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.
1205FF-1C1-02BEARING1210LT-1B1-01BEARING1208-1B1-01BEARING1211LT-1B1-01BEARING1212-1B1-01BEARING1201-1B1-01BEARING1209LT-1B1-01BEARING1210FF-1C1-01BEARING1208FF-1C1-01BEARING1214-1B1-01BEARING1200FF-1C1-02BEARING1206FF-1C1-01BEARING1214LLT-1C1-01BEARING1205LT-1B1-01BEARING1213-1B1-01BEARING1212LLT-1C1-01BEARING1209LLT-1C1-01BEARING1214FF-1C1-01BEARING1206LT-1B1-01BEARING1215-1B1-01BEARING1215LT-1B1-01BEARING1212FF-1C1-01BEARING1213LLT-1C1-01BEARING1210-1B1-01BEARING1211FF-1C1-01BEARING1168610-2FSMicrophone Assy1203LT-1B1-01BEARING1208LLT-1C1-01BEARING101141-4CR-1200Hose Assembly387LNCISMILamp387LNCISMILamp8921560G5Duct Heater24E507589G02Drain Mast8921560G2Duct Heater8921560G1Duct Heater8921340G1Lavatory Water Heater8921270G2Drain Mast8921867G1Fuel Drain Mast8921560G4Duct Heater24E506700G1Drain Mast8921560G3Duct Heater24E507040G01Lavatory Water HeaterJA1192-125Key, LockM7904-005774Hinge Pin18-4400-1Valve Assy-Defuel, Manually Operated803360-1Reservoir774400-24Valve Assy Sump Drain774400-28Valve Assy Sump Drain4087T100-5Trailing Edge Flap Alternate MotorCS1011-119Lower Deck Cargo Handling System
Back to Boeing 747-400D