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.
1176701-212Configuration Module, AMCU1303-7-16Outlet Unit, AC1303-124-12Wire Assembly, Ground, Seat-To-Seat1170815-40WIRE ASSEMBLY, GROUND SEAT-TO-SEAT1123804-132Cable Assembly, Cabin Inter-connect, Circular, Plus System1303-47-421Configuration Module, AMCU1303-35-60Cable Assembly, SPM J6/J7 To AC OU (SINGLE)1176701-275Configuration Module, AMCU1303-47-420Configuration Module, AMCU1303-74-40Wire Assembly, Ground, Seat-To-Seat1249807-1Cable Assy., MCU J7 To Term Block1191826-96Cable Assy., OU Extension (Molex)1170805-60Cable, Outlet Unit, 110 VAC, Straight1303-14-2Assembly, In-Use Light, MK V1248804-136Cable Assembly, IUL Extender (2 Circuit) Panel Mount1170803-76Cable Assembly, Seat-To-Seat (AC)1292-7-117Outlet Unit, AC1303-15-24Cable Assembly, SPM J4 To In-Use Light1176701-114Configuration Module, AMCU1176701-141Configuration Module, AMCU1068817-1Cable Assy.1303-89-36Cable Assy, SPM J6/J7 to AC OU SGL (200C)1303-5-113Outlet Unit, AC1068807-1-120Cable Assy., SWD/FD To Seat1248814-0703Cable Assy, SPM J6/J7 to AC OU, DBL (200C)1176701-277Configuration Module, AMCU1191803-40Cable Assembly, ISPS to In-Use Light1248804-56Cable Assembly, IUL Extender (2 Circuit) Panel Mount1303-140-60Cable Assembly, SPM To MK V In-Use Light1303-46Advanced Master Control Unit1303-41-0307Cable Assembly, SPM J6/J7 to AC OU (Double)1249813-1Cable Assy., Term Block To Zone A Right SWD1122401-2Switch Assy.1303-47-423Configuration Module, AMCU1303-146-32Cable Assembly, SPM J6/J7 to 9-PIN Disconnect1248823-0202Cable Assy., SPM J6/J7 To AC OU, DBL, W/Variable Lengths1248801-32Cable Assembly, SPM J4 To In-Use Light1176-1Advanced Master Control Unit1068810-2Seat Grounding Wire1191826-32Cable Assembly, OU Extension (MOLEX)1248892-0606Cable Assy, SPM J6/J7 to Disc. DBL OU, Var Leg Length, RVSD Latching (200C)1191825-32Cable Assy., System Interconnect1248815-20Cable Assy, SPM J6/J7 to AC OU SGL (200C)1170815-12Wire Assembly, Ground, Seat-to-Seat1303-14-2Assembly, In-Use Light, MK V1303-125-100Cable Assembly, Adapter/Extender 2 Pin Molex to MK V IUL1170805-28Cable, Outlet Unit, 110 VAC, Straight1191803-232Cable Assembly, ISPS To In-Use Light1303-41-0512Cable Assembly, SPM J6/J7 to AC OU (Double)1176701-144Configuration Module, AMCU
Back to Boeing 747-400D