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.
417U3031-2012Shell417U3030-2134Sign Pnl Assy417U3081-5269Oxy Box Assy417U3026-2066Shell417U3081-4262Oxy Box Assy417U5051-99Bezel417U3070-7120BGASPER PANEL ASSY - OUTBD, 2 OUTLET417U3081-5363Oxy Box Assy417U3081-1243Oxygen Box Assy418W1057-9APad417U3025-8231BREADING LIGHT ASSY - LH, 3 PERSON, WITH OEU417U3063-29Hinge417U3081-3241Oxy Box Assy417U3081-6262Oxy Box Assy417U3030-2031Sign Pnl Assy417U3065-14831Oxy Box Assy417U3060-7342BOXYGEN BOX ASSY - 4-MASK ZONE A WITH IN-LINE, THERAPEUTIC417U5052-6Bezel417U3055-7112BCLOSURE PANEL ASSY - CURTAIN, OUTBD, MD417U3060-3624Oxy Box Assy417U3025-3141Panel Assy417U3082-1005Door418W1052-1Latch Pawl417U3025-3143Panel Assy417U3081-4201Oxy Box Assy417U3067-2008Door Assy65B80544-3Medallion Assy417U3050-2030Closure Pnl Assy417U3063-21Hinge112N6101-1Door Assy417U3066-2005Oxy Box Assy417U3050-2040Closure Pnl Assy417U3065-1441Oxy Box Assy417U3081-1002Door Assy417U3030-2049Sign Pnl Assy417U3081-3418Oxy Box Assy417U3065-2635Oxy Box Assy417U3065-11341Oxy Box Assy417U3065-8131BOXYGEN BOX ASSY - 3 MASK, ZN A417U5051-73Bezel417U3070-2001Gasper Panel Assy417U3075-2016Closure Pnl Assy417U3081-5231Oxy Box Assy417U3025-3181Reading Light Assy60B50059-61Hose417U3065-7131BOXYGEN BOX ASSY - 3-MASK M/D W/IN-LINE417U3021-2042Shell417U3055-2102Closure Panel Assy417U3065-16434Oxy Box Assy417U3055-107Closure Pnl Assy
Back to Boeing 747-400D