On-Flight Market Records
The On-Flight Market Records are data on where passengers, freight and mail
commenced and ended their flight. A change in Flight number begins a new on-flight
record.
| year |
Data Year |
char(4) |
| month |
Data Month |
char(2) |
| origin |
Origin
Airport Code (code is either
OAG or OAI assigned) |
char(3) |
| origin_ id |
Origin Numeric
Id (OAI assigned) |
char(5) |
| origin_wac |
Origin World
Area Code (Alaska = “001”) |
char(3) |
| origin_city_name |
Origin Airport/City
Name |
char(35) |
| dest |
Destination
Airport Code (code is either
OAG or OAI assigned) |
char(3) |
| dest_id |
Destination
Numeric Id |
char(5) |
| dest_wac |
Destination
World Area Code (Alaska =
“001”) |
char(3) |
| dest_city_name |
Destination
Airport/City Name |
char(35) |
| carrier_code |
Carrier Code
(code is either IATA or OAI assigned) |
char(3) |
| entity_code |
OAI assigned
– unique code |
char(5) |
| group |
Group Code
classifies the US air carriers by the amount of total operating revenue
for the previous year.
- Regional Carriers – 1 (Includes Large, Medium, Commuter, Small Certificated)
- National Carriers – 2
- Major Carriers – 3
|
char(1) |
| dist |
The great circle
distance in statute miles between the Origin & Destination airports |
int |
| svc_class |
The Service
Class Code refers to the class of service used:
- F-Scheduled Passenger/Cargo Service
- G-Scheduled All Cargo Service
|
char(1) |
| passengers |
Number of Passengers
originating (enplaning) the flight at the origin airport and terminating
(deplaning) the flight at the destination airport. |
int |
| pax_first |
* Ignore this
field. First, Middle and Coach Passenger data are not identified for US
air carriers operating in domestic markets. |
int |
| pax_middle |
* Ignore this
field. |
int |
| pax_coach |
* Ignore this
field. |
int |
| freight |
Revenue Freight
in pounds originating (enplaning) the flight at the origin airport and terminating
(deplaning) the flight at the destination airport. |
int |
| mail |
Revenue Mail
in pounds originating (enplaning) the flight at the origin airport and terminating
(deplaning) the flight at the destination airport. |
int |
| type |
The Type identifies
that the points involved are DD=Domestic<>Domestic |
char(2) |
|
