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-41-0111Cable Assembly, SPM J6/J7 to AC OU (Double)1303-41-1515Cable Assembly, SPM J6/J7 to AC OU (Double)1067810-1-1Cable Assy., I/O, MCU To Zia Disconnect1248889-40Cable Assy, SPM J6/J7 to Disconnect, SGL OU, RVSD Latching (200C)1248801-28Cable Assy., SPM J4 To In-Use Light1248889-36Cable Assy, SPM J6/J7 to Disconnect, SGL OU, RVSD Latching (200C)1248871-0702Cable Assembly, SPM-1 J4 and SPM-2 J4 to In-Use Light1176701-238Configuration Module, AMCU1172-1Assembly, In-Use Light1303-89-52Cable Assy, SPM J6/J7 to AC OU SGL (200C)1068826-1-144Cable Assembly, SWD/FD To Seat1235-2-5Outlet Unit, AC1123804-72Cable Assy., Cabin Interconnect, Circular, Plus System1248871-0803Cable Assembly, SPM-1 J4 and SPM-2 J4 to In-Use Light1303-151-1617Cable Assembly, SPM-1 J4 and SPM-2 J4 to MARK V, In-Use Light1176701-210Configuration Module, AMCU1303-41-0717Cable Assembly, SPM J6/J7 to AC OU (Double)1235-1-2Outlet Unit, AC1123804-66Cable Assy., Cabin Interconnect, Circular, Plus System1303-35-68Cable Assembly, SPM J6/J7 To AC OU (SINGLE)1176701-293Configuration Module, AMCU1123808-102Cable Assembly, SWD/FD (Clocked) To Seat1303-89-24Cable Assy, SPM J6/J7 to AC OU SGL (200C)1176701-144Configuration Module, AMCU1067824-1Power Module Cable1303-151-0909Cable Assembly, SPM-1 J4 and SPM-2 J4 to MARK V, In-Use Light1068825-1-132Cable Assembly, Seat-To-Seat1303-41-0909Cable Assembly, SPM J6/J7 to AC OU (Double)1303-41-0606Cable Assembly, SPM J6/J7 to AC OU (Double)1193-2In-Use Light Assembly, Rear Mount, Modular1303-47-362Configuration Module, AMCU1170805-16Cable, Outlet Unit, 110 VAC, Straight1075-2-4Outlet1303-74-12Wire Assembly, Ground, Seat-To-Seat1248816-24Cable Assy, SPM J6/J7 to Disc DBL OU (200C)1176701-216Configuration Module, AMCU1303-147-32Cable Assembly, 9-PIN Disconnect to Outlet Unit1170805-16Cable, Outlet Unit, 110 VAC, Straight1176701-298Configuration Module, AMCU1303-47-426Configuration Module, AMCU1123807-78Cable Assy.1248814-1108Cable Assy, SPM J6/J7 To AC OU, DBL (200C)1248801-24Cable Assy., SPM J4 To In-Use Light1248801-28Cable Assembly, SPM J4 To In-Use Light1067820-1Power Module Cable1068803-2Cable Assy.1176701-204Configuration Module, AMCU1303-47-144Configuration Module, AMCU1170805-60Cable, Outlet Unit, 110 VAC, Straight1249812-1Cable Assy., Term Block To VCC Disconnect
Back to Boeing 747-400D