Commercial Aviation Analytics Set (EU)
AVICOM915· 4.9M records · 28 tables · v2.4.0 · Updated 2026-08-20
Freight & Logistics Commercial Aviation Dataset API
Overview
This longitudinal commercial aviation analytics set connects airline, fleet, route, flight, ticket, ancillary, operating, maintenance, safety, passenger-experience, rating, financial, profitability and demand-forecast data. It separates modelled observations, estimates and projections and preserves feature-source cutoffs for time-aware predictive evaluation. Real geography and official standards provide context only. Commercial entities, people, assets, transactions, measurements and financial values are modelled.
Analytics
Four entries from the packaged tables, with the performance the dataset records for them. Every value below is read from the shipped files.
737-800B738Aurelian Airways
248.3kFlights
533.0kBlock hours
32.3MPassengers
80.3%Load factor
75.7%On-time
0/14Retired
Revenue, cost and gross profit, million USDGross profitRevenueCost
1 / 4
Row Counts by Table
Counted from the files that ship, not estimated.
| Table | Rows |
|---|---|
| eu_aviation_years | 12 |
| eu_aviation_countries | 8 |
| eu_aviation_airlines | 11 |
| eu_aviation_airports | 24 |
| eu_aviation_aircraft_models | 8 |
| eu_aviation_aircraft | 78 |
| eu_aviation_aircraft_media | 12 |
| eu_aviation_routes | 48 |
| eu_aviation_fare_products | 4 |
| eu_aviation_flights | 235,810 |
| eu_aviation_tickets | 174,294 |
| eu_aviation_ancillary_sales | 58,098 |
| eu_aviation_operating_metrics | 235,810 |
| eu_aviation_fleet_utilization | 9,418 |
| eu_aviation_maintenance_events | 4,749 |
| eu_aviation_safety_occurrences | 135 |
| eu_aviation_passenger_experience | 14,524 |
| eu_aviation_gl_accounts | 18 |
| eu_aviation_cost_escalation_index | 60 |
| eu_aviation_cost_rate_standards | 216 |
| eu_aviation_flight_pnl_lines | 3,951,072 |
| eu_aviation_flight_pnl_summary | 232,416 |
| eu_aviation_route_budget_annual | 2,233 |
| eu_aviation_airline_financials | 127 |
| eu_aviation_route_profitability | 2,271 |
| eu_aviation_rating_summaries | 127 |
| eu_aviation_forecast_features | 2,271 |
| eu_aviation_demand_forecasts | 2,271 |
Table Relationships
One parent record and seven child tables, each joined back on the same key.
70%
Loading diagram
Schema
Every table ships with typed columns, referential integrity, and documentation.
eu_aviation_years· Rows: 12
| Column | Type | Description |
|---|---|---|
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| calendar_year | integer | Calendar year for the eu_aviation_years record. |
| period_start | date | Period start for the eu_aviation_years record. |
| period_end | date | Period end for the eu_aviation_years record. |
| source_status | varchar(32) | source status in the declared lifecycle or operational vocabulary. |
eu_aviation_countries· Rows: 8
| Column | Type | Description |
|---|---|---|
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| country_name | varchar(24) | Human-readable country name; names are modelled where the disclosure states so. |
| region_name | varchar(16) | Human-readable region name; names are modelled where the disclosure states so. |
| currency_code | varchar(8) | Stable code for currency. |
eu_aviation_airlines· Rows: 11
| Column | Type | Description |
|---|---|---|
| airline_id | varchar(8) | Stable identifier for airline; use it for declared joins. |
| airline_code | varchar(8) | Stable code for airline. |
| airline_name | varchar(24) | Human-readable airline name; names are modelled where the disclosure states so. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| business_model | varchar(16) | Business model for the eu_aviation_airlines record. |
| alliance_strategy | varchar(32) | Alliance strategy for the eu_aviation_airlines record. |
| founded_year | integer | Founded year for the eu_aviation_airlines record. |
+2 more columns in eu_aviation_airlines. The full schema ships with the download.
eu_aviation_airports· Rows: 24
| Column | Type | Description |
|---|---|---|
| airport_id | varchar(8) | Stable identifier for airport; use it for declared joins. |
| airport_code | varchar(8) | Stable code for airport. |
| airport_name | varchar(32) | Human-readable airport name; names are modelled where the disclosure states so. |
| city_name | varchar(16) | Human-readable city name; names are modelled where the disclosure states so. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| latitude | numeric(9,5) | Latitude for the eu_aviation_airports record. |
| longitude | numeric(10,5) | Longitude for the eu_aviation_airports record. |
+3 more columns in eu_aviation_airports. The full schema ships with the download.
eu_aviation_aircraft_models· Rows: 8
| Column | Type | Description |
|---|---|---|
| aircraft_model_id | varchar(8) | Stable identifier for aircraft model; use it for declared joins. |
| model_code | varchar(8) | Stable code for model. |
| model_name | varchar(16) | Human-readable model name; names are modelled where the disclosure states so. |
| aircraft_class | varchar(16) | Aircraft class for the eu_aviation_aircraft_models record. |
| propulsion_type | varchar(16) | Propulsion type for the eu_aviation_aircraft_models record. |
| seat_capacity_reference | varchar(8) | Seat capacity reference for the eu_aviation_aircraft_models record. |
| range_km_reference | varchar(8) | Range km reference for the eu_aviation_aircraft_models record. |
+6 more columns in eu_aviation_aircraft_models. The full schema ships with the download.
eu_aviation_aircraft· Rows: 78
| Column | Type | Description |
|---|---|---|
| aircraft_id | varchar(16) | Stable identifier for aircraft; use it for declared joins. |
| airline_id | varchar(8) | Stable identifier for airline; use it for declared joins. |
| aircraft_model_id | varchar(8) | Stable identifier for aircraft model; use it for declared joins. |
| registration_code | varchar(8) | Stable code for registration. |
| delivery_date | date | delivery date as an ISO 8601 calendar date. |
| retirement_date | date | retirement date as an ISO 8601 calendar date. |
| acquisition_type | varchar(24) | Acquisition type for the eu_aviation_aircraft record. |
+13 more columns in eu_aviation_aircraft. The full schema ships with the download.
eu_aviation_aircraft_media· Rows: 12
| Column | Type | Description |
|---|---|---|
| aircraft_media_id | varchar(8) | Stable identifier for aircraft media; use it for declared joins. |
| aircraft_model_id | varchar(8) | Stable identifier for aircraft model; use it for declared joins. |
| airline_id | varchar(8) | Stable identifier for airline; use it for declared joins. |
| image_file | varchar(40) | Image file for the eu_aviation_aircraft_media record. |
| image_format | varchar(16) | Image format for the eu_aviation_aircraft_media record. |
| image_width_px | integer | Image width px for the eu_aviation_aircraft_media record. |
| image_height_px | integer | Image height px for the eu_aviation_aircraft_media record. |
+3 more columns in eu_aviation_aircraft_media. The full schema ships with the download.
eu_aviation_routes· Rows: 48
| Column | Type | Description |
|---|---|---|
| route_id | varchar(8) | Stable identifier for route; use it for declared joins. |
| origin_airport_id | varchar(8) | Stable identifier for origin airport; use it for declared joins. |
| destination_airport_id | varchar(8) | Stable identifier for destination airport; use it for declared joins. |
| distance_km | integer | distance in kilometres. |
| market_type | varchar(24) | Market type for the eu_aviation_routes record. |
| route_group | varchar(16) | Route group for the eu_aviation_routes record. |
| active_from | date | active from as an ISO 8601 calendar date. |
+2 more columns in eu_aviation_routes. The full schema ships with the download.
eu_aviation_fare_products· Rows: 4
| Column | Type | Description |
|---|---|---|
| fare_product_id | varchar(8) | Stable identifier for fare product; use it for declared joins. |
| fare_code | varchar(8) | Stable code for fare. |
| fare_name | varchar(24) | Human-readable fare name; names are modelled where the disclosure states so. |
| cabin_class | varchar(24) | Cabin class for the eu_aviation_fare_products record. |
| flexibility_band | varchar(24) | Flexibility band for the eu_aviation_fare_products record. |
| baggage_allowance_kg | integer | baggage allowance in kilograms. |
| refundability | boolean | Refundability for the eu_aviation_fare_products record. |
+2 more columns in eu_aviation_fare_products. The full schema ships with the download.
eu_aviation_flights· Rows: 235,810
| Column | Type | Description |
|---|---|---|
| flight_id | varchar(24) | Stable identifier for flight; use it for declared joins. |
| airline_id | varchar(8) | Stable identifier for airline; use it for declared joins. |
| aircraft_id | varchar(16) | Stable identifier for aircraft; use it for declared joins. |
| route_id | varchar(8) | Stable identifier for route; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| flight_date | date | flight date as an ISO 8601 calendar date. |
| scheduled_departure | varchar(8) | Scheduled departure for the eu_aviation_flights record. |
+10 more columns in eu_aviation_flights. The full schema ships with the download.
eu_aviation_tickets· Rows: 174,294
| Column | Type | Description |
|---|---|---|
| ticket_id | varchar(16) | Stable identifier for ticket; use it for declared joins. |
| flight_id | varchar(24) | Stable identifier for flight; use it for declared joins. |
| airline_id | varchar(8) | Stable identifier for airline; use it for declared joins. |
| route_id | varchar(8) | Stable identifier for route; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| fare_product_id | varchar(8) | Stable identifier for fare product; use it for declared joins. |
| booking_date | date | booking date as an ISO 8601 calendar date. |
+11 more columns in eu_aviation_tickets. The full schema ships with the download.
eu_aviation_ancillary_sales· Rows: 58,098
| Column | Type | Description |
|---|---|---|
| ancillary_sale_id | varchar(16) | Stable identifier for ancillary sale; use it for declared joins. |
| ticket_id | varchar(16) | Stable identifier for ticket; use it for declared joins. |
| flight_id | varchar(24) | Stable identifier for flight; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| ancillary_type | varchar(24) | Ancillary type for the eu_aviation_ancillary_sales record. |
| quantity | integer | Quantity for the eu_aviation_ancillary_sales record. |
| unit_price_usd | numeric(6,2) | unit price in United States dollars. |
+3 more columns in eu_aviation_ancillary_sales. The full schema ships with the download.
eu_aviation_operating_metrics· Rows: 235,810
| Column | Type | Description |
|---|---|---|
| operating_metric_id | varchar(24) | Stable identifier for operating metric; use it for declared joins. |
| flight_id | varchar(24) | Stable identifier for flight; use it for declared joins. |
| aircraft_id | varchar(16) | Stable identifier for aircraft; use it for declared joins. |
| route_id | varchar(8) | Stable identifier for route; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| fuel_used_litre | numeric(9,1) | Fuel used litre for the eu_aviation_operating_metrics record. |
| co2e_kg | numeric(9,1) | co2e in kilograms. |
+7 more columns in eu_aviation_operating_metrics. The full schema ships with the download.
eu_aviation_fleet_utilization· Rows: 9,418
| Column | Type | Description |
|---|---|---|
| fleet_utilization_id | varchar(24) | Stable identifier for fleet utilization; use it for declared joins. |
| aircraft_id | varchar(16) | Stable identifier for aircraft; use it for declared joins. |
| airline_id | varchar(8) | Stable identifier for airline; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| month_number | varchar(8) | Month number for the eu_aviation_fleet_utilization record. |
| available_days | integer | Available days for the eu_aviation_fleet_utilization record. |
| service_days | integer | Service days for the eu_aviation_fleet_utilization record. |
+10 more columns in eu_aviation_fleet_utilization. The full schema ships with the download.
eu_aviation_maintenance_events· Rows: 4,749
| Column | Type | Description |
|---|---|---|
| maintenance_event_id | varchar(16) | Stable identifier for maintenance event; use it for declared joins. |
| aircraft_id | varchar(16) | Stable identifier for aircraft; use it for declared joins. |
| airline_id | varchar(8) | Stable identifier for airline; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| event_date | date | event date as an ISO 8601 calendar date. |
| maintenance_type | varchar(24) | Maintenance type for the eu_aviation_maintenance_events record. |
| ata_chapter | integer | Ata chapter for the eu_aviation_maintenance_events record. |
+7 more columns in eu_aviation_maintenance_events. The full schema ships with the download.
eu_aviation_safety_occurrences· Rows: 135
| Column | Type | Description |
|---|---|---|
| safety_occurrence_id | varchar(16) | Stable identifier for safety occurrence; use it for declared joins. |
| flight_id | varchar(24) | Stable identifier for flight; use it for declared joins. |
| airline_id | varchar(8) | Stable identifier for airline; use it for declared joins. |
| aircraft_id | varchar(16) | Stable identifier for aircraft; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| occurrence_date | date | occurrence date as an ISO 8601 calendar date. |
| occurrence_category | varchar(40) | Occurrence category for the eu_aviation_safety_occurrences record. |
+6 more columns in eu_aviation_safety_occurrences. The full schema ships with the download.
eu_aviation_passenger_experience· Rows: 14,524
| Column | Type | Description |
|---|---|---|
| passenger_experience_id | varchar(16) | Stable identifier for passenger experience; use it for declared joins. |
| ticket_id | varchar(16) | Stable identifier for ticket; use it for declared joins. |
| flight_id | varchar(24) | Stable identifier for flight; use it for declared joins. |
| airline_id | varchar(8) | Stable identifier for airline; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| survey_date | date | survey date as an ISO 8601 calendar date. |
| overall_rating | integer | overall rating as the declared analytical measure. |
+8 more columns in eu_aviation_passenger_experience. The full schema ships with the download.
eu_aviation_gl_accounts· Rows: 18
| Column | Type | Description |
|---|---|---|
| gl_account_id | varchar(8) | Stable identifier for a chart of accounts row; use it for the joins declared for the P&L tables. |
| account_code | varchar(8) | The chart of accounts code for this P&L account, for example 4100 for passenger ticket revenue or 5710 for aircraft depreciation. |
| account_name | varchar(48) | The human readable name of the account as it appears on the flight profit and loss statement. |
| statement_section | varchar(16) | Where the account sits on the flight P&L: revenue or cost. |
| account_category | varchar(24) | The broad operating family the account belongs to, for example flight_operations, ground_operations, maintenance, ownership or overhead. |
| account_subcategory | varchar(24) | A finer grouping within the category, for example fuel, crew, airport, handling or insurance. |
| cost_driver | varchar(32) | The operational quantity that scales this account, for example fuel_litre, block_hour, departure or passenger. |
+3 more columns in eu_aviation_gl_accounts. The full schema ships with the download.
eu_aviation_cost_escalation_index· Rows: 60
| Column | Type | Description |
|---|---|---|
| escalation_id | varchar(16) | Stable identifier for a cost escalation index row; use it for the joins declared for the P&L tables. |
| year_id | varchar(8) | Stable identifier for the reporting year; use it for the joins declared for the P&L tables. |
| cost_family | varchar(32) | Which cost family the escalation index tracks: labour, fuel, maintenance_supply_chain, airport_charges or general_cpi. |
| escalation_index | numeric(6,3) | The cost of living index for the family in this year, indexed to 1.000 in 2015. |
| annual_change_pct | numeric(7,3) | The year over year percentage change in the escalation index; zero for the first year in the dataset. |
| driver_note | varchar(112) | A short note on what is driving the family escalation, for example crew contract resets or airport tariff reviews. |
eu_aviation_cost_rate_standards· Rows: 216
| Column | Type | Description |
|---|---|---|
| rate_id | varchar(16) | Stable identifier for a cost rate standard row; use it for the joins declared for the P&L tables. |
| year_id | varchar(8) | Stable identifier for the reporting year; use it for the joins declared for the P&L tables. |
| aircraft_class | varchar(16) | Whether the standard rate applies to a narrowbody or a widebody aircraft. |
| gl_account_id | varchar(8) | Stable identifier for a chart of accounts row; use it for the joins declared for the P&L tables. |
| rate_basis | varchar(32) | The unit the standard rate is quoted per, for example per_block_hour, per_departure, per_thousand_km, per_turnaround_minute or per_passenger. |
| rate_amount_usd | numeric(8,2) | The standard rate per unit of rate_basis for this account, aircraft class and year, in United States dollars. It is the 2015 base rate escalated by the named cost family and scaled by the region own cost factor. |
| escalation_family | varchar(32) | Which cost_escalation_index family this standard rate is escalated by. |
+2 more columns in eu_aviation_cost_rate_standards. The full schema ships with the download.
eu_aviation_flight_pnl_lines· Rows: 3,951,072
| Column | Type | Description |
|---|---|---|
| flight_pnl_line_id | varchar(16) | Stable identifier for a flight profit and loss line; use it for the joins declared for the P&L tables. |
| flight_id | varchar(24) | Stable identifier for the flight; use it for the joins declared for the P&L tables. |
| airline_id | varchar(8) | Stable identifier for the airline; use it for the joins declared for the P&L tables. |
| route_id | varchar(8) | Stable identifier for the route; use it for the joins declared for the P&L tables. |
| aircraft_id | varchar(16) | Stable identifier for the aircraft tail; use it for the joins declared for the P&L tables. |
| year_id | varchar(8) | Stable identifier for the reporting year; use it for the joins declared for the P&L tables. |
| gl_account_id | varchar(8) | Stable identifier for a chart of accounts row; use it for the joins declared for the P&L tables. |
+7 more columns in eu_aviation_flight_pnl_lines. The full schema ships with the download.
eu_aviation_flight_pnl_summary· Rows: 232,416
| Column | Type | Description |
|---|---|---|
| flight_pnl_id | varchar(16) | Stable identifier for a flight profit and loss summary row; use it for the joins declared for the P&L tables. |
| flight_id | varchar(24) | Stable identifier for the flight; use it for the joins declared for the P&L tables. |
| airline_id | varchar(8) | Stable identifier for the airline; use it for the joins declared for the P&L tables. |
| route_id | varchar(8) | Stable identifier for the route; use it for the joins declared for the P&L tables. |
| aircraft_id | varchar(16) | Stable identifier for the aircraft tail; use it for the joins declared for the P&L tables. |
| year_id | varchar(8) | Stable identifier for the reporting year; use it for the joins declared for the P&L tables. |
| flight_date | date | The ISO 8601 calendar date the flight operated. |
+10 more columns in eu_aviation_flight_pnl_summary. The full schema ships with the download.
eu_aviation_route_budget_annual· Rows: 2,233
| Column | Type | Description |
|---|---|---|
| route_budget_id | varchar(16) | Stable identifier for a route budget annual row; use it for the joins declared for the P&L tables. |
| airline_id | varchar(8) | Stable identifier for the airline; use it for the joins declared for the P&L tables. |
| route_id | varchar(8) | Stable identifier for the route; use it for the joins declared for the P&L tables. |
| year_id | varchar(8) | Stable identifier for the reporting year; use it for the joins declared for the P&L tables. |
| planned_departures | integer | The number of flights the annual budget for this airline, route and year is built on. |
| planned_passengers | integer | Total passengers boarded across the airline flights on this route and year, the base the annual passenger target is built on. |
| planned_revenue_usd | numeric(12,2) | The finance approved revenue target for this airline, route and year, in United States dollars. It is set a little above the summed flight plans, since a budget is deliberately braver than an operating plan. |
+5 more columns in eu_aviation_route_budget_annual. The full schema ships with the download.
eu_aviation_airline_financials· Rows: 127
| Column | Type | Description |
|---|---|---|
| airline_financial_id | varchar(16) | Stable identifier for airline financial; use it for declared joins. |
| airline_id | varchar(8) | Stable identifier for airline; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| passenger_revenue_usd | integer | passenger revenue in United States dollars. |
| ancillary_revenue_usd | integer | ancillary revenue in United States dollars. |
| cargo_revenue_usd | integer | cargo revenue in United States dollars. |
| other_revenue_usd | integer | other revenue in United States dollars. |
+10 more columns in eu_aviation_airline_financials. The full schema ships with the download.
eu_aviation_route_profitability· Rows: 2,271
| Column | Type | Description |
|---|---|---|
| route_profitability_id | varchar(24) | Stable identifier for route profitability; use it for declared joins. |
| airline_id | varchar(8) | Stable identifier for airline; use it for declared joins. |
| route_id | varchar(8) | Stable identifier for route; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| flights_count | integer | Flights count for the eu_aviation_route_profitability record. |
| passengers_count | integer | Passengers count for the eu_aviation_route_profitability record. |
| revenue_usd | numeric(12,2) | revenue in United States dollars. |
+7 more columns in eu_aviation_route_profitability. The full schema ships with the download.
eu_aviation_rating_summaries· Rows: 127
| Column | Type | Description |
|---|---|---|
| rating_summary_id | varchar(16) | Stable identifier for rating summary; use it for declared joins. |
| airline_id | varchar(8) | Stable identifier for airline; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| overall_rating | numeric(5,2) | overall rating as the declared analytical measure. |
| service_rating | numeric(5,2) | service rating as the declared analytical measure. |
| punctuality_rating | numeric(5,2) | punctuality rating as the declared analytical measure. |
| value_rating | numeric(5,2) | value rating as the declared analytical measure. |
+5 more columns in eu_aviation_rating_summaries. The full schema ships with the download.
eu_aviation_forecast_features· Rows: 2,271
| Column | Type | Description |
|---|---|---|
| forecast_feature_id | varchar(24) | Stable identifier for forecast feature; use it for declared joins. |
| airline_id | varchar(8) | Stable identifier for airline; use it for declared joins. |
| route_id | varchar(8) | Stable identifier for route; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| feature_source_cutoff | date | Latest source date available to the feature row; it precedes the prediction target. |
| lag_passengers_1y | integer | Lag passengers 1y for the eu_aviation_forecast_features record. |
| lag_yield_usd_per_km | numeric(6,3) | lag yield usd per in kilometres. |
+8 more columns in eu_aviation_forecast_features. The full schema ships with the download.
eu_aviation_demand_forecasts· Rows: 2,271
| Column | Type | Description |
|---|---|---|
| demand_forecast_id | varchar(24) | Stable identifier for demand forecast; use it for declared joins. |
| forecast_feature_id | varchar(24) | Stable identifier for forecast feature; use it for declared joins. |
| airline_id | varchar(8) | Stable identifier for airline; use it for declared joins. |
| route_id | varchar(8) | Stable identifier for route; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| forecast_created_on | date | forecast created on as an ISO 8601 calendar date. |
| model_version | varchar(24) | Model version for the eu_aviation_demand_forecasts record. |
+8 more columns in eu_aviation_demand_forecasts. The full schema ships with the download.
Sample Data
A snapshot of real rows from the dataset (values are fully synthetic).
| fare_product_id | fare_code | fare_name | cabin_class | flexibility_band | baggage_allowance_kg | refundability | priority_services_flag |
|---|---|---|---|---|---|---|---|
| FAR1 | BASIC | Basic Economy | economy | restricted | 10 | false | false |
| FAR2 | FLEX | Flexible Economy | economy | flexible | 23 | true | true |
| FAR3 | PREM | Premium Economy | premium_economy | flexible | 30 | true | true |
Version History
| v2.4.0 | 2026-08-20 | Realistic plan versus actual variance. The budget was previously built from the same year it planned, so every normal year landed within two per cent of plan and 2020, the worst year the industry has ever had, missed its budget by fourteen. The budget is now signed the autumn before the year runs and is built only on what the airline had realised by then: last year's load factor, last year's fare, last year's into-plane fuel price and last year's achieved burn against the reference rate, with a recovery assumption after a collapse rather than a repeat of it. The flight schedule also gains a layer of ordinary disruption dated to the window and to the region, so a typhoon, a controller shortage, an airspace closure, a grounded sub fleet, a software outage and a competitor withdrawal all move the months they happened in. Plan versus actual now runs about minus five to plus twenty per cent month to month outside the pandemic, against minus fifty five in 2020 and plus sixty four on the fuel line in 2022. Ground handling and fuel no longer carry a structural bias: the plan turnaround is set per aircraft class rather than a flat forty five minutes for a widebody, and the plan burn follows the fleet's achieved rate. Twenty five of the twenty eight tables are affected because the disruption layer moves the flights themselves. Schema, table list, column names and pricing are unchanged from 2.3.1. |
Related Datasets
Commercial Aviation Analytics Set (ASIA)
Freight & LogisticsA complete Asia analytical warehouse covering airline, fleet, route, flight, ticket, ancillary, operating, maintenance, safety, passenger-experience, rating, financial, profitability and demand-forecast data.
$299one time
View details Commercial Aviation Analytics Set (US)
Freight & LogisticsA complete United States analytical warehouse covering airline, fleet, route, flight, ticket, ancillary, operating, maintenance, safety, passenger-experience, rating, financial, profitability and demand-forecast data.
$299one time
View details Logistics Fleet Tire Lifecycle and Predictive Maintenance Set (ASIA)
Freight & LogisticsA complete Asia analytical warehouse covering company, site, vehicle, tire model, serialized asset, installation, rotation, inspection, pressure, usage, conditions, damage, repair, retread, failure, cost, disposal and prediction data.
$129one time
View details