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-3417Oxy Box Assy417U3081-3363Oxy Box Assy417U3081-7113BOXYGEN BOX ASSY - ATTENDANT417U3081-3233Oxy Box Assy417U3060-4623Oxy Box Assy417U3065-14633Oxy Box Assy417U3030-3033Sign Pnl Assy417U3063-7010Door Stiffener60B50059-59Oxygen Hose110U6012-2Dripstick Door Assy417U3050-2031Closure Pnl Assy417U5051-69Bezel417U3081-3244Oxy Box Assy417U5316-5Panel417U3081-4241Oxy Box Assy417U3025-2382Reading Light Assy417U3063-18Cover417U3025-2066Reading Light Assy417U3081-4263Oxy Box Assy417U3010-2005Speaker Pnl Assy417U3081-5420Oxy Box Assy417U3031-2011Shell417U3025-8122BREADING LIGHT ASSY - RH, 2 PERSON417U3081-5415OXY BX ASSY ATTENDANT NFF WITH IN LINE FLOW INDICATOR AND STREAMER417U3062-1005Door Assy-Oxy Box417U3081-5419Oxy Box Assy417U3070-7040BGASPER PANEL ASSY - CENTER, 4 OUTLET417U3065-2632Oxy Box Assy418W1057-12APad417U3065-2222Oxy Box Assy417U3060-13426Oxy Box Assy417U3081-5225Oxy Box Assy417U3065-4636Oxy Box Assy417U3065-2337Oxy Box Assy417U3025-7122BReading Light -Outboard417U3065-12638Oxy Box Assy417U3081-3201Oxy Box Assy417U3081-3223Oxy Box Assy417U3060-14521Oxy Box Assy417U3065-2331Oxy Box Assy417U3072-1Rubber Boot Assy417U3065-12833Oxy Box Assy417U3070-7130BGasper Panel Assy417U3065-15431Oxy Box Assy417U3025-7322BReading Light -Outboard417U3060-8141BOXYGEN BOX ASSY - 4 MASK, M/D417U3025-2261Reading Light Assy417U3025-2262Reading Light Assy417U3063-119Connector Strip417U3062-2005Door Assy-Oxy Box
Back to Boeing 747-400D