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-3416Oxy Box Assy417U3063-17Cover418W1026-131AShell417U3065-14433Oxy Box Assy417U3025-8014BRh I-Oeu Panel Assy417U3067-2007Door Assy417U3060-7151BOXYGEN BOX ASSY - 5-MASK M/D WITH IN-LINE417U3081-7123BOXYGEN BOX ASSY - ATTENDANT417U3030-2050Sign Pnl Assy417U3081-3270Oxy Box Assy417U3065-4311Oxy Box Assy417U3031-2021Shell417U5051-70Bezel417U3025-3384Reading Light Assy417U3066-2010Shell417U3067-2013Door Assy417U3055-2036Closure Pnl Assy417U3081-3239Oxy Box Assy417U3025-1782Reading Light Assy417U3055-125Closure Pnl Assy417U3026-2081Shell417U3030-2041Sign Pnl Assy417U3051-2003Shell417U3065-2832Oxy Box Assy417U3031-2026Shell417U3081-2002Door Assy417U3067-2018Door Assy417U3025-8422BREADING LIGHT ASSY - RH, 2 PERSON, WITH OEU AND LED SIGN417U3030-3032Sign Pnl Assy417U3075-7101BPANEL ASSY TEMPERATURE SENSOR, OUTBD417U3081-7123COXYGEN BOX ASSY - ATTENDANT (BAC 8925)417U3071-2002Gasper Panel Assy417U3022-14Bracket Assy417U3081-3232Oxy Box Assy417U3065-2631Oxy Box Assy417U3066-2015Shell417U3025-7422BReading Light -Outboard417U3051-2102Shell417U3065-2333Oxy Box Assy417U3060-3620Oxy Box Assy417U5051-75Bezel417U3060-2422Oxy Box Assy417U3060-12520Oxy Box Assy417U3025-8232BREADING LIGHT ASSY - RH, 3 PERSON, WITH OEU417U3060-701Oxy Box Assy417U3050-2020Closure Pnl Assy417U3081-6463Oxy Box Assy417U3030-2003Sign Pnl Assy417U3081-122Shroud Assy448W1232-5TAFT SEAT TRACK FITTING COVER DETAIL
Back to Boeing 747-400D