Part 234 Instructions

PART 234 – ASQP

On-Time Data

OMB NO: 2138-0041
EXPIRATION DATE: 3/31/2016

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, mishandled baggage, is estimated to be approximately 20 hours per response, 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

Field Description	Data Type	Length	Comments	Sample Data
Carrier code	Character	2	IATA code	XX
Flight number	Character	4		1234
Origin airport code	Character	3	Airport code	DFW
Destination airport code	Character	3	Airport code	BNA
Date of flight operation	DATE	ccyymmdd	Year (CCYY)	20100301
Day of the week of flight operation	Numeric	1	Mon = 1, Sun = 7	1
Scheduled departure time as shown in Official Airline Guide (OAG)	Numeric	4	24 hour clock	0735
Scheduled departure time as shown in CRS	Numeric	4	24 hour clock	0735
Gate departure time (actual)	Numeric	4	24 hour clock	0737
Scheduled arrival time	Numeric	4	24 hour clock	0915
Scheduled arrival time per CRS	Numeric	4	24 hour clock	0915
Gate arrival time (actual)	Numeric	4	24 hour clock	1148
Difference between OAG and CRS scheduled departure times	Numeric	4	In minutes – G minus H (2 hours=120 min)	0
Difference between OAG and CRS scheduled arrival times	Numeric	4	In minutes – J minus K	0
Scheduled elapsed time	Numeric	4	In minutes – K minus H	100
Gate-to-Gate Time	Numeric	4	In minutes – L minus I	251
Departure delay time (actual minutes CRS)	Numeric	4	In minutes – I minus H	2
Arrival delay time (actual minutes CRS)	Numeric	4	In minutes – L minus K	153
Elapsed time difference (actual minutes CRS)	Numeric	4	In minutes – P minus O	151
Wheels-off time (actual)	Numeric	4	24 hour clock	0753
Wheels-on time (actual)	Numeric	4	24 hour clock	1141
Aircraft tail number	Character	6		N123XX
Cancellation code	Character	1	Values are A, B, C, D
Minutes late for Delay Code E – Carrier Caused	Numeric	4	In minutes
Minutes late for Delay Code F – Weather	Numeric	4	In minutes
Minutes late for Delay Code G – National Aviation System (NAS)	Numeric	4	In minutes
Minutes late for Delay Code H – Security	Numeric	4	In minutes
Minutes late for Delay Code I – Late Arriving Flight (Initial)	Numeric	4	In minutes
First gate departure time (actual)	Numeric	4	24 hour clock
Total ground time away from gate	Numeric	4	In minutes
Longest ground time away from gate	Numeric	4	In minutes
Number of landings at diverted airports	Numeric	1	1 to 5 for diversions, 9 designates a fly return canceled flight	1
Diverted airport code 1	Character	3	Airport code	MEM
Wheels-on time at diverted airport	Numeric	4	24 hour clock	1005
Total ground time away from gate at diverted airport	Numeric	4	In minutes	69
Longest ground time away from gate at diverted airport	Numeric	4	In minutes	69
Wheels-off time (actual) at diverted airport	Numeric	4	24 hour clock	1114
Aircraft tail number	Character	6		N234XX
Diverted airport code 2	Character	3	Airport code
Wheels-on time at diverted airport	Numeric	4	24 hour clock
Total ground time away from gate at diverted airport	Numeric	4	In minutes
Longest ground time away from gate at diverted airport	Numeric	4	In minutes
Wheels-off time (actual) at diverted airport	Numeric	4	24 hour clock
Aircraft tail number	Character	6
Diverted airport code 3	Character	3	Airport code
Wheels-on Time at Diverted Airport	Numeric	4	24 hour clock
Total ground time away from gate at diverted airport	Numeric	4	In minutes
Longest ground time away from gate at diverted airport	Numeric	4	In minutes
Wheels-off time (actual) at diverted airport	Numeric	4	24 hour clock
Aircraft tail number	Character	6
Diverted airport code 4	Character	3	Airport code
Wheels-on time at diverted airport	Numeric	4	24 hour clock
Total ground time away from gate at diverted airport	Numeric	4	In minutes
Longest ground time away from gate at diverted airport	Numeric	4	In minutes
Wheels-off time (actual) at diverted airport	Numeric	4	24 hour clock
Aircraft tail number	Character	6
Diverted airport code 5	Character	3	Airport code
Wheels-on time at diverted airport	Numeric	4	24 hour clock
Total ground time away from gate at diverted airport	Numeric	4	In minutes
Longest ground time away from gate at diverted airport	Numeric	4	In minutes
Wheels-off time (actual) at diverted airport	Numeric	4	24 hour clock
Aircraft tail number	Character	6

RECORD FORMAT:

The ASQP - On Time Data reports must be created as an electronic “comma separated values” file, using ASCII text 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 sample 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:

XX,1234,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,,,,,,,,,,,,,,,,,,,,,,,,,

PART 234 – ASQP – Mishandled Baggage Report

OMB NO: 2138-0041
EXPIRATION DATE: 3/31/2016

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, mishandled baggage, is estimated to be approximately 20 hours per response, 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 – Mishandled Baggage Report

Field Description	Data Type	Length	Comments	Sample Data
Carrier code	Character	2	Two letter IATA code	XX
Year of Data	Numeric	4	Year (CCYY)	2010
Month of Data	Numeric	2	Month (MM)	03
Number of Domestic Scheduled Passengers Enplaned	Numeric	Varies		8004000
Number of Mishandled Baggage Reports Filed with Carrier	Numeric	Varies		35000

RECORD FORMAT:

The ASQP – Mishandled Baggage reports must be created as an electronic “comma separated values” file, using ASCII text 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 sample 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-234mbr.csv

Sample Record Format:

XX,2010,03,8004000,35000

4