General

You are here

Number 307 - E-filing Revised Instructions

PDF

Department of Transportation
Research and Innovative Technology Administration
Bureau of Transportation Statistics
Office of Airline Information
Accounting and Reporting Directive

No. 307
Issue Date: 8-23-2012
Effective Date: 1-1-2013

This Directive rescinds Accounting and Reporting Directive No. 293, E-filing, and revises and reissues the reporting guidance contained in Directive No. 293.

BACKGROUND:

On July 16, 2010, the Department of Transportation (DOT) issued a final rule revising Part 241 of its Economic Regulations.  This action required air carriers to report their economic and statistical data to the Department via a secured web portal using a comma separated value (CSV) of the already required data or a PDF file.

On June 23, 2010, the DOT Research and Innovative Technology Administration, Office of Airline Information issued Accounting and Reporting Directive No. 293 effective October 1, 2010.  The Directive provided guidance on reporting air carrier recurrent economic and statistical data via a secured web portal using a comma separated value (CSV) and provided file formats for the required data to be reported.

CHANGES TO DIRECTIVE NO. 293

This Directive revises the section pertaining to the B-7 Airframe and Aircraft Engine Acquisitions and Retirements and the B-43 Inventory of Airframes and Aircraft Engines only, and affects no other part of Accounting Directive No. 293.

This Directive changes the file format or record description as defined in Directive No. 293 as follows:

For the B-7, instead of reporting the Air Carrier Name in field 2, air carriers will report their 2 or 3 letter carrier code as reported on their other recurrent economic and statistical data.  A new column/field is to be inserted after the "Number of Aircraft Engines Acquired/Retired" column/field, and before the "Type Model and Cabin Design" column/field.  The new column/field is entitled "Aircraft Type Code", is numeric and 4 digits in length.  It will correspond to the aircraft type codes as reported on Schedule P-5.1 or Schedule P-5.2 (P051 or P052) data.

For the B-43, instead of reporting the Air Carrier Name in field 2, air carriers will report their 2 or 3 letter carrier code as reported on their other recurrent economic and statistical data.  A new column/field is to be inserted after the "Manufacturer" column/field, and before the "Type Model and Cabin Design" column/field.  The new column/field is entitled "Aircraft Type Code", is numeric and 4 digits in length.  It will correspond to the aircraft type codes as reported on Schedule P-5.1 or Schedule P-5.2 (P051 or P052) data.  The "Report Date" column/field is changed to reflect "Year", is numeric and 4 digits in length.  A new column/field is to be inserted after the "Year" column/field and is entitled "Month Ended", is numeric and 2 digits in length.  This provides uniformity with the B-7 "Year" and "Month Ended" column/fields.

For your reference, the entire Reporting Directive is reissued below, with the required changes, reflected on pages 33 thru 36.

If there are any questions on the revised reporting, please contact Mr. Jeff Gorham at (202) 366-4406 or at email jeff.gorham@dot.gov(link sends e-mail)

William Chadwick Jr.
Director
Office of Airline Information
Bureau of Transportation Statistics

E-FILING

This Accounting and Reporting Directive gives detailed instructions for the file format for submitting recurrent reports via a secured web portal using a comma separated vales (CSV) of the already required data or a PDF file.  CSV is a delimited(link is external) data format that has fields/columns(link is external) separated by the comma(link is external) character(link is external)and records/rows(link is external) separated by new lines(link is external)

PART 241 – Form T100

Traffic and Capacity Statistics Segment Report

OMB NO: 2138-0040
EXPIRATION DATE: 10/31/2014

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-0040.  Public reporting for Schedule T-100, Report of Traffic and Capacity, is estimated to be approximately 6 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 241. 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, Jennifer Rodes, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jennifer.rodes@dot.gov(link sends e-mail).

REQUIREMENTS

RECORD DESCRIPTION:  T100 – Traffic and Capacity Statistics for Segment Report

Field DescriptionData TypeLengthCommentsSample Data
Data TypeCharacter1One letter code (S)S
Entity codeCharacter5Five character code assigned by DOT0A050
Year of DataNumeric4Year (CCYY)2010
Month of DataNumeric2Month (MM)03
Origin AirportCharacter3Three letter OAG airport codeBWI
Destination AirportCharacter3Three letter OAG airport codeLAS
Service ClassCharacter1One letter service class code: F, G, L, N, P, R, HF
Segment Aircraft TypeNumeric3DOT assigned three  numeric aircraft type code698
Segment Cabin ConfigurationNumeric1One numeric aircraft cabin configuration code: 1,2,3,41
Segment Departures PerformedNumeric5Up to five numeric departures performed25
Segment Available CapacityNumeric10Up to ten numeric, reported in pounds125000000
Segment Available SeatsNumeric7Up to seven numeric, aircraft seating capacity1250
Segment Passengers TransportedNumeric7Up to seven numeric, reported transported passengers922
Segment Freight TransportedNumeric10Up to ten numeric, freight reported in pounds25338
Segment Mail TransportedNumeric10Up to ten numeric, mail reported in pounds989
Segment Scheduled DeparturesNumeric5Up to five numeric scheduled departures23
Segment Ramp to Ramp MinutesNumeric10Up to ten numeric, reported in minutes789
Segment Airborne MinutesNumeric10Up to ten numeric, reported in minutes685

RECORD FORMAT:

The T100 – Traffic and Capacity Statistics for Segment 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-T100SEG.csv

Sample Record Format:

S,0A050,2010,03,BWI,LAS,F,698,1,25,12500000,1250,922,25338,989,23,789,685

PART 217 – T100(f) Certification

REQUIREMENTS

RECORD DESCRIPTION/INSTRUCTIONS: T100(f) Certification

A certification statement is required identifying an appropriate official of the reporting carrier.  The certification statement will read:

Carrier Name:

Address:

Homeland:

(Homeland is the name of the country under the laws of which air carrier organized.)

Carrier Code:

Report Date (Year/Month):

I, the undersigned, do certify that this report has been prepared under my direction in accordance with the regulations in 14CFR Part 217.  I affirm that, to the best of my knowledge and belief, this is a true, correct and complete report.

Date:

Signature:

Name (Please Print or Type):

Title:

Telephone Number:

Name of Person Who Prepared Report:

Telephone Number:

E-mail Address:

RECORD FORMAT:

Once signed, the T100(f) Certification must be published as an electronic "portable document format" file format, for uploading to the eSubmit application. 

The portable document format file MUST BE indicated when naming the file, by using the letters [PDF] or [pdf] following the file name, as the file name extension.  You must have Adobe Reader software downloaded on your computer in order to "save as/print" your document as a 'pdf' file. 

While the file name is flexible and may be determined by the individual air carrier, the portable document format (pdf) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet

Suggested file name: XXX201003-217T100fCert.pdf

PART 217 – T100 (f) Foreign Air Carrier Traffic Data

OMB NO: 2138-0040
EXPIRATION DATE: 10/31/2014

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-0040.  Public reporting for Schedule T-100(f) Report of Traffic and Capacity, is estimated to be approximately 2 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 217. 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, Jennifer Rodes, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jennifer.rodes@dot.gov(link sends e-mail).

REQUIREMENTS

RECORD DESCRIPTION:  T100 (f) Foreign Air Carrier Traffic Data

Field DescriptionData TypeLengthCommentsSample Data
Carrier CodeCharacter32 or 3 digit Carrier CodeBA
Year and Month of DataNumeric6Format: YYYYMM  YYYY = century and year; Format: MM: 01 = January … 12 = December200612
Origin AirportCharacter3The three letter OAG code identifying the airport. IAH
Destination AirportCharacter3The three letter OAG code identifying the airport. LGW
Service ClassCharacter1One letter service class code: F, G, L, N, P, R, HF
Segment Aircraft Type and Cabin ConfigurationNumber4The 1st 3 characters identify the type of aircraft used on the non-stop segment. The 4th character is used to identify the type of cabin configuration:          1 - Passenger    2 – Cargo  3 – Passenger/Cargo6271
Segment Departures PerformedNumberUp to 5Up to five numeric Revenue departures performed49
Segment PassengersNumberUp to 10Up to seven numeric, reported transported passengers6707
Segment FreightNumberUp to 10Up to ten numeric, freight reported in kilos521842
Segment Available SeatsNumberUp to 7Up to seven numeric, aircraft seating capacity10976
Segment Available CapacityNumberUp to 10Up to ten numeric, reported in kilos1903195
Market PassengersNumberUp to 10Up to seven numbers Enplaned passengers6707
Market FreightNumberUp to 10Up to ten numbers, reported in kilos521842

