Pratt & Whitney JT9D-3A
PMA parts · 1,123
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-3A'])) > 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-3A'])) > 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.
AR809393Fan Case Duct Segment, 809393AR809389Fan Case Duct Segment, 809389AR809388Fan Case Duct Segment, 809388AR809122Fan Case Duct Segment, 809122AR809390Fan Case Duct Segment, 809390AR809126Fan Case Duct Segment, 809126AR809392Fan Case Duct Segment, 80939275495-428Nut-self-locking53714-632H19Nut-self-locking, DH72112Pin, Self-Retaining430941Ignition Lead44933-1ExciterZ7433-02KNut-self-locking, HexAR809391Fan Case Duct SegmentAR809120Fan Case Duct SegmentAR809387Fan Case Duct SegmentAR809124Fan Case Duct SegmentDEC61-013-501Gear, FeedbackDEC61-014-501Gear, OutputDEC06-004-501Seal, Shaft - StationaryKT389114PackingKT-1052SealKT-1053SealN771497Duct Segment-Fan, 1st StageN771498Duct Segment-Fan, 1st StageN732765Duct Segment-Fan, 1st StageN800180Duct Segment-Fan, 1st StageN727160Duct Segment-Fan, 1st StageN800183Duct Segment-Fan, 1st StageN771496Duct Segment-Fan, 1st StageN732767Duct Segment-Fan, 1st Stage771499Duct Segment-Fan, 1st StageN765048Duct Segment-Fan, 1st StageKT-1119BaffleLHL9120-5-4Nut, Self-Locking, ClinchD52Z6620-054Nut, self-locking, DHLHL9120-7-4Nut, Self-Locking, ClinchLH11519-4Nut, self-locking, DHD52Z1835-064Locknut, DHD52Z1835-054Nut, self-locking, DHLH9118-5Nut, self-locking, DHDLH6625-054Nut, self-locking, DHLH9118-4Nut, self-locking, DHLH6629-048Nut, self-locking, DHLH6629-02Nut, self-locking, DHL11174-7-4Nut, Self-Locking, ClinchLHL9126-7-4Nut, Self-Locking, ClinchZ7577-40Nut, self-locking, HexLH9353-3Nut, self-locking, HexLH9118-6Nut, self-locking, DH
Back to Pratt & Whitney JT9D-3A