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.
417U3060-141Velcro Tape418W1056-120ASpacer Panel Shell417U3050-7110BCLOSE-OUT PANEL ASSY - PARTITION, CENTER417U3065-2340Oxy Box Assy417U3065-12637Oxy Box Assy418W1016-120ADecorative Panel417U3060-13423Oxy Box Assy417U3065-7132BOXYGEN BOX ASSY - 3-MASK U/D W/IN-LINE417U3060-14623Oxy Box Assy417U3010-8202BSPEAKER PANEL ASSY - OUTBOARD, RH, WITH 777-STYLE SPEAKER417U3020-3381Reading Light Assy417U3081-3243Oxy Box Assy417U3081-3144Oxy Box Assy417U3065-1String417U3063-114Connector Strip418W1019-2Lanyard417U3010-1006Speaker Panel Assy417U3060-2520Oxy Box Assy417U3030-2038Sign Pnl Assy417U3081-3245Oxy Box Assy417U3081-5272OXY BOX ASSY UD CREW REST AFT UPPER LH NFF FOR HALF INCH PANEL BEIGE 870417U3065-19Blank Assy417U3075-7100BPANEL ASSY TEMPERATURE SENSOR417U3031-2003Shell417U3065-12332Oxy Box Assy417U3056-2041Shell417U3051-2103Shell417U3081-121Frame Assy417U3065-12333Oxy Box Assy417U3081-3237Oxy Box Assy417U3025-3183Reading Light Assy417U3060-3621Oxy Box Assy417U3065-4832Oxy Box Assy417U3025-7132BReading Light -Outboard417U3067-1007Door Assy417U3083-27Stiffener417U3081-5265Oxy Box Assy417U3065-15433Oxy Box Assy417U3081-7117BOXYGEN BOX ASSY - ATTENDANT417U3081-5414OXY BX ASSY NON FREE FLOW 35IN STREAMERS 4IN DROP 75IN LONG HALFIN CEILING PANEL417U3025-8011BLh O-Oeu Panel Assy417U3060-3622Oxy Box Assy417U3025-2386Reading Light Assy417U3020-3Lanyard417U3065-7335BOXYGEN BOX ASSY - 3-MASK ZN-A W/IN-LINE, THERAPEUTIC417U3067-2011Door Assy417U3081-5261Oxy Box Assy417U3065-12435Oxy Box Assy417U3060-3520Oxy Box Assy417U3065-2431Oxy Box Assy
Back to Boeing 747-400D