Pratt & Whitney JT9D-7H
PMA parts · 1,054
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 engine 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 ('E20EA')
AND len(list_intersect(tcds_models, ['JT9D-7H'])) > 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 ('E20EA')
AND len(list_intersect(tcds_models, ['JT9D-7H'])) > 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.
47997Bellows Assembly54647Seal AssemblyP54645Seal AssemblyP48000Bellows Seal Assembly54646Seal AssemblyP54647Seal AssemblyP54644Seal Assembly54758Seal AssemblyP49594Seal AssemblyP69163-1Seal OptionP69163-1Seal AssyP69164-1Seal OptionP69164-1Seal AssyP69164-1Seal OptionP69163-1Seal Option494956WESeal, Plain EncasedAS3145PSealantAS3145SealantAS157SealantAS106SealantAS159SealantAS159SealantAS157SealantAS3145SealantAS3145PSealantAS3145 & AS3145PSealantAS159SealantAS159SealantAS106SealantAS3145SealantAS3145PSealantAS157SealantAS157SealantADB863F65Y4Lube Filter ElementNSL1422-B1/2SealantNSL1422-A2SealantAS106SealantNSL1750-B1/2SealantNSL1750-B2SealantNSL1422-A1/2SealantNSL1422-B2SealantST1594-12WEClamp-Loop, CushionST1594-20WEClamp-Loop, CushionST1594-08WEClamp-Loop, CushionST1594-07WEClamp-Loop, CushionST1594-16WEClamp-Loop, CushionST1594-04WEClamp-Loop, CushionST1594-10WEClamp-Loop, CushionST1594-42WEClamp-Loop, CushionST1594-06WEClamp-Loop, Cushion
Back to Pratt & Whitney JT9D-7H