Pratt & Whitney JT9D-7Q
PMA parts · 971
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 ('E3NE')
AND len(list_intersect(tcds_models, ['JT9D-7Q'])) > 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 ('E3NE')
AND len(list_intersect(tcds_models, ['JT9D-7Q'])) > 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.
MK2000-3PWNut, S-LH19942-3Nut, S-LH29220-5Nut, S-LF2000-4PWNut, S-LK2000-4CWNut, S-LH29118-5Nut, S-LH49040-6Nut, S-LH39729-4Nut, S-LK51086-4Nut, S-LK29843-4-1Nut, S-LH29119-5Nut, S-LF29724-4Nut, S-LK49502-4Nut, S-LH29119-4Nut, S-LMK49975-4Nut, S-LH50333-4Nut, S-LF50030-4Nut, S-LMK2000-4CWPWNut, S-LMF1031-3PWNut, S-LH29967-5Nut, S-LH19943-3Nut, S-LH29117-3Nut, S-LCN50039-4Nut, S-LK29109-4-1Nut, S-LVL1301VE1Ring, BackupVL1370PE1-0863Gasket, SealVL1144PW23-33C-Ring, Internal PressureVL1144PW23-05C-Ring, Internal PressureVL1144PW23-49C-Ring, Internal PressureVL1144PW23-30C-Ring, Internal PressureVL1161PW36-08C-Ring776440WENut, Self LockingDEC01-056-533Gasket - .093 Free HeightM770354Spacer-#1&2 BearingNSL1422RC A2SealantNSL890RC A2SealantNSL1422RC B1/2SealantNSL1422RC B2SealantNSL890RC A1/2SealantNSL1422RC A1/2SealantNSL1750-B2SealantNSL1422-A2SealantNSL1750-B1/2SealantNSL1422-B1/2SealantNSL1422-B2SealantNSL1422-A1/2Sealant3237450-65STARBall-Bearing, Kit3237450-67STARBall-Bearing, Kit3237450-64STARBall-Bearing, Kit3237450-66STARBall-Bearing, Kit
Back to Pratt & Whitney JT9D-7Q