Skip
to main content

About DOT | Briefing Room | Our Activities

Bureau of Transportation
Statistics

About
OST-R | Press Room | Programs | OST-R Publications | Library | Contact Us

Search form

Search

Main menu

Data and
Statistics

Intermodal
Transportation Database

By
Mode

Airlines
and Airports

Highway

Maritime

Multimodal
Sources

Pipeline
and Hazardous Materials

Rail

Transit

By
Region

International

National

State
and Local

By
Subject

Economy
and Finance

Energy
and Environment

Freight

Geospatial

Infrastructure

Passenger

Safety

Vehicles

Dictionary

Geospatial
Information

Search
Public Datasets

Databases

Help with Data

TranStats

Airport

Available
Seat-Miles

Carrier

Causes of
Flight Delays

Freight

Fuel cost and consumption

Load
Factor

Operating
Profit/Loss

Passengers

Subject Areas

Airlines
and Airports

Congestion

Connectivity

Economics
and Finance

Energy
and Environment

Freight
Data and Statistics

General

Geospatial
Information

International

Livability

Maritime
Program

Passenger
Travel

Safety

Survey
Results

Trending
and Forecasting

Library

Search
the Collections

FAQs

Ask a
Librarian

BTS
Publications

BTS Bookstore

External Links

News

Events

What's New

Upcoming Press
Releases

Policies and
Methods

Confidentiality
Policy

Laws and
Regulations

Scientific
Integrity

Statistical
Policy & Research

About BTS

Advisory
Council on Transportation Statistics

Jobs
and Internships

Organizational
Chart

BTS Programs

Contact
Us

You are here

Home

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 [email-masked]

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 data format that has
fields/columns
separated by the comma character and records/rows separated by
new lines

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 – [email-masked].

REQUIREMENTS

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

Field Description

Data Type

Length

Comments

Sample Data

Data Type

Character

1

One letter code
(S)

S

Entity code

Character

5

Five character
code assigned by DOT

0A050

Year of Data

Numeric

4

Year (CCYY)

2010

Month of Data

Numeric

2

Month (MM)

03

Origin Airport

Character

3

Three letter
OAG airport code

BWI

Destination Airport

Character

3

Three letter
OAG airport code

LAS

Service Class

Character

1

One letter
service class code: F, G, L, N, P, R, H

F

Segment Aircraft Type

Numeric

3

DOT assigned
three  numeric aircraft type code

698

Segment Cabin Configuration

Numeric

1

One numeric
aircraft cabin configuration code: 1,2,3,4

1

Segment Departures Performed

Numeric

5

Up to five
numeric departures performed

25

Segment Available Capacity

Numeric

10

Up to ten
numeric, reported in pounds

125000000

Segment Available Seats

Numeric

7

Up to seven
numeric, aircraft seating capacity

1250

Segment Passengers Transported

Numeric

7

Up to seven
numeric, reported transported passengers

922

Segment Freight Transported

Numeric

10

Up to ten
numeric, freight reported in pounds

25338

Segment Mail Transported

Numeric

10

Up to ten
numeric, mail reported in pounds

989

Segment Scheduled Departures

Numeric

5

Up to five
numeric scheduled departures

23

Segment Ramp to Ramp Minutes

Numeric

10

Up to ten
numeric, reported in minutes

789

Segment Airborne Minutes

Numeric

10

Up to ten
numeric, reported in minutes

685

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 – [email-masked].

REQUIREMENTS

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

Field Description

Data Type

Length

Comments

Sample Data

Carrier Code

Character

3

2 or 3 digit
Carrier Code

BA

Year and Month of Data

Numeric

6

Format: YYYYMM
YYYY = century and year; Format: MM: 01 = January … 12 = December

200612

Origin Airport

Character

3

The three
letter OAG code identifying the airport.

IAH

Destination Airport

Character

3

The three
letter OAG code identifying the airport.

LGW

Service Class

Character

1

One letter
service class code: F, G, L, N, P, R, H

F

Segment Aircraft Type and Cabin
Configuration

Number

4

The 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/Cargo

6271

Segment Departures Performed

Number

Up to 5

Up to five
numeric Revenue departures performed

49

Segment Passengers

Number

Up to 10

Up to seven
numeric, reported transported passengers

6707

Segment Freight

Number

Up to 10

Up to ten
numeric, freight reported in kilos

521842

Segment Available Seats

Number

Up to 7

Up to seven
numeric, aircraft seating capacity

10976

Segment Available Capacity

Number

Up to 10

Up to ten
numeric, reported in kilos

1903195

Market Passengers

Number

Up to 10

Up to seven
numbers Enplaned passengers

6707

Market Freight

Number

Up to 10

Up to ten
numbers, reported in kilos

521842

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 Description

Data Type

Length

Comments

Sample Data

Data Type

Character

1

One letter code
(S)

S

Entity code

Character

5

Five character
code assigned by DOT

06000

Year of Data

