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 DALA2015102906574Cusp Web · crackedCORROSION OF OUT LIMITS ON LT CUSP WEB X 54 TO X 60, BS 987 - 998. DAMAGE WAS REMOVED IAW SRM 53-05, FIG 131 A7 A REPAIR WAS FABRICATED IAW SRM 53-05, FIG 131A-7. THE REPAIR WAS TREATED, AND PAINTED IAW SRM 51-10-3, PAR 14 AND 21. THE REPAIR WAS INSTALLED IASDR DALA2015111206912Skin · damagedCRACK AT INBD FWD ATTACH FITTING CUTOUT HOLE SKIN, UPPER SKIN, ON OTBD VANE INBD FLAP LT WING. OTBD VANE INBD FLAP LT WAS REMOVED IAW AMM 27-51-01. VANE, NR 2 LT. LT INBD FLAP, OTBD VANE WAS REPLACED AND WAS INSTALLED UNDER CARD 148, ZONE 10.SDR DALA2015102906578Skin · wornWEAR ON LT L/E PREVIOUS REPAIR DOUBLER AT LT WING BETWEEN BS XRS=509 TO XRS=531. CARD 2, ZONE 11 L/E WAS REAPAIRED IAW ER/A 47800-14, REV B AND ETI -88-15-363, REV 2.SDR DALA2015102906573Pan · crackedCRACK ON UPPER AFT CORNER RING PAN BS 1231. THE RING PAN WAS REPAIRED IAW SRM 53-05, FIG 122 AND ERA'S NR 487747-14MA, REV A AND NR 493648-14MA, REV A.SDR DALA2015102906572Cusp Web · corrodedCORROSION ON RT CUSP WEB FROM BS 598 - 646 BETWEEN X -54 TO X -60 AT PAX CABIN. AREAS WAS REPAIRED IAW SRM 53-05, FIG 131A-6, SHEET 1, AND TREAT AND PAINT FABRICATED REPAIR PARTS APPLY CIC IAW SRM 51-10-3, PAR 14 AND 21, 38. INSTALL REPAIR PARTS.SDR DALA2015102906571Pan · crackedCRACK ON LT FWD LOWER CORNER RING PAN, BS 846. THE FWD LOWER CORNER RING PAN WAS REPAIRED IAW SRM 53-05, IG 122 AND ERA'S NR 487747-14MA, REV A AND NR 493648-14MA, REV A.SDR DALA2015102906570Skin · dentedDENTS ON LT ELEVATOR GEARED TAB UPPER SKIN. CARD 02, ZONE 65. DENTS ON LT ELEVATOR GEARED TAB UPPER SKIN WERE REPAIRED IAW SRM 55-04, PAR 2, OPN 1031.SDR DALA2015102906569Cusp Web · corrodedCORROSION ON LT CUSP WEB BS 605 - 609. WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-13.SDR DALA2015102906567Floor Support · corrodedCORROSION ON FLOOR SUPPORT BS 1155 AND 1212, LONGERONS 28 - 29R. THE FLOOR SUPPORT WAS REPLACED IAW SRM 51-30-2.SDR DALA2015102906566Frame · crackedCRACKED FRAME ANGLE BS 1418 BETWEEN LONGERONS 1 TO 2R IN AFT ACCESSORY COMPARTMENT. THE FRAME ANGLE WAS REPAIRED IAW SRM 53-03, FIG 3 AND 35.SDR DALA2015102906565Cusp Web · corrodedCORROSION ON RT CUSP WEB BETWEEN BS 935 TO 946 X -54 TO X -60 IN PAX CABIN. REPAIR INSTALLED IAW SRM 53-05, FIG 131A-10.SDR DALA2015102806539Longeron · crackedCRACKED LONGERON 5R AT BS 1309. A NEW SECTION OF THE LONGERON AND SPLICES WAS INSTALLED IAW SRM 51-30-2, 51-30-5 AND 53-02, FIG. 18.SDR DALA2015102806538Longeron · crackedCRACKED LONGERON 16L AT BS 1437. THE LONGERON WAS REPLACED IAW SRM 51-30-2, 51-30-5 AND 53-14-4.SDR WX0A2015102972972Smoke Detector · no testFORWARD SMOKE DETECTOR WILL NOT TEST. R & R SMOKE DETECTOR IAW MM 26-14-00. OPERATIONS CHECKED GOOD.SDR WX0A2015102972971Battery · dischargedCEILING EMER LIGHTS INOPERATIVE, BETWEEN ROWS 16 & 20. REPLACED EMER BATTERIES IAW AMM 33-53-00. OPERATIONS CHECKED NORMAL.SDR DALA2015102906568Beam · crackedCRACKED R1 DOOR BEAM 1 FWD EDGE. CRACKED R1 DOOR BEAM 1 WAS REPLACED IAW SRM 51-30-1, 51-30-2, 51-30-5 AND DWG 9911579, REV EP.SDR DALA2015102806543Cusp Web · corrodedCORROSION ON RT CUSP WEB X -54 TO X -60 BS 1060 - 1079. REPAIR FABRICATED, TREATED PAINTED AND INSTALLED IAW SRM 51-30-1, 53-05 FIG 131A-7, 51-30-2 PAR 14 AND 21, 51-10-3 PAR 38.SDR DALA2015102806542Scoop · crackedAVOINIC EXHAUST VENT SCOOP HAD THREE CRACKS. REMOVED SCOOP FOR WELD REPAIR IAW ER/A 464964-14MA. INSTALLED REPAIRED SCOOP.SDR DALA2015102806541Light · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTING AT SEAT 19D IN THE CABIN WAS INOPERATIVE. MAINTENANCE REPLACED THE LIGHT ASSEMBLY AND PERFORMED A SATISFACTORY FUNCTIONAL CHECK OF IT.SDR DALA2015102806536Skin · corrodedCORROSION BARRIEL NUT NR 24 ON LT HORIZONTAL STABILIZER. AREA WAS REPAIRED IAW ERA 539899-14, REV. ORIGINAL AND BOLT AND BARREL NUT NR 24 LT WERE REMOVED AND INSTALLED IAW SRM 51-30.SDR DALA2015102806534Cusp Web · corrodedCORROSION ON RT CUSP WEB MEMBRANE DOUBLER REPAIR FROM BS 660 TO 676 BTW X-54 TO X-60. THE CUSP WEB DOUBLER REPAIR WAS REPLACED IAW SRM 53-05, FIG 131A-10.SDR DALA2015102806533Skin · wornWEAR ON DOUBLER REPAIR OF EXTERNAL CARGO DOOR SKIN BS 376 FWD LOWER FRAME. DOUBLER WAS REPLACED IAW ERA 486624-14MA, REV ORIGINAL.SDR DALA2015102806532Skin · wornWEAR ON CUTOUT OF PNEUMATIC AIR GROUND CONNECTION FUSELAGE SKIN. DAMAGE DOUBLER WAS REMOVED, NEW DOUBLER WAS FABRICATED, TREATED, PAINTED AND INSTALLED IAW SRM 51-30-2.SDR DALA2015102706531Frame · crackedSPIDERING CRACKS IN AFT CANTED FUSELAGE FRAME BS 1510 AT THE LT 2 LOWER ALIGNMENT PINS. HFEC VERIFIED & MARKED END OF CRACKS (3EA) QC1984. CUT OUT DAMAGED SECTION OF FRAME (2EA). HFEC INSPECTED PER NDT-SPM 06-10-01. 001 BOTH CUTOUTS NO DEFECTS NOTED. DAMAGED SDR DALA2015102706518Cusp Web · not reportedFASTENER ON EDGE OF LIGHTING HOLE ON RT CUSP WEB PREVIOUS REPAIR BETWEEN BS 712 TO 720. PREVIOUS REPAIR DOUBLER WAS REMOVED IAW SRM 51-30-5 FITTING WAS REMOVED, DAMAGE WAS REMOVED, HFEC INSPECTION WAS PERFORMED AND NO CRACKS WERE FOUND, REPAIR DOUBLER WAS FABSDR DALA2015110406707Skin · damagedCRACK ON OUTER FUSELAGE SKIN NEXT TO LIGHTNING STRIKE WAS FOUND DURING NDT INSPECTION, BS 184 BETWEEN LONGERON 28 LT TO 29 LT, REF NRC 59, ZONE 100, CARD 275, ZONE 100. AREA WAS REPAIR IAW SRM 53-04-2, PAR 3C 2, A, 1A WITH DIMENSION HOLE .187" 51-10-3 PAR 14 SDR DALA2015102806537Skin · damagedLIGHTNING STRIKE ONE FUSELAGE SKIN BETWEEN BS 126 - 136 LONGERONS 27 - 28L. AREAS REPAIRED IAW SRM 51-10-3, PAR 15.SDR DALA2015102806535Web · crackedFOUR CRACKS ON WEB BS 1437 BETWEEN LONGERONS 5R-5L. THE WEB WAS REPLACED IAW SRM 53-14-4, 51-30-5.SDR DALA2015102706520Battery Pack · dischargedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTS IN ROWS 31-35 OF THE CABIN WERE INOPERATIVE. MAINTENANCE CHARGED THE BATTERY PACK AND THE LIGHTS RETURNED TO AN OPS CONDITION.SDR DALA2015102706519Battery Pack · dischargedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTING IN THE VENTRAL STAIRWAY WERE INOPERATIVE. MAINTENANCE CHARGED THE BATTERY PACK AND THE LIGHTS RETURNED TO AN OPS CONDITION.SDR DALA2015102706517Skin · crackedCRACK ON OUTER FUSELAGE SKIN NEXT TO LIGHTNING STRIKE WAS FOUND DURING NDT INSPECTION, BS 184 BETWEEN LONGERON 28 LT TO 29 LT. AREA WAS REPAIR IAW SRM 53-04-2 PAR 3C 2, A, 1A WITH DIMENTIONS HOLE .187", 51-10-3, PAR 14 AND 21 AND 51-30-2.SDR DALA2015102706516Cusp Web · wornWEAR OUT OF LIMITS ON CUSP WEB, BS 617 BETWEEN X=44, 54, LT SIDE AT CABIN PAX AREA. DAMAGE WAS REPAIRED IAW SRM 51-30-2, 51-30-5, 53-05, FIG 131A AND SRM 51-10-3, PAR 14 AND 21.SDR DALA2015102706515Door Frame · corrodedCORROSION ON DOUBLER PREVIOUSLY REPAIRED AT C3 CARGO DOOR JAMB BS=115 TO 1211. SPACER AND STRAPS WERE REPLACED IAW SRM 53-05, FIG 123, 51-30-5, 51-10-3.SDR DALA2015102606485Wire Harness · damagedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTS AT SEAT 12D WAS INOPERATIVE. MAINTENANCE REPLACED THE WIRE HARNESS AND FUNCTIONALLY CHECKED THE SYSTEM.SDR DALA2015102606484Fairing · crackedTAIL TOP, RT UPPER BANANA FAIRING UPPER EDGE HAS A 15 INCH LONG CRACK ABOVE AFT ATTACH POINT. REPAIRED IAW ER/A 464895-14MA REV F.SDR DALA2015102606482Fairing · crackedTAIL TOP, RT LWR BANANA FAIRING LWR EDGE HAS TWO 1 INCH LONG CRACKS AT 36 & 40 INCHES AFT OF FWD END. REPAIRED IAW ER/A 464895-14MA, REV F.SDR DALA2015102806540Vane · gougedDURING A SERVICE CHECK BOTH LEFT AND RIGHT OTBD FLAPS INBD FIXED VANES HAVE GOUGES ON L/E. R & R THE VANES IAW AMM 27-51-03. C/W E/RA 540796-14 REV ORIGINAL, SECTION II.SDR DALA2015102606483Pin · pulledFOUND L1 DOOR SLIDE PIN PULLED. THE SLIDE WAS REPLACED.SDR DALA2015102606481Cusp Web · corrodedCORROSION OUT OF LIMITS ON LT CUSP WEB X 54 - X 60, BS 890 - 892. REPAIR FABRICATED IAW SRM 53-05, FIG 131A-13. REPAIR TREATED/PAINTED IAW SRM 51-10-3, PAR 21,14 AND INSTALLED IAW SRM 51-30-2.SDR DALA2015102606480Longeron · damagedTAIL INTERIOR A .2500" ALUMINUM LINE IS CONTACTING LONGERON 13R AT BS 1341. REPAIRED IAW SRM 53-02, FIG 18 AS A REF.SDR DALA2015102606477Access Panel · corrodedCORROSION ON SETTLEMENT AREA AT LT WING ACCESS PANEL 1303C. THE ACCESS PANEL WAS REPLACED.SDR DALA2015102606476Access Panel · corrodedCORROSION ON SETTLEMENT AREA OF ACCESS PANEL 1409C ON RT WING. THE ACCESS PANEL WAS REPLACED.SDR DALA2015102606475Longeron · crackedCRACK ON LONGERON 10R, BS 427. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2015102606474Cusp Web · crackedCRACK ON RT CUSP WEB BS 907 BETWEEN X 53 - 56 IN PAX CABIN. DAMAGE WAS REMOVED IAW SRM 53-05, FIG 131A-10. A REPAIR WAS FABRICATED IAW SRM 53-05, FIG 131A-10. REPAIR AND AREA TREATED & PAINTED IAW SRM 51-10-3, PAR 14 AND 21. REPAIR WAS INSTALLED IAW SRSDR WX0A2015102672961Unknown · smokeTHE CREW SMELLED SMOKE AT ROTATION. FLIGHT ATTENDANTS CALLED SECONDS LATER. SMOKE WAS COMING FROM GASPERS IN THE FWD GALLEY. SMOKE WAS SO THICK THAT THE FLIGHT ATTENDANTS IN THE BACK OF THE AIRPLANE COULD NOT SEE THE FRONT. AN EMER WAS DECLARED WITH THE TOSDR DALA2015103006598Hinge · wornFREEPLAY ON UPPER HINGES OF HARDWARE ON YN=80, NR 1, YN=100 NR 2, YN=184 NR 3 AND YN=214 NR 4, LT APRON PYLON. UPPER HINGES ON BS YN=80, YN=184, AND YN=214 AT LT APRON PYLON WERE REPAIRED AND HARDWARE REPLACED AND FREE PLAY WAS CORRECTED IAW CMM 71-10-10 AND SDR DALA2015102506479Wire · brokenDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY PATHWAY LIGHTING AT SEAT 15D IN THE CABIN WAS INOPERATIVE. MAINTENANCE FOUND A WIRE BROKEN AND WAS REPLACED. THE SYSTEM RETURNED TO NORMAL OPERATION.SDR DALA2015102606478Wire · corrodedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTING FOR THE CATWALK IN THE TAIL COMPARTMENT WAS INOPERATIVE. MAINTENANCE FOUND WIRES TO BE CORRODED AT TERMINAL NR 5. THE CORROSION WAS CLEANED AND THE SYSTEM RETURNED TO NORMAL.SDR DALA2015102606473Access Panel · corrodedCORROSION ON COUNTERSINK AT RT WING ACCESS PANEL 1472C. THE ACCESS PANEL WAS REPLACED AND COUNTERSINK WERE MEASURED AND MAX DIAMETER ALLOWABLE IS .532" AND MAX DIAMETER MEASURED IS .620" IN, 5, HOLES THEREFORE IS OUT OF LIMITS IAW SRM 51-22-2A.SDR DALA2015102506472Spar · corrodedCORROSION ON LT HORIZONTAL STABILIZER REAR SPAR XE=225. REPAIRED IAW ER/A 539890-14, REV ORIGINAL.
Back to Mcdonnell Douglas MD-88