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 DALA2016112509297Intercostal · corrodedCORROSION ON LEFT INTERCOSTAL BS 1308 - 1320. THE INTERCOSTAL WAS REPLACED IAW SRM.SDR DALA2016112309155Intercostal · corrodedCORROSION ON INTERCOSTAL OVER LONGERON 28R BETWEEN BS 1308-1320 . THE INTERCOSTAL WAS REPLACED IAW SRM 51-30-2 AND 51-30-5.SDR DALA2016111008492Access Panel · corrodedCORROSION ON COUNTERSINK SETTLEMENT AREA AND DEGRADED SEALANT ON ANCHOR NUT AT FUEL ACCESS PANEL 1414C. THE CORROSION WAS REMOVED AND FOUND TO BE OUT OF LIMITS IAW SRM 51-22-2A. THE ACCESS PANEL WAS REPLACED.SDR DALA2015042002848Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THE EMERGENCY LIGHTS FROM ROWS 16-25 WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK AND THE LIGHTS TESTED SATISFACTORILY. LP 7267468.SDR DALA2015041902821Longeron · crackedCRACKED LONGERON 7 LT STA Y=1437 AT AFT ACC COMPARTMENT. LONG 7LT STA Y=1437 WAS REPAIRED IAW SRM 53-02, FIG 18. LP 1910329.SDR DALA2015041902820Longeron · crackedCRACKED LONG 6 LT STA Y=1437 AT AFT ACC COMPARTMENT. LONGERON 6 LT STA Y=1437 AT AFT WAS REPAIRED IAW SRM 53-02, FIG 18. LP 1910319.SDR DALA2016112309154Floor Panel · corrodedCORROSION ON FLOOR PANEL 160G . THE FLOOR PANEL WAS REPLACED IAW DWG 9957828 REV. AB, SRM 51-10-3 PAR. 14,21 & 38 AND SRM 51-30-2.SDR DALA2016112309151Cusp Web · corrodedCUSP WEB BS 579 - 598 LBL 60 HAS CORROSION. REPAIRED IAW SRM 53-05 , FIG 131A-13.SDR DALA2016112309150Cusp Web · corrodedCORROSION OUT OF LIMITS ON RT CUSP WEB BS 1046-1049 AND 1060-1079, RBL 54 AND 60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG 131A-7 AND 53-05 FIG 131A-14.SDR DALA2015041802818Longeron · crackedCRACK ON LONGERON 3R AT BS 984. LONGERON REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2015041802815Structure · corrodedCORROSION ON BARREL NUT HOLE NR 7 RT AT HORIZONTAL STABILIZER. BARREL NUT HOLE 7 RT AT HORIZONTAL STABILIZER WAS REPAIRED IAW SRM 55-03D. LP 1908603.SDR DALA2016112309149Cusp Web · corrodedPITTING CORROSION ON LT CUSP WEB UPPER AND LOWER SURFACE LBL 55 - 60, BS 1048-1059 AND 1063-1066. CORROSION REMOVED IAW SRM 53-05 FIG 131A AND AREA WAS REPAIRED IAW SRM 53-05 FIG 131ASDR DALA2016112309148Cusp Web · corrodedCORROSION ON CUSP WEB PREVIOUS RAPAIR DOUBLER BTW STA Y=1048 TO Y=1117, RBL 60. REPAIR WAS REPLACED IAW 53-05 FIG. 131A.SDR DALA2016112309147Doubler · corrodedCORROSION ON DOUBLER BS 1338 BETWEEN LONGERONS 28L - 28R AT AFT PRESSURE BULKHEAD AREA. THE DOUBLER WAS REPLACED IAW SRM 51-10-4 , 51- 30-2 , 51-30-5 , 51-10-3 PARAGRAPH 14 AND 21.SDR DALA2016112309146Doubler · corrodedCORROSION ON DOUBLER ON DOME BETWEEN LONGERON 29L AND 29R BS 1338. THE DOUBLER WAS REPLACED IAW SRM 53-14-3 FIG. 7 ITEM 59 , 51-30-2 , 51-30-5 , 51-10-3 PARAGRAPH 21 AND 14.SDR DALA2015042102824Support Fitting · corrodedCORROSION ON RT MLG SUPPORT FITTING BUSHING BORE, ALSO CORROSION AND TOOL MARKS ON BUSHING BORE BOTTOM. DAMAGE ON BUSHING BORE WAS REPAIRED IAW DWG SR 09570087. NOTE II, REV B AND DAMAGE ON BUSHING BORE BOTTOM WAS REPAIRED WITH FINAL LENGTH:1.202" SO IT WAS SDR DALA2015042102823Support Fitting · corrodedCORROSION ON LT MLG SUPPORT FITTING BUSHING BORE, ALSO CORROSION AND TOOL MARKS ON BUSHING BORE BOTTOM. DAMAGE ON BUSHING BORE WAS REPAIRED IAW SR DWG SR09570087. NOTE II, REV B AND DAMAGE ON BUSHING BORE BOTTOM WAS REPAIRED WITH FINAL LENGTH: 1.218" SO IT WASDR DALA2015041802819Longeron · crackedCRACKED LONGERON 2 RT BS 845 AT CABIN STRUCTURE. REPAIR WAS INSTALLED IAW SRM 53-02, FIG 18. LP 1909457.SDR DALA2015041802816Frame Splice · corrodedCORROSION ON SPLICE BETWEEN LONGERON PROJECTION 26 AND 27R, BS 1338 AT AFT CARGO COMPARTMENT. SPLICE WAS REPLACED IAW SRM 53-03, FIG 37, 51-10-3 PARA 14 AND 21, 51-30-5. LP 1909271.SDR DALA2016112309145Cusp Web · corrodedCORROSION ON REPAIR DOUBLER OF CUSP WEB BS 541- 560 AND LBL 54 TO 60. DOUBLER WAS FABRICATED AND INSTALLED IAW 53-05 FIG 131-A7 51-30-2, 51-30-5.SDR DALA2016112309144Cusp Web · corrodedRIGHT CUSP WEB CORRODED OUT LIMITS BETWEEN RBL 54 - 60 BS 476. REPAIRED IAW SRM 53-05 FIG 131A-13.SDR DALA2016112309143Cusp Web · corrodedCORROSION ON CUSP WEB BETWEEN BS 1202 - 1207, LBL 54 - 60. REPAIRED IAW SRM 53-05 FIG 131A-13.SDR DALA2016112309142Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF THE ACCESS PANEL 1478C. THE ACCESS PANEL WAS REPLACED.SDR DALA2016112309141Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PANEL 1454C. THE ACCESS PANEL WAS REPLACED.SDR DALA2016112309140Access Panel · corrodedCOUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PANEL 1476C. THE ACCESS PANEL WAS REPLACED.SDR DALA2016112309139Access Panel · corrodedCOUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PANEL 1470C. THE ACCESS PANEL WAS REPLACED.SDR DALA2016112309138Access Panel · corrodedCOUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PANEL 1456C. THE ACCESS PANEL WAS REPLACED.SDR DALA2016112309137Access Panel · corrodedCOUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PANEL 1464C. THE ACCESS PANEL WAS REPLACED.SDR WX0A2015042272543Battery · dischargedAFT EMER FLASHLIGHT NOT BLINKING. R & R BATTERY. OPERATIONS CHECKED NORMAL IAW MM 25-60-00.SDR DALA2015041802817Longeron · crackedCRACKED LONGERON 15R BS 1437. LONGERON REPAIRED IAW SRM 53-02.SDR DALA2016112309136Cusp Web · corrodedCORROSION ON REPAIR DOUBLER OF CUSP WEB BS 522 - 530 AND LBL 54 - 60. THE DOUBLER WAS REPLACED IAW SRM 53-05 FIG. 131A-24, 51-10-3 PAR 21,14,38, AND 51-30-2.SDR DALA2016112309135Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS 1466C. THE ACCESS PANEL WAS REPLACED.SDR DALA2016112309134Seat Track · corrodedCORROSION ON LT SEAT TRACK LBL 44, BS 1189 - 1193. THE SEAT TRACK WAS REPLACED IAW SRM 51-30-1 , 51-30-5 , 51-10-4 , 51-10-3 PARAGRAP 21 , 14 , 38.SDR DALA2015041502778Tab · damagedDAMAGE METALIZED COVER ON RUDDER TAB LT SIDE. RUDDER TAB WAS REPAIRED IAW SRM 51-70-1A PAR. 23. LP 1904665.SDR DALA2015041502777Skin · corrodedCORROSION BETWEEN FUSELAGE SKIN AND INTERNAL DOUBLER FROM STA Y=1302 TO 1322 AND LONGERON 22L. CORROSION WAS REMOVED AND AREA OUT LIMIT WAS REPAIRED IAW ER/A 533315-14, REV ORIGINAL.SDR DALA2016111108864Cusp Web · corrodedPREVIOUS CUSP WEB REPAIR CORRODED OUT OF LIMITS, STA 1158-1174 X=-54 TO -60. REPAIRED.SDR DALA2016111108863Cusp Web · corrodedCUSP WEB CORRODED OUT OF LIMITS, BS 1183-1187 LBL 54-60. REPAIRED THE CUSP WEB.SDR DALA2016111108862Access Panel · corrodedFUEL TANK ACCESS PANEL 1311C CORRODED OUT OF LIMITS, REPLACED THE ACCESS PANEL.SDR DALA2016111108861Access Panel · corrodedFUEL TANK ACCESS PANEL 1410C CORRODED OUT OF LIMITS, REPLACED THE ACCESS PANEL.SDR WX0A2015042272540Throttle · lack of lubeRIGHT THRUST REVERSER DIFFICULT TO DEPLOY. LUBED THROTTLES IAW AMM 76-11-04. OPERATIONS CHECKED GOOD ON GND.SDR WX0A2015042272539O-Ring · damagedSTARTED BOTH ENGS, LT HYD QTY WAS 9 QTS, BY THE TIME WE REACHED THE END OF THE RUNWAY IT WAS INDICATING 6 QTS. RETURNED TO THE GATE INDICATING 4 QTS. FOUND INBD AFT MOTOR OPERATED DUAL SOV FITTING LOOSE. REMOVED FITTING & REPLACED O RING. REINSTALLED FITTISDR DALA2015041502780Longeron · crackedCRACK ON LONGERON 9L AT BS 560. LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18. LP 1904874.SDR DALA2015041402761Wire · brokenDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY PATHWAY LIGHTING AT SEAT 22E IN THE CABIN WAS INOPERATIVE. MAINTENANCE FOUND A WIRE BROKEN IN THE HARNESS. THE WIRE WAS REPAIRED AND THE SYSTEM RETURNED TO NORMAL OPERATION. LP 6998358.SDR DALA2015041402755Skin · wornWEAR ON LT MLG STRUT DOOR INBD SKIN ON FWD LWR EDGE AND LWR AFT EDGE. LT MLG STRUT DOOR WAS REPAIRED IAW AC 0966 CARD 2000-8149-02, JOB 000-0004 AND ETI-88-15-116, REV 1, ER/A 534333-14, REV ORIGINAL, LP 1903243 .SDR DALA2016111108860Cusp Web · corrodedCUSP WEB CORRODED OUT OF LIMITS, BS 476 RBL 54 TO 60, REPAIRED.SDR DALA2016111108859Cusp Web · corrodedPREVIOUS CUSP WEB REPAIR DOUBLER CORRODED OUT OF LIMITS, BS 1250-1271 BETWEEN RBL 54 TO 60, A NEW REPAIR WAS INSTALLED.SDR DALA2016111108858Cusp Web · corrodedPREVIOUS CUSP WEB REPAIR CORRODED OUT OF LIMITS, BS 793-807 RBL 54 TO 60, REPAIR REPLACED.SDR DALA2015041302749Skin · crackedCRACKED FUSELAGE SKIN ON FS Y=209 AND LONGERON 6L. SKIN WAS REPAIRED IAW ETI-88-15-112 REV 1 AND ER/A 534327-14, REV ORIGINAL. LP 1901509.SDR DALA2016111108857Access Panel · corrodedFUEL TANK ACCESS PANEL 1436C CORRODED OUT OF LIMITS, THE ACCESS PANEL WAS REPLACED.SDR DALA2016111108856Access Panel · corrodedFUEL TANK ACCESS PANEL 1462C CORRODED. REPAIRED THE ACCESS PANEL.
Back to Mcdonnell Douglas MD-88