Numeric

4

Year (CCYY)

2010

Month of Data

Numeric

2

Month (MM)

05

Day of Service

Numeric

2

Day of month
the service was performed – for use by USPS Only

27

Origin Airport

Character

3

Three letter
OAG airport code

FAI

Destination Airport

Character

3

Three letter
OAG airport code

GAL

Service Class

Character

1

One letter
service class code: F, G, L, N, P, R

F

Segment Aircraft Type

Numeric

3

DOT assigned
three  numeric aircraft type code

405

Segment Cabin Configuration

Numeric

1

One numeric
aircraft cabin configuration code: 1,2,3,4

3

Segment Departures Performed

Numeric

5

Up to five
numeric departures performed

1

Segment Available Capacity

Numeric

10

Up to ten
numeric, reported in pounds

3793

Segment Available Seats

Numeric

7

Up to seven
numeric, aircraft seating capacity

16

Segment Passengers Transported

Numeric

7

Up to seven
numeric, reported transported passengers

3

Segment Freight Transported

Numeric

10

Up to ten
numeric, freight reported in pounds

239

Segment Mail Transported

Numeric

10

Up to ten
numeric, mail reported in pounds

1106

Segment Scheduled Departures

Numeric

5

scheduled
departures

1

Segment Ramp-to-Ramp time

Numeric

10

Up to ten
numeric, reported in minutes

72

Segment Airborne time in minutes

Numeric

10

Up to ten
numeric, reported in minutes

60

DOT Certification

Numeric

3

Values are:
135, 121 – for use by USPS Only

121

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 Description

Data Type

Length

Comments

Sample Data

Data Type

Character

1

One letter code
(M)

M

Entity code

Character

5

Five character
code assigned by DOT

06000

Year of Data

Numeric

4

Year (CCYY)

2010

Month of Data

Numeric

2

Month (MM)

05

Day of Service

Numeric

2

Day of month
the service was performed – for use by USPS Only

27

Origin Airport

Character

3

Three letter
OAG airport code

FAI

Destination Airport

Character

3

Three letter
OAG airport code

GAL

Service Class

Character

1

One letter
service class code: F, G, L, N, P, R

F

Market Passengers enplaned

Numeric

7

Up to seven
numeric, reported market passengers

3

Market Freight Enplaned

Numeric

10

Up to ten
numeric, reported in pounds

239

Market Mail Enplaned

Numeric

10

Up to ten
numeric, reported in pounds

1000

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 – [email-masked].

REQUIREMENTS

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

Field Description

Data Type

Length

Comments

Sample Data

Carrier code

Character

2

IATA code

XX

Year

Numeric

3

Date: YYQ Where
'09' = Year: 2009

Quarter: 4

094

Fare

Numeric

variable

Value of the
ticket in whole U.S. dollars($)

4913

Passenger Count

Numeric

variable

3

1st  Airport Code

Character

3

1st Airport Code is the
3 letter code for the first Origin airport

BOS

1st  Operating Carrier

Character

2

IATA Carrier
Code

IO

1st  Ticketed Carrier

Character

2

IATA Carrier
Code

XX

1st Fare Basis Code

Character

1

C -
Unrestricted Business Class D - Restricted Business Class F - Unrestricted
First Class G - Restricted First Class X - Restricted Coach Y -
Unrestricted Coach U - Unknown

G

2nd Airport Code

Character

3

2nd Airport Code is the
3 letter code for the first destination airport

LAX

2nd Operating Carrier

Character

2

VA

2nd Ticketed Carrier

Character

2

VA

2nd Fare Basis Code

Character

1

G

3rd  Airport Code

3rd Airport Code is the
3 letter code for the second destination airport

SYD

3rd Operating Carrier

Character

2

Surface
Segment Indicator – for Operating Carrier.

--

3rd Ticketed Carrier

Character

2

Surface
Segment Indicator – for Ticketed Carrier

--

3rd Fare Basis Code

Character

1

For surface
travel segment, leave the Fare Basis Code  blank

4th Airport Code

Character

3

4thAirport Code is the
3 letter code for the third destination airport

CNS

4th Operating Carrier

Character

2

DJ

4th  Ticketed Carrier

Character

2

VA

4th Fare Basis Code

Character

1

G

5th Airport Code

Character

3

5th Airport Code is the
3 letter code for the fourth destination airport

BNE

5th Operating Carrier

Character

2

VA

5th  Ticketed Carrier

Character

2

VA

5th Fare Basis Code

Character

1

G

6th Airport Code

Character

3

6th Airport Code is the
3 letter code for the fifth destination airport

LAX

6th Operating Carrier

Character

2

IO

6th  Ticketed Carrier

Character

2

IO

6th Fare Basis Code

Character

1

G

7th Airport Code

Character

3

7th Airport Code is the
3 letter code for the sixth destination airport.

BOS

7th Operating Carrier

Character

2

OH

7th  Ticketed Carrier

