Pratt & Whitney JT9D-7R4D
Service difficulty reports · 1,031
Newest first. General aviation reporting is voluntary.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE engine_model_key = 'JT9D7R4D' ORDER BY difficulty_date 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 sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE engine_model_key = 'JT9D7R4D' ORDER BY difficulty_date DESC
Run 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.
SDR 2001UALA02020Stringer · corrodedBODY STATION 412-434 STRINGER 38R CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER AND SPLICES.SDR 2001UALA01992Power Supply · dischargedRIGHT AISLE OF ECONOMY EMERGENCY FLOOR LIGHTING ILLUMINATED IN FLIGHT. REPLACED EEL LIGHT POWER SUPPLIES.SDR 2001UALA01965Shear Tie · corrodedBODY STATION 1131 STRINGER 39L-39R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01966Stringer Clip · elongatedBODY STATION 368 STRINGER 36L STRINGER CLIP HAS ELONGATED HOLES. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER CLIP.SDR 2001UALA01967Floorbeam · corrodedBODY STATION 1351 RBL 15-RBL 33 T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CAP.SDR 2001UALA01978Battery Pack · intermittentEEL IN RIGHT HAND FLASHING INTERMITTENTLY IN FLIGHT. REPLACED EEL BATTERY PACK.SDR 2001UALA01968Floorbeam · corrodedBODY STATION 830-860 RBL 59 FLOORBEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED FLOORBEAM SECTION AND SPLICES.SDR 2001UALA01969Stringer · corrodedBODY STATION 584-592 STRINGER 36L CORRODED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER.SDR 2001UALA01970Stringer · corrodedBODY STATION 478 STRINGER 39L CORRODED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER.SDR 2001UALA01971Stringer · corrodedBODY STATION 410 STRINGER 36R CORRODED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER.SDR 2001UALA01972Stringer · crackedBODY STATION 1065-1087 STRINGER 28R IS CRACKED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. REPLACED AND INSTALLED STRINGER.SDR 2001UALA01973Stringer · corrodedBODY STATION 325-434 STRINGER 39R CORRODED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. REPLACED AND INSTALLED STRINGER.SDR 2001UALA01974Stringer · corrodedBODY STATION 500 STRINGER 36R CORRODED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER.SDR 2001UALA01975Floorbeam · corrodedBODY STATION 1197 STRINGER 33L T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CAP.SDR 2001UALA01940Shear Tie · corrodedBODY STATION 1197 STRINGER 37R-36R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01941Shear Tie · corrodedBODY STATION 1175 STRINGER 37R-36R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01942Clip · crackedBODY STATION 720-722 STRINGER 34L CLIP CRACKED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED CLIP.SDR 2001UALA01943Fitting · corrodedBODY STATION 368 STRINGER 38R END FITTING CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED FITTING.SDR 2001UALA01944Fitting · corrodedBODY STATION 325 STRINGER 39L END FITTING CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED FITTING.SDR 2001UALA01945Fitting · corrodedBODY STATION 325 STRINGER 39R END FITTING CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED FITTING.SDR 2001UALA01946Stringer · corrodedBODY STATION 418-478 STRINGER 38L CORRODED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER.SDR 2001UALA01947Fitting · corrodedBODY STATION 1087-1080 STRINGER 37R END FITTING CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW FITTING.SDR 2001UALA01948Doubler · gougedBODY STATION 1709-1809 STRINGER 12L DOUBLER GOUGED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. REPLACED AND INSTALLED DOUBLER.SDR 2001UALA01949Intercostal · corrodedBODY STATION 317 LBL 12 WL 110 INTERCOSTAL CORRODED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED DOUBLER.SDR 2001UALA01950Stringer · corrodedBODY STATION 325-434 STRINGER 38L CORRODED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER AND SPLICES.SDR 2001UALA01951Shear Tie · corrodedBODY STATION 1518 STRINGER 35R-36R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01952Shear Tie · corrodedBODY STATION 1395 STRINGER 37L-38L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01953Shear Tie · corrodedBODY STATION 698 STRINGER 39R-39L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01954Shear Tie · corrodedBODY STATION 1175 STRINGER 37L-38L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01955Shear Tie · corrodedBODY STATION 1395 STRINGER 37R-38R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01956Shear Tie · corrodedBODY STATION 1197 STRINGER 37L-38L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01976Control Unit · faultyRETURNED TO SFO DUE RUDDER TRIM ANOMALY. REPLACED AILERON AND RUDDER TRIM CONTROL. OPERATIONALLY CHECKED RUDDER SYSTEM PER APPLICABLE MAINTENANCE MANUAL. ALL OPS CHECKS NORMAL.SDR 2001UALA01977Controller · failedFWD EQUIPMENT NO COOLING LIGHT ON FOR 3 MINUTES. REPLACED CONTROLLER AND CLEANED EQUIPMENT COOLING AIR CLEANER.SDR 2001UALA01897Shear Tie · corrodedBODY STATION 1329 STRINGER 39L-39R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01898Stringer · crackedBODY STATION 1065-1087 STRINGER 25L CRACKED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER.SDR 2001UALA01899Shear Tie · corrodedBODY STATION 1329 STRINGER 36L-37L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01900Stringer · corrodedBODY STATION 766 STRINGER 39L CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER REPAIR.SDR 2001UALA01901Shear Tie · corrodedBODY STATION 1439 STRINGER 39R-39L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01902Stringer · crackedBODY STATION 1065-1087 STRINGER 22R CRACKED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER.SDR 2001UALA01903Stringer · crackedBODY STATION 1065-1087 STRINGER 24L CRACKED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER.SDR 2001UALA01904Shear Tie · corrodedBODY STATION 1333 STRINGER 35R-36R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01905Stringer · corrodedBODY STATION 434 STRINGER 36R SPLICE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SPLICE.SDR 2001UALA01906Shear Tie · corrodedBODY STATION 1263 STRINGER 36L-37L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01907Shear Tie · corrodedBODY STATION 1263 STRINGER 38L-39L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01908Stringer · crackedBODY STATION 1065-1087 STRINGER 25R CRACKED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER.SDR 2001UALA01909Floorbeam · corrodedBODY STATION 1241 RBL 22-LBL24 T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CAP.SDR 2001UALA01910Shear Tie · corrodedBODY STATION 1197 STRINGER 35L-36L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01911Shear Tie · corrodedBODY STATION 1241 STRINGER 38R TO 39R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01912Stringer · crackedBODY STATION 1065-1087 STRINGER 26R CRACKED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER.SDR 2001UALA01913Shear Tie · corrodedBODY STATION 1562 STRINGER 38R-38L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.
Back to Pratt & Whitney JT9D-7R4D