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 DALA2016111108855Access Panel · corrodedFUEL TANK ACCESS PANEL 1335C CORRODED OUT OF LIMITS, REPLACED THE ACCESS PANEL.SDR DALA2016111108854Access Panel · corrodedFUEL TANK ACCESS PANEL 1472C COUNTERSINK CORRODED OUT OF LIMITS, THE ACCESS PANEL WAS REPLACED.SDR DALA2015041502781Skin · damagedDAMAGED METALLIZED COAT ON LT SIDE OF RUDDER. METALLIZED COAT ON LT SIDE OF RUDDER WAS REPAIR IAW SRM 51-70-1A, PAR 23. LP 1904812.SDR DALA2015041502779Skin · damagedDAMAGED METALLIZED COAT ON RT SIDE OF RUDDER. METALLIZED COAT ON RT SIDE OF RUDDER WAS REPAIR IAW SRM 51-70-1A, PAR 23. LP 1904856.SDR DALA2015041302775Release Cable · wornDURING CHECK, MAINTENANCE FOUND THAT THE EXTERNAL TAIL RELEASE CABLE WAS WORN. MAINTENANCE R & R THE WORN CABLE AND A FUNCTIONAL TEST WAS SATISFACTORY. LP 1901103.SDR DALA2015041202748Longeron · crackedCRACKED LONGERON 2RT ON FS Y=1418. CARD 45, ZONE 61. LONGERON WAS REPLACED IAW SRM 53-02, FIG. 18. LP 1900908.SDR DALA2015041202747Longeron · damagedCORROSION ON LONGERON 22 LT AND BS 1289 AT AF CARGO COMPARTMENT. LONGERON WAS ROUND WITH EXCESSIVE DAMAGE WAS REPAIRED IAW SRM 53-02, FIG 18. LP 1900697.SDR DALA2015041202746Pan · crackedCRACKED PAN ON STOP 1 AT RT FWD EMERGENCY EXIT DOOR. CRACK WITH 0.590" LONG WAS STOPPED IAW SRM 52-05. REPAIR PARTS WERE INSTALLED IAW SRM 52-05.SDR DALA2016111108853Cusp Web · corrodedLEFT CUSP WEB CORRODED OUT OF LIMITS, BS 1201, 1206-1207 BETWEEN LBL 54-60. DAMAGE REMOVED AND A REPAIR INSTALLED.SDR DALA2016111108852Angle · corrodedTEE ANGLE CORRODED OUT OF LIMITS BETWEEN BS 1427-1338 AT LONGERON 25L. THE TEE ANGLE WAS REPAIRED.SDR WX0A2015041472535Sensor · dirtyTAIL COMPARTMENT TEMP HIGH LIGHT CAME ON AT 14000' ON CLIMB OUT. LIGHT WENT OUT AFTER RT ENG POWER WAS REDUCED TO 1.3 EPR, AFTER 2 MINUTES POWER WAS INCREASED & LIGHT DID NOT RETURN. INSPECTED TAIL SECTION PNEUMATIC DUCTING & VLVS, NO DEFECTS NOTED, REF AMMSDR DALA2015041102745Cusp Web · corrodedCORROSION ON REPAIR DOUBLER OF CUSP WEB BETWEEN FS Y= 617 TO Y= 626 AND X= 54 TO X= 60 LL SIDE. REPAIR DOUBLER WAS REMOVED IAW SRM 51-30-5. PARTS WERE INSTALLED IAW SRM 53-05, FIG 131A.SDR DALA2015041002735Wire Harness · damagedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY PATHWAY LIGHTING AT SEAT 20D IN THE CABIN WAS INOPERATIVE. MAINTENANCE FOUND THE SEAT HARNESS DAMAGED. THE WIRE HARNESS WAS REPLACED AND THE SYSTEM RETURNED TO NORMAL OPERATION.SDR DALA2015041002734Lanyard · corrodedRUSTED DEPLAY LANYARD ON SLIDE AFT INFLATABLE AT TAIL CONE. LANYARD WAS REPLACED IAW AMM 26-60-01.SDR DALA2015041002733Skin · damagedLIGHTNING DAMAGE ON FUSELAGE SKIN STA Y=365 BETWEEN LONGERON 23LT AND 22 LT. FUSELAGE SKIN WAS REPAIRED IAW 53-04-2, FIG 2, SHEET 3. LP 1897946.SDR DALA2015041002732Floorbeam · corrodedCORROSION ON FLOOR SUPPORT, FS 1319 IN AFT CARGO COMPARTMENT AFT BULKHEAD. FLOOR SUPPORT WAS REMOVED IAW SRM 51-30-2 CORROSION IN FLOOR SUPPORT WAS REMOVED IAW SRM 51-10-3, PAR 26 AND ERA/ 511165-14, MAR REV B, DOUBLER TO REPAIR WAS FABRICATED IAW SRM 53-SDR DALA2015041002731Door Frame · corrodedCORROSION ON LOWER DOOR JAMB BEAM PAN, RT LONGERON PROJECTION 28 FS Y=373 TO Y=423 . LOWER DOOR JAMB WAS REMOVED IAW SRM 51-30-2 AND 51-30-5. NEW LOWER DOOR WAS INSTALLED IAW 51-30-2 AND 51-30-5, LP 1897718.SDR DALA2015041002730Door Frame · corrodedCORROSION ON LOWER DOOR JAMB EXISTING DOUBLER REPAIR AT RT LONGERON PROJECTION FS Y=640 TO Y=690, C2. REPAIR DOUBLER DOOR JAMB WAS REPAIRED, TREATED, PAINTED AND INSTALLED IAW SRM 53-05, FIG 123, 51-10-3, PAR 21, 14, 38, 51-30-5 AND 51-30-4.SDR DALA2015041002729Skin · corrodedCORROSION ON DOUBLER REPAIR BETWEEN RT LONGERON PROJECTION 27 AND 26 FS Y=368 AND Y=428 AT DOOR JAMB C1. DOUBLERS WERE REMOVED IAW SRM 51-30-5. NEW DOUBLERS WERE INSTALLED IAW SRM 51-30-5.SDR DALA2015040902727Battery Pack · inoperativeDURING CHECK, MAINTENANCE FOUND THE CEILING EMERGENCY LIGHTS WERE INOPERATIVE FORWARD OF THE L2 DOOR. MAINTENANCE REPLACED THE BATTERIES AND THE OPS CHECK WAS GOOD.SDR DALA2015040902726Cusp Web · corrodedCORROSION ON REPAIR DOUBLER OF CUSP WEB BETWEEN FS Y= 605 TO Y= 611 AND X= 54 TO X= 60 LT SIDE. DOUBLER WAS REMOVED IAW SRM 51-30-2. REPAIR PARTS WERE INSTALLED IAW SRM 51-30-2. LP 1896793.SDR DALA2015040902725Longeron Splice · corrodedCORROSION ON LONGERON SPLICE 28LT BETWEEN FS Y= 1195 AND Y=1210 AT AFT CARGO COMPARTMENT, C3. LONGERON SPLICE 28LT BETWEEN STA Y=1195 AND Y= 1210 WAS REPLACED IAW SRM 51-30-5 AND DWG 5936667, REV CD. LP 1896485.SDR DALA2015040902714Access Panel · corrodedCORROSION ON HOLE COUNTERSINKS AND FAYING SURFACE AT RT FUEL TANK ACCESS PANEL 1464C. RT FUEL TANK ACCESS PANEL 1464C WAS REPLACED. LP 1896745.SDR DALA2015040902713Access Panel · corrodedCORROSION ON HOLE COUNTERSINKS AND FAYING SURFACE AT RT FUEL TANK ACCESS PANEL 1476C. ACCESS PANEL 1476C OF RT FUEL TANK WAS REPLACED. LP 1896741.SDR DALA2015040902712Access Panel · corrodedCORROSION ON HOLE COUNTERSINKS AND FAYING SURFACE AT RT FUEL TANK ACCESS PANEL 1478C. RT FUEL TANK ACCESS PANEL 1478C WAS REPLACED.SDR DALA2015040902711Access Panel · corrodedCORROSION ON HOLE COUNTERSINKS AND FAYING SURFACE AT RT FUEL TANK ACCESS PANEL 1454C. RT FUEL TANK ACCESS PANEL 1454C WAS REPLACED. LP 1896715.SDR DALA2015040902710Longeron · crackedCRACKED LONGERON 4R STA Y= 1437 AT AFT ACCESSORIES COMPARTMENT, SM. LONGERON WAS REPARED IAW SRM 51-30-2, 51-10-4, 51-10-3 PAR 14 AND 21, 51-30-5 53-02, FIG 18. LP 1896678.SDR DALA2015040902709Longeron · crackedCRACKED LONGERON 3L FS Y=1437 AT AFT ACCESSORIES COMPARTMENT, SM. LONGERON WAS REPARED IAW SRM 51-30-2, 51-10-4, 51- 10-3 PAR 14 AND 21, 51-30-5 53-02, FIG 18. LP 1896673.SDR DALA2015040902708Longeron · crackedCRACKED LONGERON 3R, FS Y= 1437 AT AFT ACCESORIES COMPARTMENT, SM. LONGERON WAS REPAIRED IAW SRM 51-30-2, 51-10-4, 51-10-3 PAR 14 AND 21, 51-30-5 53-02, FIG 18. LP 1896669.SDR DALA2015040902707Access Panel · corrodedCORROSION ON HOLE COUNTERSINKS AND FAYING SURFACE AT RT FUEL TANK ACCESS PANEL 1470C IN REF CARD 5, ZONE 10. RT FUEL TANK ACCESS PANEL 1470C WAS REMPLACED. LP 1896585.SDR DALA2015040902706Floor Panel · corrodedCORROSION ON FLOOR PANEL 160G, W1. FLOOR PANEL WAS REPLACED IAW DWG 9957828, REV AB AND 51-10-3, PAR 14, 21.SDR DALA2015040902705Doubler · crackedCRACK OF 1.250" ON INTERNAL PRODUCTION DOUBLER FS Y=427 BETWEEN LONGERON 25-26 RT ON LOWER AFT CORNER AT FWD CARGO DOOR JAMB. PARTS WERE REMOVED IAW SRM 51-30-2, DAMAGE WAS REMOVED IAW SRM 53-05, FIG 105, WERE FABRICATED PARTS REPAIR, IAW SRM 53-05, FIG 105, SDR DALA2015040902704Cusp Web · corrodedCRACK ON RT CUSP WEB STA Y=844 BETWEEN X=-54 TO X=-60 AT PAX CABIN. IN REF OR NRC 102 AC ZONE 201. DAMAGE WAS REMOVED, FABRICATED DOUBLER, DOUBLER AND FILLER TREATED AND PAINTED ALSO INSTALLED REPAIR PARTS IAW SRM 53-05, FIG 131A-14 AND SRM 51-10-3, PAR 14 ASDR DALA2015040902703Cusp Web · corrodedCORROSION ON DOUBLER REPAIR ON RT CUSP WEB BETWEEN X=-54 AND X=-60 STA Y=484-496, Y=720-729 AT PAX CABIN. MRB 53-037-02. DOUBLERS WERE REPLACED IAW SRM 51-30-1, 51-30-2, 51-30-5, 51-30-3, PAR 14, 21 & 38, 53-05, FIG 131A-6. LP 1896262.SDR DALA2015040902701Access Panel · corrodedCORROSION ON HOLE COUNTERSINKS AND FAYING SURFACE AT RT FUEL TANK ACCESS PANEL 1462C IN REF CARD 5, ZONE 10. AYP, CORROSION ON HOLES COUNTERSINK ACCESS PANEL 1462C WAS R & R IAW AMM 28-00-00-201. LP 1895956.SDR DALA2015040902700Door Frame · corrodedCORROSION ON LOWER DOOR JAMB EXISTING DOUBLER REPAIR AT RT LONGERON PROJECTION 28 BETWEEN STA Y=1209 AND 1158, C3. DOUBLER WAS REPLACED IAW SRM 51-30-5. LP 1895944.SDR DALA2015040902699Frame · corrodedCORROSION FRAME Y=1380 LWR SECTION AT AFT ACCESSORIES COMPARTMENT. FRAME TEE WAS REPLACED IAW SRM 51-30-2, 51-30-5, 51-10-4, 51-10-3, PARS 21, 14 & 38. LP 1895919.SDR DALA2015040802681Access Panel · corrodedCORROSION ON HOLE COUNTERSINKS AT RT FUEL TANK ACCESS PANEL 1456C. CORROSION ON HOLES COUNTERSINK ACCESS PANEL 1456C WAS R & R IAW AMM 28-00-00-201. LP 1895715.SDR DALA2015040802680Access Panel · corrodedCORROSION ON HOLE COUNTERSINKS AT LT FUEL TANK ACCESS PANEL 1363C. CORROSION ON HOLES COUNTERSINK ACCESS PANEL 1363C WAS R & R IAW AMM 28-00-00-201. LP 1895474.SDR DALA2015040802679Access Panel · corrodedCORROSION ON HOLE COUNTERSINKS LT FUEL TANK ACCESS PANEL 1365C. CORROSION ON HOLES COUNTERSINK ACCESS PANEL 1365C WAS R & R IAW AMM 28-00-00-201. LP 1895472.SDR DALA2016111108851Cusp Web · corrodedLEFT CUSP WEB CORROSION, BS 788-807, LBL 54 - 60. DAMAGE REMOVED, REPAIR INSTALLED.SDR DALA2015040902702Cusp Web · corrodedCORROSION ON LT CUSP WEB BETWEEN X=54 AND X=60 STA Y=598-712 AT PAX CABIN, SM. DAMAGE CUSP WEB WAS REMOVED AND NEW CUSP WEB WAS DRILLED, HOLES WERE TREATED AND PAINTED AND NEW CUSP WEB WAS INSTALLED IAW SRM 51-30-5, 51-30-1, 51-10-4 , 51-30-2 AND 51-10-3, PARSDR DALA2015040802697Floor Panel · debondedDISBONDED FIRST LAYER ON FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-01-201.SDR DALA2015040802685Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY PATHWAY CEILING LIGHTS FROM ROWS 23-25 OF THE CABIN WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERIES. OPS CHECK WAS GOOD.SDR DALA2015040802678Cusp Web · crackedCRACK ON RT CUSP WEB, FS Y=574-575 BETWEEN X=-54 TO X=-60 AT PAX CABIN. CRACK WAS REPAIRED IAW SRM 53-05, FIG 131A-14, 51-10-3, PAR 14, 21. LP 1895259.SDR DALA2015040802677Longeron · crackedCRACK ON LONGERON 2 LT AT FS Y=160 CABIN PASSENGER, SM, CARD 334 ZONE. SECTION ON LONGERON NR 2 LT DAMAGE WAS REMOVED. NEW SECTION ON LONGERON 2 LT WAS AJUSTED, DRILLED ALSO TREATED AND PAINTED NEW SECTION OF LONGERON AND SPLICE, WAS INSTALLED IAW SRM 51-10-SDR DALA2015040802676Longeron · crackedCRACK ON LONG 3 LT FS Y=160 AT PAX CABIN, CARD 10. DAMAGE SECTION ON LONGERON NR 3 LT WAS REMOVED. NEW SECTION LONGERON NR 3 LT WAS AJUSTED, AND DRILLED ALSO TREATED AND PAINTED NEW SECTION LONGERON AND SPLICE WAS INSTALLED IAW SRM 51-10-3, PAR 14 AND 21, ALSDR DALA2015040802675Cusp Web · crackedCRACK ON LT CUSP WEB E FS Y 278 BETWEEN X=54 TO X=60 AT PAX CABIN. CRACK WAS REPAIRED IAW SRM 53-05, FIG 131A-14, 51-10-3 PAR. 14, 21, 51-30-2. LP 1894794.SDR DALA2015040802674Intercostal · corrodedCORROSION ON INTERCOSTAL FROM STA Y=1147 TO Y= 1155 BETWEEN LONGERON 30-29 RT. INTERCOSTAL CLIPS AND SUPPORT WERE REMOVED IAW SRM 51-30-2 INTERCOSTAL WAS FABRICATED IAW DWG 936071 NEW INTERCOSTAL WAS TREATED AND PAINTED IAW SRM 51-10-3, PAR 21 AND 14 INTERCSDR DALA2015040802672Rub Strip · debondedDISBONDED FWD LT RUB STRIPS BETWEEN STA Y=731 TO Y=826 SM. RUBSTRIP DAMAGES WERE REMOVED, NEW RUBSTRIPS WERE FABRICATED, AREA WAS CLEANED. NEW RUBSTRIPS WERE TREATED AND PAINTED AND NEW RUBSTRIPS WERE BONDED IAW ER/A: 479444-14MA, REV E. LP 1894351.
Back to Mcdonnell Douglas MD-88