Electronic Filing

Directive 307 E-filing OD instructions.doc

Passenger Origin-Destination Survey Report

Electronic Filing

OMB: 2139-0001

Document [doc]

Download: doc | pdf

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 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/RITA, 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
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	2	IATA Carrier Code	IO
1^st Ticketed Carrier	Character	2	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	2		VA
2^nd Ticketed Carrier	Character	2		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	2	Surface Segment Indicator – for Operating Carrier.	--
3^rd Ticketed Carrier	Character	2	Surface Segment Indicator – for Ticketed Carrier	--
3^rd Fare Basis Code	Character	1	For surface travel segment, leave the Fare Basis Code blank
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	2		DJ
4^th Ticketed Carrier	Character	2		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	2		VA
5^th Ticketed Carrier	Character	2		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	2		IO
6^th Ticketed Carrier	Character	2		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	2		OH
7^th Ticketed Carrier	Character	2		DL
7^th Fare Basis Code	Character	1		G
8^th Airport Code	Character	3	8^th Airport Code is the 3 letter code for the seventh destination airport, and in this example, the final destination for this ticket	DCA
8^th Operating Carrier	Character	2	If 23 coupons have to be recorded, then the format continues as follows:	EV
8^th Ticketed Carrier	Character	2		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, and in this example, the final destination for this ticket	CLT
9^th Operating Carrier	Character	2		YV
9^th Ticketed Carrier	Character	2		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, and in this example, the final destination for this ticket	ATL
10^th Operating Carrier	Character	2		FL
10^th Ticketed Carrier	Character	2		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, and in this example, the final destination for this ticket	MIA
11^th Operating Carrier	Character	2		MQ
11^th Ticketed Carrier	Character	2		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, and in this example, the final destination for this ticket	FLL
12^th Operating Carrier	Character	2		NK
12^th Ticketed Carrier	Character	2		NK
12^th Fare Basis Code	Character	1		X
13^th 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
13^th Operating Carrier	Character	2		NK
13^th Ticketed Carrier	Character	2		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, and in this example, the final destination for this ticket	ATL
14^th Operating Carrier	Character	2		EV
14^th Ticketed Carrier	Character	2		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, and in this example, the final destination for this ticket	LAS
15^th Operating Carrier	Character	2		SY
15^th Ticketed Carrier	Character	2		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, and in this example, the final destination for this ticket	SAN
16^th Operating Carrier	Character	2		XE
16^th Ticketed Carrier	Character	2		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, and in this example, the final destination for this ticket	MEX
17^th Operating Carrier	Character	2		AM
17^th Ticketed	Character	2		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, and in this example, the final destination for this ticket	LIM
18^th Operating Carrier	Character	2		AA
18^th Ticketed Carrier	Character	2		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, and in this example, the final destination for this ticket	MEX
19^th Operating Carrier	Character	2		MX
19^th Ticketed Carrier	Character	2		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, and in this example, the final destination for this ticket	LAX
20^th Operating Carrier	Character	2		AA
20^th Ticketed Carrier	Character	2		AA
20^th Fare Basis Code	Character	1		G
21^th Airport Code	Character	3	21^th Airport Code is the 3 letter code for the twentieth destination airport, and in this example, the final destination for this ticket	PDX
21^th Operating Carrier	Character	2		QX
21^th Ticketed Carrier	Character	2		AS
21^th Fare Basis Code	Character	1		G
22^nd 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
22^nd Operating Carrier	Character	2		NW
22nd Ticketed Carrier	Character	2		AS
22nd Fare Basis Code	Character	1		Y
23rd^rdAirport Code	Character	3	23^rd 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
23^rd Ticketed Carrier	Character	2		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, 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

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
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	2	IATA Carrier Code	IO
1^st Ticketed Carrier	Character	2	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	2		VA
2^nd Ticketed Carrier	Character	2		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	2	Surface Segment Indicator – for Operating Carrier.	--
3^rd Ticketed Carrier	Character	2	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	2		DJ
4^th Ticketed Carrier	Character	2		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	2		VA
5^th Ticketed Carrier	Character	2		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	2		IO
6^th Ticketed Carrier	Character	2		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 and in this example, the final destination for this ticket	BOS
8^th Airport Code	Character	3	8^th Airport Code is the 3 letter code for the seventh destination airport, and in this example, the final destination for this ticket	DCA
8^th Operating Carrier	Character	2	If 23 coupons have to be recorded, then the format continues as follows:	EV
8^th Ticketed Carrier	Character	2		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, and in this example, the final destination for this ticket	CLT
9^th Operating Carrier	Character	2		YV
9^th Ticketed Carrier	Character	2		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, and in this example, the final destination for this ticket	ATL
10^th Operating Carrier	Character	2		FL
10^th Ticketed Carrier	Character	2		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, and in this example, the final destination for this ticket	MIA
11^th Operating Carrier	Character	2		MQ
11^th Ticketed Carrier	Character	2		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, and in this example, the final destination for this ticket	FLL
12^th Operating Carrier	Character	2		NK
12^th Ticketed Carrier	Character	2		NK
12^th Fare Basis Code	Character	1		X
13^th 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
13^th Operating Carrier	Character	2		NK
13^th Ticketed Carrier	Character	2		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, and in this example, the final destination for this ticket	ATL
14^th Operating Carrier	Character	2		EV
14^th Ticketed Carrier	Character	2		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, and in this example, the final destination for this ticket	LAS
15^th Operating Carrier	Character	2		SY
15^th Ticketed Carrier	Character	2		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, and in this example, the final destination for this ticket	SAN
16^th Operating Carrier	Character	2		XE
16^th Ticketed Carrier	Character	2		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, and in this example, the final destination for this ticket	MEX
17^th Operating Carrier	Character	2		AM
17^th Ticketed	Character	2		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, and in this example, the final destination for this ticket	LIM
18^th Operating Carrier	Character	2		AA
18^th Ticketed Carrier	Character	2		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, and in this example, the final destination for this ticket	MEX
19^th Operating Carrier	Character	2		MX
19^th Ticketed Carrier	Character	2		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, and in this example, the final destination for this ticket	LAX
20^th Operating Carrier	Character	2		AA
20^th Ticketed Carrier	Character	2		AA
20^th Fare Basis Code	Character	1		G
21^th Airport Code	Character	3	21^th Airport Code is the 3 letter code for the twentieth destination airport, and in this example, the final destination for this ticket	PDX
21^th Operating Carrier	Character	2		QX
21^th Ticketed Carrier	Character	2		AS
21^th Fare Basis Code	Character	1		G
22^nd 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
22^nd Operating Carrier	Character	2		NW
22nd Ticketed Carrier	Character	2		AS
22nd Fare Basis Code	Character	1		Y
23rd^rdAirport Code	Character	3	23^rd 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
23^rd Ticketed Carrier	Character	2		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, 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 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	Kimberly.Webb
File Modified	2013-07-31
File Created	2013-07-31