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.
417U3025-2061Reading Light Assy417U3063-7001BRACKET - CENTER OXYGEN BOX417U3031-2032Shell417U3060-12521Oxy Box Assy417U3055-2105Closure Pnl Assy418W1057-10AGap Seal417U3081-4246Oxy Box Assy315T3557-1QASAssembly, Bumper, Thrust Reverser417U3063-31Lanyard Clip417U3055-126Closure Pnl Assy417U3083-1Bracket417U3060-3623Oxy Box Assy417U3020-8230BREADING LIGHT ASSY - 3 PERSON, M/D 60, W/LED SIGN417U3020-2061Reading Light Assy417U3030-2026Sign Pnl Assy417U3021-2061Shell417U3055-6Closure Pnl Assy417U3065-2221Oxy Box Assy417U3081-3234Oxy Box Assy417U3081-5412Oxy Box Assy417U3065-1344Oxy Box Assy417U3083-2Bracket417U3060-12620Oxy Box Assy417U3050-3031Closure Pnl Assy417U3065-12331Oxy Box Assy417U3060-5620Oxy Box Assy417U3061-2005Shell-Oxy Box418W1017-20Door Test Stop417U3056-2006Shell418W1066-2AHousing417U3065-2336Oxy Box Assy417U3010-2007Panel Assy417U5316-10Panel417U3081-2032Door Assy417U3065-2636Oxy Box Assy417U3030-2040Sign Pnl Assy417U3060-7341BOXYGEN BOX ASSY - 4-MASK M/D WITH IN-LINE, THERAPEUTIC417U3065-8132BOXYGEN BOX ASSY - 3 MASK, U/D417U3030-2037Sign Pnl Assy417U3065-17Blank Assy417U3025-8421BREADING LIGHT ASSY - LH, 2 PERSON, WITH OEU AND LED SIGN417U3065-7141BOXYGEN BOX ASSY - 4-MASK M/D W/IN-LINE417U3010-2001Speaker Panel Assy417U3075-2010Closure Pnl Assy417U3025-2182Reading Light Assy417U5051-82Bezel417U3065-1442Oxy Box Assy418W1051-3ASpacer Panel Shell417U3081-3221Oxy Box Assy417U3083-34Bracket Assy
Back to Boeing 747-400D