RECORD FORMAT:

The T100(f) Foreign Air Carrier Traffic 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: XXX201003-T100F.csv

Sample Record Format:

BA,200612,IAH,DTW,F,6261,30,1647,17137,5670,772500,0,0

BA,200612,IAH,LGW,F,6271,49,6707,521842,10976,1903195,6707,521842

BA,200612,IAH,LHR,F,0,0,0,0,0,0,1643,12935

PART 241 – T100 – Alaskan Air Carrier Weekly Traffic and Capacity Data Report

REQUIREMENTS

RECORD DESCRIPTION:  T100 – Alaskan Air Carrier Weekly Segment and Market Report

Field DescriptionData TypeLengthCommentsSample Data
Data TypeCharacter1One letter code (S)S
Entity codeCharacter5Five character code assigned by DOT06000
Year of DataNumeric4Year (CCYY)2010
Month of DataNumeric2Month (MM)05
Day of ServiceNumeric2Day of month the service was performed – for use by USPS Only27
Origin AirportCharacter3Three letter OAG airport codeFAI
Destination AirportCharacter3Three letter OAG airport codeGAL
Service ClassCharacter1One letter service class code: F, G, L, N, P, RF
Segment Aircraft TypeNumeric3DOT assigned three  numeric aircraft type code405
Segment Cabin ConfigurationNumeric1One numeric aircraft cabin configuration code: 1,2,3,43
Segment Departures PerformedNumeric5Up to five numeric departures performed1
Segment Available CapacityNumeric10Up to ten numeric, reported in pounds3793
Segment Available SeatsNumeric7Up to seven numeric, aircraft seating capacity16
Segment Passengers TransportedNumeric7Up to seven numeric, reported transported passengers3
Segment Freight TransportedNumeric10Up to ten numeric, freight reported in pounds239
Segment Mail TransportedNumeric10Up to ten numeric, mail reported in pounds1106
Segment Scheduled DeparturesNumeric5scheduled departures1
Segment Ramp-to-Ramp timeNumeric10Up to ten numeric, reported in minutes72
Segment Airborne time in minutesNumeric10Up to ten numeric, reported in minutes60
DOT CertificationNumeric3Values are: 135, 121 – for use by USPS Only121

RECORD FORMAT:

The T100 – Alaskan Air Carrier Weekly Segment Report 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: XX20100528-T100AKSEG.csv

Sample Record Format:

S,06000,2010,05,27,FAI,GAL,F,405,3,1,3793,16,3,239,1106,1,72,60,121

PART 241 - T100-Alaskan Air Carrier Weekly Market Report

REQUIREMENTS

RECORD DESCRIPTION:  T100 – Alaskan Air Carrier Traffic and Capacity Data – On-Flight Market

Field DescriptionData TypeLengthCommentsSample Data
Data TypeCharacter1One letter code (M)M
Entity codeCharacter5Five character code assigned by DOT06000
Year of DataNumeric4Year (CCYY)2010
Month of DataNumeric2Month (MM)05
Day of ServiceNumeric2Day of month the service was performed – for use by USPS Only27
Origin AirportCharacter3Three letter OAG airport codeFAI
Destination AirportCharacter3Three letter OAG airport codeGAL
Service ClassCharacter1One letter service class code: F, G, L, N, P, RF
Market Passengers enplanedNumeric7Up to seven numeric, reported market passengers3
Market Freight EnplanedNumeric10Up to ten numeric, reported in pounds239
Market Mail EnplanedNumeric10Up to ten numeric, reported in pounds1000

RECORD FORMAT:

The T100 – Alaskan Air Carrier Weekly Market Report 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-T100AKMKT.csv

Sample Record Format:

M,06000,2010,05,27,FAI,GAL,F,3,239,1000

PART 241 – U.S. Carrier Origin-Destination Survey Transmittal Letter

REQUIREMENTS

RECORD DESCRIPTION/INSTRUCTIONS: Origin-Destination Survey Transmittal Letter – U.S. Carriers

Full name of airline:

Reporting period:

A certification statement for the Origin and Destination Survey Report is required identifying an appropriate official of the reporting carrier.  This statement certifies that:

I . . . . .. . . . . . . . . . .  . . . . , and . . . . . . . . . . . . . . . . . . ., of the above named carrier, certify that the

        (Name)                                            (Title)

information in this transmittal  letter is to the best of my knowledge and belief, true, correct  and a complete report for the period stated.

 Total Number of records:

 Total Number of passengers:

 Date:

 Signature:

 Name (Please Print or Type):

RECORD FORMAT:

Once signed, the Origin-Destination Survey Transmittal Letter must be published as an electronic "portable document format" file format, for uploading to the eSubmit application. 

The portable document format file MUST BE indicated when naming the file, by using the letters [PDF] or [pdf] following the file name, as the file name extension.  You must have Adobe Reader software downloaded on your computer in order to "save as/print" your document as a 'pdf' file. 

While the file name is flexible and may be determined by the individual air carrier, the portable document format (pdf) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet

File name: XX201003- ONDtransmittal.pdf

NOTE:

XX = Carrier 2 letter code

2010 = Year of report

03 = Quarter of report (First Quarter)  06 = (Second Quarter)  09 = (Third Quarter)  12 = (Fourth Quarter)

PART 241 – Foreign Carrier Origin-Destination Survey Transmittal Letter

REQUIREMENTS

RECORD DESCRIPTION/INSTRUCTIONS: Origin-Destination Survey Transmittal Letter – Foreign Carriers

Full name of airline:

Reporting period:

A certification statement for the Origin and Destination Survey Report is required identifying an appropriate official of the reporting carrier.  This statement certifies that:

I . . . . .. . . . . . . . . . .  . . . . , and . . . . . . . . . . . . . . . . . . ., of the above named carrier, certify that the

           (Name)                                        (Title)

Information in this transmittal letter is to the best of my knowledge and belief, true, correct     and a complete report for the period stated.

Total Number of records:

 Total Number of passengers:

 Date:

 Signature:

 Name (Please Print or Type):

RECORD FORMAT:

Once signed, the Origin-Destination Survey Transmittal Letter must be published as an electronic "portable document format" file format, for uploading to the eSubmit application. 

The portable document format file MUST BE indicated when naming the file, by using the letters [PDF] or [pdf] following the file name, as the file name extension.  You must have Adobe Reader software downloaded on your computer in order to "save as/print" your document as a 'pdf' file. 

While the file name is flexible and may be determined by the individual air carrier, the portable document format (pdf) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet

File name: XX201003- FONDtransmittal.pdf

NOTE:

XX = Carrier 2 letter code

2010 = Year of report

03 = Quarter of report (First Quarter), 06 = (Second Quarter), 09 = (Third Quarter), and 12 = (Fourth Quarter).

PART 241 – Passenger Origin-Destination Survey Report

OMB NO: 2139-0001
EXPIRATION DATE: 2/28/2014

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 2139-0001.  Public reporting for this collection of information is estimated to be approximately 60 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 241. 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, Marianne Seguin, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – marianne.seguin@dot.gov(link sends e-mail).

REQUIREMENTS

RECORD DESCRIPTION:  Origin-Destination Survey Report – U.S. Carriers

