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-89-76Cable Assy, SPM J6/J7 to AC OU SGL (200C)1068807-1-108Cable Assy., SWD/FD To Seat1303-47-427Configuration Module, AMCU1248871-0715Cable Assembly, SPM-1 J4 and SPM-2 J4 to In-Use Light1303-12In-Use Light Assembly, Rear Mount, Modular BLU1068806-1Harness Assy.1068105-1Cable1176-1Advanced Master Control Unit1303-41-1919Cable Assembly, SPM J6/J7 to AC OU (Double)1068-2In-Seat Power Supply1248823-0813Cable Assy., SPM J6/J7 To AC OU, DBL, W/Variable Lengths1303-15-44Cable Assembly, SPM J4 To In-Use Light1303-140-24Cable Assembly, SPM To MK V In-Use Light1303-146-44Cable Assembly, SPM J6/J7 to 9-PIN Disconnect1303-47-359Configuration Module, AMCU1303-140-28Cable Assembly, SPM To MK V In-Use Light1303-35-32Cable Assembly, SPM J6/J7 To AC OU (SINGLE)1248888-16Cable Assy, Disconnect to OU SGL, RVSD Latching (200C)1176701-273Configuration Module, AMCU1249819-1Cable Assy., Term Block To Upper Deck AFT Right SWD1191802-40Cable Assembly, ISPS To In-Use or Reading Light1303-151-0506Cable Assembly, SPM-1 J4 and SPM-2 J4 to MARK V, In-Use Light1068807-1Cable Assy.1170801-44Cable, In-Use Light (LED)1068806-1Cable Assy.1303-35-52Cable Assembly, SPM J6/J7 To AC OU (SINGLE)1303-27-2Cable Assembly, SPM J4 To IUL and Switch1170805-96Cable, Outlet Unit, 110 VAC, Straight1303-74-16Wire Assembly, Ground, Seat-To-Seat1303-27-9Cable Assembly, SPM J4 To IUL and Switch1303-114-32Cable Assembly, SPM J6/J7 To Disconnect, SGL OU, RVSD Latching (200C)1303-89-16Cable Assy, SPM J6/J7 to AC OU SGL (200C)1303-47-357Configuration Module, AMCU1067822-1Power Module Cable1303-41-1616Cable Assembly, SPM J6/J7 to AC OU (Double)1248863-28Cable Assembly, SPM J6/J7 to AC OU (Single)1248888-36Cable Assy, Disconnect to OU SGL, RVSD Latching (200C)1303-46Advanced Master Control Unit1170815-12Wire Assembly Ground, Seat-To-Seat1248801-40Cable Assembly, SPM J4 to In-Use Light1248815-80Cable Assy, SPM J6/J7 To AC OU SGL (200C)1068808-1Plug assembly, Termination1248801-100Cable Assembly, SPM J4 To In-Use Light1191825-36Cable Assembly, ISPS To Outlet Unit (Molex)1176701-209Configuration Module, AMCU1191803-80Cable Assembly, ISPS To In-Use Light1170814-128Cable Assembly, In-Use Light Extender1248855-15Cable Assembly, SPM J4 to IUL and Switch1303-47-421Configuration Module, AMCU1303-7-11Outlet Unit, AC
Back to Boeing 747-400D