Microsoft Word - OMB 2138-0041 Part 234 On-time Instructions

Status: Original and derived artifacts are available for this document.

Download: pdf

Part 234 – ASQP
On-Time Data
OMB NO: 2138-0041
EXPIRATION DATE:
Paperwork Reduction Act Burden Statement
A federal agency may not conduct or sponsor, and a person is not required to respond
to, nor shall a person be subject to a penalty for failure to comply with a collection of
information subject to the requirements of the Paperwork Reduction Act unless that
collection of information displays a current valid OMB Control Number. The OMB
Control Number for this information collection is 2138-0041. Public reporting for on-time
performance is estimated to be approximately 42 hours per response each (plus 42
hours for any codeshare reporting), including the time for reviewing instructions,
completing and reviewing the collection of information. All responses to this collection of
information are mandatory, as authorized by 14 CFR, Part 234. Send comments
regarding this burden estimate or any other aspect of this collection of information,
including suggestions for reducing this burden to: Information Collection Clearance
Officer, OAI/BTS/OST-R, RTS-42, 1200 New Jersey Avenue, SE, Washington, D.C.
20590.
REQUIREMENTS
RECORD DESCRIPTION: ASQP MONTHLY ON-TIME DATA
Form 1: On-Time Performance Data for Non-Codeshare and Codeshare Flights1
Field
A
B
C
D
E
F
G
H
I
J
K
L
M
N

1

Description

Type
Character
Character

Departure airport code
Arrival airport code
Date of flight operation
Day of the week of flight operation
Scheduled departure time as shown in
Official Airline Guide (OAG)
Scheduled departure time as shown in
CRS (selected by the Carrier)
Gate departure time (actual)
Scheduled arrival time per OAG
Scheduled arrival time per CRS
Gate arrival time (actual)
Difference between OAG and CRS
scheduled departure times
Difference between OAG and CRS
scheduled arrival times

Carrier code
Flight number

Comments
Two letter IATA code
—

Character
Character
Num
Num
Num

Length
2
Max length of
4
3
3
8
1
4

Num

4

Local time 24 - hour clock

Num
Num
Num
Num
Num

4
4
4
4
Max length of
4
Max length of
4

Local time 24 - hour clock
Local time 24 - hour clock
Local time 24 - hour clock
Local time 24 - hour clock
In minutes (2 hours =
120 min) G minus H
In minutes – J minus K

Num

Three letter Airport code
Three letter Airport code
Format ccyymmdd
Mon = 1, Sun = 7
Local time 24 - hour clock

A reporting carrier must use this form to report on-time performance data if the flight was not a codeshare flight
with another U.S. carrier. A reporting carrier must also use this form to report on-time performance data if the
reporting carrier operated, but did not market, a codeshare flight.

Field
O

Description
Scheduled elapsed time per CRS

Type
Num

P

Actual gate-to-gate time

Num

Q

Departure delay time (actual minutes
CRS)
Arrival delay time (actual minutes CRS)

Num

Elapsed time difference (actual minutes
CRS)
Wheels-off time (actual)
Wheels-on time (actual)
Aircraft tail number
Cancellation code
Minutes late for Delay Code F – Air
Carrier
Minutes late for Delay Code G –
Weather
Minutes late for Delay Code H – National
Aviation System (NAS)
Minutes late for Delay Code I – Security

Num

Num

AD
AE

Minutes late for Delay Code J – Late
Arriving Flight (Initial)
Minutes late for Delay Code K –
Section 511(b)
First gate departure time (actual)
Total ground time away from gate

AF

Longest ground time away from gate

Num

AG

Number of landings at diverted airports

Num

AH
AI
AJ

Diverted airport code 1
Wheels-on time at diverted airport
Total ground time away from gate at
diverted airport
Longest ground time away from gate at
diverted airport
Wheels-off time (actual) at diverted
airport
Aircraft tail number
Diverted airport code 2
Wheels-on time at diverted airport
Total ground time away from gate at
diverted airport
Longest ground time away from gate at
diverted airport
Wheels-off time (actual) at diverted
airport
Aircraft tail number
Diverted airport code 3
Wheels-on time at diverted airport
Total ground time away from gate at
diverted airport
Longest ground time away from gate at
diverted airport