Field DescriptionData TypeLengthCommentsSample Data
Carrier codeCharacter2IATA codeXX
YearNumeric3Date: YYQ Where '09' = Year: 2009                          Quarter: 4094
FareNumericvariableValue of the ticket in whole U.S. dollars($)4913
Passenger CountNumericvariable 3
1st  Airport CodeCharacter31st Airport Code is the 3 letter code for the first Origin airportBOS
1st  Operating CarrierCharacter2IATA Carrier CodeIO
1st  Ticketed CarrierCharacter2IATA Carrier CodeXX
1st Fare Basis CodeCharacter1C - Unrestricted Business Class D - Restricted Business Class F - Unrestricted First Class G - Restricted First Class X - Restricted Coach Y - Unrestricted Coach U - UnknownG
2nd Airport CodeCharacter32nd Airport Code is the 3 letter code for the first destination airportLAX
2nd Operating CarrierCharacter2 VA
2nd Ticketed CarrierCharacter2 VA
2nd Fare Basis CodeCharacter1 G
3rd  Airport Code  3rd Airport Code is the 3 letter code for the second destination airportSYD
3rd Operating CarrierCharacter2Surface Segment Indicator – for Operating Carrier.--
3rd Ticketed CarrierCharacter2Surface Segment Indicator – for Ticketed Carrier--
3rd Fare Basis CodeCharacter1For surface travel segment, leave the Fare Basis Code  blank 
4th Airport CodeCharacter34thAirport Code is the 3 letter code for the third destination airportCNS
4th Operating CarrierCharacter2 DJ
4th  Ticketed CarrierCharacter2 VA
4th Fare Basis CodeCharacter1 G
5th Airport CodeCharacter35th Airport Code is the 3 letter code for the fourth destination airportBNE
5th Operating CarrierCharacter2 VA
5th  Ticketed CarrierCharacter2 VA
5th Fare Basis CodeCharacter1 G
6th Airport CodeCharacter36th Airport Code is the 3 letter code for the fifth destination airportLAX
6th Operating CarrierCharacter2 IO
6th  Ticketed CarrierCharacter2 IO
6th Fare Basis CodeCharacter1 G
7th Airport CodeCharacter37th Airport Code is the 3 letter code for the sixth destination airport.BOS
7th Operating CarrierCharacter2 OH
7th  Ticketed CarrierCharacter2 DL
7th Fare Basis CodeCharacter1 G
8th Airport CodeCharacter38th Airport Code is the 3 letter code for the seventh destination airport, and in this example, the final destination for this ticketDCA
8th Operating CarrierCharacter2If 23 coupons have to be recorded, then the format continues as follows:EV
8th  Ticketed CarrierCharacter2 DL
8th Fare Basis CodeCharacter1 X
9th Airport CodeCharacter39th Airport Code is the 3 letter code for the eight  destination airport, and in this example, the final destination for this ticketCLT
9th Operating CarrierCharacter2 YV
9th  Ticketed CarrierCharacter2 YV
9th Fare Basis CodeCharacter1 X
10th Airport CodeCharacter310th Airport Code is the 3 letter code for the ninth destination airport, and in this example, the final destination for this ticketATL
10th Operating CarrierCharacter2 FL
10th  Ticketed CarrierCharacter2 FL
10th Fare Basis CodeCharacter1 Y
11th Airport CodeCharacter311th Airport Code is the 3 letter code for the tenth destination airport, and in this example, the final destination for this ticketMIA
11th Operating CarrierCharacter2 MQ
11th  Ticketed CarrierCharacter2 AA
11th Fare Basis CodeCharacter1 G
12th Airport CodeCharacter312th Airport Code is the 3 letter code for the eleventh destination airport, and in this example, the final destination for this ticketFLL
12th Operating CarrierCharacter2 NK
12th  Ticketed CarrierCharacter2 NK
12th Fare Basis CodeCharacter1 X
13th Airport CodeCharacter313th Airport Code is the 3 letter code for the twelfth destination airport, and in this example, the final destination for this ticketFMY
13th Operating CarrierCharacter2 NK
13th  Ticketed CarrierCharacter2 NK
13th Fare Basis CodeCharacter1 X
14th Airport CodeCharacter314th Airport Code is the 3 letter code for the thirteenth destination airport, and in this example, the final destination for this ticketATL
14th Operating CarrierCharacter2 EV
14th  Ticketed CarrierCharacter2 DL
14th Fare Basis CodeCharacter1 Y
15th Airport CodeCharacter315th Airport Code is the 3 letter code for the fourteenth destination airport, and in this example, the final destination for this ticketLAS
15th Operating CarrierCharacter2 SY
15th  Ticketed CarrierCharacter2 SY
15th Fare Basis CodeCharacter1 Y
16th Airport CodeCharacter316th Airport Code is the 3 letter code for the fifteenth destination airport, and in this example, the final destination for this ticketSAN
16th Operating CarrierCharacter2 XE
16th Ticketed CarrierCharacter2 CO
16th Fare Basis CodeCharacter1 y
17th Airport CodeCharacter317th Airport Code is the 3 letter code for the sixteenth destination airport, and in this example, the final destination for this ticketMEX
17th Operating CarrierCharacter2 AM
17th TicketedCharacter2 MX
17th Fare Basis CodeCharacter1 Y
18th Airport CodeCharacter318th Airport Code is the 3 letter code for the seventeenth destination airport, and in this example, the final destination for this ticketLIM
18th Operating CarrierCharacter2 AA
18th  Ticketed CarrierCharacter2 AA
18th Fare Basis CodeCharacter1 y
19th Airport CodeCharacter319th Airport Code is the 3 letter code for the eighteenth destination airport, and in this example, the final destination for this ticketMEX
19th Operating CarrierCharacter2 MX
19th  Ticketed CarrierCharacter2 MX
19th Fare Basis CodeCharacter1 Y
20th Airport CodeCharacter320th Airport Code is the 3 letter code for the nineteenth destination airport, and in this example, the final destination for this ticketLAX
20th Operating CarrierCharacter2 AA
20th  Ticketed CarrierCharacter2 AA
20th Fare Basis CodeCharacter1 G
21th Airport CodeCharacter321th Airport Code is the 3 letter code for the twentieth destination airport, and in this example, the final destination for this ticketPDX
21th Operating CarrierCharacter2 QX
21th  Ticketed CarrierCharacter2 AS
21th Fare Basis CodeCharacter1 G
22nd Airport CodeCharacter322nd Airport Code is the 3 letter code for the twenty-first destination airport, and in this example, the final destination for this ticketANC
22nd Operating CarrierCharacter2 NW
22nd Ticketed CarrierCharacter2 AS
22nd Fare Basis CodeCharacter1 Y
23rdrd Airport CodeCharacter323rd  Airport Code is the 3 letter code for the twenty-second destination airport, and in this example, the final destination for this ticketBNE
23rd Operating CarrierCharacter2 VA
23rd  Ticketed CarrierCharacter2 VA
23rd  Fare Basis CodeCharacter1 G
24th Airport CodeCharacter324th Airport Code is the 3 letter code for the twenty-third destination airport, and in this example, the final destination for this ticketSYD

RECORD FORMAT:

The Origin-Destination Survey 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 with file extension [CSV] or [csv] following the file name.

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-OND.csv 

Sample Record Format:

XX,94,4913,1,BOS,IO,XX,G,LAX,VA,VA,G,SYD,--,--,,CNS,DJ,VA,G,BNE,VA,VA,G,LAX,IO,IO,G,BOS

NOTE: The second itinerary in the sample record format above indicates a surface segment between SYD and CNS. The --,--, , indicate the positions the two carriers and fare code would have occupied had there been air transportation between the two airports.

PART 241 – Passenger Origin-Destination Survey Report

OMB NO: 2139-0001
EXPIRATION DATE: 2/28/2014

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 2139-0001.  Public reporting for this collection of information is estimated to be approximately 60 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 241. 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, Marianne Seguin, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – marianne.seguin@dot.gov(link sends e-mail).

REQUIREMENTS

RECORD DESCRIPTION:  Origin-Destination Survey Report – Foreign Carriers

