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.

65B70287-183CONDUIT ASSY-BODYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B70287-183 · Mar 25, 201365B70287-172CONDUIT ASSEMBLYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B70287-172 · Mar 25, 201365B40379-12BRACKETAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B40379-12 · Mar 25, 201369B19175-2WASHER-SPECIALAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B19175-2 · Mar 25, 201365B08857-3BOLT ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08857-3 · Mar 25, 201369B04037-1PADAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04037-1 · Mar 25, 201365B83251-79SHIM-LAMINATEDAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B83251-79 · Mar 25, 201365B05469-1NUTAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05469-1 · Mar 25, 201369B70997-7FAIRLEAD ASSY-Aviation Materials Management Inc · PMA PQ4098CE · Replaces 69B70997-7 · Mar 25, 201365B70468-1BOX ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B70468-1 · Mar 25, 201365B70287-158CONDUIT ASSEMBLYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B70287-158 · Mar 25, 201365B08104-70BUSHING-FLANGEDAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08104-70 · Mar 25, 201365B08103-262Bushing-PlainAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08103-262 · Mar 25, 201369B00107-1BUSHINGAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B00107-1 · Mar 25, 201365B84896-8RODAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B84896-8 · Mar 25, 201365B08104-77BUSHING-FLANGEDAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08104-77 · Mar 25, 201369B04102-1WASHER-TANGAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04102-1 · Mar 25, 201365B05471-4PIVOT PINAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05471-4 · Mar 25, 201369B00177-2WASHERAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B00177-2 · Mar 25, 201366-12688-1BushingAviation Materials Management Inc · PMA PQ4098CE · Replaces 66-12688-1 · Mar 25, 201365B18247-1BULKHEAD ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B18247-1 · Mar 25, 201369B14927-2REDUCERAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B14927-2 · Mar 25, 201369B04139-1NUTAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04139-1 · Mar 25, 201365B05190-1WASHERAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05190-1 · Mar 25, 201369B70488-6FAIRLEADAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B70488-6 · Mar 25, 2013313T3371-19SealAviation Materials Management Inc · PMA PQ4098CE · Replaces 313T3371-19 · Mar 25, 201369B04027-1NUTAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04027-1 · Mar 25, 201365B05489-1COUPLINGAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05489-1 · Mar 25, 201369B40660-13SHIMAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B40660-13 · Mar 25, 201369B04108-3NUT, SPECIALAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04108-3 · Mar 25, 201365B05271-3BRACE ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05271-3 · Mar 25, 201365B70518-25CONDUIT ASSEMBLYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B70518-25 · Mar 25, 201369B83911-4PLATEAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B83911-4 · Mar 25, 201365B83251-67STRAP ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B83251-67 · Mar 25, 201365B05172-18TUBING SUPPORTAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05172-18 · Mar 25, 201365B08845-2PINAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08845-2 · Mar 25, 201369B80626-5WASHERAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B80626-5 · Mar 25, 201369B04008-3BOLT ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04008-3 · Mar 25, 201365B19935-1SLEEVEAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B19935-1 · Mar 25, 201369B04155-1WASHERAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04155-1 · Mar 25, 201365B70518-27CONDUIT ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B70518-27 · Mar 25, 201365B10197-21WASHERAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B10197-21 · Mar 25, 201369B13380-5BEARING ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B13380-5 · Mar 25, 201369B42183-1SUPPORT ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B42183-1 · Mar 25, 201369B04134-1LOCK-TABAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04134-1 · Mar 25, 201365B08104-44BUSHING-FLANGEDAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08104-44 · Mar 25, 201365B10713-14BRACKET ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B10713-14 · Mar 25, 201365B05193-3SLEEVE-AXLEAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05193-3 · Mar 25, 201366-12687-1PinAviation Materials Management Inc · PMA PQ4098CE · Replaces 66-12687-1 · Mar 25, 201369B00311-1SLEEVEAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B00311-1 · Mar 25, 2013
Back to Boeing 747-367