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.
1068805-5Cable Assy.1191825-44Cable Assembly, ISPS to Outlet Unit (MOLEX)1303-145-051834Cable Assembly, SPM J4 to Two IUL and switch1248825-16Cable Assy., SPM To Outlet Unit1249814-1Cable Assy., Term Block To Zone B Right SWD1123808-108Cable Assembly, SWD/FD (Clocked) To Seat1123804-144Cable Assy., Cabin Interconnect, Circular, Plus System1068805-5Harness Assy.1248817-64Cable Assy, SPM J6/J7 to DISC, SGL OU (200C)1303-140-24Cable Assembly, SPM To MK V In-Use Light1176701-341Configuration Module, AMCU1248863-80Cable Assembly, SPM J6/J7 to AC OU (Single)1303-41-0211Cable Assembly, SPM J6/J7 to AC OU (Double)RD-FA3621-01Seat Power Module1292-1-13Outlet Unit, AC1303-47-443Configuration Module, AMCU1171-1-5Outlet Unit, AC, In-Seat Power Supply1303-140-40Cable Assembly, SPM To MK V In-Use Light1248825-12Cable Assy., SPM To Outlet Unit1303-74-12Wire Assembly, Ground, Seat-To-Seat1248814-0307Cable Assy, SPM J6/J7 To AC OU, DBL (200C)1248814-0407Cable Assy, SPM J6/J7 to AC OU, DBL (200C)1248823-1116Cable Assy., SPM J6/J7 To AC OU, DBL, W/Variable Lengths1170805-32Cable, Outlet Unit, 110 VAC, Straight1248814-0905Cable Assy, SPM J6/J7 to AC OU, DBL (200C)1248821-913Cable Assembly, SPM J4 to IUL, DBL, w/variable Lengths1193-1In-Use Light Assembly, Rear Mount, Modular1176701-301Configuration Module, AMCU1170801-88Cable, In-Use Light (LED)1068808-1Term Plug1248815-28Cable Assy, SPM J6/J7 to AC OU SGL (200C)1303-41-1206Cable Assembly, SPM J6/J7 to AC OU (Double)1170814-80Cable Assembly, In-Use Light Extender1068808-1Plug Assy.1170801-84Cable, In-Use Light (LED)1193-1In-Use light Assemble, Rear Mount, Modular1303-151-1008Cable Assembly, SPM-1 J4 and SPM-2 J4 to MARK V, In-Use Light1170801-24Cable, In-Use Light (LED)1123804-162Cable Assembly, Cabin Inter-connect, Circular, Plus System1248801-60Cable Assembly, SPM J4 to In-Use Light1303-35-72Cable Assembly, SPM J6/J7 To AC OU (SINGLE)1123804-120Cable Assembly, Cabin Inter-connect, Circular, Plus System1248823-1111Cable Assy., SPM J6/J7 To AC OU, DBL, W/Variable Lengths1249817-1Cable Assy., Term Block To Upper Deck FWD Right SWD1123804-108Cable Assy., Cabin Interconnect, Circular, Plus System1191825-48Cable Assembly, ISPS To Outlet Unit (Molex)1176701-215Configuration Module, AMCU1176701-113Configuration Module, AMCU1292-1-13Outlet Unit, AC1303-47-444Configuration Module, AMCU
Back to Boeing 747-400D