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.
700-1913-002Cable Installation914033-3Mounting Tray1167007-141Inboard Overhead Unit1167890-105Part Name Cable Assembly1167014-144AMU617-6274-005Mon. Installation 10.4 inch LCD1167860-25Cable Assembly1167890-109Cable Assembly1167867-35Cable Assembly1306554-002Cable Assy, AP1602 Disc/AVU1140-0110-248Fuel Stick Assembly1167890-114Cable Assembly40-625647-1018MM VTP Personal Video Tape Player20-625652-001Instl. Kit, Personal Video, B/C, L/H601612-0000Player Mtg Plate1307187-010Cable Assembly, SWD/AVU1167890-104Cable Assembly1167903Seat Unit Term, Plug1167014-140Audio Mgmt. Unit925010-100Airshow 4200 Digital Media Server1167012-140Pilot's Call Panel704-3294-013Cable Assy, Seat-Seat1167865-50Cable Assembly1307187-006Cable Assembly, SWD/AVU610610-0003Monitor 10.41167008-141Outboard Overhead Unit1167014-142Audio Management Unit700-1516-001SVDU Termination Plug1167870-42Cable Assembly1167867-36Cable Assembly1167856-57Cable Assembly1301343-064Cable Assy, AVU/UPCU/Audio Jack, Trpl1167890-116Cable Assembly743-0293-001Video Reproducer Unit24-622100-00210.4 INCH LCD Monitor921006Airshow 420 Digital Interface Unit492784-0002Projector704-3294-008Cable Assembly, Seat-Seat1306650-004Cable Assembly, Disconnect to Disconnect700-1909-002Cable InstallationIndex List 1304635Video Entertainment System1307891-010Cable Assy, AVU/Disc/RGB Video, TrplIndex List 1304630Enhanced Total Entertainment SystemS220U006-600LAC P/N 1300006-1401167856-16Cable Assembly1167866-32Cable Assembly1300002-140PSC40-622663-003Flip Screen1167002-141Central Mgmt Unit1140-0160-122Fuel Stick Assembly
Back to Boeing 747-400D