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.
ST1594-14WEClamp-Loop, CushionST1594-05WEClamp-Loop, CushionST1142-031WEGasket-0.125 Free HeightST1142-031WEGasket-0.125 Free HeightKTST1222-14Bolt- Mach, DHAC9840F65Y1Lube Oil Filter ElementAC9840E40Filter ElementAC9840F30FilterAR809125Fan Case Duct SegmentAR652309Arm - Assy ofAR809124Fan Case Duct Segment5000574-01AARBraceAR809122Fan Case Duct SegmentAR809390Fan Case Duct Segment805387AARShim-1st Stage Compressor Blade RootAR809387Fan Case Duct SegmentAR809392Fan Case Duct SegmentAR809120Fan Case Duct SegmentAR809391Fan Case Duct SegmentAR809386Fan Case Duct SegmentAR623629Pin-Step, HeadlessAR656302Pin-GearboxAR809123Fan Case Duct SegmentAR652311Arm - Assy ofAR809388Fan Case Duct SegmentAR809389Fan Case Duct SegmentAR809126Fan Case Duct SegmentAR809393Fan Case Duct SegmentNSL890RC A2SealantNSL1422RC A1/2SealantNSL1422RC B1/2SealantNSL890RC A1/2SealantNSL1422RC B2SealantNSL1422RC A2Sealant599798WDBall, Spherical599805WDBall, Spherical546689WEFerrule-Tube Fitting, .625694280WERivet494956WESeal, Plain Encased534492CL1WECounter-Weight776703 WENut821454WENut214306-1WABearing, Pressurized212638WESpring, Bearing Preload587681WEGasket- 0.5110 X 0.750 X 0.052545962WEScrew, Machine4023466WENut391009WEPacking Preformed, 0.497 X 0.760 X 0.3575546690WEFerrule-Tube Fitting, 0.750490111WEBolt-Machine, 0.250-28 X 0.438, Drilled Double Hex
Back to Pratt & Whitney JT9D-7H