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.
417U3065-2637Oxy Box Assy417U3070-2007Gasper Panel Assy417U3050-7004BCLOSURE PANEL ASSY, CENTER, M/D417U3065-2332Oxy Box Assy417U3070-7030BGASPER PANEL ASSY - CENTER, 3 OUTLET417U3025-3182Reading Light Assy417U3010-2006Speaker Pnl Assy418W1051-2ASpacer Panel Shell417U3060-13521Oxy Box Assy417U3060-7343BOXYGEN BOX ASSY - 4-MASK M/D WITH IN-LINE, THERAPEUTIC417U3025-7432BReading Light Assy417U3025-7421BReading Light -Outboard417U3065-12631Oxy Box Assy417U3065-4221Oxy Box Assy417U3082-1008Shell417U3030-2013Sign Pnl Assy417U3060-14621Oxy Box Assy417U3020-2261Reading Light Assy417U3060-2620Oxy Box Assy417U3050-7111BGap Cover417U3063-115Connector Strip417U3065-4433Oxy Box Assy65-76140-3Door Casting417U3065-2833Oxy Box Assy417U3056-2042Shell417U3061-1005Shell-Oxy Box417U3022-12Bracket Assy417U3055-118Closure Pnl Assy417U3060-14420Oxy Box Assy417U3066-2013Shell417U3065-1342Oxy Box Assy417U3065-3341Oxy Box Assy418W1021-40AShell417U3060-4621Oxy Box Assy417U5051-103Bezel417U3067-17Lanyard417U3071-2005Gasper Panel Assy417U3065-2338Oxy Box Assy417U3065-12335Oxy Box Assy417U3060-13520Oxy Box Assy417U3060-2420Oxy Box Assy417U3081-6241Oxy Box Assy417U3065-5432Oxy Box Assy417U3010-2002Speaker Panel Assy417U3020-8010BCenter Oeu417U3065-12832Oxy Box Assy417U3055-104Closure Pnl Assy417U3082-7001BShell Attendant Oxygen Box417U3065-8130BOXYGEN BOX ASSY - 3 MASK, ZN A417U3025-2142Panel Assy
Back to Boeing 747-400D