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 DALA2017041703101Door · looseLT FWD OVERWING EXIT DOOR NOT FLUSH WITH FUSELAGE AND LOOSE. ADJUSTED LT FWD OVERWING EXIT DOOR IAW AMM 52-21-00, OK FOR SERVICE.SDR DALA2017041703097Cusp Web · corrodedCORRODED REPAIR DOUBLER ON THE CUSP WEB RBL 54 - 60 BETWEEN BS 522 AND 541. THE REPAIR DOUBLER WAS REMOVED AND REPLACED IAW SRM 51-30-05, SRM 53-05, FIG 131A-13, SHEET 1, AND SRM 53-05 FIG. 131A-13, SHEET 1.SDR DALA2017041703096Door Frame · crackedRT OVERWING DOOR FRAME CRACKED. REPAIRED IAW SRM 53-05, PAR 42, FIG. 32.SDR DALA2017041703093Beam · crackedL1 DOOR BEAM CRACKED ON BOTH CORNERS. THE BEAM WAS REPAIRED IAW SRM 52-05, PAR 68, FIG 81-82.SDR DALA2017041703108Wire · damagedROW 11E EMERGENCY LIGHT INOPERATIVE. FOUND BROKEN WIRES AT THE CONECTOR. REPAIRED THE WIRES IAW ESPM 90-03.SDR DALA2017041703105Hinge · damagedFWD CARGO DOOR HAS LONGATED FWD HINGE HOLE. THE HINGE WAS REPAIRED IAW ER/A 10-524489-14.SDR DALA2017041703102Cable · frayedTAILCONE CABLE FRAYED. REPLACED THE CABLE IAW AMM 53-53-00.SDR DALA2017041703099Floor Support · out of limitsCORROSION ON FLOOR SUPPORT BS 1007, 1079, 1155 BETWEEN LONGERONS 28L - 28R. OUT OF LIMITS PER SRM 53-01 FIG 1 SHEET 3.SDR DALA2017041703098Floorbeam · corrodedCORROSION ON THE FLOORBEAM AT BS 1155 BTW LONG 28L AND 28R IN THE CARGO BAY. THE FLOORBEAM ANGLE WAS REPLACED IAW SRM 51-30-5, AND DWG 5956705, REV AY.SDR DALA2017041603091Floor Support · corrodedCORRODED FLOOR SUPPORT AFT WET AREA BETWEEN BS 1307 - 1338, RBL 18. THE FLOOR SUPPORT WAS REPLACED IAW SRM 51-30-1 AND DWG 9936656, REV AM.SDR DALA2017041603090Skin · crackedCRACK OF 0.195" LENGTH, WAS FOUND ON FUSELAGE SKIN AT BS 1403, LONGERON 2L. THE SKIN WAS REPAIRED IAW ERA 556329-14A0D, REV ORIG, AND ETI-88-17-088, REV 5.SDR DALA2017041603089Pan · crackedDOOR CRACKED ON UPPER FWD CORNER OF SEGMENT PAN AT FORWARD ENTRY DOOR. UPPER FWD CORNER OF SEGMENT PAN AT FWD ENTRY DOOR WAS REPAIRED IAW SRM 52-05, PAR 14, FIG 18A.SDR DALA2017041603088Vane · wornRIGHT WING WORN ON UPPER SURFACE SKIN AT THE OTBD FIXED GUIDE VANE INBD FLAP. REPAIRED THE GUIDE VANE IAW SRM 57-03 D, PAR 11.SDR DALA2017041703110Slide · low pressureL1 DOOR SLIDE BOTTLE PRESSURE LOW. REMOVED AND REPLACED THE SLIDE IAW AMDS 2561-4964.SDR DALA2017041703094Rub Strip · corrodedRIGHT WING HAS CORROSION ON THE RUBSTRIPS UPPER SURFACE. THE RUBSTRIPS WERE REPLACE IAW SRM 51-22-2A.SDR DALA2017041503085Floor Panel · corrodedEVIDENCE OF POSSIBLE CORROSION FWD GALLEY FLOOR. BS 163 AND RBL 7 COMPLIED WITH PRI 557511-14 REV 0, 1, AND 2. REPAIRED IAW ERA 557511-14, REV ORIG.SDR DALA2017041503084Longeron · crackedAFT ACCESSORY BAY HAS A CRACKED LONGERON 16R, BS 1429. THE LONGERON WAS REPLACED IAW SRM 51-30-5, AND 51-30-2.SDR DALA2017041503083Vane · delaminatedDELAMINATED INTERNAL DOUBLER ON THE OTBD FLAP INBD GUIDE VANE. THE GUIDE VANE WAS REPLACED IAW SRM 57-03D, PAR 11.SDR DALA2017041503082Support Fitting · corrodedCORROSION ON THE LT MLG SUPPORT FITTING BUSHING BORE. REPAIRED THE SUPPORT FITTING IAW ETI-88-17-170, REV 1, AND ERA 491033-14AD, REV A.SDR DALA2017041503079Floor Support · corrodedCORROSION FOUND ON THE FLOOR SUPPORT BETWEEN BS 237 TO 256, LBL 33. THE FLOOR SUPPORT WAS REPLACED IAW SRM 51-10-4, AND SRM 51-30-5.SDR DALA2017041503078Floor Panel · damagedCORROSION AND CRACKS FOUND ON THE FLOOR PANEL 160G. FLOOR PANEL WAS REPLACED IAW 51-10-2, AND DWG 9957828, REV Y.SDR DALA2017041903196Spar · crackedWING REAR SPAR CRACKED AT XRS 164, A DOUBLER REPAIR WAS ACCOMPLISHED.SDR DALA2017041703115Terminal Block · burnedRETURNED TO DEPARTURE DUE TO AN ACRID ODOR IN THE FLIGHT DECK REPORTED TO BE FROM THE F/O'S WINDSHIELD. MAINTENANCE FOUND TERMINAL BLOCK R5-38 AND THE F/O'S WINDSHIELD BURNED AT CONNECTION P WHICH IS THE GROUND SIDE FOR WINDOW ANTI-ICE. THE TERMINAL BLOCK, SDR DALA2017041403013Skin · crackedCRACKED PREVIOUS REPAIR DOUBLER ON FUSELAGE SKIN HOLD OPEN HOOK HOUSING OF L1 DOOR BS 120 - 133, LONG 14 - 16L. REPAIRED IAW ETI-88-17-105, REV 1, AND ERA 556364-14, REV ORIG.SDR DALA2017041403012Pin · wornFOUND PIN FOR TAILCONE RELEASE IN AFT ACCESSORY COMPARTMENT WORN. REMOVED AND REPLACED THE PIN IAW AMM 53-53-00.SDR DALA2017041403010Cusp Web · corrodedCORROSION ON CUSP WEB BETWEEN LBL 54 AND 60, BS 570 - 712. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG. 131A-14.SDR DALA2017041403009Cusp Web · puncturedLEFT CUSP WEB SURFACE PUNCTURED AT LBL 44 TO 54, BS 264. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, PAR 144, FIG 131A-13.SDR DALA2017041403008Skin · damagedRIGHT WING HAD NICKS ON LOWER SURFACE SKIN AT THE RT INBOARD VANE INBD FLAP. REPAIRED IAW SRM 57-03D, PAR 11, FIG 11.SDR DALA2017041302978Battery Pack · inoperativeCEILING EMERGENCY LIGHTS AT ROWS 23 THROUGH 25 INOPERATIVE. REPLACED THE BATTERY PACK B5104 IAW AMM 33-53. CHECKED GOOD.SDR DALA2017041703104Bracket · crackedFOUND CRACK IN LOUVER BRACKET AT STATION L5 OF BS 1463 CANTED FRAME. R & R LOUVER MOUNT BRACKET AT STATION L5 OF 1463 CANTED FRAME IAW MD88 SRM 53-14-4 FIG 4 AND BOEING DRAWING 9911839. (LP2977886)SDR DALA2017041302983Power Supply · malfunctionedDURING RAMP CHECK, COCKPIT OVERHEAD EMERGENCY LIGHT ON DIM WITH SWITCH ON OR OFF POSITION. REPLACED POWER SUPPLY IAW WDM 33-51-12.SDR DALA2017041302981Bearing · corrodedCORROSION ON BEARING OF RETRACT SUPPORT FITTING ON THE RT MLG. THE BEARING WAS REMOVE IAW CMM 20-10-7, WORKED IAW DWG SR09570087 REV. B. A NEW BEARING WAS INSTALLED IAW SOPM 20-10-7.SDR DALA2017041302980Structure · damagedRIGHT PYLON HAD ELONGATED APRON FITTING HOLES. REWORKED, BUSHINGS WERE FABRICATED AND REPLACED IAW CMM 71-10-10 ERA 228793-14 & 266727-14 PAGE D601.SDR DALA2017041302976Intercostal · crackedCRACKED LOWER INTERCOSTAL BS 937 - 941 AND RBL 60. THE INTERCOSTAL WAS REPAIRED IAW ER/A 556390-14, REV ORIGINAL, AND ETI-88-17-102, REV 3.SDR DALA2017041302975Floor Support · corrodedEXCESSIVE CORROSION ON FLOOR SUPPORT BS 160 - 200, LBL 54. THE FLOOR SUPPORT WAS REPLACED IAW SRM 51-10-4.SDR DALA2017041302974Tab · dentedHORIZONTAL STABILIZER DENTED ON THE LT & RT ANTI FLOAT TAB UPPER SURFACE. THE ANTI FLOAT TABS WERE REPAIRED IAW SRM 55-04 P. 3.SDR DALA2017041202972Skin · scratchedSCRATCHES ON WINDOW BELT AT FWD RH EMERGENCY EXIT DOOR. WINDOW BELT AT FWD RH EMERGENCY EXIT DOOR WAS REPAIRED IAW ETI-88-17-126, REV ORIG. AND ERA 556388-14 REV ORIG.SDR DALA2017041202971Pin · migratedWEAR DAMAGE DUE TO PIN MIGRATION ON THE I/B SIDE OF THE FUEL DOOR CUTOUT ON THE RT WING IN REF LOG 1319130. THE I/B SIDE OF THE FUEL DOOR CUTOUT ON THE RT WING WAS REPAIRED PER ETI-88-17-083 REV 2 AND ERA 523305-14 REV B SECTION III AND JOB 125 UNDER LOG 13191SDR DALA2017041202970Spacer · corrodedCORROSION ON PREVIOUS REPAIR SPACER AT LOWER MID CARGO COMPARTMENT DOOR JAMB. PREVIOUS REPAIR SPACER WAS REPLACED PER SRM 53-05 FIGURE 123A.SDR DALA2017041202969Longeron · crackedPAX CABIN, CRACK ON LONGERON NR 4 LT STA Y= 160 AT PASSENGER CABIN. LONGERON SECTION NR 4 LT BTW Y=150 TO Y= 170 WAS REPAIRED PER CARD AMDS 5330-01204-04, SR- 09530170 REV ORG AND SRM 53-02 FIG 18.SDR DALA2017041202968Longeron · crackedAFT ACCESSORY COMPARTMENT, CRACKED LONGERON 3R ON STA Y=1429. LONGERON WAS REPAIRED PER SRM 53-02 FIG 18.SDR DALA2017041102906Floor Support · corrodedCORROSION ON FLOOR SUPPORTS BTW STA Y=150-200 AND X=7, X=-7. FLOOR SUPPORTS WERE REPLACED PER SRM 51-30-1.SDR DALA2017041102926Cable · frayedTAILCONE CABLE FRAYED. REPLACED TAILCONE CABLE IAW AMM 20-10-01.SDR DALA2017041102907Fastener · brokenTAILCONE SLIDE COVER SNAP IS BROKEN. DISCONNECTED DEPLOY LANYARD, REMOVED AND REPLACED SNAP, RECONNECTED DEPLOY LANYARD, O.K. FOR SERVICE. REQUIRED INSPECTION COMPLETED.SDR DALA2017041102905Skin · crackedCRACK ON FUSELAGE SKIN STA 1022 BETWEEN LONGERONS 13/14L. REPAIRED PER ETI-17-17-038 REV 1 AND ER/A 556345-14.SDR DALA2017041102904Intercostal · crackedAFT ACCESSORY COMPARTMENT CRACKED INTERCOSTAL STA Y=1480 CANTED BULKHEAD APPROX IN LONG PROJECTION 19L. INTERCOSTAL WAS REPLACED PER SRM 51-30-2 AND 51-30-5 AND DWG 9911946 REV R.SDR DALA2017041102902Longeron · crackedCRACK ON LONG 2R BTW STA Y = 541 AT PAX CABIN. REPAIRED LONG 2 R BTW STA Y=520 TO Y=560 PER SRM 53-02 FIG 18 SHEET 1.SDR DALA2017041102901Rivet · looseTAILCONE UPPER LEFT LOCK BRACKET PULLING LOOSE FROM TAIL CONE. REMOVED LOOSE RIVETS AND INSTALLED NEW RIVETS PER MD88 SRM51-30-2.SDR DALA2017041002873Wire Harness · damagedSEAT MOUNTED EMERGENCY LIGHTS INOPERATIVE AT SEATS 13D AND 21D. REPLACED THE WIRE HARNESS, OPS CHECKED GOOD IAW AMM 33-53.SDR DALA2017041002874Filter · clogged.WHILE DESCENDING THROUGH 8,000 FEET, RECEIVED A RT ENGINE OIL STRAINER CLOG LIGHT. PERFORMED QRH, OPERATED RT ENGINE UNTIL LANDING. REPLACED THE ENGINE OIL FILTER IAW AMM 79-20. INSPECTION OF FILTER REVEALS CARBON. ODI PREVENTION PARA 3 STEPS A-F.
Back to Mcdonnell Douglas MD-88