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 TCS AR-1Rogue River Valley Traffic AssociationAircraft · 1 model · Revised Aug 25, 2015TCDS LTC-31Rehr Louis S.Aircraft · 2 models · Revised Aug 24, 2015TCDS A2EAHelio Aircraft LLCAircraft · 1 model · Revised Aug 21, 2015TCDS A34SOLeSEAAircraft · 1 model · Revised Aug 21, 2015TCDS LTC-16Holmberg Aerial SurveyAircraft · 1 model · Revised Aug 21, 2015TCDS TCS AR-19Curtis Clayton V.Aircraft · 1 model · Revised Aug 14, 2015TCDS A24SOCenter Equities Corp.Aircraft · 1 model · Revised Jul 31, 2015TCDS A28SODay Gene C.Aircraft · 1 model · Revised Jul 31, 2015TCDS A30SOConnair InternationalAircraft · 1 model · Revised Jul 31, 2015TCDS 3A11Textron Aviation Inc.Aircraft · 1 model · Revised Jul 29, 2015TCDS P00014WIMcCauley Propeller SystemsPropeller · 1 model · Revised Mar 31, 2015TCDS B7CHAeronaut Instruction ResearchAircraft · 2 models · Revised Mar 9, 2015TCDS P-891Hartzell Propeller Inc.Propeller · 4 models · Revised Dec 22, 2014TCDS P28EAHartzell Propeller Inc.Propeller · 4 models · Revised Dec 22, 2014TCDS P29EAHartzell Propeller Inc.Propeller · 3 models · Revised Dec 22, 2014TCDS S00007LAWorldwide Aeros Corp.Aircraft · 2 models · Revised Oct 27, 2014TCDS A44EURust Robert E.Aircraft · 3 models · Revised Jul 10, 2014TCDS R00012LAHelicopter Transport Services LLCAircraft · 1 model · Revised May 2, 2014TCDS P32BOMT-Propeller Entwicklung GmbHPropeller · 2 models · Revised Feb 12, 2014TCDS AL-2S and R Aviation Services IncAircraft · 15 models · Revised Jan 29, 2014TCDS 4A27CV Nevada, LLCAircraft · 2 models · Revised Nov 15, 2013TCDS 4A30CV Nevada, LLCAircraft · 2 models · Revised Nov 15, 2013TCDS P34BOAvia Propeller Ltd.Propeller · 1 model · Revised Sep 24, 2013TCDS E28NECFM International S.A.Engine · 7 models · Revised May 17, 2013TCDS E29NECFM International S.A.Engine · 7 models · Revised May 17, 2013TCDS E18EAFranklin Sp. z.o.o.Engine · 2 models · Revised Apr 30, 2013TCDS E24EAFranklin Sp. z.o.o.Engine · 4 models · Revised Apr 30, 2013TCDS E5EAFranklin Sp. z.o.o.Engine · 2 models · Revised Apr 30, 2013TCDS R00012ATRed Tail Flying Services LLCAircraft · 1 model · Revised Feb 25, 2013TCDS P57GLMcCauley Propeller SystemsPropeller · 22 models · Revised Feb 1, 2013TCDS H5WELockheed Martin Aeronautics CompanyAircraft · 1 model · Revised Jul 23, 2012TCDS TC 652Lockheed Martin Aeronautics CompanyAircraft · 1 model · Revised Jul 23, 2012TCDS AS2EUSkyship Services Inc.Aircraft · 1 model · Revised Apr 23, 2012TCDS TS00002ATSkyship Services Inc.Aircraft · 1 model · Revised Apr 23, 2012TCDS A22EUDe Havilland Support LimitedAircraft · 3 models · Revised Mar 1, 2012TCDS A58EUFFT Gesellschaft fur FlugzeugAircraft · 1 model · Revised Mar 1, 2012TCDS A64EUFLS Aerospace (Lovaux) Ltd.Aircraft · 1 model · Revised Mar 1, 2012TCDS A68EUWSK PZL Mielec and OBR SK MielecAircraft · 1 model · Revised Mar 1, 2012TCDS G17EUSlingsby Aircraft Co Ltd.Aircraft · 1 model · Revised Mar 1, 2012TCDS G27EUSlingsby SailplanesAircraft · 1 model · Revised Mar 1, 2012TCDS E-287Curtiss-Wright/Marquette Inc.Engine · 7 models · Revised Jan 27, 2012TCDS G56EUBarry Aviation LLCAircraft · 1 model · Revised Oct 31, 2011TCDS 2-572The Boeing CompanyAircraft · 1 model · Revised Sep 29, 2011TCDS ATC 52The Boeing CompanyAircraft · 1 model · Revised Sep 29, 2011TCDS R00010SETamarack Helicopters Inc.Aircraft · 1 model · Revised Sep 1, 2011TCDS A27NMBAE Systems (Operations) LimitedAircraft · 1 model · Revised Jul 29, 2011TCDS P31BOMT-Propeller Entwicklung GmbHPropeller · 1 model · Revised Jul 7, 2011TCDS 7A7British Aerospace Aircraft GroupAircraft · 2 models · Revised Jun 24, 2011TCDS E14NERolls-Royce LimitedEngine · 1 model · Revised Jun 6, 2011TCDS P-874McCauley Propeller SystemsPropeller · 4 models · Revised Apr 21, 2011