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 DALA2015081905107Cusp Web · corrodedCORROSION ON RT CUSP WEB BETWEEN BS -52 TO -60, BS 807-826, 845-864, 886-905 CABIN FLOOR STRUCTURE. TASK 53-37-02. BS 855-858 OUT OF LIMITS WILL BE ATTENDED ON NRC 292.SDR DALA2015081905104Cusp Web · corrodedCORROSION ON CUSP WEB BETWEEN BS 722-725, X=-54 TO -60. TASK 53-037-02. REPAIRED IAW SRM 53-005, FIG 13 AND 51-30-02, 51-10-03.SDR DALA2015070404135Cusp Web · crackedCRACK ON RT CUSP WEB X -45 BS 797 AT PAX CABIN. CUSP WEB WAS REPLACED IAW SRM 51-30-1, 51-30-2 AND 51-10-4.SDR DALA2015070304095Cusp Web · crackedCRACKED CUSP WEB X 54 BETWEEN BS 237 - 256. REPAIRED IAW SRM 53-01, FIG 1.SDR DALA2015070204079Cusp Web · crackedCUSP WEB CRACKED BETWEEN BS 984 - 1003 AND X54 - 60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131-A, 51-10-3 P 14, 21 AND 51-30-2.SDR DALA2015070204078Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PLATE AT UPPER RT WING 1410C. CORROSION ON COUNTERSINK OF FUEL ACCESS PLATE WAS REMOVED IAW SRM 51-22-2. COUNTERSINK OF FUEL ACCESS PLATE WAS MEASURED AND FOUND OUT OF LIMITS WITH 3 ADJACENT HOLES .SDR DALA2015070204074Cusp Web · crackedCRACK ON RT CUSP WEB X=-54 TO X=-60 BETWEEN STA Y=1207 TO 1208 CABIN FLOOR STRUCTURE. CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-5.SDR DALA2015070104065Skin · damagedDAMAGED METALIZED COATING ON RUDDER SKIN. RUDDER REPAIRED IAW SRM 57-70-1A, PAR 23.SDR DALA2015081905103Cusp Web · corrodedCORROSION ON RT CUSP WEB UPPER AND LOWER SURFACE BETWEEN BS 1081 - 1084 X=-54 TO -60. FABRICATED AND INSTALLED DOUBLER AND FILLER IAW SRM 53-05 AND 51-10-03.SDR DALA2015070204392Pan · crackedSEVERAL CRACKS ON INNER PAN OF FWD CARGO DOOR. REPAIRED IAW SRM 52-01, FIG 4, 51-30-2, 51-10-3 PAR 14/21.SDR DALA2015070204081Beam · crackedCRACKED BEAM NR 4 AT FWD GALLEY SERVICE DOOR FWD SECTION. THE BEAM WAS REPLACED IAW SRM 51-30-2 AND 51-30-5. LENGTH CRACK .750".SDR DALA2015070204077Access Panel · corrodedCORROSION ON CENTRAL FUEL TANK ACCESS PLATE 2302C, COUNTERSINKS. CORROSION ON COUNTERSINK OF CENTRAL FUEL TANK ACCESS PLATE WAS REMOVED FOUND 3 ADJACENT HOLES OUT OF LIMITS. ACCESS PLATE WAS REPLACED FOR A NEW ONE AND WILL BE INSTALLED WITH JIC 5730-0655, JSDR DALA2015070204076Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PLATE AT UPPER RT WING NR 1436C. CORROSION ON COUNTERSINK OF FUEL ACCESS PLATE WAS REMOVED IAW SRM 51-22-2. COUNTERSINK OF FUEL ACCESS PLATE WAS MEASURED AND FOUND OUT OF LIMIT WITH 3 ADJACENT HOLESSDR DALA2015070204075Access Panel · corrodedCORROSION ON COUNTER SINK AND SETTLEMENT AREA OF FUEL ACCESS PLATE AT UPPER LT WING NR 1307C. CORROSION ON COUNTERSINK OF FUEL ACCESS PLATE WAS REMOVED IAW SRM 51-22-2A. FUEL ACCESS PLATE NR 1307C WAS MEASURED AND FOUND OUT OF LIMIT WITH 3 ADJACENT HOLES .7SDR DALA2015070204073Access Panel · corrodedCORROSION ON COUNTER SINK AND SETTLEMENT AREA OF FUEL ACCESS PLATE AT UPPER LT WING NR 1303C. BLEND OUT ON SETTLEMENT AREA OF FUEL ACCESS PLATE NR 1303C IS NOT PERMITED IAW SRM 51-22-2A. FUEL ACCESS PLATE NR 1303C WAS REPLACED FOR A NEW ONE AND WILL BE REPLASDR DALA2015070204072Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PLATE 1409, UPPER RT WING . BLENDED OUT OF THE ACCESS PLATE IS NOT PERMITED IAW SRM 51-22-2A. FUEL ACCESS PLATE NR 1409C WAS REPLACED.SDR DALA2015070204071Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PLATE 1454C LOWER RT WING . CORROSION ON COUNTERSINK OF FUEL ACCESS PLATE NR 1454C WAS REMOVED IAW SRM 51-22-2 COUNTERSINK OF FUEL ACCESS PLATE NR 1454C WAS MEASSURED AND FOUND OUT OF LIMITS WITH SDR DALA2015070204070Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PLATE AT LOWER RT WING 1460C. CORROSION ON COUNTERSINK OF FUEL ACCESS PLATE WAS REMOVED IAW SRM 51-22-2. COUNTERSINK OF FUEL ACCESS PLATE NR 1460C WAS MEASURED AND FOUND OUT OF LIMIT WITH 3 ADJACENTSDR DALA2015070104064Seat Track · corrodedCORROSION ON RT SEAT TRACK X -22 BETWEEN, BS 230-233. SEAT TRACK WAS REPAIRED IAW SRM 53-05, FIG 4A.SDR DALA2015070104063Skin · crackedLEFT SIDE UPPER AFT HORIZONTAL SKIN PANEL HAS INDICATION ON LFEC INSPECTION. APPROXIMATELY 1" LONG. CRACK INDICATION CONFIRMED IAW NDTSPM 06-10-02.005. COMPLIED WITH PRI 537341-14AD, REV O. TEMPORARY REPAIRED IAW ER/A 537341-14AD, REV ORIG.SDR DALA2015070104060Rib · corrodedCORROSION ON INBD MID RIB AT LT SLAT PANEL NR 4. REPAIRED IAW SRM 57-02, PAR 9 AND ER/A 536464-14, REV ORIGINAL.SDR DALA2015070104052Access Panel · damagedCORROSION AND TOOL MARKS ON COUNTERSINK AND OTBD SKIN AT FUEL ACCESS NR 1361C, LW, AYP, CARD 154, ZONE 00, RII: N ENTR 146629 W SUMMARY, FUEL ACCESS PLATE 1361C IS OUT LIMITS AND WAS REPLACED IAW SRM 51-22-2A.SDR DALA2015070104062Skin · wornWEAR ON FUSELAGE SKIN REPAIR DOUBLER BETWEEN BS 1300-1309 AND LONGERONS 18 TO 20 RIGHT. PREVIOUS REPAIR DOUBLER WAS REMOVED AND NEW EXTERNAL DOUBLER WAS FABRICATED AND INSTALLED IAW SRM 53-04-2, FIG 2, SHEET 9 AND 51-30-2.SDR DALA2015070104061Skin · crackedFOUR CRACKS ON FUSELAGE SKIN OF 0.125", 0.062", 0.156", AND 0.281" OF LENGTH LOCATED BETWEEN BS Y=372 TO Y=374 AND LONG 20RT-21RT AT FWD CARGO DOOR JAMB UPPER CORNER. DAMAGE WAS REPAIRED IAW SRM 53-05, FIG 105 OM FUSELAGE SKIN, AND ER/A 536461-14AD, REV OSDR DALA2015062904049Access Panel · damagedCORROSION AND TOOL MARKS ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS NR 1377C, LW, CARD 145, ZONE 00, RII: N ENTR 181463 W SUMMARY: FUEL ACCESS PLATE 1377C IS OUT LIMITS AND WAS REPLACED IAW SRM 51-22-2A.SDR DALA2015063004047Release Cable · frayedBROKEN STRANDS ON TAIL CONE RELEASE CABLE. RELEASE CABLE WAS REPLACED.SDR DALA2015063004046Longeron · crackedCRACKED LONGERON 14R BS 1380. LONGERON REPAIRED IAW ER/A 536440-14, REV ORIGINAL.SDR DALA2015063004045Cusp Web · corrodedCORROSION ON RT CUSP WEB X -54 TO X -60 BETWEEN BS 1220 - 1223. CUSP WEB WAS REPAIRED IAW SRM 51-30-1, 51-30-5 53-05, FIG 131A-5, SHEET 1 AND 51-10-3, PAR 21,14.SDR DALA2015063004044Cusp Web · corrodedCORROSION ON RT CUSP WEB X -54 TO X -60 BETWEEN BS 1086 - 1096. CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-6.SDR DALA2015063004043Cusp Web · corrodedCORROSION ON RT CUSP WEB X=-54 TO X=-60 BETWEEN BS 1137 - 1149. CUSP WEB WAS REPAIRED IAW SRM 51-30-1, 51-30-5 53-05, FIG 131A-10, SHEET 1 AND 51-10-3, PAR 21,14.SDR DALA2015063004042Seat Track · corrodedCORROSION ON SEAT TRACK, X 54, BS 246. DAMAGE WAS REMOVED IAW SRM 53-05, FIG 4A. REWORKED AREA WAS TREATED AND PAINTED IAW SRM 51-10-3, PAR 21,14. PLUG WAS INSTALLED IAW SRM 51-30-1, 53-05, FIG 4A CIC WAS APPLIED IAW SRM 51-10-3, PAR 38.SDR DALA2015063004041Pan · crackedCRACK ON FWD PAN SECTION AREA OF STOP FITTING NR 4 AT FWD CARGO DOOR. RII: N ENTR 983062 W SUMMARY: REPAIR WAS ACCOMPLISHED ON CRACK PAN OF STOP NR 4 IAW SRM 52-05 D, FIG 50 AND CRACK WAS FOUND 0.187 OF LENGTH.SDR DALA2015063004040Skin Panel · corrodedCORROSION ON INBD MID, OTBD RIB HOLES AT RT SLAT PANEL NR 1, CARD 1 ZONE 12. RII: N ENTR 983062 WSUMMARY: CORROSION ON INBD, MID OTBD RIB HOLES AT RT SLAT PANEL NR 1 WAS REPAIRED IAW SRM 57-02, PAR 9.SDR DALA2015063004039Stop Fitting · crackedCRACKED STOP FITTING NR 1 AND 2 STA Y=427 AT FWD CARGO DOOR. STOP FITTING REPLACED IAW SRM 51-30-1 AND 51-30-5.SDR DALA2015063004038Longeron · corrodedDURING MAINTENANCE ACTIVITIES, FOUND CORROSION OUT OF LIMITS ON LONGERON 22 LT FROM STA Y=1155 TO STA Y =1174 IN REF CARD 156, ZONE 100, CARD 269, ZONE 100.02. RII: Y ENTR 008590 W SUMMARY: SECTION LONG 22 LT FROM STA Y=1155 TO STA Y=1174 WAS R & R IAW SRM 51SDR DALA2015063004037Cusp Web · crackedCRACK ON RT CUSP WEB FROM BS 779 TO 781 AND X -54 TO -60. CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-13.SDR DALA2015063004036Doubler · wornWEAR ON DOUBLER SKIN OF AFT CARGO COMPARTMENT DOOR SKIN LOWER EDGE. DOUBLER REPLACED IAW SRM 51-30-2.SDR DALA2015063004035Angle · crackedCRACKED FRAME ANGLE BS 1380 BETWEEN LONGERON 15-16R . FRAME ANGLE WAS REMOVED AND FABRICATED, TREATED, PAINTED, AND INSTALLED IAW SRM 51-30-2, 51-30-5, 53-14-4 AND 51-10-3, PAR 14 AND 21.SDR DALA2015063004034Cusp Web · corrodedCORROSION ON LT CUSP WEB FROM BS 693 - 700 AND X 54 - 60. CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-13 AND 51-30-2 AND 51-10-3, PAR 21 AND 14 AND 51-30-5.SDR DALA2015063004033Cusp Web · corrodedCORROSION ON LT CUSP WEB FROM BS 693 - 700 AND X 54 - 60 . CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-13, 51-30-2, 51-10-3, PAR 21 AND 14 AND 51-30-5.SDR DALA2015062904032Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PANEL 1464C RT WING. ACCESS PLATE IS OUT OF LIMITS AND WAS REPLACED IAW SRM 51-22-2A.SDR DALA2015062904031Access Panel · corrodedCORROSION ON COUNTERSINK OF FUEL ACCESS NR 1470C, RT WING. ACCESS PLATE OUT OF LIMITS AND WAS REPLACED IAW SRM 51-22-2A.SDR DALA2015062904030Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PANEL 1456C, RT WING. ACCESS PLATE OUT OF LIMITS AND WAS REPLACED IAW SRM 51-22-2A.SDR DALA2015062904029Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS 1476C, RT WING. ACCESS PLATE OUT OF LIMITS AND WAS REPLACED IAW SRM 51-22-2A.SDR DALA2015062904028Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS 1436C RT WING. ACCESS PLATE OUT OF LIMITS AND REPLACED IAW SRM 51-22-2A.SDR DALA2015062904027Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS NR 1307C, LW, CARD 149, ZONE 00, RII: N ENTR 181463 W, FUEL ACCESS PLATE 1307C IS OUT LIMITS AND WAS REPLACED IAW SRM 51-22-2A.SDR DALA2015062904026Access Panel · damagedTOOL DAMAGE ON OTBD SKIN OF FUEL ACCESS 1355C. FUEL ACCESS PLATE IS OUT LIMITS AND WAS REPLACED IAW SRM 51-22-2A.SDR DALA2015082005111Cusp Web · corrodedCORROSION ON RIGHT CUSP WEB UPPER/LOWER SURFACE BETWEEN BS X=-54 TO -60 AND Y=750 TO 769, 769 TO 788, TASK 53-037-02. AREA IS WITHIN LIMITS BUT BS Y=779-781 WILL BE ATTENDED ON CARD 294.SDR DALA2015081905110Cusp Web · corrodedCORROSION ON RT CUSP WEB, BS X=-54 TO -60 AND Y= 1174 TO 1193. TASK 53-037-02. BS Y=1183 TO 1187 WAS FOUND TO BE OUT OF LIMITS.SDR DALA2015070204080Skin · wornWEAR ON OUTER SKIN OF MID CARGO COMPARTMENT DOOR LOWER EDGE. PRODUCTION DOUBLER WAS REPLACED IAW SRM 51-30 -02, DWG 5910141.
Back to Mcdonnell Douglas MD-88