Character
Num
Num

R
S
T
U
V
W
X
Y
Z
AA
AB
AC

AK
AL
AM
AN
AO
AP
AQ
AR
AS
AT
AU
AV
AW

Num

Num
Num
Character
Character
Num
Num
Num
Num

Num
Num
Num

Num
Num
Character
Character
Num
Num
Num
Num
Character
Character
Num
Num
Num

Length
Max length of
4
Max length of
4
Max length of
4
Max length of
4
Max length of
4
4
4
6
1
Max length of
4
Max length of
4
Max length of
4
Max length of
4
Max length of
4
Max length of
4
4
Max length of
4
Max length of
4
1
3
4
Max length of
4
Max length of
4
4

Comments
In minutes – K minus H
In minutes – L minus I
In minutes – I minus H
In minutes – L minus K
In minutes – P minus O
Local time 24 - hour clock
Local time 24 - hour clock
—
Values are A, B, C, D, E
In minutes
In minutes
In minutes
In minutes
In minutes
In minutes
Local time 24 - hour clock
In minutes
In minutes
1 to 5 for diversions, 9
designates a fly return
canceled flight
Three letter Airport code
Local time 24 - hour clock
In minutes
In minutes
Local time 24 - hour clock

6
3
4
Max length of
4
Max length of
4
4

—
Three letter Airport code
Local time 24 - hour clock
In minutes

6
3
4
Max length of
4
Max length of
4

—
Three letter Airport code
Local time 24 - hour clock
In minutes

In minutes
Local time 24 - hour clock

In minutes

Field
AX

Description
Wheels-off time (actual) at diverted
airport
AY
Aircraft tail number
AZ
Diverted airport code 4
BA
Wheels-on time at diverted airport
BB
Total ground time away from gate at
diverted airport
BC
Longest ground time away from gate at
diverted airport
BD
Wheels-off time (actual) at diverted
airport
BE
Aircraft tail number
BF
Diverted airport code 5
BG
Wheels-on time at diverted airport
BH
Total ground time away from gate at
diverted airport
BI
Longest ground time away from gate at
diverted airport
BJ
Wheels-off time (actual) at diverted
airport
BK
Aircraft tail number
— Not applicable.

Type
Num
Character
Character
Num
Num
Num
Num
Character
Character
Num
Num

Length

Comments
Local time 24 - hour clock

6
3
4
Max length of
4
Max length of
4
4

—
Three letter Airport code
Local time 24 - hour clock
In minutes

4

Num

6
3
4
Max length of
4
Max length of
4
4

Character

6

Num

In minutes
Local time 24 - hour clock
Three letter Airport code
Local time 24 - hour clock
In minutes
In minutes
Local time 24 - hour clock
—

Form 2A: On-Time Performance Data for Codeshare Flights (Long)2
Field
A1
B1

Description
Marketing Carrier code
Marketing Carrier Flight number

Type
Character
Character

A2
B2

Operating Carrier Code
Operating Carrier Flight Number

Character
Character

C
D
E
F
G

O

Departure airport code
Arrival airport code
Date of flight operation
Day of the week of flight operation
Scheduled departure time as shown in
Official Airline Guide (OAG)
Scheduled departure time as shown in
CRS (selected by the Carrier)
Gate departure time (actual)
Scheduled arrival time per OAG
Scheduled arrival time per CRS
Gate arrival time (actual)
Difference between OAG and CRS
scheduled departure times
Difference between OAG and CRS
scheduled arrival times
Scheduled elapsed time per CRS

P

Actual gate-to-gate time

Num

H
I
J
K
L
M
N

2

Comments
Two letter IATA code
—

Character
Character
Num
Num
Num

Length
2
Max length of
4
2
Max length of
4
3
3
8
1
4

Num

4

Local time 24 - hour clock

Num
Num
Num
Num
Num

4
4
4
4
Max length of
4
Max length of
4
Max length of
4
Max length of
4

