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 2001UALA01859Shear Tie · corrodedBODY STATION 742 STRINGER 34L-33L SHEAR TIE CORRODED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01860Floorbeam · corrodedBODY STATION 478 LBL 12-22 T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CAP REPAIR.SDR 2001UALA01861Shear Tie · corrodedSTATION 1175 STRINGER 38L-39L SHEARTIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEARTIE REPAIR.SDR 2001UALA01862Strap · corrodedSTATION 654-648 STRINGER 39L STRAP CORRODED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER STRAP REPAIR.SDR 2001UALA01863Clip · corrodedSTATION 1087 STRINGER 36L ATTACH CLIP CORRODED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED.REPLACED STRINGER CLIP.SDR 2001UALA01864Shear Tie · corrodedSTATION 1285 STRINGER 38L-39L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01865Shear Tie · corrodedSTATION 1219 STRINGER 36L-37L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01868Shear Tie · corrodedSTATION 1219 STRINGER 36L-37L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01869Shear Tie · corrodedSTATION 1351 STRINGER 33R-34R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01870Floorbeam · corrodedSTATION 1153 LBL 10-RBL 28 T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CAP REPAIR.SDR 2001UALA01871Shear Tie · corrodedSTATION 1219 STRINGER 35R-36R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01872Clip · elongatedSTATION 368 STRINGER 38R CLIP HAS ELONGATED HOLE. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED CLIP REPAIR.SDR 2001UALA01873Shear Tie · corrodedSTATION 1219 STRINGER 37R-38R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01877Shear Tie · corrodedSTATION 743 STRINGER 37R-38R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01878Shear Tie · corrodedMAJOR BODY STATION 743 STRINGER 37R-38R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01836Connector · faultyPASSING 15,000 FT EICAS C-HYD QTY MSG STATUS PAGE SHOWED ZERO QUANTITY, CENTER QUANTITY LIGHT CAME ON, OPERATED NORMALLY. POSSIBLE LOOSE CONNECTOR PIN AND LOOSE SHIELD TERMINAL. REPLACED CONNECTOR D4946P AND SHIELD GROUND RE-TERMINATED AT CONNECTOR.SDR 2001UALA01813StringerBS-325-434 STRINGER 39R NECESSARY TO FAB STRINGER TO FACILITATE OTHER MAINTENANCE. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER SECTION.SDR 2001UALA01794Splice · corrodedBS 434 STRINGER 39L SPLICE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER SPLICE REPAIR.SDR 2001UALA01795Stringer · corrodedBODY STATION 1080-1087 STRINGER 37R CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER REPAIR.SDR 2001UALA01796Shear Tie · corrodedBODY STATION 1241-1263 STR 37R-38R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01803Shear Tie · corrodedBODY STATION 1153 STRINGER 39L-39R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01804Shear Tie · corrodedBODY STATION 1175-1197 STRINGER 39R-38R SHEAR TIE CORRODED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01805Stringer · corrodedBODY STATION 325-434 STRINGER 39L CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW STRINGER.SDR 2001UALA01806Splice · corrodedBODY STATION 440 STRINGER 36R SPLICE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SPLICE REPAIR.SDR 2001UALA01807Shear Tie · corrodedBODY STATION 1285 STRINGER 38R-39R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01808Splice · corrodedBODY STATION 434 STRINGER 34L SPLICE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER SPLICE REPAIR.SDR 2001UALA01809Stringer · corrodedBODY STATION 714-723 STRINGER 34L CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER REPAIR.SDR 2001UALA01810Shear Tie · corrodedBODY STATION 588 STRINGER 33L-34L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01811Stringer · crackedBODY STATION 434-456 STRINGER 38R CRACKED AND CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER REPAIR.SDR 2001UALA01812Shear Tie · corrodedBODY STATION 610 STRINGER 37L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01814Stringer · corrodedBODY STATION 478 STRINGER 39R CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER REPAIR.SDR 2001UALA01815Shear Tie · corrodedBODY STATION 1285 STRINGER 37L-38L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01816Shear Tie · corrodedBODY STATION 434 STRINGER 33L-34L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER REPAIR.SDR 2001UALA01817Stringer · crackedBODY STATION 1065-1087 STRINGER 28L CRACKED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER REPAIR.SDR 2001UALA01818Shear Tie · corrodedBODY STATION 1307 STRINGER 37L-38L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01819Shear Tie · corrodedBODY STATION 1395 STRINGER 36R-37R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01820Shear Tie · corrodedBODY STATION 1373 STRINGER 37L-38L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01821Shear Tie · corrodedBODY STATION 1373 STRINGER 36L-37L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01822Shear Tie · corrodedBODY STATION 1153 STRINGER 38L-39L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01823Stringer · corrodedBODY STATION 588 STRINGER 38L CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER REPAIR.SDR 2001UALA01824Shear Tie · corrodedBODY STATION 1219-1241 STRINGER 38L-37L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01825Shear Tie · corrodedBODY STATION 478 STRINGER 35R-36R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01826Splice · corrodedBODY STATION 412-456 STRINGER 39R SPLICE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER SPLICE REPAIR.SDR 2001UALA01781Shear Tie · corrodedBODY STATION 1219 STRINGER 35L-36L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND SRM 51-40-02.SDR 2001UALA01783Clip · crackedBODY STATION STRINGER 37R ATTACH CLIP CRACKED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED ATTACH CLIP IN ACCORDANCE WITH BAC DWG 141T3220.SDR 2001UALA01784Shear Tie · corrodedBODY STATION 1417 STRINGER 38R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND SRM 51-40-02.SDR 2001UALA01785Shear Tie · corrodedBODY STATION 1307 STR 35L-36L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND SRM 51-40-02.SDR 2001UALA01786Floorbeam · corrodedBODY STATION 287 RBL 55 FLOORBEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED FLOORBEAM REPAIR IN ACCORDANCE WITH SRM 53-00-51.SDR 2001UALA01787Stringer · corrodedBODY STATION 527 STRINGER 34L CORRODED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER SPLICE REPAIR IN ACCORDANCE WITH SRM 53-00-03.SDR 2001UALA01788Shear Tie · corrodedBODY STATION 1153 STRINGER 39R-38R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND SRM 51-40-02.
Back to Pratt & Whitney JT9D-7R4D