OpenAirDocs.org
Boeing 747-367

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.

69B00355-1SPACERAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B00355-1 · Mar 25, 201365B08103-300Bushing-PlainAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08103-300 · Mar 25, 2013113U0013-18BOLT-SPECIALIZEDAviation Materials Management Inc · PMA PQ4098CE · Replaces 113U0013-18 · Mar 25, 2013414T2358-1RubstripAviation Materials Management Inc · PMA PQ4098CE · Replaces 414T2358-1 · Mar 25, 201369B83017-1BOLTAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B83017-1 · Mar 25, 201365B05222-3SLEEVE LUB ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05222-3 · Mar 25, 201365B70518-36CONDUIT ASSY-Aviation Materials Management Inc · PMA PQ4098CE · Replaces 65B70518-36 · Mar 25, 201365B23287-1BUSHING ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B23287-1 · Mar 25, 201369B13390-1CLIPAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B13390-1 · Mar 25, 201365B80254-115BlockAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B80254-115 · Mar 25, 201369B04044-3BOLT ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04044-3 · Mar 25, 201365B05412-5PIN ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05412-5 · Mar 25, 201365B05491-4BOLTAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05491-4 · Mar 25, 201369B80168-25WASHERAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B80168-25 · Mar 25, 201365B83251-64PAD, RUBBERAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B83251-64 · Mar 25, 201365B19937-1CARRIER ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B19937-1 · Mar 25, 201369B04123-1BOLTAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04123-1 · Mar 25, 201365B05172-20TUBING SUPPORT ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05172-20 · Mar 25, 201365B81491-1PULLEY BRACKET ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B81491-1 · Mar 25, 201369B04126-1PIN, SHEARAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04126-1 · Mar 25, 201365B19933-1SLEEVEAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B19933-1 · Mar 25, 201369B04097-2NUTAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04097-2 · Mar 25, 201365B01378-1NUT ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B01378-1 · Mar 25, 201365B08104-37BUSHING-FLANGEDAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08104-37 · Mar 25, 201369B00394-1WASHER-TANG, SPECIALAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B00394-1 · Mar 25, 201365B05444-4BOLT-UPPERSIDE BRACEAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05444-4 · Mar 25, 201365B05476-2UPPER STRUT PINAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05476-2 · Mar 25, 201365B05316-6TUBE ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05316-6 · Mar 25, 201369B00158-3BEARING PADAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B00158-3 · Mar 25, 201365B01399-3RETAINER NUTAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B01399-3 · Mar 25, 201366-9776-7CollarAviation Materials Management Inc · PMA PQ4098CE · Replaces 66-9776-7 · Mar 25, 2013113U0013-17BOLT-SPECIALIZEDAviation Materials Management Inc · PMA PQ4098CE · Replaces 113U0013-17 · Mar 25, 201365B70287-150CONDUIT ASSEMBLYYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B70287-150 · Mar 25, 201365B08830-2CYLINDERAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08830-2 · Mar 25, 201369B70773-6BRACKETAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B70773-6 · Mar 25, 2013BACB28AK05-038BUSHING, PLAINAviation Materials Management Inc · PMA PQ4098CE · Replaces BACB28AK05-038 · Mar 25, 201369B71107-1ARM ASSY-Aviation Materials Management Inc · PMA PQ4098CE · Replaces 69B71107-1 · Mar 25, 201369B04081-1WASHERAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04081-1 · Mar 25, 201369B15136-3KEYAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B15136-3 · Mar 25, 201369B04140-1WASHER, KEYAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04140-1 · Mar 25, 201369B00188-1BOLTAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B00188-1 · Mar 25, 201369B14918-1RING PISTONAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B14918-1 · Mar 25, 201365B05221-2BOLT-APEXAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05221-2 · Mar 25, 201369B70231-7COUPLINGAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B70231-7 · Mar 25, 201369B00371-1BUSHINGAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B00371-1 · Mar 25, 201369B80877-2GUIDE ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B80877-2 · Mar 25, 201365B08103-264Bushing-PlainAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08103-264 · Mar 25, 201365B08859-7INSERT ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08859-7 · Mar 25, 201369B14928-1WIREAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B14928-1 · Mar 25, 201365B08854-11INNER RACEAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08854-11 · Mar 25, 2013
Back to Boeing 747-367