Character

2

DL

7th Fare Basis Code

Character

1

G

8th Airport Code

Character

3

8th Airport Code is the
3 letter code for the seventh destination airport, and in this example,
the final destination for this ticket

DCA

8th Operating Carrier

Character

2

If 23
coupons have to be recorded, then the format continues as follows:

EV

8th  Ticketed Carrier

Character

2

DL

8th Fare Basis Code

Character

1

X

9th Airport Code

Character

3

9th Airport Code is the
3 letter code for the eight  destination airport, and in this
example, the final destination for this ticket

CLT

9th Operating Carrier

Character

2

YV

9th  Ticketed Carrier

Character

2

YV

9th Fare Basis Code

Character

1

X

10th Airport Code

Character

3

10th Airport Code is
the 3 letter code for the ninth destination airport, and in this example,
the final destination for this ticket

ATL

10th Operating Carrier

Character

2

FL

10th  Ticketed
Carrier

Character

2

FL

10th Fare Basis Code

Character

1

Y

11th Airport Code

Character

3

11th Airport Code is
the 3 letter code for the tenth destination airport, and in this example,
the final destination for this ticket

MIA

11th Operating Carrier

Character

2

MQ

11th  Ticketed
Carrier

Character

2

AA

11th Fare Basis Code

Character

1

G

12th Airport Code

Character

3

12th Airport Code is
the 3 letter code for the eleventh destination airport, and in this
example, the final destination for this ticket

FLL

12th Operating Carrier

Character

2

NK

12th  Ticketed
Carrier

Character

2

NK

12th Fare Basis Code

Character

1

X

13th Airport Code

Character

3

13th Airport
Code is the 3 letter code for the twelfth destination airport, and in this
example, the final destination for this ticket

FMY

13th Operating Carrier

Character

2

NK

13th  Ticketed
Carrier

Character

2

NK

13th Fare Basis Code

Character

1

X

14th Airport Code

Character

3

14th Airport Code is
the 3 letter code for the thirteenth destination airport, and in this
example, the final destination for this ticket

ATL

14th Operating Carrier

Character

2

EV

14th  Ticketed
Carrier

Character

2

DL

14th Fare Basis Code

Character

1

Y

15th Airport Code

Character

3

15th Airport Code is
the 3 letter code for the fourteenth destination airport, and in this
example, the final destination for this ticket

LAS

15th Operating Carrier

Character

2

SY

15th  Ticketed
Carrier

Character

2

SY

15th Fare Basis Code

Character

1

Y

16th Airport Code

Character

3

16th Airport Code is
the 3 letter code for the fifteenth destination airport, and in this
example, the final destination for this ticket

SAN

16th Operating Carrier

Character

2

XE

16th Ticketed Carrier

Character

2

CO

16th Fare Basis Code

Character

1

y

17th Airport Code

Character

3

17th Airport Code is
the 3 letter code for the sixteenth destination airport, and in this
example, the final destination for this ticket

MEX

17th Operating Carrier

Character

2

AM

17th Ticketed

Character

2

MX

17th Fare Basis Code

Character

1

Y

18th Airport Code

Character

3

18th Airport Code is
the 3 letter code for the seventeenth destination airport, and in this
example, the final destination for this ticket

LIM

18th Operating Carrier

Character

2

AA

18th  Ticketed
Carrier

Character

2

AA

18th Fare Basis Code

Character

1

y

19th Airport Code

Character

3

19th Airport Code is
the 3 letter code for the eighteenth destination airport, and in this
example, the final destination for this ticket

MEX

19th Operating Carrier

Character

2

MX

19th  Ticketed
Carrier

Character

2

MX

19th Fare Basis Code

Character

1

Y

20th Airport Code

Character

3

20th Airport Code is
the 3 letter code for the nineteenth destination airport, and in this
example, the final destination for this ticket

LAX

20th Operating Carrier

Character

2

AA

20th  Ticketed
Carrier

Character

2

AA

20th Fare Basis Code

Character

1

G

21th Airport Code

Character

3

21th Airport Code is
the 3 letter code for the twentieth destination airport, and in this
example, the final destination for this ticket

PDX

21th Operating Carrier

Character

2

QX

21th  Ticketed
Carrier

Character

2

AS

21th Fare Basis Code

Character

1

G

22nd Airport Code

Character

3

22nd
Airport Code is the 3 letter code for the twenty-first destination
airport, and in this example, the final destination for this ticket

ANC

22nd Operating Carrier

Character

2

NW

22nd Ticketed Carrier

Character

2

AS

22nd Fare Basis Code

Character

1

Y

23rdrd Airport Code

Character

3

23rd
Airport Code is the 3 letter code for the twenty-second
destination airport, and in this example, the final destination for this
ticket

BNE

23rd Operating Carrier

Character

2

VA

23rd  Ticketed
Carrier

Character

2

VA

23rd  Fare Basis Code

Character

1

G

24th Airport Code

