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.
RD-AM7112-04H/A IVASEB to SDU, RJMRD-AM7028-02H/A Seat to SDU (DBL)DA10099-13Floor Box Mounting AssemblyDS10097-01ADB Bracket Angle AssemblyWM3123-118C/A EADB to Sidewall or Floor BoxDS10135-09Cable Support BracketIS30067-101SYSTEM 2000E STRUCTURAL INSTALLATIONDS10135-03Cable Support BracketRD-AM7009-36H/A IVASEB to IHS (DBL)RD-AM6261-21C/A VASEB to VASEBRD-AT1004-01CABIN TELECOMMUNICATION UNITWM3714-0CABLE ASSEMBLY EPESC (STAN 2) TO FR AMPDS10082-09SIDEWALL DISCONNECT BRACKETRD-AM7007-30H/A SWD to SeatIn accordance with MAS drawing list MDL10117 Rev A, DTD 2/24/97 or later FAA approved revisionSYSTEM 2000EWM3710-0CABLE ASSEMBLY P15 STANCHION-2 E2-2/ASB 1WM3755-001C/A E2-1 PA InterfaceRD-AM7145-0CABLE ASSEMBLYIW30064-303SYSTEM 2000E WIRING INSTALLATIONWM3736-001C/A EADB 2 to EADB 3WM3123-113C/A EADB to Sidewall or Floor BoxWM5217-003C/A ASB to ASB 4WM3757-001C/A VCC to DiscRD-AM7035-23H/A Seat to Seat (SDU/DBL)DA10099-03Floor Box Mounting AssemblyRD-AM7217-01H/A Disc to SDU (DBL)RD-AM6003-0SEAT HARNESS ASSEMBLYRD-AA8061-11Lan HubRD-AM7007-24Harness Assembly SWD to Seat103073-01CABLE, DISK DRIVE TO CMTRD-AM7047-0HARNESS ASSEMBLY SWD TO SEATRD-AA2908TERMINATION PLUGWM2245-0CABLE ASSEMBLY TU TO TU 1RD-AX3001-AColumn Timer Decoder (CTD)RD-AA8046-11Cabin Management TerminalDS10135-04Cable Support BracketRD-AM7112-05H/A IVASEB to SDU, RJMWM2009-039Cable Assembly Tapping Unit to Monitor/ ProjectorRD-AV1211-01VCP-1211 VIDEO CASSETTE PLAYERRD-AM6261-18C/A VASEB to VASEBRD-AM7007-30Harness Assembly SWD to SeatRD-AA1002-02PSS Controller IIRD-AA2902TERMINATION PLUGWM5213-003C/A ASB 2 to ASB 3WM2034-013Cable Assembly TU to DisconnectIS60262-02Seat ConfigurationRD-AA6514-05CradleWM3606-0CABLE ASSEMBLY EADB 3 TO EADB 4WM2034-014Cable Assembly TU to DisconnectMAS10188-01Virgin Atlantic 747-200 System 2000E Installation
Back to Boeing 747-230B