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.
1303-33-020212Cable Assy SPM J4 to SW, IUL & 2ND SPM J41303-47-422Configuration Module, AMCU1303-35-28Cable Assembly, SPM J6/J7 To AC OU (SINGLE)1249800-1Cable Assy., Power Panel1303-140-52Cable Assembly, SPM To MK V In-Use Light1303-89-20Cable Assy, SPM J6/J7 to AC OU SGL (200C)1067827-6Cable1248815-32Cable Assy, SPM J6/J7 to AC OU SGL (200C)1193-1In-Use Light Assembly, Rear Mount, Modular1248889-48Cable Assy, SPM J6/J7 to Disconnect, SGL OU, RVSD Latching (200C)1170805-132Cable, Outlet Unit, 110 VAC, Straight1248871-1505Cable Assembly, SPM-1 J4 and SPM-2 J4 to In-Use Light1303-47-449Configuration Module, AMCU1068803-2-120Cable Assy., Seat-To-Seat1170805-36Cable, Outlet Unit, 110 VAC, Straight1248814-0205Cable Assy, SPM J6/J7 to AC OU, DBL (200C)1303-27-71Cable Assembly, SPM J4 To IUL and Switch1303-41-0209Cable Assembly, SPM J6/J7 to AC OU (Double)1068563-1MCU Bracket1303-89-68Cable Assy, SPM J6/J7 to AC OU SGL (200C)1303-41-0308Cable Assembly, SPM J6/J7 to AC OU (Double)1303-89-28Cable Assy, SPM J6/J7 to AC OU SGL (200C)1303-35-56Cable Assembly, SPM J6/J7 To AC OU (SINGLE)1170801-28Cable, In-Use Light (LED)1303-15-32Cable Assembly, SPM J4 To In-Use Light1303-47-360Configuration Module, AMCU1170814-60Cable Assy., In-Use light Extender1303-47-449Configuration Module, AMCU1170814-44Cable Assembly, In-Use Light Extender1176701-342Configuration Module, AMCU1235-2-115Outlet Unit, AC1068810-2Seat Grounding Wire1248871-1320Cable Assembly, SPM-1 J4 and SPM-2 J4 to In-Use Light1123804-300Cable Assembly, Cabin Inter-connect, Circular, Plus System1303-114-68Cable Assembly, SPM J6/J7 To Disconnect, SGL OU, RVSD Latching (200C)1067821-1Power Module Cable1303-140-72Cable Assembly, SPM To MK V In-Use Light1068820-2Seat J-Box1171-1-8Outlet Unit, AC, In-Seat Power Supply1248871-0805Cable Assembly, SPM-1 J4 and SPM-2 J4 to In-Use Light1176701-274Configuration Module, AMCU1068803-2Cable Assy.1068805-7Harness - Outlet, Left1176701-290Configuration Module, AMCU1303-140-40Cable Assembly, SPM To MK V In-Use Light1170815-16Wire Assembly Ground, Seat-To-Seat1303-89-48Cable Assy, SPM J6/J7 to AC OU SGL (200C)1248801-28Cable Assembly, SPM J4 To In-Use Light1303-140-48Cable Assembly, SPM To MK V In-Use Light1303-47-425Configuration Module, AMCU
Back to Boeing 747-400D