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 DALA2017090306589Floor Panel · puncturedPUNCTURED FLOOR PANEL 1307B. THE FLOOR PANEL WAS REPAIRED IAW AMM 53-20-01-201.SDR DALA2017090306542Cusp Web · corrodedEXCESSIVE CORROSION ON CUSP WEB, BS 772 TO 775. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-13.SDR DALA2017090306541Cusp Web · corrodedEXCESSIVE CORROSION ON CUSP WEB, BS 732 TO 738. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-13.SDR DALA2017090306540Channel · crackedCRACKED CHANNEL ON FLOOR PANEL 1079A. THE CHANNEL WAS REPAIRED IAW SRM 51-90-1.SDR DALA2017090306539Cusp Web · nickedTWO NICKS ON THE RT CABIN FLOOR CUSP WEB BETWEEN RBL 44 AND 54, BS 1054 TO 1063. THE CUSP WEB WAS REPAIRED IAW SRM 53-01, FIG 1.SDR DALA2017090306536Floor Support · corrodedCORROSION ON FLOOR SUPPORT LBL 52, BETWEEN BS 168 AND 200. THE FLOOR SUPPORT WAS REPLACED IAW SRM 51-30-2 AND SRM 51-30-5.SDR DALA2017090306535Floor Support · corrodedCORROSION ON FLOOR SUPPORT LBL 54, BS 160 AND 200. THE FLOOR SUPPORT WAS REPLACED IAW SRM 51-30-2 AND SRM 51-30-5.SDR DALA2017090306534Angle · crackedCRACK ON INTERNAL ANGLE,LOWER DOOR C-1. DAMAGED ANGLE ON LOWER EDGE WAS REPLACED IAW SRM 51-30-1 AND 51-30-5.SDR DALA2017090306533Spar Cap · crackedLEFT VERTICAL STAB FRONT SPAR CAP HAS 4 CRACK INDICATIONS INSIDE FASTENER HOLES ABOVE AND BELOW LEADING EDGE SKIN SPLICE STA. ZFS=52.267. REPAIR PER ERA 561317-14AD REV ORIG. (LP0195348)SDR DALA2017090306593Door Sill · corrodedFWD CARGO DOOR SILL HAS PILLOWING AT LOWER ZEE ANGLE BETWEEN STOPS. REPAIRED IAW SRM 53-05, FIG 44A.SDR DALA2017090206543Windshield · arcedDURING FINAL APPROACH, FIRST OFFICER`S WINDSHIELD HEAT UNIT ARCED AND SPARKED VISUAL AND AURAL SPARK BOTH WINDSHIELD ANTI- FOG AND ANTI-ICE SWITHES ON, NO CIRCUIT BREAKERS TRIPPED, NO SCORCH MARKS NOTED. PERFORMED AN OPERATIONAL CHECK OF THE WINDSHIELD ANTSDR DALA2017090206532Barrel · damagedTHE AFT DEPLOYED SWITCH FOR THE TAILCONE HAS A DAMAGED SET OF TURN BARRELS AND CABLE ENDS. WITH A SECOND CORRODED CABLE FROM THE EXTERNAL HANDLE SWITCH. REPLACED CABLES PER MD88 SRM 53-10-00 ON NR 3. (LP3444131)SDR DALA2017090206531Intercostal · crackedCRACKED INTERCOSTAL BTW BEAMS 4-5 AT FWD ENTRY DOOR. INTERCOSTAL WAS REPLACED IAW SRM 51-30-2.SDR DALA2017090206530Cusp Web · corrodedCORROSION ON LT CABIN FLOOR CUSP WEB UPPER/LOWER SURFACE BTW LBL 54 AND 60 FROM BS 598 TO 712. THE CUSP WEB WAS REPLACED IAW SRM 53-05 FIG. 131A-24, AND SRM 51-30-01, 51-30-02, 51-30-05.SDR DALA2017090106520Battery Pack · inoperativeEMERGENCY EXIT LIGHTS INOPERATIVE OVER THE FWD OVERWING EXIT DOOR. REPLACED THE BATTERY PACK. CHECKED NORMAL. REPLACED IAW WDM 33-51-12. OK FOR SERVICE.SDR DALA2017090106506Battery Pack · dischargedEMERGENCY EXIT LIGHTS INOP OVER THE OVER WING EXIT DOOR, AFT DOORS. DURING T/S FOUND EMERGENCY LIGHT BATTERY PACK B5-105 IN POOR CONDITION. RPLD PER WDM 33-51-12. OPS CK NML. OK FOR SVC.SDR DALA2017090106521Skin · gougedLEFT WING L/E SLAT NR 3 EXTERNAL SKIN HAS A GOUGE NEXT TO THE END. REMOVED DAMAGE AND EVALUATED, ORIGINAL .100 LOSS .024, REMAINING .076, AND FOUND TO BE OUT OF ALLOWABLE LIMITS IAW SRM 57-01. REPAIRED AREA IAW ERA 556444-14, REV O.SDR DALA2017090106519Cable · corrodedTHE AFT DEPLOYED SWITCH FOR THE TAILCONE HAS A DAMAGED SET OF TURN BARRELS AND CABLE ENDS. WITH A SECOND CORRODED CABLE FROM THE EXTERNAL HANDLE SWITCH. REPLACED THE CABLES IAW SRM 53-10-00.SDR DALA2017090106505Access Panel · crackedCRACK IN HOLES ON ACCESS FUEL PANEL ACCESS NR 1361C AND 1355C. BUSHINGS ON ACCESS FUEL PANEL ACCESS NR 1361C AND 1355C WERE REPLACED PER SRM 51-22-2A.SDR DALA2017090106504Floor Support · crackedCRACK ON FLOOR SUPPORT BEAM X=16L, STA 180 APPROX. FLOOR SUPPORT FROM STA Y=180 X=16L WAS REPLACED PER SRM 51-10-4.SDR DALA2017090106503Floor Support · corrodedEXCESSIVE CORROSION ON END OF FLOOR SUPPORT FROM STA Y= 200 ,X = -7. END OF FLOOR SUPPORT FROM STA Y=200 X=-7 WAS REPLACED PER SRM 51-10-4.SDR DALA2017090106502Tab · nickedNICK ON LT ELEVATOR ANTI FLOAT TAB OUTBD CORNER. LT ELEVATOR ANTI FLOAT TAB WAS REPAIRED IN ACCORDING SRM 55-04 PARAGRAPH 3 FIGURE 2.SDR DALA2017090106501Cusp Web · corrodedCORROSION ON RT CABIN FLOOR CUSP WEB UPPER/LOWER SURFACE BTW X=-44 AND X=-60 FROM STA Y=503 TO Y=598. SECTION CUSP WEB WAS REPLACE ON STA Y= 503 TO Y=598 BTW X=-44 AND X=-60 PER SRM 53-05 FIG 131A-16, 53-05 FIG131A-24 AND SRM 51-30-01,51-30-02, 51-30-05.SDR DALA2017090106500Floor Support · corrodedEXCESSIVE CORROSION ON FLOOR SUPPORT BTW STA Y= 200 , X=7 TO X=-7 IN REF NRC 899. FLOOR SUPPORT FROM STA Y=200 X=-7 TO 7 WAS REPLACED PER SRM 51-10-4.SDR DALA2017090106499Floor Support · corrodedCORROSION AND ELONGATED HOLES ON FLOOR SUPPORT BTW X=-44 AND X=-60 STA Y=200 AT FLOOR STRUCTURE CABIN. FLOOR SUPPORT FROM STA Y=200 X=44-60 WAS REPLACED PER SRM 51-10-4.SDR DALA2017090106498Floor Panel · crackedCRACK FLOOR PANEL NR 389G. FLOOR PANEL NR 389G WAS REPAIRED PER SRM 53-01 FIG 4 SHEET.SDR DALA2017083106475Doubler · crackedCRACKED PLATE ON THE FWD ENTRY DOOR FWD UPPER CORNER CAVITY DOUBLER. REPLACED IAW SRM 51-30-1, 51-30-2 AND DWG 9955752, REV K.SDR DALA2017090106522Vane · gougedLEFT WING OTBD FLAP INBOARD VANE GOUGED AT INBOARD UPPER SURFACE. REMOVED THE FLAP VANE IAW AMM 27-51-03.SDR DALA2017083106480Angle · corrodedCORROSION ON LT LOWER EPC ANGLE BS 160 AND LBL 50. THE ANGLE WAS REPLACED IAW SRM 51-30-2, 51-30-1, AND DWG 9955780, REV LA.SDR DALA2017083106478Retainer · brokenNR 2 THE INTERNAL TAIL CONE HANDLE, RETAINER IS BROKEN. REPLACED BOTH RETAINERS IAW AMM 53-53-00.SDR DALA2017083106477Skin · damagedDURING AN NDT INSPECTION, A DISCREPANT AREA WAS FOUND ON LOWER SKIN BETWEEN XCW=163 TO 168 REAR SPAR AT LT WING. REPAIRED IAW ER/A 560873-14AD, REV ORIGINAL.SDR DALA2017083106474Cusp Web · corrodedCORROSION ON THE CUSP WEB, LBL 44 - 60 UPPER & LOWER SURFACE FROM BS 598 - 712. THE CUSP WEB WAS REPLACED IAW DWG.9930538, ITEM -9 REV CF, AND SRM 53-05, FIG 131A-24.SDR DALA2017083106473Door Frame · corrodedMID CARGO DOOR FRAME CORRODED JUST IN FRONT OF THE LOWER AFT DOOR FRAME STOP. REMOVED DAMAGE AND REPAIRED IAW SRM 53-05, FIG 123, OPTION 2.SDR DALA2017083106472Door Sill · corrodedMID CARGO DOOR SILL HAS CORROSION AT LOWER ZEE ANGLE BETWEEN STOPS AND FWD OF FWD STOP. REPAIRED THE DOOR SILL IAW SRM 53-05, FIG 123, OPTION 2.SDR DALA2017083106471Strut · damagedDURING NLG SHOCK STRUT SEAL REPLACEMENT, FOUND METERING PIN AND INNER TUBE DAMAGED. REMOVED AND REPLACED NLG METERING PIN, SUPPORT TUBE, RESTRICTOR SUPPORT ASSY HEAD AND LOWER STRUT PISTON ASSY IAW CMM 32-21-04 AND AMDS.SDR DALA2017090106497Unknown · odorBURNING RUBBER SMELL IN CABIN/COCKPIT MOST NOTICEABLE IN AFT CABIN AREA. SEEMED TO IMPROVE DURING CRUSE. ATS ALSO DISCONNECTED W/THROTTLE SPLIT APPROACHING LEVEL OFF. ATS DISCONNECT W/THROTTLE SPLIT SIGNED ON LOG PAGE. PERFORMED AMDS CARDS 2120-2367 SMOKE/ODORSDR DALA2017083006470Skin · dentedDENTS ON SLAT PANEL NR 1 XIS 83, LT WING. THE DENTD WERE REPAIRED IAW SRM 57-03D, PAR 19. FIG 19, SHEET 2.SDR DALA2017083006460Cable · frayedL1 DOOR SLIDE1. THE LACE CABLE PIN REMOVED AND SAFETY PIN NOT INSTALLED P/N D29982-225S/N 27452. THE GIRT BAR CABLE IS FRAYED. REPLACED SLIDE ASSY PER OPN 2561-4964.SDR DALA2017083006459Fitting · corrodedCORROSION ON FITTING STA=693 BTW X 60 LT AT CABIN PAX. FITTING STA=693 BTW X 60 LT AT CABIN PAX WAS REPLACED PER DWG 4911383 ITEM 1 REV "K".SDR DALA2017083106476Stand Off · crackedAUX HYD PUMP POWER CABLE RT WW WIRING STANDOFF SUPPORT BRACKET CRACKED. LOCATED JUST I/B OF THE HYD SERVICE ACCESS PANEL. REMOVED AND INSTALLED THE STAND OFF IAW SRM 51-30-01.SDR DALA2017083006458Attach Fitting · crackedAFT ACCESSORY BAY LT AFT SIDE OF CANTED FRAME 1463 ATTACH CLIP IS CRACKED AROUND INBD FASTENER L7L INSIDE OF LOUVER PANEL REF AA 5310-01456-01.SDR DALA2017082900003Pin · corrodedCORROSION AND WORN RT AND LT INBD FLIGHT SPOILER HINGE CENTER PINS. THE PINS WERE REPLACED.SDR DALA2017082900002Angle · crackedCRACKED ANGLE BETWEEN LOWER EDGE AND BEAM NR 1 AT AFT CARGO DOOR. THE ANGLE WAS REPLACED.SDR DALA2017082900001Splice · corrodedCORROSION ON CUSP ANGLE SPLICE BETWEEN BS 503 - 522, RBL 60. THE CUSP SPLICE WAS REPLACED.SDR DALA2017082806404Fuse · blownF/C EMER LIGHTS INOP ON TEST. REPLACED FUSE AT BATTERY PACK B5-211. OPS CHECK GOOD REF WDM 33-51-14.SDR DALA2017082806403Floor Panel · delaminatedDELAMINATION FLOOR PANEL NR 200E, 617C, 160E AT PASSENGER CABIN. FLOOR PANEL NR 200E, 617C AND 160E WERE REMPLACED AND IDENTIFIED PER AMM 53-20-01-201.SDR DALA2017082806402Skin · damagedDAMAGE METALIZED COAT ON RUDDER SKIN LT AND RT SIDE. RUDDER WAS REPAIRED PER SRM 51-70-1A PAR 23 AND ERA 092613-14MA REV A.SDR DALA2017082706401Skin · dentedDENTS DAMAGE ON UPPER/LOWER SURFACE SKIN AT LT ELEVATOR GEARED TAB, ALSO DEGRADED SEALANT. ELEVATOR GEARED TAB LT WAS REPAIRED PER SRM 55-04 PAR 2 C AND SRM 51-20-0.SDR DALA2017082806408Floor Support · corrodedAFT CARGO BAY, LOWER SILL CORRODED, ALONG ENTIRE LENGTH, AT NUMEROUS NUTPLATE HOLES.SDR DALA2017082606400Pan · crackedCRACK ON RING PAN UPPER FWD CORNER STA Y=846 LEFT SIDE. RING PAN UPPER FWD CORNER STA Y=846 LEFT SIDE WAS REPAIRED PER SRM 53-05 FIG 122 AND 51-10-03.
Back to Mcdonnell Douglas MD-88