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 DALA2015061203825Doubler · corrodedCORROSION ON PREVIOUS REPAIR DOUBLER ON OTBD FUSELAGE SKIN BETWEEN BS 760 - 778 AND LONGERON 27 - 28 RT. DOUBLER WAS REPLACED IAW ER/A 331081-14, REV A AND SRM 51-30-2 AND 51-30-5.SDR DALA2015061403799Skin · crackedA CRACK WAS FOUND ON FWD ENTRY DOOR SKIN NEXT TO HANDLE HOUSING RUBSTRIP. THE FWD ENTRY DOOR SKIN WAS REPAIRED IAW ER/A 501106-14, REV B.SDR DALA2015061103774Apu · odorCREW PERFORMED AN ATB AT FL130 DUE TO THE F/A REPORT OF HAZE IN AFT CABIN. ACCOMPANIED BY THE AFT LAVATORY SMOKE DETECTORS SOUNDING. MAINTENANCE INSPECTED ENGINES AND APU FOR OIL LEAKS. NONE FOUND. PERFORMED DUCT BURNOUT PROCEDURE TWICE. NO FURTHER FUMES SDR DALA2015061503771Access Panel · corrodedCORROSION ON COUNTERSINK SETTLEMENT AREA AND UPPER SURFACE ON FUEL ACCESS PANEL 1409C ON THE RT WING. THE ACCESS PANEL WAS REPLACED IAW SRM 51-22-2A.SDR DALA2015061203770Rib · corrodedCORROSION FOUND ON LT WING SLAT PANEL RIB HOLES XOS=580. THE RIB WAS REMOVED IAW SRM 51-30-2 AND 51-30-8. A NEW RIB WAS DRILLED IAW SRM 51-10-4, TREATED AND PAINTED IAW SRM 51-10-3, PAR 14/21 AND INSTALLED IAW SRM 51-30-2 AND 51-30-8.SDR DALA2015061203769Skin · crackedCRACKED INNER SKIN ON RT WING SLAT XOS=240.081. CRACK WAS FOUND .312 IN LENGTH IAW NDT SPM 06-10-01.001. DOUBLER REPAIR AND FILLER WERE FABRICATED IAW SRM 57-01,FIG 5, SHEET 2. REPAIR TREATED AND PAINTED IAW SRM 51-10-3, PAR 14/21. REPAIR INSTALLED IAW SRMSDR DALA2015061103768Longeron · corrodedCORROSION ON LONGERON 22L BS 1338 IN AFT CARGO BAY. REPLACED THE LONGERON IAW SRM 51-30-5.SDR DALA2015061103767Stiffener · crackedCRACK ON LOWER ANGLE OF AFT PRESSURE BULKHEAD STIFFENER X-54 AND Z 62. THE ANGLE WAS REPLACED IAW SRM 51-30-1, 51-30-5, 51-10-4, 51-10-3 PAR 21 - 14, AND DWG 9915558, REV BA.SDR DALA2015090105369Skin · crackedINSPECTION OF LOWER SKIN FOUND CRACKED AT S17. REPAIRED IAW SECTION I OF ER/A 536836-14 .SDR DALA2015071004246Release Cable · wornMAINTENANCE DISCOVERED THAT THE LT RELEASE LATCH CABLE FOR THE TAILCONE WAS WORN OUT OF ALLOWABLE LIMITS. THE CABLE WAS REPLACED AND THE SYSTEM WAS RIGGED TO SPECIFICATIONS. THE FUNCTIONAL CHECK WAS COMPLETED SATISFACTORILY.SDR DALA2015061703836Slide · misinstalledINSPECTION DISCOVERED THAT THE EMERGENCY ESCAPE SLIDE IN THE TAILCONE WAS NO LONGER IN AN ACCEPTABLE CONFIGURATION. MISRIGGED, IMPROPERLY INSTALLED STRAP FOR THE SLIDE COVER WOULD PREVENT PROPER DEPLOYMENT OF THE ESCAPE SYSTEM AND IS NOT IN COMPLIANCE WITH 1SDR WX0A2015061572655Unknown · odorSMELL RESEMBLING BURNT WIRES OR SMOKE IN FWD CARGO, COULD NOT DUPLICATE FAULT. OPERATIONS CHECKED GOOD IAW AMM 05-10. ACCOMPLISHED TASK CARD 21-059-002 STEP C.SDR DALA2015061103766Skin · damagedLIGHTNING STRIKE ON FUSELAGE SKIN BS 607.437 LONGERON 9L. AREA OUT LIMITS AND WAS REPAIRED IAW SRM 53-04-2, FIG 2, SH 3.SDR DALA2015061103765Door Frame · crackedCRACKED FWD CARGO DOOR OUTER PANE UNDER ANGLE GUIDE. BETWEEN BEAMS NR 1 AND 2. IN REF ORNRC 113, ZONE 100, CARD 259, ZONE 100. CRACK ON OUTER PAN WAS STOP DRILLED AND REPAIRED IAW SRM 52-05D, FIG 26A.SDR DALA2015061103764Skin · corrodedCORROSION ON RIB HOLES AT RT WING SLAT PANEL NR 5 STA XOS=580, RW, SH-CP-SM, CARD 2 ZONE 012. SKIN AND STRUCTURE, NEW RIB WAS DRILLED, TREATED AND PAINTED, INSTALLED AND SKIN AND STRUCTURE WERE INSTALLED AND REMOVED IAW SRM 51-30-2, 51-10-4, 51-10-3, PAR 14/2SDR DALA2015061203757Wire Harness · damagedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTING AT SEAT 21DE IN THE CABIN WAS INOPERATIVE. MAINTENANCE REPLACED THE WIRE HARNESS AND THE SYSTEM RETURNED TO NORMAL OPERATION.SDR DALA2015061103756Intercostal · corrodedCORROSION ON INTERCOSTAL STA Y=769-788 BETWEEN LONGERONS 27-28RT. THE INTERCOSTAL WAS REPLACED IAW DWG 9915554, REV J, SRM 51-10-4, 51-30-1, 51-30-2, 51-30-5, AND 51-10-3 PAR 14-21.SDR DALA2015061103754Frame · crackedCRACKED FRAME ANGLE BS 1437 BETWEEN LONGERON 12-13R IN AFT ACCESSORY COMPTARTMENT. FRAME CLIP WAS FABRICATED IAW SRM 53-14-4 FIG 3, SHEET 4 AND INSTALLED IAW SRM 51-30-2.SDR DALA2015061103753Doubler · corrodedCORROSION ON PREVIOUS REPAIR ON OTBD FUSELAGE SKIN BETWEEN BS 803 - 814 BETWEEN LONGERON 28 - 30 RT. PREVIOUS REPAIR WAS REPLACED IAW ER/A 331097-14, REV A.SDR DALA2015061103752Doubler · corrodedCORROSION ON PREVIOUS REPAIR DOUBLER ON OTBD FUSELAGE SKIN BETWEEN BS 781 - 797 AND LONGERONS 28 - 29R. DOUBLER WAS REPLACED IAW ER/A 331081-14, REV A.SDR DALA2015061103750Beam · corrodedCORROSION ON LOWER FWD FLANGE BS 652-671 AND VERTICAL FACE BS 644 AT MID CARGO COMPARTMENT DOOR FRAME BEAM REF ORNRC 154 ZONE 100 MRB 53-018-02, CARD 219, ZONE 100. MID CARGO DOOR JAMB BEAM WAS REPAIRED IAW SRM 53-05, FIG 123A, OPTION 2 AND ER/A 534411-14 REVSDR DALA2015061103743Skin · damagedLIGHTNING STRIKE ON FUSELAGE SKIN BS 562.375 AND LONGERON 10 LT. THE SKIN WAS REPAIRED IAW SRM 53-04-2, FIG 2. DOUBLER WAS TREATED AND PAINTED IAW SRM 51-10-3. DOUBLER WAS INSTALLED IAW SRM 53-04-2, FIG 2.SDR DALA2015061103742Cusp Web · corrodedCORROSION ON RT CUSP WEB BETWEEN X=-54 TO -60 AND BS 1098 - 1117, 1136 - 1155, 1155 - 1174, 1174 - 1193, 1193 - 1212 AT PAX CABIN FLOOR STRUCTURE. CUSP WEB REMOVED IAW SRM 51-30-2, 51-30-5. A NEW CUSP WEB WAS DRILLED IAW SRM 51-10-4 & DWG 9930612, REV, THESDR DALA2015061103741Skin · damagedDAMAGE METALIZED COAT ON SKIN PANEL LT/RT SIDE AT RUDDER VERTICAL STABILIZER. METALIZED COAT ON SKIN PANEL LT/RT SIDE AT RUDDER VERTICAL STABILIZER WERE REPAIRED IAW SRM 51-70-1A, PAR 23.SDR DALA2015061103740Longeron · corrodedCORROSION ON LONGERON 23L BETWEEN BS 1136 - 1250. THE LONGERON WAS REPLACED IAW SRM 53-01 FIG 18 51-30-2, 51-30-5, AND 51-10-3, PAR 38.SDR DALA2015061103670Compressor · stalledTHE NR 1 ENGINE EXPERIENCED A COMPRESSOR STALL AFTER TAKEOFF. THE NR 1 ENGINE WAS SHUTDOWN AND AN AIR TURNBACK WAS ACCOMPLISHED. MAINTENANCE REPLACED THE NR 1 ENGINE AND THE ACFT HAS RETURNED TO SERVICE.SDR DALA2015061203758Wire · brokenDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTING AT SEAT 24D IN THE CABIN WAS INOPERATIVE. MAINTENANCE FOUND A BROKEN WIRE IN THE UNDERSEAT HARNESS. THE WIRE HARNESS WAS REPAIRED AND THE SYSTEM RETURNED TO NORMAL OPERATION. LP 7126129.SDR DALA2015061103751Intercostal · crackedCRACKED INTERCOSTAL Y=37 AND X=11, X=-11 AT NLG WHEEL WELL. LT INTERCOSTAL WAS REPAIRED IAW 51-01, PAR 4, STEP 21 AND DOUBLER WAS FABRICATED IAW SRM 53-14-1, 51-10-2, DOUBLER WAS TREATED AND PAINTED IAW SRM 51-10-3, PAR 21/14.SDR DALA2015061003734Longeron · crackedCRACK ON LONGERON 20L BS 1003. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 22, 51-30-3, 51-10-3 PAR 14, 21, 38.SDR DALA2015061003733Longeron · crackedCRACK ON LONGERON 20R BS 1003. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 22, 51-30-5, 51-10-3 PAR 14,21,38.SDR DALA2015061003732Vane · damagedSEVERAL NICKS ON PREVIOUS REPAIR DOUBLER AT NR 1 FLAP VANE. THE PREVIOUS DOUBLER WAS REPLACED IAW SRM 57-03D, PAR 11.SDR DALA2015061003731Frame · corrodedCORROSION ON FRAME CAP BS 1380 BETWEEN LONGERONS 24L-24R. THE FRAME TEE WAS REPLACED IAW SRM 51-30-2, 51-30-5, 53-14-4.SDR DALA2015061003729Access Panel · corrodedCORROSION ON COUNTERSINK OF FUEL ACCESS PANEL 1466C AT RT WING. CORROSION WAS REMOVED IAW SRM 51-22-2A AND COUNTERSINK HOLES WERE MEASURED MAX DIAMETER ALLOWABLE IS 0.660" AND MAX DIAMETER MEASURED IS 0.670" IN 3 ADJACENT HOLES THEREFORE OUT OF LIMITS IAW SRMSDR DALA2015061003728Shear Tie · crackedSHEAR TIE BS 1437 BETWEEN LONGERONS 16 - 17R IS CRACKED. THE SHEAR TIE WAS REPLACED IAW SRM 51-30-2 AND 51-30-5.SDR DALA2015061003727Shear Tie · crackedSHEAR TIE ON BS 1446 LONGERONS 17 - 18L IS CRACKED. THE SHEAR TIE WAS REPLACED IAW SRM 53-14-4, FIG. 3.SDR DALA2015061003739Longeron · crackedCRACKED LONGERON NR 13R IN AFT ACCESSORY COMPARTMENT BS 1380. THE LONGERON WAS REPLACED IAW SRM 53-14-14, FIG 2, ITEM 4 AND 51-30-2, 51-30-5.SDR DALA2015061003736Tab · dentedDENT ON ANTI-FLOAT TAB UPPER SURFACE AT RT ELEVATOR. ANTI-FLOAT TAB WAS REPAIRED IAW SRM 55-04 PAR 2.SDR DALA2015061103696Wire · pulledDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTING AT SEAT 26D IN THE CABIN WAS INOPERATIVE. MAINTENANCE FOUND WIRES PULLED OUT OF THE LIGHT SOCKET. THE LIGHT ASSEMBLY WAS REPLACED AND THE SYSTEM RETURNED TO NORMAL OPERATION.SDR DALA2015061003688Skin · corrodedCORROSION ON BARREL NUT HOLE NR 13 AT LT HORIZONTAL STABILIZER STA XH=6.625. DAMAGE ON BARREL NUT HOLE WAS REPAIRED IAW ETI-88-15-173, REV 1 AND ER/A 534422-14, REV ORIGINAL.SDR DALA2015061003687Longeron · corrodedCORROSION ON LONGERON 20L BETWEEN BS 1287 TO 1297. THE LONGERON WAS REPLACED IAW SRM 51-30-2, 51-30-5, AND 53-14-3.SDR DALA2015061003686Cusp Web · crackedCRACK ON RT CUSP WEB BETWEEN BS 1244 TO 1250, X=-56 TO X=-60. CUSP WEB WAS REPLACED IAW SRM 51-30-1, 51-30-2, AND 51-30-5.SDR DALA2015061003685Panel · corrodedCORROSION ON RIB HOLES XOS= 610 AT LT WING SLAT PANEL NR 5. CORROSION ON RIB HOLES STA XOS= 610 AT LT WING SLAT PANEL NR 5 WAS REMOVED, REPAIR BUSHINGS WERE FABRICATED AND INSTALLED IAW SRM 57-02, PAR 9.SDR DALA2015062203890Floor Panel · damagedDAMAGE ON FERRUL AND PUNCTURE ON PAX CABIN FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201 AND INSTALLED IAW AMM 53-20-01-201.SDR DALA2015061103711Battery Pack · inoperativeDURING LINE CHECK FOUND TAIL COMPARTMENT EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BATTERY PACK. OPS CHECKED NORNMAL IAW AMM 33-53-00.SDR DALA2015061003737Rib · corrodedCORROSION ON RIB HOLE, STA XIS=136 AT LT WING SLAT PANEL 1. CORROSION ON RIB HOLE STA 136 WAS REMOVED, WAS FABRICATED BUSING AND INSTALLED IAW SRM 57-02, PAR. 9C, 1, 2.SDR DALA2015060803697Duct · disconnectedF/A REPORTED SMOKE BUILDING IN THE AFT CABIN ON FINAL APPROACH ACCOMPANIED BY THE AFT RT LAVATORY SMOKE DETECTOR IN ALARM. VISIBLE SMOKE WAS OBSERVED INSIDE LAVATORY SO THE F/A DISCHARGED THE PORTABLE FIRE EXTINGUISHER INTO THE AFT LAVATORY AND SECURED THE DOSDR DALA2015060903684Access Panel · corrodedCORROSION ON LT MAIN FUEL TANK ACCESS PANEL 1365C COUNTERSINK HOLES AND SETTLEMENT AREA. CORROSION WAS REMOVED, COUNTERSINKS WERE MEASURED, MAX DIAMETER ALLOWABLE IS 0.532" AND WERE FOUND SEVEN COUNTERSINKS OUT OF LIMITS. THE ACCESS PANEL WAS REPLACED IAW SSDR DALA2015060903683Longeron · crackedCRACKED LONGERON 16L, BS 1437. THE LONGERON WAS REPLACED IAW SRM 53-14-4, FIG 4 AND DWG 5910228, REV KF AND SRM 51-30-5.SDR DALA2015060903682Longeron · corrodedCORROSION ON LONGERON 30, BS 1332. REPLACED THE LONGERON IAW SRM 51-30-2, SRM 51-30-5, SRM 51-10-4, AND SRM 51-10-3 PARA 14 & 21.SDR DALA2015060903681Longeron · crackedCRACK ON LONGERON 8R AT BS 1309. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18, REPAIR PARTS WERE FABRICATED IAW SRM 53-02, FIG 18, REPAIR TREATED AND PAINTED IAW SRM 51-10-3, PARAGRAPHS 14, 21, REPAIR INSTALLED IAW SRM 53-02, FIG 18.
Back to Mcdonnell Douglas MD-88