Aviation
Pack file: catalog/industries/aviation in ambient-core.
Workspace demo (screenshots) · Catalog consumption
Industry summary
Industry code
ISIC Rev.4 5110
27 metrics · 7 data options
- NAICS 2022
481111- NACE Rev.2
51.10- GICS 2023
203020
Taxonomy tags from ambient-core pack.yaml / manifest v3 (analysis lens, not legal-entity self-classification). Coverage notes: catalog-industry-coverage.md.
Data options (7)
Airport traffic and revenue summary
Catalog key aviation.airport.traffic_revenue_summary
Fields
period_start_date- date
period_end_date- date
enplaned_passengers- string
passengers_enplaned_growth- string
aeronautical_revenue- decimal
commercial_revenue- decimal
total_revenue- decimal
Accounting Software
Catalog key aviation.core.accounting_software
Fields
date- date
period_start_date- date
period_end_date- date
revenue- decimal
cogs- decimal
cost_of_goods- decimal
operating_expenses- decimal
net_income- decimal
produce_revenue- decimal
total_production_cost- decimal
total_operational_cost- decimal
Financial statements
Catalog key aviation.core.financial_statements
Fields
date- date
statement_type- enum
period_start_date- date
period_end_date- date
HR records
Catalog key aviation.core.hr_records
Fields
date- date
headcount- decimal
Payroll records
Catalog key aviation.core.payroll_records
Fields
date- date
period_start_date- date
period_end_date- date
headcount- decimal
gross_pay- decimal
net_pay- decimal
employer_taxes- decimal
labor_cost- decimal
revenue- decimal
net_income- decimal
total_labor_costs- decimal
total_harvested_kg- decimal
total_production_cost- decimal
total_operational_cost- decimal
drivers_left- decimal
total_drivers- decimal
total_maintenance_costs- decimal
total_miles- decimal
Airline operational statistics summary
Catalog key aviation.network_carrier.operational_statistics_summary
Fields
period_start_date- date
period_end_date- date
available_seat_kilometers- string
revenue_passenger_kilometers- decimal
revenue_capacity_units- decimal
available_capacity_units- string
total_operating_cost- decimal
total_operating_revenue- decimal
on_time_arrivals- string
total_arrivals- decimal
fuel_expense- string
cargo_tonne_km_carried- string
available_tonne_km- string
cargo_revenue- decimal
Travel distribution booking summary
Catalog key aviation.travel_distribution.booking_summary
Fields
period_start_date- date
period_end_date- date
platform_revenue- decimal
gross_booking_value- string
completed_bookings- string
qualified_sessions- string
Metrics (27)
- Cargo Load Factor
- Cargo Yield per Tonne-Kilometer
- Aeronautical Revenue per Passenger
- Commercial Revenue Share
- Passengers Enplaned Growth
- Monthly Burn Rate
- Cash Conversion Cycle
- Current Ratio
- Days Payable Outstanding (DPO)
- Days Sales Outstanding (DSO)
- EBITDA Margin
- Gross Profit Margin
- Headcount (FTE)
- Net Profit Margin
- Operating Cash Flow
- Operating Margin (EBIT)
- Quick Ratio (Acid Test)
- Revenue Growth Rate
- Cash Runway
- Working Capital
- Cost per Available Seat Kilometer (CASM)
- Fuel Cost Percent of Operating Cost
- Load Factor
- On-Time Performance (OTP)
- Revenue per Available Seat Kilometer (RASM)
- Gross Booking Value Take Rate
- Look-to-Book Conversion
Cargo Load Factor
- ID: 1830
- Type: Operational
- Unit: %
- Description: Cargo tonnage carried relative to available cargo capacity (aggregated).
- Inputs:
cargo_tonne_km_carried,available_tonne_km - Methodology: Cargo Load Factor = (Cargo Tonne-Km Carried / Available Tonne-Km) × 100
- Calculation:
cargo_tonne_km_carried / available_tonne_km * 100 - Catalog key:
aviation.air_cargo.cargo_load_factor
Cargo Yield per Tonne-Kilometer
- ID: 1831
- Type: Financial
- Unit: Currency per tonne-km
- Description: Cargo revenue per tonne-kilometer carried (aggregated).
- Inputs:
cargo_revenue,cargo_tonne_km_carried - Methodology: Yield = Cargo Revenue / Cargo Tonne-Kilometers Carried
- Calculation:
cargo_revenue / cargo_tonne_km_carried - Catalog key:
aviation.air_cargo.cargo_yield_per_tonne_km
Aeronautical Revenue per Passenger
- ID: 1826
- Type: Financial
- Unit: Currency
- Description: Aeronautical charges divided by enplaned passengers (aggregated).
- Inputs:
aeronautical_revenue,enplaned_passengers - Methodology: ARPP = Aeronautical Revenue / Enplaned Passengers
- Calculation:
aeronautical_revenue / enplaned_passengers - Catalog key:
aviation.airport.aeronautical_revenue_per_passenger
Commercial Revenue Share
- ID: 1827
- Type: Financial
- Unit: %
- Description: Non-aeronautical revenue as a share of total airport revenue (aggregated).
- Inputs:
commercial_revenue,total_revenue - Methodology: Share = (Commercial Revenue / Total Revenue) × 100
- Calculation:
commercial_revenue / total_revenue * 100 - Catalog key:
aviation.airport.commercial_revenue_share
Passengers Enplaned Growth
- ID: 1825
- Type: Operational
- Unit: %
- Description: Year-over-year growth in enplaned passengers (aggregated).
- Methodology: Growth = ((Current Enplanements − Prior Enplanements) / Prior Enplanements) × 100
- Calculation: No machine-readable calc — directly reported or qualitative.
- Catalog key:
aviation.airport.passengers_enplaned_growth
Monthly Burn Rate
- ID: 1812
- Type: Financial
- Unit: Currency/month
- Description: Net cash consumed per month (negative net operating cash flow).
- Inputs:
cash_out,cash_in - Methodology: Net Burn = Cash Out − Cash In (per month)
- Calculation:
cash_out - cash_in - Catalog key:
aviation.core.burn_rate
Cash Conversion Cycle
- ID: 1810
- Type: Financial
- Unit: Days
- Description: Days to convert investments in inventory and receivables back into cash.
- Inputs:
days_inventory_outstanding - Methodology: CCC = DSO + Days Inventory Outstanding − DPO
- Calculation:
dso + days_inventory_outstanding - dpo - Catalog key:
aviation.core.ccc
Current Ratio
- ID: 1800
- Type: Financial
- Unit: Ratio
- Description: Short-term liquidity: ability to cover current liabilities with current assets.
- Inputs:
current_assets,current_liabilities - Methodology: Current Ratio = Current Assets / Current Liabilities
- Calculation:
current_assets / current_liabilities - Catalog key:
aviation.core.current_ratio
Days Payable Outstanding (DPO)
- ID: 1809
- Type: Financial
- Unit: Days
- Description: Average number of days the business takes to pay its suppliers.
- Inputs:
accounts_payable,cogs,days - Methodology: DPO = (Accounts Payable / COGS) × Number of Days
- Calculation:
accounts_payable / cogs * days - Catalog key:
aviation.core.dpo
Days Sales Outstanding (DSO)
- ID: 1808
- Type: Financial
- Unit: Days
- Description: Average number of days to collect cash after a sale.
- Inputs:
accounts_receivable,total_credit_sales,days - Methodology: DSO = (Accounts Receivable / Total Credit Sales) × Number of Days
- Calculation:
accounts_receivable / total_credit_sales * days - Catalog key:
aviation.core.dso
EBITDA Margin
- ID: 1804
- Type: Financial
- Unit: %
- Description: Core operating cash profitability before interest, tax, depreciation and amortization.
- Inputs:
ebitda,revenue - Methodology: EBITDA Margin = (EBITDA / Revenue) × 100
- Calculation:
ebitda / revenue * 100 - Catalog key:
aviation.core.ebitda_margin
Gross Profit Margin
- ID: 1802
- Type: Financial
- Unit: %
- Description: Share of revenue retained after the direct cost of goods sold.
- Inputs:
revenue,cogs - Methodology: Gross Margin = ((Revenue − COGS) / Revenue) × 100
- Calculation:
(revenue - cogs) / revenue * 100 - Catalog key:
aviation.core.gross_margin
Headcount (FTE)
- ID: 1814
- Type: Operational
- Unit: Count
- Description: Period-end count of active full-time-equivalent employees. A directly measured input, not a derived ratio.
- Methodology: Period-end count of active employees expressed as full-time equivalents (directly measured, not calculated).
- Calculation: No machine-readable calc — directly reported or qualitative.
- Catalog key:
aviation.core.headcount
Net Profit Margin
- ID: 1805
- Type: Financial
- Unit: %
- Description: Bottom-line profitability after all costs, interest and tax.
- Inputs:
net_income,revenue - Methodology: Net Profit Margin = (Net Income / Revenue) × 100
- Calculation:
net_income / revenue * 100 - Catalog key:
aviation.core.net_margin
Operating Cash Flow
- ID: 1811
- Type: Financial
- Unit: Currency (e.g., USD)
- Description: Cash generated by core operations during the period.
- Inputs:
net_income,non_cash_charges,increase_in_working_capital - Methodology: Operating Cash Flow = Net Income + Non-Cash Charges − Increase in Working Capital
- Calculation:
net_income + non_cash_charges - increase_in_working_capital - Catalog key:
aviation.core.operating_cash_flow
Operating Margin (EBIT)
- ID: 1803
- Type: Financial
- Unit: %
- Description: Operating profitability after operating expenses (EBIT margin).
- Inputs:
operating_income,revenue - Methodology: Operating Margin = (Operating Income / Revenue) × 100
- Calculation:
operating_income / revenue * 100 - Catalog key:
aviation.core.operating_margin
Quick Ratio (Acid Test)
- ID: 1801
- Type: Financial
- Unit: Ratio
- Description: Acid-test liquidity excluding inventory — most conservative short-term solvency view.
- Inputs:
current_assets,inventory,current_liabilities - Methodology: Quick Ratio = (Current Assets − Inventory) / Current Liabilities
- Calculation:
(current_assets - inventory) / current_liabilities - Catalog key:
aviation.core.quick_ratio
Revenue Growth Rate
- ID: 1806
- Type: Financial
- Unit: %
- Description: Period-over-period revenue growth rate.
- Inputs:
revenue,revenue_prior - Methodology: Revenue Growth = ((Current Period Revenue − Prior Period Revenue) / Prior Period Revenue) × 100
- Calculation:
(revenue - revenue_prior) / revenue_prior * 100 - Catalog key:
aviation.core.revenue_growth
Cash Runway
- ID: 1813
- Type: Financial
- Unit: Months
- Description: Number of months of cash remaining at the current net burn rate.
- Inputs:
current_cash_balance - Methodology: Runway (months) = Current Cash Balance / Monthly Net Burn
- Calculation:
current_cash_balance / burn_rate - Catalog key:
aviation.core.runway
Working Capital
- ID: 1807
- Type: Financial
- Unit: Currency (e.g., USD)
- Description: Operating liquidity available to fund day-to-day operations.
- Inputs:
current_assets,current_liabilities - Methodology: Working Capital = Current Assets − Current Liabilities
- Calculation:
current_assets - current_liabilities - Catalog key:
aviation.core.working_capital
Cost per Available Seat Kilometer (CASM)
- ID: 1821
- Type: Financial
- Unit: Currency per ASK
- Description: Operating cost per unit of available seat capacity (aggregated).
- Inputs:
total_operating_cost,available_seat_kilometers - Methodology: CASM = Total Operating Cost / Available Seat Kilometers
- Calculation:
total_operating_cost / available_seat_kilometers - Catalog key:
aviation.network_carrier.casm
Fuel Cost Percent of Operating Cost
- ID: 1824
- Type: Financial
- Unit: %
- Description: Fuel expense as a share of total operating cost (aggregated).
- Inputs:
fuel_expense,total_operating_cost - Methodology: Fuel % = (Fuel Expense / Total Operating Cost) × 100
- Calculation:
fuel_expense / total_operating_cost * 100 - Catalog key:
aviation.network_carrier.fuel_cost_pct_operating
Load Factor
- ID: 1820
- Type: Operational
- Unit: %
- Description: Revenue passenger miles or cargo tonnage carried relative to available capacity (aggregated).
- Inputs:
revenue_capacity_units,available_capacity_units - Methodology: Load Factor = (RPM or RTM / ASM or ATM) × 100
- Calculation:
revenue_capacity_units / available_capacity_units * 100 - Catalog key:
aviation.network_carrier.load_factor
On-Time Performance (OTP)
- ID: 1823
- Type: Operational
- Unit: %
- Description: Share of flights arriving within regulatory on-time threshold (aggregated).
- Inputs:
on_time_arrivals,total_arrivals - Methodology: OTP = (On-Time Arrivals / Total Arrivals) × 100
- Calculation:
on_time_arrivals / total_arrivals * 100 - Catalog key:
aviation.network_carrier.on_time_performance
Revenue per Available Seat Kilometer (RASM)
- ID: 1822
- Type: Financial
- Unit: Currency per ASK
- Description: Operating revenue per unit of available seat capacity (aggregated).
- Inputs:
total_operating_revenue,available_seat_kilometers - Methodology: RASM = Total Operating Revenue / Available Seat Kilometers
- Calculation:
total_operating_revenue / available_seat_kilometers - Catalog key:
aviation.network_carrier.rasm
Gross Booking Value Take Rate
- ID: 1828
- Type: Financial
- Unit: %
- Description: Platform revenue as a share of gross bookings (aggregated).
- Inputs:
platform_revenue,gross_booking_value - Methodology: Take Rate = (Platform Revenue / Gross Booking Value) × 100
- Calculation:
platform_revenue / gross_booking_value * 100 - Catalog key:
aviation.travel_distribution.gbv_take_rate
Look-to-Book Conversion
- ID: 1829
- Type: Operational
- Unit: %
- Description: Share of travel searches or sessions that complete a booking (aggregated).
- Inputs:
completed_bookings,qualified_sessions - Methodology: Conversion = (Completed Bookings / Qualified Sessions) × 100
- Calculation:
completed_bookings / qualified_sessions * 100 - Catalog key:
aviation.travel_distribution.look_to_book_conversion
Data engineering pipeline
Ambient Core ships the catalog (typed data options and metrics) and ambient_pipeline helpers. Lakehouse jobs and schedules live in the application repository that pins a core tag.
Canonical order: map columns → coerce types → unpivot → stamp lineage → (optional Silver validate) → contract assert → write. Gold vertical products evaluate catalog formulas with ambient_calc after Silver.
How this pack feeds the pipeline
- Airport traffic and revenue summary — feeds Passengers Enplaned Growth, Aeronautical Revenue per Passenger, Commercial Revenue Share
- Accounting Software — feeds Gross Profit Margin, Operating Margin (EBIT), Net Profit Margin
- Financial statements — feeds Current Ratio, Quick Ratio (Acid Test), Gross Profit Margin, Operating Margin (EBIT), Net Profit Margin, EBITDA Margin, Operating Cash Flow, Revenue Growth Rate, Working Capital, Days Sales Outstanding (DSO), Days Payable Outstanding (DPO), Cash Conversion Cycle, Monthly Burn Rate, Cash Runway
- HR records — feeds Headcount (FTE)
- Payroll records — feeds Net Profit Margin, Operating Margin (EBIT)
- Airline operational statistics summary — feeds Load Factor, Cost per Available Seat Kilometer (CASM), Revenue per Available Seat Kilometer (RASM), On-Time Performance (OTP), Fuel Cost Percent of Operating Cost, Cargo Load Factor, Cargo Yield per Tonne-Kilometer
- Travel distribution booking summary — feeds Gross Booking Value Take Rate, Look-to-Book Conversion
Further reading: Catalog consumption · Pipeline governance helpers
Generated from ambient-core ref 22b6089 (digest f5bca892574e3e28). Regenerate: npm run sync:catalog-wiki.