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.
WM3123-0CABLE ASSEMBLY EADB TO SIDEWALL OR FLOORBOXRD-AM7035-20H/A Seat to Seat (SDU/DBL)RD-AM7112-03H/A IVASEB to SDU, RJMRD-AM7094-01H/A IVASEB to Disc (SDU)WM3123-119C/A EADB to Sidewall or Floor BoxIS60108-10System 2000E Seat Equipment ConfigurationDS10097-17ADB BRACKET ANGLE ASSEMBLYRD-AX5301-APSUD (Triple)IS60108-13SYSTEM 2000E SEAT EQUIPMENT CONFIGURATIONRD-AM7230-02H/A IVASEB to SDU and RJMDS10087-02DISCONNECT BRACKET IN-SEAT VIDEORD-AM7246-0HARNESS ASSEMBLY DISC TO WALL MOUNT HANDSETDA10099-11BRACKET ASSEMBLYRD-AA2902Termination PlugMAS10188-03Virgin Atlantic 747-200 System 2000E InstallationDS10026-10SIDEWALL DISC BRACKETWM5212-0CABLE ASSEMBLY ASB 1 TO ASB 2DS10147-12BLANK TRAYWM3129-088C/A EADB to Sidewall or Floor BoxIS60112-03System 2000E Seat Equipment ConfigurationDA10099-06BRACKET ASSEMBLYWM3199-0CABLE ASSEMBLY EADB TO SW OR F/BIS30067-01SYSTEM 2000E STRUCTURAL INSTALLATIONRD-AM7093-02Seat Harness IVASEB to Disc. (IHS)RD-AM7040-21H/A SWD to SeatWM1858-001C/A Token Ring VCC to EE BayWM3199-018Cable Assembly EADB to Software or F/BRD-AM7049-06HARNESS ASSEMBLY IVASEB TO IHS (TPL)IW60105-04System 2000E Passenger Cabin Wiring InstallationRD-AM7112-B8Harness Assembly, IVASEB to SDU RJMIW60105-07SYSTEM 2000E PASSENGER CABIN WIRING INSTALLATIONWM3129-084C/A EADB to Sidewall or Floor BoxWM5213-002Cable Assembly ASB 2 to ASB 3RD-AM7015-0HARNESS ASSEMBLY IVASEB TO SDU & RJMIS60112-09System 2000E Seat Equipment ConfigurationRD-R5Z35AMAGNET ACTUATORWM3746-001C/A P14 to Relay 2RD-AX2003Zone Multiplexer (ZM)MAS10180-01SYSTEM 2000E INSTALLATIONWM3744-001C/A P14 to Relay 1RD-AX7001-01Music Tape PlayerRD-AM7010-15H/A IVASEB to IHS (TPL)RD-AM7007-31H/A SWD to SeatDS10087-09Disconnect Bracket, In-Seat VideoRD-AM7013-0HARNESS ASSEMBLY IVASEB TO IHS (DBL)RD-AM7007-19Harness Assembly SWD to SeatRD-AA902301-029 inch LCD, Panel Mount Installation Door 4, B747-200WM3129-092C/A EADB to Sidewall or Floor BoxIS30069-01System 2000E Structural InstallationWM5225-001C/A PSSC to ASB
Back to Boeing 747-230B