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.
417U3081-4265Oxy Box Assy417U3020-8140BREADING LIGHT ASSY - 4-PERSON, M/D 60417U3081-6261Oxy Box Assy417U3070-2002Gasper Panel Assy417U3055-7212BSeal -Cutout Cover417U3062-2004Door417U3065-4434Oxy Box Assy417U3030-2032Sign Pnl Assy417U3081-5422Oxy Box Assy417U3081-5267Oxy Box Assy417U3030-2035Sign Pnl Assy417U3031-2013Shell417U3063-30Hinge417U3060-4420Oxy Box Assy417U3063-22Hinge417U3065-12632Oxy Box Assy417U3083-30Angle417U3025-8132BREADING LIGHT ASSY - RH, 3 PERSON417U5051-95Bezel417U3081-4205Oxy Box Assy417U3056-2003Shell65C33095-1Gasket417U3026-2082Shell417U3055-2042Closure Pnl Assy417U3060-13422Oxy Box Assy417U3022-5Bracket Assy417U3065-6433Oxy Box Assy417U3026-2062Shell418W1026-132AShell417U3010-2008Panel Assy418W1050-210ASpacer Panel Assy417U3055-2031Closure Pnl Assy417U3081-6201Oxy Box Assy417U3081-6265Oxy Box Assy417U3065-2432Oxy Box Assy417U3030-2033Sign Pnl Assy417U3025-3184Reading Light Assy417U3026-2061Shell417U3065-12434Oxy Box Assy417U3060-3String417U3060-13622Oxy Box Assy417U3081-7171BOXYGEN BOX ASSY - ATTENDANT417U3030-7110BSign Panel Assy Ctr & Outbd417U3026-2041Shell417U3061-2003Shell-Oxy Box417U3050-2103Closure Pnl Assy417U3025-2068Reading Light Assy417U3065-7331BOXYGEN BOX ASSY - 3-MASK M/D W/IN-LINE, THERAPEUTIC417U3060-7352BOXYGEN BOX ASSY - 5-MASK M/D WITH IN-LINE, THERAPEUTIC417U3030-2036Sign Pnl Assy
Back to Boeing 747-400D