Directive 307 E-filing OND Instructions

Directive 307 E-filing O&D instructions.doc

Origin and Destination Survey

Directive 307 E-filing OND Instructions

OMB: 2139-0013

Document [doc]
Download: doc | pdf




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


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


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.


9

File Typeapplication/msword
File TitleeSubmit Record formats for Directive
Authormarianne.seguin
Last Modified ByUSDOT_User
File Modified2017-02-02
File Created2017-02-02

© 2024 OMB.report | Privacy Policy