Mcdonnell Douglas MD-88
Service difficulty reports · 21,991
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 aircraft_model_key = 'MD88' 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 aircraft_model_key = 'MD88' 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 DALA2017122008758Floor Support · corrodedSEVERAL CORROSION POINTS ON FLOOR SUPPORT Y 200 AND X54 AT FWD WET AREA (W1). FLOOR SUPPORT Y 200 AND X54 AT FWD WET AREA WAS REPLACED PER SRM 51-10-2 & DWG 9910078-627.SDR DALA2017122008757Fitting · corrodedCORROSION ON FITTINGS OF FLOOR PANEL P/N SAA9957828-11. FITTINGS WERE REPLACED PER SRM 51-10-4.SDR DALA2017122008756Skin · damagedDAMAGED METALIZED ON RUDDER SKIN RT AND LT SIDE (EHV). REPAIRED PER ERA 092613-14 MA, REV C.SDR DALA2017122008743Cusp Web · corrodedCORROSION OUT OF LIMITS ON LT CUSP WEB FROM STA Y= 160 TO STA Y=164, X 54 AT PAX CABIN. CORROSION LEVEL 2 CUSP WEB WAS REPAIRED PER SRM 51-70-4.SDR DALA2017122008742Cusp Web · corrodedCORROSION ON CUSP WEBS BTW STA 522 TO 674 LT SIDE LOWER AND UPPER SURFACE CABIN PAX. LEVEL CORROSION 2 CUSP WEBS STA Y= 522 TO 598 AND STA Y= 598 TO STA Y=664 WERE REPLACED PER SRM 53-05 FIG 131 A-24 AND SRM 51-30-2 AND 51-30-5.SDR DALA2017122008740Rib · crackedCRACK ON RIB FORMER STA XRS=332 AT FIXED LEADING EDGE INTERNAL STRUCTURE, RT WING. CRACK RIB FORMER ON STA XRS=332 AT FIXED LEADING EDGE INTERNAL STRUCTURE, RT WING WAS REPAIRED PER ER/A 530827-14MA REV: ORIGINAL.SDR DALA2017121908718Bulb · inoperativeNUMERIOUS EMERGENCY LIGHTS IN THE OVERHEAD CABIN INOPERATIVE. REPLACED THE BULBS.SDR DALA2017121908717Seat Track · corrodedOUT OF LIMITS CORROSION ON THE SEAT TRACK LBL 22 FROM BS 855 TO 856, BS 965 TO 966 AND BS 996 TO 997. THE DAMAGE AREAS WERE REPAIRED IAW SRM 53-05.SDR DALA2017121908716Floor Panel · crackedCRACKED FLOOR PANEL 1003F. THE FLOOR PANEL WAS REPAIRED.SDR DALA2017121908715Seat Track · corrodedCORROSION OUT OF LIMITS ON THE SEAT TRACK LBL 22 FROM BS 451 TO 453 IN THE PAX CABIN. THE DAMAGED AREA WAS REPAIRED.SDR DALA2017121908714Cusp Web · corrodedCORROSION OUT OF LIMITS ON THE RT CUSP WEB BETWEEN BS 739 TO 742. DAMAGE AREA WAS REPAIRED.SDR DALA2017121908721Floor Support · corrodedCORROSION ON FLOOR SUPPORT BS 255 LBL 33. THE FLOOR SUPPORT WAS REPLACED IAW SRM 51-30-5.SDR DALA2017121908723Cover · tornTORN COVER TAPE ON AUXILIARY HYD PUMP POWER FEEDER WIRING CONNECTOR AT RH W/W. COVER TAPE ON AUX HYD PUMP FEEDER WIRING CONNECTOR WAS REPLACED PER ER/A 467688-14MA AD (LP# 0344059)SDR DALA2017121908722Cusp Web · corrodedCORROSION OUT OF LIMITS ON CUSP WEB LT SIDE ON BS 855. REPAIRED IAW SRM 53-05 FIG. 131A-14.SDR DALA2017121908705Angle · crackedCRACK CLIP ON STOP FITTING #1 AT FWD/LH OVERWING EMERGENCY EXIT DOOR. CLIP WAS REPLACED PER DC-9/MD80 DWG:9957735 REV:G AND SRM 51-30-5 ,51-30-2 (LP# 0344320)SDR DALA2017121908704Seat Track · corrodedCORROSION ON LT SEAT TRACK LBL 54, BS 858 TO 859. REPAIRED IAW SRM 53-05, FIG 4A.SDR DALA2017121908703Former · crackedCRACKED FORMER RWS 290 AT FIXED LEADING EDGE INTERNAL STRUCTURE. REPAIRED IAW SRM 57-06B, PARA 7, FIG 18.SDR DALA2017121908702Rib · crackedCRACKED RIB WS 300 TO 319 AT FIXED LEADING EDGE INTERNAL STRUCTURE, LT WING. THE RIB WAS REPLACED IAW SRM 51-30-2, SRM 51-30-5, AND DWG 9937588, REV G.SDR DALA2017121908701Longeron · crackedCRACKED LONGERON 3R, BS 1437. REPAIRED IAW SRM 53-02, PARA 12.SDR DALA2017121908700Rib · crackedCRACKED RIB AND ANGLE WS 217 TO 346 AT FIXED LEADING EDGE INTERNAL STRUCTURE , LT WING. THE RIB WAS REPLACED IAW SRM 51-30-2 AND SRM 51-30-5.SDR JR2R20171218285Attach Fitting · crackedCANTED FRAME 1463 RT, AFT FACE OB, EXTERIOR LOUVER FWD LOWER ATTACH CLIP CRACKED. REMOVED AND REPLACED RT ATTACH CLIP AT STA 1463 IAW SRM 51-30-5.SDR JR2R20171218257Attach Angle · crackedCANTED FRAME 1463 LH, AFT FACE OB, EXTERIOR LOUVER FWD ATTACH CLIP CRACKED. REMOVED AND REPLACED LH ATTACH CLIP AT STA 1463 I.A.W. MD80 SRM 51-30-5SDR DALA2017121908720Battery Pack · inoperativeCEILING EMERGENCY LIGHTS OUT AT ROWS 12,13,AND 14. REPLACED BATTERIES IN THE POWER SUPPLY.SDR DALA2017121808719Connector · disconnectedEMERGENCY LIGHT AT 23 DE INOPERATIVE. FOUND THE CONNECTOR DISCONNECTED. RECONNECTED.SDR DALA2017121808712Bearing · corrodedRUSTED RUDDER YOKE BEARING (EHV). DUE TO CORROSION LEVEL 2, BEARING WAS VERIFIED AND REPLACED.SDR DALA2017121808668Lamp · inoperativeBOTH FWD CABIN DOOR EMERGENCY LIGHTS OUT. RELAMPED BOTH FWD CABIN DOOR EMERGENCY LIGHT ASSYS PER MD88 AMM 33-53. OPS CHECKED GOOD. (LP3869586)SDR DALA2017121808667Seat Track · corrodedCORROSION OUT OF LIMITS ON LH SEAT TRACK X 22 FROM STA Y=764 TO STA Y=765 AT PAX CABIN. (LEVEL CORROSION 2) DAMAGE SECTION WAS REPLACED PER DC9/MD80 SRM 51-30-1 AND 51-30-5. (LP0342845)SDR DALA2017121808663Longeron · crackedFUSELAGE CRACK AT FASTEN HOLE STA 294 L24L. REMOVED DAMAGE SECTION 54 3/4 OF LONGERON 24 LEFT @ STA 294 AND REPAIRED LONGERON IAW MD88 SRM 53-02 FIG 18. (LP0342699)SDR DALA2017121808662Channel · crackedCRACKED CHANNEL ON FLOOR PANEL NBR 313E, 465E, 389G 693E, 313A,1003A AND 256A AT CABIN FLOOR STRUCTURE. FLOOR PANELS 313E, 465E, 389G 693E, 313A, 1003A & 256A WERE REPAIRED PER DC9/MD80 SRM 53-05 PAR 145. (LP0343025)SDR DALA2017121808656Seat Track · corrodedCORROSION OUT OF LIMITS ON LH SEAT TRACK X 22 FROM STA Y=794 TO STA Y=796 AT PAX CABIN. (LEVEL CORROSION 2) DAMAGE SECTION WAS REPLACED PER DC9/MD80 SRM 51-30-1 AND 51-30-5.SDR DALA2017121808713Battery Pack · inoperativeOVERHEAD CABIN EMERGENCY LIGHTS INOPERATIVE ROWS 22-25. REPLACED THE BATTERIES.SDR DALA2017121808666Seat Track · corrodedCORROSION ON RH SEAT TRACK X=-54 BTW STA Y=-629-630 AT PAX CABIN IN REF NRC 00317. (LEVEL CORROSION 2) DAMAGE AREA WAS REPAIRED PER DC9/MD80 SRM 53-05 FIG 4A. (LP0342127)SDR DALA2017121808665Seat Track · corrodedCORROSION ON RH SEAT TRACK X=-54 STA Y=307 IN REF NRC 00317. (LEVEL CORROSION 2) DAMAGE AREA WAS REPAIRED PER DC9/MD80 SRM 53-05 FIG 4A. (LP0342099)SDR DALA2017121808664Seat Track · corrodedCORROSION ON RH SEAT TRACK X =-54 BTW Y=531-532 AT PAX CABIN IN REF NRC 00317. (LEVEL CORROSION 2) DAMAGE AREA WAS REPAIRED PER DC9/MD80 SRM 53-05 FIG 4A. (LP0342112)SDR DALA2017121808661Floorbeam · corrodedSEVERAL CORROSION POINTS ON FLOOR SUPPORT Y 197 AND FROM X16 TO 40 AT FWD WET AREA. (LEVEL CORROSION 2) FLOOR SUPPORT Y 197 AND FROM X16 TO 40 AT FWD WET AREA WAS REPLACED PER DC9/MD80 SRM 51-30-02.SDR DALA2017121808660Cusp Web · corrodedSEVERAL CORROSION POINTS ON RH CUSP WEB DOUBLER REPAIR Y 560. LEVEL CORROSION 2.RH CUSP WEB Y=560 WAS REPAIRED PER SRM 53-05 FIG 131A.SDR DALA2017121808658Rib · crackedCRACK ON RIB STA XRS=326 AT FIXED LEADING EDGE INTERNAL STRUCTURE , RH WING. RIB ON STA XRS=326 AT FIXED LEADING EDGE INTERNAL STRUCTURE , RH WING WAS REPLACED PER DC-9/MD-80 SRM 51-30-05, SRM 51-30-02, AND DWG 9937589 REV D. (AD)(LP0341549)SDR DALA2017121608655Floorbeam · corrodedSEVERAL CORROSION POINTS ON FLOOR SUPPORT Y 200 FROM X-5 TO X5 AT FWD WET AREA. LEVEL CORROSION 2. FLOOR SUPPORT Y 200 FROM X-5 TO X5 AT FWD WET AREA (W1) WAS REPLACED PER DC9/MD80 SRM 51-30-2. (LP0340778)SDR DALA2017121808652Floor Support · corrodedSEVERAL CORROSION POINTS ON FLOOR SUPPORT X50 FROM Y 166 TO 182 AT FWD WET AREA. LEVEL CORROSION NR 2. FLOOR SUPPORT WAS REPLACED ON X=50 FROM Y=166 TO X=182 PER SRM 51-30-02.SDR DALA2017121808651Cusp Web · corrodedCORROSION OUT LIMITS ON CUSP WEB BTW STA Y=730 TO Y=731 LT SIDE AT CABIN PAX. (LEVEL CORROSION 2) CUSP WEB WAS REPAIRED PER SRM 53-05 FIG 131A-9.SDR DALA2017121808659Cusp Web · corrodedCORROSION OUT OF LIMITS ON CUSP WEB BTW STA Y=1010 TO 1012 LH SIDE AT PAX CABIN, IN REF TO NRC S/N 00632.(LEVEL CORROSION 2) CUSP WEB WAS REPAIRED PER DC9/MD80 SRM 53-05 FIG 131A.SDR DALA2017121808657Cusp Web · corrodedCORROSION ON RH CUSP WEB STA Y=405 BTW X=-54 TO X=-60 AT PAXCABIN. LEVEL CORROSION 2: CUSP WEB WAS REPAIRED PER DC9/MD80 SRM 53-05 FIG 131A-13. (LP0339984)SDR DALA2017121808650Battery · dischargedOVERHEAD EMERGENCY LIGHTS BETWEEN ROWS 11 AND 15 INOP. REPLACED BATTERIES AT BATTERY PACK ROW 12 RIGHT. OPS CKS GOOD PER AMM 33-50.SDR DALA2017121808649Longeron · crackedCRACK ON LONG NR 4R STA Y=1437 AT AFT ACCESSORY COMPT. REPAIRED PER SRM 53-02 PAR 12.SDR DALA2017121808648Seat Track · corrodedOUT OF LIMITS CORROSION ON RT SEAT TRACK X=-44 FROM STA Y=200 TO 247 PAX CABIN. (LEVEL CORROSION 2) DAMAGE SECTION WAS REPLACED PER SRM 53-05 FIG 4.SDR DALA2017121808647Floor Support · corrodedSEVERAL CORROSION POINTS ON FLOOR SUPPORT FROM Y 160 TO 200 AND X-53 AT FWD WET AREA. (LEVEL CORROSION 2) FLOOR SUPPORT FROM Y 160 TO Y 200 AND X-53 AT FWD WET AREA WAS REPLACED PER SRM 51-30-02.SDR DALA2017121808646Floor Support · corrodedSEVERAL CORROSION POINTS ON FLOOR SUPPORT Y 180 AND FROM X-11 TO -42 AT FWD WET AREA. LEVEL CORROSION NR 2. NEW FLOOR SUPPORT WAS REPLACED ON STA Y 180 AND FROM X-11 TO -42 PER SRM 51-30-02.SDR DALA2017121808645Rib · crackedCRACK ON RIB FORMER STA X05=408 AT FIXED LEADING EDGE INTERNAL STRUCTURE, LT WING. RIB FORMER STA X05=408 AT FIXED LEADING EDGE INTERNAL STRUCTURE , LT WING WAS REPAIRED PER SRM 57-06B FIG 23, SRM 51-30-2, SRM 51-30-5.SDR DALA2017121808644Cusp Web · corrodedCORROSION ON RT CUSP WEB STA Y= 479 BTW X=-56 TO X=-60 AT PAX CABIN. LEVEL CORROSION 2: CUSP WEB WAS REPAIRED PER SRM 53-05 FIG 131A-13.SDR DALA2017121808643Floor Support · corrodedSEVERAL CORROSION POINTS ON FLOOR SUPPORT X -44 FROM Y 161 TO 198 AT FWD WET AREA. LEVEL CORROSION NR 2. FLOOR SUPPORT WAS REPLACED ON X-44 FROM Y 161 TO 198 PER SRM 51-30-02.
Back to Mcdonnell Douglas MD-88