d o t logoUnited States Department of Transportation

  OST-R > BTS
ESubmit User Guide Report Formats Manage Profile Contact OAI FAQ Log Out

PART 241 – Passenger Origin-Destination Survey Report

PDF

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, James Bouse, email: OAI.ICCO@dot.gov, OAI/BTS, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590

REQUIREMENTS

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

Field Description Data Type Length Comments Sample Data
Carrier code Character 3 IATA code RI
Year Numeric 4 Year: CCYY
Where CCYY = 2009
2009
Quarter Numeric 1 Quarter: Q
Values = 1, 2, 3, 4
Where ‘1’ = First Quarter of Year
1
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 3 IATA Carrier Code RI
1st Ticketed Carrier Character 3 IATA Carrier Code IR
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 3 AI
2nd Ticketed Carrier Character 3 AU
2nd Fare Basis Code Character 1 G
3rd Airport Code 3 3rd Airport Code is the 3 letter code for the second destination airport SYD
3rd Operating Carrier Character 3 Surface Segment Indicator – for Operating Carrier. --
3rd Ticketed Carrier Character 3 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 4th Airport Code is the 3 letter code for the third destination airport CNS
4th Operating Carrier Character 3 DJ
4th Ticketed Carrier Character 3 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 3 VA
5th Ticketed Carrier Character 3 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 3 IO
6th Ticketed Carrier Character 3 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 3 OH
7th Ticketed Carrier Character 3 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. DCA
8th Operating Carrier Character 3   EV
8th Ticketed Carrier Character 3 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. CLT
9th Operating Carrier Character 3 YV
9th Ticketed Carrier Character 3 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. ATL
10th Operating Carrier Character 3 FL
10th Ticketed Carrier Character 3 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. MIA
11th Operating Carrier Character 3 MQ
11th Ticketed Carrier Character 3 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. FLL
12th Operating Carrier Character 3 NK
12th Ticketed Carrier Character 3 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. FMY
13th Operating Carrier Character 3 NK
13th Ticketed Carrier Character 3 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. ATL
14th Operating Carrier Character 3 EV
14th Ticketed Carrier Character 3 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. LAS
15th Operating Carrier Character 3 SY
15th Ticketed Carrier Character 3 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. SAN
16th Operating Carrier Character 3 XE
16th Ticketed Carrier Character 3 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. MEX
17th Operating Carrier Character 3 AM
17th Ticketed Character 3 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. LIM
18th Operating Carrier Character 3 AA
18th Ticketed Carrier Character 3 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. MEX
19th Operating Carrier Character 3 MX
19th Ticketed Carrier Character 3 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. LAX
20th Operating Carrier Character 3 AA
20th Ticketed Carrier Character 3 AA
20th Fare Basis Code Character 1 G
21st Airport Code Character 3 21st Airport Code is the 3 letter code for the twentieth destination airport. PDX
21st Operating Carrier Character 3 QX
21st Ticketed Carrier Character 3 AS
21st 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. ANC
22nd Operating Carrier Character 3 NW
22nd Ticketed Carrier Character 3 AS
22nd Fare Basis Code Character 1 Y
23rd Airport Code Character 3 23rd Airport Code is the 3 letter code for the twenty-second destination airport. BNE
23rd Operating Carrier Character 3 VA
23rd Ticketed Carrier Character 3 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. 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,2009,1,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 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.