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 TC 809Ephraim NowakPropeller · 2 models · Revised Jul 24, 2024TCDS TC 817Ephraim NowakPropeller · 4 models · Revised Jul 24, 2024TCDS TC 843Ephraim NowakPropeller · 4 models · Revised Jul 24, 2024TCDS B05CEUltramagic S.A.Aircraft · 1 model · Revised Jul 23, 2024TCDS G58EUStemme GmbHAircraft · 2 models · Revised Jul 23, 2024TCDS P22BOMT-Propeller Entwicklung GmbHPropeller · 1 model · Revised Jul 17, 2024TCDS A00080CEBlackshape S.p.A.Aircraft · 1 model · Revised Jun 21, 2024TCDS P8BOHamilton Sundstrand CorporationPropeller · 4 models · Revised Mar 25, 2024TCDS A49NMJetcruzer International LLCAircraft · 1 model · Revised Feb 8, 2024TCDS P00066IBMT-Propeller Entwicklung GmbHPropeller · 1 model · Revised Jan 31, 2024TCDS A00034LAICON Aircraft Inc.Aircraft · 1 model · Revised Dec 20, 2023TCDS P58GLMcCauley Propeller SystemsPropeller · 17 models · Revised Dec 13, 2023TCDS R00030LAMatternet Inc.Aircraft · 1 model · Revised Oct 17, 2023TCDS R00033LAAirobotics Inc.Aircraft · 1 model · Revised Sep 5, 2023TCDS 1P2Sensenich Propeller CompanyPropeller · 2 models · Revised Aug 28, 2023TCDS P-170Sensenich Propeller CompanyPropeller · 113 models · Revised Aug 28, 2023TCDS P-886Sensenich Propeller CompanyPropeller · 4 models · Revised Aug 28, 2023TCDS P-904Sensenich Propeller CompanyPropeller · 3 models · Revised Aug 28, 2023TCDS P00001NYSensenich Propeller CompanyPropeller · 2 models · Revised Aug 28, 2023TCDS P00022ATSensenich Propeller CompanyPropeller · 3 models · Revised Aug 28, 2023TCDS P17EASensenich Propeller CompanyPropeller · 1 model · Revised Aug 28, 2023TCDS P27NESensenich Propeller CompanyPropeller · 3 models · Revised Aug 28, 2023TCDS P28NESensenich Propeller CompanyPropeller · 2 models · Revised Aug 28, 2023TCDS P4EASensenich Propeller CompanyPropeller · 1 model · Revised Aug 28, 2023TCDS R0015DEBillings Flying Service Inc.Aircraft · 2 models · Revised Aug 28, 2023TCDS R00028LAHeliqwest International Inc.Aircraft · 2 models · Revised Aug 23, 2023TCDS P50GLMcCauley Propeller SystemsPropeller · 1 model · Revised Aug 8, 2023TCDS A00012NYDiamond Aircraft Industries Inc.Aircraft · 1 model · Revised Jul 13, 2023TCDS P00041BOMT-Propeller Entwicklung GmbHPropeller · 1 model · Revised May 15, 2023TCDS E00022CHDeltaHawk Engines Inc.Engine · 1 model · Revised Apr 7, 2023TCDS R00004RCJJASPP Engineering Services - AlaskaAircraft · 1 model · Revised Mar 15, 2023TCDS P3NEMcCauley Propeller SystemsPropeller · 4 models · Revised Feb 24, 2023TCDS H12NMMidwest Aerospace TC LLCAircraft · 3 models · Revised Feb 8, 2023TCDS H3NMMidwest Aerospace TC LLCAircraft · 1 model · Revised Feb 8, 2023TCDS B1EUCameron Balloons Ltd.Aircraft · 27 models · Revised Feb 1, 2023TCDS E1NEPratt & Whitney Canada Corp.Engine · 2 models · Revised Nov 16, 2022TCDS E3INContinental Aerospace Technologies, Inc.Engine · 13 models · Revised Sep 19, 2022TCDS P10EUAirbus Poland S.A.Propeller · 1 model · Revised Aug 16, 2022TCDS P23NEAirbus Poland S.A.Propeller · 1 model · Revised Aug 16, 2022TCDS P4NEAirbus Poland S.A.Propeller · 1 model · Revised Aug 16, 2022TCDS P9EUAirbus Poland S.A.Propeller · 1 model · Revised Aug 16, 2022TCDS G54EUCentrairAircraft · 1 model · Revised Aug 9, 2022TCDS A69EUAirbus Poland S.A.Aircraft · 2 models · Revised Jul 14, 2022TCDS E8EAOzark Aeroworks LLCEngine · 1 model · Revised May 6, 2022TCDS A25EUAgusta S.p.A.Aircraft · 1 model · Revised Apr 15, 2022TCDS B87EULindstrand Balloons Ltd.Aircraft · 5 models · Revised Mar 22, 2022TCDS A86EUAermacchi S.p.A.Aircraft · 1 model · Revised Mar 11, 2022TCDS A45CEIlyushin Aviation ComplexAircraft · 1 model · Revised Mar 8, 2022TCDS A48CEHongdu Aviation Industry Co. Ltd.Aircraft · 1 model · Revised Mar 7, 2022TCDS A8PCFuji Heavy Industries Ltd.Aircraft · 2 models · Revised Mar 7, 2022