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 DALA2016111008496Cusp Web · corrodedCORROSION ON RT CUSP WEB BETWEEN X -54 TO X -60 AT BS 598 - 617, 617 - 636, AND 636 - 655. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG. 131A-13.SDR DALA2016111008495Cusp Web · corrodedCORROSION ON RT CUSP WEB BETWEEN X -54 - 60 AND BS 984 - 1003. REPAIRED THE CUSP WEB IAW SRM 53-05 FIG 131A-3, 51-10-3 PAR 14, 21.SDR DALA2016111008494Access Panel · corrodedCORROSION ON LEFT WING ACCESS PANELS. THE ACCESS PANEL WAS REPLACED IAW SRM 51-22-2A.SDR DALA2015052803554Skin · crackedDURING NDT INSPECTION A DISCREPANT AREA WAS FOUND ON FUSELAGE SKIN AT BS FROM BS 1401 - 1429 BETWEEN LONGERONS 1 AND 3 RT. REPAIRED IAW ER/A 534369-14AD, REV ORIGINAL.SDR DALA2016111008493Cusp Web · corrodedCORROSION ON RT CUSP WEB BETWEEN X -54 TO X -60 AND BS 465 - 484. THE AREA WAS REPAIRED IAW SRM 53-05 FIG 131A-14, 51-30-01, AND 51-10-3 PARR 14-21.SDR DALA2016111008490Access Panel · corrodedCORROSION ON FUEL ACCESS PANEL 1409C. THE ACCESS PANEL WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016111008489Intercostal · corrodedCORROSION ON INTERCOSTAL BETWEEN BS 1136 AND 1155 AND LONGERON 29 AND 30R. INTERCOSTAL WAS REPLACED IAW SRM 51-30-2.SDR DALA2016111008488Skin · corrodedCORROSION ON EXTERNAL FUSELAGE SKIN BS 1098 - 1112 BETWEEN LONGERONS 27 - 29L. THE DAMAGED AREA WAS REPAIRED IAW SRM 53-04 FIG 57, 51-10-3 P. 21-14, 51-30-5.SDR DALA2015052803572Unknown · smokeFLIGHT RETURNED TO DEPARTURE AFTER SMOKE ACCUMULATED IN THE CABIN AND COCKPIT. THE AFT LAVATORY SMOKE DETECTOR ALSO SOUNDED BRIEFLY. MAINTENANCE REPLACED A LEAKING APU AND ACCOMPLISHED THE PNEUMATIC SYS DUCT BURN OUT PROCEDURES.SDR WX0A2015060172621Power Supply · inoperativeAFT FLIGHT ATTENDANT STATION OVERHEAD EMER LIGHTS & TAIL CONE LOWER LIGHT INOPERATIVE. BATTERIES CHECKED GOOD WITH EMER LIGHTS ON CHECK, POWER TO THE POWER SUPPLY TERMINALS, NO VOLTAGE NOTED. REPLACED POWER SUPPLY. OPERATIONS CHECKED GOOD IAW AMM 33-53-01.SDR DALA2015052703553Skin · crackedMAINTENANCE FOUND A VISIBLE CRACK ON THE LOWER SKIN OF THE CENTERWING BOX. THE CRACK IS LOCATED ON THE FORWARD EDGE OF THE AFT WING SKIN, AND AFT EDGE OF THE FORWARD WING SKIN. THE CRACK ALSO PROPAGATED THROUGH THE UNDERLYING STRINGER IN THE CENTER WING BOX. SDR DALA2016111008487Cusp Web · corrodedCORROSION ON RT CUSP WEB BS 1144, 1163 BETWEEN X -54 AND X -60. THE DAMAGE WAS REMOVED, A REPAIR WAS FABRICATED IAW SRM 53-05 FIG-131A-3. THE REPAIR WAS INSTALLED IAW SRM 51-30-5.SDR DALA2016111008486Seat Track · corrodedCORROSION ON LT SEAT TRACK X 54 BETWEEN BS 1060 TO 1064. THE SEAT TRACK WAS REPAIRED IAW SRM 53-05 FIG 4A.SDR DALA2016111008485Cusp Web · corrodedCORROSION ON RT CUSP WEB BS 1024 BETWEEN X -54 AND X -60. THE DAMAGE WAS REMOVE IAW SRM 53-05 FIG. 131A-8, A NEW DOUBLER WAS FABRICATED IAW SRM 53-05 FIG-131A-8. REPAIR WAS INSTALLED IAW SRM 51-30-5.SDR DALA2016111008484Finger Doubler · corrodedCORROSION ON FINGER DOUBLER FROM LONGERON 26L BTW BS 588-598, 607-617. FABRICATED, TREATED, AND PAINTED A NEW DOUBLER AND INSTALLED IAW SRM 51-30-2, 51-30-5, 53-04-3 FIG. 12 (SHEET 1) 51-10-3 PAR 14, 21.SDR DALA2016111008483Doubler · corrodedCORROSION ON DOUBLER REPAIR ON LT CUSP WEB BETWEEN X 54 AND X 60 BS 655 - 660, 834 - 845. REPAIR DOUBLERS WERE REMOVED IAW SRM 51-30-2 AND 51-30-5. THE DOUBLERS WERE FABRICATED IAW SRM 53-05 FIG. 131. THE DOUBLERS WERE TREATED, PAINTED, AND INSTALLED IAW SRSDR DALA2016111008482Web · corrodedCORROSION ON THE LT WEB UPPER AND LOWER SURFACE BETWEEN X 59 ADN X 60 BS 693 - 712. THE WEB WAS REPAIRED IAW SRM 53-05 FIG. 13A, 51-10-3, 51-30-2.SDR DALA2015052503493Longeron · crackedCRACKED LONGERON 4R AT BS 522. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2015052503492Longeron · crackedCRACKED LONGERON 4L AT BS 541. THE LONGERON WAS REPAIRED IAW SRM 53-02 FIG 18.SDR DALA2016111008481Cusp Web · corrodedCORROSION ON PREVIOUS REPAIR OF CUSP WEB AT BS 484 - 503 BETWEEN X -54 TO X -60. THE REPAIR WAS REPLACED IAW SRM 53-05 , 51-10-3, 51-30-2, AND 51-30-5.SDR DALA2016111008480Structure · corrodedCORROSION ON RUB STRIP SETTLEMENT AREA AT RT MLG OUTBOARD DOOR. THE DOOR WAS REMOVED IAW AMM 32-12-21 201. AREAS WAS BLENDED (UT) WAS ACCOMPLISHED, FOUND OUT OF LIMITS. THE DOOR WAS REPLACED IAW SRM 51-10-03, 52-01, AND NDT SPM 04-00-07.SDR DALA2016111008479Structure · corrodedCORROSION ON RUB STRIP SETTLEMENT AREA AT LT MLG OUTBOARD DOOR. FIXED DOOR WAS REMOVED IAW AMM 32-12-21-201. AREA WAS BLENDED, UT WAS ACCOMPLISHED,FOUND OUT OF LIMITS. REPLACED IAW SRM 51-10-03, 52-10, AND NDT SPM 04-00-07.SDR DALA2016111008478Cusp Web · corrodedCORROSION ON CUSP WEB BETWEEN BS 313 TO 332 AND X 54 TO X 60. REPAIRED IAW SRM 53-05 FIG 131-A-13.SDR DALA2016111008477Access Panel · corrodedCORROSION ON COUNTERSINK OF FUEL ACCESS PANEL 1361C AT LT WING. THE CORROSION WAS REMOVED AND FOUND OUT OF LIMITS IAW SRM 51-22-2A AND ACCESS DOOR WAS REPLACED.SDR DALA2016111008476Longeron Splice · corrodedCORROSION ON LONGERON SPLICE END 25R BETWEEN BS 1212 AND 1231. LONGERON SPLICE WAS REPLACED DUE TO EXCESIVE CORROSION IAW DWG 5936007 REV AR AND SRM 51-30-05.SDR DALA2015052303490Longeron · crackedCRACK ON LONGERON 6L BS 1307. LONGERON REPLACED IAW SRM 53-02, FIG 18, SHT 1.SDR DALA2016111008475Doubler · corrodedCORROSION ON RT CUSP WEB PREVIOUS REPAIR DOUBLER BS 807 - 845 BETWEEN X -54 AND X -60. REPAIR DOUBLER WAS REPLACED IAW SRM 53-05 FIG 131A-14 SRM 51-10-4 SRM 51-10-3 PAR. 14, 21, 38, SRM 51-30-2.SDR DALA2016111008474Cusp Web · corrodedCORROSION ON CUSP WEB BETWEEN BS 275 TO 294 AND X 54 TO X 60 BOTH SURFACE LT SIDE. AREA WAS REPAIRED IAW SRM 53-05 FIG. 131A-13 AND SRM 51-10-3 PAR. 14, 21 SRM 51-30-2.SDR DALA2016111008473Intercostal · corrodedCORROSION ON INTERCOSTAL BETWEEN BS 1136 AND 1155 LONGERON 29L. INTERCOSTAL WAS REPLACED IAW SRM 51-30-5.SDR DALA2016111008472Access Panel · corrodedCORROSION ON COUNTERSINK AREA OF RT WING FUEL ACCESS PANEL 1436C. THE ACCESS PANEL WAS REPLACED IAW SRM 51-22-2ASDR DALA2016111008471Cusp Web · corrodedCORROSION ON DOUBLER OF REPARATION ON CUSP WEB AND ANGLE BETWEEN BS 332 - 351 AND X 54 TO X 60 LT SIDE. DOUBLER WAS REPLACED IAW SRM 53-05 FIG. 131A.SDR DALA2016111008470Cusp Web · corrodedCABIN BS 1208 - 1249 LBL 60 CUSP WEB UPPER AND LWR SURFACES HAS AREAS OF CORROSION. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW ER/A 511165-14MA REV B. REPLACED THE CUSP WEB IAW SRM 51-30-01 AND SRM 51-30-02.SDR DALA2016111008469Seat Track · corrodedCORROSION ON THE RT SEAT TRACK BS 270 - 271 X -54. PLUG WAS REMOVED IAW SRM 51-30-1 AND 51-20-0. A NEW PLUG WAS INSTALLED IAW SRM 53-05 FIG 4A.SDR DALA2016111008468Cusp Web · corrodedCORROSION ON RT CUSP WEB AT BS 1103 - 1132 BETWEEN X -54 TO X -60. CUSP WEB WAS REPAIRED, TREATED, AND PAINTED IAW SRM 53-05 FIG 131A-14, 51-10-3 PAR 14 AND 21, 51-30-1, 51-30-2 AND 51-30-5.SDR DALA2016111008467Doubler · corrodedCORROSION REPAIR DOUBLER BS 1155 - 1174 RT SIDE BETWEEN X -54 TO X -60 IN THE PAX CABIN. THE REPAIR DOUBLER WAS REPLACED IAW SRM 51-30-1, 51-30-2, 51-30-5, 51-10-3 P. 21 AND 14, AND 53-05 FIG 131A.SDR DALA2015052103573Wire Harness · damagedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY PATHWAY LIGHTING AT SEAT 13DE IN THE CABIN WAS INOPERATIVE. MAINTENANCE REPLACED THE WIRE HARNESS AND FUNCTIONALLY CHECKED THE SYSTEM. LP 6731688.SDR DALA2015052103421Longeron · crackedCRACKED LONGERON 3L BS 1437 AFT ACCESSORIES COMPARTMENT. LONGERON REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2016111008466Cusp Web · corrodedCORROSION ON RT CUSP WEB BS 1196 - 1209, X -54 TO X -60 IN PAX CABIN. THE DAMAGE WAS REMOVED IAW SRM 53-05 FIG 131A-5. A REPAIR WAS FABRICATED IAW SRM 53-05 FIG 131A-5. THE REPAIR WAS TREATED AND PAINTED IAW SRM 51-10-3 PAR 14 AND 21. THE REPAIR WAS INSTALLSDR DALA2016111008465Cusp Web · corrodedCORROSION ON RT CUSP WEB BS 1023 - 1095 BETWEEN X -54TO X -60 IN PAX CABIN. THE CUSP WEB WAS REMOVED, A NEW CUSP WEB WAS DRILLED, TREATED, INSTALLED IAW SRM 51-10-3, 51-30-2, 51-30-5, 51-30-1, 51-10-4, AND 51-10-3 PAR 21, 14, AND 38.SDR DALA2015051903420Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THE AFT CATWALK OVERHEAD EMERGENCY LIGHTS TO BE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK AND THE OPS CHECK WAS GOOD.SDR DALA2016111008464Access Panel · corrodedCORROSION ON COUNTERSINK AREA OF RT WING FUEL ACCESS PANEL 1414C. THE CORROSION WAS REMOVED AND THE ACCESS PANEL WAS FOUND TO BE OUT LIMITS AND REPAIRED IAW SRM 51-22-2A.SDR DALA2015051903419Cam · looseDURING CHECK, MAINTENANCE FOUND THE TAILCONE RELEASE CAM LEVER LOOSE ON THE SPLINES. MAINTENANCE REPLACED THE CAM LEVER ASSEMBLY AND THE FUNCTIONAL TEST WAS SATISFACTORY.SDR DALA2015051803418Clevis · improper partDURING CHECK, MAINTENANCE FOUND IMPROPER SAFETY ON 3 CLEVISES ON THE TAILCONE RELEASE CABLE. MAINTENANCE RESAFETIED THE CLEVIS AND THE FUNCTIONAL TEST WAS SATISFACTORY. LP 1951354.SDR DALA2015051803417Receptacle · wornDURING CHECK, MAINTENANCE FOUND NUMEROUS ALIGNMENT PIN RECEPTICLES WORN. MAINTENANCE REPLACED THE ALIGNMENT PIN RECEPTICLES. LP 1952193.SDR DALA2015051803416Release Cable · out of adjustDURING CHECK, THE TAILCONE RELEASE CABLE FAILED GAP CLEARENCE DURING FUNCTIONAL TEST. THE TAILCONE RELEASE CABLE WAS ADJUSTED AND THE TEST WAS PERFORMED SATISFACTORILY. LP 1951349.SDR DALA2015051803415Retainer · weakDURING CHECK, MAINTENANCE FOUND THE EXTERIOR HANDLE RETAINING CLIPS TENSION WEAK FOR THE TAILCONE. MAINTENANCE REPLACED THE HANDLE RETAINING CLIPS.SDR DALA2015051803414Release Cable · damagedDURING CHECK, MAINTENANCE FOUND THE KEVLAR ROPE ON THE TAILCONE RELEASE SYSTEM TO BE DAMAGED. MAINTENANCE REPLACED THE KEVLAR ROPE ON THE TAILCONE RELEASE SYSTEM. LP 1952047.SDR DALA2015051803413Longeron · crackedCRACKED LONGERON 2L BS 1418 AT AFT ACCESSORIES COMPARTMENT. THE LONGERON WAS REMOVED AND A NEW LONGERON WAS FABRICATED, TREATED, PAINTED, AND INSTALLED IAW SRM 53-02, FIG 18, 51-10-3 PARA 21, 14 51-30-5.SDR DALA2015051903361Gasket · leakingF/A AND PASSENGERS EXPERIENCED HAZE AND SMOKE IN CABIN AFTER TAKEOFF. THE AFT LAVATORY SMOKE DETECTOR WAS SOUNDING DURING THE CLIMB THROUGH 7000 FT. THE CREW DECLARED AN EMERGENCY AND RETURNED. MAINTENANCE FOUND THE APU INLET CONTAMINATED WITH OIL. A LEAK ATSDR DALA2016111008463Floor Support · corrodedFLOOR SUPPORT CORRODED ON UPPER SURFACE BS 160 TO 195. REMOVE CORROSION. REPLACED THE FLOOR SUPPORT IAW SRM 51-20-0 AND 51-30-01.
Back to Mcdonnell Douglas MD-88