Local time 24 - hour clock
Local time 24 - hour clock
Local time 24 - hour clock
Local time 24 - hour clock
In minutes (2 hours=120
min) G minus H
In minutes – J minus K

Num
Num

Two letter IATA code
—
Three letter Airport code
Three letter Airport code
Format ccyymmdd
Mon = 1, Sun = 7
Local time 24 - hour clock

In minutes – K minus H
In minutes – L minus I

A reporting carrier must use this form to report on-time performance data if: (1) the flight was a codeshare flight
held out to the public with only one U.S. carrier designator code (that a flight is also held out under any number
of foreign carrier designator codes is irrelevant to determining whether to report); (2) the reporting carrier
marketed, but did not operate, the codeshare flight; (3) there was no flight substitution; and (4) the operating
carrier of the flight is not a reporting carrier.

Field
Q

Type
Num

AD
AE

Description
Departure delay time (actual minutes
CRS)
Arrival delay time (actual minutes
CRS)
Elapsed time difference (actual minutes
CRS)
Wheels-off time (actual)
Wheels-on time (actual)
Aircraft tail number
Cancellation code
Minutes late for Delay Code F – Air
Carrier
Minutes late for Delay Code G –
Weather
Minutes late for Delay Code H –
National Aviation System (NAS)
Minutes late for Delay Code I –
Security
Minutes late for Delay Code J – Late
Arriving Flight (Initial)
Minutes late for Delay Code K –
Section 511 (b)
First gate departure time (actual)
Total ground time away from gate

AF

Longest ground time away from gate

Num

AG

Number of landings at diverted
airports

Num

Length
Max length of
4
Max length of
4
Max length of
4
4
4
6
1
Max length of
4
Max length of
4
Max length of
4
Max length of
4
Max length of
4
Max length of
4
4
Max length of
4
Max length of
4
1

AH
AI
AJ

Diverted airport code 1
Wheels-on time at diverted airport
Total ground time away from gate at
diverted airport
Longest ground time away from gate at
diverted airport
Wheels-off time (actual) at diverted
airport
Aircraft tail number
Diverted airport code 2
Wheels-on time at diverted airport
Total ground time away from gate at
diverted airport
Longest ground time away from gate at
diverted airport
Wheels-off time (actual) at diverted
airport
Aircraft tail number
Diverted airport code 3
Wheels-on time at diverted airport
Total ground time away from gate at
diverted airport
Longest ground time away from gate at
diverted airport
Wheels-off time (actual) at diverted
airport
Aircraft tail number
Diverted airport code 4
Wheels-on time at diverted airport

Character
Num
Num

3
4
Max length of 4

1 to 5 for diversions, 9
designates a fly return
canceled flight
Three letter Airport code
Local time 24 - hour clock
In minutes

Num

Max length of 4

In minutes

Num

4

Local time 24 - hour clock

Character
Character
Num
Num

6
3
4
Max length of 4

—
Three letter Airport code
Local time 24 - hour clock
In minutes

Num

Max length of 4

In minutes

Num

4

Local time 24 - hour clock

Character
Character
Num
Num

6
3
4
Max length of 4

—
Three letter Airport code
Local time 24 - hour clock
In minutes

Num

Max length of 4

In minutes

Num

4

Local time 24 - hour clock

Character
Character
Num

6
3
4

—
Three letter Airport code
Local time 24 - hour clock

R
S
T
U
V
W
X
Y
Z
AA
AB
AC

AK
AL
AM
AN
AO
AP
AQ
AR
AS
AT
AU
AV
AW
AX
AY
AZ
BA

Num
Num
Num
Num
Character
Character
Num
Num
Num
Num
Num
Num
Num
Num

Comments
In minutes – I minus H
In minutes – L minus K
In minutes – P minus O
Local time 24 - hour clock
Local time 24 - hour clock
—
Values are A, B, C, D, E
In minutes
In minutes
In minutes
In minutes
In minutes
In minutes
Local time 24 - hour clock
In minutes
In minutes

Field
BB

