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 DALA2016031201885Floor Panel · corrodedCORROSION OR FLOOR PANEL 160G. FLOOR PANEL 160G WAS REPLACED; A NEW WAS FABRICATED IAW SRM 51-10-2, 51-10-4 AND DGW 9957828AB.SDR DALA2016031201884Fitting · corrodedCORROSION ON FITTING, 2EA OF FLOOR PANEL 160G, LATCH GIRT BAR. FITTINGS WERE REPLACED NEW, 2 EA WERE ADJUSTED IAW SRM 51-10-4.SDR DALA2016031201883Skin · dentedDENT ON UPPER FACE MID FIXED VANE LT WING OTBD FLAP NR 4. DENT ON UPPER FACE MID FIXED VANE LT WING OTBD FLAP WAS REPAIRED IAW SRM 57-03D, PARR 11 AND CARD 2000-8149-07.SDR WX0A2016031473102Stiffener · crackedCRACKED UPPER SKIN STIFFENER, STRINGER NR 1, ON AFT END OF AUXILIARY TANK IN AFT CARGO. REPAIRED IAW SRM 53-05 FIG 46.SDR DALA2016031101858Skin · corrodedBULGE OUTER FUSELAGE SKIN AND DOUBLER BETWEEN LONG 30 TO LONG 28, RT BS 130 APPROXIMATELY AT E/E DOOR JAMB. BULGE WAS EVALUATED WITH NEXT DIMENTIONS: D=1.5", X=0.095", D/X=15.78. THEREFORE IT IS WITHIN LIMITS IAW SRM 53-04-1, PAR 7 E CONDITION 1B. HFEC INSPESDR DALA2016031101874Wire Harness · damagedTHE FLIGHT CREW FOUND 1 RED EMERGENCY LIGHT INOPERATIVE AT SEAT ROW 24DE. MCO MAINTENANCE REPLACED THE HARNESS ASSY AND THE LIGHT CHECKED OK.SDR DALA2016031101873Lug · crackedCRACK ON LUG WYE DUCT. LUG ON WYE DUCT WAS WELDED IAW ER/A 494638-14MA, REV B.SDR DALA2016031101872Skin · wornWEAR ON OUTER SKIN FWD SIDE OF BS 192 AND BEAM NR 6 AT FWD ENTRY DOOR. DUE EXCESSIVE DAMAGE AREA WAS REPAIRED IAW ER/A 486216-14 MA, REV A.SDR DALA2016031101871Doubler · wornWEAR ON FWD/AFT DOUBLERS ON LOWER CORNERS AT FWD CARGO COMPARTMENT DOOR. DOUBLERS WERE REMOVED, NEW DOUBLERS WERE FABRICATED, TREATED, PAINTED AND INSTALLED IAW SRM 51-30-2, 51-10-3, PAR 21 AND 14, ER/A 486624-14MA, REV ORIGINALSDR DALA2016031101870Skin · corrodedCORROSION AT FUSELAGE, BS 1338, BETWEEN LONGERON 19L/20 LT. REPAIR WAS ACCOMPLISHED IAW ER/A 543198-14, REV ORIGINAL AND ETI-88-16-105 OF DATE: 04-MAR-16.SDR DALA2016031101869Cusp Web · crackedCRACK ON CUPS WEB BS 241 BETWEEN X= -60 TO X= -54 AT RT FLOOR CABIN PASSENGER. CUSP WEB WAS REPAIRED IAW SRM 51-30-1, SRM 51-30-5, SRM 51-01, SRM 51-30-2, SRM 53-05 FIG 131A-6, SRM 51-10-3, PAR 14,21,38.SDR DALA2016031101868Skin · crackedVERTICAL STABILIZER HAS A CRACK ON TOP L/E. REMOVED DAMAGED SKIN BETWEEN STOP DRILLS. TRIMMED OUT DAMAGED AREA. HFEC IAW SPM 6-10-01.001. FABRICATED AND INSTALLED INTERNAL DOUBLER AND FILLER IAW PRI 544417-14, REV O. IDENTIFIED REPAIR IAW 900-5-1, NR 4. RSDR DALA2016031101867Spar · damagedDURING NDT INSPECTION A DISCREPANT AREA WAS FOUND 7 DIFFERENT FASTENERS OF THE PSE AT LT LOWER WING SKIN REAR SPAR BETWEEN BS XRS =162 TO XRS=168. THIS NRC WILL BE ATTENDED BY THE ER/A 543200-14AD. REV ORIGINAL. FROM THE SECTION II.SDR DALA2016031101866Spar · damagedDURING NDT INSPECTION A DISCREPANT AREA WAS FOUND 7 DIFFERENT FASTENERS OF DE PSE AT RT LOWER WING SKIN REAR SPAR BETWEEN XRS=162 TO XRS=168. REPAIRED IAW ER/A 543200-14AD. REV, ORIGINAL FROM THE SECTION II.SDR DALA2016031101865Seat Track · corrodedCORROSION ON PLUG AT RT SEAT TRACK, X=-54 BS 506-509 AT FLOOR STRUCTURE. PLUG WAS REMOVED, NEW PLUG WAS INSTALLED IAW SRM 51-30-1, 53-10-3, PAR 21, 14, 53-05, FIG 4A.SDR DALA2016031101864Pan · crackedCRACK ON LT RING PAN UPPER FWD CORNER BETWEEN BS 579 TO 598. RING PAN WAS REPAIRED IAW SRM 51-30-2, 51-30-5, 53-05, FIG 122, 51-10-3, PAR 14,21 AND ER/A 487747-14MA, REV A AND ER/A 493648-14MA, REV A. LONG OF CRACK IS 0.450".SDR DALA2016031101863Seat Track · corrodedCORROSION ON LT PLUG SEAT TRACK, X=54, BS 579. PLUG WAS REMOVED, NEW PLUG WAS INSTALLED IAW SRM 51-30-1, 53-10-3, PAR 21, 14, 53-05, FIG 4A.SDR DALA2016031101862Seat Track · corrodedCORROSION ON LT PLUG SEAT TRACK X=22, BS 579-826. PLUG WAS REMOVED, NEW PLUG WAS INSTALLED IAW SRM 51-30-1, 53-10-3 PAR 21, 14, 53-05 FIG 4A.SDR DALA2016031101861Pan · crackedCRACK ON LT RING PAN UPPER FWD CORNER BETWEEN BS 927 TO 946. RING PAN WAS REPAIRED IAW SRM 51-30-2, 51-30-5 53-05, FIG 122, 51-10-3, PAR 14,21 AND ER/A 487747-14MA REV A AND ER/A 493648-14MA, REV A.SDR DALA2016031101860Pan · crackedCRACK ON LT RING PAN UPPER AFT CORNER BETWEEN BS 984 TO 1003. RING PAN WAS REPAIRED IAW SRM 51-30-2, 51-30-5, 53-05, FIG 122, 51-10-3, PAR 14, 21 AND ER/A 487747-14MA REV A AND ER/A 493648-14MA, REV A.SDR DALA2016031101859Pan · crackedCRACK ON LT RING PAN LOWER FWD CORNER BETWEEN BS 750 TO 769. RING PAN WAS REPAIRED IAW SRM 51-30-2, 51-30-5, 53-05, FIG 122, 51-10-3, PAR 14,21 AND ER/A 487747-14MA, REV A AND ER/A 493648-14MA, REV A.SDR DALA2016031101857Frame · crackedCRACKED FRAME CLIP BS 1380 PROYECTION LONG 15 LT AT AFT ACC COMPARTMENT. FABRICATED AND REPLACED FRAME CLIP IAW SRM 53-14-4 AND 51-10-3, PAR 14 AND 21 AND 51-30-5 AND 51-30-2, 51-10-4.SDR DALA2016031101856Pan · crackedCRACK ON LT RING PAN UPPER FWD CORNER BETWEEN BS 769 TO 788. RING PAN WAS REPAIRED IAW SRM 51-30-5, 51-30-2 53-05, FIG 122, 51-10-3 PAR 14,21 AND ER/A 487747-14MA, REV A AND ER/A 493648-14MA, REV A.SDR DALA2016031101855Pan · crackedCRACKED LT RING PAN UPPER FWD CORNER BETWEEN BS 313-332 AND AFT LWR CORNER BETWEEN BS Y=427-446. RING PAN WAS REPAIRED IAW SRM 53-05, FIG 122, 51-30-2, 51-30-5, 51-10-3 PAR 14, 21 ON BS 427-446 AND BS 313-332 HFEC WAS ACCOMPLISHED ON RING PAN, UPPER FWD CORNESDR DALA2016031101854Floor Support · crackedCRACKED FLOOR SUPPORT. NEW FLOOR SUPPORT INSTALLED. REMOVED SRM 51-30-1. DRILLED SRM 51-10-4. INSTALLED DWG 9936639, REV P.SDR DALA2016031101853Longeron · crackedCRACKED END LONGERON 2L BS 1418 AT AFT ACCESSORY COMPARTMENT. REPAIR LONGERON WAS REPLACED IAW SRM 53-02, FIG 18, SRM 51-30-5.SDR DALA2016031101852Pan · crackedCRACKED RT RING PAN AFT UPPER CORNER BETWEEN BS 750-769, 1117-1136, 1136-1155, 1174-1193, 1212-1231. RING PAN RT AFT UPPER CORNER BETWEEN BS 750-769, BS 1117-1136, BS 1136-1155, BS 1174-1193, BS 1212-1231 WERE REPAIRED IAW SRM 51-30-2, 51-30-5, SRM 53-05, FISDR DALA2016031101851Pan · crackedCRACKED RT RING PAN FWD LOWER CORNER BETWEEN BS 807-826, 1022-1041, 1079-1098. RING PAN RT FWD LWD CORNER BETWEEN BS 807-826, 1022-1041, 1079-1098 WERE REPAIRED IAW SRM 53-05, FIG 122 AND SRM 51-30-2, 51-30-05, ERA`S 493648-14MA REV A 487747-14MA, REV A.SDR DALA2016031101850Angle · crackedCRACKED INTERCOSTAL ANGLE ON BS 674 BETWEEN EDGE AND BEAM 1 AT MID CARGO COMPARTMENT DOOR. CRACKED INSTERCOSTAL ANGLE WAS REPLACED IAW SRM 51-30-2 AND 51-3-5.SDR DALA2016031101849Pan · crackedCRACKED RT RING PAN FWD UPPER CORNER BETWEEN BS 351-370, 370-389, 845-864. RING PAN RT FWD UPPER CORNER BETWEEN BS 351-370, 370-389, 845-864 WERE REPAIRED IAW SRM 53-05, FIG 122 AND 51-30-2, 51-30-05, ERA 487747-14MA, REV A 493648-14MA, REV A.SDR DALA2016031101848Seat Track · corrodedCORROSION ON PLUG AT SEAT TRACK X=-22, BS 1288-1291 AT FLOOR STRUCTURE. PLUG WAS REPLACED IAW SRM 51-30-1, 51-10-3, PAR 21 AND 14 AND 53-05, FIG 4A.SDR DALA2016031101847Skin · not reportedDISCREPANT AREA WAS FOUND ON FUSELAGE SKIN, EXTERNAL DOUBLER REPAIR AT BS 1418 AND BETWEEN LONGERON 1 AND 3 RT. THE ER/A 498486-14, REV. ORIGINAL WAS GENERATED AND FROM SECTION I: ER/A REVISION REQUIRED, AMOC IAW SID AD 2004-11-07.SDR DALA2016031101846Pan · crackedCRACK ON INNER PAN OF AFT UPPER CORNER BETWEEN BEAM NR 1 AND BS 196 AT FWD ENTRY DOOR. INNER PAN OF FWD ENTRY DOOR WAS REMOVED, DUE TO CRACK AND NEW PAN WAS DRILLER AND INSTALLED IAW SRM 51-30-1, 51-30-2 AND 51-30-4.SDR DALA2016031101845Skin · damagedDAMAGE ALLUMINIZED ON RT/LT SIDES OF RUDDER SKIN AT VERTICAL STABILIZER. METALLIZED ON RT/LT SIDES OF RUDDER SKIN AT VERTICAL STABILIZER WERE REPAIRED IAW ER/A 092613-14MA REV A, SRM 51-70-1A D, PAR 23.SDR JR2R03102016374Fuel Tank · crackedAFT AUX FUEL TANK CRACKED AT UPPER SKIN STIFFENER, NR 1 STRINGER, AFT END. REPAIR WAS ACCOMPLISHED IAW SRM 53-05 FIGURE 46 UNDER WO 1012616-1600 0091 & WO 00283925 M301 NR 374.SDR DALA2016031501956Structure · missingFLAME SPRAY MISSING FROM CRITICAL ZONES ON RUDDER IAW SRM 55-03, PAGE 91 AND 92. RUDDER REQUIRES REPLACEMENT. RUDDER ASSY, PN 5955501-1, SN 0327 REMOVED. INSTALLED RUDDER IAW AMDS WC 2720-4421 AND 2720-7454. OK FOR SERVICE.SDR DALA2016031001828Light · inoperativeMAINTENANCE FOUND 2 EMERGENCY LIGHTS INOPERATIVE AT THE G2 COAT CLOSET. BOTH LIGHT ASSEMBLYS WERE REPLACED.SDR DALA2016031001827Skin · crackedCRACK ON FIXED L/E LOWER SURFACE LT WING BS XRS=218. FIXED L/E LOWER LT WING WAS REPAIRED IAW ER/A 380953-14MA, REV A.SDR DALA2016031001825Frame · crackedCRACKED FRAME CLIP BS 1380 LONG 15 RT AT AFT ACCESSORY COMPARTMENT. FRAME CLIP WAS REPLACED IAW SRM 53-14-4, SRM 51-30-2, SRM 51-30-5.SDR DALA2016031001824Longeron · crackedCRACKED LONGERON 3 LT BS 1437 AT AFT ACCESSORY COMPARTMENT. SPLICE, SUPPORT AND LONGERON WERE REMOVED IAW SRM 51-30-2 AND 51-30-5. SPLICE, SUPPORT AND LONGERON WERE INSTALLED IAW SRM 51-30-5, SRM 53-02, FIG 18. LONGERON WAS FOUND PREVIOUSLY REPAIRED IAW SRMSDR DALA2016030901786Pin · pulledMAINTENANCE FOUND L1 DOOR SLIDE PARACHUTE PIN PULLED WHILE GETTING AN OK TO INSTALL. THE SLIDE PACK WAS REPLACED.SDR DALA2016030901785Structure · wornWEAR ON SLIDE PLATFORM OF TAIL CONE. REPAIR DOUBLER WAS REPLACED IAW ER/A 497244-14MA REV ORIGINAL.SDR DALA2016030901784Floorbeam · corrodedCORROSION AT FLOORBEAM BS 160 X31 IN ELECTRONIC EQUIPMENT COMPARTMENT. CORROSION WAS REMOVED IAW SRM 51-10-3, PAR 26. REPAIR WAS ACCOMPLISHED IAW SRM 53-01 FIG 2.SDR DALA2016030901783Floor Panel · puncturedPUCTURED FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2016030901781Skin · crackedCRACKED SKIN ON UPPER SURFACE OF RT OTBD FIXED GUIDE VANE INBD FLAP. UPPER SURFACE OF RT OTBD FIXED GUIDE VANE INBD FLAP WAS REPAIRED IAW SRM 57-03D, PAR. II.SDR DALA2016030901780Bulkhead · nickedNICKS FOUND ON REAR FACE OF LOWER T-CAP AT BS 1338, P DOME, BETWEEN PROYECTION OF LONGERONS 27 LT AND 29 LT, REF CARD 4, ZONE 59 20000102603. T-CAP AT BS 1338, P-DOME BETWEEN PROYECTION OF LONGERON 23 LT AND 23 RT WAS REPLACED IAW SRM 51-30-2 AND 51-30-5 ANSDR DALA2016030901779Door Frame · crackedCRACKED DOOR JAMB CHANNEL BS 941, X=7LT AT LT MLG WHEEL WELL. CRACKED DOOR JAMB CHANNEL BS 941 AT LT MLG W/W WAS REPLACED IAW SRM 51-3-2, 51-30-5, 51-10-4 AND 51-10-3 PAR 14 AND 21 DWG 5930584, REV.SDR DALA2016030901778Structure · corrodedCORROSION ON INTERCOSTAL FUSELAGE SKIN BS 1155 BETWEEN LONG 29LT- 29RT AT C3. AREA WAS REPAIRED IAW 543161-14, REV ORIGINAL AND ETI- 88-16-073, REV 3.SDR DALA2016030801755Lanyard · tornMAINTENANCE FOUND YELLOW KEVLAR CORD TORN DURING THE TAILCONE KEVLAR CABLE INSPECTION. THE CABLE WAS REPLACED.SDR DALA2016030801753Access Panel · corrodedCORROSION AT FUEL ACCESS PANEL 2302C ON COUNTER SKIN. ACCESS IS OUT LIMITS AND IT WAS REPLACED IAW SRM 51-22-2A.
Back to Mcdonnell Douglas MD-88