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-2433Oxy Box Assy417U3063-7006Bracket418W1056-130ASpacer Panel Shell417U3070-2013Gasper Panel Assy417U3065-13342Oxy Box Assy417U3083-7002BRACKET - ATTENDANT OXYGEN BOX417U3067-2017Door Assy417U3081-3414Oxy Box Assy417U3083-29Bracket417U3065-7341BOXYGEN BOX ASSY - 4-MASK M/D W/IN-LINE, THERAPEUTIC417U3081-3265Oxy Box Assy110U6011-1Door Assy417U3020-2181Reading Light Assy417U3065-7130BOXYGEN BOX ASSY - 3-MASK ZN-A W/IN-LINE417U3065-18Blank Assy418W1050-202ASpacer Panel Assy417U3055-108Closure Pnl Assy417U3030-7210BINFO SIGN LAV-OCCUPIED ASSY, CENTER417U3065-12635Oxy Box Assy417U3025-7231BReading Light -Outboard417U3062-2014Door417U3025-3382Reading Light Assy417U5051-100Bezel417U3070-2012Gasper Panel Assy417U3065-2434Oxy Box Assy417U3081-6321Oxy Box Assy417U3065-12834Oxy Box Assy417U3062-2010Door417U3060-7340BOXYGEN BOX ASSY - 4-MASK ZONE A WITH IN-LINE, THERAPEUTIC417U3060-14522Oxy Box Assy418W1026-122AShell417U3065-16433Oxy Box Assy417U3025-8012BRh O-Oeu Panel Assy417U3030-2023Sign Pnl Assy417U3026-2067Shell417U3025-2381Reading Light Assy417U3081-3313Oxy Box Assy417U5051-81Bezel417U3010-8201BSPEAKER PANEL ASSY - OUTBOARD, LH, WITH 777-STYLE SPEAKER417U3020-3141Panel Assy417U5051-96Bezel417U3063-7007Stiffening Doubler417U3025-7121BREADING LIGHT ASSY - OUTBOARD417U3055-2022Closure Pnl Assy417U3025-8321BREADING LIGHT ASSY - LH, 2 PERSON, W/LED SIGN417U3025-8221BREADING LIGHT ASSY - LH, 2 PERSON, WITH OEU417U3065-2334Oxy Box Assy417U3081-6263Oxy Box Assy417U3081-3Lanyard110U6011-2Access Door Assy
Back to Boeing 747-400D