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.
411638WEPacking4004C5-6-14WERoller Bearing4004C6-6D20WERoller Bearing4004C7-7-8WERoller, Bearing4004-6-6-14WERoller, Bearing Element4004C8-11-26WERoller, Bearing386022WEShaft and Insert Subassembly4004C8-12-12WERoller, Bearing Element4004C6-6-14WERoller, Bearing4004-6-6-30WERoller, Bearing Element4004C6-6D34WERoller, Bearing4004C9-10-10WERoller, Bearing Element4004C8-8-16WERoller, Bearing4004C6-6D14WERoller Bearing413T3032-1065WESlider Assy10-60754-7WESealPL24-9112-00Top Level Installation KitDLH045-10012CXModule Assy - First Class LavDLH044-15022CXModule Assy - Centerline LavatoryDLH04B10001CXModule Assy - BC5B/BC6B4004C6-6-14WERoller, Bearing Element4004C6-6D20WERoller, Bearing Element4004C6-6D34WERoller, Bearing Element4004C6-6-20WERoller, Bearing Element4004C6-6-34WERoller, Bearing Element4004C5-6-14WERoller, Bearing Element4004C6-10D20WERoller, Bearing Element4004C6-6D14WERoller, Bearing Element4004C5-5-10WERoller, Bearing ElementPTR1090Track Roller BearingPTR1190Track Roller BearingPTR1190Track Roller BearingM123170-1Roller, CoveredM126170-1Roller, Covered267-5Air Chiller1430-020Cabinet6301-6Forward Lock 6 Pin1205-001Stretcher300372Oxylog Mount1201-001Stretcher6374-1Adapter1403-011Stretcher Bridge1403-001Stretcher BridgeSLA001-1Stretcher Lock Assy1302264-004FSKeypad AssemblySP-KT-27Installation Kit2800-606Ambulance Module2800-001Ambulance Module1211-002Stretcher1401-001Accessory Table
Back to Boeing 747-400D