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.
WM3711-0CABLE ASSEMBLY P15, E-E BAY TO VCCIS60112-10System 2000E Seat Equipment ConfigurationRD-AM8016SPEAKERRD-AA8034-01CPMS Memory Expansion UnitWM3123-125C/A EADB to Sidewall or Floor BoxRD-AM7111-06H/A IVASEB to SDU, RJMWM5220-0CABLE ASSEMBLY ASB TO ASB 6RD-AM7028-05H/A Seat to SDU (DBL)RD-AM2403-06Control Drawing Front Row, ISVD, RightMAS10188-03SYSTEM 2000E INSTALLATIONWM2602-0CABLE ASSEMBLY TU TO TU 7DS10026-04Sidewall Disconnect BracketRD-AM7247-0CABLE ASSEMBLY IVASEB TO DISCONNECTWM3751-001C/A CB to DiscDS10097-14ADB BRACKET ANGLE ASSEMBLYRD-AM7010-14H/A IVASEB to IHS (TPL)RD-AM7114-27H/A IVASEB to SDU & RJMRD-AX6532Digital Pass. Ctrl. UnitIS60112-01System 2000E Seat Equipment ConfigurationRD-AV7103-51LCD MonitorRD-AX1002Main Multiplexer (MM)DS10087-09DISCONNECT BRACKET IN-SEAT VIDEOIS60108-07SYSTEM 2000E SEAT EQUIPMENT CONFIGURATIONRD-AM7009-95H/A IVASEB to IHS (DBL)WM5219-002C/A ASB to ASB 5RD-AX4403-ASeat Electronics Box (SEB)RD-AX6438-01RJUDS10079-01UPPER DECK SIDEWALL DISCONNECT BRACKETWM3123-116C/A EADB to Sidewall or Floor BoxIS30067-102SYSTEM 2000E STRUCTURAL INSTALLATIONWM5010-( )CABLE ASSEMBLY ASB TO DISCONNECTRD-AA1007-05Enhanced Passenger Entertainment System ControlRD-AM7012-0HARNESS ASSEMBLY IVASEB TO IHS (DBL)RD-AA1007-03Enhanced Passenger Entertainment System ControlDA10100-02Floor Box Cover KitMAS10188-04SYSTEM 2000E INSTALLATIONIS60112-04System 2000E Seat Equipment ConfigurationRD-AX7002-01Music Tape PlayerIS60108-03SYSTEM 2000E SEAT EQUIPMENT CONFIGURATIONWM3622-0CABLE ASSEMBLY EADB 3 TO EADB 2RD-AM7247-002Cable Assembly IVASEB to DisconnectRD-AM7010-13H/A IVASEB to IHS (TPL)RD-AM7230-01H/A IVASEB to SDU and RJMWM3123-124C/A EADB to Sidewall or Floor BoxRD-AM6271-30C/A VASEB to VASEBRD-AM6047-46Seat Harness AssemblyRD-AA902233VCC ASSEMBLY IBERIA 747-200WM3709-0CABLE ASSEMBLY EPESC, EPSSC, E2-2 SHELFRD-AM7112-14H/A IVASEB to SDU, RJMDS10082-16SIDEWALL DISCONNECT BRACKET
Back to Boeing 747-230B