BTS | e-Submit | PART 241 – Passenger Origin-Destination Survey Report

United States Department of Transportation

PART 241 – Passenger Origin-Destination Survey Report

REQUIREMENTS

RECORD DESCRIPTION: Origin-Destination Survey Report – Foreign Carriers

Field Description	Data Type	Maximum Length	Comments	Sample Data
Carrier code	Character	3	IATA code	XXX
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($)	1234
Passenger Count	Numeric	variable		3
1^st Airport Code	Character	3	1^st Airport Code is the 3 letter code for the first Origin airport	BOS
1^st Operating Carrier	Character	3	IATA Carrier Code	IO
1^st Ticketed Carrier	Character	3	IATA Carrier Code	XX
1^st 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
2^nd Airport Code	Character	3	2^nd Airport Code is the 3 letter code for the first destination airport	LAX
2^nd Operating Carrier	Character	3		VA
2^nd Ticketed Carrier	Character	3		VA
2^nd Fare Basis Code	Character	1		G
3^rd Airport Code			3^rd Airport Code is the 3 letter code for the second destination airport	SYD
3^rd Operating Carrier	Character	3	Surface Segment Indicator – for Operating Carrier.	--
3^rd Ticketed Carrier	Character	3	Surface Segment Indicator – for Ticketed Carrier	--
3^rd Fare Basis Code	Character	1	For surface travel segment
4^th Airport Code	Character	3	4^th Airport Code is the 3 letter code for the third destination airport	CNS
4^th Operating Carrier	Character	3		DJ
4^th Ticketed Carrier	Character	3		VA
4^th Fare Basis Code	Character	1		G
5^th Airport Code	Character	3	5^th Airport Code is the 3 letter code for the fourth destination airport	BNE
5^th Operating Carrier	Character	3		VA
5^th Ticketed Carrier	Character	3		VA
5^th Fare Basis Code	Character	1		G
6^th Airport Code	Character	3	6^th Airport Code is the 3 letter code for the fifth destination airport	LAX
6^th Operating Carrier	Character	3		IO
6^th Ticketed Carrier	Character	3		IO
6^th Fare Basis Code	Character	1		G
7^th Airport Code	Character	3	7^th Airport Code is the 3 letter code for the sixth destination airport	BOS
7^th Operating Carrier	Character	3		OH
7^th Ticketed Carrier	Character	3		DL
7^th Fare Basis Code	Character	1		X
8^th Airport Code	Character	3	8^th Airport Code is the 3 letter code for the seventh destination airport	DCA
8^th Operating Carrier	Character	3		EV
8^th Ticketed Carrier	Character	3		DL
8^th Fare Basis Code	Character	1		X
9^th Airport Code	Character	3	9^th Airport Code is the 3 letter code for the eight destination airport	CLT
9^th Operating Carrier	Character	3		YV
9^th Ticketed Carrier	Character	3		YV
9^th Fare Basis Code	Character	1		X
10^th Airport Code	Character	3	10^th Airport Code is the 3 letter code for the ninth destination airport	ATL
10^th Operating Carrier	Character	3		FL
10^th Ticketed Carrier	Character	3		FL
10^th Fare Basis Code	Character	1		Y
^11th Airport Code	Character	3	11^th Airport Code is the 3 letter code for the tenth destination airport	MIA
11^th Operating Carrier	Character	3		MQ
11^th Ticketed Carrier	Character	3		AA
11^th Fare Basis Code	Character	1		G
12^th Airport Code	Character	3	12^th Airport Code is the 3 letter code for the eleventh destination airport	FLL
12^th Operating Carrier	Character	3		NK
12^th Ticketed Carrier	Character	3		NK
12^th Fare Basis Code	Character	1		X
13^th Airport Code	Character	3	13^th Airport Code is the 3 letter code for the twelfth destination airport	FMY
13^th Operating Carrier	Character	3		NK
13^th Ticketed Carrier	Character	3		NK
13^th Fare Basis Code	Character	1		X
14^th Airport Code	Character	3	14^th Airport Code is the 3 letter code for the thirteenth destination airport	ATL
14^th Operating Carrier	Character	3		EV
14^th Ticketed Carrier	Character	3		DL
14^th Fare Basis Code	Character	1		Y
15^th Airport Code	Character	3	15^th Airport Code is the 3 letter code for the fourteenth destination airport	LAS
15^th Operating Carrier	Character	3		SY
15^th Ticketed Carrier	Character	3		SY
15^th Fare Basis Code	Character	1		Y
16^th Airport Code	Character	3	16^th Airport Code is the 3 letter code for the fifteenth destination airport	SAN
16^th Operating Carrier	Character	3		XE
16^th Ticketed Carrier	Character	3		CO
16^th Fare Basis Code	Character	1		y
17^th Airport Code	Character	3	17^th Airport Code is the 3 letter code for the sixteenth destination airport	MEX
17^th Operating Carrier	Character	3		AM
17^th Ticketed	Character	3		MX
17^th Fare Basis Code	Character	1		Y
18^th Airport Code	Character	3	18^th Airport Code is the 3 letter code for the seventeenth destination airport	LIM
18^th Operating Carrier	Character	3		AA
18^th Ticketed Carrier	Character	3		AA
18^th Fare Basis Code	Character	1		Y
19^th Airport Code	Character	3	19^th Airport Code is the 3 letter code for the eighteenth destination airport	MEX
19^th Operating Carrier	Character	3		MX
19^th Ticketed Carrier	Character	3		MX
19^th Fare Basis Code	Character	1		Y
20^th Airport Code	Character	3	20^th Airport Code is the 3 letter code for the nineteenth destination airport	LAX
20^th Operating Carrier	Character	3		AA
20^th Ticketed Carrier	Character	3		AA
20^th Fare Basis Code	Character	1		G
21^stAirport Code	Character	3	21^st Airport Code is the 3 letter code for the twentieth destination airport	PDX
21^st Operating Carrier	Character	3		QX
21^st Ticketed Carrier	Character	3		AS
21^st Fare Basis Code	Character	1		G
22^nd Airport Code	Character	3	22^nd Airport Code is the 3 letter code for the twenty-first destination airport	ANC
22^nd Operating Carrier	Character	3		NW
22^nd Ticketed Carrier	Character	3		AS
22^nd Fare Basis Code	Character	1		Y
23^rdAirport Code	Character	3	23^rd Airport Code is the 3 letter code for the twenty-second destination airport	BNE
23^rd Operating Carrier	Character	3		VA
23^rd Ticketed Carrier	Character	3		VA
23^rd Fare Basis Code	Character	1		G
24^th Airport Code	Character	3	24^th Airport Code is the 3 letter code for the twenty-third destination airport	SYD

