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) |
|