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.
1307366-001Harness Assy, VCCINDEX LIST 062-0142VIDEO ENTERTAIN SYSTEM914023-4Tray Assembly749-0478-003Harness Assy, SEU-PCU, Triple, W/SW Prov704-3295-010Cable Assembly, Seat-Seat, 1394749-0601-001Harness Assy, SEU-JAU1/JAU2/ Disc, Double1167878-45Cable Assembly1167010-141Audio Multiplexer1301353-007LAC617-6424-001Stationary Screen Installation1307866-012Cable Assembly, SWD/AVU1103102Terminator1167866-33Cable Assembly1140-0160-115Fuel Stick Assembly700-2200-001SVDU1167877-44Cable Assembly910040-01-5026-3Airshow 210 DIU1167890-117Cable Assembly617-6388-001Rack Assembly743-0238-001Hi-Band Video 8 VTR704-3294-013Cable Assembly, Seat-SeatR54040008Video Display Unit Console1167869-41Cable Assembly921111Caddy Assy1167858-18Cable Assembly1307209-001Provision Kit, Bulkhead Phones1103099Terminator621890APAX-150 Worldlink Passenger Entertainment40-622567-001Primary Access Terminal (PAT) Assy1167864-29Cable Assembly749-0601-002Harness Assy, SEU-JAU1/JAU2/ Disc, Double1167890-113Cable Assembly921006DIUS220U006-200PAC1167855-14Cable Assembly1167001-140Cabin Test Module1301311-019Cable Assy, AVU/Disc/UPCU/Audio, Dbl1167858-19Part Name Cable AssemblyS220U006-400PSC1150410-100Central Switching Unit1167853-10Cable Assembly970-0022-013PCH/Cradle Assembly, 32 inch Ratchet, SAA1167873-214Cable Assembly1167860-23Part Name Cable Assembly704-3294-010Cable Assy, Seat-Seat704-3295-009Cable Assembly, Seat-Seat, 1394704-3289-004Cable Assy, SEU-SVD Disc, Double1167894-54Cable Assembly60B40125-208Seat Electronics Box20-625652-003Instl. Kit, Personal Video, B/C, CTR
Back to Boeing 747-400D