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.
WM2244-0CABLE ASSEMBLY TU TO TU 2WM3123-120C/A EADB to Sidewall or Floor BoxRD-AA902508-01VCC CABINETRD-AA2006-70Area Service BoxRD-AM6261-19C/A VASEB to VASEBRD-AA5007-13ENHANCED VIDEO SYS. CONTROL UNIT (EVSCU)DS10079-01Upper Deck Sidewall Disconnect BracketRD-AM7234-02H/A Disc to SDUWM3129-095C/A EADB to Sidewall or Floor Box107367KIT, PANEL, SPACERRD-AM7013-14Harness Assembly IVASEB to IHS (DBL)WM5221-( )CABLE ASSEMBLY ASB TO PSUD DISCRD-AA5008-01RF Splitter/ CombinerDA10100-03Floor Box Cover KitRD-AM2205-04Monitor Deployment IVS Arm AssemblyIW60105-01SYSTEM 2000E PASSENGER CABIN WIRING INSTALLATIONDA10099-12Floor Box Mounting AssemblyRD-AA2006-30AREA SERVICE BOXRD-AM7029-16H/A Seat to SDU (SDU/TPL)RD-AA5009-01RF Amp/ SplitterRD-AM7115-03H/A RJM to C/Disc.IS60108-18System 2000E Seat Equipment ConfigurationWM3734-001C/A EADB 1 to VCC DiscIW30064-301SYSTEM 2000E WIRING INSTALLATIONWM3124-010C/A EADB to Floor BoxRD-AM7247-001Cable Assembly IVASEB to DisconnectWM2013-0CABLE ASSEMBLY TAPPING UNIT TO MONITOR/PROJECTORDS00005-10TERMINAL STRIPRD-AA3403-05Digital Seat Electronics BoxWM3741-001C/A EADB 7 to EADB 8RD-AM7007-32H/A SWD to SeatRD-AX4404-ASeat Electronics Box (SEB)RD-AA5101-10TAPPING UNITRD-AA2006-60Area Service BoxRD-AA2912-01Termination PlugWM3742-001C/A E2-2 Shelf (PSSC/DISC)RD-AM7112-15H/A IVASEB to SDU, RJMRD-AM7097-36H/A IVASEB to IHS (DBL)WM5224-( )CABLE ASSEMBLY PSUD TO CALL READING LIGHTDS10097-07ADB BRACKET ANGLE ASSEMBLYRD-AA6163-01P.C.U. (LEFT)RD-AV7091-01LCD MONITORRD-AX5403-APSUD (Quad)RD-AM7047-34H/A SWD to Seat510000-206-442SOFTWARE CONFIGURATION INDEXDS10147-13BLANK TRAYRD-AM7036-18H/A Seat to Seat (SDU/TPL)RD-AM7028-18H/A Seat to SDU (DBL)RD-AM7007-38H/A SWD to SeatDS10082-10SIDEWALL DISCONNECT BRACKET
Back to Boeing 747-230B