ACMI Tracking

To access the full sample data set on Amazon Web Services manually or programmatically, the S3 bucket URLs are provided here.

To get user name and password for manual access or access key and secret key for programmatic access, contact sales@ch-aviation.com.

 

Sample File NameSample Description
acmi-tracking.csvSample data for commercial aviation
ColumnData TypeData descriptionKeyData SetJoin On
flight_idvarchar(255)Spire internal unique flight ID. Random UUIDv4 sequencePrimary
datetimestampDate of flight in UTC
observation_starttimestampMovement observation start time, UTC
observation_endtimestampMovement observation end time, UTC
altitude_startint4Altitude at observation start in feet
altitude_endint4Altitude at observation end in feet
callsignvarchar(255)Flight callsign
takeoff_timetimestampTake off time, UTC
landing_timetimestampLanding time, UTC
origin_airport_icaovarchar(6)Origin airport ICAO codeForeignAirportsAirport ICAO
origin_airport_iatavarchar(3)Origin airport IATA codeForeignAirportsAirport IATA
destination_airport_icaovarchar(6)Destination airport ICAO codeForeignAirportsAirport ICAO
destination_airport_iatavarchar(3)Destination airport IATA codeForeignAirportsAirport IATA
speed_startint4Speed at observation start in km/h
speed_endint4Speed at observation end in km/h
durationint4Flight duration formatted as hh:mm:ss, difference between landing time and take off time, NULL if one or both are not recorded
max_timetimestampMaximum of all time stamps for a flight, UTC
flight_typevarchar(20)Indicator of special flight types (ferry, technical, training)
regional_partnershipvarchar(255)Regional partnership name under which the flight is operatedForeignRegional SubsidiariesRel Subsidiary
cargo_customervarchar(255)Name of cargo customer for whom the flights is operated
callsign_icaovarchar(3)Callsign Operator ICAO three-character code
callsign_flight_numbervarchar(4)Callsign Operator flight number
callsign_suffixchar(1)Callsign Operator flight number suffix
wet_lease_cha_codevarchar(5)Wet-lease customer ch-aviation code (assigned by ch-aviation). Same as Operator ch-aviation codes, can be 2, 3, or 5 characters.ForeignOperatorsOperator ch-a Code
wet_lease_customer_namevarchar(255)Wet-lease customer name
idint4Unique ch-aviation created aircraft ID, remains stable throughout an aircraft's life (assigned by ch-aviation), the aircraft_id and date_from_full fields are the combined primary key of the Aircraft Histories data setForeignAircraftAircraft ID
cnvarchar(16)Construction/Line Number
msnvarchar(16)Manufacturer Serial Number
aircraft_variantvarchar(255)Aircraft Variant designation (i.e. A321-200N)ForeignAircraft Variantsvariant_text
ch_airline_codevarchar(5)Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters.ForeignOperatorsOperator ch-a Code
airline_namevarchar(255)Operator name
icaovarchar(3)Operator ICAO three-character code
regvarchar(16)Aircraft Registration, blank if unknown or no longer registered
hexcodechar(6)ICAO 24-bit address/Mode-S hexcode
seats_ysmallint(6)Seats in Economy
seats_ypsmallint(6)Seats in Economy Plus/Comfort, ch-aviation applies the following methodology for Economy Plus/Comfort vs. Premium Economy aircraft seat configurations/capacity calculations to ensure comparability across all carriers worldwide: ch-aviation only considers cabins to be Premium Economy if the maximum number of seats per row (Max Abreast) is at least 2 seats less than the maximum number of seats that could physically be fitted in Economy Class for the aircraft type (i.e. 10 for a B777) no matter what the actual maximum abreast configuration on that aircraft is.
seats_wsmallint(6)Seats in Premium Economy, ch-aviation applies the following methodology for Economy Plus/Comfort vs. Premium Economy aircraft seat configurations/capacity calculations to ensure comparability across all carriers worldwide: ch-aviation only considers cabins to be Premium Economy if the maximum number of seats per row (Max Abreast) is at least 2 seats less than the maximum number of seats that could physically be fitted in Economy Class for the aircraft type (i.e. 10 for a B777) no matter what the actual maximum abreast configuration on that aircraft is.
seats_csmallint(6)Seats in Business, ch-aviation applies the following methodology for Business vs. First aircraft seat configurations/capacity calculations to ensure comparability across all carriers worldwide: ch-aviation only considers narrowbody cabins to be First Class if the maximum number of seats per row (Max Abreast) is 2 and widebody cabins to be First Class if the maximum number of seats across per row is 4 (unless there is a Business and First Class cabin installed on the aircraft and the First Class cabin has more than 4 seats across per row in these exceptional cases).
seats_fsmallint(6)Seats in First, ch-aviation applies the following methodology for Business vs. First aircraft seat configurations/capacity calculations to ensure comparability across all carriers worldwide: ch-aviation only considers narrowbody cabins to be First Class if the maximum number of seats per row (Max Abreast) is 2 and widebody cabins to be First Class if the maximum number of seats across per row is 4 (unless there is a Business and First Class cabin installed on the aircraft and the First Class cabin has more than 4 seats across per row in these exceptional cases).
aircraft_rolechar(3)Aircraft's primary role (PAX = Passenger, CAR = Cargo, QUI = Quick Change)