Description
Total ground time away from gate at
diverted airport
BC
Longest ground time away from gate at
diverted airport
BD
Wheels-off time (actual) at diverted
airport
BE
Aircraft tail number
BF
Diverted airport code 5
BG
Wheels-on time at diverted airport
BH
Total ground time away from gate at
diverted airport
BI
Longest ground time away from gate at
diverted airport
BJ
Wheels-off time (actual) at diverted
airport
BK
Aircraft tail number
— Not applicable.

Type
Num

Length
Max length of 4

Comments
In minutes

Num

Max length of 4

In minutes

Num

4

Local time 24 - hour clock

Character
Character
Num
Num

6
3
4
Max length of 4

—
Three letter Airport code
Local time 24 - hour clock
In minutes

Num

Max length of 4

In minutes

Num

4

Local time 24 - hour clock

Character

6

—

Form 2B: On-Time Performance Data for Codeshare Flights (Short)3
Field
A1
B1

Description
Marketing Carrier code
Marketing Carrier Flight number

Type
Character
Character

A2
B2

Operating Carrier code
Operating Carrier Flight number

Character
Character

C
D
E
F
G

Departure airport code
Arrival airport code
Date of flight operation
Day of the week of flight operation
Scheduled departure time as shown in
Official Airline Guide (OAG)
J
Scheduled arrival time per OAG
V
Aircraft tail number
— Not applicable.

3

Comments
Two letter IATA code
—

Character
Character
Num
Num
Num

Length
2
Max length of
4
2
Max length of
4
3
3
8
1
4

Num
Character

4
6

Local time 24 - hour clock
—

Two letter IATA code
—
Three letter Airport code
Three letter Airport code
Format ccyymmdd
Mon = 1, Sun = 7
Local time 24 - hour clock

A reporting carrier must use this form to report on-time performance data if: (1) the flight was a codeshare flight
held out to the public with only one U.S. carrier designator code (that a flight is also held out under any number
of foreign carrier designator codes is irrelevant to determining whether to report); (2) the reporting carrier
marketed, but did not operate, the codeshare flight; (3) there was no flight substitution; and (4) the operating
carrier of the flight is also a reporting carrier.

Form 3A: On-Time Performance Data for Codeshare Flights (Long)4
(For Use Only by Marketing Carrier Following June 2017 OACP Enforcement Policy When
There is a Swap)
Field
A1
B1

Description
Marketing Carrier code
Marketing Carrier Flight number

Type
Character
Character

A2
B2

Scheduled Operating Carrier Code
Scheduled Operating Carrier Flight
Number
Actual Operating Carrier Code
Actual Operating Carrier Flight Number

Character
Character

Departure airport code
Arrival airport code
Date of flight operation
Day of the week of flight operation
Scheduled departure time as shown in
Official Airline Guide (OAG)
Scheduled departure time as shown in
CRS
(selected by the Carrier)
Gate departure time (actual)
Scheduled arrival time per OAG
Scheduled arrival time per CRS
Gate arrival time (actual)
Difference between OAG and CRS
scheduled departure times
Difference between OAG and CRS
scheduled arrival times
Scheduled elapsed time per CRS

A3
B3
C
D
E
F
G5
H
I
J
K
L
M
N
O

Comments
Two letter IATA code
—

Character
Character
Num
Num
Num

Length
2
Max length of
4
2
Max length of
4
2
Max length of
4
3
3
8
1
4

Num

4

Local time 24 - hour clock

Num
Num
Num
Num
Num

4
4
4
4
Max length of
4

Num

Max length of
4
Max length of
4

Local time 24 - hour clock
Local time 24 - hour clock
Local time 24 - hour clock
Local time 24 - hour clock
In minutes (2 hours=120
min)
G minus H
In minutes – J minus K

Character
Character

Num

Two letter IATA code
—
Two letter IATA code
—
Three letter Airport code
Three letter Airport code
Format ccyymmdd
Mon = 1, Sun = 7
Local time 24 - hour clock

In minutes – K minus H

4

