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 DALA2017051803996Access Panel · corrodedCORROSION ON SETTLEMENT AREA ON THE FUEL TANK ACCESS PANEL 1379C. THE ACCESS PANEL WAS REPLACED IAW SRM 51-22-2A, PAR 6.SDR DALA2017051803995Doubler · corrodedCORROSION BELOW PRODUCTION DOUBLERS ON THE AFT CARGO DOOR. SKIN CORNERS REPAIRED IAW ER/A 558112-14, REV ORIGINAL, AND ETI-88-17-158, REV 1.SDR DALA2017051803994Access Panel · corrodedCORROSION ON COUNTERSINK ON FUEL TANK ACCESS PANEL 1361C. THE ACCESS PANEL WAS REPLACED IAW PAR 6, SRM 51-22-2A, CONDITION II.SDR DALA2017051803993Doubler · wornWEAR ON THE LOWER AFT & FWD DOUBLER CORNERS ON THE MID CARGO DOOR. THE DOUBLERS WERE REPLACED IAW SRM 51-30-2, AND DWG 5910141, REV FE.SDR DALA2017051803992Doubler · wornWEAR ON THE LOWER AFT & FWR DOUBLER CORNERS AT THE AFT CARGO DOOR. THE LOWER AFT & FWR DOUBLER CORNERS WERE REPLACED IAW SRM 51-30-2, AND DWG 5910141, FIG FE.SDR DALA2017051803991Tab · dentedDENTS ON THE RT GEARED TAB. THE TAB WAS REPAIRED IAW SRM 55-04, PAR 2.SDR DALA2017051803990Doubler · wornWEAR ON DOUBLER REPAIRS ON FUSELAGE SKIN BETWEEN BS 1485 - 1510, 5 O`CLOCK POSITION AT AFT ACCESSORY COMPARTMENT. DOUBLERS WERE REPLACED IAW SRM 53-01, FIG 2, SHEET 3, AND 51-30-2.SDR DALA2017051803989Skin · wornWEAR AROUND CUT OUT OF L1 DOOR HOOK ON FUSELAGE SKIN. THE SKIN WAS REPAIRED IAW SRM 53-04, FIG 24, 51-10-3, PAR 14, & 21, 51-30-2, 51-30-5, AND 51-10-4.SDR DALA2017051803988Seat Track · corrodedCORROSION ON THE SEAT TRACK RBL 54, BETWEEN BS 840 - 986. THE DAMAGE AREA WAS REPAIRED IAW SRM 53-05, FIG 4F.SDR DALA2017051803987Seat Track · damagedELONGATED HOLES ON THE RT SEAT TRACK LBL 54 BETWEEN BS 323 - 330. THE DAMAGED AREA WAS REPAIRED IAW SRM 53-05, FIG 4F.SDR DALA2017051803986Seat Track · damagedELONGATED HOLES ON THE RT SEAT TRACK LBL 54 BETWEEN BS 792 - 798. THE DAMAGE AREA WAS REPAIRED IAW SRM 53-05, FIG 4F.SDR DALA2017051803985Cusp Web · corrodedCORROSION THE ON CUSP WEB UPPER & LOWER SURFACES LBL 54 - 60, BETWEEN BS 579 - 665 ,AND BS 681 - 704, IN THE PAX CABIN. THE CUSP WEB WAS REPLACED IAW SRM 53-14-3, AND 53-05, FIG 131, A-24.SDR DALA2017051803984Cusp Web · corrodedCORROSION ON THE CUSP WEB UPPER & LOWER SURFACE RBL 54 - 60, BETWEEN BS 739 - 769, IN THE PAX CABIN. THE CUSP WEB WAS REPLACED IAW SRM 53-14-3, AND 53-05, FIG 131, A-24.SDR DALA2017051803983Cusp Web · corrodedCORROSION ON CUSP WEB UPPER & LOWER SURFACE LBL 54 TO 60 BETWEEN BS 518 - 541, BS 553 - 556, AND BS 573 - 579 IN THE PAX CABIN. THE CUSP WEB WAS REPLACED IAW SRM 53-14-3, AND 53-05, FIG 131, A-24.SDR DALA2017051803982Cusp Web · corrodedCORROSION ON CUSP WEB UPPER & LOWER RBL 54 TO 60 BETWEEN BS 503 & 604. THE CUSP WEB WAS REPLACED IAW SRM 53-14-3, AND 53-05 FIG 131 A-24.SDR DALA2017051803981Angle · corrodedCORRODED ANGLE ON THE CARGO DOOR FRAME BS 1212, LONGERON 22R IN THE AFT CARGO BAY. THE ANGLE WAS REPLACED IAW DWG 4912817, ITEM 503, REV C.SDR DALA2017051803980Floor Panel · crackedCRACK ON FLOOR PANEL 200F. THE FLOOR PANEL WAS REPAIRED IAW SRM 53-05, FIG 131B, PAR 145.SDR DALA2017051603909O-Ring · failedAFTER TAKE-OFF, THE NOSE GEAR UNSAFE LIGHT REMAINED ILLUMINATED WITH ASSOCIATED AIR NOISE FROM THE NOSE GEAR AREA. THE GEAR HANDLE WAS SELECTED DOWN AND 3 GREEN LIGHTS WERE OBSERVED. MAINTENANCE FOUND THE NOSE GEAR STRUT FLAT WITH THE SCHRADER VALVE PACKING SDR DALA2017051603907Seat Track · corrodedCORROSION OUT OF LIMITS AT BS 671 - 672 ON SEAT TRACK PLUG LBL 54. THE PLUG WAS REPLACED IAW SRM 53-05, FIG 4A.SDR DALA2017051603906Doubler · debondedDISBONDED PREVIOUS REPAIR DOUBLER AND IMPROPERLY DISTANCE OF FASTENER TO EDGE ON RH CUSP WEB BTW BS 427-434 RBL 54 TO 60 AT PAX CABIN. THE REPAIR DOUBLER WAS FABRICATED AND WAS INSTALLED IAW SRM 51-30-2, 51-05, FIG 131A, AND 51-30-5.SDR DALA2017051503910Battery Pack · inoperativeLT AND RT EXIT SIGNS AT ABOVE WING, AFT DOORS, ABOVE WINDOWS, LIGHTS INOPERATIVE. REPLACED THE BATTERIES FOR EXIT LIGHTS IAW AMM 33-53. OPS CHECKED GOOD. OK FOR SERVICE.SDR WX0A2017051573249Control Box · malfunctionedDURING TAKE OFF ROLL, FLIGHT CREW RECEIVED A SLAT WARNING AND THE CAPTAIN REJECTED TAKE OFF AT APPROX 120 KTS . R & R THE PROXIMITY SWITCH CONTROL BOX AS PRECAUTION.SDR DALA2017051503876Cusp Web · corrodedCORROSION ON CUSP WEB, BS 1222 - 1224, LBL 54 - 60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-6.SDR DALA2017051403875Spacer · corrodedCORROSION ON PREVIOUS REAPAIR SPACER AND ON BEAM BETWEEN BS 636 - 693, LONGERON 28R. REPAIRED IAW SRM 53-05, FIG 123.SDR DALA2017051403874Doubler · debondedDISBONDED REPAIR DOUBLER BS 294, BETWEEN LONGERONS 17 & 18L. THE DOUBLER WAS REPLACED IAW SRM 53-04-3, FIG 2, & 51-30-2.SDR DALA2017051303873Skin · dentedDENT ON EXTERNAL FUSELAGE SKIN BETWEEN BS 646 - 645, LONGERONS 29L - 29R. THE SKIN WAS REPAIRED IAW ETI-88-17-147, REV 6, AND ER/A 558091-14, REV ORIGINAL.SDR DALA2017051303872Longeron · crackedCRACK ON LONGERON 12L, BS 1437. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2017051303871Cusp Web · crackedCRACKED RT CUSP WEB BS 885 BETWEEN LBL 54 AND 60. DOUBLER AND FILLER FABRICATED AND INSTALLED IAW SRM 53-05, FIG 131A-3.SDR DALA2017051203825Door Frame · crackedOVERWING EMERGENCY EXIT DOOR CRACKED ON THE DOOR FRAME. THE DOOR FRAME WAS REPAIRED IAW SRM 53-05, PAR 42, FIG. 32.SDR DALA2017051203824Longeron · corrodedCORROSION ON LONGERON 24L, BS 1170. THE LONGERON WAS REMOVED AND REPLACED IAW SRM 51-30-02, SRM 51-10-4, AND SRM 51-30-5.SDR DALA2017051203823Fitting · crackedCRACK ON FITTING BS 655 BETWEEN BEAM 1 AND LWR EDGE AT MID CARGO DOOR. FITTING REPLACED IAW SRM 51-30-5 AND 51-30-2. (LP0016410)SDR DALA2017051203821Pan · crackedCRACKED L1 DOOR FWD & AFT PAN BETWEEN BEAM 1 AND TOP. THE PAN CORNERS WERE REPAIRED IAW SRM 52-05, FIG 18A.SDR DALA2017051203820Floor Support · corrodedCORROSION ON FLOOR SUPPORT BETWEEN BS 160 - 200, RBL 44. FLOOR SUPPORT REPLACED IAW SRM 51-30-2, 51-30-5, AND 51-10-3, PAR 26.SDR DALA2017060604495Skin · dentedSEVERAL DENTS ON OTBD VANE AT RT INBD FLAP. DUE TO SEVERAL DENTS ON OUTBD VANE AT RT INBD FLAP. WILL BE REPLACED IAW SRM 57-04, PARAGRAPH. 5. C. (1).SDR DALA2017051103766Frame · crackedCANTED FRAME BS 1510 CRACKED AT TAILCONE PIN GUIDE AT 5:30 POSITION. REPLACED THE FRAME IAW DRAWINGS 5966769, AND 9911843-6.SDR DALA2017051103765Vane · delaminatedDELAMINATION ON INBD VANE OF THE OTBD FLAP. THE VANE WAS REPLACED IAW SRM 57-03 D, PARAGRAPH 11 B.SDR DALA2017051103757Beam · crackedCRACKED R1 DOOR NR 1 BEAM FWD SECTION. THE BEAM WAS REPLACED IAW SRM 51-30-1, 51-30-2, AND 51-30-5.SDR DALA2017051103756Cusp Web · crackedCRACK ON CUSP WEB BETWEEN BS 844, RBL 57. DAMAGE AREA WAS REPAIRED IAW SRM 53-05, FIG 131A-3.SDR DALA2017051103755Floorbeam · corrodedCORROSION ON FLOORBEAM BS 200, RBL 47 TO 58. THE FLOORBEAM WAS REPLACED IAW SRM 51-30-5 AND 51-10-4.SDR DALA2017051103754Floor Support · corrodedCORROSION ON FLOOR SUPPORT BETWEEN BS 210, RBL 12, IN THE PAX CABIN. THE FLOOR SUPPORT WAS REPLACED IAW SRM 51-30-5, AND 51-10-4.SDR DALA2017051103753Vane · wornWEAR ON REPAIR DOUBLER OF MIDDLE GUIDE VANE UPPER SURFACE AT RT WING OTBD FLAP. THE GUIDE VANE WAS REPAIRED IAW SRM. 57-03 D, PAR 11.SDR DALA2017051103752Access Panel · corrodedCORRODED ACCESS PANEL 1303C ON LT WING. THE ACCESS PANEL WAS REPLACED IAW SRM 51-22-2A, PAR 6, CONDITION III.SDR DALA2017051103751Channel · crackedCRACKED CHANNEL ON RT FWD EMERGENCY EXIT DOOR BELOW STOP FITTING NR 1. THE CHANNEL WAS REPLACED IAW SRM 51-30-2 AND 51-30-5.SDR DALA2017051103750Beam · crackedCRACKED L1 DOOR BEAM NR 7 AFT SECTION. THE DOOR BEAM WAS REPAIRED IAW SRM 52-05, FIG.109.SDR DALA2017051003735Cable · tornTORN TAILCONE CABLE ASSEMBLY. REPLACED THE CABLE IAW AMM 53-53 AND COMPLETED REQUIRED INSPECTION.SDR DALA2017051003734Doubler · crackedCRACK ON DOUBLER REPAIR BETWEEN BS 905, LBL 56 IN THE PAX CABIN LT SIDE. THE DOUBLER WAS REPLACED IAW SRM 53-05, FIG 131A-12.SDR DALA2017071405425Spar Cap · crackedUPPER LT REAR SPAR CAP CRACKED. REPAIRED LT REAR UPPER SPAR CAP WITH A SPAR CAP SPLICE PER ER/A 549325-14AD REVB. ALL OTHER REPAIRS AND INSPECTIONS WERE ACCOMPLISHED ON SHOP ORDERS.SDR DALA2017051003733Spar Cap · crackedCRACK ON UPPER INBD HOLE ON THE HORIZONTAL STABILIZER RT REAR UPPER SPAR CAP. REPAIRED.SDR DALA2017051003732Skin · crackedDURING NDT INSPECTION, A DISCREPANT AREA WAS FOUND ON THE LOWER SKIN BETWEEN XRS 163 - 168, REAR SPAR ON RT WING. REPAIRED IAW ER/A 556412-14AD, REV.ORIGINAL.SDR DALA2017051003731Skin · crackedDURING NDT INSPECTION, A DISCREPANT AREA WAS FOUND ON LOWER SKIN BETWEEN XRS 163 - 168, REAR SPAR. REPAIRED IAW ER/A 556412-14AD, REV ORIGINAL.
Back to Mcdonnell Douglas MD-88