Boeing 747-400D
PMA parts · 105,720
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-400D 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-400D 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.
TL10522-03System 3000IS70048-01SYSTEM EX2 STRUCTURAL INSTALLATIONRD-AM6218-06HARNESS ASSY SEU TO IVASEB (DBL)RD-AA1008-02Enhanced Passenger Entertainment System ControllerRD-AM7351-84Harness Assembly Seatback SDUTL10462-01System 3000i Video EntertainmentRD-FA1071-01CONTENT SERVERIW60191-01SYSTEM 3000 WIRINGRD-AV1316-01DVD PLAYERRD-AM6620-1SEAT HARNESSIW30124-01KID Skypower WiringRD-AM7126-45HARNESS ASSY SWD TO SEATRD-AM6745-4Seat HarnessRD-AA2014-01ZONE INTERFACE UNITRD-FA1031-01DISC ARRAYRD-AM7424-09HARNESS ASSEMBLY SEAT TO SEAT LAPTOP POWERRD-KM7544-3636HARNESS ASSEMBLY FEED FWD DISC TO BULKHEAD SDU (DBL), LH CABLE EXITWM13440-005-585CABLE ASSY, LEAKY FEEDER ANTENNARD-KM7032-10Harness Assembly Console Disc to RJ45/USBRD-KA1006-02CREW PANELIS30080-03SYSTEM 3000 STRUCTURALRD-AA8011-22KeyboardRD-AM6254-52HARNESS ASSEMBLY SW TO VASEBRD-AA902741-01ICD, SYSTEM SETUP BOXIW50027-02GCS WIRING INSTALLATIONRD-FA1011-01AIRCRAFT INTERFACERD-AM6062-30SEAT HARNESSRD-AM7545-03Harness Assembly SEB to C/Disc (IHS/DBL)RD-KM7938-016HARNESS ASSEMBLY SEB TO SDU DISC, PERIPHERALS (DBL)IS60757-01EX2 SEAT EQUIPMENT CONFIGURATIONRD-AA902418-03INSTALLATION, WALL MOUNT 15 INCH LCDRD-AK1132004FCH OPS SoftwareRD-AM7407-06Harness Assembly Seatback SDU (DBL)101769-01TERMINAL PCB MECH ASSYRD-AM7300-104HARNESS ASSEMBLY DSEB TO SDU, RJU560000-206-260Software Configuration IndexRD-AK1167104CMEU III OPS SoftwareRD-AM7097-119Harness Assembly, IVASEB to Disc (DBL)RD-FA1141-01ON BOARD MEDIA LOADERRD-AM7455-10Harness Assembly Disc to RH In-Arm SDURD-KM7826-160HARNESS ASSEMBLY SEAT TO SWD/FDB, DATA REDUNDANCYRD-AM7545-04Harness Assembly SEB to C/Disc (IHS/DBL)RD-AM6053-07SEAT HARNESSRD-AM6053-03SEAT HARNESSWM13440-004-1300CABLE ASSY, LEAKY FEEDER ANTENNARD-AA2901-01TERMINATION PLUGRD-AA4673-18IVASEBRD-AM6097-15SEAT HARNESS ASSEMBLYRD-AV1306-01DVD PLAYERRD-AA902563-01Video Control Center
Back to Boeing 747-400D