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.
1167871-205Cable Assembly601341-0001Roll Screen inch A Zone700-2200-002SVDU1167850-1Cable Assembly704-3297-014Cable Assy, Feeder, 1394/F40-620785-150Tapping Unit Terminator1167006-142Local Area Controller749-0597-001Harness Assy, PCU3/SW-DISC, Triple910040-01-5180-4Airshow 210 DIU910030-5037Airshow 210 DIU921005Airshow 420 DIU617-6464-001Mk7 Proj. Installation1167890-100Cable Assembly617-5053-001CSU1167871-204Cable Assembly1307892-010Cable Assy, Disconnect/ RGB Video612571-0001Roll Screen U.D.1167890-110Cable Assembly785-0099-009Screen System, SQ910040-01-5095-1Airshow 210 DIU749-0472-004Harness Assy, SEU-PCU, Triple, Seatback1156506-151Seat Electronics Box SEB AV12116700-140Service Controller1167891-49Cable Assembly749-0477-003Harness Assy, SEU-PCU, Double, W/SW Prov1167002-142Central Management Unit (CMU)1167871-207Cable Assembly1103103TerminatorIndex List 1304630Total Entertainment System1156509-153PESC-V1156590-150Area Distribution Box (ADB-LAC)1167890-106Cable Assembly1307867-008Cable Assembly, AVU/AVU617-6464-005Mk Viii Proj. Installation1167003-142ECS970-0005-003Passenger Control Unit (RH)70-625572-002Instl, Kit System Cables1167006-143Local Area Controller617-6510-0016.4 inch Seatback SVD/Shroud Assy, W/SVD, Bac 7801, E1167863-28Cable Assembly950-0005-00110.4 inch LCD Monitor1167875-222Cable Assembly1307187-013Cable Assembly, SWD/AVU1306650-002Cable Assembly, Disconnect to Disconnect612558-0001Adapter, Projector1306234-002Cable Assy, Galley Disc/Dual Phone611595-0001Installation Kit, 10.41167856-15Cable Assembly60B40125-206Zone Multiplexer1167004-140Passenger Adrs Control
Back to Boeing 747-400D