PART 241 – Passenger Origin-Destination Survey Report
OMB NO: 2139-0001
EXPIRATION
DATE: 2/28/2017
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 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, James Bouse, OAI/BTS/OST-R, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – james.bouse@dot.gov.
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 |
4th Airport 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/2017
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 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, James Bouse, OAI/BTS/OST-R, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – James.Bouse@dot.gov.
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 |
4th Airport 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.
File Type | application/msword |
File Title | eSubmit Record formats for Directive |
Author | marianne.seguin |
Last Modified By | USDOT_User |
File Modified | 2017-02-02 |
File Created | 2017-02-02 |