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 DALA2015081604983Cusp Web · corrodedCORROSION ON CUSP WEB BS 715-718 BETWEEN X -54 TO -60 AT CABIN PAX IN REF CARD 149, ZONE 201. REPAIR WAS ACCOMPLISHED IAW SRM 53-05, FIG 131A -13.SDR DALA2015081905092Seat Track · corrodedCORROSION ON SEAT TRACK REPAIR BS 826 - 822 LBL 54. REPAIR WAS REPLACED IAW SRM 53-05, FIG 4A AND SRM 51-10-3, PAR 14, 21.SDR DALA2015081905091Seat Track · corrodedCORROSION ON SEAT TRACK REPAIR BS 527 - 533 LBL 22. REPAIR WAS REPLACED IAW SRM 51-30-1.SDR DALA2015081504982Skin · crackedCRACK ON FUSELAGE SKIN ON BS 1474 ON LONGERON 21 TO 22L. HOLES WERE STOP DRILLED AND REPAIR DOUBLER WAS FABRICATED, TREATED AND PAINTED AND INSTALLED IAW SRM 53-01, FIG 2, 51-10-3, P 14 AND 21 AND 51-30-2. HFEC WAS PERFORMED IAW NDT SPM 06-10-01.001.SDR DALA2015081504981Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT SURFACE AT RT WING FUEL TANK ACCESS PLATE NR 1414C, MRB 57-083-02, ACCESS 1414C WAS REPLACED IAW SRM 51-22-2A.SDR DALA2015081504980Access Panel · corrodedCORROSION ON COUNTERSINK AT SETTLEMENT AREA AT FUEL ACCESS PLATE NR 1335C LT WING. FUEL ACCESS 1335C WAS REPLACED IAW SRM 51-22-2A.SDR DALA2015081404954Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE OVERHEAD EMERGENCY LIGHTING IN THE GALLEY WAS INOPERATIVE. MAINTENANCE REPLACED THE BATTERIES. OPS CHECKED GOOD.SDR DALA2015081405006Cusp Web · wornWEAR ON CUSP WEB, BS 617, BETWEEN LBL 44 - 54. CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A.SDR DALA2015081604988Seat Track · corrodedCORROSION ON SEAT TRACK BS 730 - 736 ON PREVIOUS REPAIR X 54. PLUG WAS REPLACED IAW SRM 51-30-1 AND 53-05, FIG 4A.SDR DALA2015081404979Stringer · crackedCRACK ON STRINGER 17 AT BS XCW=10 RT SIDE, CENTER TANK. DAMAGE WAS REPAIRED ER/A 537731-14AD, REV. ORIGINAL AND ER/A 537741-14, REV ORIGINAL.SDR DALA2015081404978Skin · damagedFUSELAGE EXTERIOR, EIGHT DAMAGED FASTENERS AFT AT BS 1193 LONGERON NR 1. REPAIRED IAW ERA 538516-14AD, REV A.SDR DALA2015081304977Web · corrodedCORROSION ON WEB AROUND OF WATER LINES BS 160 BETWEEN X -44 AND X -54 LOWER SURFACE. DUE TO AN EXESSIVE DAMAGE, THE WEB WAS REPAIRED IAW SRM 51-70-4. DAMAGE WAS REMOVED, DOUBLER WAS FABRICATED, TREATED AND PAINTED AND FINALLY DOUBLER REPAIR WAS INSTALLED IAWSDR DALA2015081304976Cusp Web · corrodedCORROSION ON LT CUSP WEB BETWEEN BS 387-389 AND BETWEEN X 56-60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A, 51-10-3, PAR 14-21.SDR DALA2015081705127Skin · dentedDENT FOUND ON RT NR 5 SLAT PANEL L/E. FOUND WITHIN LIMITS IAW SRM 57-03D, FIG 18. HFEC INSPECTION WAS ACCOMPLISHED AND NO CRACKS WERE FOUND IAW SRM 57-03, FIG 18. STEP 6A AND NDT SPM 06-10-01.001.SDR DALA2015081304975Longeron · crackedCRACKED LONGERON NR 8, RT STA Y=13. LONGERON WAS REPAIRED IA SRM 51-30-2, 51-30-5, 53-02 FIG 18, 51-10-3 PAR 14 AND 21.SDR DALA2015081304974Seat Track · corrodedCORROSION ON PREVIOUS REPAIR LT SEAT TRACK PLUG X=22 BS 670-674 AT PAX CABIN. PLUG WAS REPLACED IAW SRM 53-05, FIG 4A.SDR DALA2015081304973Cusp Web · puncturedPUNCTURE ON CUSP WEB BS 1129 AND X -54 DAMAGE AREA WAS REMOVED, NEW FILLER AND DOUBLER WERE FABRICATED, NEW FILLER AND DOUBLER WERE TREATED AND PAINTED, NEW DOUBLER AND FILLER WERE INSTALLED IAW SRM 53-05, FIG 131A-19 AND 51-10-3, PAR 14 AND 21.SDR DALA2015081304972Doubler · corrodedCORROSION ON PRODUCTION DOUBLER OF CENTER WING REAR SPAR BS XCW= 53 AT RT MLG WHEEL WELL. DAMAGE WAS REPAIRED IAW: ER/A 536507-14, REV ORIG.SDR DALA2015081304971Pan · crackedCRACK ON LT WINDOW RING PAN LOWER/AFT CORNER BETWEEN BS 598-617, 769-788, 1060-1079. REPAIRED IAW SRM 53-05, FIG 122, 51-30-2 , 51-30-5 , 51-10-3 PAR. 14 AND 21 AND SRM 51-10-4 AND ERA 493648-14MA, REV A.SDR DALA2015081304970Pan · crackedCRACK ON LT WINDOW RING PAN LOWER/FWD CORNER BETWEEN BS 1060-1079, AND 1079-1098. REPAIRED IAW SRM 53-05, FIG 122, 51-30-2 , 51-30-5 , 51-10-3, PAR 14 AND 21 AND 51-10-4 AND ERA 493648-14MA, REV A.SDR WX0A2015081672795Light · inoperativeEMERGENCY LIGHTS INOPERATIVE AT ROWS 16, 20 & 30. REMOVED CHECKED BATTERIES FOR PROPER VOLTAGE. BATTERIES CHECKED GOOD. RE-INSTALLED BATTERIES & OPERATIONS CHECKED GOOD IAW AMM 33-53-01.SDR DALA2015081304955Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTS IN ROWS 11-15 OF THE CABIN WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACKS FOR THE NOTED LIGHTED AREAS AND THE OPS CHECK WAS GOOD.SDR DALA2015081905131Seat Track · corrodedCORROSION ON PREVIOUS REPAIR ON SEAT TRACK X=-22 AND BS 695-698. PLUG WAS REPLACED IAW SRM 53-05, FIG 4 AND CIC WAS APPLIED IAW SRM 51-10-3.SDR DALA2015081604986Seat Track · corrodedCORROSION ON SEAT TRACK BS 932 - 938 ON PREVIOUS REPAIR X 54. PLUG WAS REPLACED IAW SRM 53-05, FIG 4A AND 51-30-1I.SDR DALA2015081604985Seat Track · corrodedCORROSION ON RT REPAIR PLUG OF SEAT TRACK, X -54 AND BETWEEN BS 379-381, 429-431 AND 463-465. PLUG WAS REPLACED IAW SRM 53-05, FIG 4A AND 51-30-1I. ALARCON 593421. PRIMARY STRUCTURE.SDR DALA2015081604984Seat Track · corrodedCORROSION ON SEAT TRACK BS 436 - 441 ON PREVIOUS REPAIR X 54. PLUG WAS REPLACED IAW SRM 53-05, FIG 4A AND 51- 30-1. PRIMARY STRUCTURE.SDR DALA2015081204969Skin · crackedCRACKED FUSELAGE SKIN BETWEEN LONGERONS 1-2R, BS 1418. REPAIRED IAW ER/A 537730-14AD REV ORIGINAL, M.SDR DALA2015081204968Skin · crackedCRACK WAS FOUND AT FUSELAGE SKIN UPPER FWD CORNER, DOOR JAMB BS 375 BETWEEN LONGERONS 19-20R, REPAIRED IAW ETI-88-15-261, REV ORIG AND ER/A 536516-14AD, REV ORIG.SDR DALA2015081204967Seat Track · corrodedCORROSION ON RT SEAT TRACK X -54 BETWEEN BS 496-503. DAMAGE OUT OF LIMITS, CUT OUT AND REPAIRED IAW SRM 53-05, FIG 4A.SDR DALA2015081204953Seat Track · corrodedCORROSION ON SEAT TRACK, X -54 AND BS 305-309 AT PAX CABIN. DAMAGE OUT LIMITS WAS CUT OUT AND REPAIRED IAW SRM 53-05, FIG 4A.SDR DALA2015081204952Support Fitting · corrodedCORROSION ON LT MLG SUPPORT FITTING BUSHING BORE. CORROSION ON BUSHING BORE WAS REMOVED AND FOUND WITHIN LIMITS IAW DWG SR09570087, REV B AND CORROSION ON BOTTOM BORE WAS REMOVED WITH FINAL LENGTH 1.208" OUT OF LIMITS IAW DWG 5935812, REV BB, THEREFORE THIS ASDR DALA2015081204951Skin · damagedLIGHTNING STRIKE ON WINDOW BELT BETWEEN BS 731 AND 750 RT SIDE. WINDOW BELT WAS REPAIRED IAW ETI-88-15-270, REV 1 AND ER/A 537735-14AD, REV ORIGINAL "ON CRITICAL ZONE". AREA NOT A CRITICAL ZONE WAS ATTENDED WITH SRM 53-05, FIG. 111, SRM 51-10-3 PAR 21. MAJORSDR DALA2016111108830Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT SURFACE AT RT WING FUEL TANK ACCESS PANEL 1462C. THE ACCESS PANEL WAS REPLACED IAW SRM 51-22- 2A.SDR DALA2015090905506Pan · wornACFT HAS WEAR ON PREVIOUS REPAIR DOUBLER INNER AND OUTER PAN AT MID CARGO DOOR. MID CARGO DOOR WAS REPLACED IAW AMM 52-31-00-401. AND WILL BE INSTALLED UNDER AMDS CARD 5200-4291, JOB 001-0267.SDR DALA2015082405191Skin · dentedSEVERAL DENTS ON OUTER SKIN OF AFT CARGO DOOR. THE AFT CARGO DOOR WAS REPLACED IAW AMM 52-31-00-401.SDR DALA2015081905132Access Panel · corrodedCORROSION ON COUNTERSINK FUEL ACCESS PLATE NR 1409C AT RT WING. FUEL ACCESS WAS REPLACED IAW SRM 51-22-2A.SDR DALA2015081104887Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE OVERHEAD EMERGENCY LIGHTS AT DOOR 2L AND SEAT 33 WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERIES. OPS CHECK WAS GOOD.SDR DALA2016111108829Cusp Web · corrodedCORROSION ON CUSP WEB BS 712 - 720 BETWEEN RBL 54 TO 60. CORROSION WAS REMOVED IAW SRM.SDR DALA2015081004949Structure · damagedELONGATED HOLE DUE TO INADEQUATE DRILL HOLE ON LT LOWER ACCESS DOOR CUTOUT XRS=189.0 TO 214.0. ELONGATED HOLE WAS REPAIR IAW ETI 88-15-278, REV ORIGINAL. AREA WAS REPAIRED IAW ER/A NR 536495-14, REV ORIGINAL.SDR DALA2015081805130Floor Support · corrodedENTRANCE DOOR FLOOR SUPPORT FRAME, SIX INCHES FROM DOOR SILL HAS CORROSION. REPLACED THE FLOOR SUPPORT IAW DWG 9936534.SDR DALA2015080904927Seat Track · corrodedCORROSION ON PREVIOUS REPAIR, LT SEAT TRACK PLUGS X=22, STA 450-455 AND 484-489 AT PAX CABIN. PLUGS WERE REMOVED IAW SRM 51-30-1. PLUGS WERE ADJUSTED IAW SRM 53-05, FIG 4A, SHEET 1-2. AREA AND PLUGS WERE TREATED AND PAINTED IAW SRM 51-10-3 PAR 14 AND 21. PLSDR DALA2015080904926Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT SURFACE AT RT WING FUEL TANK ACCESS PLATE NR 1436C, MRB 57-083-02. CORROSION ON COUNTERSINK WAS REMOVED AND MEASURED. THE MAX DIAMETER ALLOWED IS .660" AND MAX DIAMETER MEASURED ON 3 HOLES ADJACENT IS 0.686", IT IS OUTSDR DALA2015080904925Cusp Web · crackedCRACK ON CUSP WEB, BS 767 BETWEEN X 44 - 54 LT SIDE AT CPAX. CUSP WEB REPAIRED IAW SRM 53-01, FIG 4, 53-05, 51-10-3 PAR 14 AND 21 AND 51-30-2. LENGTH OF CRACK IS 2.250".SDR DALA2015080904924Spar · crackedCRACKED VERTICAL STABILIZER SPAR FWD. SPAR WAS REPAIRED IAW SRM 55-02D, FIG. 26. LENGTH CRACK .750".SDR DALA2015080904923Frame · crackedCRACKED FRAME, BS 1510 AND 3 O'CLOCK POSITION AT AFT ACCESSORY COMPARTMENT (SM) (ZONE 61) (CARD 48). CRACK, FABRICATED DOUBLER AND FILLER, INSTALL DOUBLER AND FILLER IAW SRM 51-10-3 PAR 14 AND 21 AND ER/A 497316-14MA REV ORIGINAL HFEC INSPECTION EQUIPMENT MESDR DALA2015080804922Angle · corrodedCORROSION ON LT AND RT ANGLE FWD, MID, AND AFT SECTION AT STAIRWAY WALKING BRIDGE. ANGLES WERE BLENDED AND TREATED AND PAINTED IAW SRM 51-10-3, PAR 14, 21, AND 26. AREA WAS OUT OF LIMITS AND WAS REPAIRED IAW SRM 53-01, FIG 4, TRANS: V260-RM. EQ GAGE THICKNESDR DALA2015090105371Door Frame · crackedON WALK-AROUND FOUND RT MLG WW DOOR FWD FRAME CRACKED. REPAIRED IAW ERA 538458-14, REV ORIG.SDR DALA2015081805100Bulkhead · crackedCORROSION ON FORWARD BULKHEAD AT CATWALK BRIDGE. TASK 53-062-03. CRACK WAS FOUND. CRACK WAS STOPPED. FABRICATED AND INSTALLED DOUBLER IAW SRM 51-10-03, 53-01, FIG 2, 53-14-3, 51-30-02 AND ERA 511165-14MA, REV C.SDR DALA2015081805096Support Angle · corrodedCORROSION AT CARGO TRACK SUPPORT ANGLE, BS 1166, TASK 53-139-05. REMOVED AND INSTALLED NEW ZEE CHANNEL IAW SRM 51-01, PARA 4.SDR DALA2015080804921Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA ON ACCESS PLATE 1363C AT LT WING CORROSION ON COUNTERSINK AND SETTLEMENT AREA WAS REMOVED AND COUNTERSINK HOLES WAS MEASURED. MAX DIAMETER ALLOWABLE IS 0.532" AND MAX DIAMETER MEASURED ON 3 ADJACENT HOLES IS 0.565
Back to Mcdonnell Douglas MD-88