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 DALA2015060803677Spar Cap · damagedHORIZONTAL STABILIZER RT REAR CAP SPLICE DAMAGED. SPAR CAP REPAIRED.SDR DALA2016111008555Floorbeam · corrodedCORROSION ON FLOORBEAM BS 1338 X -20. THE FLOORBEAM WAS REPAIRED IAW SRM 53- 05 FIG. 20A, 51-30-1, 51-30-5, AND 51-10-3 PAR. 21, 14, AND 38.SDR DALA2015061103708Frame · crackedCRACKED FRAME BS 1485. REPAIRED IAW SRM 53-03, PAR 38, FIG 43.SDR DALA2015061103707Seat Track · corrodedCORROSION ON SEAT TRACK PLUG REPAIR X-54 AND BS 307 . PLUG WAS REPLACED IAW SRM 53-05, FIG 4, 51-30-1, 51-10-3, PAR, 38.SDR DALA2015061103703Access Panel · corrodedCORROSION ON LT MAIN FUEL TANK ACCESS PLATE 1335C COUNTERSINK HOLES. REPLACED THE ACCESS PANEL 1335C.SDR DALA2015061103702Access Panel · corrodedCORROSION ON LT MAIN FUEL TANK ACCESS PLATE 1307C COUNTERSINK HOLES. REPLACED THE ACCESS PANEL.SDR DALA2015061003730Intercostal · crackedCRACKED INTERCOSTAL ON BS 1338 LONGERON 3R, AFT FACE. REPAIRED THE INTERCOSTAL IAW SRM 53-01.SDR DALA2015061003738Access Panel · corrodedCORROSION ON COUNTERSINK OF FUEL ACCESS PLATE 1460C AT RT WING, CARD 205, ZONE 00. CORROSION ON ACCESS DOOR 1460C WAS REMOVED IAW SRM 51-10-03 AND COUNTERSINK HOLES WERE MEASURED AND MAX DIAMETER MEASURED IS 0.578", 6 HOLES THERFORE WAS FOUND OUT OF LIMITS IAWSDR DALA2015060903678Cusp Web · corrodedCORROSION ON RT CUSP WEB BETWEEN X=-54 TO X=-60, BS 579- 598. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-13, 51-30-5, AND 51-10-3 PARR 14 , 21. UT WAS ACCOMPLISHED IAW NDT SPM 04-00-07, PARR 5, FIG 3, SHT 1, 2. AND FOUND OUT OF LIMITS IAW ER/A 511SDR DALA2015060803675Access Panel · corrodedCORROSION ON LT MAIN FUEL TANK ACCESS PANEL 1357C COUNTERSINK HOLES AND SETTLEMENT AREA. CORROSION WAS REMOVED, COUTERSINKS WERE MEASURED AND MAXIMUM DIAMETER ALLOWABLE IS .532" AND WERE FOUND 3 COUTERSINKS ADJACENTS OUT OF LIMITS, THE ACCESS PANEL WAS REPSDR DALA2015060803673Longeron · crackedCRACK ON LONGERON 8 BS 1309. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18 AND SRM 51-10-3 PAR 14, 21 SRM 51-30-2, SRM 51-30-5.SDR DALA2015061003689Skin · damagedPERFORM REPAIR ON FUSELAGE SKIN Y=237 BETWEEN. LONGERONS 18-20L, REF MON 88, CARD 220 ZONE 00. PERMANENT REPAIR WAS PERFORMED IAW SRM 53-04-5, FIG 3, CLASS I AND UNDER MONITOR NR 88. PERFORM DECAL INSPECTION ON PREVIOUS REPAIR AT EVERY "C" CHECK IAW TOPP SDR DALA2015062203889Cusp Web · corrodedCORROSION ON DOUBLER OF REPARATION ON CUSP WEB BETWEEN STA Y=984 TO Y=1003 AND X=-54 TO X=-60, RT SIDE. CUSP WEB WAS REPLACED IAW SRM 53-05 , 51-30-2, 51-30-5 AND 51-10-3 PAR 14 , 21.SDR DALA2015061103701Access Panel · corrodedCORROSION ON COUNTERSINK OF FUEL ACCESS PLATE 1311C AT LT WING. REPLACED THE ACCESS PANEL.SDR DALA2015061103700Access Panel · corrodedCORROSION ON COUNTERSINK OF FUEL ACCESS PANEL 1335C AT LT WING. REPLACED THE ACCESS PANEL.SDR DALA2015060803676Angle · corrodedCORROSION ON ANGLES OF FRAME BS 693 BETWEEN LONGERON 28 - 30L. THE ANGLES WERE REPAIRED IAW SRM 51-30-02, 51-30-05, 51-10-03 PAR 14, 21, 38 AND 51-10-02, 53-03 D FIG 3.SDR DALA2015060803674Door Frame · corrodedCORROSION ON VENTRAL DOOR FRAME BS 1350 BETWEEN X=18 TO X=-18. THE VENTRAL DOOR JAMB WAS REPAIRED IAW SRM 53-05, FIG 34.SDR DALA2015060703672Skin · damagedWAVENING ON OTBD FUSELAGE SKIN BETWEEN BS 229 TO 262, LONGERONS 16 - 18L. FUSELAGE SKIN WAS REPLACED IAW SRM 53-04, FIG 12C AND SRM 51-10-3, PAR 14, 21 AND SRM 51-30-2 AND 51-30-5.SDR DALA2015060703671Tab · damagedDAMAGED RUDDER CONTROL TAB UPPER SECTION. RUDDER TAB WAS REPAIRED IAW SRM 51-70-1A, PAR 23 AMD 51-90-0 PAR 8K.SDR DALA2015060703668Floor Support · crackedCRACKED INTERCOSTAL ON X=0 BETWEEN BS 1307 AND 1287 AND CRACKED X=3 BETWEEN BS 1287 AND 1271. THE INTERCOSTAL WAS REPLACED IAW SRM 51-30-2, 51-30-5, 51-10-4, 51-10-3 PAR 14,21 AND AMM 20-30-01, AND SECOND CRACK REPAIRED IAW SRM 51-30-2, 51-01 PAR 4, STEP 21SDR DALA2015060703667Pan · crackedINITIAL CRACK ON SEAL PAN IN CUT OUT THE LOWER HINGE AT FWD SERVICE DOOR. REPAIR WAS ACCOMPLISHED IAW SRM 52-03D, FIG 3, 51-10-3 PAR 14/21, 51-30-4.SDR DALA2015060703666Cusp Web · crackedCRACKED LT CUSP WEB BETWEEN X= 54-60, BS 800-807. CUSP WEB REPLACED IAW SRM 51-30-1 AND 51-30-2.SDR DALA2015060703665Skin · damagedDAMAGED METALLIZED FABRIC SKIN ON LT & RT SIDE OF RUDDER CONTROL TAB. RUDDER CONTROL TAB WAS REPAIRED IAW SRM 51-70-1A PAR 23. CLASSIFIED AS A MAJOR REPAIR.SDR WX0A2015061072647Ground Stud · looseEMERGENCY EXIT SIGN AT L1 DOOR INOPERATIVE. TROUBLE SHOT & FOUND GND STUD S281 LOOSE IN FRAME AT STATION 332R. SECURED GND STUD IAW SRM 51-30-01. EMER EXIT SIGN OPERATIONS CHECKED GOOD IAW AMM 33-53-00.SDR DALA2015060803611Light · brokenDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTING AT SEAT 15DE IN THE CABIN WAS BROKEN AND MISSING. MAINTENANCE REPLACED THE WIRE HARNESS, INSTALLED A NEW LENS COVER, AND FUNCTIONALLY CHECKED THE SYSTEM. LP 7333950.SDR DALA2015060703610Access Panel · corrodedCORROSION ON LT MAIN FUEL TANK ACCESS PLATE NR 1361C COUNTERSINK HOLES AND SETTLEMENT AREA. CORROSION ON COUNTERSINKS AND SETTLEMENT AREA WAS REMOVED, COUNTERSINKS WERE MEASURED AND MAXIMUM DIAMETER ALLOWABLE IS .532" AND WAS FOUND 3 COUNTERSINKS OUT OF LIMITSDR DALA2016111008554Cusp Web · corrodedCORROSION ON LT CUSP WEB, X 54 TO X 60 AND BS 1202 -1207. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG.131A-7, 51-10-3 PAR 14, 21, AND 51-30-1, 51-30-5.SDR DALA2015061103755Doubler · corrodedCORROSION ON PRODUCTION DOUBLER AT AFT LAVATORY SERVICE PANEL. THE DOUBLER WAS REPAIRED IAW ER/A 534417-14, REV ORIGINAL.SDR DALA2015061103706Skin · crackedDURING NDT INSPECTION A DISCREPANT AREA WAS FOUND ON FUSELAGE SKIN BETWEEN BS 200 TO 206.5 AND BETWEEN LONGERONS 18 TO 26 RT.SDR DALA2015061103705Spar Cap · crackedUPPER REAR SPAR CAP AFT BARREL NUT HOLE HAS APPROXIMATELY 1.5" CRACK FROM AFT SIDE OF HOLE. REPAIRED IAW AMDS CARD 5510-01074-16.SDR DALA2015060903680Access Panel · corrodedCORROSION ON COUNTERSINK OF FUEL ACCESS PANEL 1410C, ON RT WING. ACCESS PANEL WAS REPAIRED IAW SRM 51-22-2A.SDR DALA2015060903679Access Panel · corrodedCORROSION FOUND ON FOUR COUNTERSINK HOLES OF FUEL ACCESS PANEL 1456C ON RT WING. THE ACCESS PANEL WAS REPAIRED IAW SRM 51-22-2A.SDR DALA2015060603664Cusp Web · corrodedCORROSION ON RT CUSP WEB BS 1079-1089 BETWEEN X=56 - X=60. FASTENERS WERE REMOVED, FITTING BS 1097 LT WAS REMOVED, DAMAGE WAS REMOVED, NEW REPAIRS PARTS WERE FABRICATED, REPAIR PARTS WERE TREATED AND PAINTED, REPAIRS PARTS ANGLE AND FITTING WERE INSTALLED, ASDR DALA2015060603663Cusp Web · corrodedCORROSION ON PREVIOUS DOUBLER REPAIR X=55 TO X=60 BS 835-841. DUE TO EXCESSIVE CORROSION, PREVIOUS REPAIR WAS REMOVED IAW SRM 51-30-2 AND 51-30-5 AND NEW CUSP WEB WAS FABRICATED IAW SRM 53-05, FIG 131A AND NEW DOUBLER REPAIR WAS INSTALLED IAW SRM 51-30-2 ANDSDR DALA2015060603662Longeron · crackedCRACKED LONGERON 1 ON BS 1437. LONGERON SECTION REPLACED IAW SRM 53-14-4 AND 53-02, FIG 18 AND 51-10-3, PAR 21 AND 14.SDR DALA2015060603661Structure · damagedLIGNTNING STRIKE ON LT ELEVATOR PLATE NEXT TO TIP. TIP END WAS REPLACED IAW SRM 51-10-2, 51-10-3, PAR 21, 14, 51-30-2, 51-30-8, AND 51-30-1.SDR DALA2015060603660Cusp Web · corrodedCORROSION ON LT CUSP WEB BETWEEN X=54 TO X=60 BETWEEN BS 864 - 886. CUSP WEB REPAIRED IAW SRM 51-10-3, PAR 14, 21, AND 53-05, FIG 131A-14.SDR DALA2015060603649Beam · crackedCRACK ON INTERNAL BETWEEN BEAMS 4 AND 5 AND BS 187 IN FWD ENTRY L1 DOOR. INTERCOSTAL WAS REPLACED IAW SRM 51-30-2 AND 51-30-5.SDR DALA2016111008553Access Panel · corrodedCORROSION ON LT WING FUEL TANK ACCESS PANEL 1379C COUNTERSINKS. CORROSION REMOVED AND WERE FOUND OUT OF LIMITS. THE ACCESS PANEL WAS REPLACED IAW DC-SRM 51-22-2A CONDITION II.SDR DALA2016111008552Cusp Web · corrodedCORROSION ON LT CUSP WEB X 55 TO X 60, BS 987-1000. A NEW CUSP WEB REPLACED IAW SRM 53-05 FIG. 131A.SDR DALA2016111008551Cusp Web · corrodedCORRODED PREVIOUS REPAIR DOUBLER ON RT CUSP WEB X 54 TO X 60, BS 561-572. THE CUSP WEB WAS FABRICATED, AND REPLACED IAW SRM 53-05 FIG. 131A.SDR DALA2015061103710Intercostal · crackedCRACKED AFT INTERCOSTAL BETWEEN PAN AND BEAM 1 AT L1 DOOR. INTERCOSTAL WAS REPLACED IAW SRM 51-30-2.SDR DALA2015061103704Access Panel · corrodedCORROSION ON RT MAIN FUEL TANK ACCESS PANEL 1464C COUNTERSINKS INLET AND SETTLEMENT AREA. THE ACCESS PANEL WAS REPLACED IAW SRM 51-22-2A CONDITION II.SDR DALA2015060903650Rib · damagedCORROSION AND SCRATCHS ON RIB HOLES NR 2 BS XOS= 240 WERE REMOVED IAW SRM 57-02 PAR 9. REWORKED HOLES WERE MEASURED INBD LUG FWD HOLE 0.939" AND AFT HOLE 0.941". BUSHINGS WERE FABRICATED IAW SRM 57-02, PAR 9, C, TABLE 1, 1, 2. BUSHINGS WITH OD 0.942" BUSHINSDR DALA2015060503648Longeron · crackedCRACKED LONGERON 11R AT AFT ACC COMP BS 1380. REPLACED THE LONGERON IAW SRM 53-02, FIG 18.SDR DALA2015060503647Intercostal · crackedCRACK ON INTERCOSTAL BEHIND SIX PULLEY BRACKET BS 1352 AND X=-22. INTERCOSTAL WAS REPLACED, INTERCOSTAL WAS REPAIR IAW SRM 51-30-2, 51-30-1, 53-01, FIG 2.SDR DALA2015060503646Pan · crackedCRACKED PAN ON BEAM FWD EDGE AT LT AFT EMERGENCY EXIT DOOR, SM, ZONE 201, CARD 73. AREA WAS REPAIRED IAW SRM 52-05D FIG 51, 51-30-1, 51-30-2, 51-30-5, AND 51-10-3 PARA 14 AND 21. CRACK 1. PRIMARY STRUCTURE.SDR DALA2016111008550Cusp Web · corrodedLEFT CUSP WEB X 54-60 , 995-999, THE CORROSION WAS REMOVED IAW SRM 53-05 FIG 131A-2, SRM 51-10-3 PAR 21 AND 14, AND 51-30-2.SDR DALA2016111008549Cusp Web · corrodedCORROSION ON THE LT CUSP WEB X 44 TO X 54, BS 1155 - 1174 . REPAIRED IAW SRM 53-05-FIG. 131A-1, 51-30-2, 51-30-5, AND 51-10-3 PARS 14, 21, AND 38.SDR DALA2016111008548Cusp Web · corrodedCORROSION ON LT CUSP WEB, BS 421 - 424, X 55 TO X 60. DAMAGE REMOVED, AND A REPAIR FABRICATED IAW SRM 53-05 FIG 131A-13. THE REPAIR WAS TREATED AND PAINTED IAW SRM 51-10-3 PAR 21, 14, AND INSTALLED IAW SRM 51-30-5.
Back to Mcdonnell Douglas MD-88