Pratt & Whitney JT8D series
PMA parts · 4,120
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 ('E2EA', 'E9NE')
AND len(list_intersect(tcds_models, ['JT8D-17AR', 'JT8D-1', 'JT8D-17R', 'JT8D-15A', 'JT8D-15', 'JT8D-17', 'JT8D-7', 'JT8D-17A', 'JT8D-5', 'JT8D-11', 'JT8D-9', 'JT8D-7A', 'JT8D-1B', 'JT8D-1A', 'JT8D-9A', 'JT8D-7B', 'JT8D-217C', 'JT8D-217A', 'JT8D-219', 'JT8D-209', 'JT8D-217'])) > 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 ('E2EA', 'E9NE')
AND len(list_intersect(tcds_models, ['JT8D-17AR', 'JT8D-1', 'JT8D-17R', 'JT8D-15A', 'JT8D-15', 'JT8D-17', 'JT8D-7', 'JT8D-17A', 'JT8D-5', 'JT8D-11', 'JT8D-9', 'JT8D-7A', 'JT8D-1B', 'JT8D-1A', 'JT8D-9A', 'JT8D-7B', 'JT8D-217C', 'JT8D-217A', 'JT8D-219', 'JT8D-209', 'JT8D-217'])) > 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.
628748Duct CombustionChamber, Inner,Assembly of806748Case CC, Assy of474948P9Stud – Plain .190-24-32 x 2.188 Long505509Shield - Heat,NR4 Bearing,Assy Of506503CL4Metering Plug – Bleed Control616313Duct – Fan Combustion Chamber & Turbine Assy Of474948P6Stud – Plain .190-24-32 x 2.188 Long845601Blade – LowPressureCompressor, 1StageE823652Vane Cluster – Low Pressure Turbine, 2 Stage823078-01Housing Assy – Gearbox, Rear823078-01Housing Assy – Gearbox, RearVL1268PW95WasherAA134S-1KTIgniter PlugAA134S-1KTIgniter PlugRD1010Ring, CutRD1010Ring, Cut1058V0400-1Start Bleed Control Valve1058V0400-1Start Bleed Control Valve1058V0100Start Bleed Control Valve1058V0100Start Bleed Control Valve1058V0100Start Bleed Control Valve1058V0100Start Bleed Control Valve1058V0400-1Start Bleed Control Valve1058V0400-1Start Bleed Control Valve1058V0400Start Bleed Control Valve1058V0400Start Bleed Control Valve1058V0400-2Start Bleed Control Valve1058V0400-2Start Bleed Control Valve1058V0100-1Start Bleed Control Valve1058V0600Start Bleed Control Valve1058V0600Start Bleed Control Valve1058V0700Start Bleed Control Valve819771WDBearing, Ball819771WDBearing, BallST2273JP-07Pin214635JP-1Bearing214635JP-1Bearing214636JP-1Bearing214636JP-1Bearing214633JP-1Bearing Set214633JP-1Bearing Set214637JP-1Bearing214637JP-1Bearing214634JP-1Bearing214634JP-1BearingDEC01- 039-501Lever - Pressure Ratio Bleed ControlDEC01- 039-501Lever - Pressure Ratio Bleed Control758308P10WWESeal-Ring758308WESeal-Ring758308P15WWESeal-Ring
Back to Pratt & Whitney JT8D series