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.

65B05195-2SLEEVE AXLEAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05195-2 · Mar 25, 201369B00174-2BUSHINGAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B00174-2 · Mar 25, 201365B70514-2PULL BOX ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B70514-2 · Mar 25, 2013BACB30UU6K19BOLT. 12 PT HEADAviation Materials Management Inc · PMA PQ4098CE · Replaces BACB30UU6K19 · Mar 25, 2013BACC14AD06JCAPAviation Materials Management Inc · PMA PQ4098CE · Replaces BACC14AD06J · Mar 25, 201369B00316-1PLUGAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B00316-1 · Mar 25, 201369B04021-1PLATE ASSY-STOPAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04021-1 · Mar 25, 201369B81658-2PINAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B81658-2 · Mar 25, 201365B05463-4BOLT-STRUT/SPINDLEAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05463-4 · Mar 25, 201365B82585-4Actuator AssyAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B82585-4 · Mar 25, 201369B70950-1BLOCKAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B70950-1 · Mar 25, 201365B70327-8JUNCTION BOX ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B70327-8 · Mar 25, 201365B01498-7Bearing AssyAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B01498-7 · Mar 25, 201365B08103-70BUSHING-PLAINAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08103-70 · Mar 25, 201365B08882-3RETAINER ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08882-3 · Mar 25, 201369B00317-1WASHER-TANGAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B00317-1 · Mar 25, 201365B05296-3PLUG ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05296-3 · Mar 25, 201365B08103-258Bushing-PlainAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08103-258 · Mar 25, 201369B11232-2NUT-SUPPORT PINAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B11232-2 · Mar 25, 201365B01314-10STRIKER ARM ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B01314-10 · Mar 25, 201365B80254-158ChannelAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B80254-158 · Mar 25, 201365B01585-13BRACKET ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B01585-13 · Mar 25, 201369B11223-3COLLARAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B11223-3 · Mar 25, 201369B13308-1SPACER, THREADEDAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B13308-1 · Mar 25, 201365B05452-3BOLT ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05452-3 · Mar 25, 201365B01553-1ADAPTERAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B01553-1 · Mar 25, 201365B08882-5RETAINER ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08882-5 · Mar 25, 201365-35436-5RetainerAviation Materials Management Inc · PMA PQ4098CE · Replaces 65-35436-5 · Mar 25, 201366-15424-1Plate-BearingAviation Materials Management Inc · PMA PQ4098CE · Replaces 66-15424-1 · Mar 25, 201365B08103-69BUSHING-PLAINAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08103-69 · Mar 25, 201365B83251-39RADIUS FILLERAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B83251-39 · Mar 25, 201366-12688-502BushingAviation Materials Management Inc · PMA PQ4098CE · Replaces 66-12688-502 · Mar 25, 201369B82574-1SUPPORT ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B82574-1 · Mar 25, 201365B80113-2BRACKET ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B80113-2 · Mar 25, 201369B13363-3KEYAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B13363-3 · Mar 25, 201365B08104-200Bushing-FlangedAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08104-200 · Mar 25, 2013BACU24AA0806TUNION, BULKHEADAviation Materials Management Inc · PMA PQ4098CE · Replaces BACU24AA0806T · Mar 25, 201365B08104-224Bushing-FlangedAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08104-224 · Mar 25, 201365B08104-201Bushing-FlangedAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08104-201 · Mar 25, 201365B08104-226Bushing-FlangedAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08104-226 · Mar 25, 201365B05449-2BOLT UPPER TRIPODAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05449-2 · Mar 25, 2013332U2112-3Reinforcement PadAviation Materials Management Inc · PMA PQ4098CE · Replaces 332U2112-3 · Mar 25, 201365B05260-2BOLTAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05260-2 · Mar 25, 2013BACB30PN12-24BOLT, EXT WRENCHINGAviation Materials Management Inc · PMA PQ4098CE · Replaces BACB30PN12-24 · Mar 25, 201369B04023-1WASHER-KEYAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B04023-1 · Mar 25, 201369B00203-2NUT-SPACERAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B00203-2 · Mar 25, 201365-35436-14RetainerAviation Materials Management Inc · PMA PQ4098CE · Replaces 65-35436-14 · Mar 25, 2013BACC14AD06JLCAPAviation Materials Management Inc · PMA PQ4098CE · Replaces BACC14AD06JL · Mar 25, 201369B70828-5PADAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B70828-5 · Mar 25, 201365B70537-19CONDUIT ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B70537-19 · Mar 25, 2013
Back to Boeing 747-230B