Pratt & Whitney JT9D series
PMA parts · 3,173
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', 'E3NE')
AND len(list_intersect(tcds_models, ['JT9D-7', 'JT9D-7AH', 'JT9D-7J', 'JT9D-3A', 'JT9D-7F', 'JT9D-7A', 'JT9D-20', 'JT9D-7H', 'JT9D-20J', 'JT9D-7Q', 'JT9D-7Q3', 'JT9D-7R4E4', 'JT9D-7R4E', 'JT9D-70A', 'JT9D-7R4H1', 'JT9D-7R4D1', 'JT9D-7R4D', 'JT9D-7R4E1', 'JT9D-7R4G2', 'JT9D-59A'])) > 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', 'E3NE')
AND len(list_intersect(tcds_models, ['JT9D-7', 'JT9D-7AH', 'JT9D-7J', 'JT9D-3A', 'JT9D-7F', 'JT9D-7A', 'JT9D-20', 'JT9D-7H', 'JT9D-20J', 'JT9D-7Q', 'JT9D-7Q3', 'JT9D-7R4E4', 'JT9D-7R4E', 'JT9D-70A', 'JT9D-7R4H1', 'JT9D-7R4D1', 'JT9D-7R4D', 'JT9D-7R4E1', 'JT9D-7R4G2', 'JT9D-59A'])) > 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.
10-614960-2Stator- -EEC10-614965-1Rotor-EEC10-614965-1Rotor - EEC
Generator10-614960-2Stator - EEC GeneratorDEC01- 056-533Gasket - .093 Free HeightDEC06- 003-501Seal, Shaft, StationaryDEC06- 003-501Seal, Shaft, StationaryDEC31- 174-503Shaft Assembly, FlexibleDEC01- 056-527Gasket - .093 Free HeightKTST2785-10Nut, Self Locking753224WEC-Ring, Internal Pressure733726WEPin, Shoulder Headless, 0.156 X 0.100 X 0.300 X 6.720733726WEPin, Shoulder Headless, 0.156 X 0.100 X 0.300 X 6.720715118WEPin, Straight Headed, .1705 X .305, Slab715118WEPin, Straight Headed, .1705 X .305, SlabM5001518-01Shoulder PinM770354Spacer-#1&2 BearingRDST1428-04Clamp, LoopM5005438-01Stop- Instrumentation Plug44ASP290ASwitch Assembly44ASP290ASwitch Assembly44ASP290Switch Assembly44ASP290Switch AssemblyH49513-4Nut, S-LK29109-5-4Nut, S-LK39268-5Nut, S-LMK50476-4Nut, S-LH29117-4Nut, S-LK29109-5-4Nut, S-LK39255-4Nut, S-LH29118-3Nut, S-LK29110-4Nut, S-LH22-5PWNut, S-LH50361-5Nut, S-LMF1031-3PWNut, S-LF5231-4PWNut, S-LK1000X4PWNut, S-LMF39839-4Nut, S-LH19942-3Nut, S-LK52341-3Nut, S-LK49502-4Nut, S-LF39244-3BCNut, S-LH29118-3Nut, S-LMK2000-4CWPWNut, S-LK3031-3PWNut, S-LH29220-4Nut, S-LH29220-4Nut, S-LH29011-6Nut, S-LH29605-4Nut, S-LK39369-4Nut, S-L
Back to Pratt & Whitney JT9D series