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.

S-14644-19SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-19 · Aug 28, 2015 5673-197AERO SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-197 · Aug 28, 2015 SF15-103-419SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-419 · Aug 28, 2015 800-219SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-219 · Aug 28, 2015 S-13117-192SEAL, AERODYNAMICKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-192 · Aug 28, 2015 S-13117-22SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-22 · Aug 28, 2015 H-1727-25HOSEKirkhill-TA Co · PMA PQ1981NM · Replaces 60B50097-25 · Aug 28, 2015 SF15-103-2SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-2 · Aug 28, 2015 SF15-103-36SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-36 · Aug 28, 2015 S-13117-306SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-306 · Aug 28, 2015 SF15-103-209SEAL-CORNERKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-209 · Aug 28, 2015 800-121SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-121 · Aug 28, 2015 S-13117-150SEAL-BULBKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-150 · Aug 28, 2015 800-189SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-189 · Aug 28, 2015 S-13117-307SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-307 · Aug 28, 2015 BACG20AF4F1GROMMETKirkhill-TA Co · PMA PQ1981NM · Replaces BACG20AF4F1 · Aug 28, 2015 800-016SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-16 · Aug 28, 2015 SF15-103-141BULB SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-141 · Aug 28, 2015 800-258SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-258 · Aug 28, 2015 SF15-103-121SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-121 · Aug 28, 2015 800-001SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-1 · Aug 28, 2015 S-13117-515SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-515 · Aug 28, 2015 800-259SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-259 · Aug 28, 2015 S-13117-83W SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-83 · Aug 28, 2015 5673-849SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-849 · Aug 28, 2015 S-13117-186SEAL, AERODYNAMICKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-186 · Aug 28, 2015 S-13117-182SEAL, AERODYNAMICKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-182 · Aug 28, 2015 SF15-103-200CLOSURE PLUGKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-200 · Aug 28, 2015 S-13117-159SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-159 · Aug 28, 2015 S-13117-177SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-177 · Aug 28, 2015 SF15-103-32SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-32 · Aug 28, 2015 SF15-103-197AERO SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-197 · Aug 28, 2015 800-205SEAL INSTLKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-205 · Aug 28, 2015 H-1727-1TUBE - FLUSH LINEKirkhill-TA Co · PMA PQ1981NM · Replaces 60B50097-1 · Aug 28, 2015 BACG20AF6B2AGROMMETKirkhill-TA Co · PMA PQ1981NM · Replaces BACG20AF6B28A · Aug 28, 2015 827SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 60B90601-2 · Aug 28, 2015 800-207Seal-End PlugKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-207 · Aug 28, 2015 S-13117-185SEAL, AERODYNAMICKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-185 · Aug 28, 2015 H-1727-17HOSE, FLUSH LINEKirkhill-TA Co · PMA PQ1981NM · Replaces 60B50097-17 · Aug 28, 2015 SF15-103-196AERO SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-196 · Aug 28, 2015 800-108SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-108 · Aug 28, 2015 SF15-103-195FABRIC COVERED AERODYNAMIC SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-195 · Aug 28, 2015 800-177SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-177 · Aug 28, 2015 SF15-103-146SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-146 · Aug 28, 2015 S-13117-303SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-303 · Aug 28, 2015 S-14644-21SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-21 · Aug 28, 2015 5673-119SEAL, AERODYNAMICKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-119 · Aug 28, 2015 BACG20AF3D1GROMMETKirkhill-TA Co · PMA PQ1981NM · Replaces BACG20AF3D1 · Aug 28, 2015 S-13117-187SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-187 · Aug 28, 2015 S-13117-219SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-219 · Aug 28, 2015

Back to Boeing 747-367