Data Content
Spire’s Flight Report pulls key observed insights from the positional Tracking Stream API and enriches these with flight and aircraft information to deliver a concise, one-row-per-flight structure in csv format.
Developed specifically as a light and accessible dataset, the Flight Report in csv is designed to deliver all the key insights for each flight tracked by ADS-B globally. The Flight Report benefits from extensive development to Spire Aviation’s flight detection algorithm to produce a rich combination of ADS-B observations and also flight, aircraft, airline, airport, schedule and actual observed metadata in just one row.
Contents#
ADS-B position information#
The fields in this table are taken directly from ADS-B messages:
| Field | Type | Description | Example |
|---|---|---|---|
date | string | Date the flight started in UTC | 2023-02-02 |
callsign | string | Call sign | SWA9002 |
icao_address | string | Hexadecimal representation of ICAO 24-bit address | ABD994 |
Spire target update metadata#
The below fields provide additional information regarding the ADS-B messages received from each flight:
| Field | Type | Description | Example |
|---|---|---|---|
flight_id | ID | Unique internal flight identifier | 9bfe2152-471a-402d-9c07-07b2da25649c |
observation_start | timestamp | Flight start time based on best available ADS-B data. | 2023-02-02 14:45:00 UTC |
observation_end | timestamp | Flight end time based on best available ADS-B data. | 2023-02-02 18:00:00 UTC |
Aircraft Information#
The following fields are enhanced data and may be present in the record depending on availability:
| Field | Type | Description | Example |
|---|---|---|---|
ac_type_icao | string | Aircraft type (ICAO code) | B738 |
ac_type_name | string | Aircraft type name | Boeing 737-8H4 |
ac_role | string | Aircraft role | PAX |
tail_number | string | Aircraft Registration | N8627B |
airline_icao | string | Airline ICAO code | SWA |
airline_iata | string | Airline IATA code | WN |
airline_name | string | Airline commercial name | Southwest Airlines |
Flight Information#
The following fields are enhanced data and may be present in the record depending on availability:
| Field | Type | Description | Example |
|---|---|---|---|
flight_number | string | Flight number (IATA format) | WN9002 |
departure_airport_icao | string | Departure airport ICAO code | KRSW |
arrival_airport_icao | string | Arrival airport ICAO code | KMDW |
departure_airport_iata | string | Departure airport IATA code | RSW |
arrival_airport_iata | string | Arrival airport IATA code | MDW |
departure_airport_country | string | ISO country code on departure | US |
arrival_airport_country | string | ISO country code on arrival | US |
departure_scheduled_time | timestamp | Scheduled departure time | 2023-02-02 15:00:00 UTC |
departure_utc_offset | string | Departure airport timezone offset from UTC | -0500 |
arrival_scheduled_time | timestamp | Scheduled arrival time | 2023-02-02 17:40:00 UTC |
arrival_utc_offset | string | Arrival airport timezone offset from UTC | -0600 |
Flight Analytics#
The following fields are enhanced data and may be present in the record depending on availability:
| Field | Type | Description | Example |
|---|---|---|---|
takeoff_time | timestamp | Actual time of takeoff | 2023-02-02 15:10:00 UTC |
landing_time | timestamp | Actual time of landing | 2023-02-02 17:42:00 UTC |
Sample#
| date | flight_id | callsign | flight_number | icao_address | aircraft_type_icao | aircraft_type_name | aircraft_role | tail_number | airline_icao | airline_iata | airline_name | origin_airport_icao | destination_airport_icao | origin_airport_iata | destination_airport_iata | origin_airport_country | destination_airport_country | departure_scheduled_time | departure_utc_offset | arrival_scheduled_time | arrival_utc_offset | takeoff_time | landing_time |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01/07/2022 | 255b9c91-b32c-4485-a020-f927e2e1f5de | AAL2500 | AA2500 | ACE5BC | A321 | Airbus A321-231 | PAX | N930AU | AAL | AA | American Airlines | MKJS | KDFW | MBJ | DFW | US | US | 2022-07-01 15:17:00 UTC | -5.0 | 2022-07-01 19:13:00 UTC | -6.0 | 2022-07-01 15:31:00 UTC | 2022-07-01 18:55:00 UTC |
| 01/07/2022 | a8d7a53e-c997-4c17-bc66-049186acd13a | DLH33K | LH1114 | 3C6542 | A20N | Airbus A320-271N | PAX | D-AIJB | DLH | LH | Lufthansa | EDDF | LEMD | FRA | MAD | DE | ES | 2022-07-01 11:20:00 UTC | 1.0 | 2022-07-01 13:55:00 UTC | 1.0 | 2022-07-01 13:50:00 UTC | 2022-07-01 15:45:00 UTC |