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 DALA2017040302666Attach Fitting · corrodedCORROSION ON FITTING TO ATTACH FWD SERVICE GALLEY SLIDE. THE FITTING WAS REPLACED IAW SRM 51-10-4.SDR DALA2017040202648Access Panel · corrodedCORROSION ON THE COUNTERSINKS AND SEATING AREAS OF THE ACCESS PANEL 1361C FOR THE LT WING. THE ACCESS PANEL WAS REPLACED IAW SRM 51-22-2A, PAR 6, CONDITION II.SDR DALA2017040202647Access Panel · corrodedCORROSION IN THE COUNTERSINKS OF THE ACCESS PANEL FOR THE RT WING. THE ACCESS PANEL WAS REPLACED.SDR DALA2017040202646Access Panel · corrodedCORROSION ON COUNTERSINK ON THE ACCESS PANEL 1335C FOR THE LT WING. THE ACCESS PANEL WAS REPLACED IAW SRM 51-22-2A, PAR 6, CONDITION II (A) 1 AND 2.SDR DALA2017040202645Access Panel · corrodedCORROSION ON COUNTERSINK AND SEATING AREA OF THE ACCESS PANEL 1303C FOR LT WING. THE ACCESS PANEL WAS REPLACED IAW SRM 51-22-2A, CONDITION III.SDR DALA2017040202644Skin · crackedLEFT WING UPPER SURFACE SKIN CRACKED 1.250 INCHES LENGTH. COMPLIED WITH PRI 556857-14 REV 0, REV 1, & REV 2. REPAIRED IAW ER/A 556857-14 REV ORIG.SDR DALA2017040402721Feeder Cable · burnedWHILE PERFORMING DUAL PACK CONFIDENCE CHECK FOUND APU GENERATOR FEEDER CABLES SCOTCHED AND BLACKENED. PULLED AND COLLARD APU CNTR/APU DOOR CNTL/AND APU GEN CNTL C/BS. RMVD L/H AFT STAIR SIDEWALL FOR ACCESS. RMVD APU INLET SCREEN FOR ACCESS. RMVD JUMPER BETWEESDR DALA2017040302665Rod End · damagedRT ELEVATOR GEAR TAB, OTBD CONTROL ROD, FWD ROD END PULLING OUT OF ROD, RIVET SHEARED AND NUT LOOSE. REPAIRED IAW AMM 27-30-04.SDR DALA2017040302662Web · crackedAFT FUSELAGE VENTRAL STAIRS, LT SIDE CANTED WEB CRACKED. REPAIRED IAW ERA 557101-14, REV ORIG.SDR DALA2017040302659Cusp Web · damagedCUSP WEB DAMAGED BS 464, RBL 58. REPAIRED IAW SRM 53-05, FIG 131A-10.SDR DALA2017040302657Skin · damagedRIGHT WING INBOARD FLAP UPPER SURFACE DAMAGED. . REPAIRED IAW ERA 556877-14 REV ORIG. REMOVED AND INSTALLED LOWER SECTION WEDGE ASSY IAW AMM 57-50-00 AND REPLACED WEAR STRIP IAW CMM 27-50-01.SDR DALA2017040302656Bushing · damagedDAMAGE BUSHINGS ON GROUND SPOILER LINKS. THE LINKS WERE REPLACED IAW CMM. 27-61-10.SDR DALA2017040102643Housing · wornWORN HOUSING AT MID CARGO DOOR. THE HOUSING WAS REPLACED IAW SRM 51-30-2, AND 51-30-5.SDR DALA2017040102642Cusp Web · corrodedCORROSION ON CUSP WEB LBL 44 & 60, BS 1245 - 1243. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131 A.SDR DALA2017040102641Pan · crackedCRACKED FWD, LOWER CORNER OF RING PAN BETWEEN BS 807 - 826. REPAIRED IAW SRM 53-05, FIG 122.SDR DALA2017040102640Angle · crackedCRACKED AFT, UPPER ANGLE OF CORNER ON RING PAN BS 946 - 964. REPLACED IAW SRM 51-30-2, AND 51-30-5.SDR DALA2017040102639Fitting · crackedHORIZONTAL STAB, CENTER BOX FWD END, UPPER FITTING CRACKED ON RT SIDE, HSS XH 7. REPAIRED IAW DWG 5910405-401.SDR DALA2017040102638Skin · not reportedERA491693-14AD REV B, FUSELAGE SKIN LT & RT WINDOW BELT PANEL. WINDOW BELT PANEL WAS REPLACED IAW ER/A 491693-14AD, REV C, AND DRAWING 5953608, REV C.SDR DALA2017040102637Housing · wornWEAR ON HOUSING AT THE L1 DOOR. THE HOUSING WAS REPLACED IAW SRM 51-30-2.SDR DALA2017040102636Hinge · crackedCRACKED HINGE ATTACH LOWER EDGE AT FWD L1 DOOR. THE HINGE WAS REPLACED IAW SRM 51-30-1, AND 51-30-4.SDR DALA2017040302668Wire Harness · disconnectedEMERGENCY LIGHT INOPERATIVE AT SEAT 16DE. FOUND THE WIRE HARNESS UNDER SEAT DISCONNECTED. CONNECTED THE WIRE HARNESS, OPS CHECKED GOOD.SDR DALA2017033102596Panel · delaminatedMECHANIC FOUND A CRACK ON THE UNDERNEATH PANLE FWD OF THE SPOILER. FOUND PANEL COMPLETELY DELAMINATED. REMOVED THE DAMAGED PANEL. DRILLED AND TRIMMED A NEW PANEL AND INSTALLED IAW DRAWING 9936823.SDR DALA2017033102595Cylinder · corrodedSPLINES ON OUTER CYLINDER AND BOWL ARE CORRODED ON THE NLG. REMOVAL AND REPLACED THE LANDING GEAR ASSY IAW AMDS 3242-4522, AND 3221-4152.SDR DALA2017033102594Skin · corrodedCORROSION ON THE HORIZONTAL STAB SKIN AT THE BARREL NUTS NR 9 AND 25, XH 27. REPAIRED IAW ETI-88-17-089, REV 2, AND ER/A 556330-14, REV ORIGINAL.SDR DALA2017033102593Floor Panel · damagedCENTER FLOOR PANEL BETWEEN SEAT ROWS 2B - 2C HAS A SOFT SPOT. REPLACED THE FLOOR PANEL IAW AMM 53-20.SDR DALA2017033102592Seat Track · damagedSEAT TRACK BS 607 - 609, LBL 54 DAMAGED OUT OF LIMITS. THE DAMAGE WAS REPAIRED IAW SRM 53-05, FIG. 4A.SDR DALA2017033102591Cusp Web · corrodedCORROSION ON THE RT CUSP WEB, BS 1060 - 1079, RBL 54 - 60. THE DAMAGE AREA WAS REPAIRED SRM 53-05, FIG 131A-9.SDR DALA2017033102590Doubler · crackedCRACKED DOUBLER ON THE AFT PAN BETWEEN BEAM 1 AND 2 ON THE AFT CARGO DOOR. THE DOUBLER WAS REPLACED IAW SRM 51-30-5, AND DWG 9957664, REV N.SDR DALA2017033102589Cusp Web · corrodedCORROSION THE ON CUSP WEB BETWEEN BS 1163 - 1164, RBL 54 - 60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131.SDR DALA2017033102588Cusp Web · corrodedCORROSION ON THE CUSP WEB UPPER & LOWER SURFACE RBL 54 - 60, BS 1003 - 1022. THE DAMAGED AREA WAS REPAIRED IAW SRM 53-05, FIG 131A-4.SDR DALA2017033102587Intercostal · crackedL1 DOOR HAD A CRACK ON THE INTERCOSTAL BETWEEN BEAMS 4 AND 5. THE INTERCOSTAL WAS REPLACED IAW SRM 51-30-1, AND 51-30-2.SDR DALA2017033102586Cusp Web · crackedCRACK ON RT CUSP WEB BETWEEN BS 712 TO 715, RLB 54 TO 60 . DAMAGE AREA WAS REPAIRED IAW SRM 53-05- FIG.131A-10.SDR DALA2017033102584Beam · crackedFWD CARGO BAY DOOR CRACKED INNER PAN BEAM NR 5, BS 1212. REPAIRED IAW SRM 52-03D FIG 8.SDR DALA2017033102583Cusp Web · corrodedCORROSION ON LEFT LOWER AND UPPER CUSP WEB SURFACE BS 598 TO 712, LBL 44 - 60. THE CUSP WEB WAS REPLACED IAW SRM 53-05 FIG 131A-24 .SDR DALA2017033002551Cusp Web · corrodedCORROSION ON THE PREVIOUS REPAIR OF THE PAX CABIN CUSP WEB BS 984 TO 1010, LBL 54 TO 60. THE CUSP WEB WAS REPLACED IAW SRM 53-05, FIG 131A-24.SDR DALA2017033002552Cusp Web · corrodedCORROSION ON THE PAX CABIN RT CUSP WEB UPPER & LOWER SURFACES BS 579 - 598, RBL 44 - 60. THE CORROSION WAS REMOVED, TREATED, AND PAINTED IAW SRM 51-10-3, PAR 26, 14, 21, AND 38. FOUND TO BE OUT LIMITS.SDR DALA2017033002550Doubler · wornWEAR ON THE FWD AND AFT LOWER CORNERS OF THE DOUBLERS ON THE AFT CARGO DOOR. THE DOUBLERS WERE REPLACED IAW SRM 51-30-2.SDR DALA2017033002549Seat Track · damagedOUT OF LIMITS SEAT TRACK BS 484 - 486, LBL 54 IN THE CABIN. DAMAGED AREA WAS REPAIRED IAW SRM 53-05, FIG 4A .SDR DALA2017033002548Floor Panel · corrodedCORROSION OUT OF LIMITS ON FLOOR PANEL 120D. A NEW FLOOR PANEL WAS DRILLED IAW SRM 51-10-4. TREATED AND PAINTED IAW SRM 51-10-3PAR 14 AND 21.SDR DALA2017033002547Cusp Web · corrodedCORROSION OUT OF LIMITS ON RT LOWER AND UPPER CUSP WEB SURFACE BS 579 TO 582, BS 595 - 598, RBL 44 TO 60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A.SDR DALA2017033002546Floor Panel · damagedFWD WET AREA, CORROSION AND CRACKED ANGLES ON RT FLOOR PANEL 160G. THE FLOOR PANEL WAS REPLACED IAW DWG 9957828, SRM 51-30-2, 51-10-3, PAR 26, 14, AND 21, 51-10-4, AND 51-10-2.SDR DALA2017033002544Skin · dentedDENT ON UPPER SKIN ON LT AILERON. THE AILERON WAS REPAIRED IAW SRM 51-70-1A, PAR. 12.SDR DALA2017033002543Longeron · wornWEAR ON LONGERON 8L, BS 1408. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2017033002542Bulkhead · crackedBULKHEAD BS 1463, BETWEEN LONGERONS 7 & 9R, WEB CRACKED AT CENTER LOCATION. REPAIRED IAW PRI 557035-14 REV 0.SDR DALA2017033002541Bulkhead · crackedAFT FUSELAGE, TAIL INTERIOR, CANTED BULKHEAD BS 1463 FWD WEB CRACKED. REPAIRED IAW PRI 557035-14 REV 0.SDR DALA2017032902526Skin · crackedLEFT WING TIP AFT OF LIGHT LOWER SURFACE SKIN CRACKED. REMOVED AND REPLACED LT WING TIP IAW AMM 57-20-02. (LP2951139)SDR DALA2017033002553Engine · vibrationAIRCRAFT LEVELED AT 370 AND POWER RETARDED, AIRCRAFT DEVELOPED A SMALL VIBRATION. VIBRATION FELT IN FLOOR AND YOKE AND WOULD CHANGE WITH POWER CHANGES. ALL PARAMETERS NORMAL. WHEN LEFT ENGINE WAS SHUT DOWN AT GATE AND DECELERATED VIBRATION GOT WORSE AND AIRSDR DALA2017032902527Skin · crackedDURING A WALK AROUND, FOUND CRACKING IN SKIN IN 48 SECTION LOWER RIGHT SIDE UNPRESSURIZED AREA ABOVE ACCUM ACCESS DOOR. STOP DRILLED THE CRACK. FABRICATED A DOUBLER. TREATED, INSTALLED, AND PAINTED IAW SRM 53-01, PAGE 12, FIG 2, SHEET 3.SDR DALA2017032902525Floor Panel · delaminatedDELAMINATED FLOOR PANEL. A NEW FLOOR PANEL WAS FABRICATED AMM 53-20-01-201.SDR DALA2017032902524Floor Support · crackedAFT CARGO BAY, CRACKED FLOOR SUPPORT BS 1309 BL 0. THE FLOOR SUPPORT WAS REPLACED IAW DWG 5930560, REV BC, SRM 51-30-2, AND 51-30-5.
Back to Mcdonnell Douglas MD-88