Skip to content

PMA parts · 58,851

Current parts manufacturer approvals (PMA): parts the FAA has approved companies to make as replacements or modifications. Each record lists its models as free text; OpenAirDocs matched them to this model on its data sheet, so check the FAA record before relying on it. Newest first.

Query with SQL

duckdb -csv -c "SELECT drs_guid, part_number, part_name, holder, pma_number, replaces_part, supplement_date, tcds_models
  FROM 'https://openairdocs.org/data/latest/faa_type_certificate_pma.parquet'
  WHERE tcds_number IN ('A20WE')
    AND len(list_intersect(tcds_models, ['747-300 Series'])) > 0
  ORDER BY supplement_date DESC, drs_guid DESC"

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.

SELECT drs_guid, part_number, part_name, holder, pma_number, replaces_part, supplement_date, tcds_models
FROM 'https://openairdocs.org/data/latest/faa_type_certificate_pma.parquet'
WHERE tcds_number IN ('A20WE')
  AND len(list_intersect(tcds_models, ['747-300 Series'])) > 0
ORDER BY supplement_date DESC, drs_guid DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

800-201CLOSURE PLUGKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-201 · Aug 28, 2015 S-13117-146SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-146 · Aug 28, 2015 800-83W SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-83 · Aug 28, 2015 5673-83W SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-83 · Aug 28, 2015 SF15-103-1SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-1 · Aug 28, 2015 5673-159SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-159 · Aug 28, 2015 S-14216-13SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60814-13 · Aug 28, 2015 800-186SEAL, AERODYNAMICKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-186 · Aug 28, 2015 SF15-103-92SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-92 · Aug 28, 2015 800-119SEAL, AERODYNAMICKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-119 · Aug 28, 2015 6565-40SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-40 · Aug 28, 2015 5673-107RETAINERKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-107 · Aug 28, 2015 SF15-103-278SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-278 · Aug 28, 2015 SF15-103-140BULB SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-140 · Aug 28, 2015 5673-196AERO SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-196 · Aug 28, 2015 800-196SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-196 · Aug 28, 2015 S-13117-229SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-229 · Aug 28, 2015 S-13117-215END PLUGKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-215 · Aug 28, 2015 S-13117-120SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-120 · Aug 28, 2015 S-13117-184SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-184 · Aug 28, 2015 BACG20AF12B2AGROMMETKirkhill-TA Co · PMA PQ1981NM · Replaces BACG20AF12B2A · Aug 28, 2015 800-91SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-91 · Aug 28, 2015 5673-20SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-20 · Aug 28, 2015 BACP20BAPLUG-FILLERKirkhill-TA Co · PMA PQ1981NM · Replaces BACG20BA · Aug 28, 2015 S-13117-36SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-36 · Aug 28, 2015 C-3768-2ELBOWKirkhill-TA Co · PMA PQ1981NM · Replaces 60B50062-2 · Aug 28, 2015 5673-194SEAL - FABRIC COVERED, AERODYNAMICKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-194 · Aug 28, 2015 6565-5SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-5 · Aug 28, 2015 5673-121SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-121 · Aug 28, 2015 SF15-103-230SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-230 · Aug 28, 2015 800-221SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-221 · Aug 28, 2015 BACG20AF2B1GROMMETKirkhill-TA Co · PMA PQ1981NM · Replaces BACG20AF2B1 · Aug 28, 2015 S-13117-210SEAL - CORNERKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-210 · Aug 28, 2015 5673-278AERODYNAMIC SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-278 · Aug 28, 2015 5673-219SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-219 · Aug 28, 2015 S-13117-262SEAL, AERODYNAMICKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-262 · Aug 28, 2015 800-191SEAL, AERODYNAMICKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-191 · Aug 28, 2015 800-183SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-183 · Aug 28, 2015 S-13117-191SEAL, AERODYNAMICKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-191 · Aug 28, 2015 H-1727-8HOSE FLUSH LINEKirkhill-TA Co · PMA PQ1981NM · Replaces 60B50097-8 · Aug 28, 2015 800-87SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-87 · Aug 28, 2015 S-14644-10SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-10 · Aug 28, 2015 6565-37PRESSURE SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-37 · Aug 28, 2015 5673-208SEAL-CORNERKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-208 · Aug 28, 2015 5673-88SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-88 · Aug 28, 2015 D-4640SEAL, AIRKirkhill-TA Co · PMA PQ1981NM · Replaces 60B92410-1 · Aug 28, 2015 S-14630-2SEAL COVERKirkhill-TA Co · PMA PQ1981NM · Replaces 60B80033-2 · Aug 28, 2015 S-13117-221AERODYNAMIC SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-221 · Aug 28, 2015 6565-2SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-2 · Aug 28, 2015 5673-87SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-87 · Aug 28, 2015

Back to Boeing 747-367