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.

SF15-103-20SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-20 · Aug 28, 2015 S-13117-190SEAL, AERODYNAMICKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-190 · Aug 28, 2015 6565-41SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-41 · Aug 28, 2015 SF15-103-235SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-235 · Aug 28, 2015 6565-23SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-23 · Aug 28, 2015 SF15-103-220SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-220 · Aug 28, 2015 S-13117-1SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-1 · Aug 28, 2015 9562SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-35 · Aug 28, 2015 S-13117-261SEAL, AERODYNAMICKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-261 · 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 800-231SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-231 · Aug 28, 2015 5673-1088SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-1088 · Aug 28, 2015 S-13117-305SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-305 · Aug 28, 2015 S-13117-91SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-91 · Aug 28, 2015 5673-177AERO SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-177 · Aug 28, 2015 S-13117-16SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-16 · Aug 28, 2015 800-193SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-193 · Aug 28, 2015 800-188SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-188 · Aug 28, 2015 SF15-103-210SEAL-CORNERKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-210 · Aug 28, 2015 S-14644-22SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-22 · Aug 28, 2015 S-13117-266SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-266 · Aug 28, 2015 800-36SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-36 · Aug 28, 2015 S-16954SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-35 · Aug 28, 2015 SF15-103-234SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-234 · Aug 28, 2015 800-214END PLUGKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-214 · Aug 28, 2015 S-13117-212Seal-PlugKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-212 · Aug 28, 2015 C-3768-3SLEEVE COUPLINGKirkhill-TA Co · PMA PQ1981NM · Replaces 60B50062-3 · Aug 28, 2015 S-13117-151SEAL-BULBKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-151 · Aug 28, 2015 6565-502SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-502 · Aug 28, 2015 SF15-103-208SEAL-CORNERKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-208 · Aug 28, 2015 6565-501SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-501 · Aug 28, 2015 S-13117-220SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-220 · Aug 28, 2015 H-1727-22HOSE, FLUSH LINEKirkhill-TA Co · PMA PQ1981NM · Replaces 60B50097-22 · Aug 28, 2015 800-239SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-239 · 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-14644-9SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-9 · Aug 28, 2015 S-13117-258SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-258 · Aug 28, 2015 SF15-103-16SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-16 · Aug 28, 2015 S-13117-304SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-304 · Aug 28, 2015 5673-86SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-86 · Aug 28, 2015 S-14644-502SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-502 · Aug 28, 2015 SF15-103-231SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-231 · Aug 28, 2015 800-114AERODYNAMIC SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-114 · Aug 28, 2015 S-13117-312SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-312 · Aug 28, 2015 800-194SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-194 · Aug 28, 2015 SF15-103-22SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-22 · Aug 28, 2015 6565-24SealKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-24 · Aug 28, 2015 BACG20AF6B7GROMMETKirkhill-TA Co · PMA PQ1981NM · Replaces BACG20AF6B7 · Aug 28, 2015

Back to Boeing 747-367