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-2052Door Assy417U3031-2023Shell417U3081-3225Oxy Box Assy417U3055-7101BTRANSITION PANEL ASSY, OUTBD417U3065-12431Oxy Box Assy110U6012-1Door Assy417U3065-4331Oxy Box Assy417U3010-2003Panel Assy417U3081-4203Oxy Box Assy417U3030-2051Sign Pnl Assy417U3025-8013BLh I-Oeu Panel Assy417U3065-3342Oxy Box Assy417U3030-3031Sign Pnl Assy417U3065-12432Oxy Box Assy417U3060-601Oxy Box Assy417U5052-7Bezel417U3065-3441Oxy Box Assy417U3020-3181Reading Light Assy417U3060-3423Oxy Box Assy417U3060-3220Oxy Box Assy417U3065-2223Oxy Box Assy417U3081-3411Oxy Box Assy417U3070-2008Gasper Panel Assy417U3060-15620Oxy Box Assy417U3050-3020Closure Pnl Assy417U3025-7222BReading Light -Outboard418W1055-203ASpacer Panel Assy417U3075-2012Closure Pnl Assy417U3020-7130B3-Person M/D 60 R/L417U3025-7013BOeu Panel Assy (I-Oeu)417U3065-4634Oxy Box Assy417U3056-2004Shell417U3065-12334Oxy Box Assy417U3067-3008Door Assy417U3065-2335Oxy Box Assy417U3065-5431Oxy Box Assy417U3031-2022Shell417U3060-2521Oxy Box Assy417U3065-4222Oxy Box Assy417U3025-8432BREADING LIGHT ASSY - RH, 3 PERSON, WITH OEU AND LED SIGN417U3065-7337BOXYGEN BOX ASSY - 3-MASK U/D W/IN-LINE, THERAPEUTIC417U3081-3203Oxy Box Assy417U3066-2006Oxy Box Assy417U3060-4620Oxy Box Assy417U3065-2339Oxy Box Assy418W1066-10AShell417U3081-2012Door Assy417U3081-3415Oxy Box Assy417U3075-2000Closure Pnl Assy417U3021-2041Shell
Back to Boeing 747-400D