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 DALA2016040902748Seat Track · corrodedCORROSION ON SEAT TRACK PLUGS BS 316-982 AT X=22. SEAT TRACK PLUGS REPLACED IAW SRM 51-30-1, 53-05, FIG 4A, SH 1 AND 51-10-3, PAR 38.SDR DALA2016040902747Cusp Web · corrodedCORROSION ON RT CUSP WEB PREVIOUS REPAIR BETWEEN BS 996 AND X=-54 TO X=-60. REMOVE AND INSTALLED REPAIR PARTS ON RT CUSP WEB BETWEEN BS 996 AND X=-54 TO X=-60 IAW SRM 51-30-3 AND 51-30-2.SDR DALA2016040902751Skin · crackedCRACKED EXTERNAL REPAIR DOUBLER FWD LOWER CORNER AT PASSENGER ENTRANCE DOOR. REPAIR DOUBLER WAS REPLACED IAW SRM 51-30-2, 52-05D FIG 37, 51-10-3, PAR 14/21.SDR DALA2016040802706Engine · malfunctionedTHE CREW PERFORMED AN AIR TURN BACK DUE TO WINDSHEAR AND SUBSEQUENT DUAL ENGINE OVERSPEED. THE CAPTAIN FIREWALLED BOTH ENGINES AND BOTH WENT TO 2.2 EPR FOLLOWED BY COMPRESSOR STALLS AND AN ODOR IN THE CABIN. DURING INITIAL CLIMB-OUT CAPTAIN NOTICED AIRSPEED DESDR DALA2016040802712Tab · damagedLEFT ELEVATOR ANTI-FLOAT TAB HAS LIGHTNING STRIKE. REPLACED TAB IAW AMDS CARD 2730-4382.SDR DALA2016040802710Spar · damagedLEFT WING LOWER AFT SPAR, VERTICAL LEG BS 154-164 HAS 14 HOLES MIS-DRILLED, ELIPITICAL. ACCOMPLISHED REWORK OF HOLES 14EA IAW ER/A 544925-14AD.SDR DALA2016040802705Cusp Web · puncturedPUNCTURED RT CUSP WEB BETWEEN BS 484-492 AND X=-44 TO X=-54. PUNCTURED ON RT CUSP WEB WAS REPAIRED IAW SRM 51-30-2, 51-10-3 PAR 19 AND 21 AND 38, 53-05, FIG 131A-17.SDR DALA2016040802704Spar · crackedLT REAR SPAR SHOWS A CRACK INDICATION OF 0.100" IAW NDT SPM 06-01.001 AT THE 5:30 POSITION. CRACK VERIFIED LESS THAN 1". PERFORMED REPAIR IAW DWG JO60271.SDR DALA2016040802703Bushing · corrodedCORROSION ON INNER SURFACE OF FITTING BUSHING RT MLG. CORROSION ON BUSHING BORE RT WAS REMOVED IAW DWG SR 09570087, REV B, NOTE II, MEASURE AFTER REWORK ID 2.337", THEREFORE IS WITHIN LIMITS FOR REPAIR IAW DWG SR09570087, REV: B, NOTE II.SDR DALA2016040802701Support Fitting · corrodedCORROSION ON RETRACT ACTUATOR SUPPORT FITTING BORE AND OTBD FACE AT LT MLG. THIS REPAIR WAS PERFORMED IAW ER/A 543221-14AD, REV ORIGINAL.SDR DALA2016040802700Skin · delaminatedDELAMINATED UPPER, LOWER SKIN ON LT ELEVATOR GEARED TAB. GEARED TAB WAS REPLACED AND LEVATOR GEARED TAB WILL BE INSTALLED AND ADJUSTED UNDER CARD 2730-4334.SDR DALA2016040902749Cusp Web · corrodedCORROSION ON CUSP WEB PREVIOUS REPAIR FROM BS 984-1003 BETWEEN X=54-X=60 LT SIDE. CUSP WEB PREVIOUS REPAIR WAS REPLACED IAW SRM 51-30-5 AND 53-05, FIG 131A-14.SDR DALA2016040802711Cam · looseTAILCONE JETTISON CAM ASSY LOOSE. RIGGED JETTISON CAM IAW AMM 53-50.SDR DALA2016040702699Skin · damagedLIGHTNING STIKE RT WING TIP JUST INBD OF AFT POSITION LIGHT. REPAIRED, BLENDED AREA IAW SRM 57-03D, FIG 1, PG 5.SDR DALA2016040702696Pan · crackedCRACKED ON FWD PAN EXTERNAL FACE JUST AROUND BLIND NUT BETWEEN BEAM 2 AND 3 AT AFT CARGO COMPARTMENT DOOR. FWD PAN EXTERNAL WAS REPAIRED IAW ETI-88-16-139 REV 1 AND ERA 545083-14 REV ORIG.SDR DALA2016040702695Skin · crackedCRACK ON MID CARGO COMPARTMENT DOOR SKIN NEXT TO OPEN, CLOSE HANDLE HSG MID CARGO COMPARTMENT DOOR SKIN WAS REPAIRED IAW ER/A 486446, MA REV ORIGINAL.SDR DALA2016040702694Doubler · wornWORN PREVIOUS REPAIR DOUBLERS ON AFT AND FWD LOWER CORNER AT FWD CARGO COMPARTMENT DOOR. REPAIR DOUBLERS WERE REPLACED IAW SRM 51-30-2 AND ER/A 486624-14 REV ORIGINAL.SDR DALA2016040702693Vane · wornWEAR ON OTBD AFT CORNER OF RT WING OTBD FLAP INBD GUIDE VAVE LOWER SURFACE BS XV1=211 CANT. OTBD AFT CORNER OF RT WING OTBD FLAP INBD GUIDE VANE LOWER SURFACE BS XVI=211 WAS REPAIRED IAW ER/A 521198-14MA, REV ORIGINAL.SDR DALA2016040702691Skin · corrodedCORROSION WAS FOUND ON 7 FASTENER HOLES COMMON TO THE RT LOWER WING SKIN AND THE ACCESS DOOR CUTOUT, AT THE BS XRS 196, 197, 198.5, 200.5, 206, 207 AND 209 BETWEEN STR 12 AND 15. HOLES WERE REPAIRED IAW ER/A 543214-14AD, REV ORIGINAL.SDR DALA2016040702689Seat Track · corrodedCORROSION ON SEAT TRACK PLUG BS 419 TO 422, 455 TO 458, 671 TO 674, 701 TO 703 AT X=54 ON CABIN PASSENGER PLUGS WERE REMOVED, NEW PLUGS WERE INSTALLED IAW SRM 51-30-1, 53-05 FIG 4A, SH 1.SDR DALA2016040702688Cusp Web · corrodedSEVERE CORROSION ON RT CUSP WEB BETWEEN BS 389-408 AND X=-54 TO X=-60. CUSPS WEB WERE REPAIRED IAW SRM 53-05, FIG 131A AND 51-10-3, PAR 14, 21, 38.SDR DALA2016040702687Seat Track · corrodedCORROSION ON RT SEAT TRACK PLUG X=-22 BETWEEN BS 1231 TO 1212. PLUG WAS REMOVED. NEW PLUG WAS INSTALLED IAW SRM 51-30-1, 53-05, FIG 4A, SH1.SDR DALA2016040702686Tab · delaminatedDELAMINATED ON INBD AT ANTI-FLOAT TAB UPPER, LOWER SURFACE LT ELEVATOR. DUE TO EXCESSIVE DAMAGE REPLACED IAW SRM 55-04, PAR 2C.SDR DALA2016040702685Cusp Web · corrodedSEVERE CORROSION ON RT CUSP WEB BETWEEN BS 370-389 AND X=-54 TO X=-60. DAMAGE WAS REPAIRED IAW SRM 53-05, FIG 131A AND 51-30-2, 51-10-3 PAR 14 AND 21.SDR DALA2016040702684Pan · crackedCRACK ON RING PAN AFT LOWER CORNER BETWEEN BS 237-258 LT AT PASSENGER CABIN. FASTENERS AND DAMAGE WERE REMOVED, WAS PERFORMED IAW SRM 06-10-01-001. NO CRACKS. REPAIR PARTS WERE FABRICATED AND INSTALLED IAW SRM 51-30-2, 51-30-5, 53-05, FIG 122.SDR DALA2016040702683Pan · crackedCRACK ON RING PAN STRUCTURE UPPER FWD AND LOWER AFT CORNERS BETWEEN BS 788 AND BS 769 LT SIDE. DAMAGE AND FASTENERS WERE REMOVED, WAS PERFORMED IAW NDT SPM 06-10-01-001, WO CRACKS. REPAIR PARTS WERE FABRICATED AND INSTALLED IAW SRM 51-30-5, 51-30-2, 53-05, SDR DALA2016040702682Pan · crackedCRACK ON RING PAN FWD UPPER CORNER BETWEEN BS 351-370 RT AT PASSENGER CABIN. FASTENERS AND DAMAGE WERE REMOVED REPAIR PARTS WERE FABRICATED. REPAIR PARTS WERE INSTALLED IAW SRM 53-05, FIG 122, 51-30-2, 51-30-5.SDR DALA2016040702681Pan · crackedCRACK ON RING PAN FWD UPPER CORNER BETWEEN BS 617-636 RT AT CABIN PAX. FASTENERS AND DAMAGE WERE REMOVED REPAIR PARTS WERE FABRICATED REPAIR PARTS WERE INSTALLED IAW SRM 53-05, FIG 122, 51-30-2, 51-30-5.SDR DALA2016040702680Pan · crackedCRACK ON RING PAN FWD UPPER CORNER BETWEEN BS 769-788 RT AT CABIN PAX. DAMAGE WAS REMOVED IAW SRM 53-05, FIG 122. REPAIR PARTS WERE FABRICATED IAW SRM 53-05, FIG 122. REPAIR PARTS WERE INSTALLED IAW SRM 51-30-5, 51-30-2.SDR DALA2016040702679Pan · crackedCRACK ON RING PAN AFT LOWER CORNER BETWEEN BS 294-275 LT AT CABIN PAX. FASTENERS AND DAMAGE WERE REMOVED IAW SRM 51-30-2 AND 53-05, FIG 122. REPAIR PARTS WERE FABRICATED ANS INSTALLED IAW SRM 51-30-5, 51-30-2.SDR DALA2016040702678Pan · crackedCRACK ON RING PAN FWD UPPER CORNER BETWEEN BS 788-807RT CABIN PASSENGER. FASTENERS AND DAMAGE WERE REMOVED, REPAIR PARTS WERE FABRICATED, REPAIR PARTS WERE INSTALLED IAW SRM 53-05, FIG 122, 51-30-2, 51-30-5.SDR DALA2016040702677Pan · crackedCRACK ON RING PAN FWD UPPER CORNER BETWEEN BS 655-674, RT AT CABIN PASSENGER DAMAGE AND FASTENER WERE REMOVED IAW SRM 53-05, FIG 122 AND 51-30-2.SDR DALA2016040502665Csd · overservicedCREW NOTED THE LOSS OF ELECTRICAL POWER WHILE CLIMBING OUT. THE RT ENGINE GENERATOR TRIPPED OFF LINE AND WOULD NOT RESET AND THE APU GENERATOR WOULD NOT PICK UP POWER. THE FLIGHT WAS RETURNED. PERFORMED EMERGENCY LANDING AND ALTERNATE GEAR EXTEND. LEFT GENSDR DALA2016040902746Pan · crackedCRACKED PAN ABOVE FRAME NR 4 FROM AREA AT R1 DOOR. PAN WAS REPAIRED IAW SRM 52-03 D FIG. 3.SDR DALA2016040702690Pan · crackedCRACK ON RING PAN STRUCTURE AT UPPER FWD CORNER BETWEEN BS 788 AND 807 ALSO UPPER FWD CORNER BETWEEN BS 807 AND 826 LT SIDE. RING PAN WERE REPAIRED IAW SRM 53-05, FIG 122, 51-30-2 AND 51-30-5 CRACK LONG WAS 0.125" HFEC WAS PERFORMED NO CRACKS WERE FOUND AFTERSDR DALA2016040602663Hinge · damagedLT FLAP HINGE INBD HOLE. CIRCUMVENTIAL SEMI-CIRCLE WORN, GOUGE ON WING SPAR FLANGE. R & R FLAP HINGE FITTING IAW AMM 57-40-01.SDR DALA2016040602662Structure · crackedREMOVE INBD FLAP HINGE FITTING FOR LT WING OTBD FLAP TO DETERMINE CRACK LENGTH. FLAP FITTING IS LOCATED ON AFT WING SPAR BS 164. MEASURED AND MARKED ENDS OF CRACK IAW NDTSPM 06-10-01.001. CRACK MEASURES .625 IN LENGTH. INSTALLATION OF INBD FLAP FITTING TO SDR DALA2016040602661Pan · crackedCRACKED OTBD PAN, OTBD FACE BETWEEN PROJECTION BEAM 1 AND 2, AND MECHANISM CAM AT FWD CARGO COMPARTMENT DOOR. PAN WAS REPAIRED IAW ETI-88-16-126, REV 1 AND ERA 543220-14 REV ORIGINAL.SDR DALA2016040702692Skin · wornWEAR ON UPPER SKIN T/E OF OTBD VANE OTBD FLAP BS XV2-297 CANT AT LT WING. WEAR ON UPPER SKIN T/E OF OTBD VANE OTBD FLAP BS XV2=297 LT WING WAS REPAIRED IAW ERA 521199-14MA REV ORIGINAL.SDR DALA2016040502664Strut · corrodedNLG SHOCK STRUT HAS CORROSION IN INNER BORE RT SIDE AXLE AREA. SEE NR FOR ADDITIONAL INFORMATION 006-0001:3230-5003/002 00003. REPLACED NLG SHOCK STRUT IAW AMM 32-21-02 AND REPLACED SEALS IAW AMDS CARD 3221-6192.SDR DALA2016040502660Connector · unsecureMAINTENANCE FOUND THE EMERGENCY PATH LIGHT AT SEAT ROW 17DE INOPERATIVE. MAINTENANCE RESECURED THE SEAT CONNECTOR. THE EMERGENCY PATH LIGHT CHECKED OK.SDR DALA2016040502659Connector · unsecureCVG MAINTENANCE FOUND THE EMERGENCY PATH LIGHT AT SEAT ROW 1CD INOPERATIVE. MAINTENANCE RESECURED THE SEAT CONNECTOR. THE EMERGENCY PATH LIGHT CHECKED OK.SDR DALA2016040502658Doubler · crackedCRACKED PREVIOUS REPAIR DOUBLER ON FUSELAGE SKIN BETWEEN BS 101 TO BS 110 AND PROJECTION LONGERON 27LT. DOUBLER WAS REPLACED IAW SRM 53-05, FIG 158, 51-30-2, 51-30-5, 51-30-11 AND 51-10-3 PAR 14 AND 21.SDR DALA2016040502656Doubler · crackedCRACKED PREVIOUS REPAIR DOUBLER ON FUSELAGE SKIN BS 99 AND PROJECTION OF LONGERON 28R. DOUBLER WAS REPLACED IAW SRM 53-05, FIG 158, 51-30-2, 51-30-5.SDR DALA2016041402910Cusp Web · crackedCORROSION ON LT CUSP WEB, OUT LIMITS, BETWEEN BS 674 TO 693. CORROSION OUT LIMITS WAS REPAIRED IAW SRM 53-05, FIG 131A-14 51-30-5, 51-30-2, 51-10-3 PAR 14, 21, 26, 38.SDR DALA2016041102768Battery Pack · inoperativeMAINTENANCE FOUND THE AFT SECTION OF ACFT EMERGENCY LIGHTS INOPERATIVE. BATTERY PACK B5-107 WAS REPLACED AND THE LIGHTS CHECKED OK.SDR DALA2016041102767Battery Pack · inoperativeMAINTENANCE FOUND THE EMERGENCY LIGHTS INOPERATIVE IN THE MID CABIN SECTION. BATTERY PACK B5-101 WAS REPLACED AND THE LIGHTS CHECKED OK.SDR DALA2016040402524Line · looseSTRONG JET FUEL ODOR IN AIRPLANE AFTER STARTING APU GROUND PERSONNEL POINTED OUT FUEL FROM LT SIDE OF ACFT. FOUND RT WHEEL WELL UPPER AFT FUEL LINE IN SHROUD UNSAFTIED AND LOOSE. RESECURED LINE IAW AMM 28-20. REINST SHROUD IAW AMM 28-20.SDR DALA2016040402520Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENTAREAOF FUEL ACCESS PLATE NR 1303C AND 1409C. FUEL ACCESS PLATE NR 1303C AND 1409C WERE REPLACED IAW SRM 51-22-2A CONDTION III.SDR DALA2016040402519Channel · crackedCRACK ON PREVIOUS REPAIR AND CHANNEL FLOOR PANEL 927E. FLOOR PANEL 927E WAS REPLACED IAW SRM 51-10-4 AND 51-10-3, PAR 21 AND 14.
Back to Mcdonnell Douglas MD-88