Character

3

24th Airport Code is
the 3 letter code for the twenty-third destination airport, and in this
example, the final destination for this ticket

SYD

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 – [email-masked].

REQUIREMENTS

RECORD DESCRIPTION:  Origin-Destination Survey Report – Foreign
Carriers

Field Description

Data Type

Length

Comments

Sample Data

Carrier code

Character

2

IATA code

XX

Year

Numeric

3

Date: YYQ Where
'09' = Year: 2009

Quarter: 4

094

Fare

Numeric

variable

Value of the
ticket in whole U.S. dollars($)

1234

Passenger Count

Numeric

variable

3

1st  Airport Code

Character

3

1st Airport Code is the
3 letter code for the first Origin airport

BOS

1st  Operating Carrier

Character

2

IATA Carrier
Code

IO

1st  Ticketed Carrier

Character

2

IATA Carrier
Code

XX

1st Fare Basis Code

Character

1

C -
Unrestricted Business Class D - Restricted Business Class F - Unrestricted
First Class G - Restricted First Class X - Restricted Coach Y -
Unrestricted Coach U - Unknown

G

2nd Airport Code

Character

3

2nd Airport Code is the
3 letter code for the first destination airport

LAX

2nd Operating Carrier

Character

2

VA

2nd Ticketed Carrier

Character

2

VA

2nd Fare Basis Code

Character

1

G

3rd  Airport Code

3rd Airport Code is the
3 letter code for the second destination airport

SYD

3rd Operating Carrier

Character

2

Surface
Segment Indicator – for Operating Carrier.

--

3rd Ticketed Carrier

Character

2

Surface
Segment Indicator – for Ticketed Carrier

--

3rd Fare Basis Code

Character

1

For surface
travel segment

4th Airport Code

Character

3

4thAirport Code is the
3 letter code for the third destination airport

CNS

4th Operating Carrier

Character

2

DJ

4th  Ticketed Carrier

Character

2

VA

4th Fare Basis Code

Character

1

G

5th Airport Code

Character

3

5th Airport Code is the
3 letter code for the fourth destination airport

BNE

5th Operating Carrier

Character

2

VA

5th  Ticketed Carrier

Character

2

VA

5th Fare Basis Code

Character

1

G

6th Airport Code

Character

3

6th Airport Code is the
3 letter code for the fifth destination airport

LAX

6th Operating Carrier

Character

2

IO

6th  Ticketed Carrier

Character

2

IO

6th Fare Basis Code

Character

1

G

7th Airport Code

Character

3

7th Airport Code is the
3 letter code for the sixth destination airport and in this example, the
final destination for this ticket

BOS

8th Airport Code

Character

3

8th Airport Code is the
3 letter code for the seventh destination airport, and in this example,
the final destination for this ticket

DCA

8th Operating Carrier

Character

2

If 23
coupons have to be recorded, then the format continues as follows:

EV

8th  Ticketed Carrier

Character

2

DL

8th Fare Basis Code

Character

1

X

9th Airport Code

Character

3

9th Airport Code is the
3 letter code for the eight  destination airport, and in this
example, the final destination for this ticket

CLT

9th Operating Carrier

Character

2

YV

9th  Ticketed Carrier

Character

2

YV

9th Fare Basis Code

Character

1

X

10th Airport Code

Character

3

10th Airport Code is
the 3 letter code for the ninth destination airport, and in this example,
the final destination for this ticket

ATL

10th Operating Carrier

Character

2

FL

10th  Ticketed
Carrier

Character

2

FL

10th Fare Basis Code

Character

1

Y

11th Airport Code

Character

3

11th Airport Code is
the 3 letter code for the tenth destination airport, and in this example,
the final destination for this ticket

MIA

11th Operating Carrier

Character

2

MQ

11th  Ticketed
Carrier

Character

2

AA

11th Fare Basis Code

Character

1

G

12th Airport Code

Character

3

12th Airport Code is
the 3 letter code for the eleventh destination airport, and in this
example, the final destination for this ticket

FLL

12th Operating Carrier

Character

2

NK

12th  Ticketed
Carrier

Character

2

NK

12th Fare Basis Code

Character

1

X

13th Airport Code

Character

3

13th Airport
Code is the 3 letter code for the twelfth destination airport, and in this
example, the final destination for this ticket

FMY

13th Operating Carrier

Character

2

NK

13th  Ticketed
Carrier

Character

2

NK

13th Fare Basis Code

Character

1

X

14th Airport Code

Character

3

14th Airport Code is
the 3 letter code for the thirteenth destination airport, and in this
example, the final destination for this ticket

ATL

14th Operating Carrier

Character

2

EV

14th  Ticketed
Carrier

Character

2

DL

14th Fare Basis Code

Character

1

Y

15th Airport Code

Character

3

15th Airport Code is
the 3 letter code for the fourteenth destination airport, and in this
example, the final destination for this ticket

LAS

