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 DALA2015110306665Lanyard · damagedMAINTENANCE DISCOVERED THAT THE EMERGENCY ESCAPE SLIDE AT DOOR 1R HAD A NON-SERVICEABLE LANYARD. THIS COULD PREVENT PROPER DEPLOYMENT OF THE ESCAPE SLIDE AND IS NOT IN COMPLIANCE WITH 14 CFR PART 121.703. THE DOOR SLIDE GIRT BAR LANYARD WAS REPLACED.SDR DALA2015110306655Girt Bar · malfunctionedTHE CREW DISCOVERED THAT THE GIRT BAR FOR THE EMERGENCY ESCAPE SLIDE AT DOOR 1L WOULD NOT REMAIN IN THE ARMED POSITION. THIS WOULD PREVENT PROPER DEPLOYMENT OF THE ESCAPE SLIDE AND IS NOT IN COMPLIANCE WITH 14 CFR PART 121.703. THE GIRT BAR WAS REINSTALLED BSDR DALA2015110306654Light · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTING AT SEAT 19D IN THE CABIN WAS INOPERATIVE. MAINTENANCE REPLACED THE LIGHT ASSEMBLY AND PERFORMED A SATISFACTORY FUNCTIONAL CHECK OF IT.SDR DALA2015110506738Longeron · crackedCRACKED LONG 3L AT BS 1437, A/A, SM, CARD 20, ZONE 61. CRACKED LONG 3L AT BS 1437 WAS REPLACED AND REPAIRED IAW SRM 53-02, FIG 18 AND 51-10-3, PAR 21, 14. LENGTH CRACK: 0.180. RII COMPLETED.SDR DALA2015110306653Floorbeam · damagedELONGATED HOLES ON FLOORBEAM BS 636 BETWEEN LONGERONS 28R - 28L. REPLACED IAW SRM 53-24-0 AND 51-10-4.SDR DALA2015110306651Shear Tie · crackedCRACKED LOWER TEE CAP BS 1437, LONGERON 2R AND 2L AT AFT ACCESSORY COMPARTMENT. A/A, SM, CARD 63, ZONE 61. CAP WAS REPAIRED IAW 53-01, FIG. 2, LENGTH CRACKS: 3.625", 1.625", 4", 3.062".SDR DALA2015110306650Frame · damagedELONGATED HOLES ON FRAME BS 1485. HOLES WERE DRILLED TO NEXT SIZE IAW 51-10-4, DUE TO EXCESSIVE DAMAGE WAS ATTENDED IAW SRM 53-01, FIG 2, SRM 51-10-3 PAR 21, 14 AND 51-30-2.SDR DALA2015110306649Pan · crackedCRACK ON AFT UPPER CORNER RING PAN BS 1098. UPPER CORNER RING PAN WAS REPAIRED IAW SRM 53-05, FIG 122, AND ER/A 487747-14MA, REV A AND 493648-14MA, REV A.SDR DALA2015110306648Cusp Web · crackedTHREE INCH CRACK ON CUSP WEB BS 218-237, RT SIDE UNDER SEAT TRACK CABIN. W1, CUSP WEB BS Y=218-237 WAS REPLACED IAW SRM 51-30-2 AND DWG 9930538, REV CF.SDR DALA2015110206636Cusp Web · crackedCRACK ON LT CUSP WEB BS 943. REPAIRED IAW SRM 53-05, FIG 131A-13.SDR DALA2015110206635Floor Panel · corrodedCORROSION ON FLOOR PANEL 16DG. FLOOR PANEL WAS FABRICATED, TREATED, PAINTED, DRILLED AND ADJUSTED IAW SRM 51-10-3, PAR 14, 21, 26 DWG 9957828, REV AB.SDR DALA2015111106872Door Frame · crackedCRACK AND ELONGATED HOLE AT LOWER LT CORNER OF FS 1338 VENTRAL DOOR LOWER JAMB. AREA WAS REPAIRED IAW SRM 53-05, FIG 34. MAINTENANCE REQUIREMENTS: PERFORM REPETITIVE VISUAL INSPECTION OF BLIND FASTENERS EVERY 8000 CYCLES.SDR DALA2015110806803Tab · dentedDENT ON ELEVATOR CONTROL TAB SKIN, PN 5910413-508, S/N 49626. ELEVATOR CONTROL TAB PN 5910413, SN 49626 WAS REPAIRED IAW SRM 55-04 P2 AND AC 0986, CARD 2000-8149-07.SDR DALA2015110406706Shear Tie · crackedCRACKED FRAME CLIP BS 1437 BETWEEN LONGERON 1 TO 2 RT AT AFT ACC COMPARTMENT. FRAME CLIPS BS 1437 BETWEEN LONGERON 1 TO 2 LT AND RT AFT ACCESSORY WERE REPLACED IAW SRM 51-30-5, 51-10-3 PAR 14-21, AND DWG 9911840, REV. DC.SDR DALA2015110206637Doubler · unsecureGAPPING BETWEEN FUSELAGE SKIN AND INTERNAL DOUBLER EXISTING REPAIR, BS Y=180-200 BETWEEN LONGERONS 26-27RT. REMOVE FINGER DOUBLERS, NEW FINGER DOUBLER WERE FABRICATED WERE TREATED AND PAINTED IAW SRM 51-30-2, 51-10-3, PAR 14 AND 21 AND 53-04, FIG 128.SDR DALA2015110206634Floor Panel · delaminatedDELAMINATED FLOOR PANEL. FLOOR PANEL REPLACED IAW AMM 53-20-01-201.SDR DALA2015110206633Floor Panel · crackedCRACK ON FLOOR PANEL IS BS 168, X -25. DAMAGE AREA WAS REMOVED, REPAIR PARTS WERE FABRICATED AND TREATED, PAINTED AND INSTALLED IAW SRM 51-70-4, FIG 2 AND 51-10-3, PAGE 14 / 21.SDR DALA2015110206632Floor Panel · delaminatedDELAMINATED FLOOR PANEL BETWEEN BS 1003 TO 1338. FLOOR PANEL REPLACED IAW AMM 53-20-01-201.SDR DALA2015110206631Door Frame · corrodedCORROSION ON LOWER DOOR FRAME BETWEEN BS 1155 - 1212. REPAIR DOUBLER, SPACER WAS REPLACED IAW SRM 53-05, FIG 123, 51-30-2 AND 51-30-5.SDR DALA2015110106629Battery Pack · inoperativeMAINTENANCE FOUND CABIN EMERGENCY LIGHT INOPERATIVE. THE OVERWING BATTERY PACK RELAY R2-271 AND BATTERY PACK B5-49 WAS REPLACED.SDR DALA2015110106625Cusp Web · corrodedCORROSION ON COUNTERSINK OF FUEL TANK ACCESS PANEL 1460C ON THE RT WING. ACCESS PANEL WAS REPLACED.SDR DALA2015110106624Cusp Web · corrodedCORROSION ON LT CUSP WEB BS 714, X 60. REPAIRED IAW SRM 51-10-3, PAR 14, 21, 26, 38, 51-30-2 AND 53-05 FIG 131A-13 E.SDR DALA2015110106623Cusp Web · corrodedCORROSION ON LT CUSP WEB BS 734 X 54 - 60. REPAIRED IAW SRM 53-05, FIG 131A-13, 51-10-3 PAR 14, 21, 26, 38, AND 51-30-2 E.SDR DALA2015110206639Wire · brokenDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTING AT SEAT 26D IN THE CABIN WAS INOPERATIVE DUE TO A BROKEN WIRE. MAINTENANCE FOUND A LOOSE WIRE IN THE CONNECTOR, RE-INSTALLED THE WIRE INTO THE CONNECTOR, AND THE SYSTEM RETURNED TO NORMAL OPERATSDR WX0A2015110272982Hydraulic Line · damagedFLIGHT ATTENDANTS REPORTED SMOKE IN CABIN AFTER TAKEOFF. CBS J8, J9 & J10 ALL POPPED. 18 DURING TROUBLESHOOTING OF ODOR & SMOKE FOUND APU OIL FILTER LEAKING. R & R APU OIL FILTER O RING. LEAK CHECKED GOOD IAW MM 49-90-06. DURING TROUBLESHOOTING FOUND HYD SDR DALA2015110106627Intercostal · crackedCRACK FOUND ON INTERCOSTAL BELOW 6 PULLEY BRACKET BS 1357, X= -18, Z=0, AT RT LAVATORY FLOOR STRUCTURE. INTERCOSTAL WAS REMOVED IAW SRM 51-30-2 , 51-30-5. CRACKS WERE STOPPED IAW SRM 53-01, FIG 2. HFEC INSPECTION WAS ACCOMPLISHED AROUND STOP DRILLS, 4 EAS.SDR DALA2015110106621Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF ACCESS PANEL 1466C ON RT WING. THE ACCESS PANEL WAS REPLACED IAW SRM 51-22-2A.SDR DALA2015110106620Cusp Web · corrodedCORROSION ON LT CUSP WEB BS 667, X 60. REPAIRED IAW SRM 53-05, PAR 144, FIG 131A-13.SDR DALA2015110106619Shear Tie · corrodedINITIAL WEAR AND CORROSION ON FRAME TEE BS 1380 BETWEEN LONGERONS 28L - 28R. FRAME TEE WAS REPLACED IAW SRM 51-30-2 AND 51-30-5 AND DWG 9912246115, REV DE.SDR DALA2015110106618Longeron · crackedCRACK ON LONGERON 6L BS 1309 AT PASSENGER CABIN. DAMAGE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18. LENGTH CRACK .125 , AND SRM 51-10-3, PAR 14.21.38, AMM 20-30-01. (LP2204125)SDR DALA2015110906820Support Fitting · corrodedCORROSION AND WEAR AT RT BEARING OF MLG RETRACT ACTUATOR SUPPORT FITTING. RT BEARING OF MLG RETRACT ACTUATOR SUPPORT FITTING WAS REPLACED IAW CMM 20-10-7, PAR D1-A.SDR DALA2015110406719Door · crackedDURING RUB STRIPS REMOVAL, A CRACKED PAN ON RT MLG FWD UPPER EDGE, BS 940. RT MLG DOOR WAS REPLACED FOR A REPAIRED DOOR.SDR DALA2015103006638Hydraulic System · leakingDURING CLIMB BOTH AFT LAVATORY SMOKE DETECTORS ALERTED AND F/A REPORTED SMELLING AND SEEING SMOKE. AFTER 1 MINUTE THE SMOKE DETECTORS SILENCED AND THE SMOKE DISSIPATED. CREW ELECTED TO RETURN TO DEPARTURE. MAINTENANCE FOUND HYDRAULIC FLUID DRIPPING FROM DRASDR DALA2015110106630Connector · disconnectedEMERGENCY LIGHT FOUND INOPERATIVE. CONNECTOR WAS FOUND DISCONNECTED. RECONNECTED, CHECKED OK.SDR DALA2015110106628Frame · crackedCRACKED FRAME BEHIND DOOR STOP FITTING NR 2 AT AFT EDGE OF C1 DOOR. REPAIR WAS ACCOMPLISHED IAW ETI-88-15-352, REV 3 AND ERA 539874-14, REV ORIGINAL.SDR DALA2015103106617Door Frame · crackedCRACK ON FWD ACCESSORY DOOR JAMB BS Y=63 AT 7 O`CLOCK POSITION. DAMAGE ON FWD DOOR JAMB WAS REPAIRED IAW SRM 53-01, FIGURE 2, SHEET 3.SDR DALA2015103106616Floor Support · crackedCRACKED CHANNEL ON FLOOR PANEL 1079A AT CABIN PAX. CHANNEL WAS REPAIRED IAW SRM 51-70-1D P. 10.SDR WX0A2015110272974Battery · dischargedEMERGENCY LIGHTS INOPERATIVE AT ROWS 15 & 16. REPLACED BATTERIES. OPERATIONS CHECKED GOOD IAW AMM 33-53-00.SDR DALA2015110106626Duct · crackedCRACKED RADIO RACK COOLING EXHAUST DUCT AT FUSELAGE SKIN. RADIO RACK EXHAUST DUCT WAS REPAIRED IAW ER/A 464964-14MA, REV C.SDR DALA2015103006611Line · damagedDURING DESCENT INBD, LEAVING FL240 FOR FL190 WITH ENGINE ANTI-ICE ON, THE CREW RECEIVED FLICKERING FLOW LIGHT ON OVERHEAD CABIN PRESSURIZATION CONTROL PANEL. FLOW LIGHT THEN ILLUMINATED STEADY WITH CABIN ALTITUDE CLIMBING AT 1500 FT./MIN. CREW DECLARED AN EMSDR DALA2015103006603Vane · wornWEAR ON T/E XV2=297, INBD EDGE, ON OTBD VANE OF OTBD FLAP AT RT WING. REPAIRED IAW ER/A 492663-14MA REV, ORIGINAL.SDR DALA2015103006602Vane · wornWEAR ON T/E IN XV1=211, OTBD EDGE, ON INBD VANE OF OTBD FLAP AT RT WING. RW, SH-CP-SM, CARD 120, ZONE 10. T/E IN BS XV1=211 WAS REPAIRED IAW ER/A 492663-14MA, REV ORIGINAL.SDR DALA2015103006601Longeron · crackedCRACKED LONGERON 17L BS 256. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2015103006600Cusp Web · corrodedCORROSION ON RT CUSP WEB MEMBRANE FROM BS 503 - 589 UPPER AND LOWER SURFACE BETWEEN X -54 TO X -60. THE CUSP WEB WAS REPLACED IAW SRM 51-30-1, 51-30-2, 51-30-5, 53-05, FIG 131A-24, 51-10-3 PARA 14/21.SDR DALA2015103006599Longeron · crackedCRACKED LONGERON END 2R, BS 1418. LONGERON END REPLACED IAW SRM 51-30-5 AND 53-14-4, 53-02, FIG.18.SDR DALA2015103006597Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF ACCESS PANEL 1371C ON RT WING. THE ACCESS PANEL WAS REPLACED IAW AMM 28-00-00.SDR DALA2015103006596Beam · corrodedCORROSION ON LOWER BEAM UNDER PREVIOUS REPAIR DOUBLER BETWEEN BS 1154 - 1174. THE BEAM WAS REPAIRED IAW ER/A NR 539872-14, REV ORIGINAL.SDR DALA2015102906577Cusp Web · damagedDURING CUSP WEB INSPECTION WAS FOUND OUT OF LIMITS AREAS BS 1025 - 1093 ON LT CUSP WEB BETWEEN X 54 AND X 60. DAMAGE REMOVED, A REPAIR FABRICATED, TREATED, PAINTED AND INSTALLED IAW SRM 51-30-2, 53-05 FIG 131A-17, 51-10-3 PAR 21,14, 38, 51-30-5, 53-05 FIG 131SDR DALA2015102906576Beam · crackedCRACK FOUND ON BEAM 4 OF R1 DOOR. THE BEAM WAS REPLACED IAW SRM 51-30-1, 51-30-2, 51-10-3 PAR 14/21, 51-10-4.SDR DALA2015102906575Pan · crackedCRACKED PAN FWD EDGE JUST BELOW OF LOWER HINGE ON R1 DOOR. REPAIR WAS ACCOMPLISHED IAW SRM 52-03D, FIG 3.
Back to Mcdonnell Douglas MD-88