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.

65B83251-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, 201365B47753-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, 201365B53931-4Bracket AssyAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B53931-4 · 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, 201365B19934-4Carrier AssyAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B19934-4 · Mar 25, 2013
Back to Boeing 747-230B