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.
1306240-002Ground Block Assy.1307187-007Cable Assembly, SWD/AVU980-9903-025PRAM914023-3Mounting Tray704-3290-002Cable Assy, SEU-SVD Disc, Triple1167875-220Cable Assembly1306338-006Cable Assembly, AVU/AVU1167874-219Cable Assembly785-0172-001Screen System700-1590-00114 inch QUAD Format Mon Assy1140-0160-119Fuel Stick Assembly1167850-3Cable Assembly704-3294-009Cable Assy, Seat-Seat601728-0003Installation Kit, Screen743-0304-001Video Reproducer Unit704-3287-012Cable Assy, SVD-Disc, Double, Seatback1167890-111Cable Assembly1304636Index List, Total Entertainment System1167867-34Cable Assembly60B40125-211Center PSUD1167002-140Central Mgmt. Unit1302328Entertainment System Seat Components60B40125-205Main Multiplexer601342-0003Flip Screen749-0599-001Harness Assy, PCU1/PCU2/JAU2/SW-Disc, Triple785-0101-008Screen System1308677-001Cable Assy, AVU/UPCU/ Audio Jack/Disc1307568-001Cable Assy, P2/AP 1602 Disc/AVU60B40125-210Outboard PSUD1167875-58Cable Assembly704-3582-001Cable Assy, SVD-SEU, Single743-0293-001Video Reproducer UnitS220U000-105AMU1307866-003Cable Assembly, SWD/AVU498392-0001Monitor 16 inch1167868-37Cable Assembly704-3294-008Cable Assy, Seat-Seat607676-0002Printer Assembly601341-0003Roll Screen14330-095-1JASwitch (Close Position)14330-063JASwitch and Harness Assy3205-20-1JAGrommetVA-2540-H01Immersion Stick Heater14330-095-2JASwitch (Open Position)14330-067JABracket, Switch MountSP3558-51-1500O-RingNP684047CUPSP25105-16-2065Bumper, DoorNP205623CONESP25105-16-1205Spring, Torsion
Back to Boeing 747-400D