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.
1068828-1-3Switch Box1303-151-0304Cable Assembly, SPM-1 J4 and SPM-2 J4 to MARK V, In-Use Light1303-41-1717Cable Assembly, SPM J6/J7 to AC OU (Double)1075-4-2Outlet Unit1174815-1Assembly, RS-485 Jumper, AC ISPS1170815-92WIRE ASSEMBLY, GROUND SEAT-TO-SEAT1303-74-92Wire Assembly, Ground, Seat-To-Seat1303-42-0810Cable Assembly, SPM-1 J4 and SPM-2 J4 To In-Use Light1249801-1Cable Assy., MCU J1 To Term Block1303-151-1314Cable Assembly, SPM-1 J4 and SPM-2 J4 to MARK V, In-Use Light1303-74-16Wire Assembly, Ground, Seat-To-Seat1248825-40Cable Assy., SPM To Outlet Unit1303-74-16Wire Assembly, Ground, Seat-To-Seat1170803Cable Assembly1248814-1207Cable Assy, SPM J6/J7 To AC OU, DBL (200C)1303-35-60Cable Assembly, SPM J6/J7 To AC OU (SINGLE)1067-2MCU1303-35-40Cable Assembly, SPM J6/J7 To AC OU (SINGLE)1303-42-0910Cable Assembly, SPM-1 J4 and SPM-2 J4 To In-Use Light1235-1-5Outlet Unit, AC1303-42-0711Cable Assembly, SPM-1 J4 and SPM-2 J4 To In-Use Light1248823-0207Cable Assy., SPM J6/J7 To AC OU, DBL, W/Variable Lengths1123809-144Cable Assembly, Set to SWD/FD (Clocked)1067-2Master Control Unit1248815-40Cable Assy, SPM J6/J7 to AC OU SGL (200C)1068821-2Seat J-Box1176701-300Configuration Module, AMCU1249811-1Cable Assy., Term Block To Zone B Left SWD1176701-169Configuration Module, AMCU1248814-1406Cable Assy, SPM J6/J7 To AC OU, DBL (200C)1248809-1Plug Assy., 15 Pin D-Sub, Termination1248815-24Cable Assy, SPM J6/J7 to AC OU SGL (200C)1303-89-44Cable Assy, SPM J6/J7 to AC OU SGL (200C)1123804-96Cable Assy., Cabin Interconnect, Circular, Plus System1303-27-0506Cable Assembly, SPM J4 To IUL and Switch1176701-288Configuration Module, AMCU1068826-1-90Cable Assembly, SWD/FD To Seat1249815-1Cable Assy., Term Block To Zone B FDB1303-47-445Configuration Module, AMCU1303-137-56Cable Assembly, SPM J4 to IUL DISC1170814-28Cable Assembly, In-Use Light Extender1248801-100Cable Assy., SPM J4 To In-Use Light1249808-1Cable Assy., Decompression Relay To Power Panel Disconnect1248814-0105Cable Assy, SPM J6/J7 to AC OU, DBL (200C)1248816-20Cable Assy, SPM J6/J7 to Disc DBL OU (200C)1303-145-050606Cable Assembly, SPM J4 to Two IUL and switch1248871-0814Cable Assembly, SPM-1 J4 and SPM-2 J4 to In-Use Light1303-47-448Configuration Module, AMCU1303-47-140Configuration Module, AMCU1123804-54Cable Assy., Cabin Interconnect, Circular, Plus System
Back to Boeing 747-400D