15th Operating Carrier

Character

2

SY

15th  Ticketed
Carrier

Character

2

SY

15th Fare Basis Code

Character

1

Y

16th Airport Code

Character

3

16th Airport Code is
the 3 letter code for the fifteenth destination airport, and in this
example, the final destination for this ticket

SAN

16th Operating Carrier

Character

2

XE

16th Ticketed Carrier

Character

2

CO

16th Fare Basis Code

Character

1

y

17th Airport Code

Character

3

17th Airport Code is
the 3 letter code for the sixteenth destination airport, and in this
example, the final destination for this ticket

MEX

17th Operating Carrier

Character

2

AM

17th Ticketed

Character

2

MX

17th Fare Basis Code

Character

1

Y

18th Airport Code

Character

3

18th Airport Code is
the 3 letter code for the seventeenth destination airport, and in this
example, the final destination for this ticket

LIM

18th Operating Carrier

Character

2

AA

18th  Ticketed
Carrier

Character

2

AA

18th Fare Basis Code

Character

1

y

19th Airport Code

Character

3

19th Airport Code is
the 3 letter code for the eighteenth destination airport, and in this
example, the final destination for this ticket

MEX

19th Operating Carrier

Character

2

MX

19th  Ticketed
Carrier

Character

2

MX

19th Fare Basis Code

Character

1

Y

20th Airport Code

Character

3

20th Airport Code is
the 3 letter code for the nineteenth destination airport, and in this
example, the final destination for this ticket

LAX

20th Operating Carrier

Character

2

AA

20th  Ticketed
Carrier

Character

2

AA

20th Fare Basis Code

Character

1

G

21th Airport Code

Character

3

21th Airport Code is
the 3 letter code for the twentieth destination airport, and in this
example, the final destination for this ticket

PDX

21th Operating Carrier

Character

2

QX

21th  Ticketed
Carrier

Character

2

AS

21th Fare Basis Code

Character

1

G

22nd Airport Code

Character

3

22nd
Airport Code is the 3 letter code for the twenty-first destination
airport, and in this example, the final destination for this ticket

ANC

22nd Operating Carrier

Character

2

NW

22nd Ticketed Carrier

Character

2

AS

22nd Fare Basis Code

Character

1

Y

23rdrd Airport Code

Character

3

23rd
Airport Code is the 3 letter code for the twenty-second
destination airport, and in this example, the final destination for this
ticket

BNE

23rd Operating Carrier

Character

2

VA

23rd  Ticketed
Carrier

Character

2

VA

23rd  Fare Basis Code

Character

1

G

24th Airport Code

Character

3

24th Airport Code is
the 3 letter code for the twenty-third destination airport, and in this
example, the final destination for this ticket

SYD

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 – [email-masked].

REQUIREMENTS

RECORD DESCRIPTION:  ASQP – Monthly On-Time Data

Field Description

Data Type

Length

Comments

Sample Data

Carrier code

Character

2

IATA code

XX

Flight number

Character

4

1234

Origin airport code

Character

3

Airport code

DFW

Destination airport code

Character

3

Airport code

BNA

Date of flight operation

DATE

ccyymmdd

Year (CCYY)

20100301

Day of the week of flight operation

Numeric

1

Mon = 1, Sun =
7

1

Scheduled departure time as shown in
Official Airline Guide (OAG)

Numeric

4

24 hour
clock

0735

Scheduled departure time as shown in
CRS

Numeric

4

24 hour
clock

0735

Gate departure time (actual)

Numeric

4

24 hour
clock

0737

Scheduled arrival time

Numeric

4

24 hour
clock

0915

Scheduled arrival time per CRS

Numeric

4

24 hour
clock

0915

Gate arrival time (actual)

Numeric

4

24 hour
clock

1148

Difference between OAG and CRS scheduled
departure times

Numeric

4

In minutes – G
minus H (2 hours=120 min)

0

Difference between OAG and CRS scheduled
arrival times

Numeric

4

In minutes – J
minus K

0

Scheduled elapsed time

Numeric

4

In minutes – K
minus H

100

Gate-to-Gate Time

Numeric

4

In minutes – L
minus I

251

Departure delay time (actual minutes
CRS)

Numeric

4

In minutes – I
minus H

2

Arrival delay time (actual minutes
CRS)

Numeric

4

In minutes – L
minus K

153

Elapsed time difference (actual minutes
CRS)

Numeric

4

In minutes – P
minus O

151

Wheels-off time (actual)

Numeric

4

24 hour
clock

0753

Wheels-on time (actual)

Numeric

4

24 hour
clock

1141

Aircraft tail number

Character

6

N123XX

Cancellation code

Character

1

Values are A,
B, C, D

Minutes late for Delay Code E – Carrier
Caused

Numeric

4

In minutes

Minutes late for Delay Code F –
Weather

Numeric

4

In minutes

Minutes late for Delay Code G – National
Aviation System (NAS)

Numeric

