Skip to content

PMA parts · 38,389

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, ['747SR 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, ['747SR 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-257SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-257 · Aug 28, 2015 BACG20AF6B1AGROMMETKirkhill-TA Co · PMA PQ1981NM · Replaces BACG20AF6B1A · Aug 28, 2015 6565-41SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-41 · Aug 28, 2015 H-1727-27HOSE, FLUSH LINEKirkhill-TA Co · PMA PQ1981NM · Replaces 60B50097-27 · Aug 28, 2015 S-13117-7SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-7 · Aug 28, 2015 BACG20AF7B1AGROMMETKirkhill-TA Co · PMA PQ1981NM · Replaces BACG20AF7B1A · Aug 28, 2015 S-13117-305SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-305 · Aug 28, 2015 S-13117-212Seal-PlugKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-212 · Aug 28, 2015 H-1727-14HOSEKirkhill-TA Co · PMA PQ1981NM · Replaces 60B50097-14 · Aug 28, 2015 H-1727-22HOSE, FLUSH LINEKirkhill-TA Co · PMA PQ1981NM · Replaces 60B50097-22 · Aug 28, 2015 H-1727-6LINEKirkhill-TA Co · PMA PQ1981NM · Replaces 60B50097-6 · Aug 28, 2015 800-206SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-206 · Aug 28, 2015 S-13117-304SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-304 · Aug 28, 2015 S-13117-312SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-312 · Aug 28, 2015 6565-24SealKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-24 · Aug 28, 2015 S-13117-121SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-121 · Aug 28, 2015 5673-7SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-7 · Aug 28, 2015 S-13117-298SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-298 · Aug 28, 2015 BACG20AF6D1GROMMETKirkhill-TA Co · PMA PQ1981NM · Replaces BACG20AF6D1 · Aug 28, 2015 BACG20AF4B2GROMMETKirkhill-TA Co · PMA PQ1981NM · Replaces BACG20AF4B2 · Aug 28, 2015 S-13117-213Seal-PlugKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-213 · Aug 28, 2015 BACG20AF5B3AGROMMETKirkhill-TA Co · PMA PQ1981NM · Replaces BACG20AF5B3A · Aug 28, 2015 S-13117-301SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-301 · Aug 28, 2015 S-13117-297SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-297 · Aug 28, 2015 800-120SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-120 · Aug 28, 2015 5673-515BLADE SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-515 · Aug 28, 2015 S-13117-315SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-315 · Aug 28, 2015 H-1727-25HOSEKirkhill-TA Co · PMA PQ1981NM · Replaces 60B50097-25 · Aug 28, 2015 S-13117-306SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-306 · Aug 28, 2015 800-121SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-121 · Aug 28, 2015 S-13117-307SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-307 · Aug 28, 2015 S-13117-515SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-515 · Aug 28, 2015 S-13117-159SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-159 · Aug 28, 2015 BACG20AF3B1AGROMMETKirkhill-TA Co · PMA PQ1981NM · Replaces BACG20AF3B1A · Aug 28, 2015 H-1727-1TUBE - FLUSH LINEKirkhill-TA Co · PMA PQ1981NM · Replaces 60B50097-1 · Aug 28, 2015 800-207Seal-End PlugKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-207 · Aug 28, 2015 800-108SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-108 · Aug 28, 2015 S-13117-303SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-303 · Aug 28, 2015 S-13117-257SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-257 · Aug 28, 2015 S-13117-308SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-308 · Aug 28, 2015 S-13117-309SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-309 · Aug 28, 2015 5737-18SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60814-18 · Aug 28, 2015 S-13117-302SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-302 · Aug 28, 2015 H-1727-3FLUSH HOSEKirkhill-TA Co · PMA PQ1981NM · Replaces 60B50097-3 · Aug 28, 2015 5673-108SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-108 · Aug 28, 2015 SF15-103-108SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-108 · Aug 28, 2015 SF15-103-120SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-120 · Aug 28, 2015 S-13117-299AERODYNAMIC SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-299 · Aug 28, 2015 S-13117-310SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-310 · Aug 28, 2015 S-13117-311SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-311 · Aug 28, 2015

Back to Boeing 747-SR