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.

5373-13SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60814-13 · Aug 28, 2015 800-236SEAL, AERODYNAMICKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-236 · Aug 28, 2015 800-204SEAL INSTLKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-204 · Aug 28, 2015 S-13117-121SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-121 · Aug 28, 2015 5673-90SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-90 · Aug 28, 2015 S-14644-26SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-26 · Aug 28, 2015 B-5132-8RUBBER BOOT ASSYKirkhill-TA Co · PMA PQ1981NM · Replaces 60B90107-8 · Aug 28, 2015 S-13117-188SEAL, AERODYNAMICKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-188 · 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 S-14644-501SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-501 · Aug 28, 2015 S-13117-2SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-2 · Aug 28, 2015 BACG20AF6D1GROMMETKirkhill-TA Co · PMA PQ1981NM · Replaces BACG20AF6D1 · Aug 28, 2015 BACG20AF4B2GROMMETKirkhill-TA Co · PMA PQ1981NM · Replaces BACG20AF4B2 · Aug 28, 2015 5673-523SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-523 · Aug 28, 2015 5673-520SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-520 · Aug 28, 2015 5673-141SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-141 · Aug 28, 2015 S-13117-32SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-32 · Aug 28, 2015 S-13117-149SEAL-BULBKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-149 · Aug 28, 2015 SF15-103-194SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-194 · Aug 28, 2015 S-13117-214END PLUGKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-214 · Aug 28, 2015 S-17381-2SEAL ASSYKirkhill-TA Co · PMA PQ1981NM · Replaces 60B89600-2 · Aug 28, 2015 SF15-103-201CLOSURE PLUGKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-201 · Aug 28, 2015 C-3768-23SLEEVEKirkhill-TA Co · PMA PQ1981NM · Replaces 60B50062-23 · Aug 28, 2015 S-13117-213Seal-PlugKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-213 · Aug 28, 2015 S-14644-25SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-25 · Aug 28, 2015 S-13117-140BULB SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-140 · Aug 28, 2015 SF15-103-261SEAL, AERODYNAMICKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-261 · Aug 28, 2015 6565-21SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-21 · 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 5673-22SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-22 · Aug 28, 2015 SF15-103-219SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-219 · Aug 28, 2015 800-22SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-22 · Aug 28, 2015 S-13117-223SEAL - CORNER PLUGKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-223 · Aug 28, 2015 800-187SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-187 · Aug 28, 2015 S-13117-20SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-20 · Aug 28, 2015 800-120SealKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-120 · Aug 28, 2015 S-13117-39SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-39 · Aug 28, 2015 800-181SEAL, SERODYNAMICKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-181 · Aug 28, 2015 SF15-103-39SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-39 · Aug 28, 2015 5673-140SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-140 · Aug 28, 2015 S-13117-1088SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-1088 · Aug 28, 2015 800-185SEAL, AERODYNAMICKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-185 · Aug 28, 2015 SF15-103-258SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-258 · Aug 28, 2015 800-215END PLUGKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-215 · Aug 28, 2015 800-192SEAL, AERODYNAMICKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-192 · Aug 28, 2015 5673-515BLADE SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-515 · Aug 28, 2015 800-200CLOSURE PLUGKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-200 · Aug 28, 2015 5673-221FABRIC COVERED SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-221 · Aug 28, 2015

Back to Boeing 747-367