4

In minutes

Minutes late for Delay Code H –
Security

Numeric

4

In minutes

Minutes late for Delay Code I – Late
Arriving Flight (Initial)

Numeric

4

In minutes

First gate departure time (actual)

Numeric

4

24 hour
clock

Total ground time away from gate

Numeric

4

In minutes

Longest ground time away from gate

Numeric

4

In minutes

Number of landings at diverted
airports

Numeric

1

1 to 5 for
diversions, 9 designates a fly return canceled flight

1

Diverted airport code 1

Character

3

Airport
code

MEM

Wheels-on time at diverted airport

Numeric

4

24 hour
clock

1005

Total ground time away from gate at
diverted airport

Numeric

4

In minutes

69

Longest ground time away from gate at
diverted airport

Numeric

4

In minutes

69

Wheels-off time (actual)  at
diverted airport

Numeric

4

24 hour
clock

1114

Aircraft tail number

Character

6

N234XX

Diverted airport code 2

Character

3

Airport
code

Wheels-on time at diverted airport

Numeric

4

24 hour
clock

Total ground time away from gate at
diverted airport

Numeric

4

In minutes

Longest ground time away from gate at
diverted airport

Numeric

4

In minutes

Wheels-off time (actual)  at
diverted airport

Numeric

4

24 hour
clock

Aircraft tail number

Character

6

Diverted airport code 3

Character

3

Airport
code

Wheels-on Time at Diverted Airport

Numeric

4

24 hour
clock

Total ground time away from gate at
diverted airport

Numeric

4

In minutes

Longest ground time away from gate at
diverted airport

Numeric

4

In minutes

Wheels-off time (actual)  at
diverted airport

Numeric

4

24 hour
clock

Aircraft tail number

Character

6

Diverted airport code 4

Character

3

Airport
code

Wheels-on time at diverted airport

Numeric

4

24 hour
clock

Total ground time away from gate at
diverted airport

Numeric

4

In minutes

Longest ground time away from gate at
diverted airport

Numeric

4

In minutes

Wheels-off time (actual)  at
diverted airport

Numeric

4

24 hour
clock

Aircraft tail number

Character

6

Diverted airport code 5

Character

3

Airport
code

Wheels-on time at diverted airport

Numeric

4

24 hour
clock

Total ground time away from gate at
diverted airport

Numeric

4

In minutes

Longest ground time away from gate at
diverted airport

Numeric

4

In minutes

Wheels-off time (actual)  at
diverted airport

Numeric

4

24 hour
clock

Aircraft tail number

Character

6

RECORD FORMAT:

The ASQP - On Time Data reports must be created as an electronic
"comma separated values" file, using ASCII text character encoding, for
uploading via the "eSubmit" application.

The comma separated values file MUST BE indicated when naming the file, by
using the letters [CSV] or [csv] following the file name, as the file name
extension.

The file name is flexible and may be determined by the individual air
carrier, but the comma separated values (csv) file format is required, as
outlined in the rule entitled, Submitting Airline Data via the
Internet.

The fields in the sample record shown below follow the same order as the
above record description, separated by commas, and saved with the file name
extension of .csv.

Suggested file name: XX201003-234ontime.csv

Sample Record Format:

XX,1234,DFW,BNA,20100301,1,0735,0735,0737,0915,0915,1148,0,0,100,251,2,153,151,0753,1141,N123XX,,,,,,,,,,1,MEM,1005,69,69,1114,N234XX,,,,,,,,,,,,,,,,,,,,,,,,,

PART 234 – ASQP

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 – [email-masked].

REQUIREMENTS

RECORD DESCRIPTION:  ASQP – Mishandled Baggage Report

Field Description

Data Type

Length

Comments

Sample Data

Carrier code

Character

2

Two letter IATA
code

XX

Year of Data

Numeric

4

Year (CCYY)

2010

Month of Data

Numeric

2

Month (MM)

03

Number of Domestic Scheduled Passengers
Enplaned

Numeric

Varies

8004000

Number of Mishandled Baggage Reports
Filed with Carrier

Numeric

Varies

35000

RECORD FORMAT:

The ASQP – Mishandled Baggage reports must be created as an electronic
"comma separated values" file, using ASCII text character encoding, for
uploading via the "eSubmit" application.

The comma separated values file MUST BE indicated when naming the file, by
using the letters [CSV] or [csv] following the file name, as the file name
extension.

The file name is flexible and may be determined by the individual air
carrier, but the comma separated values (csv) file format is required, as
outlined in the rule entitled, Submitting Airline Data via the
Internet.

The fields in the sample record shown below follow the same order as the
above record description, separated by commas, and saved with the file name
extension of .csv.

Suggested file name: XX201003-234mbr.csv

Sample Record Format:

XX,2010,03,8004000,35000

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 – [email-masked].

REQUIREMENTS

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

Field Description

Data Type

Length

Comments

Sample Data

Carrier Name