Field DescriptionData TypeLengthCommentsSample Data
Carrier codeCharacter2IATA codeXX
YearNumeric3Date: YYQ Where '09' = Year: 2009                          Quarter: 4094
FareNumericvariableValue of the ticket in whole U.S. dollars($)1234
Passenger CountNumericvariable 3
1st  Airport CodeCharacter31st Airport Code is the 3 letter code for the first Origin airportBOS
1st  Operating CarrierCharacter2IATA Carrier CodeIO
1st  Ticketed CarrierCharacter2IATA Carrier CodeXX
1st Fare Basis CodeCharacter1C - Unrestricted Business Class D - Restricted Business Class F - Unrestricted First Class G - Restricted First Class X - Restricted Coach Y - Unrestricted Coach U - UnknownG
2nd Airport CodeCharacter32nd Airport Code is the 3 letter code for the first destination airportLAX
2nd Operating CarrierCharacter2 VA
2nd Ticketed CarrierCharacter2 VA
2nd Fare Basis CodeCharacter1 G
3rd  Airport Code  3rd Airport Code is the 3 letter code for the second destination airportSYD
3rd Operating CarrierCharacter2Surface Segment Indicator – for Operating Carrier.--
3rd Ticketed CarrierCharacter2Surface Segment Indicator – for Ticketed Carrier--
3rd Fare Basis CodeCharacter1For surface travel segment 
4th Airport CodeCharacter34thAirport Code is the 3 letter code for the third destination airportCNS
4th Operating CarrierCharacter2 DJ
4th  Ticketed CarrierCharacter2 VA
4th Fare Basis CodeCharacter1 G
5th Airport CodeCharacter35th Airport Code is the 3 letter code for the fourth destination airportBNE
5th Operating CarrierCharacter2 VA
5th  Ticketed CarrierCharacter2 VA
5th Fare Basis CodeCharacter1 G
6th Airport CodeCharacter36th Airport Code is the 3 letter code for the fifth destination airportLAX
6th Operating CarrierCharacter2 IO
6th  Ticketed CarrierCharacter2 IO
6th Fare Basis CodeCharacter1 G
7th Airport CodeCharacter37th Airport Code is the 3 letter code for the sixth destination airport and in this example, the final destination for this ticketBOS
8th Airport CodeCharacter38th Airport Code is the 3 letter code for the seventh destination airport, and in this example, the final destination for this ticketDCA
8th Operating CarrierCharacter2If 23 coupons have to be recorded, then the format continues as follows:EV
8th  Ticketed CarrierCharacter2 DL
8th Fare Basis CodeCharacter1 X
9th Airport CodeCharacter39th Airport Code is the 3 letter code for the eight  destination airport, and in this example, the final destination for this ticketCLT
9th Operating CarrierCharacter2 YV
9th  Ticketed CarrierCharacter2 YV
9th Fare Basis CodeCharacter1 X
10th Airport CodeCharacter310th Airport Code is the 3 letter code for the ninth destination airport, and in this example, the final destination for this ticketATL
10th Operating CarrierCharacter2 FL
10th  Ticketed CarrierCharacter2 FL
10th Fare Basis CodeCharacter1 Y
11th Airport CodeCharacter311th Airport Code is the 3 letter code for the tenth destination airport, and in this example, the final destination for this ticketMIA
11th Operating CarrierCharacter2 MQ
11th  Ticketed CarrierCharacter2 AA
11th Fare Basis CodeCharacter1 G
12th Airport CodeCharacter312th Airport Code is the 3 letter code for the eleventh destination airport, and in this example, the final destination for this ticketFLL
12th Operating CarrierCharacter2 NK
12th  Ticketed CarrierCharacter2 NK
12th Fare Basis CodeCharacter1 X
13th Airport CodeCharacter313th Airport Code is the 3 letter code for the twelfth destination airport, and in this example, the final destination for this ticketFMY
13th Operating CarrierCharacter2 NK
13th  Ticketed CarrierCharacter2 NK
13th Fare Basis CodeCharacter1 X
14th Airport CodeCharacter314th Airport Code is the 3 letter code for the thirteenth destination airport, and in this example, the final destination for this ticketATL
14th Operating CarrierCharacter2 EV
14th  Ticketed CarrierCharacter2 DL
14th Fare Basis CodeCharacter1 Y
15th Airport CodeCharacter315th Airport Code is the 3 letter code for the fourteenth destination airport, and in this example, the final destination for this ticketLAS
15th Operating CarrierCharacter2 SY
15th  Ticketed CarrierCharacter2 SY
15th Fare Basis CodeCharacter1 Y
16th Airport CodeCharacter316th Airport Code is the 3 letter code for the fifteenth destination airport, and in this example, the final destination for this ticketSAN
16th Operating CarrierCharacter2 XE
16th Ticketed CarrierCharacter2 CO
16th Fare Basis CodeCharacter1 y
17th Airport CodeCharacter317th Airport Code is the 3 letter code for the sixteenth destination airport, and in this example, the final destination for this ticketMEX
17th Operating CarrierCharacter2 AM
17th TicketedCharacter2 MX
17th Fare Basis CodeCharacter1 Y
18th Airport CodeCharacter318th Airport Code is the 3 letter code for the seventeenth destination airport, and in this example, the final destination for this ticketLIM
18th Operating CarrierCharacter2 AA
18th  Ticketed CarrierCharacter2 AA
18th Fare Basis CodeCharacter1 y
19th Airport CodeCharacter319th Airport Code is the 3 letter code for the eighteenth destination airport, and in this example, the final destination for this ticketMEX
19th Operating CarrierCharacter2 MX
19th  Ticketed CarrierCharacter2 MX
19th Fare Basis CodeCharacter1 Y
20th Airport CodeCharacter320th Airport Code is the 3 letter code for the nineteenth destination airport, and in this example, the final destination for this ticketLAX
20th Operating CarrierCharacter2 AA
20th  Ticketed CarrierCharacter2 AA
20th Fare Basis CodeCharacter1 G
21th Airport CodeCharacter321th Airport Code is the 3 letter code for the twentieth destination airport, and in this example, the final destination for this ticketPDX
21th Operating CarrierCharacter2 QX
21th  Ticketed CarrierCharacter2 AS
21th Fare Basis CodeCharacter1 G
22nd Airport CodeCharacter322nd Airport Code is the 3 letter code for the twenty-first destination airport, and in this example, the final destination for this ticketANC
22nd Operating CarrierCharacter2 NW
22nd Ticketed CarrierCharacter2 AS
22nd Fare Basis CodeCharacter1 Y
23rdrd Airport CodeCharacter323rd  Airport Code is the 3 letter code for the twenty-second destination airport, and in this example, the final destination for this ticketBNE
23rd Operating CarrierCharacter2 VA
23rd  Ticketed CarrierCharacter2 VA
23rd  Fare Basis CodeCharacter1 G
24th Airport CodeCharacter324th Airport Code is the 3 letter code for the twenty-third destination airport, and in this example, the final destination for this ticketSYD

RECORD FORMAT:

The Origin-Destination Survey 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 with file extension [CSV] or [csv] following the file name.

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-FOND.csv 

Sample Record Format:

XX,94,1234,1,BOS,IO,XX,G,LAX,VA,VA,G,SYD,--,--,,CNS,DJ,VA,G,BNE,VA,VA,G,LAX,IO,IO,G,BOS

NOTE:

The second itinerary in the sample record format above indicates a surface segment between SYD and CNS. The --,--, , indicate the positions where the ticketing carrier, the  operating carrier, and the fare basis code information would have been entered had there been air transportation between the two airports.

PART 234 – ASQP

On-Time Data

OMB NO: 2138-0041
EXPIRATION DATE: 9/30/2011

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, Cecelia Robinson, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – cecelia.robinson@dot.gov(link sends e-mail).

REQUIREMENTS

RECORD DESCRIPTION:  ASQP – Monthly On-Time Data

