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 DALA2017041002872Battery Pack · inoperativeEMERGENCY LIGHTS IN CEILING FIRST CLASS SECTION INOPERATIVE. REPLACED THE BATTERY PACKS IAW AMM 33-53. OPS CHECKED GOOD.SDR DALA2017041002870Control Tube · corrodedCORROSION ON THE LT & RT ELEVATOR CONTROL TUBES.SDR DALA2017041002869Doubler · wornWORN FWD LOWER DOUBLER ON THE FWD CARGO DOOR. THE DOUBLER WAS REPLACED IAW ER/A 486624-14 MA, REV ORIGINAL.SDR DALA2017041002867Frame · crackedCRACKED FRAME BS 1510. REPAIRED THE FRAME IAW ER/A 497316-14MA, REV ORIGINAL.SDR DALA2017041002871Battery Pack · inoperativeOVERHEAD CABIN EMERGENCY LIGHTS INOPERATIVE FROM ROWS 1 TO 16. REMOVED AND REPLACED THE BATTERY PACKS IAW AMM 33-53. CHECKED GOOD.SDR DALA2017041002868Door Frame · damagedDURING NDT INSPECTION A DISCREPANT AREA WAS FOUND ON A DOUBLER REPAIR AT BS 194 TO 200 OF THE LOWER AFTER DOOR FRAME AT THE FWD SERVICE DOOR. REPAIRED IAW ER/A 333312-14, REV. B.SDR DALA2017040902864Doubler · corrodedCORRODED REPAIR DOUBLER ON CUSP WEB FROM RBL 54 TO 60 BETWEEN BS 712 AND 731. THE DOUBLER WAS REPLACED IAW SRM 53-05, FIG131A-10, 51-30-2, AND 51-30-5.SDR DALA2017040902863Angle · crackedCRACKED ANGLE ON UPPER CORNERS OF CHANNEL ON THE RT AFT OVERWING EXIT DOOR. THE ANGLES WERE REPLACED IAW DWG:9957735, REV G, SRM 51-30-2, AND 51-30-5.SDR DALA2017040902861Skin · crackedCRACKED RT LOWER ACCESS DOOR CUTOUT BETWEEN XRS 189 AND 214, STRINGERS 12 AND 15R. REPAIRED IAW ETI-88-17-098, REV ORIGINAL, AND ERA 556348-14AD, REV ORIGINAL.SDR DALA2017040902860Angle · crackedCRACKED ANGLE ON FWD LT EMERGENCY DOOR STOP NR 1. THE ANGLE WAS REPLACED IAW 51-30-5, 51-30-2, AND DWG 9957735 REV. G.SDR DALA2017040902859Beam · corrodedMID CARGO COMPARTMENT HAD CORROSION ON PREVIUS REPAIR SPACER BS 636 - 670 ON THE CARGO DOOR FRAME LOWER BEAM. THE DOOR FRAME LOWER BEAM WAS REPAIR IAW SRM 53-05, FIG 123.SDR DALA2017041002866Stiffener · crackedCRACK ON STIFFENER IN FWD LT NOSE COWL BULKHEAD NS 19.430 NEAR 6 O`CLOCK. THE STIFFENER WAS REPLACED IAW SRM 54-40-0, FIG 6, ITEM 12, SRM 51-30-8, AND ER/A 556386-14, REV ORIGINAL.SDR DALA2017040802858Angle · crackedAFT ACCESSORY COMPARTMENT HAD A CRACKED FRAME ANGLE BS 1380 BETWEEN LONGERONS 13 AND 14R. THE FRAME ANGLE WAS REPLACED IAW DWG 9912246, REV DE, SRM 51-30-5, AND 51-30-2. (LP2965334)SDR DALA2017040802857Frame · crackedAFT ACCESSORY COMPARTMENT HAD A CRACKED FRAME BS 1485, BELOW VENTRAL STAIRWAY ACTUATOR. THE FRAME WAS REPAIRED IAW SRM 53-03D, FIG 43, SHEET3.SDR DALA2017040802856Pan · crackedCRACKED AFT OUTER PAN BETWEEN BEAMS 1 AND 2, IN THE AFT CARGO DOOR. THE PAN WAS REPAIRED IAW SRM 52-05, FIG 26B, SHEET 2.SDR DALA2017040702855Connector · brokenEMERGENCY LIGHT INOPERATIVE AT SEAT 31 AB. REPLACED A BROKEN CONNECTOR IAW SWPM 20. OPS CHECKED GOOD.SDR DALA2017040702853Tire · failedAFTER TAKEOFF, AIRFRAME VIBRATION AND BURNING RUBBER ODOR FOLLOWED BY LEFT MAIN GEAR UNSAFE INDICATION WITH GEAR STILL EXTENDED. CHECKED LANDING GEAR VISUALLY AND NOW HAVE 3 GREEN DOWN AND LOCKED GEAR SAFE LIGHTS. FOUND THE NR 2 MAIN TIRE BLOWN AND RECAP SEPSDR DALA2017040702804Track · corrodedCORROSION ON TIE TRACK FROM STA Y=1007 TO Y=1220 LT SIDE. TIE TRACK FROM STA Y=1007 TO Y=1220 LT SIDE WAS INSTALLED PER SRM 51-30-2, SRM 51-30-5, SRM 51-30-1.SDR DALA2017040702803Cargo Track · corrodedAFT CARGO COMPARTMENT; CORROSION ON TIE TRACK AND FROM STA Y= 1212 TO Y=1309 RT SIDE. TIE TRACK AND FROM STA Y=1212 TO Y=1309 RT SIDE WAS REPLACED PER SRM 51-30-2, SRM 51-30-5, SRM 51-30-1.SDR DALA2017040702802Cargo Track · corrodedAFT CARGO COMPARTMENT; CORROSION ON TIE TRACK AND FROM STA Y=1007 TO Y=1155 RT SIDE. TIE TRACK AND FROM STA Y=1007 TO Y=1155 RT SIDE WAS REPLACED PER SRM 51-30-2, SRM 51-30-5, SRM 51-30-1.SDR DALA2017040702801Track · corrodedCORROSION ON TIE TRACK AND SPLICE FROM STA Y=1220 TO Y=1309 LT SIDE. TIE TRACK FROM STA Y=1220 TO Y=1309 LT SIDE WAS REPLACED PER SRM 51-30-2, SRM 51-30-5, SRM 51-30-1. TIE TRACK SPLICE WAS ACCOMPLISHED WITH NRC.SDR DALA2017040702800Floor Panel · puncturedPUNCTURE ON FLOOR PANELS 826E, 826B. 826E AND 826B WERE REPLACED PER AMM 53-20-01-201.SDR DALA2017040702799Door Frame · crackedPAX CABIN, CRACKED DOOR JAMB OF AFT LT OVERWING EMERGENCY EXIT (UPPER SURFACE). DOOR JAMB WAS REPAIRED PER SRM 53-05 PAR 42 FIG 32.SDR DALA2017040702798Skin · crackedCRACKED FUSELAGE SKIN BTW LONG 27R TO 28R BTW STA Y= 83.55 TO 110. CRACKED FUSELAGE SKIN BTW LONG 27R TO 28R BTW STA Y=83.55 TO 110. (FUS) WAS REPAIRED PER SG09530030 REV-, AND SRM 53-05 PAR 162, FIG 158.SDR DALA2017040702797Intercostal · corrodedCORROSION ON WALKING BRIDGE INTERCOSTALS. INTERCOSTALS WERE REPLACED PER DWG 9911993 REV CJ.SDR DALA2017040702796Skin · delaminatedHORIZONTAL STABILIZER, DELAMINATION ON LT ANTI-FLOAT TAB UPPER/LOWER SURFACE. ANTI-FLOAT TAB WAS REPAIRED PER SRM 55-04 P 3.SDR DALA2017040602773Lamp · inoperativeONE RED EMERGENCY LIGHT ON SEAT 24D INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-53. CHECKED GOOD.SDR DALA2017040602775Pan · crackedCRACK ON RING PAN LT SIDE, BS 826. THE RING PAN WAS REPAIRED IAW SRM 53-02, FIG 122, AND ER/A 487747-14MA, REV A, AND 493648-14MA, REV A.SDR DALA2017040602774Wire Harness · out of positionDURING VIS INSPECTION OF THE OVERHEAD WIRE BUNDLE, FOUND THE WIRE BUNDLE CHAFING AGAINST RELAY. ROUTED THE WIRE BUNDLE FOR CLEARANCE AND FOUND NO DAMAGED WIRES. ACFT OKAY FOR SERVICE.SDR DALA2017040602772Bulkhead · corrodedAFT ACCESSORY COMPARTMENT CORRODED ON FWD AND AFT BULKHEADS AT WALKING BRIDGE. FOUND OUT LIMITS. REPAIRED.SDR DALA2017040602771Skin · delaminatedLEFT WING TE FLAP HAD DELAMINATED SKIN, UPPER AND LOWER SURFACE AT THE OTBD FLAP MID GUIDE VANE. REPAIRED IAW SRM 57-03D, PARAGRAPH 11, FIGURE 11.SDR DALA2017040602770Access Panel · corrodedCORROSION ON COUNTERSINKS OF THE FUEL ACCESS PANEL NR 1307C ON THE LT WING. THE ACCCESS PANEL WAS REPLACED IAW SRM 51-22-2A.SDR DALA2017040602769Skin · dentedLEFT WING DENTED ON UPPER AND LOWER SURFACE ON THE INBD FLAP, INBD GUIDE VANE. TAP TEST INSPECTION WAS ACCOMPLISHED AND DISBONDED AREAS WERE FOUND AT THE DENTS. THE AREA WAS REPAIRED IAW SRM 57-03D, PARAGRAPH 11, FIGURE 11.SDR DALA2017040602768Vane · wornLEFT WING HAS A WORN OTBD EDGE SKIN ON THE INBD FLAP, INBD GUIDE VANE. THE GUIDE VANE WAS REPAIRED IAW SRM 57-03D, PARAGRAPH 11, FIGURE 11.SDR DALA2017040602767Frame · corrodedAFT CARGO BAY CORRODED ON PREVIOUS FRAME REPAIR BS 1309, LONGERON 29L IN THE AFT CARGO BAY. THE REPAIR WAS REPLACED IAW SRM 53-03D, FIG 2A.SDR DALA2017040602766Bulkhead · corrodedCORROSION ON FWD BULKHEAD AT WALKING BRIDGE. AREA OUT LIMITS AND WAS REPAIRED IAW SRM 53-01, FIG 4.SDR DALA2017040502752Connector · damagedLEFT INBOARD AND LEFT OUTBOARD ANTI-SKID AMBER MESSAGES INFLIGHT. CREW DECLARED EMERGENCY. FOUND CONNECTOR TO P1-1148 WITH PUSHED PINS. REPLACED THE CONNECTOR AND SYSTEM CHECKED GOOD.SDR DALA2017040502753Battery Pack · inoperativeFOUND OVERWING EXIT LIGHTS INOPERATIVE. REPLACED THE BATTERIES IAW AMM 33-53, LIGHTS CHECKED GOOD.SDR DALA2017040502751Pan · crackedCRACK ON AFT LOWER CORNER RING PAN LT SIDE BS 1098. REPAIRED IAW SRM 53-05, FIG 122.SDR DALA2017040502750Doubler · wornWORN FWD & AFT LOWER EXTERNAL PRODUCTION DOUBLERS AT AFT CARGO DOOR. AFT DOUBLER WAS REPLACED IAW SRM 51-30-2. THE FWD DOUBLER WAS BLENDED OUT IAW SRM 52-01, FIG 1, SHEET 3.SDR DALA2017040402722Door Frame · crackedFWD PASSENGER DOOR UPPER FWD CORNER PAN CRACKED. REMOVED AND INSTALLED NEW DOOR. LEAK CHECK GOOD PER MD88 AMM 52-10-00. (LP2959437)SDR DALA2017040302654Vane · dentedRIGHT WING DENTED ON PREVIOUS REPAIR DOUBLERON INBD GUIDE VANE. REPAIRED IAW SRM 57-03D, PARAGRAPH 11, AND 51-70-2D.SDR DALA2017040302664Vane · delaminatedDURING ZONE FINAL, FOUND AREA OF DELAMINATION ON THE LT FLAP VANE LOWER SURFACE. REMOVED AND REPLACED IAW AMM 27-51-03-201.SDR DALA2017040302663Skin · worn:WEAR LOWER INNER AND OUTER SKIN OF THE FWD CARGO DOOR. THE DAMAGE WAS REPAIRED IAW ERA 522785-14MA, REV ORIGINAL.SDR DALA2017040302658Vane · dentedRIGHT WING DENTED ON PREVIOUS REPAIR DOUBLER AT INBOARD FLAP, INBOARD GUIDE VANE. REPAIRED IAW SRM 57-03D, PARAGRAPH 11, AND 51-70-2D.SDR DALA2017040302653Longeron · crackedCRACKED LONGERON 11R BS 1380. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2017040302652Pan · crackedCRACK IN REPAIR OF RING PAN LT BETWEEN BS 984 TO 1003. REPAIRED IAW SRM 53-05 FIG.122.SDR DALA2017040302650Tee Fitting · damagedAFT PRESSURE BULKHEAD TEE SPLICE BETWEEN LONGERONS 26 AND 27R WITH ONLY 2 FASTENERS ON ONE SIDE. REPAIRED RIGHT APB TEE SPLICE IAW ERA 556897-14, REV 0.SDR DALA2017040302649Tee Fitting · damagedAFT PRESSURE BULKHEAD TEE SPLICE, BETWEEN LONGERONS 26 AND 27L WITH ONLY 2 FASTENERS ON ONE SIDE. REPAIRED IAW ERA 556897-14, REV 0.SDR DALA2017040202667Trim System · bindingAILERON TRIM WHEEL STUCK IN FLIGHT WITH AUTOPILOT ON OR OFF, IT WORKED PRIOR TO DEPARTURE. CHECKED ACTUATOR SCREW ROD END DIMENSION AND DRUM. AILERON TRIM RIG IS GOOD AND NO SIGNS OF BINDING NOTED. COMPLETED IAW AMM 27-10.
Back to Mcdonnell Douglas MD-88