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 DALA2016112809329Floor Support · corrodedCORROSION ON A CABIN FLOOR SUPPORT AT STA 200 RBL-20 AND RBL-36 AND 1EA ELONGATED HOLE AT RBL-15. REMOVED AND REPLACED FLOOR SUPPORT.SDR DALA2015043003015Connector · detachedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTS AT THE FWD RT GALLEY SIDEWALL WAS INOPERATIVE. MAINTENANCE FOUND A CONNECTOR IN THE WIRE HARNESS AT THE FIRST ROW SEATS UNPLUGGED, RECONNECTED IT, AND FUNCTIONALLY CHECKED THE SYSTEM. LP 6721096.SDR DALA2016112809328Fitting · corrodedCORROSION ON FRAME CLIP STA Y=1322 BETWEEN LONGERONS 19L AND 26L. CORROSION WAS ATTENDED IAW SRM.SDR DALA2016112809327Floor Support · corrodedCORROSION ON MAIN CABIN FLOOR SUPPORT BETWEEN STA 148 - 200 LBL-7. REMOVED AND REPLACED FLOOR SUPPORT BETWEEN STA 148-200 LBL 7.SDR DALA2016112809326Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PLATE NBR1460C. CORROSION FOUND OUT OF LIMITS IAW SRM. ACCESS PLATE WAS REPLACED.SDR DALA2016112809325Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS NR 1367C. FUEL ACCESS 1367C WAS REPLACED DUE TO EXCESSIVE DAMAGE.SDR DALA2016112809324Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS NR 1472C. FUEL ACCESS 1472C WAS REPLACED DUE TO EXCESSIVE DAMAGE.SDR DALA2015042802955Rib · crackedCRACKED RIB ON RT SLAT PANEL NR 5 AT STA XFS=623. RIB ON RT SLAT PANEL NR 5 AT STA XFS= 623 WAS REPLACED IAW SRM 51-30-2.SDR DALA2015042802954Pan · crackedCRACK ON RT WINDOW RING PAN BETWEEN BS 984 AND 1003 AT PAX CABIN STRUCTURE FWD LWR CORNER. RING PAN WAS REPAIRED IAW SRM 53-05, FIG 122 AND ERA 493648-14MA, REV ORIGINAL. LP 1923133.SDR DALA2015042802953Longeron · corrodedCORROSION ON LONGERON 22L FROM BS 1287 - 1338. LONGERON REPAIRED IAW SRM 51-10-3/51-30-5 AND 51-30-2, 53-02, FIG 18.SDR DALA2015042802952Frame · crackedCRACKED FRAME BS 1485 CANT AND 1 HR POSITION. CRACKED FRAME WAS REPAIRED IAW SRM 53-03D, FIG.49. LP 1922656.SDR DALA2015042802951Longeron · crackedCRACKED LONGERON 8L BS 1431 CANT AT AFT ACCESSORY COMPARTMENT. LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18, LP 1922641.SDR DALA2015042802950Longeron · crackedCRACKED LONGERON 8 LT, BS 1431 CANT AT AFT ACCY COMPARTMENT. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2016112809323Intercostal · corrodedCORROSION ON INTERCOSTAL STA Y= 1394 AND LONG 28 LT AT AFT ACCESSORY COMPARTMENT. REMOVED INTERCOSTAL, FABRICATED NEW INTERCOSTAL, TREAT AND PAINT INTERCOSTAL, INSTALLED NEW INTERCOSTAL IAW SRM.SDR DALA2016112809322Floor Support · corrodedFLOOR SUPPORT HAS CORROSION AROUND ATTACH TAB ON UPPER SURFACE 8 INCHES INBD OF THE L1 DOOR THESHOLD, BS 186 - 194. REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM.SDR DALA2016112809321Frame Splice · corrodedCORROSION ON SPLICE BS 1231 BETWEEN LONGERONS 28 - 30R. THE SPLICE WAS REPLACED IAW SRM.SDR DALA2016112809320Cargo Track · corrodedCORROSION ON THE RT CARGO TRACK BETWEEN BS 1212 - 1320. THE CARGO TRACK WAS REPLACED IAW SRM.SDR DALA2016112809319Cargo Track · corrodedSEVERAL POINTS OF CORROSION ON THE LT CARGO TRACK BETWEEN BS 1212 - 1320. THE CARGO TRACK WAS REPLACED IAW SRM.SDR DALA2015042702959Pin · pulledDURING LINE CHECK, MAINTENANCE FOUND THE L1 DOOR SLIDE PINS TO BE OUT OF THE PACK. MAINTENANCE REPLACED THE L1 DOOR SLIDE.SDR DALA2016112809318Cusp Web · corrodedCORROSION ON UPPER AND LOWER SURFACE OF CUSP WEB, RBL 54 - 60, BS 579 - 598. THE CUSP WEB WAS REPLACED IAW SRM.SDR DALA2016112809317Floorbeam · corrodedCORROSION ON FLOORBEAM BS 1322, LBL 19 AND 45. AREA FOUND TO BE OUT OF LIMITS. REPAIRED IAW SRM.SDR DALA2016112809316Cusp Web · corrodedCORROSION ON CUSP WEB, BS 1003 - 1022, RBL 58. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. REPAIRED THE CUSP WEB IAW SRM.SDR DALA2016112809315Frame · corrodedCORROSION ON FUSELAGE FRAME LOWER SECTION ATTACHED TO SKIN BS 1219 , BETWEEN LONGERONS 29L AND 29R. CORROSION OUT OF LIMITS. REMOVED AND REPLACED THE FRAME IAW SRM.SDR DALA2016112809314Floorbeam · corrodedCORROSION ON FLOORBEAM BS 1307 LBL 20. REMOVE AREAS OF DAMAGE. FABRICATED, TREATED, PAINTED, AND INSTALLED A REPAIR IAW SRM .SDR DALA2016112609313Cusp Web · corrodedCORROSION ON MAIN CABIN CUSP WEB, BS 560 - 579 , RBL 58. CORROSION FOUND TO BE OUT OF LIMITS. REPLACED THE WEB CUSP.SDR DALA2016112609312Cusp Web · corrodedCORROSION ON MAIN CABIN CUSP WEB, BS 522 - 541, RBL 58. CORROSION OUT OF LIMITS. REPLACED THE CUSP WEB.SDR DALA2016112609311Cusp Web · corrodedCORROSION ON MAIN CABIN CUSP WEB BS 597, RBL 58. CORROSION OUT OF LIMITS. REPLACED THE CUSP WEB.SDR DALA2016112609310Cusp Web · corrodedCABIN BS 1179, LBL 50, CUSP WEB UPPER SKIN HAS CORROSION. CORROSION OUT OF LIMITS, CUSP WEB REPLACED.SDR DALA2016112609309Frame · corrodedCORROSION ON PREVIOUS REPAIR DOUBLER ON FRAME BS 1308, LONGERONS 28L - 28R. THE REPAIR DOUBLER WAS REPLACED IAW SRM.SDR DALA2015042402884Door Frame · corrodedCORROSION ON MID CARGO COMPARTMENT DOOR JAMB LOWER BEAM REPAIR SPACER. NEW REPAIR SPACER WAS INSTALLED IAW SRM 53-05, FIG 123A.SDR DALA2016112609308Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF THE ACCCES PANEL 1371C. CORROSION FOUND TO BE OUT OF LIMITS IAW SRM 51-22-2A AND THE ACCESS PANEL WAS REPLACED.SDR DALA2016112609307Access Panel · corrodedCORRSOION ON COUNTERSINK AND SETTLEMENT AREA OF THE ACCESS PANEL 1377C. THE ACCESS PANEL WAS REPLACED.SDR DALA2016112609306Access Panel · corrodedCORRSOION ON COUNTERSINK AND SETTLEMENT AREA OF ACCESS PANEL 1365C. CORROSION OUT OF LIMITS IAW SRM. THE ACCESS PANEL WAS REPLACED.SDR DALA2015042302863Cusp Web · corrodedCORROSION ON RT CUSP WEB BETWEEN, X=-54 TIAL AND X=-60 AND BS 574 AND 691. CUSP WEB AND RING DOUBLERS WERE FABRICATED, TREATED, PAINTED, AND INSTALLED IAW SRM 53-05, FIG 131A-24. LP 1916614.SDR DALA2015042302862Beam · crackedCRACKED BEAM NR 4 FWD EDGE AT FWD SERVICE DOOR. BEAM NR 4 AT FWD SERVICE DOOR WAS REPLACED IAW SRM 51-30-2.SDR DALA2016112609305Cusp Web · corrodedCORROSION ON CUSP WEB, BS 500 - 503, RBL 60 - 64. THE CUSP WEB WAS REPAIRED IAW SRM.SDR DALA2016112609304Cusp Web · corrodedCORROSION ON CUSP WEB BETWEEN BS 484 - 503 , RBL 58. REPAIRED THE CUSP WEB IAW SRM.SDR DALA2015042202859Longeron · crackedCRACKED LONG 8 LT BS 1437 AT AFT ACC COMPARTMENT. LONGERON NR 8 LT BS 1437 WAS REPAIRED IAW SRM 53-02, FIG 18. LP 1914812.SDR DALA2016112609303Floor Support · corrodedCORROSION ON MAIN CABIN FLOOR SUPPORT BETWEEN BS 148 - 200, RBL 7. REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM.SDR DALA2016112509302Cusp Web · corrodedBS 560 - 579, LBL 60, WEB LOWER SKIN HAS CORROSION. REPAIRED THE CUSP WEB IAW SRM.SDR DALA2016112509301Cusp Web · corrodedBS 446 - 465, LBL 60, CUSP WEB UPPER AND LOWER SKIN CORRODED. REPAIRED THE CUSP WEB IAW SRM.SDR DALA2016112509300Cusp Web · corrodedCABIN BS 475 LBL 60 CUSP WEB LOWER SKIN HAS CORROSION. REPAIRED IAW SRM.SDR DALA2015042302861Longeron · crackedCRACKED LONGERON 12L BS 1437. LONGERON 12L WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2016112509299Seat Track · corrodedCORROSION ON THE LEFT SEAT TRACK LBL 44, BS 215 - 220. THE SEAT TRACK WAS REPAIRED, TREATED, AND PAINTED IAW SRM.SDR DALA2016112509298Access Panel · corrodedCORROSION ON SETTLEMENT AND COUNTERSINK AREA OF THE ACCESS PANEL. THE ACCESS PANEL WAS REPLACED IAW SRM.SDR DALA2015042102849Wire · brokenDURING LINE CHECK, MAINTENANCE FOUND THE EMERGENCY LIGHTS AT 10D WERE INOPERATIVE. MAINTENANCE REPAIRED A BROKEN WIRE AND THE OPS TEST WAS GOOD. LP 6963534.SDR DALA2015042002822Door Frame · corrodedFORWARD CARGO BAY AFT JAMB IS CORRODED. CORROSION NOTED ON -21 REPAIR ANGLE , 0.013 MATERIAL LOSS IS OUT OF LIMITS AND WAS R & R PART AND INSTALLED IAW SRM 53-05, FIG 44. LP 1911442.SDR DALA2015042002812Wire · brokenDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHT AT ROW 28 INOPERATIVE. MAINTENANCE FOUND A BROKEN WIRE ON THE OTBD SEAT RAIL. THE CONNECTOR WAS REPLACED AND THE WIRE WAS REPAIRED. THE SYSTEM RETURNED TO NORMAL OPERATION.SDR DALA2016112809332Seat Track · corrodedCORROSION ON SEAT TRACK STA X=-54 STA Y=529 AT PAX CABIN. DAMAGE WAS REMOVED AND PLUG WAS ADJUSTED IAW SRM.SDR DALA2016112809331Seat Track · corrodedOUT OF LIMITS FOR EXCESSIVE CORROSION ON LT SEAT TRACK X= 54 BTW STA Y=546-550. DAMAGE WAS REMOVED IAW SRM.
Back to Mcdonnell Douglas MD-88