Field DescriptionData TypeLengthCommentsSample Data
Carrier codeCharacter2IATA codeXX
Flight numberCharacter4 1234
Origin airport codeCharacter3Airport codeDFW
Destination airport codeCharacter3Airport codeBNA
Date of flight operationDATEccyymmddYear (CCYY)20100301
Day of the week of flight operationNumeric1Mon = 1, Sun = 71
Scheduled departure time as shown in Official Airline Guide (OAG)Numeric424 hour clock0735
Scheduled departure time as shown in CRSNumeric424 hour clock0735
Gate departure time (actual)Numeric424 hour clock0737
Scheduled arrival timeNumeric424 hour clock0915
Scheduled arrival time per CRSNumeric424 hour clock0915
Gate arrival time (actual)Numeric424 hour clock1148
Difference between OAG and CRS scheduled departure timesNumeric4In minutes – G minus H (2 hours=120 min)0
Difference between OAG and CRS scheduled arrival timesNumeric4In minutes – J minus K0
Scheduled elapsed timeNumeric4In minutes – K minus H100
Gate-to-Gate TimeNumeric4In minutes – L minus I251
Departure delay time (actual minutes CRS)Numeric4In minutes – I minus H2
Arrival delay time (actual minutes CRS)Numeric4In minutes – L minus K153
Elapsed time difference (actual minutes CRS)Numeric4In minutes – P minus O151
Wheels-off time (actual)Numeric424 hour clock0753
Wheels-on time (actual)Numeric424 hour clock1141
Aircraft tail numberCharacter6 N123XX
Cancellation codeCharacter1Values are A, B, C, D 
Minutes late for Delay Code E – Carrier CausedNumeric4In minutes 
Minutes late for Delay Code F – Weather       Numeric4In minutes 
Minutes late for Delay Code G – National Aviation System (NAS)Numeric4In minutes 
Minutes late for Delay Code H – SecurityNumeric4In minutes 
Minutes late for Delay Code I – Late Arriving Flight (Initial)Numeric4In minutes 
First gate departure time (actual)Numeric424 hour clock 
Total ground time away from gateNumeric4In minutes 
Longest ground time away from gateNumeric4In minutes 
Number of landings at diverted airportsNumeric11 to 5 for diversions, 9 designates a fly return canceled flight1
Diverted airport code 1Character3Airport codeMEM
Wheels-on time at diverted airportNumeric424 hour clock1005
Total ground time away from gate at diverted airportNumeric4In minutes69
Longest ground time away from gate at diverted airportNumeric4In minutes69
Wheels-off time (actual)  at diverted airportNumeric424 hour clock1114
Aircraft tail numberCharacter6 N234XX
Diverted airport code 2Character3Airport code 
Wheels-on time at diverted airportNumeric424 hour clock 
Total ground time away from gate at diverted airportNumeric4In minutes 
Longest ground time away from gate at diverted airportNumeric4In minutes 
Wheels-off time (actual)  at diverted airportNumeric424 hour clock 
Aircraft tail numberCharacter6  
Diverted airport code 3Character3Airport code 
Wheels-on Time at Diverted AirportNumeric424 hour clock 
Total ground time away from gate at diverted airportNumeric4In minutes 
Longest ground time away from gate at diverted airportNumeric4In minutes 
Wheels-off time (actual)  at diverted airportNumeric424 hour clock 
Aircraft tail numberCharacter6  
Diverted airport code 4Character3Airport code 
Wheels-on time at diverted airportNumeric424 hour clock 
Total ground time away from gate at diverted airportNumeric4In minutes 
Longest ground time away from gate at diverted airportNumeric4In minutes 
Wheels-off time (actual)  at diverted airportNumeric424 hour clock 
Aircraft tail numberCharacter6  
Diverted airport code 5Character3Airport code 
Wheels-on time at diverted airportNumeric424 hour clock 
Total ground time away from gate at diverted airportNumeric4In minutes 
Longest ground time away from gate at diverted airportNumeric4In minutes 
Wheels-off time (actual)  at diverted airportNumeric424 hour clock 
Aircraft tail numberCharacter6  

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

On-Time Data Transmittal

REQUIREMENTS

RECORD DESCRIPTION/INSTRUCTIONS: ASQP – On-Time Data Transmittal Letter

The transmittal letter must identify the carrier and month and year for which the On-Time Data are being submitted, and contain the following information:

A certification statement identifying an appropriate official of the reporting carrier.  The certification statement will read:

I, (Name) and (Title), of the above-named air carrier, certify that the BTS Form 234 "On-Time Flight Performance Report" is to the best of my knowledge and belief, true, correct, and a complete report for the period stated.

Date:

Signature:

Name (Please Print or Type):

The name(s) and telephone number(s) of the carrier's staff who can be contacted to resolve problems regarding both carrier data and technical matters.

For control purposes, a statement indicating the total number of flight operations and unique flight numbers in the Form 234 submission.

For the initial submission, a description of the data submitted, specifying whether the eSubmit file includes data for only reportable airports or for all domestic scheduled nonstop flight operations.

For the initial submission and for subsequent changes, a statement identifying the source of the scheduled arrival and departure times used in the report:  (1) Official Airline Guide in effect on (date) and (2) the name of the computer reservation system used for reporting purposes, pursuant to §234.4(f).

RECORD FORMAT:

Once signed, the On-Time Data Transmittal Letter must be published as an electronic "portable document format" file format, for uploading to the eSubmit application. 

The portable document format file MUST BE indicated when naming the file, by using the letters [PDF] or [pdf] following the file name, as the file name extension.  You must have Adobe Reader software downloaded on your computer in order to "save as/print" your document as a 'pdf' file. 

While the file name is flexible and may be determined by the individual air carrier, the portable document format (pdf) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet

Suggested file name: XX201003-234transmittal.pdf

PART 234 – ASQP – Mishandled Baggage Report

OMB NO: 2138-0041
EXPIRATION DATE: 9/30/2011

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, Cecelia Robinson, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – cecelia.robinson@dot.gov(link sends e-mail).

REQUIREMENTS

RECORD DESCRIPTION:  ASQP – Mishandled Baggage Report

Field DescriptionData TypeLengthCommentsSample Data
Carrier codeCharacter2Two letter IATA codeXX
Year of DataNumeric4Year (CCYY)2010
Month of DataNumeric2Month (MM)03
Number of Domestic Scheduled Passengers EnplanedNumericVaries 8004000
Number of Mishandled Baggage Reports Filed with CarrierNumericVaries 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

PART 234 – Mishandled Baggage Report Certification

REQUIREMENTS

RECORD DESCRIPTION/INSTRUCTIONS: ASQP – Mishandled Baggage Report Certification

A certification statement for the Mishandled Baggage Report is required identifying an appropriate official of the reporting carrier.  The certification statement will read:

I, (Name) and (Title), of the above named carrier, certify that the Mishandled Baggage Report file is to the best of my knowledge and belief, true, correct and a complete report for the period stated.

Date:

Signature:

Name (Please Print or Type):

RECORD FORMAT:

Once signed, the Mishandled Baggage Report Certification must be published as an electronic "portable document format" file format, for uploading to the eSubmit application. 

The portable document format file MUST BE indicated when naming the file, by using the letters [PDF] or [pdf] following the file name, as the file name extension.  You must have Adobe Reader software downloaded on your computer in order to "save as/print" your document as a 'pdf' file. 

While the file name is flexible and may be determined by the individual air carrier, the portable document format (pdf) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet

Suggested file name: XX201003-234mbrCert.pdf

PART 251 - Report of Passengers Denied Confirmed Space Report

OMB NO: 2138-0018
EXPIRATION DATE: 9/30/2011

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-0018.  Public reporting for Form 251, Report of Passengers Denied Confirmed Space, is estimated to be approximately 5 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 250. 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, Cecelia Robinson, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – cecelia.robinson@dot.gov(link sends e-mail).

REQUIREMENTS

RECORD DESCRIPTION:  251 - Report of Passengers Denied Confirmed Space Report

