Boeing 747-230B

PMA parts · 62,097

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-200B 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.

69B14103-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, 201365B15945-11FITTING ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B15945-11 · 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, 201369B00355-1SPACERAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B00355-1 · Mar 25, 201365B08103-300Bushing-PlainAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08103-300 · Mar 25, 201369B83017-1BOLTAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B83017-1 · Mar 25, 2013284T0748-1GASKET - HORNAviation Materials Management Inc · PMA PQ4098CE · Replaces 284T04748-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, 201365B70287-150CONDUIT ASSEMBLYYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B70287-150 · Mar 25, 2013
Back to Boeing 747-230B