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 DALA2016060604359Cusp Web · damagedCORROSION ON UPPER AND LOWER RT CUSP WEB FROM BS 660 TO 673 X - 56 -60 AT CPAX. DAMAGE WAS REPAIRED IAW SRM 53-05, FIGURE 131A-5 AND APPLIED CIC IAW SRM 51-10-3, PAR. 38. AND 51-30-2, 51-30-8.SDR DALA2016060604356Access Panel · corrodedCORROSION ON COUNTERSINK ON FUEL ACCESS PLATE NR 1363C. ACCESS PLATE 1363C WAS REPLACED.SDR DALA2016060604355Cusp Web · puncturedPUNCTURE ON LT CUSP WEB BS 1203 X 54. REPAIRED IAW SRM 51-01, PAR. 24, 51-10-3, PAR. 14 AND 21, 51-30-5.SDR DALA2016060604354Cusp Web · corrodedCORROSION ON UPPER /LOWER RT CUSP WEB FROM BS 1189 TO 1181 X 56. REPAIRED IAW SRM 53-05, FIG 131A-5, SHEET 1.SDR DALA2016060604353Cusp Web · corrodedCORROSION ON UPPER /LOWER RT CUSP WEB FROM BS 640 TO 653 X- 56 -60. REPAIRED IAW SRM 53-05 FIG. 131, 51-10-3 PAR. 14, 21 AND 38, 51-30-2, 51,-30-5.SDR DALA2016060604352Cusp Web · corrodedCORROSION ON UPPER RT CUSP WEB FROM BS 696 TO 672, X - 57. REPAIRED IAW SRM 53-05, FIG 131A-5 AND 131A-13, SRM 51-10-3 PAR. 14, 21 AND 38, AND SRM 51-30-2, 51-30-8.SDR DALA2016060604351Cusp Web · corrodedCRACK ON RT CUSP WEB BS 1016 X- 58 AT CPAX. CUSP WEB REPAIRED IAW SRM 53-05, FIG 131A.SDR DALA2016060604361Latch · wornUPPER LEFT TAIL CONE ATTACH LATCH LOCK IS WORN. R & R AND ADJUSTED LATCH IAW AMM 53-53-00.SDR DALA2016060504350Cusp Web · corrodedCORROSION ON UPPER, LOWER RT CUSP WEB FROM BS 503 TO 520 X - 57 . CUSP WEB REPLACED IAW SRM 51-10-3, PAR 14.21, SRM 51-10-4, SRM 51-30-2, SRM 51-30-5, SRM 51-30-1.SDR DALA2016060504348Longeron · crackedCRACK ON LONGERON 12 LT AND BS 1437 IN AFT ACCESSORY COMPARTMENT. LONGERON WAS REPLACED IAW DWG 5911433-85 AND DRILLED AND ADJUSTED I.A.W DC-9/MD-80 SRM 51-10-4 AND NEW SECTION LONGERON WAS INSTALLED IAW SRM 51-30-2 AND 51-30-5.SDR DALA2016060404358Skin · damagedLIGHTNING STRIKE ON FUSELAGE SKIN BETWEEN LONGERONS 2 AND 3 LT BS 838. LIGHTNING STRIKE ON FUSELAGE SKIN BETWEEN LONGS 2-3LT, STA Y=838 WAS REPAIRED BY PLUG IAW SRM 53-04-2 PAR 3C, 2, A,1, A.SDR DALA2016060504347Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCES DOOR NR 1466C. ACCESS PLATE WAS REPLACED.SDR DALA2016060404345Skin · damagedLIGHTNING STRIKE ON FASTENERS AT UPPER FUSELAGE BETWEEN LONGERONS 4 AND 3 LT BS 276. LIGHTNING STRIKE ON FUSELAGE SKIN ON BS Y=276 BETWEEN LONGERONS 4-3 LT WAS REPAIRED BY PLUG IAW SRM 53-04-1, PAR 3C, 2, A, 1, A.SDR DALA2016060404344Pan · crackedCRACKED RT WINDOW RING PAN FORWARD LOWER CORNER AT BS 1060. RING PAN WAS REPAIRED IAW SRM 53-05, FIG 122, REF ER/A 493648-14MA, REV A.SDR DALA2016060404343Channel · crackedCRACKED AFT DOOR JAMB CHANNEL BS 941 AND X=7 AT LT WHEEL WELL AREA. CHANNEL WAS REPLACED IAW SRM 51-30-2, 51-30-5 AND DWG 5930584, REV.SDR DALA2016060704411Buckle · brokenTAILCONE STRAP BUCKLE BROKEN. REINSTALLED BLIND THREADED SELF LOCKING INSERT.SDR DALA2016060204357Coalescer Bag · unknownDURING DESCENT FROM FL350 TO FL240 THE "FLOW" LIGHT ILLUMINATED WITH THE CABIN ALTITUDE RISING RAPIDLY THROUGH 9,000 FT. DURING EMERGENCY DESCENT CABIN PRESSURE, AUTO 1 INOPERATIVE, AUTO 2 INOPERATIVE AND AUTO INOPERATIVE ILLUMINATED. THE RT PACK PRESSURE WASSDR DALA2016060304334Oxygen Mask · unwanted deployCABIN OXYGEN MASKS DEPLOYED. REPLACED OXYGEN CANISTER IN ROWS 10ABC TO ROWS 18ABC LT SIDE. INSTALLED OXYGEN MASK IN ROW 10ABC TO ROW 18ABC IAW MM 35-21-01. R & R OXYGEN CANISTER IN ROW 10 DE TO ROW 19DE RT SIDEPANEL. INSTALLED OXYGEN MASK IN ROWS 10 DE TO ROWSDR DALA2016060304333Cabin Pressure · malfunctionedDURING DESCENT FROM FL350 TO FL240, FLOW LIGHT ILLUMINATED WITH CABIN ALT RISING RAPIDLY THROUGH 9000'. DURING EMERGENCY DESCENT AUTO INOPERATIVE. INOP 1, INOP 2 LIGHTS ILLUMINATED AND RT AC PACK PRESSURE NOTED LOW. CABIN ALT ROSE TO 16,000' AND PASSENGER OSDR DALA2016060304331Bolt · damagedDAMAGED THREADS ON RT HORIZONTAL STABILIZER ATTACH POINT NR 3 EYE BOLT. RIGHT HORIZONTAL STABILIZER ATTACH POINT NR 3 EYEBOLT WAS REPLACED IAW CMM 27-30-2.SDR DALA2016060304330Light · inoperativeSEAT 23E EMERGENCY AISLE SEAT LIGHT INOPERATIVE. R & R SEAT 23E EMERGENCY AISLE SEAT LIGHT ASSY IAW AMM 33-53.SDR DALA2016060304329Pan · crackedCRACKED ON RING PAN LT SIDE ON LOWER FWD CORNER OF WINDOW 91, BS 1079. CRACK OF .135" ON RING PAN WAS REPAIRED IAW SRM 53-05, FIG 122.SDR DALA2016060304328Pan · crackedCRACKED ON RING PAN LT SIDE ON FWD LOWER CORNER AT WINDOW 55, BS 731. CRACK OF .165" ON RING PAN WAS REPAIRED IAW SRM 53-05, FIG 122.SDR DALA2016060304327Wire · pulledFOUND EMERGENCY LIGHTS INOPERATIVE FROM 1C TO 12D. FOUND WIRES PULLED FROM CONNECTOR AT BOTTOM OF SEAT LEG 1D. REPAIRED WIRES IAW SWPM 20-10-03. NO HELP. R & R FIRST CLASS BATTERY CHARGER IAW AMM 33-53. OPS CHECK NORMAL. OK FOR SERVICE.SDR DALA2016060304326Pan · crackedCRACKED ON RING PAN RT SIDE ON UPPER FWD CORNER OF WINDOW 76, BS 927. RING PAN WAS REPAIR IAW SRM 53-05, FIG 122.SDR DALA2016060304325Pan · crackedCRACKED ON RING PAN RT SIDE ON UPPER FWD CORNER OF WINDOW 62 BS 788. RING PAN WAS REPAIR IAW SRM 53-05, FIG 122.SDR DALA2016060304332Drive Assy · corrodedCORROSION ON SPLINES AT RUDDER DRIVE CRANK. RUDDER TORQUE TUBE CRANK WAS REPLACED IAW AMM 27-20-03.SDR DALA2016060304324Floor Panel · corrodedCORROSION ON FLOOR PANEL 160G. FLOOR PANEL WAS FABRICATED IAW DWG 9957828.SDR DALA2016060204323Wire · misinstalledDURING SERVICE CHECK FOUND ROW 24-30 EMERGENCY LIGHTS IN THE AISLE INOPERATIVE. R & R POWER SUPPLY 55-107 IAW MM 33-53-00. NO HELP. REPLACED FUSE FOR POWER SUPPLY B5-212. NO HELP. INSPECTED WIRING FOUND DISCONNECTED WIRE THAT WAS NOT SEATED CORRECTLY IN THE SDR DALA2016060204322Pan · crackedRIGHT AFT OVERWING EXIT DOOR PAN CRACKED AT FWD UPPER DOOR STOP. R & R DOOR IAW AMM 52-21-00. LEAK CHECKED GOOD.SDR DALA2016060204283Bearing · frozenCORROSION ON SPLINES AND FROZEN BEARING AT RUDDER DRIVE TORQUE TUBE. RUDDER DRIVE TORQUE TUBE WAS REPLACED IAW AMM 27-20-03.SDR DALA2016060204281Floor Panel · damagedBROKEN COCKPIT FLOOR BEHIND CENTER CONSOLE. FLOOR PANEL 120C WAS FABRICATED IAW AMM 53-20-01-201.SDR DALA2016060204280Floor Panel · delaminatedDELAMINATED FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20 01-201.SDR DALA2016060204279Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINK ON FUEL ACCESS PLATE NR 1303C. ACCESS PLATE WAS REPLACED.SDR DALA2016060204278Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINK ON FUEL ACCESS PLATE NR 1409C. ACCESS WAS REPLACED.SDR DALA2016060204276Threshold · corrodedCORROSION ON AFT CARGO DOOR THRESHOLD LOWER AFT CORNER. REPLACED SUPPORT IAW SRM 51-30-05 AND DWG 5936469.SDR DALA2016062304878Skin · delaminatedDELAMINATION ON LOWER SKIN AT LT WING OTBD FLAP MID GUIDE VANE. CUT NEW WAS DONE AND DAMAGE WAS FOUND ON INTERNAL STRUCTURE THEREFORE IT IS OUT LIMITS IAW SRM 51-70-2D, PAR 6A AND SRM 57-03D, PAR 11. MID VANE WAS REPLACED.SDR DALA2016060204282Bushing · scratchedSCRATCH ON RT ELEVATOR ATTACH POINT BUSHING NR 2 001-0236:2730-4586/001 S/N: 01214. RIGHT ELEVATOR ATTACH POINT BUSHING NR 2 WAS REPLACED IAW CMM 27-30-2 AND DWG NR 5918028 ID:3, REV:M.SDR DALA2016060104269Tail Cone · out of rigVAULT DOOR FORCE REQUIRED TO DROP TAIL CONE EXCEEDED 20 LBS TENSION. ADJUSTED TAIL CONE RIG IAW AMM 53-53-00 AND AMDS 5350-01077-0101.SDR DALA2016060104268Channel · crackedCRACK ON CHANNEL AT FLOOR PANEL NR 256A LT. FLOOR PANEL WAS REPAIRED IAW SRM 53-05, PAR.145, 53-05, FIG 131C, 51-30-2, 51-10-3 PAR 14 AND 21.SDR DALA2016060104267Skin · crackedA/C SKIN HAS .3750" LONG CRACK EXTENDING INBD FROM FASTENER HOLE AT BS 1418, 1.5" OTBD OF L2R. ACCOMPLISHED SEC I IAW ERA 547264-14AD. SEC II MONITOR AMOC REQUIRED BY 25 MAY 17. ESTABLISHED ON LOG PAGE 2505537.SDR DALA2016060104266Floor Support · crackedCRACK ON CHANNEL AT FLOOR PANEL 313A. CRACK WAS REPAIRED IAW SRM 53-05, FIG 131C, 51-10-3 PAR 14 AND 21, 51-30-2.SDR DALA2016060104265Skin · corrodedPOPPED RIVET AND PILLOWING SKIN CORROSION ON BELLY AT BS 217 STR 30. COMPLETED SEC I IAW ERA 546984-14, REV O. SECTION II MONITOR TO BE ACCOMPLISHED AT 8000 CYCLE INTERVALS ESTABLISHED ON LOG PAGE 2509314.SDR DALA2016060204277Cusp Web · corrodedCORROSION ON UPPER /LOWER RT CUSP WEB FROM BS 451 - 459. X - 57. DAMAGE WAS REPAIRED IAW SRM 53-05, FIG 131A-14, 51-10-3 PAR 14 AND 21, 51-30-2.SDR DALA2016060104270Sleeve · disconnectedDURING TAXI OUT, ABOUT 2 MIN AFTER RT ENGINE START AND DURING T/O WARNING, CHECK RT ENGINE AUTO CANCELED TO MAX POWER AND WOULD NOT RESPOND TO THROTTLE MOVEMENT. EGT C664 HAD TO SHUTDOWN WITH FUEL LEVER. FOUND PUSH/PULL THROTTLE CABLE OUTER SLEEVE DISCONNECTESDR DALA2016053104223Wire Harness · damagedSEAT 17 DE EMERGENCY LIGHT INOPERATIVE. REPLACED HARNESS IAW AMM 33-53. CHECKS GOOD.SDR DALA2016053104189Turbine · failedRETURNED TO DEPARTURE DUE TO A RT ENGINE TURBINE FAILURE DURING CLIMB AT AT 800-1000 FT. RT ENGINE WAS SHUTDOWN IFSD. CREW NOTED MAXIMUM EGT 800DEG. MAINTENANCE FOUND TURBINE DAMAGE AND AN ENGINE CHANGE WAS REQUIRED. ENGINE WAS REPLACED AND SUBSEQUENT CHECSDR DALA2016053104222Pan · crackedCRACK ON RT WINDOW RING PAN AFT LOWER CORNER AT BS 1041. REPAIR PARTS WERE INTALLED IAW SRM 51-30-2, 51-30-5 AND ERA 493648-14MA, REV. A.SDR DALA2016053004221Power Supply · inoperativeDURING SERVICE CHECK FOUND NUMEROUS EMERGENCY LIGHTS INOPERATIVE THROUGH CABIN & TAIL AREA. REPLACED POWER SUPPLY BATTERIES AND LAMP IAW WDM 33-51-13. OPS CHECKED GOOD. OK FOR SERVICE.SDR DALA2016053004220Fastener · damagedRIVET HEAD POPPED AT BS 226 AND LONGERON 20-R. REMOVED STRINGER SPLICE AND DAMAGED STRINGER SECTION AT 20R, STA 226, ITEM C/W ON LOG NR 2509285.
Back to Mcdonnell Douglas MD-88