OpenAirDocs.org

Type certificate data sheets

The latest revision of 2,257 data sheets. Each lists its models, the ADs that name them and the registered aircraft.

Sort by
Query with SQL
duckdb -csv -c "WITH fleet AS (
    SELECT a.tcds_number, count(*) AS aircraft
    FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' a ON a.code = g.aircraft_model_code
    WHERE a.tcds_number IS NOT NULL GROUP BY 1
    UNION ALL
    SELECT e.tcds_number, count(*)
    FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g JOIN 'https://openairdocs.org/data/latest/faa_engine_model.parquet' e ON e.code = g.engine_model_code
    WHERE e.tcds_number IS NOT NULL GROUP BY 1
  ),
  models AS (
    SELECT tcds_number, count(*) AS models, string_agg(concat_ws(' ', model, unofficial_name), ' ') AS names
    FROM 'https://openairdocs.org/data/latest/faa_type_certificate_model.parquet' GROUP BY 1
  )
  SELECT t.tcds_number, t.holder, t.status, t.product_type, coalesce(m.models, 0) AS models,
    coalesce((SELECT sum(aircraft) FROM fleet f WHERE f.tcds_number = t.tcds_number), 0) AS aircraft, t.revision_date
  FROM 'https://openairdocs.org/data/latest/faa_type_certificate.parquet' t LEFT JOIN models m USING (tcds_number)
  ORDER BY aircraft DESC, t.status = 'Current' DESC, t.revision_date DESC NULLS LAST, t.tcds_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

TCDS P55GLHartzell Propeller LLCPropeller · 9 models · Revised Nov 18, 2025TCDS H15EUPZL-Swidnik S.A.Aircraft · 1 model · Revised Nov 13, 2025TCDS A00121CEBRM AERO s.r.o.Aircraft · 1 model · Revised Sep 9, 2025TCDS P00123IBHercules Propellers LimitedPropeller · 4 models · Revised Sep 8, 2025TCDS P13BOMT-Propeller Entwicklung GmbHPropeller · 1 model · Revised Aug 8, 2025TCDS P20BOMT-Propeller Entwicklung GmbHPropeller · 1 model · Revised Aug 8, 2025TCDS P00114CHHartzell Propeller LLCPropeller · 1 model · Revised Jul 18, 2025TCDS P00120IBAvia Propeller S.R.O.Propeller · 1 model · Revised Jul 2, 2025TCDS TE2CHLight Helicopter Turbine Engine Company (LHTEC)Engine · 4 models · Revised May 7, 2025TCDS P00016CHHartzell Propeller LLCPropeller · 1 model · Revised Apr 3, 2025TCDS P56GLHartzell Propeller LLCPropeller · 2 models · Revised Apr 3, 2025TCDS P10EAHartzell Propeller LLCPropeller · 1 model · Revised Apr 2, 2025TCDS P27EAHartzell Propeller LLCPropeller · 5 models · Revised Apr 2, 2025TCDS P31EAHartzell Propeller LLCPropeller · 5 models · Revised Apr 2, 2025TCDS P34NEHartzell Propeller LLCPropeller · 1 model · Revised Apr 2, 2025TCDS P35EAHartzell Propeller LLCPropeller · 6 models · Revised Apr 2, 2025TCDS P41EAHartzell Propeller LLCPropeller · 2 models · Revised Apr 2, 2025TCDS P42GLHartzell Propeller LLCPropeller · 5 models · Revised Apr 2, 2025TCDS P43GLHartzell Propeller LLCPropeller · 2 models · Revised Apr 2, 2025TCDS P44GLHartzell Propeller LLCPropeller · 5 models · Revised Apr 2, 2025TCDS P9EAHartzell Propeller LLCPropeller · 3 models · Revised Apr 2, 2025TCDS P9NEHartzell Propeller LLCPropeller · 1 model · Revised Apr 2, 2025TCDS P00013CHHartzell Propeller LLCPropeller · 2 models · Revised Mar 31, 2025TCDS P00014CHHartzell Propeller LLCPropeller · 1 model · Revised Mar 31, 2025TCDS P00019CHHartzell Propeller LLCPropeller · 1 model · Revised Mar 31, 2025TCDS P15EAHartzell Propeller LLCPropeller · 1 model · Revised Mar 31, 2025TCDS R00115SEBillings Flying Service Inc.Aircraft · 2 models · Revised Mar 13, 2025TCDS E00100ENGeneral Electric CompanyEngine · 1 model · Revised Mar 7, 2025TCDS P21BOAvia Propeller Ltd.Propeller · 9 models · Revised Mar 3, 2025TCDS R00035LAHallux Aerospace LLCAircraft · 5 models · Revised Jan 6, 2025TCDS A34EUACC Columbia Jet Service GmbHAircraft · 3 models · Revised Dec 10, 2024TCDS P25EAHartzell Propeller LLCPropeller · 3 models · Revised Nov 26, 2024TCDS P36EAHartzell Propeller LLCPropeller · 6 models · Revised Nov 26, 2024TCDS P00015CHHartzell Propeller LLCPropeller · 2 models · Revised Nov 15, 2024TCDS P00023CHHartzell Propeller LLCPropeller · 1 model · Revised Sep 30, 2024TCDS P40EAHartzell Propeller LLCPropeller · 3 models · Revised Sep 27, 2024TCDS P20NEHartzell Propeller LLCPropeller · 8 models · Revised Sep 18, 2024TCDS P33EAHartzell Propeller LLCPropeller · 8 models · Revised Sep 18, 2024TCDS E00055ENCFM International S.A.Engine · 49 models · Revised Aug 19, 2024TCDS E00056ENCFM International S.A.Engine · 49 models · Revised Aug 19, 2024TCDS P24NEMT-Propeller Entwicklung GmbHPropeller · 1 model · Revised Aug 15, 2024TCDS AS3EUSkyship Services Inc.Aircraft · 1 model · Revised Aug 14, 2024TCDS P10NEHartzell Propeller LLCPropeller · 2 models · Revised Aug 13, 2024TCDS R00032LAPercepto Robotics Ltd.Aircraft · 1 model · Revised Aug 9, 2024TCDS E39NERolls-Royce Deutschland Ltd & Co KGEngine · 3 models · Revised Aug 6, 2024TCDS TC 408Ephraim NowakPropeller · 1 model · Revised Jul 24, 2024TCDS TC 429Ephraim NowakPropeller · 2 models · Revised Jul 24, 2024TCDS TC 610Ephraim NowakPropeller · 1 model · Revised Jul 24, 2024TCDS TC 754Ephraim NowakPropeller · 11 models · Revised Jul 24, 2024TCDS TC 802Ephraim NowakPropeller · 14 models · Revised Jul 24, 2024