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.
H29220-6Nut, Self-Locking, Double HexH19942-3Nut, Self-Locking, Double HexMF39839-4Nut, Self-Locking, PlateH29118-4Nut, Self-Locking, Double HexK29109-4-1Nut, Self-LockingK49331-4Nut, Self-Locking, ClinchF11766-4Nut, S-L, PLATED52ZA1-02Nut, S-L, PLATENS203087-4Nut, S-L, PLATELHTA51M2860-048Nut, S-L, PLATECGA804105Blade, High Pressure Compressor, JT9D, Stage 5KT806308PlugNS203306-4NUT, S-L, PLATENS203274-3NUT, S-L PLATENS203299-4NUT, S-L, PLATENS202051-02NUT, S-L PLATENS202353-048NUT, S-L PLATENS203278-6-3NUT, S-L CLIPNS202081-02NUT, S-L, HEXNS202448-4NUT, S-L PLATENS103675-048NUT, S-L PLATENS203283-6-3NUT, S-L CLIPNS103555-02NUT, S-L PLATENS203274-4NUT, S-L PLATENS203285-4NUT, S-L, PLATEVCC0234Bolt, Machine .250-28X .680, Double Hex HeadVCC0235Bolt, Machine .250-28 x .950 Double Hex HeadB02104-5-18PMABolt, Machine, Double Hex, .3125-24B02104-5-10PMABolt, Machine, Double Hex, .3125-24B02104-5-14PMABolt, Machine, Double Hex, .3125-24B02104-5-09PMABolt, Machine, Double Hex, .3125-24B02104-5-17PMABolt, Machine, Double Hex, .3125-24B02104-5-16PMABolt, Machine, Double Hex, .3125-24A76602UFuel De-icing ValveA76602PValve Solenoid, Air Shut-offA76602SFuel De-icing Valve101050A2Valve, fuel de-icingA76602MValve, fuel de-icing101050A3Valve, fuel de-icingA76602TFuel De-icing ValveA76602NValve, fuel de-icing774739QQBolt15800Thermocouple ImmersionNS202109-048Nut Self-Locking, Plate, 2 Lug104086-16Ring, Retaining, Bolt59609-428Nut, Self Locking, Gang Channel69250-428Nut, Self Locking, DH61148-524-2Nut, Self Locking, Clinch69418-524Nut, Self Locking, DH70295-1032Nut, Self Locking, DH
Back to Pratt & Whitney JT9D-7Q