Field DescriptionData TypeLengthCommentsSample Data
Carrier NameCharacter30 Atlantic Southeast
OAG Carrier CodeCharacter2Two Letter CodeEV
Quarter EndedCharacter6Quarter/Year3Q2010
Number of passengers who were denied boarding involuntarily who qualified for denied boarding compensation and: (a) were given alternate transportation within the meaning of §250.5.NumericVaries 1177
(b) were not given such alternate transportation.NumericVaries 1358
Number of passengers denied boarding involuntarily who did not qualify for denied boarding compensation due to: (a) accommodation on another flight that arrived within 1 hour after the scheduled arrival time of the original flight.NumericVaries 0
(b) substitution of smaller capacity equipment.NumericVaries 0
(c) failure of passenger to comply with ticketing, check-in, or reconfirmation procedures, or to be acceptable for transportation under carrier's tariff or contract of carriage.NumericVaries 746
TOTAL NUMBER DENIED BOARDING INVOLUNTARILYNumericVaries 3281
Number of passengers denied boarding involuntarily who actually received compensation.*NumericVaries*If any passengers qualified for denied boarding compensation but were not offered compensation, attach a pdf statement as to the number of such passengers and an explanation of why the offer was not made.2535
Number of passengers who volunteered to give up reserved space in exchange for a payment of the carrier's choosing.NumericVaries 28566
Number of passengers accommodated in another section of the aircraft: (a) Upgrades.NumericVaries 0
(b) Downgrades.NumericVaries 0
Total Boardings.NumericVaries 25450773
Amount of compensation paid to passengers who: (a) were denied boarding involuntarily and were given alternate transportation within the meaning of §250.5.CurrencyVaries 407092
(b) were denied boarding involuntarily and were not given alternate transportation.CurrencyVaries 480726
(c) volunteered for denied boarding.CurrencyVaries 0

RECORD FORMAT:

The 251 - Report of Passengers Denied Confirmed Space Report 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-Form251.csv

Sample Record Format:

Atlantic Southeast Airlines,EV,3Q2010,1177,1358,0,0,746,3281,2535,28566,0,0,25450773,407092,480726,0

Part 241 - Form 41

P-1a Interim Operations Report

OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015

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-0013.  Public reporting for Schedule P-1(a), Interim Operations Report, is estimated to be approximately 1 hour 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 241. 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, Jeff Gorham, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov(link sends e-mail).

REQUIREMENTS

RECORD DESCRIPTION:  P-1a Interim Operations Report - Group I+, II & III

Field DescriptionData TypeLengthCommentsSample Data
Schedule ItemCharacter4 P01A
Carrier CodeCharacter3 3Z
Entity RegionCharacter1 
Aircraft TypeCharacter4P-5.1, P-5.20000, 9999
Account CodeCharacter5 0014A, 10100
FrequencyNumeric1 
YearCharacter4 2010
MonthCharacter2 12
Gain or LossNumeric--- 2282243, -5645

RECORD FORMAT:

The P-1a Interim Operations 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-F41-P-1a.csv

Sample Record Format:

P01A,YV,S,0000,39010,1,2010,06,-68401383

Part 241 - Form 41

P-12a Fuel Cost and Consumption

OMB NO: 2138-0013

EXPIRATION DATE: 7/31/2015

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-0013.  Public reporting for Schedule P-12(a), Fuel Consumption by Type of Service and Entity, is estimated to be approximately 4 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 241. 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, Jeff Gorham, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov(link sends e-mail).

REQUIREMENTS

RECORD DESCRIPTION:  P-12a – Fuel Cost and Consumption Report - Group I+, II & III

Field DescriptionData TypeLengthCommentsSample Data
Schedule ItemCharacter4 P12A
Carrier CodeCharacter3 3Z
Entity RegionCharacter1 D
Aircraft TypeCharacter4Reported on P-5.1, P-5.2 only0000
Account CodeCharacter5 0014A, 10100
FrequencyNumeric1 2  
YearCharacter4 2010
MonthCharacter2 12
Gain or LossNumeric--- 2282243, -5645

RECORD FORMAT:

The P-12a – Fuel Cost and Consumption 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-F41-P-12A.csv

Sample Record Format:

P-12a    Fuel Cost and Consumption 

P12A,3Z,S,0000,0008A,1,2010,06,213786

P12A,3Z,S,0000,0008B,1,2010,06,2208410

P12A,3Z,S,0000,0008C,1,2010,06,820818

Account Code   

A = Gallons

B = Cost

C = Gallons not Paid for

PART 241 – Form 41

Form A Certification

OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015

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-0013.  Public reporting for Schedule A, Certification is estimated to be approximately 15 minutes 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 241. 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, Jeff Gorham, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov(link sends e-mail).

REQUIREMENTS

RECORD DESCRIPTION/INSTRUCTIONS: Form A Certification

A certification statement is required identifying an appropriate official of the reporting carrier.  The certification statement will read:

Period ended:

I, (Name) and (Title), of (Carrier Name), do certify that all schedules and supporting documents which are submitted herewith or have been submitted heretofore as parts of this report filed for the indicated period, have been prepared under my direction; that I have carefully examined them and declare that they correctly reflect the accounts and records of the company, and to the best of my knowledge and belief are a complete and accurate statement, after adjustments to reflect full accruals, of the operating revenues and expenses, income items, assets, liabilities, capital, retained earnings, and operating statistics for the periods reported in the financial schedules, the Schedule T-100 Traffic, and if applicable, the Passenger Origin-Destination Survey; that the various items herein reported were determined in accordance with the Code of Federal Regulations for Large Certificated Air Carriers  as prescribed by the Department of Transportation; and that the data contained herein are reported on a basis consistent with that of the preceding report except as specifically noted in the financial and statistical statements.

Date:

Signature:

Name (Please Print or Type):

Title 18 U.S.C. Sec. 1001, Crimes and Criminal Procedures, makes it a criminal offense subject-to a maximum fine of $10,000 or imprisonment for not more than 5 years, or both, to knowingly and willfully make or cause to be made any false or fraudulent statements or representation in any matter within jurisdiction of any agency of the United States.

The Confidential Information Protection and Statistical Efficiency Act 2002 (44 USC 3501), requires a statistical agency to clearly identify information it collects for non-statistical purposes.  BTS hereby notifies the respondents and the public that BTS uses the information it collects under this OMB approval for non-statistical purposes including, publication of both respondent's identity and it's data, submission of the information to agencies outside BTS for review, analysis and possible use in regulatory and other administrative matters.

Per quarter, it can take each air carrier between 30 and 300 hours to complete the required financial reports and between 6 and 18 hours to complete the required T-100 monthly traffic reports.

RECORD FORMAT:

Once signed, the Form A Certification must be published as an electronic "portable document format" file format, for uploading to the eSubmit application. 

The portable document format file MUST BE indicated when naming the file, by using the letters [PDF] or [pdf] following the file name, as the file name extension.  You must have Adobe Reader software downloaded on your computer in order to "save as/print" your document as a 'pdf' file. 

While the file name is flexible and may be determined by the individual air carrier, the portable document format (pdf) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet

Suggested file name: XX201003- F41-A-Cert.pdf

FORM 41 FINANCIAL DATA

B-1, B1-1, P1.1, P1.2, P5.1, P5.2, P6, P7

OMB NO: 2138-0013

EXPIRATION DATE: 7/31/2015

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-0013.  Public reporting for Schedule B-1.1, Balance Sheet is estimated to be approximately 2 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 241. 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, Jeff Gorham, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov(link sends e-mail).

OMB NO: 2138-0013

EXPIRATION DATE: 7/31/2015

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-0013.  Public reporting for Schedule B-1, Balance Sheet is estimated to be approximately 7 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 241. 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, Jeff Gorham, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov(link sends e-mail).

OMB NO: 2138-0013

EXPIRATION DATE: 7/31/2015

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-0013.  Public reporting for Schedule P-1.1, Statement of Operations, is estimated to be approximately 2 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 241. 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, Jeff Gorham, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov(link sends e-mail).

OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015

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-0013.  Public reporting for Schedule P-1.2 Statement of Operations, is estimated to be approximately 7 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 241. 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, Jeff Gorham, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov(link sends e-mail).

OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015

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-0013.  Public reporting for Schedule P-5.1, Aircraft Operating Expenses, is estimated to be approximately 2 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 241. 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, Jeff Gorham, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov(link sends e-mail).

OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015

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-0013.  Public reporting for Schedule P-5.2, Aircraft Operating Expenses, is estimated to be approximately 15 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 241. 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, Jeff Gorham, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov(link sends e-mail).

OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015

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-0013.  Public reporting for Schedule P-6, Operating Expenses by Objective Grouping, is estimated to be approximately 7 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 241. 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, Jeff Gorham, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov(link sends e-mail).

OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015

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-0013.  Public reporting for Schedule P-7, Operating Expenses by Functional Grouping, is estimated to be approximately 10 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 241. 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, Jeff Gorham, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov(link sends e-mail).

REQUIREMENTS

RECORD DESCRIPTION:  Form 41 Financials – DB10 Collection

Field DescriptionData TypeLengthCommentsSample Data
Schedule ItemCharacter4 B010
Carrier CodeCharacter3 3Z
Entity RegionCharacter1 
Aircraft TypeCharacter4(P-5.1, P-5.2)0000, 9999
Account CodeCharacter5 0014A, 10100
FrequencyNumeric1 
YearCharacter4 2010
MonthCharacter2 12
Gain or LossNumeric--- 2282243, -5645

RECORD FORMAT:

The Form 41 Financials – DB10 Collection 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-DB10.csv

Sample Record Format:

B-1         B010      Balance Sheet – Liabilities & Stockholders Equity - Group I+, II & III

B010,3Z,D,0000,20250,2,2010,12,-461395

B-1.1      B011      Balance Sheet – Group I-

B011,SI,D,0000,00230,3,2010,12,54232

P-1.1      P011      Profit and Loss Statement – Group I-

P011,SI,D,0000,00130,3,2010,12,54232

P-1.2      P012      Profit and Loss Statement - Group I+, II & III

P012,3Z,D,0000,39190,2,2010,12,-850

P-5.1      P051      Aircraft Operating Expenses – Group I+, I-

P051,XP,D,9999,Z9210,2,2010,03,399134

P-5.2      P052      Aircraft Operating Expenses – Group II & III

P052,AA,D,6171,51990,2,2010,03,2986314

P-6         P060      Operating Expenses by Objective Grouping - Group I+, II & III

P060,3Z,D,0000,00320,2,2010,12,359199

P-7         P070      Operating Expenses by Functional Grouping - Group III

P070,AA,D,0000,00130,2,2010,12,359199

PART 241 – Form 41

B-12 Statement of Changes in Financial Position

OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015

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-0013.  Public reporting for Schedule B-12, Statement of Changes in Financial Position, is estimated to be approximately 5 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 241. 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, Jeff Gorham, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov(link sends e-mail).

REQUIREMENTS

RECORD DESCRIPTION/INSTRUCTIONS: B-12 Statement of Changes in Financial Position

For the B-12, Cash Flow Statement, it is freeform depending on each carrier's operations and is a bridge between the B-1 Balance Sheet  and the P-1.2 Statement of Operations (Income Statement).

RECORD FORMAT:

The PART 241 – B-12 Statement of Changes in Financial Position must be published as an electronic "portable document format" file format, for uploading to the eSubmit application. 

The portable document format file MUST BE indicated when naming the file, by using the letters [PDF] or [pdf] following the file name, as the file name extension.  You must have Adobe Reader software downloaded on your computer in order to "save as/print" your document as a 'pdf' file. 

While the file name is flexible and may be determined by the individual air carrier, the portable document format (pdf) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet

Suggested file name: XX201003- F41-B-12.pdf

Part 241 - Form 41

B-7 Airframe and Aircraft Engine Acquisitions and Retirements

OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015

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-0013.  Public reporting for Schedule B-7, Airframe and Aircraft Engine Acquisitions and Retirements, is estimated to be approximately 7 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 241. 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, Jeff Gorham, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov(link sends e-mail).

REQUIREMENTS

RECORD DESCRIPTION:  B-7 – Airframe and Aircraft Engine Acquisitions and Retirements - Group II & III

Field DescriptionData TypeLengthCommentsSample Data
Form TypeCharacter3 B-7
Air Carrier CodeCharacter3 UA
YearNumericccyy 2010
Month EndedNumericmm 12
Year of First Airframe DeliveryNumericccyy 1989
Airframe Manufacturer Serial no.Character20 87654321
Date Acquired or RetiredNumericccyymmdd 20090131
Acquisition or Retirement CodeCharacter1 R or A
Airframe License NumberCharacter8 N000XX
Number of Aircraft Engines Acquired/RetiredCharacter5 2 GE
Aircraft Type CodeNumeric4 6141
Type, Model and Cabin DesignCharacter25 Boeing B-737-8 PAX
Usual Seat ConfigurationNumeric4 76
Acquired Cost or Capitalized ValueNumeric15 12345678
Depr. Cost or Amortized ValueNumeric15 23232323
Realization ValueNumeric15 45454545
Acquired From / DispositionCharacter50 Sold to ABC Leasing Inc
Owned/Lease TypeCharacter1 O
Operating StatusCharacter1 Y

RECORD FORMAT:

The B-7 – Airframe and Aircraft Engine Acquisitions and Retirements 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-B7.csv

Sample Record Format:

B-7,UA,2010,12,198990131,87654321,20090131,R,N000XX,2 GE,6141,Boeing B-737-8 PAX,76,12345678,23232323,45454545,Sold to ABC Leasing Inc,O,Y

Leased Type:  a = Capital Lease, b = Operating Lease, O = Owned

Operating Status:  Y = Yes, N = Not operating

Part 241 - Form 41

B-43 Inventory of Airframes and Aircraft Engines

OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015

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-0013.  Public reporting for Schedule B-43, Inventory of Airframes and Aircraft Engines, is estimated to be approximately 8 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 241. 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, Jeff Gorham, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov(link sends e-mail).

REQUIREMENTS

RECORD DESCRIPTION:  B43 – Inventory of Airframes and Aircraft Engines - Group I-, I+, II & III

Field DescriptionData TypeLengthCommentsSample Data
Form TypeCharacter4 B-43
Air Carrier CodeCharacter3 UA
YearNumericccyy 2011
Month EndedNumericmm 12
Year of First Airframe DeliveryNumericccyy 2010
Airframe Manufacturer Serial no.Character20 1191
Airframe License NumberCharacter8 N000XX
Date Acquired or Placed in ServiceNumericccyymmdd 20100101
Usual Seat ConfigurationNumeric4 124
Number of Aircraft EnginesCharacter5Engines by Type2 GE
ManufacturerCharacter50 Airbus Industrie
Aircraft Type CodeNumeric4 6981
Type, Model and Cabin DesignCharacter25 A-319-PSGR
Available CapacityNumeric12Capacity in pounds35100
Acquired Cost or Capitalized ValueNumeric15 12345678
Allowance for Depr. or AmortizationNumeric15 123456
Depr. Cost or Amortized ValueNumeric15 23232323
Estimated Residual ValueNumeric15 45454545
Est. Depreciation or Amortizable LifeNumeric3 300
Owned/Lease TypeCharacter1 O
Operating StatusCharacter1 Y

RECORD FORMAT:

The B43 – Inventory of Airframes and Aircraft Engines 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-B43.csv

Sample Record Format:

B-43,UA,2011,12,2010,1191,N000XX,20100101,124,2GE,Airbus Industries,6981,A-319 PSGR,35100,12345678,123456,23232323,

45454545,300,O,Y

Leased Type:  a = Capital Lease, b = Operating Lease, O = Owned

Operating Status:  Y = Yes, N = Not operating

