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 DALA2017032302335Cusp Web · corrodedCORROSION ON LT LOWER AND UPPER CUSP WEB SURFACE STA Y= 863 TO Y=865 BTW X=44 TO X=60 AMDS 5300-2586. DAMAGE AREA WAS REPAIRED PER SRM 53-05 FIG 131A-1.SDR DALA2017032302334Floor Support · corrodedCORROSION ON FLOOR SUPPORT ANGLES STA Y=120 AND Y=148 AT X=-44. FLOOR SUPPORT STA Y=120 AND STA Y=148 AT X=-44 WAS REPLACED PER SRM 53-14-1 FIG.11 AND 51-10-8.SDR DALA2017032302333Pan · crackedCRACK ON RT LWR CORNER RING PAN STA Y =1117. RING PAN WAS REPAIRED PER SRM 53-05 FIG 122 AND ER/AS 493648-14MA REV A AND 487747-14MA REV A.SDR DALA2017032302332Tab · dentedHORIZONTAL STABILIZER, DENT 1EA ON LT CONTROL TAB NEAR STA XHS= 68. LT CONTROL TAB NEAR STA XHS= 68 WAS REPAIRED PER SRM 55-04 FIGURE 2.SDR DALA2017032302331Tab · damagedHORIZONTAL STABILIZER, PROTUBERANCE ON LT CONTROL TAB NEAR STA XHS= 86. LT CONTROL TAB NEAR STA XHS= 86 WAS REPAIRED PER SRM 55-04 PAR 3 CLASS A.SDR DALA2017032202318Connector · disconnectedEMERGENCY LIGHTS INOPERATIVE AT SEAT ROWS 24 - 27. TROUBLESHOT IAW WDM 33-51. FOUND CONNECTOR DISCONNECTED AFT OF SEAT ROW 27. LIGHTS OPS CHECKED GOOD. OK FOR SERVICE.SDR DALA2017032202317Door Frame · corrodedAFT CARGO BAY, CORROSION ON PREVIOUS REPAIR SPACER ON DOOR FRAME LOWER BEAM BS 1155 - 1212. THE REPAIR WAS REPLACED IAW SRM 53-05, FIG 123.SDR DALA2017032102262Cam · wornFOUND BASE OF THE TAILCONE RELEASE MECHANISM CAM WORN. REPLACED TAILCONE RELEASE MECHANISM CAM BASE IAW AMM 53-53-02.SDR DALA2017032002263Wire · sparksCAPTAIN`S CLEARVIEW WINDOW WIRES SPARKED ON TAXI IN. TERMINATED THE WIRES IAW SWPM 20-20. CHECKED GOOD.SDR DALA2017032002200Doubler · damagedBENT AND NICKED EXTERNAL DOUBLER ON BOTTOM AREA OF THE L1 DOOR. DOUBLER THE WAS REPLACED IAW SRM 52-05 FIG. 37 (SHEET 1).SDR DALA2017031902199Skin · crackedSKIN PANEL CRACKED BS 1041, 1022, 984, 946, AND BS 886. DAMAGED AREAS WERE REPAIRED IAW SRM 53-05 FIG. 122.SDR DALA2017031802197Floor Panel · crackedCRACK ON FLOORS PANEL. THE FLOOR PANEL WAS REPAIRED IAW SRM 53--05, PAR 145, FIG 131B, AND 131C.SDR DALA2017031802196Beam · crackedL1 DOOR CRACKED BEYOND STOP DRILL ON PREVIOUS REPAIR BEAM 1. THE BEAM FWD EDGE WAS REPAIRED IAW SRM 52-05 FIG. 98 (SHEET 3).SDR DALA2017031702180Indicator · missingRIGHT HYDRAULIC SYSTEM PRESSURE/QUANTITY LOSS REQUIRED USE OF ALTERNATE GEAR EXTEND PER QRH. MAINTENANCE FOUND THE RIGHT ENGINE DRIVEN HYDRAULIC PUMP PRESSURE SIDE FILTER MODULE DIFFERENTIAL PRESSURE INDICATOR (DPI) MISSING. RETAINING SCREWS SHEARED FROM MODULSDR DALA2017031702124Vane · wornRIGHT AFT FLAP INBD VANE HAS A WORN UPPER SURFACE AT REPAIR. REPLACED THE VANE.SDR DALA2017031702123Sleeve · tornTORN AUXILLARY HYD PUMP WIRING SLEEVE. SLEEVE WAS RAPAIRED PER MD88 SWPM 20-10-01 AND ER/A 467688-14MAAD. (LP2933936)SDR DALA2017031702122Spar · damagedDURING NDT INSPECTION, A DISCREPANT AREA WAS FOUND SEVEN DIFFERENT FASTENERS OF PSE ON LOWER SKIN BETWEEN XRS 163 TO 168 REAR SPAR AT RT WING.SDR DALA2017031702120Beam · crackedL1 DOOR. CRACK ON BEAM 1 , AFT EDGE AT MAIN ENTRANCE DOOR. BEAM 1 , AFT EDGE WAS REPAIRED IAW SRM 52-05, FIG 81, SHEET 3.SDR DALA2017031602119Angle · crackedFOUND LOWER ANGLE CRACKED AT BS 942.225 ON LOUVER FWD FRAME. REPLACED THE ANGLE.SDR DALA2017031602118Bracket · brokenFOUND BROKEN BRACKET ON RT CANTED FRAME, AFT SIDE. LOCATED AT THE OTBD END OF STIFFENER LONGERON 7R, BS 942.225. REPLACED THE BRACKET.SDR DALA2017031602117Wire · brokenSEAT 29 DE, SEAT MOUNTED EMERGENCY LIGHT INOPERATIVE. FOUND A WIRE BROKEN AT CONTACT PIN IN CONNECTOR AT SEAT FRAME. TERMINATED THE WIRE IAW SWPM 20-90-03. CHECKED GOOD.SDR DALA2017031302109Wire · chafedAFTER ARRIVAL AT THE GATE, WITH ONLY THE APU POWERING THE AIRCRAFT, SPARKS AND FLASHING LIGHTS WERE REPORTED IN THE FIRST CLASS OVERHEAD CEILING AREA. THE PASSENGER OXYGEN MASKS DEPLOYED AND SMOKE WAS DETECTED IN THE FLIGHT DECK. SEVERAL FLIGHT DECK CIRCUIT BRSDR DALA2017031602112Wire · damagedFOUND WIRES DAMAGED - WDM 21-31. REPAIRED THE WIRES IAW WDM. TESTED IAW WDM 21031, 33-23, & 33-38. ALL TESTED NORMAL.SDR DALA2017031602111Wire · damagedFOUND A WIRES DAMAGED . REPAIRED THE WIRES IAW WDM 33-24, 52-73, 25-41, 35-24, AND 33-21. TESTED SYSTEMS IAW WDM. ALL TESTED GOOD.SDR DALA2017031602110Frame · crackedFOUND A CRACK ON THE FRAME WEB, FWD SIDE. LOCATED 4 FASTENERS BELOW LONGERON 7L, BS 942.225. REPAIRED IAW SRM 53-03D FIG. 38D.SDR DALA2017031602113Wire · damagedFOUND WIRES DAMAGED IAW WDM 33-22. REPAIRED THE WIRES IAW WDM 33-22.SDR DALA2017031502060Wire · damagedTRANSFORMER TRAY ASSEMBLY IN CEILING NEXT TO FWD LAV DOOR HAS SIGNS OF ARCHING CAUSED BY WIRE DAMAGE PASSING OVER IT. REPAIRED IAW RI 556663-14.SDR DALA2017031402014Battery Pack · inoperativeFOUND LEFT AND RIGHTT BS 875 OVERWING FWD EMERGENCY EXIT LIGHTS OUT. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-53. OPS CHECKED NORMAL.SDR DALA2017032102261Skin · crackedLOWER AFT TAIL CONE HAS A 6.5 INCH CRACK. REMOVED AND REPLACED TAILCONE IAW CARD 5350-0177-0101.SDR DALA2017031402061Flap System · out of rigDURING ROTATION, THE AIRCRAFT ROLLED HARD TO THE LEFT. 2.5 UNITS OF AILERON TRIM WERE REQUIRED FOR LEVEL FLIGHT. MAINTENANCE FOUND THE FLAPS OUT OF RIG AT SETTING 11. THE FLAP BUSS CABLE ADJUSTMENT WAS PERFORMED AND THE AIRCRAFT WAS RETURNED TO SERVICE.SDR DALA2017031402015Jackscrew · wornWEAR CHECK FAILED STEP 50. READS .045. REPLACED THE HORIZONTAL JACKSCREW ASSY IAW WC 2742-4540. ALSO PERFORMED WORKCARD 2740-01113-08 WEAR CHECKED GOOD.SDR DALA2017031402013Connector · looseEMERGENCY LIGHTS 26D AND 28D INOPERATIVE. SECURED LOOSE CONNECTORS AT 26 AND 28D. CHECKED GOOD.SDR DALA2017031402012Angle · crackedEMERGENCY EXIT DOOR HAS A CRACK ON ANGLE THAT ATTACH THE BEAM WITH THE INNER PAN . THE ANGLE WAS REPLACED IAW SRM 51-30-2 AND 51-30-5.SDR DALA2017031302016Smoke Detector · false activationTHE RED AFT CARGO BIN FIRE LIGHT ILLUMINATED BRIEFLY, EXTINGUISHED FOR ABOUT 30 SECONDS, AND THEN CAME BACK ON AND STAYED ON. MAINTENANCE INSPECTED THE AFT CARGO BIN AND FOUND NO EVIDENCE OF SMOKE OR FIRE. MAINTENANCE DID FIND LUGGAGE WEDGED AGAINST SMOKE DETESDR DALA2017031301971Wire · shortedOVERHEAD EMERGENCY LIGHTS AT THE L1 DOOR ARE INOPERATIVE. FOUND WIRE L767A22 CONNECTED TO GROUND OF NR 4 BULB AT FWD ATT WORK LIGHT, ENTRY LIGHT PANEL L2-155. FOUND THE NR 2 BULB GROUND JUMPED AC GROUND. RECONFIGURED IAW WDM, REMOVED JUMPER. SYSTEM OPS CHECKESDR DALA2017031402066Brake Sys · malfunctionedDURING THE LANDING ROLL, THE CREW REPORTED THE BRAKES FELT LIKE THEY WERE CYCLING AND THE AIRCRAFT WAS NOT SLOWING DOWN. MAINTENANCE BLED THE BRAKES IAW AMM 32-42 AND RETURNED THE AIRCRAFT TO SERVICE.SDR DALA2017031301972Battery Pack · inoperativeFWD EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK. OPS CHECKED OK IAW AMM 33-51.SDR DALA2017031301969Light · inoperativeSEAT 29 EMERGENCY LIGHT INOPERATIVE. REPLACED EMERGENCY LIGHT ASSEMBLY.SDR DALA2017031201967Structure · damagedOUT OF LIMITS DRAIN HOLE IN LOWER TEE AFT FLANGE BS 1338. REPAIRED IAW ER/A 555650-14, REV ORIGINAL & ETI-88-17-082, REV. 2.SDR DALA2017031301968Battery Pack · inoperativeROW 25 OVERWING EXIT LIGHTS INOPERATIVE. BOTH SIDES. REPLACED THE BATTERY PACKS IAW AMM 33-53. TESTED GOOD.SDR DALA2017031101966Spar · crackedVERTICAL STABILIZER SPAR LEADING EDGE CRACKED. COMPLIED WITH ERA 556177-14AD, REV ORIG, AND PRIS 556177-14AD, REV 0-8.SDR DALA2017031101965Spar Cap · crackedRIGHT HORIZONTAL STAB FRONT SPAR CAP HAD CRACK INDICATIONS, REPAIRED IAW ERA 556177-14 AD REV ORIG.SDR DALA2017031001926Frame · crackedAFT ACCESSORY BAY, CRACKED FRAME BS 1451, LONGERON 3L - 3R. REPAIRED IAW ETI-88-17-080, REVISION 4, AND ER/A 555642-14, REV ORIGINAL.SDR DALA2017030901905Light · damagedSEAT 11 D EMERGENCY EXIT LIGHT DAMAGED. REPLACED EMERGENCY PATH LIGHT ASSY SEAT 11D.SDR DALA2017031402017Panel · crackedA 12 INCH CRACK IN RT WING FIXED T/E PANEL. REMOVED DAMAGE , INSTALLED A REPAIR IAW SRM 51-90-0.SDR DALA2017030901906Spring · failedDURING TAKEOFF ROLL AND AFTER ROTATION, THE CAPTAIN'S SEAT ROLLED BACK TO THE FULL AFT POSITION. REPLACED LOCK RETURN SPRING.SDR DALA2017030901904Light · malfunctionedAFT EMERGENCY LIGHTS ILLUMINATED WITH POWER REMOVED FROM ACFT. PERFORMED EMERGENCY LIGHT CHECK IAW AMM 33-53. RECYCLED ARM SWITCH WITH POWER OFF, OPS CHECKED GOOD.SDR DALA2017030801880Connector · not seatedEMERGENCY LIGHT INOPERATIVE IN CEILING SECOND AFT OF AFT CABIN DOOR. RESEATED THE CONNECTOR. OPS CHECKED SATISFACTORY.SDR DALA2017030801879Connector · not seatedEMERGENCY LIGHT INOPERATIVE BY EMERGENCY SLIDE IN TAIL. RESEATED THE CONNECTOR, OPS CHECKED SATISFACTORY.SDR DALA2017030801878Socket · damagedEMERGENCY LIGHT INOPERATIVE IN CEILING JUST AFT OF AFT CABIN DOOR. FOUND THE SOCKET DAMAGED. REPAIRED THE SOCKET. LIGHT OPS NORMAL. 6)
Back to Mcdonnell Douglas MD-88