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 1H12Boeing Defense & Space GroupAircraft · 4 models · Revised May 15, 1971TCDS P-870Hamilton Standard DivisionPropeller · 1 model · Revised Jan 7, 1971TCDS P-871Hamilton Standard DivisionPropeller · 1 model · Revised Jan 7, 1971TCDS P-853Hamilton Standard DivisionPropeller · 1 model · Revised Jan 6, 1971TCDS P-856Hamilton Standard DivisionPropeller · 1 model · Revised Jan 6, 1971TCDS P-887Hamilton Standard DivisionPropeller · 1 model · Revised Jan 5, 1971TCDS P-749Hamilton Standard DivisionPropeller · 1 model · Revised Dec 11, 1970TCDS P-785Hamilton Standard DivisionPropeller · 1 model · Revised Dec 4, 1970TCDS P-786Hamilton Standard DivisionPropeller · 1 model · Revised Dec 4, 1970TCDS P-784Hamilton Standard DivisionPropeller · 1 model · Revised Dec 3, 1970TCDS P-881Hamilton Standard DivisionPropeller · 1 model · Revised Dec 3, 1970TCDS P-206Hamilton Standard DivisionPropeller · 2 models · Revised Dec 1, 1970TCDS P-255Hamilton Standard DivisionPropeller · 1 model · Revised Nov 17, 1970TCDS E21EABristol Aerospace (1968) LimitedEngine · 1 model · Revised Sep 14, 1970TCDS E1PCIshikawajima-Harima Heavy Industries Co. Ltd.Engine · 2 models · Revised Aug 10, 1970TCDS P-825Curtiss-Wright CorporationPropeller · 1 model · Revised May 1, 1970TCDS P-826Curtiss-Wright CorporationPropeller · 1 model · Revised May 1, 1970TCDS P-847Curtiss-Wright CorporationPropeller · 1 model · Revised May 1, 1970TCDS P-883Curtiss-Wright CorporationPropeller · 1 model · Revised May 1, 1970TCDS P-869Sensenich Propeller Manufacturing Company Inc.Propeller · 2 models · Revised Apr 13, 1970TCDS A13EAFound Brothers Aviation LimitedAircraft · 1 model · Revised Jan 1, 1970TCDS P-736Hamilton Standard DivisionPropeller · 1 model · Revised Aug 3, 1969TCDS P20EAHamilton Standard DivisionPropeller · 1 model · Revised May 15, 1969TCDS P26EAHamilton Standard DivisionPropeller · 1 model · Revised May 15, 1969TCDS A19EUAeronautica Macchi S.p.A. & Aerfer-Industrie Aerospaziali Meridionali S.p.A.Aircraft · 1 model · Revised Feb 26, 1969TCDS P-861Sensenich Propeller Manufacturing Company Inc.Propeller · 3 models · Revised Nov 1, 1968TCDS G18EUSlingsby Aviation Ltd.Aircraft · 1 model · Revised Sep 3, 1968TCDS E7EUTurbomeca S.A.Engine · 1 model · Revised Aug 29, 1968TCDS E-291Pratt & Whitney DivisionEngine · 6 models · Revised Sep 15, 1967TCDS E-290Pratt & Whitney DivisionEngine · 4 models · Revised Sep 6, 1967TCDS A3PCC. Itoh Aircraft Maintenance and Engineering Co. Ltd.Aircraft · 1 model · Revised Dec 5, 1966TCDS E-123Pratt & Whitney DivisionEngine · 7 models · Revised Jul 15, 1966TCDS E-306General Electric CompanyEngine · 3 models · Revised Feb 15, 1966TCDS A8EURobertson Cliff c/o Gadbois Business ManagementAircraft · 1 model · Revised Feb 7, 1966TCDS G7EUVilegtuigbouw N.V.Aircraft · 1 model · Revised Aug 2, 1965TCDS A2EUSimmering Graz Pauker A.G.Aircraft · 2 models · Revised Jun 11, 1965TCDS G1WEPrue Irving O.Aircraft · 1 model · Revised Jan 15, 1965TCDS E-250Aerojet-General CorporationEngine · 1 model · Revised Nov 23, 1964TCDS A5WEConroy James F.Aircraft · 1 model · Revised Sep 1, 1964TCDS 7G5Slingsby Aviation Ltd.Aircraft · 1 model · Revised May 22, 1964TCDS E6CEContinental Aviation & Engineering CorporationEngine · 1 model · Revised May 11, 1964TCDS G-20Slingsby Sailplanes Ltd.Aircraft · 1 model · Revised Apr 1, 1964TCDS G-21Slingsby Aviation Ltd.Aircraft · 1 model · Revised Apr 1, 1964TCDS G2INSlingsby Aviation Ltd.Aircraft · 1 model · Revised Apr 1, 1964TCDS G3EUSezione Sperimentale Volvo A VelaAircraft · 1 model · Revised Mar 13, 1964TCDS A9INSfermaAircraft · 2 models · Revised Mar 4, 1964TCDS A3INAvions JodelAircraft · 1 model · Revised Feb 3, 1964TCDS P-894Detroit Diesel AllisonPropeller · 1 model · Revised Dec 15, 1963TCDS 2A5Tempo Design CorporationAircraft · 2 models · Revised Nov 1, 1963TCDS A1WEHamilton Aircraft Company Inc.Aircraft · 2 models · Revised Oct 1, 1963