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.
Name
Description
Type
year
Data Year
char(4)
month
Data Month
char(2)
origin
OriginAirport 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
DestinationAirport 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