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.

65B47753-2SWITCH SUPPORTAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B47753-2 · Mar 25, 201369B80997-8BRACKET ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B80997-8 · Mar 25, 201369B04047-1NUTAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04047-1 · Mar 25, 201365B05144-3ROLLER ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05144-3 · Mar 25, 201366-9776-1CollarAviation Materials Management Inc · PMA PQ4098CE · Replaces 66-9776-1 · Mar 25, 201365B70287-165CONDUIT ASSEMBLYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B70287-165 · Mar 25, 201365B70298-11FLEX CONDUIT ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B70298-11 · Mar 25, 201369B14917-1PLUG ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B14917-1 · Mar 25, 201365B05467-1SPACERAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05467-1 · Mar 25, 201369B00245-1WASHER,TANG SPECIALAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B00245-1 · Mar 25, 201369B00306-2WASHER, SPRING RETAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B00306-2 · Mar 25, 201365B08862-3INSERT ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08862-3 · Mar 25, 2013BACN10JD3CDNUT, CASTELLATEDAviation Materials Management Inc · PMA PQ4098CE · Replaces BACN10JD3CD · Mar 25, 201369B00187-1HALF RINGAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B00187-1 · Mar 25, 201369B04082-1WASHERAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04082-1 · Mar 25, 201365B08104-194Bushing-FlangedAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08104-194 · Mar 25, 201369B71278-1PIVOT ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B71278-1 · Mar 25, 2013BACP11K4PACKINGAviation Materials Management Inc · PMA PQ4098CE · Replaces BACP11K4 · Mar 25, 2013BACB30LJ4D15BOLT, HEX HEADAviation Materials Management Inc · PMA PQ4098CE · Replaces BACB30LJ4D15 · Mar 25, 2013BAC27ELG21MARKERAviation Materials Management Inc · PMA PQ4098CE · Replaces BAC27ELG21 · Mar 25, 201365B08865-7INSERT ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08865-7 · Mar 25, 201369B04084-3BOLT ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04084-3 · Mar 25, 201369B70231-11BOX CONNECTORAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B70231-11 · Mar 25, 201369B80882-1PINAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B80882-1 · Mar 25, 201365B04251-10ArrowAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B04251-10 · Mar 25, 201365B01361-3LEVER ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B01361-3 · Mar 25, 201369B83355-4BRACKETAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B83355-4 · Mar 25, 201365B05481-3BOLT ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05481-3 · Mar 25, 201369B04024-1NUTAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04024-1 · Mar 25, 201369B70828-4BRACKET ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B70828-4 · Mar 25, 201369B40672-1ACTUATOR ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B40672-1 · Mar 25, 201369B14103-3PIN ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B14103-3 · Mar 25, 201369B00386-3NUT-WALKING BEAMAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B00386-3 · Mar 25, 201365B05316-8TUBE ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05316-8 · Mar 25, 201365B05316-7TUBE ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05316-7 · Mar 25, 201365B05317-6TUBE ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05317-6 · Mar 25, 201369B70511-6BRACEAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B70511-6 · Mar 25, 201369B00278-2NUT-SPECIALAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B00278-2 · Mar 25, 201365B84936-10CABLE ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B84936-10 · Mar 25, 201365B08892-3BOLTAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08892-3 · Mar 25, 201369B13303-1LOCK-TABAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B13303-1 · Mar 25, 201365B08103-302Bushing-PlainAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08103-302 · Mar 25, 201365B83251-61PAD, RUBBERAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B83251-61 · Mar 25, 201365B05378-3BOLTAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05378-3 · Mar 25, 201365B08868-1BRACKETAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08868-1 · Mar 25, 201369B12026-1SUPPORT-YOKEAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B12026-1 · Mar 25, 201369B04133-3BOLT ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04133-3 · Mar 25, 201365B05456-3BOLTAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05456-3 · Mar 25, 201365B08872-2BOLT-TRUNNION PINAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08872-2 · Mar 25, 201369B70488-4FAIRLEADAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B70488-4 · Mar 25, 2013
Back to Boeing 747-367