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.

10A347-350-350Housing, Peri-SealRSA Engineered Products LLC · PMA PQ1445NM · Replaces 10A347-350-350 · Apr 24, 201314A320-7RetainerRSA Engineered Products LLC · PMA PQ1445NM · Replaces 14A320-7 · Apr 24, 2013460-825SealRSA Engineered Products LLC · PMA PQ1445NM · Replaces 460-825 · Apr 24, 201314A314-7PistonRSA Engineered Products LLC · PMA PQ1445NM · Replaces 14A314-7 · Apr 24, 201314A339SealRSA Engineered Products LLC · PMA PQ1445NM · Replaces 14A339 · Apr 24, 201314A469SealRSA Engineered Products LLC · PMA PQ1445NM · Replaces 14A469 · Apr 24, 201314A362RetainerRSA Engineered Products LLC · PMA PQ1445NM · Replaces 14A362 · Apr 24, 2013ADV-3575-1251-07Heater AssyAdvantage Aerospace LLC · PMA PQ2528NM · Replaces 3575-1251-07, 3575-1251-01… · Apr 18, 2013ADV-428-0074-1Tank AssyAdvantage Aerospace LLC · PMA PQ2528NM · Replaces 428-0074-1 · Apr 18, 2013ADV-RL119-2RelayAdvantage Aerospace LLC · PMA PQ2528NM · Replaces KR90693-2 KR90693-1 KR14DGE24VDC RL-119 · Apr 18, 201321FA213FilterKeddeg Company · PMA PQ3745CE · Replaces 69B42967-1 · Apr 15, 2013LA140U4005-18Pane - Outer, Passenger WindowTriumph Aerospace Systems Inc · PMA PQ3766CE · Replaces 140U4005 -18 · Apr 9, 2013LA140U4005-19Pane - Outer, Passenger WindowTriumph Aerospace Systems Inc · PMA PQ3766CE · Replaces 140U4005 -19 · Apr 9, 20138050917-0006BWEPaper, RollWencor LLC · PMA PQ1370NM · Replaces 8050917-0006 · Apr 9, 2013LA140U4005-13Pane - Outer, Passenger WindowTriumph Aerospace Systems Inc · PMA PQ3766CE · Replaces 140U4005-13 · Apr 9, 2013LA140U4005-5Pane - Outer, Passenger WindowTriumph Aerospace Systems Inc · PMA PQ3766CE · Replaces 140U4005 -5 · Apr 9, 2013LA140U4005-11Pane - Outer, Passenger WindowTriumph Aerospace Systems Inc · PMA PQ3766CE · Replaces 140U4005 -11 · Apr 9, 2013LA140U4005-9Pane - Outer, Passenger WindowTriumph Aerospace Systems Inc · PMA PQ3766CE · Replaces 140U4005-9 · Apr 9, 20133501741-2WEGearshaft, SpurWencor LLC · PMA PQ1370NM · Replaces 3501741-2 · Apr 9, 2013LA140U4005-14Pane - Outer, Passenger WindowTriumph Aerospace Systems Inc · PMA PQ3766CE · Replaces 140U4005 -14 · Apr 9, 2013LA140U4005-10Pane - Outer, Passenger WindowTriumph Aerospace Systems Inc · PMA PQ3766CE · Replaces 140U4005 -10 · Apr 9, 2013LA140U4005-15Pane - Outer, Passenger WindowTriumph Aerospace Systems Inc · PMA PQ3766CE · Replaces 140U4005 -15 · Apr 9, 2013LA140U4005-7Pane - Outer, Passenger WindowTriumph Aerospace Systems Inc · PMA PQ3766CE · Replaces 140U4005 -7 · Apr 9, 2013LA140U4005-17Pane - Outer, Passenger WindowTriumph Aerospace Systems Inc · PMA PQ3766CE · Replaces 140U4005 -17 · Apr 9, 2013LA140U4005-1Pane - Outer, Passenger WindowTriumph Aerospace Systems Inc · PMA PQ3766CE · Replaces 140U4005 -1 · Apr 9, 2013LA140U4005 -3Pane - Outer, Passenger WindowTriumph Aerospace Systems Inc · PMA PQ3766CE · Replaces 140U4005 -3 · Apr 9, 2013LA140U4005-20Pane - Outer, Passenger WindowTriumph Aerospace Systems Inc · PMA PQ3766CE · Replaces 140U4005 -20 · Apr 9, 2013740801-6WDSleeve, BearingWencor LLC (formerly Dixie Aerospace LLC) · PMA PQ1630CE · Replaces 740801-6 · Apr 7, 2013P22010Bearing AssemblyPSI Bearings · PMA PQ1183NM · Replaces J1168G02 · Apr 7, 2013E410-1543RelayDRI Relays Inc · PMA PQ1085NE · Replaces BACR13CG3A · Apr 2, 2013ES410-1538RelayDRI Relays Inc · PMA PQ1085NE · Replaces BACR13CG2AB · Apr 2, 2013E410-1550RelayDRI Relays Inc · PMA PQ1085NE · Replaces BACR13CG1A · Apr 2, 2013ES210-1632RelayDRI Relays Inc · PMA PQ1085NE · Replaces BACR13CF2AB · Apr 2, 2013E210-1643RelayDRI Relays Inc · PMA PQ1085NE · Replaces BACR13CF5A · Apr 2, 2013E210-1642RelayDRI Relays Inc · PMA PQ1085NE · Replaces BACR13CF3A · Apr 2, 2013E210-1631RelayDRI Relays Inc · PMA PQ1085NE · Replaces BACR13CF2A · Apr 2, 2013E210-1641RelayDRI Relays Inc · PMA PQ1085NE · Replaces BACR13CF1A · Apr 2, 2013KT972576Element, SealTurbine Kinetics Inc, Subsidiary of HEICO Corp · PMA PQ0816NE · Replaces 972576 · Apr 1, 201369-12359-4Fitting-NutAviation Materials Management Inc · PMA PQ4098CE · Replaces 69-12359-4 · Mar 25, 201365B05441-3BOLT ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05441-3 · Mar 25, 201365B08104-202Bushing-FlangedAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B08104-202 · Mar 25, 201365B80143-1CLAMP ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B80143-1 · Mar 25, 201369B71234-1PLATEAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B71234-1 · Mar 25, 201365B41664-3CUSHIONED CLAMP ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B41664-3 · Mar 25, 201369B00171-1SPACERAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B00171-1 · Mar 25, 201369B00230-2NUTAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B00230-2 · Mar 25, 201365B05244-2PINAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B05244-2 · Mar 25, 201369B43388-30BOX ASSYAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B43388-30 · Mar 25, 201365B01485-1HOUSING SPRINGAviation Materials Management Inc · PMA PQ4098CE · Replaces 65B01485-1 · Mar 25, 201369B11217-1BRACKET-SIDE ROLLERAviation Materials Management Inc · PMA PQ4098CE · Replaces 69B11217-1 · Mar 25, 2013
Back to Boeing 747-230B