A reporting carrier must use this form to report on-time performance data if: (1) the originally scheduled flight was
a codeshare flight held out to the public with only one U.S. carrier designator code (that a flight is also held out
under any number of foreign carrier designator codes is irrelevant to determining whether to report); (2) there
was a flight substitution (Codeshare Swap); (3) the reporting carrier marketed the originally scheduled codeshare
flight but did not operate the originally scheduled codeshare flight or the substitute codeshare flight; and (4) the
substitute flight was an extra section flight or the carrier that operated the flight is not a reporting carrier.

5

For the purposes of fields G, H, J, and K, a carrier must provide information as it relates to the originally scheduled
flight that was not operated and subject to the Codeshare Swap and must apply that information in calculating the
other fields that are based on the information in fields G, H, J, and K (i.e. M, N, O, Q, R, S). All other fields and
references to them relate to the substitute flight that was actually operated.

Field
P

Description
Actual gate-to-gate time

Type
Num

Q

Departure delay time (actual minutes)

Num

R

Arrival delay time (actual minutes)

Num

S

Elapsed time difference (actual minutes)

Num

T
U
V
W

Wheels-off time (actual)
Wheels-on time (actual)
Aircraft tail number
Cancellation code

Num
Num
Character
Character

X

Minutes late for Delay Code F – Air
Carrier
Minutes late for Delay Code G –
Weather
Minutes late for Delay Code H – National
Aviation System (NAS)
Minutes late for Delay Code I – Security

Num

Num

AD
AE

Minutes late for Delay Code J – Late
Arriving Flight (Initial)
Minutes late for Delay Code K –
Section 511 (b)
First gate departure time (actual)
Total ground time away from gate

AF

Longest ground time away from gate

Num

AG

Number of landings at diverted airports

Num

AH
AI
AJ

Diverted airport code 1
Wheels-on time at diverted airport
Total ground time away from gate at
diverted airport
Longest ground time away from gate at
diverted airport
Wheels-off time (actual) at diverted airport
Aircraft tail number
Diverted airport code 2
Wheels-on time at diverted airport
Total ground time away from gate at
diverted airport
Longest ground time away from gate at
diverted airport
Wheels-off time (actual) at diverted airport
Aircraft tail number
Diverted airport code 3
Wheels-on time at diverted airport
Total ground time away from gate at
diverted airport
Longest ground time away from gate at
diverted airport
Wheels-off time (actual) at diverted airport
Aircraft tail number
Diverted airport code 4
Wheels-on time at diverted airport

Character
Num
Num

Y
Z
AA
AB
AC

AK
AL
AM
AN
AO
AP
AQ
AR
AS
AT
AU
AV
AW
AX
AY
AZ
BA

Num
Num
Num

Num
Num
Num

Num
Num
Character
Character
Num
Num
Num
Num
Character
Character
Num
Num
Num
Num
Character
Character
Num

Length
Max length of
4
Max length of
4
Max length of
4
Max length of
4
4
4
6
1
Max length of
4
Max length of
4
Max length of
4
Max length of
4
Max length of
4
Max length of
4
4
Max length of
4
Max length of
4
1
3
4
Max length of
4
Max length of
4
4
6
3
4
Max length of
4
Max length of
4
4
6
3
4
Max length of
4
Max length of
4
4
6
3
4

Comments
In minutes – L minus I
In minutes – I minus H
In minutes – L minus K
In minutes – P minus O
Local time 24 - hour clock
Local time 24 - hour clock
—
Values are A, B, C, D, and
E
In minutes
In minutes
In minutes
In minutes
In minutes
In minutes
Local time 24 - hour clock
In minutes
In minutes
1 to 5 for diversions, 9
designates a fly return
canceled flight
Three letter Airport code
Local time 24 - hour clock
In minutes
In minutes
Local time 24 - hour clock
—
Three letter Airport code
Local time 24 - hour clock
In minutes
In minutes
Local time 24 - hour clock
—
Three letter Airport code
Local time 24 - hour clock
In minutes
In minutes
Local time 24 - hour clock
—
Three letter Airport code
Local time 24 - hour clock

Field
BB