Field Description

Data Type

Maximum Length

Comments

Sample Data

Carrier code

Character

IATA code

XXX

Year

Numeric

Year: CCYY
Where CCYY = 2009

2009

Quarter

Numeric

Quarter: Q
Values = 1, 2, 3, 4
Where ‘1’ = First Quarter of Year

Fare

Numeric

variable

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

1234

Passenger Count

Numeric

variable

1^st Airport Code

Character

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

BOS

1^st Operating Carrier

Character

IATA Carrier Code

1^st Ticketed Carrier

Character

IATA Carrier Code

1^st Fare Basis Code

Character

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

2^nd Airport Code

Character

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

LAX

2^nd Operating Carrier

Character

2^nd Ticketed Carrier

Character

2^nd Fare Basis Code

Character

3^rd Airport Code

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

SYD

3^rd Operating Carrier

Character

Surface Segment Indicator – for Operating Carrier.

3^rd Ticketed Carrier

Character

Surface Segment Indicator – for Ticketed Carrier

3^rd Fare Basis Code

Character

For surface travel segment

4^th Airport Code

Character

4^th Airport Code is the 3 letter code for the third destination airport

CNS

4^th Operating Carrier

Character

4^th Ticketed Carrier

Character

4^th Fare Basis Code

Character

5^th Airport Code

Character

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

BNE

5^th Operating Carrier

Character

5^th Ticketed Carrier

Character

5^th Fare Basis Code

Character

6^th Airport Code

Character

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

LAX

6^th Operating Carrier

Character

6^th Ticketed Carrier

Character

6^th Fare Basis Code

Character

7^th Airport Code

Character

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

BOS

7^th Operating Carrier

Character

7^th Ticketed Carrier

Character

7^th Fare Basis Code

Character

8^th Airport Code

Character