Character

30

Atlantic
Southeast

OAG Carrier Code

Character

2

Two Letter
Code

EV

Quarter Ended

Character

6

Quarter/Year

3Q2010

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.

Numeric

Varies

1177

(b) were not given such alternate
transportation.

Numeric

Varies

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.

Numeric

Varies

0

(b) substitution of smaller capacity
equipment.

Numeric

Varies

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.

Numeric

Varies

746

TOTAL NUMBER DENIED BOARDING
INVOLUNTARILY

Numeric

Varies

3281

Number of passengers denied boarding
involuntarily who actually received compensation.*

Numeric

Varies

*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.

Numeric

Varies

28566

Number of passengers accommodated in
another section of the aircraft: (a) Upgrades.

Numeric

Varies

0

(b) Downgrades.

Numeric

Varies

0

Total Boardings.

Numeric

Varies

25450773

Amount of compensation paid to
passengers who: (a) were denied boarding involuntarily and were given
alternate transportation within the meaning of §250.5.

Currency

Varies

407092

(b) were denied boarding involuntarily
and were not given alternate transportation.

Currency

Varies

480726

(c) volunteered for denied boarding.

Currency

Varies

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 – [email-masked].

REQUIREMENTS

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

Field Description

Data Type

Length

Comments

Sample Data

Schedule Item

Character

4

P01A

Carrier Code

Character

3

3Z

Entity Region

Character

1

D

Aircraft Type

Character

4

P-5.1,
P-5.2

0000,
9999

Account Code

Character

5

0014A,
10100

Frequency

Numeric

1

2

Year

Character

4

2010

Month

Character

2

12

Gain or Loss

Numeric

---

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 – [email-masked].

REQUIREMENTS

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

Field Description

Data Type

Length

Comments

Sample Data

Schedule Item

Character

4

P12A

Carrier Code

Character

3

3Z

Entity Region

Character

1

D

Aircraft Type

Character

4

Reported on
P-5.1, P-5.2 only

0000

Account Code

Character

5

0014A,
10100

Frequency

Numeric

1

2

Year

Character

4

2010

Month

Character

2

12

Gain or Loss

Numeric

---

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 –
[email-masked].

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 –
[email-masked].

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 –
[email-masked].

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 – [email-masked].

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 – [email-masked].

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 – [email-masked].

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 – [email-masked].

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 – [email-masked].

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 – [email-masked].

REQUIREMENTS

RECORD DESCRIPTION:  Form 41 Financials – DB10 Collection

Field Description

Data Type

Length

Comments

Sample Data

Schedule Item

Character

4

B010

Carrier Code

Character

3

3Z

Entity Region

Character

1

D

Aircraft Type

Character

4

(P-5.1,
P-5.2)

0000,
9999

Account Code

Character

5

0014A,
10100

Frequency

Numeric

1

2

Year

Character

4

2010

Month

Character

2

12

Gain or Loss

Numeric

---

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 – [email-masked].

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 – [email-masked].

REQUIREMENTS

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

Field Description

Data Type

Length

Comments

Sample Data

Form Type

Character

3

B-7

Air Carrier Code

Character

3

UA

Year

Numeric

ccyy

2010

Month Ended

Numeric

mm

12

Year of First Airframe Delivery

Numeric

ccyy

1989

Airframe Manufacturer Serial no.

Character

20

87654321

Date Acquired or Retired

Numeric

ccyymmdd

20090131

Acquisition or Retirement Code

Character

1

R or A

Airframe License Number

Character

8

N000XX

Number of Aircraft Engines
Acquired/Retired

Character

5

2 GE

Aircraft Type Code

Numeric

4

6141

Type, Model and Cabin Design

Character

25

Boeing
B-737-8 PAX

Usual Seat Configuration

Numeric

4

76

Acquired Cost or Capitalized Value

Numeric

15

12345678

Depr. Cost or Amortized Value

Numeric

15

23232323

Realization Value

Numeric

15

45454545

Acquired From / Disposition

Character

50

Sold to ABC
Leasing Inc

Owned/Lease Type

Character

1

O

Operating Status

Character

1

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 – [email-masked].

REQUIREMENTS

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

Field Description

Data Type

Length

Comments

Sample Data

Form Type

Character

4

B-43

Air Carrier Code

Character

3

UA

Year

Numeric

ccyy

2011

Month Ended

Numeric

mm

12

Year of First Airframe Delivery

Numeric

ccyy

2010

Airframe Manufacturer Serial no.

Character

20

1191

Airframe License Number

Character

8

N000XX

Date Acquired or Placed in Service

Numeric

ccyymmdd

20100101

Usual Seat Configuration

Numeric

4

124

Number of Aircraft Engines

Character

5

Engines by
Type

2 GE

Manufacturer

Character

50

Airbus
Industrie

Aircraft Type Code

Numeric

4

6981

Type, Model and Cabin Design

Character

25

A-319-PSGR