Description
Total ground time away from gate at
diverted airport
BC
Longest ground time away from gate at
diverted airport
BD
Wheels-off time (actual) at diverted airport
BE
Aircraft tail number
BF
Diverted airport code 5
BG
Wheels-on time at diverted airport
BH
Total ground time away from gate at
diverted airport
BI
Longest ground time away from gate at
diverted airport
BJ
Wheels-off time (actual) at diverted airport
BK
Aircraft tail number
— Not applicable.

Type
Num

Length
Max length of
4
Max length of
4
4
6
3
4
Max length of
4
Max length of
4
4
6

Num
Num
Character
Character
Num
Num
Num
Num
Character

Comments
In minutes
In minutes
Local time 24 - hour clock
—
Three letter Airport code
Local time 24 - hour clock
In minutes
In minutes
Local time 24 - hour clock
—

Form 3B: On-Time Performance Data for Codeshare Flights (Short)6
(Note: For use only by marketing carrier following July 2017 OACP enforcement policy when
there is a swap.)
Field
A1
B1

Description
Marketing Carrier code
Marketing Carrier Flight number

Type
Character
Character

A2
B2

Scheduled Operating Carrier code
Scheduled Operating Carrier Flight
number
Actual Operating Carrier code
Actual Operating Carrier Flight number

Character
Character

Departure airport code
Arrival airport code
Date of flight operation
Day of the week of flight operation
Scheduled departure time as shown in
Official Airline Guide (OAG)
J
Scheduled arrival time per OAG
V
Aircraft tail number
— Not applicable.

A3
B3
C
D
E
F
G7

Comments
Two letter IATA code
—

Character
Character
Num
Num
Num

Length
2
Max length of
4
2
Max length of
4
2
Max length of
4
3
3
8
1
4

Num
Character

4
6

Local time 24 - hour clock
—

Character
Character

Two letter IATA code
—
Two letter IATA code
—
Three letter Airport code
Three letter Airport code
Format ccyymmdd
Mon = 1, Sun = 7
Local time 24 - hour clock

6

A reporting carrier must use this form to report on-time performance data if: (1) the originally scheduled flight was
a codeshare flight held out to the public with only one U.S. carrier designator code (that a flight is also held out
under any number of foreign carrier designator codes is irrelevant to determining whether to report); (2) there
was a flight substitution (Codeshare Swap); (3) the reporting carrier marketed the originally scheduled codeshare
flight but did not operate the originally scheduled codeshare flight or the substitute codeshare flight; (4) the
substitute flight was not an extra section flight; and (5) the substitute flight was operated by a reporting carrier.

7

For fields G and J, a carrier must provide information as it relates to the originally scheduled flight that was not
operated and subject to the Codeshare Swap. All other fields relate to the substitute flight that was actually
operated.

Cancellation codes follow:
A
B
C
D
E

Air Carrier
Weather
National Aviation System
Security
Section 511(b)

Delay codes follow:
F
G
H
I
J
K

Air Carrier
Weather
National Aviation System
Security
Late Arriving Aircraft
Section 511(b)

RECORD FORMAT:
The ASQP – On Time Data reports must be created as an electronic “comma separate values”
file, using ASCII character encoding, for uploading via the “eSubmit” application.
The comma separated values file MUST BE indicated when naming the file, by using the letters
[CSV] or [csv] following the file name, as the file name extension.
The file name is flexible and may be determined by the individual air carrier, but the comma
separated values (csv) file format is required, as outlined in the rule entitled, Submitting Airline
Data via the Internet.
The fields in the same record shown below follow the same order as the above record
description, separated by commas, and saved with the file name extension of .csv.
Suggested file name: XX201003-234ontime.csv
Sample Record Format (Form 3A):
XX,1234,YY,567,ZZ,921,DFW,BNA,20100301,1,0735,0735,0737,0915,0915,1148,0,0,100
,251,2,153,151,0753,1141,N123XX,,,,,,,,,,,1,MEM,1005,69,69,1114,N234XX,,,,,,,,,,,,,,,,,,,,,,
,,