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 G1NEK & L Soaring LLCAircraft · 1 model · Revised Nov 29, 2010TCDS E-285Lycoming EnginesEngine · 3 models · Revised Nov 4, 2010TCDS TC 771 (Beech)Hawker Beechcraft CorporationPropeller · 1 model · Revised Oct 25, 2010TCDS TC 770Hawker Beechcraft CorporationAircraft · 2 models · Revised Sep 1, 2010TCDS P60GLMcCauley Propeller SystemsPropeller · 4 models · Revised Aug 10, 2010TCDS E33NEAlfa Romeo Avio S.p.A.Engine · 2 models · Revised Jul 1, 2010TCDS E-276Lycoming EnginesEngine · 2 models · Revised Jun 23, 2010TCDS E11EALycoming EnginesEngine · 1 model · Revised Jun 23, 2010TCDS 4A23Dollar Associates Inc.Aircraft · 1 model · Revised Mar 4, 2010TCDS 7A2Bristol Aircraft LimitedAircraft · 1 model · Revised Mar 2, 2010TCDS A12EUIndustrie Aeronautiche e MeccanicheAircraft · 1 model · Revised Mar 2, 2010TCDS A39EUVFW-Vereinigte Flugtechnische Werke G.m.b.H.Aircraft · 1 model · Revised Mar 2, 2010TCDS P47GLMcCauley Propeller SystemsPropeller · 23 models · Revised Feb 16, 2010TCDS A36NMMinden Air CorpAircraft · 1 model · Revised Feb 11, 2010TCDS 7A6Sud AviationAircraft · 3 models · Revised Nov 24, 2009TCDS LTC-11Cal Pacific Airmotive Inc.Aircraft · 3 models · Revised Nov 18, 2009TCDS P-857McCauley Propeller SystemsPropeller · 4 models · Revised Nov 2, 2009TCDS TC 645Howard Aircraft FoundationAircraft · 2 models · Revised Aug 17, 2009TCDS A00003AKSuper 18 LLCAircraft · 1 model · Revised Jul 29, 2009TCDS 4A15Mitchell Trimotor Aircraft CorporationAircraft · 2 models · Revised Jun 23, 2009TCDS P5NEDowty PropellersPropeller · 1 model · Revised Jun 1, 2009TCDS P13EAMcCauley Propeller SystemsPropeller · 1 model · Revised Feb 26, 2009TCDS P15NEMcCauley Propeller SystemsPropeller · 7 models · Revised Feb 26, 2009TCDS P7EAMcCauley Propeller SystemsPropeller · 4 models · Revised Feb 25, 2009TCDS A39CET.B.M. Inc.Aircraft · 1 model · Revised Dec 8, 2008TCDS E00008SEMerlyn Products IncEngine · 1 model · Revised Apr 30, 2008TCDS P28BOMT-Propeller Entwicklung GmbHPropeller · 1 model · Revised Apr 24, 2008TCDS P30BOHoffmann GmbH & Co. KGPropeller · 1 model · Revised Apr 24, 2008TCDS TC 2-558STOL Aviation LLCAircraft · 1 model · Revised Oct 31, 2007TCDS P-918McCauley Propeller SystemsPropeller · 5 models · Revised Oct 25, 2007TCDS P-875R. Hunt PropellerPropeller · 2 models · Revised Sep 27, 2007TCDS P-804R. Hunt PropellerPropeller · 2 models · Revised Sep 17, 2007TCDS P-832R. Hunt PropellerPropeller · 1 model · Revised Sep 17, 2007TCDS H11SWAST Inc.Aircraft · 1 model · Revised May 1, 2007TCDS 7E1BMW Triebwerkbau G.m.b.H.Engine · 1 model · Revised Mar 28, 2007TCDS A41NMBAE Systems (Operations) LimitedAircraft · 1 model · Revised Mar 28, 2007TCDS E1EUBristol Siddeley Engines Ltd.Engine · 7 models · Revised Mar 28, 2007TCDS H1EAErickson Air-Crane Incorporated DBA Erickson Air-CraneAircraft · 1 model · Revised Mar 28, 2007TCDS H40NMErickson Air-Crane Incorporated DBA Erickson Air-CraneAircraft · 1 model · Revised Mar 28, 2007TCDS H4EAErickson Air-Crane Incorporated DBA Erickson Air-CraneAircraft · 1 model · Revised Mar 28, 2007TCDS E-299Alvis LimitedEngine · 22 models · Revised Mar 26, 2007TCDS E22NEAlfa Romeo Avio S.p.A.Engine · 1 model · Revised Mar 26, 2007TCDS E-283Rolls-Royce Deutschland Ltd & Co KGEngine · 4 models · Revised Mar 23, 2007TCDS E10NEWytwornia Sprzetu KomunikacyjnegoEngine · 4 models · Revised Mar 23, 2007TCDS E-294Rolls-Royce LimitedEngine · 1 model · Revised Mar 22, 2007TCDS E17EUTurbomeca S.A.Engine · 1 model · Revised Mar 21, 2007TCDS E4EUTurbomeca S.A.Engine · 1 model · Revised Mar 21, 2007TCDS E8EUTurbomeca S.A.Engine · 5 models · Revised Mar 20, 2007TCDS P14BOMT-Propeller Entwicklung GmbHPropeller · 2 models · Revised Mar 15, 2007TCDS 7P1Hoffmann GmbH & Co. KGPropeller · 1 model · Revised Mar 12, 2007