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 Name | Sample Description |
---|---|
acmi-tracking.csv | Sample data for commercial aviation |
Column | Data Type | Data description | Key | Data Set | Join On |
---|---|---|---|---|---|
flight_id | varchar(255) | Spire internal unique flight ID. Random UUIDv4 sequence | Primary | ||
date | timestamp | Date of flight in UTC | |||
observation_start | timestamp | Movement observation start time, UTC | |||
observation_end | timestamp | Movement observation end time, UTC | |||
altitude_start | int4 | Altitude at observation start in feet | |||
altitude_end | int4 | Altitude at observation end in feet | |||
callsign | varchar(255) | Flight callsign | |||
takeoff_time | timestamp | Take off time, UTC | |||
landing_time | timestamp | Landing time, UTC | |||
origin_airport_icao | varchar(6) | Origin airport ICAO code | Foreign | Airports | Airport ICAO |
origin_airport_iata | varchar(3) | Origin airport IATA code | Foreign | Airports | Airport IATA |
destination_airport_icao | varchar(6) | Destination airport ICAO code | Foreign | Airports | Airport ICAO |
destination_airport_iata | varchar(3) | Destination airport IATA code | Foreign | Airports | Airport IATA |
speed_start | int4 | Speed at observation start in km/h | |||
speed_end | int4 | Speed at observation end in km/h | |||
duration | int4 | Flight duration formatted as hh:mm:ss, difference between landing time and take off time, NULL if one or both are not recorded | |||
max_time | timestamp | Maximum of all time stamps for a flight, UTC | |||
flight_type | varchar(20) | Indicator of special flight types (ferry, technical, training) | |||
regional_partnership | varchar(255) | Regional partnership name under which the flight is operated | Foreign | Regional Subsidiaries | Rel Subsidiary |
cargo_customer | varchar(255) | Name of cargo customer for whom the flights is operated | |||
callsign_icao | varchar(3) | Callsign Operator ICAO three-character code | |||
callsign_flight_number | varchar(4) | Callsign Operator flight number | |||
callsign_suffix | char(1) | Callsign Operator flight number suffix | |||
wet_lease_cha_code | varchar(5) | Wet-lease customer ch-aviation code (assigned by ch-aviation). Same as Operator ch-aviation codes, can be 2, 3, or 5 characters. | Foreign | Operators | Operator ch-a Code |
wet_lease_customer_name | varchar(255) | Wet-lease customer name | |||
id | int4 | Unique 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 set | Foreign | Aircraft | Aircraft ID |
cn | varchar(16) | Construction/Line Number | |||
msn | varchar(16) | Manufacturer Serial Number | |||
aircraft_variant | varchar(255) | Aircraft Variant designation (i.e. A321-200N) | Foreign | Aircraft Variants | variant_text |
ch_airline_code | varchar(5) | Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters. | Foreign | Operators | Operator ch-a Code |
airline_name | varchar(255) | Operator name | |||
icao | varchar(3) | Operator ICAO three-character code | |||
reg | varchar(16) | Aircraft Registration, blank if unknown or no longer registered | |||
hexcode | char(6) | ICAO 24-bit address/Mode-S hexcode | |||
seats_y | smallint(6) | Seats in Economy | |||
seats_yp | smallint(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_w | smallint(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_c | smallint(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_f | smallint(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_role | char(3) | Aircraft's primary role (PAX = Passenger, CAR = Cargo, QUI = Quick Change) |