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 DALA2016010300011Skin · damagedLIGHTNING STRIKE ON EXTERNAL FUSELAGE SKIN BS 955 BETWEEN LONGERONS 1 - 2 RT. SKIN WAS REPAIRED. FASTENER WAS REPLACED IAW SRM 53-04-1 PARR 6C2 CONDITION 2. DAMAGE ON SKIN WAS REPARED IAW SRM 53-04-1 PARR 5C CONDITION 1.SDR DALA2016010100010Skin · damagedTHREE LIGHTINING STRIKE DAMAGE LOWER FORWARD FUSELAGE JUST AFT OF ELECTRONIC EQUIPMENT COMPARTMENT ACCESS. 1, 7" AFT OF ELECTRONIC EQUIPMENT CUTOUT AT S29R, 2, 9.5 " AFT OF E/E CUTOUT 3" RT OF S30 AT FASTENER. 3, 11" AFT OF ELECTRONIC EQUIPMENT CUTOUT 3" RT SDR DALA2016010100009Stop Fitting · crackedCRACKED NR 5 STOP FITTING FWD SECTION AT CARGO DOOR. DAMAGE STOP FITTING WAS REPLACED IAW SRM 51-30-1 AND 51-30-5.SDR DALA2016012500565Guide Vane · corrodedCORROSION ON OTBD GUIDE VANE OF OTBD FLAP RT LOWER MID SECTION. NEW VANE WAS INSTALLED IAW AMM 27-51-03.SDR DALA2016011800418Guide Vane · corrodedCORROSION ON LT INBD GUIDE VANE OF OTBD FLAP, 3 BETWEEN BS XV1 181 AROUND MID ACCESS HINGE. LT INBD GUIDE VANE OF OTBD FLAP, 3 WAS REPLACED IAW AMM 27-51-03-201.SDR DALA2016010100017Engine · malfunctionedFAS IN AFT CABIN REPORTED POPS FROM LT ENGINE AT TAKEOFF POWER. REPLACED NR 1 ENGINE IAW 88-7110-9-0010.SDR DALA2016010300013Skin · wornWEAR ON LOWER/ FWD DOUBLER EXTERNAL SKIN AT C1 DOOR. DAMAGE DOUBLER WAS REPLACED IAW ER/A 486624-14MA, REV ORIGINAL.SDR DALA2015123107774Structure · corrodedAFT LAV SERVICE DOOR CORRODED.SDR DALA2015123107773Frame · crackedTAILCONE FRAME CRACKED AT RT UPPER LATCH FITTING. REPLACED TAIL CONE ASSY., INSTALLATION & OPS CHECKS GOOD, AMDS CARD 2561-4001.SDR DALA2015123107772Support Fitting · shearedMAINTENANCE FOUND TAILCONE UPPER LATCH SUPPORT FITTING SHEARED OFF. THE TAILCONE WAS REPLACED.SDR DALA2015123107771Battery Pack · inoperativeMAINTENANCE FOUND THE EMERGENCY SIGNS INOPERATIVE IN FIRST CLASS. THE BATTERIES WERE REPLACED. THE EMERGENCY LIGHTS CHECKED OK.SDR DALA2015123107770Fuse · failedMAINTENANCE FOUND EMERGENCY LIGHTING INOPERATIVE AFT OF SEAT ROW 35. THE BATTERY PACK FUSE WAS REPLACED AT ROW 35. LIGHTS CHECKED OK.SDR DALA2015123107769Wire Harness · failedMAINTENANCE FOUND SEAT 10D EMERGENCY LIGHTING INOPERATIVE 30DEC. REPLACED THE HARNESS. CHECKED OK.SDR DALA2016010400016Pan · crackedCRACKED PAN ON RT FWD OVERWING EMERGENCY EXIT DOOR AT STOP FITTING NR 2. CRACKED PAN ON RT FWD OVERWING EMERGENCY EXIT DOOR AT STOP FITTING NR 2 WAS REPAIRED IAW SRM 52-05D, FIG 51.SDR DALA2016010300014Angle · crackedCRACKED ANGLE ON RT AFT OVERWING EMERGENCY EXIT DOOR. THE ANGLE REPLACED IAW SRM 51-30-02.SDR DALA2015123007757Hub · damagedNR 1 AND NR 2 ENGINE N1'S WENT TO 103 PERCENT FOR 7 SECS. DURING LOW ALTITUDE GO AROUND. REPLACED NR 2 ENGINE HUB IAW SPC 03-7201-9-0016. REPLACED NR 1 ENGINE HUB IAW SPC 03-7201-9-0016.SDR DALA2015123007756Structure · crackedFORWARD L1 DOOR HAS A FOUR INCH CRACK VERIFIED BY EDDY CURRENT IN UPPER FWD CORNER. IAW MMB C-CHECK EMPOWER NR 213, L1 DOOR REPLACED.SDR DALA2015123007755Seat Track · corrodedCORROSION ON PLUG AT RT SEAT TRACK X= -54 BETWEEN BS 1155 - 1161. PLUG WAS REPLACED IAW SRM 53-05, FIG 4A.SDR DALA2016012200531Skin · dentedSEVERAL DENTS ON EXTERNAL SKIN FROM BS 1194 -1212 BETWEEN BEAM NR 5 AT C3 DOOR. AFT CARGO DOOR WAS REPLACED DUE TO EXCESSIVE DAMAGE.SDR DALA1524180907Fuse · inoperativeEMERGENCY SEAT ROW LIGHTING INOPERATIVE ROW 31 AND AFT RT SIDE. REPLACED FUSE ON BATTERY PACK.SDR DALA2015122907746Door · crackedLT MLG DOOR HAS A TWO INCH CRACK AT INBD FWD CORNER. REMOVED AND INSTALLED SERVICEABLE DOOR IAW AMM 32-12-01.SDR DALA2015122807741Inlet · crackedDURING SEVERE TURBULANCE INSPECTION, FOUND APPROXIMATELY 6" CRACK AT AIR INLET LT SIDE AT BASE OF VERTICAL. WELDED APU AIR INLET IAW ERA 382101-14MA. ACCOMPLISHED FPI OF WELDED AERA IAW PS 900-6-3, NR 2.SDR DALA2015122807742Pin · pulledMAINTENANCE FOUND THE L1 DOOR SLIDE PINS PULLED OUT. THE L1 DOOR SLIDE WAS REPLACED.SDR DALA2015122807740Skin · crackedVERTICAL STABILIZER L/E, SKIN CRACKED AT EXISTING REPAIR, LONGERON 2R, BS 1418. CRACK PASSES THROUGH HI-LOC HOLE. REPAIR OF SKIN REPAIRED ON NR 167. L2R LONGERON REPAIRED BY SPLICE METHOD WITH SHIMMING TO ACCOMODATE SKIN REPAIR IAW SRM 53-02, FIG 18.SDR DALA2015122807739Skin · crackedVERTICAL STABILIZER L/E, SKIN CRACKED AT BS 1418, LONGERON 3R. NR 167, SKIN CRACK AT BS 1418 AND LONGERON 3R REPAIRED BY TRIMOUT, DOUBLER INSTALLATION AND LONGERON SPLICE WITH SHIMS. ALL WORK ACCOMPLISHED AND RECORDED ON PRI 542150-14AD, REV 0 THRU REV 03 SDR DALA2015122807743Lap Joint · corrodedREMOVED MID CARGO BIN PANEL FOUND CORROSION AT LAP SPLICE BS 588, STR 26L. DAMAGE CONFINED TO FINGER DOUBLER ONLY. CW REPAIR INSTRUCTIONS 542580-14.SDR DALA2015122607723Power Supply · malfunctionedCREW FOUND EMERGENCY OVERWING LIGHTS INOPERATIVE. MAINTENACE REPLACED THE BATTERY POWER SUPPLY BASE. LIGHTS CHECKED OK.SDR DALA2016112110213Skin · crackedFUSELAGE SKIN STA 1418 BETWEEN L2R AND 3R CRACK. REPAIRED PER ERA 542150-14AD.SDR DALA2015122607722Skin · damagedON LIGHTNING STRIKE INSPECTION, FOUND SKIN DAMAGE AT BS 256 JUST BELOW STRINGER 27R. C/W PERMANENT REPAIR IAW SRM 53-04-2.SDR DALA2015122607721Radome · damagedAT 10,000 ACFT TOOK LIGHTNING STRIKE, SUSPECT RT SIDE RADOME. REPAIRED MULTIPLE LIGHTNING STRIKES RT SIDE FUSELAGE BS 36 THRU BS 408 IAW SRM 53-04.SDR DALA2015122607720Skin · damagedRT WING INBD FORE FLAP LOWER SURFACE HAS NUMEROUS DENTS FROM MLG DEBRIS. R & R RT INBD FORE FLAP IAW AMM 27-51-01.SDR DALA2015122407711Scoop · crackedVERTICAL STABILIZER L/E, INLET SCOOP CRACKED TOP CENTER, NEXT TO WELD. WELDED IAW SRM 55-05.SDR DALA2015122407710Scoop · crackedVERTICAL STABILIZER L/E, INLET SCOOP CRACKED TOP CENTER, NEXT TO WELD. WELDED IAW SRM 55-05.SDR DALA2015122307706Longeron · crackedTAIL COMPARTMENT, LONGERON 2L CRACKED AT BS 1418. INSTALLED NEW LONGERON SECTION AND REPAIR SPLICE IAW SRM 53-02, FIG 18.SDR DALA2015122307705Skin · crackedRT HORIZONTAL STABILIZER UPPER RT AFT SKIN PANEL SHOWS A CRACK INDICATION IAW NDTSPM 06-10-02.005 AND AMDS, AA 5510-01074-11. VERIFIED CRACK INDICATION IAW NDTSPM 06-00-07. INDICATION MEASURES APPROXIMATELY .5". ACCOMPLISHED SECTION 1 OF ERA 542476-14AD, REV SDR DALA2015122207691Lamp · inoperativeDURING LINE CHECK, NOTED EMERGENCY LIGHTS IN AFT EQUIPMENT BAY WERE INOPERATIVE. REPLACED THE LAMP IAW AMM 33-53 AND OPS CHECKED GOOD.SDR DALA2015122207688Tee Fitting · corrodedAFT PRESSURE BULKHEAD LOWER TEE CHORD AT L26 AND L27, LT AND RT SIDES, SRM SPLICE REPAIR. COMPLIED WITH ERA/PRI 542247-14, REV 2 DATED 18DEC15 AT 0930E, PRI AND ERA MATCH.SDR DALA2015122107684Skin · corrodedAFT LAVATORY SERVICE PANEL HAS CORROSION, SKIN AROUND PERIMETER IS BULGED AND CRACKED. COMPLIED WITH ERA, PRI REV 1 DATED 10DEC15 AT 1550E, PRI MATCHES FINAL ERA 542209-14, REV ORIG.SDR DALA2015122007681Spar Cap · damagedPREVIOUS TOOL DAMAGE ON NEW RT HORIZONTAL STABILIZER REAR SPAR UPPER CAP XHS=115. REAR SPAR UPPER CAP WAS REPAIRED IAW ER/A 541579-14AD, REV ORIGINAL ETI-88-15-435, REV 2.SDR DALA2015122107683Pan · crackedCRACKED OUTER PAN BETWEEN BEAM 1 AND 2 FWD EDGE AT AFT CARGO COMPARTMENT DOOR. OUTER PAN BETWEEN BEAM 1 AND 2 FWD EDGE AT AFT CARGO COMPARTMENT DOOR, C3 WAS REPAIRED IAW ERA 541561-14, REV ORIG PERMANENT REPAIR.SDR DALA2015122007682Skin · damagedSEVERAL GOUGES ON FIXED L/E BETWEEN BS XIS=83 AND XIS=73 AT RT WING. FIXED L/E BETWEEN BS XIS=83 AND XIS=73 AT RT WING WAS REPAIRED IAW ER/A 541584-14, REV ORIGINAL AND SLAT TRACK NR 3 WAS REMOVE/INSTALL IAW AMM 27-80-01; AFTER BLEND OUT, ORIGINAL THICKNESS SDR DALA2015121807665Heater · failedACFT HAD SLIGHT ODOR, HAZE IN CABIN AND COCKPIT. FLIGHT CREW NOTED 1 PHASE OF CARGO HEAT C/B POPPED. PULLED REMAINING C/BS AND ALL DISSIPATED. MAINTENANCE FOUND THE FORWARD CARGO HEAT INTERNAL ELEMENT FAILED AND REPLACED THE FORWARD CARGO HEATER. MAINTENANSDR DALA2015121707654Wire · damagedMEM MAINTENANCE FOUND LT FORWARD EMERGENCY OVERWING SIGN INOPERATIVE. A DAMAGED WIRE WAS FOUND AT THE EMERGENCY EXIT ROW AND WAS REPAIRED. LIGHT CHECKED OK.SDR DALA2017121208526Spar Cap · damagedMD88 - STABILIZERS / H.S. / RH REAR SPAR UPPER CAP, XHS 115 / TOOLING DAMAGE. DTA MONITOR INSPECTION LOG REFERENCE ER/A 541579-14AD SECTION II REQUIRES DTA APPROVAL WITHIN 24 MONTHS AFTER SECTION I. ER/A 541579-14AD REV A IS CURRENT. DTA RESTRICTION REMOVED, SDR DALA2015121707657Pan · crackedCRACKED INNER PAN BS 370 . INNER PAN WAS REPAIRED IAW ER/A 541559-14, REV ORIG.SDR DALA2015121707656Hinge · damagedELONGATED HOLES ON FWD/AFT HINGE AT MID CARGO COMPARTMENT DOOR. FWD/AFT HINGES AT MID CARGO COMPARTMENT DOOR WERE REPLACED THEREFORE HINGES ARE OUT OF LIMITS IAW MD-88 52-31- 02 AND ER/A 497387-14MA, REV B. ADJUST AND TEST WILL BE ACCOMPLISHED WITH CARD 5200SDR DALA2015121707653Floor Panel · delaminatedDELAMINATED AND DAMAGED FLOOR PANEL BS 1231 - 1338 . THE FLOOR PANEL WAS FABRICATED IAW AMM 53-20-01-201.SDR DALA2015121707652Support Fitting · corrodedCORROSION ON LT RETRACT ACTUATOR SUPPORT FITTING BORE. REPAIRED IAW DWG SR09570087, REV B.SDR DALA2015121707651Support Fitting · corrodedCORROSION ON RT MLG RETRACT ACTUATOR SUPPORT FITTING BUSHING VERTICAL FACE AND BORE. REPAIRED IAW DWG SR09570087, REV B.SDR WX0A2015121800046Oil System · leakingAFTER TAKEOFF. LAVATORY SMOKE ANNUNCIATOR ILLUMINATED FOR FWD LAVATORY DURING QRH CHECKLIST, ANNUNCIATOR EXTINGUISHED. IN COCKPIT ODOR OF EVAPORATING OIL NOTED. TROUBLESHOOTING ACCOMPLISHED ON LP 610870 & 610871, LT ENG REPLACED IAW WO 279553. ENG RUNS ACCO
Back to Mcdonnell Douglas MD-88