FieldTypeDescriptionExample
ORGVARCHAR(10)Origin airport code (ICAO code, if any)KVNY
ORG_IATAVARCHAR(10)Origin airport IATA code, if anyVNY
O_CITYVARCHAR(50)Origin cityVan Nuys
O_TIMEZONEVARCHAR(50)Origin time zoneAmerica/Los_Angeles
O_STATEVARCHAR(50)Origin state code, if anyCA
O_COUNTRYVARCHAR(50)Origin country codeUS
DSTVARCHAR(10)Destination airport code (ICAO code, if any)KTEB
DST_IATAVARCHAR(10)Destination airport IATA code, if anyTEB
D_CITYVARCHAR(50)Destination cityTeterboro
D_TIMEZONEVARCHAR(50)Destination time zoneAmerica/New_York
D_STATEVARCHAR(50)Destination state code, if anyNJ
D_COUNTRYVARCHAR(50)Destination country codeUS
AIRLINEVARCHAR(4)Carrier code (XXX for private flights)LXJ
AL_NAMEVARCHAR(15000)Carrier name, if anyFlexjet LLC
AIRCRAFT_IDVARCHAR(20)Call sign of tail number of the aircraftLXJ414
FLIGHT_NOVARCHARFlight number, if any414
AIRCRAFT_TYPEVARCHAR(10)ICAO aircraft type codeE545
AC_CATEGORYVARCHAR(26)ICAO aircraft categoryJet_M
AIRCRAFT_CATEGORYVARCHAR(50)Business aviation aircraft categorySuper Midsize Jet
SEATSNUMBERNumber of seats9
DEPARTURE_UTCTIMESTAMPDeparture time in UTC time2021-01-01 17:02:00
ARRIVAL_UTCTIMESTAMPArrival time in UTC time2021-01-01 21:47:06
LOCAL_DATEDATEDeparture date in local time2021-01-01
DOWVARCHAR(3)Day of week in local timeFri
GATE_DEPARTURETIMESTAMPDeparture time from gate, if any
DEPARTURETIMESTAMPDeparture time in local time2021-01-01 09:02:00
ARRIVALTIMESTAMPArrival time in local time2021-01-01 16:47:06
SCHEDULED_ORGVARCHAR(10)Scheduled origin airport code, if different from the actual origin airport
SCHEDULED_DSTVARCHAR(10)Scheduled destination airport code, if different from the actual destination airport
FLIGHT_MINUTESNUMBERMinutes of flight time285
BLOCK_MINUTESNUMBERMinutes of block time, which equals taxi-out time + flight time + taxi-in time 292
TAXI_INNUMBERMinutes from run-way wheels down to the gate2
TAXI_OUTNUMBERMinutes from the gate to run-way wheels up5
MILESDOUBLEMiles between the origin airport and the destination airport2450
SOURCEVARCHAR(11)Specific data channel from FAATFMS