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 DALA2017090806740Cusp Web · corrodedCORROSION ON THE CUSP WEB LBL 44 - 60, UPPER & LOWER SURFACES BS 797 - 800. REPAIRED IAW SRM 53-01, FIG. 1.SDR DALA2017090806739Cusp Web · corrodedCORROSION ON THE RT CUSP WEB BETWEEN BS 1070 TO 1072 AND BS 1096 TO 1098. REPAIRED IAW SRM 53-05, FIG 131 A, FIGURES 9 AND 13.SDR DALA2017090806738Skin · corrodedFUSELAGE SKIN HAD POPPED FASTENERS AND PILLOWING AT BS 465, LONGERON 30L. REPAIRED IAW ER/A 560971-14.SDR DALA2017090806737Angle · crackedCRACKED ANGLE AT BS 389 BETWEEN THE LOWER EDGE AND BEAM NR 1 ON THE FWD CARGO DOOR. THE ANGLE WAS REPLACED IAW SRM 51-30-2.SDR DALA2017090706711Access Panel · corrodedCORROSION ON FUEL TANK ACCESS PLATES NBR 1371C, 1303C, 1335C. PANELS WERE REPLACED. (LP# 0201594)SDR DALA2017090706704Ferrule · damagedDAMAGED AND MISSING FERRULES ON CABIN FLOOR PANELS 160D, 160A, 1117E, 160B, 693C, 465D, 200D, 120E, 1250C,1155B, 769D, 200B, 256B. REPLACED FLOOR PANELS. (LP# 0201721)SDR DALA2017090700005Vane · wornWEAR ON LEADING EDGE AT LT INBOARD VANE OUTBOARD FLAP. REPAIRED IAW 2000-8149-04.SDR DALA2017090700004Frame · wornWORN FRAME TEE BS 1380, LOWER FACE BETWEEN LONGERON 24L TO 24R AT AFT ACCESORY COMPARTMENT. REPLACED THE FRAME.SDR DALA2017090706713Cam · wornTAIL CONE RELEASE CAM IS WORN. HAS A GROOVE IN THE RAMP AREA. REPLACED THE CAM ASSY.SDR DALA2017090706712Cusp Web · crackedCRACK ON THE CUSP WEB MEMBRANE AT RBL 54 - 60, BS 802 - 804. REPAIRED IAW SRM 53-05, PAR 144, FIG 131A-1.SDR DALA2017090706710Spacer · corrodedCORROSION ON SPACER AT THE AFT CARGO DOOR FRAME REPAIR, BS 1174 - 1212. REPAIRED IAW SRM 53-05, FIG 123, 51-10-3, PAR 14, 21, 38, SRM 51-30-5, AND 51-10-2.SDR DALA2017090706709Floor Support · corrodedCORROSION ON FLOOR SUPPORT 160G. A NEW FLOOR SUPPORT WAS FABRICATED IAW SRM 51-10-4 AND DWG 9957828, REV AB.SDR DALA2017090706708Cusp Web · corrodedCORROSION OUT OF LIMIT ON THE CUSP WEB FROM BS 419 - 422 , RBL 60. REPAIRED IAW SRM 53-05, PAR 144, FIGURE 131A-6.SDR DALA2017090706707Cusp Web · corrodedCORROSION ON THE CUSP WEB FROM BS 1256 - 1260, RBL 54 TO 60. REPAIRED IAW SRM 53-05, FIGURE 131A-13.SDR DALA2017090706706Cusp Web · corrodedCORROSION ON CUSP WEB, RBL 54, UPPER & LOWER SURFACES FROM BS 897 - 905. REPAIRED IAW SRM 53-05, PAR 144, FIG 131A.SDR DALA2017090706705Cam · wornTAIL CONE RELEASE CAM IS WORN. HAS A GROOVE IN THE RAMP AREA. REPLACED CAM ASSY.SDR DALA2017090706703Access Panel · corrodedCORROSION ON THE FUEL PANEL ACCESS PANEL 1456C. THE ACCESS PANEL WAS REPLACED.SDR DALA2017090606673Battery Pack · inoperativeOVERWING EMERGENCY LIGHT (AFT) INOPERATIVE. R & R POWER SUPPLY BATTERIES IAW AMM 33-53. OPS CHECKED GOOD, ACFT OK FOR SERVICE.SDR DALA2017090606671Cusp Web · corrodedEXCESSIVE CORROSION ON CUSP WEB RT FROM BS 724 - 728. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-13.SDR DALA2017090606670Cusp Web · corrodedCORROSION ON PREVIOUS REPAIR DOUBLER OF CUSP WEB RBL 54 TO 60, BS 465 - 484. THE CUSP WEB WAS REPLACED IAW SRM 53-05, FIG 131A-13, AND SRM 51-30-5.SDR DALA2017090606669Access Panel · crackedCRACKED FUEL ACCESS PANEL 1355C. THE ACCESS PANEL WAS REPAIR IAW SRM 51-22-2A, PAR 6.SDR DALA2017090606668Floor Panel · delaminatedDELAMINATION ON CABIN FLOOR PANELS 160E, 693C, 465D, 200D, 617C, 120E, 1250D, 1250B, 1250C, 927B. FLOR PANES NBRS:927B, 160E, 1250C,1250D, AND 1250B WERE FABRICATED AND IDENTIFIED PER MD-88 A.M.M. 53-20-01-201. AND FLOOR PANEL NBR:617C WAS CLEANING PER P.S. 90SDR DALA2017090606665Access Panel · corrodedCORROSION IN FUEL PANEL ACCESS NBR# 1303C AND 1409C. THE FUEL ACCESS NBR 1303C AND 1409C BLEND OUT REPAIR IS NOT PERMITTED ON THE UPPER WING ACCESS DOOR (P/N 3912757) DUE TO THE REDUCED AREA OF THE CONDUCTIVE INTERFACE. THEREFORE THEY ARE OUT LIMITS AND ACCESSSDR DALA2017090606672Angle · crackedCRACKED ANGLE ON UPPER SURFACE BS 826, RBL 42. THE ANGLE WAS REPAIRED IAW ERA 498192-14MA, REV A.SDR DALA2017090606667Skin · dentedDENTS ON THE UPPER & LOWER SURFACE SKIN OF THE LT ELEVATOR CONTROL TAB, AND THE ELEVATOR ANTI-FLOAT TAB. THE TAB SKIN WAS REPAIRED IAW SRM 55-04, PAR 3.SDR DALA2017090606666Cusp Web · nickedNICKS ON THE RT CUSP WEB BETWEEN BS 870 - 876, RBL 48 TO 52. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A.SDR DALA2017090606664Seat Track · damagedSEAT TRACK, BS 878 TO 880, LBL 22. DAMAGED OUT OF LIMITS. THE SEAT TRACK WAS REPAIRED IAW SRM 53-05, FIG 4A.SDR DALA2017090606663Cusp Web · corrodedCORROSION ON CUSP WEB RT SIDE, RBL 54 TO 60 UPPER & LOWER SURFACES FROM BS 598 TO 617. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131-14.SDR DALA2017090606662Access Panel · corrodedCORROSION ON FUEL TANK ACCESS PLATES NR 1410C. FOUND OUT OF LIMITS AND REPLACED IAW SRM 51-22-2A,SDR DALA2017090606651Skin · corrodedCORROSION ON FUSELAGE SKIN UNDER FILLET PANEL RUB STRIPS FROM BS 731 - 826. THE CORROSION WAS REMOVED IAW SRM 53-04, PAR. 57. NDT WAS ACCOMPLISHED IAW SPM 04-00-07, PAR 5, FIG 3, SHEET I AND 2. FOUND TO BE WITHIN LIMITS IAW SRM 53-04, PAR. 57.SDR DALA2017090606650Floor Support · corrodedCORROSION ON A FLOOR SUPPORT. THE FLOOR SUPPORT WAS REPLACED IAW SRM 51-10-4.SDR DALA2017090606649Cusp Web · corrodedCORROSION ON CUSP WEB, LBL 44 - 60 UPPER & LOWER SURFACES, BS 503 - 598. THE CUSP WEB WAS REPLACED IAW SRM 53-05, FIGURE 131A-24, 51-30-1, 51-30-2, 51-30-5, AND DWG 9930538-11, REV BF.SDR DALA2017090606648Angle · corrodedEXCESSIVE CORROSION ON LOWER ANGLE, BS 503 TO 522, RBL 60. THE ANGLE WAS REPLACED IAW SRM 51-30-5, 51-10-4, AND DWG 9930538, REV CF.SDR DALA2017090506606Cusp Web · corrodedCORROSION OUT OF LIMITS ON RT CABIN FLOOR MEMBRANE AT STA Y =662 TO Y=667 AND Y=680 TO Y=683 IN REF NRC 00285. CUSP WEB WAS REPAIRED PER SRM 51-70-4.SDR DALA2017090506605Cusp Web · corrodedAFTER TO REMOVE CORROSION ON CUSP WEB BTW STA Y=1174 TO Y=1193, X=-54 TO X=-60, AREA WAS FOUND OUT OF LIMITS. CORROSION ON CUSP WEB BTW STA Y=1174 TO Y=1193, X=-54 TO X=-60 WAS REPAIRED PER SRM 51-70-04 FIG 2 (SHEET 1).SDR DALA2017090506604Cusp Web · corrodedCRACKED RT CUSP WEB BTW STA Y=200-256 AT PAX CABIN. RT CUSP WEB BTW STA Y=218-236 WAS REPLACED PER SRM 51-30-02 AND 51-30-05.SDR DALA2017090406602Charger · inoperativeEMERGENCY LIGHTS INOPERATIVE. TROUBLESHOT THE FIRST CLASS EMERGENCY LIGHTS IAW AMM 33-53. REPLACED THE BATTERY AND CHARGER IAW AMM 33-53. OPS CHECKED GOOD.SDR DALA2017090406601Ferrule · puncturedPUNCTURED AND DAMAGED FERRULE ON FLOOR PANEL 200C. A NEW FLOOR PANEL WAS FABRICATED IAW AMM 53-20-01-201.SDR DALA2017090406595Floor Panel · damagedDAMAGED ON FLOOR PANELS 160D, 160E, 160F. FLOOR PANELS NBRS: 160D, 160E AND 160F WERE REPLACED AND IDENTIFIED PER MD88 AMM 53-20-01-201. (LP0196779)SDR DALA2017092807160Hinge Fitting · corrodedCORROSION ON THE LT WING FWD FLAP HINGE FITTING AND LOWER STUDS, XW 251.383. THE HINGE FITTINGS WERE REPLACED IAW AMM 57-40-01.SDR DALA2017090506646Slide · malfunctionedUNPACKAGED TAILCONE SLIDE AT AFT ACC COMPARTMENT. THE TAILCONE SLIDE WAS REPLACED IAW AMM 25-62-01.SDR DALA2017090406600Seat Track · corrodedCORROSION ON THE SEAT TRACK LBL 54, BS 424 AND 485. THE SEAT TRACK WAS REPAIRED SRM 53-05, FIG. 4A.SDR DALA2017090406599Cusp Web · corrodedCORROSION ON THE CUSP WEB BS 326 TO 351, RBL 54 TO 60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 PARA 144, FIG 131 A-13.SDR DALA2017090406598Angle · crackedCRACKED ANGLE AT BS 1338, LONGERON 7R AT THE AFT PRESURE BULKHEAD, THE ANGLE WAS REPAIRED IAW SRM 53-01, FIG 3.SDR DALA2017090406597Floor Support · corrodedCORROSION ON FLOOR SUPPORT BETWEEN BS 1309 & 1346, RBL 18.0. THE FLOOR SUPPORT WAS REPLACED IAW SRM. 51-30-1.SDR DALA2017090406596Longeron · crackedCRACKED LONGERON 16L, BS 1437 IN THE AFT ACCESSORY BAY. THE LONGERON WAS REPLACED IAW SRM 53-14-4, FIG 4, 51-30-2, AND 51-30-5.SDR DALA2017090306592Seat Track · corrodedAWR: CORROSION ON LT SEAT TRACK LBL 54 BETWEEN BS 702 TO 704. THE SEAT TRACK WAS REPAIRED IAW SRM 53-05, FIG 4A.SDR DALA2017090306594Cusp Web · corrodedCORROSION ON THE CUSP WEB BETWEEN BS 399 - 401, RBL 44 TO 60. THE CUSP WEB WAS REPAIRED IAW SRM 51-70-4.SDR DALA2017090306591Angle · crackedCRACKED ANGLE ON LOWER FITTING BETWEEN BEAM 1 AND LOWER EDGE BS 1174 AT AFT CARGO DOOR. THE ANGLE WAS REPLACED IAW SRM 51-30-1, AND 51-30-5.SDR DALA2017090306590Cusp Web · corrodedEXCESSIVE CORROSION ON THE CUSP WEB, BS 281 TO 283 , RBL 54 TO 60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG. 131A-13.
Back to Mcdonnell Douglas MD-88