Part 241 - Form 41

P-2 Notes to BTS Form 41 Reports

OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015

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-0013.  Public reporting for Schedule P-2, Notes to BTS Form 41 Report, is estimated to be approximately 4 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 241. 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, Jeff Gorham, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov(link sends e-mail).

REQUIREMENTS

RECORD DESCRIPTION/INSTRUCTIONS: P-2 Notes to BTS Form 41 Report

For the P-2 Notes, this report is a narrative document that explains the Air Carrier's Form 41 Financials.

RECORD FORMAT:

The P-2 Notes to BTS Form 41 Report must be published as an electronic "portable document format" file format, for uploading to the eSubmit application. 

The portable document format file MUST BE indicated when naming the file, by using the letters [PDF] or [pdf] following the file name, as the file name extension.  You must have Adobe Reader software downloaded on your computer in order to "save as/print" your document as a 'pdf' file. 

While the file name is flexible and may be determined by the individual air carrier, the portable document format (pdf) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet

Suggested file name: XX201003- F41-P-2notes.pdf

Part 241 - Form 41

P-2 Passenger Facility Charge Report

REQUIREMENTS

RECORD DESCRIPTION:  P-2 Passenger Facility Charge Report

Field DescriptionData TypeLengthCommentsSample Data
Airline IDCharacter5DOT Assigned12345
Carrier CodeCharacter3IATA or DOT AssignedXX
Year of Data Included in the ReportNumeric4Year (CCYY)2010
Month of Quarter Ending Data Included in the ReportNumeric2Month (MM) Qtr 1 = 03    Qtr 3 = 09 Qtr 2 = 06    Qtr 4 = 1203
Total PFC Liability at Beginning of PeriodNumeric50 9999
Total Amount Collected in Trust for Public AgenciesNumeric50 9999
Total Amount Remitted to Public AgenciesNumeric50 9999
AdjustmentsNumeric50Collection Compensation, PFC Refunds9999
Total PFC Liability at End of PeriodNumeric50 9999

RECORD FORMAT:

The P-2 Passenger Facility Charge 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- F41-P-2pfc.csv

Sample Record Format:

12345,XX,2010,03,9999,9999,9999,9999,9999

FORM 41 FINANCIAL DATA

P-10 – Employee Statistics by Labor Category

OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015

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-0013.  Public reporting for Schedule P-10, Employment Statistics by Labor Category, is estimated to be approximately 2 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 241. 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, Jeff Gorham, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov(link sends e-mail).

REQUIREMENTS

RECORD DESCRIPTION:  P-10 – Employee Statistics by Labor Category Report - Group I+, II & III

Field DescriptionData TypeLengthCommentsSample Data
Schedule ItemCharacter4 P100
Carrier CodeCharacter3 3Z
Entity RegionCharacter1 
Aircraft TypeCharacter4(P-5.1, P-5.2)0000
Account CodeCharacter5 0014A, 10100
FrequencyNumeric1 2  
YearCharacter4 2010
MonthCharacter2 12
Gain or LossNumeric--- 2282243, -5645

RECORD FORMAT:

The P-10 – Employee Statistics by Labor Category 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-F41-P-10.csv

Sample Record Format:

P100,3Z,D,0000,00310,4,2010,12,31

Part 241 - Form 41

T-8 Report of All-Cargo Operations Report

OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015

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-0013.  Public reporting for Schedule T-8, Report of All-Cargo Operations, is estimated to be approximately 2 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 241. 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, Jeff Gorham, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov(link sends e-mail).

REQUIREMENTS

RECORD DESCRIPTION:  T-8 Report of All-Cargo Operations Report

Field DescriptionData TypeLengthCommentsSample Data
Schedule ItemCharacter2Name of FormT8
Carrier codeCharacter2IATA codeXX
Airline IDNumeric5Five digit Cardecode10579
RegionNumeric3Certificate of Operations418 or 401
Account CodeNumeric5Account41990
FrequencyNumeric1Annual4
Year of Data Included in the ReportNumeric4Year (CCYY)2010
Month of Data Included in the ReportNumeric2Month (MM)03
DataNumeric---Actual data value3938455

RECORD FORMAT:

The T-8 Report of All-Cargo Operations Report 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-F41-T8.csv

Sample Record Format:

T8,JW,10548,418,39050,4,2010,12,4948301

PART 248 – Form 248

Audit Reports

OMB NO: 2138-0004
EXPIRATION DATE: 12/31/2008

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-0004.  Public reporting for this collection of information is estimated to be approximately 15 minutes 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 248. 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, Jeff Gorham, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov(link sends e-mail).

REQUIREMENTS

RECORD DESCRIPTION/INSTRUCTIONS: Form 248- Audit Report

The Form 248 – Annual Audit Report is an external audit conducted by Certified Public Accounts and is freeform based on the carrier's operations.  If no audit is conducted for any given year, then a statement to that fact must be submitted instead.

RECORD FORMAT:

The Form 248- Audit Report must be published as an electronic "portable document format" file format, for uploading to the eSubmit application. 

The portable document format file MUST BE indicated when naming the file, by using the letters [PDF] or [pdf] following the file name, as the file name extension.  You must have Adobe Reader software downloaded on your computer in order to "save as/print" your document as a 'pdf' file. 

While the file name is flexible and may be determined by the individual air carrier, the portable document format (pdf) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet

Suggested file name: XX201003- Form248Audit.pdf

PART 374A - Form 183

Report of Extension of Credit to Political Candidates

OMB NO: 2138-0016
EXPIRATION DATE: 7/31/2006

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-0016.  Public reporting for Form 183, Report of Extension of Credit to Political Candidates, is estimated to be approximately 1 hour 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 374a. 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, Jeff Gorham, OAI/BTS/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov(link sends e-mail).

REQUIREMENTS

RECORD DESCRIPTION:  Form 183 - Report of Extension of Credit to Political Candidates

The report and a certification statement are required. Certification must be by an appropriate official of the reporting carrier.  The report and certification statement will include:

Reporting Period (Month/Year):                                             

Air Carrier Code:

Air Carrier Name:

Name of Candidate:

Name of AccountTotal ReceivableCredit LimitationUnpaid BalanceAge of Unpaid Balance In DaysSecurity type of collateral and $amount
      
      
      
      
      

I, (Name) and (Title), of the above named carrier, certify that the above Report of Extension of Credit to Political Candidates has been examined by me and is to the best of my knowledge and belief, true, correct, as defined in PART 374a (14 CFR 374a) and is a complete report for the period stated.

Date:

Signature: (this may be electronic or signed with document scanned into a pdf)

Name (Please Print or Type):

RECORD FORMAT:

Once signed, the Form 183 - Report of Extension of Credit to Political Candidates must be published as an electronic "portable document format" file format, for uploading to the eSubmit application. 

The portable document format file MUST BE indicated when naming the file, by using the letters [PDF] or [pdf] following the file name, as the file name extension.  You must have Adobe Reader software downloaded on your computer in order to "save as/print" your document as a 'pdf' file. 

While the file name is flexible and may be determined by the individual air carrier, the portable document format (pdf) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet

Suggested file name: CC201003- Form183PoliticalCreditRpt-Cert.pdf

PART 291 - Form 291

Statement of Operations Report

REQUIREMENTS

RECORD DESCRIPTION:  291 - Statement of Operations Report for Section 41103 Operations

Field DescriptionData TypeLengthCommentsSample Data
Schedule ItemVarchar4Name of Form291A
Carrier codeCharacter2Two letter IATA codeXX
Airline IDNumeric5Five digit Cardecode10482
Account CodeNumeric5Account41990
FrequencyNumeric1Annual4
Year of Data Included in the ReportNumeric4Year (CCYY)2010
Month of Data Included in the ReportNumeric2Month (MM)03
DataNumeric---Actual data value3484750

RECORD FORMAT:

The 291 - Statement of Operations Report 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-Form291.csv

Sample Record Format:

291A,JW,10548,39050,4,2010,12,4847502