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.
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 DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
WM3750-001C/A CB to CBRD-AX6438-02RJURD-AX5403-A4-Seat Passenger Service Unit Decoder (PSUD)RD-AA2006-60Area Service BoxRD-AA6501-01HANDSETIS60108-09System 2000E Seat Equipment ConfigurationWM3139-003C/A Sidewall Disc to Sidewall DiscRD-AA5007-13Enhanced Video Systems Control UnitIW30064-03SYSTEM 2000E WIRING INSTALLATIONIW30064-02System 2000E Wiring InstallationRD-AM6261-37Cable Assembly VASEB to VASEBRD-AM7047-37H/A SWD to SeatDA10101-11Relay/Disc. Bracket AssemblyWM5212-002Cable Assembly ASB 1 to ASB 2RD-AM7111-08H/A IVASEB to SDU, RJMWM2260-0CABLE ASSEMBLY MAIN DISCONNECT TO TU 3RD-AA1007-03ENHANCED PES CONTROLLERWM2247-0CABLE ASSEMBLY TU TO TU 6WM5203-002C/A ASB 1 to ASB 2RD-AM7047-28H/A SWD to SeatRD-AA4662-03INTEGRATED AUDIO/VIDEO SEB (FOR 2 SEAT RIGHT SIDE)RD-AM7009-33H/A IVASEB to IHS (DBL)RD-AX5902-APSUD Termination Plug (Quad)RD-AM6271-0CABLE ASSEMBLY VASEB TO VASEBIS30067-103SYSTEM 2000E STRUCTURAL INSTALLATIONWM3712-0CABLE ASSEMBLY EPPSC (STAN 2) TO PACRD-AM7190-0HARNESS ASSEMBLY JUMPERIS60112-08System 2000E Seat Equipment ConfigurationIW30064-305SYSTEM 2000E WIRING INSTALLATIONDS10097-12ADB BRACKET ANGLE ASSEMBLYRD-AX5301-A3-SEAT PSU DECODERIS60262-03Seat ConfigurationRD-AM2403-05Control Drawing Front Row, ISVD, LeftIW60111-05System 2000E Passenger Cabin Wiring InstallationIW60105-09System 2000E Passenger Cabin WiringIS60108-12System 2000E Seat Equipment ConfigurationWM3732-0CABLE ASSEMBLY EPESC DISC TO CPMU DISC AND SATCOMRD-AV7075-28LCD Monitor 6.5 inchRD-AX7095-01CD ReproducerRD-AA8080-01Printer Plotter Laser Quality B-Bit Parallel InterIS60108-08SYSTEM 2000E SEAT EQUIPMENT CONFIGURATIONRD-AA2901-01Termination PlugRD-AX4406Seat Electronics Box (SEB)WM3145-0CABLE ASSEMBLY VCC TO MAIN DISCDA10115-01CABLE SUPPORT BRACKET ASSEMBLYWM3745-001C/A P14 to Relay 2IS60108-04SYSTEM 2000E SEAT EQUIPMENT CONFIGURATIONIS60112-02System 2000E Seat Equipment ConfigurationWM2605-001Cable Assembly TU to TU 8DA10100-03GASKET, FLOOR BOX KIT
Back to Boeing 747-230B