Available Capacity

Numeric

12

Capacity in
pounds

35100

Acquired Cost or Capitalized Value

Numeric

15

12345678

Allowance for Depr. or Amortization

Numeric

15

123456

Depr. Cost or Amortized Value

Numeric

15

23232323

Estimated Residual Value

Numeric

15

45454545

Est. Depreciation or Amortizable
Life

Numeric

3

300

Owned/Lease Type

Character

1

O

Operating Status

Character

1

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 – [email-masked].

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 Description

Data Type

Length

Comments

Sample Data

Airline ID

Character

5

DOT
Assigned

12345

Carrier Code

Character

3

IATA or DOT
Assigned

XX

Year of Data Included in the Report

Numeric

4

Year
(CCYY)

2010

Month of Quarter Ending Data Included in
the Report

Numeric

2

Month (MM)
Qtr 1 = 03    Qtr 3 = 09 Qtr 2 = 06    Qtr 4
= 12

03

Total PFC Liability at Beginning of
Period

Numeric

50

9999

Total Amount Collected in Trust for
Public Agencies

Numeric

50

9999

Total Amount Remitted to Public
Agencies

Numeric

50

9999

Adjustments

Numeric

50

Collection
Compensation, PFC Refunds

9999

Total PFC Liability at End of Period

Numeric

50

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 – [email-masked].

REQUIREMENTS

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

Field Description

Data Type

Length

Comments

Sample Data

Schedule Item

Character

4

P100

Carrier Code

Character

3

3Z

Entity Region

Character

1

D

Aircraft Type

Character

4

(P-5.1,
P-5.2)

0000

Account Code

Character

5

0014A,
10100

Frequency

Numeric

1

2

Year

Character

4

2010

Month

Character

2

12

Gain or Loss

Numeric

---

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 – [email-masked].

REQUIREMENTS

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

Field Description

Data Type

Length

Comments

Sample Data

Schedule Item

Character

2

Name of
Form

T8

Carrier code

Character

2

IATA code

XX

Airline ID

Numeric

5

Five digit
Cardecode

10579

Region

Numeric

3

Certificate
of Operations

418 or
401

Account Code

Numeric

5

Account

41990

Frequency

Numeric

1

Annual

4

Year of Data Included in the Report

Numeric

4

Year
(CCYY)

2010

Month of Data Included in the Report

Numeric

2

Month
(MM)

03

Data

Numeric

---

Actual data
value

3938455

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 – [email-masked].

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 – [email-masked].

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 Account

Total Receivable

Credit Limitation

Unpaid Balance

Age of Unpaid Balance In Days

Security 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 Description

Data Type

Length

Comments

Sample Data

Schedule Item

Varchar

4

Name of
Form

291A

Carrier code

Character

2

Two letter
IATA code

XX

Airline ID

Numeric

5

Five digit
Cardecode

10482

Account Code

Numeric

5

Account

41990

Frequency

Numeric

1

Annual

4

Year of Data Included in the Report

Numeric

4

Year
(CCYY)

2010

Month of Data Included in the Report

Numeric

2

Month
(MM)

03

Data

Numeric

---

Actual data
value

3484750

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

Data and
Statistics

Intermodal
Transportation Database

By
Mode

By
Region

By
Subject

Dictionary

Geospatial
Information

Search
Public Datasets

Databases

Help with Data

TranStats

Airport

Available
Seat-Miles

Carrier

Causes of
Flight Delays

Freight

Fuel cost and consumption

Load
Factor

Operating
Profit/Loss

Passengers

Subject Areas

Airlines
and Airports

Congestion

Connectivity

Economics
and Finance

Energy
and Environment

Freight
Data and Statistics

General

Geospatial
Information

International

Livability

Maritime
Program

Passenger
Travel

Safety

Survey
Results

Trending
and Forecasting

Library

Search
the Collections

FAQs

Ask a Librarian

BTS Publications

BTS Bookstore

External Links

News

Events

What's New

Upcoming Press
Releases

Policies and
Methods

Confidentiality
Policy

Laws and
Regulations

Scientific
Integrity

Statistical
Policy & Research

About BTS

Advisory
Council on Transportation Statistics

Jobs
and Internships

Organizational
Chart

BTS Programs

Contact Us

Office of the
Assistant Secretary for Research and Technology (OST-R) • U.S. Department of Transportation (US DOT)

1200 New Jersey Avenue, SE • Washington, DC 20590 •
800.853.1351 • E-mail
OST-R

Accessibility | Disclaimer | Fast Lane | FedStats | Freedom of
Information Act | No
FEAR Act | OIG Hotline | Privacy Policy | USA.gov | White
House

Plug-ins: PDF
Reader | Flash Player
| Excel
Viewer | PowerPoint
Viewer | Word
Viewer | WinZip

OST-R's privacy policies and procedures do not
necessarily apply to external web sites. We suggest contacting these sites
directly for information on their data collection and distribution
policies.