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.
RD-KA1005-01Area Distribution BoxRD-AM7623-17Harness Assembly, DSEB to SDU, RJURD-AM6003-56Seat Harness AssemblyRD-AA2014-03ZONE INTERFACE UNITWM2145-016CABLE ASSEMBLY DISC TO LCDIS30088-01SYSTEM 3000 STRUCTURALIS60663-08eX2 SEAT EQUIPMENT CONFIGURATIONRD-KA1003-03FILE SERVERRD-AM7126-10HARNESS ASSEMBLY SWD TO SEATRD-AK01CI005CMT SoftwareRD-AA902769-01AIRCRAFT ASSEMBLY 15 INCH RETRACT INSTALLATIONRD-KM6665-28HARNESS ASSEMBLY DISC TO SEB DATARD-AM6062-37SEAT HARNESSRD-KM7383-B07EHARNESS ASSEMBLY SPM (DOUBLE) TO SEBWM13440-002-0120CABLE ASSY, LEAKY FEEDER ANTENNAIS60751-04EX2 SEAT EQUIPMENT CONFIGURATIONRD-AM7009-52HARNESS ASSEMBLY IVASEB TO IHS (DBL)RD-AM6003-07Seat Harness AssemblyRD-AM7302-23HARNESS ASSEMBLY, SDU FEED FWD, TPLRD-AA5002-23VIDEO MODULATOR UNITRD-AX6504Digital Pass. Ctrl. UnitRD-AA6605-02HANDSETRD-AM6003-49Seat Harness AssemblyRD-AA3501-02QMURD-AM6062-45SEAT HARNESSRD-AA902372-02VIDEO CONTROL CENTER113353-01Keyboard Shelf AssyRD-AA902372-02VCCIS50040-02GCS STRUCTURAL INSTALLATIONRD-FA1161-02ETHERNET PRINTERRD-AA2016-04ENHANCED AREA DISTRIBUTION BOXRD-AM7303-89Harness Assembly Seatback SDU, DBLRD-AM7324-17Harness Assembly, 10.4 Inch SDU Video ArmRD-AA902477-01VCC INSTALLATION DOOR 2 CENTER, AFTRD-AA3402-05DIGITAL SEAT ELECTRONICS BOXRD-NB2111-02ANTENNA, BROADBAND, AURA LERD-AM6262-18HARNESS ASSEMBLY IVASEB TO SDU, PCURD-NB4200-01ANTENNA COMBINER UNIT (ACU)RD-AM6062-43SEAT HARNESSIW60601-03EX2 SYSTEM CABIN WIRING INSTALLATION SON B747-400RD-FA1051-01CREW TERMINALRD-AM6003-02Seat Harness AssemblyRD-AM6062-47SEAT HARNESSIW30077-02SYSTEM 3000 WIRINGIW60757-02CABIN WIRING INSTALLATIONRD-NB4300-01ANTENNA SPLITTER COMBINER (ASC)RD-KM7032-11Harness Assembly Console Disc to RJ45/USBIS60172-04SYSTEM 3000 SEAT EQUIPMENT CONFIGURATIONIS70074-01SYSTEM EX2 STRUCTURAL INSTALLATIONRD-AA902718-03CREW PANEL INSTALLATION, WALL MOUNT, B777
Back to Boeing 747-400D