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.

GM5341-1CWS Force TransducerKavlico Corporation · PMA PQ1186NM · Replaces 10-61072-3 · Sep 21, 2015 GM5172-1Transducer Assy, LinearKavlico Corporation · PMA PQ1186NM · Replaces 10-60810-13 · Sep 21, 2015 GM10242Force TransducerKavlico Corporation · PMA PQ1186NM · Replaces S253T401-3 · Sep 21, 2015 GM5470-1Transducer Assy, LinearKavlico Corporation · PMA PQ1186NM · Replaces 10-60810-27 · Sep 21, 2015 GM5341-6CWS Force TransducerKavlico Corporation · PMA PQ1186NM · Replaces 10-60172-6 · Sep 21, 2015 GM5322-1Linear Variable Differential Transducer (LVDT)Kavlico Corporation · PMA PQ1186NM · Replaces Dowty Aerospace 1171-082 · Sep 21, 2015 GM5021-1Transducer Assy, LinearKavlico Corporation · PMA PQ1186NM · Replaces 10-60810-4 · Sep 21, 2015 GM5177-2Transducer, Feel PressureKavlico Corporation · PMA PQ1186NM · Replaces 60B00174-2 · Sep 21, 2015 GM5341-5CWS Force TransducerKavlico Corporation · PMA PQ1186NM · Replaces 10-60172-5 · Sep 21, 2015 GM5172-6Transducer Assy, LinearKavlico Corporation · PMA PQ1186NM · Replaces 10-60810-43 · Sep 21, 2015 GM5341-4CWS Force TransducerKavlico Corporation · PMA PQ1186NM · Replaces 10-60172-4 · Sep 21, 2015 GM5175-1Transducer AssyKavlico Corporation · PMA PQ1186NM · Replaces 10-60810-10 · Sep 21, 2015 GM5177-1Transducer, Feel PressureKavlico Corporation · PMA PQ1186NM · Replaces 60B00174-1 · Sep 21, 2015 GM5163-1Transducer Assy, LinearKavlico Corporation · PMA PQ1186NM · Replaces 10-60810-16 · Sep 21, 2015 GM1032-101Transducer Assy, LinearKavlico Corporation · PMA PQ1186NM · Replaces 10-60810-37 · Sep 21, 2015 2-1032-93Transformer Assy, LinearKavlico Corporation · PMA PQ1186NM · Replaces 10-60810-34 · Sep 21, 2015 GM6425Transducer, PLAKavlico Corporation · PMA PQ1186NM · Replaces 60B90034-1 · Sep 21, 2015 LA140U4005 -1, -3, -5, -7, -9, -10, -11, -13, -14, -15, -17, -18, 19 & -20Pane, Outer, Passenger WindowLee Aerospace, Inc. · PMA PQ3766CE · Replaces 140U4005 -1, -3, -5, -7, -9, -10, -11… · Sep 14, 2015 LA140U4005 -1, -3, -5, -7, -9, -10, -11, -13, -14, -15, -17, -18, 19 & -20Pane, Outer, Passenger WindowLee Aerospace, Inc. · PMA PQ3766CE · Replaces 140U4005 -1, -3, -5, -7, -9, -10, -11… · Sep 14, 2015 107STC-232EVAS(r)VisionSafe Corporation · PMA PQ1885NM · Replaces 107STC-232 · Sep 9, 2015 107STC-231EVAS(r)VisionSafe Corporation · PMA PQ1885NM · Replaces 107STC-231 · Sep 9, 2015 743632WERotor-PumpWencor LLC · PMA PQ1370NM · Replaces 743632 · Aug 30, 2015 H-1727-15TUBE - FLUSH LINEKirkhill-TA Co · PMA PQ1981NM · Replaces 60B50097-15 · Aug 28, 2015 S-13117-211SEAL - CORNERKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-211 · Aug 28, 2015 800-182SEAL, SERODYNAMICKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-182 · Aug 28, 2015 S-13117-86SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-86 · Aug 28, 2015 5673-211SEAL-CORNERKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-211 · Aug 28, 2015 5673-1SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-1 · Aug 28, 2015 5673-210SEAL-CORNERKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-210 · Aug 28, 2015 5737-13GasketKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60814-13 · Aug 28, 2015 6565-22SEAL - NUMBER THREE ENTRY DOORKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-22 · Aug 28, 2015 5673-89SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-89 · Aug 28, 2015 800-240SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-240 · Aug 28, 2015 5673-220SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-220 · Aug 28, 2015 H-1727-16TUBE - FLUSH LINEKirkhill-TA Co · PMA PQ1981NM · Replaces 60B50097-16 · Aug 28, 2015 H-1727-2TUBE, FLUSH LINEKirkhill-TA Co · PMA PQ1981NM · Replaces 60B50097-2 · Aug 28, 2015 S-14630-1SEAL PLATE ASSYKirkhill-TA Co · PMA PQ1981NM · Replaces 60B80033-1 · Aug 28, 2015 S-13117-141BULB SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-141 · Aug 28, 2015 800-223SEAL - CORNER PLUGKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-223 · Aug 28, 2015 S-13117-116FABRIC COVERED AERODYNAMIC SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-116 · Aug 28, 2015 S-13117-189SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-189 · Aug 28, 2015 5673-2SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-2 · Aug 28, 2015 H-1727-9HOSE FLUSH LINEKirkhill-TA Co · PMA PQ1981NM · Replaces 60B50097-9 · Aug 28, 2015 800-184SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-184 · Aug 28, 2015 800-220SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-220 · Aug 28, 2015 6565-36SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 60B10000-36 · Aug 28, 2015 C-3768-6PLUGKirkhill-TA Co · PMA PQ1981NM · Replaces 60B50062-6 · Aug 28, 2015 S-13117-183SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-183 · Aug 28, 2015 SF15-103-296SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-296 · Aug 28, 2015 5673-39AERODYNAMIC SEALKirkhill-TA Co · PMA PQ1981NM · Replaces 10-60754-39 · Aug 28, 2015

Back to Boeing 747-367