8^th Airport Code is the 3 letter code for the seventh destination airport

DCA

8^th Operating Carrier

Character

8^th Ticketed Carrier

Character

8^th Fare Basis Code

Character

9^th Airport Code

Character

9^th Airport Code is the 3 letter code for the eight destination airport

CLT

9^th Operating Carrier

Character

9^th Ticketed Carrier

Character

9^th Fare Basis Code

Character

10^th Airport Code

Character

10^th Airport Code is the 3 letter code for the ninth destination airport

ATL

10^th Operating Carrier

Character

10^th Ticketed Carrier

Character

10^th Fare Basis Code

Character

^11th Airport Code

Character

11^th Airport Code is the 3 letter code for the tenth destination airport

MIA

11^th Operating Carrier

Character

11^th Ticketed Carrier

Character

11^th Fare Basis Code

Character

12^th Airport Code

Character

12^th Airport Code is the 3 letter code for the eleventh destination airport

FLL

12^th Operating Carrier

Character

12^th Ticketed Carrier

Character

12^th Fare Basis Code

Character

13^th Airport Code

Character

13^th Airport Code is the 3 letter code for the twelfth destination airport

FMY

13^th Operating Carrier

Character

13^th Ticketed Carrier

Character

13^th Fare Basis Code

Character

14^th Airport Code

Character

14^th Airport Code is the 3 letter code for the thirteenth destination airport

ATL

14^th Operating Carrier

Character

14^th Ticketed Carrier

Character

14^th Fare Basis Code

Character

15^th Airport Code

Character

15^th Airport Code is the 3 letter code for the fourteenth destination airport

LAS

15^th Operating Carrier

Character

15^th Ticketed Carrier

Character

15^th Fare Basis Code

Character

16^th Airport Code

Character

16^th Airport Code is the 3 letter code for the fifteenth destination airport

SAN

16^th Operating Carrier

Character

16^th Ticketed Carrier

Character

16^th Fare Basis Code

Character

17^th Airport Code

Character

17^th Airport Code is the 3 letter code for the sixteenth destination airport

MEX

17^th Operating Carrier

Character

17^th Ticketed

Character

17^th Fare Basis Code

Character

18^th Airport Code

Character

18^th Airport Code is the 3 letter code for the seventeenth destination airport

LIM

18^th Operating Carrier

Character

18^th Ticketed Carrier

Character

18^th Fare Basis Code

Character

19^th Airport Code

Character

19^th Airport Code is the 3 letter code for the eighteenth destination airport

MEX

19^th Operating Carrier

Character

19^th Ticketed Carrier

Character

19^th Fare Basis Code

Character

20^th Airport Code

Character

20^th Airport Code is the 3 letter code for the nineteenth destination airport

LAX

20^th Operating Carrier

Character

20^th Ticketed Carrier

Character

20^th Fare Basis Code

Character

21^stAirport Code

Character

21^st Airport Code is the 3 letter code for the twentieth destination airport

PDX

21^st Operating Carrier

Character

21^st Ticketed Carrier

Character

21^st Fare Basis Code

Character

22^nd Airport Code

Character

22^nd Airport Code is the 3 letter code for the twenty-first destination airport

ANC

22^nd Operating Carrier

Character

22^nd Ticketed Carrier

Character

22^nd Fare Basis Code

Character

23^rdAirport Code

Character

23^rd Airport Code is the 3 letter code for the twenty-second destination airport

BNE

23^rd Operating Carrier

Character

23^rd Ticketed Carrier

Character

23^rd Fare Basis Code

Character

24^th Airport Code

Character

24^th 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-FOND.csv

Sample Record Format:

ZZ,2010,2,1151,1,ABQ,ZZ,UA,X,LAX,ZZ,AA,X,AKL,ZZ,ZZ,X,LAX,UA,UA,X,ABQ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
ZZ,2010,2,1297,1,ABQ,ZZ,UA,X,LAX,ZZ,NZ,X,AKL,ZZ,LH,X,CHC,CO,ZZ,X,EWR,--,--, ,JFK,UA,UA,X,ABQ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

NOTE:

The second itinerary in the sample record format above indicates a surface segment between EWR and JFK.

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.

USA Banner

Site Notification

Site Notification

PART 241 – Passenger Origin-Destination Survey Report