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 DALA2015081805060Longeron · wornWEAR LONGERON 8R BS 1408. THE LONGERON 8 WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2015081805018Power Supply · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTS IN ROWS 31-36 OF THE CABIN WERE INOPERATIVE. MAINTENANCE REPLACED THE POWER SUPPLY AND THE LIGHTS RETURNED TO AN OPERATIONAL CONDITION.SDR DALA2015081805017Light · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTING AT SEAT 21D IN THE CABIN WAS INOPERATIVE. MAINTENANCE REPLACED THE LIGHT ASSEMBLY AND PERFORMED A SATISFACTORY FUNCTIONAL CHECK OF IT.SDR DALA2015081705015Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTS IN ROWS 27-31 WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERIES. OPS CHECK WAS GOOD.SDR DALA2015082805274Tab · dentedSEVERAL DENTS FOUND ON CONTROL TAB UPPER SURFACE ON LEFT ELEVATOR. CONTROL TAB REPLACED.SDR DALA2015082705256Rib · corrodedCORRODED RIB XOS 580 - 610, LT WING SLAT NR 5. R & R SLAT IAW AMM 27-80-1.SDR DALA2015081705128Skin · damagedOUT OF LIMITS, REWORKED AREA ON FUSELAGE SKIN BETWEEN BS Y=394.5 TO Y=401 AND LONGS 23 LT TO 25 LT. FUSELAGE SKIN BETWEEN BS Y=394.5 TO Y=401 AND LONG 23 LT TO 25 LT. CRACK OF 0.375" AT BS Y=394.5 WAS TRIMMED OUT WITHIN 0.750 OF DIAMETER IAW SRM 53-04-2 FIGUSDR DALA2015081805063Intercostal · corrodedCORROSION ON INTERCOSTAL BETWEEN LONGERON 29 AND 30R BS 1212 - 1219 AND BS 1148-1155 IN AFT CARGO COMPARTMENT. INTERCOSTALS REPLACED IAW DGW: 5936071, REV: W.51-10-3, PAR. 14, 21, 26, AND 38, AND 51-10-4.SDR DALA2015081705059Cusp Web · crackedCRACK ON LT CUSP WEB BS 223 BETWEEN LBL 52-60. CUSP WEB WAS REPLACED IAW SRM 51-30-5, 51-30-2, 51-30-1, 51-10-4, 51-10-3 PAR 14 AND 21, AND DWG 9930538, REV CF.SDR DALA2015081705058Cusp Web · crackedCRACKED CUSP WEB BS 855, BETWEEN RBL 54 - 60. DAMAGE WAS REMOVED WAS ACCOMPLISHED AROUND CUTOUT AREA AND NO CRACK WERE FOUND, REPAIR DOUBLER AND RING DOUBLER WERE FABRICATED. REPAIR TREATED AND PAINTED WAS INSTALLED AND WAS APPLIED CIC IAW SRM 53-05, FIG 131SDR DALA2015081705057Service Panel · corrodedCORROSION ON AFT LAVATORY SERVICE PANEL. AFT LAVATORY SERVICE PANEL WAS REPLACED IAW DWG 5914792, REV AG AND SRM 51-30-2, 51-10-3 PAR 14 AND 21.SDR DALA2015081705046Longeron · crackedCRACK ON LONGERON 5L AND BS 1437 AT AFT ACCESSORY COMPARTMENT. THE LONGERON WAS REPAIRED IAW SRM 53-02, PAR 12, FIG 18, 51-10-3, PAR 14 AND 21, 51-30-2, 51-30-5, AND 51-10-4.SDR DALA2015081705045Cusp Web · corrodedCORROSION ON CUSP WEB OUT OF LIMITS X 54 TO X 60 BETWEEN BS Y= 564-566. CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-13, SHEET 1, 51-30-2, AND 51-30-5.SDR DALA2015081705044Cusp Web · corrodedCORROSION ON RT CUSP WEB BS 1044-1052 BETWEEN X -54 X -60, IN REF TO CARD 140, ZONE 201, CFS, SM. RT CUSP WEB BS Y=1044-1052, X-54/X=-60 WAS REPAIRED IAW SRM 53-05, FIG 131A-7, 51-30-2, AND 51-10-3, PAR 14 AND 21.SDR DALA2015082405192Pan · crackedCRACKED PAN ON FWD UPPER OF FWD PASSENGER PAN ON FWD UPPER CORNER OF FWD PASSENGER ENTRANCE DOOR L1. DUE TO EXCESSIVE DAMAGE OUT OF LIMITS ON ENTRANCE DOOR L1 WILL BE REPLACE.SDR DALA2015081905090Structure · corrodedCORROSION ON REPAIR DOUBLER BETWEEN SEAT TRACK X 54 AND 60, BS 579-598 DAMAGE REPAIR DOUBLER WAS REPLACED IAW SRM 53-05, FIG 131A-13 , 51-30-2 AND 51-30-5 , 51-10-3 PAR 14 AND 21.SDR DALA2015081905065Skin · crackedCRACKED FUSELAGE SKIN AT BS 1380, BETWEEN LONGERONS 13-14L. REPAIRED IAW SRM 51-30-2, 51-30-5, 53-04, FIG 18, 51-10-3, PAR 14 AND 21.SDR DALA2015081705055Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PLATE 1464C. THE ACCESS PANEL WAS REPLACED IAW SRM 51-22-2.SDR DALA2015081705054Access Panel · corrodedCORROSION ON COUNTERSINK OF FUEL ACCESS 136. THE ACCESS PANEL WAS REPLACED IAW SRM 51-22-2.SDR DALA2015081705053Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS 1363C. THE ACCESS PANEL WAS REPLACED IAW SRM 51-22-2.SDR DALA2015081705052Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PLATE 1470C. THE ACCESS PANEL WAS REPLACED IAW SRM 51-22-2A.SDR DALA2015081705051Access Panel · corrodedCORROSION ON COUNTERSINK OF FUEL ACCESS PANEL 1379C. THE ACCESS PANEL WAS REPLACED IAW SRM 51-22-2A.SDR DALA2015081705050Access Panel · corrodedCORROSION ON COUNTERSINK OF FUEL ACCESS PANEL 1355C. THE ACCESS PANEL WAS REPLACED IAW SRM 51-22-2.SDR DALA2015081705049Access Panel · corrodedCORROSION ON COUNTERSINK OF FUEL ACCESS PLATE NR 1476 C, AYP, CARD 66, ZONE 00. FUEL ACCESSS PANEL WAS REPLACED IAW SRM 51-22-2A.SDR DALA2015081705048Access Panel · corrodedCORROSION ON COUNTERSINK OF FUEL ACCESS NR 1357C. THE FUEL ACCESS PANEL WAS REPLACED IAW SRM 51-22-2A.SDR DALA2015081705047Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PLATE 1436. FUEL ACCESS WAS REPLACED IAW SRM 51-22-2A .SDR DALA2015081605019Seat Track · corrodedCORROSION ON LT SEAT TRACK X=54, BS 820-826. REPAIRED IAW SRM 53-05, FIG 4A.SDR DALA2015081605014Support Bracket · crackedCRACK ON SUPPORT OF SIX PULLEY BRACKET BETWEEN BS 1338 AND LONGERON 3RT AT AFT ACCESORIES COMPARTMENT. SUPPORT WAS REPAIRED IAW SRM 51-30-2, 53-01, FIG 2, SHEET 4, 51-10-3 PAR 14, 21 51-30-5.SDR DALA2015081605013Floor Panel · damagedDELAMINATED AND PUNCTURED FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2015081605012Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA ON FUEL ACCESS PLATE, 1311C AT RT WING, LW, SM, CARD 147, ZONE 10. CORROSION ON COUNTERSINK WAS REMOVED AND MEASURED. THE MAX DIAMETER ON 3 HOLES ADJACENT IS .695", THEREFORE IS OUT LIMITS. FUEL ACCESS PLATE 1311CSDR DALA2015081605011Access Panel · corrodedCORROSION ON COUNTERSINK AT LT WING FUEL TANK ACCESS PLATE NR 1361C. MRB 57-083-02, CARD 145, ZONE 10. CORROSION ON COUNTERSINK HOLES WAS REMOVED AND MEASURED AND THE MAX DIAMETER ON 3 HOLES ADJACENT IS .560", THEREFORE IT IS OUT LIMITS. FUEL ACCESS PLATE 13SDR DALA2015081605010Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT SURFACE AT RT WING FUEL ACCESS PLATE NR 1460C. MRB 57-083-02, CARD 144, ZONE 10. CORROSION ON COUNTERSINK WAS REMOVED AND MEASURED. THE MAX DIAMETER MEASURED ON 3 HOLES ADJACENT IS .557", THEREFORE IS OUT LIMITS. FUELSDR DALA2015081605009Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT SURFACE AT RT WING FUEL TANK ACCESS PLATE NR 1466C. MRB 57-083-02, CARD 143, ZONE 10. CORROSION ON COUNTERSINK WAS REMOVED AND MEASURED. THE MAX DIAMETER ON 3 HOLES ADJACENT MEASURED IS .547", THEREFORE IT IS OUT LIMISDR DALA2015081605008Web · corrodedCORROSION ON WEB FROM BS 620-700 AT MID CARGO COMPARTMENT LOWER DOOR JAM. (C2). WEB WAS REPLACED IAW SRM 51-10-3, PAR 14-21, 51-10-4 DWG 5910142, REV DJ.SDR DALA2015081605007Pan · crackedCRACK ON WINDOW RING PAN BETWEEN BS 1174-1193, 1155-1174, AND 1098-1117 AT FWD LOWER CORNER RT SIDE. RING PAN WAS REPAIRED IAW SRM 53-05, FIG 139, 51-30-2, 51-30-5, 51-10-2, 51-10-4, 51-10-3, PAR 14, 21 AND ER/A 487747-14MA, REV A, ER/A 493648-14MA REV A, SRMSDR WX0A2015081772815Iru · malfunctionedCAPTAINS SIDE ATTITUDE INDICATOR TUMBLED, FOLLOWED BY A MAP FAIL WHICH DID NOT RESET, IRS FAILURE. REMOVED & REINSTALLED BOTH IRU'S IAW AMM 34-43-01-2. PERFORMED RTS IAW AMM 22-01-05-1, SHOWED GO ON BOTH SIDES.SDR DALA2015081605001Pan · crackedCRACK ON LT WINDOW RING PAN UPPER /AFT CORNER BETWEEN BS 1041-1060, AND 1231-1250. DAMAGE WAS REMOVED, NDT INSPECTION CHECK, NO CRACKS. ANGLES AND SHIMS WERE FABRICATED AND INSTALLED IAW SRM 51-30-2 AND 51-30-5, SRM 53-05, FIG 122 AND ER/AS 487747-14MA, REV A,SDR DALA2015081605000Pan · crackedCRACK ON LT WINDOW RING PAN UPPER /AFT CORNER BETWEEN BS 1041-1060, 1231-1250. DAMAGE WAS REMOVED NDT INSPECTION CHECK, NO CRACKS. ANGLES AND SHIMS WERE FABRICATED AND INSTALLED IAW SRM 51-30-2 AND 51-30-5, SRM 53-05, FIG 122 AND ER/AS 487747-14MA, REV A, 4SDR DALA2015081604999Pan · crackedCRACK ON RING PAN BETWEEN BS 886-905, 655-674, 579-598 AND 769-788 FWD UPPER CORNER RT SIDE. RING PAN WAS REPAIRED IAW SRM 53-5, FIG 139, SRM 51-30-2, 51-30-5, 51-10-2, 51-10-4, 51-10-3 PAR 14, 21 AND ERAS 487747-14MA, REV A, 493648-14MA, REV. A, SRM 53-05 SDR DALA2015081604998Pan · crackedCRACK ON WINDOW RING PAN BETWEEN BS 1155-1174, 1136-1155, 1117-1136 AND 1098-1079. RING PAN WAS REPAIRED IAW SRM 53-05, FIG 139, SRM 51-10-2, 51-10,4, 51-10-3 PAR 14, 21, SRM 51-30-2, 51-30-5, AND ERAS 487747-14MA REV A, 493648-14MA REV A, SRM 53-05, FIG 1SDR DALA2015081604997Pan · crackedCRACK ON WINDOW RING PAN BETWEEN BS 1060-1079. RING PAN WAS REPAIRED IAW SRM 53-05, FIG 139, 51-30-2, 51-30-5, 51-10-2, 51-10-4, 51-10-3, PAR 14,21 AND ER/AS 487747-14, MA REV A, 493648-14 MA, REV A, SRM 53-05, FIG 222.SDR DALA2015081604996Pan · crackedCRACK ON LT WINDOW RING PAN LOWER/FWD CORNER BETWEEN BS 807-826, 1041-1060. DAMAGE REMOVED NDT INSPECTION CHECK NO CRACKS, ANGLES AND SHIMS WERE FABRICATED AND INSTALLED IAW SRM 51-30-2 AND 51-30-5 J. AVI/A 152126 AND ERA 487747-14MA REV A, 493648-14MA, REV SDR DALA2015081604995Pan · crackedCRACK ON LT WINDOW RIN PAN UPPER/FWD CORNER BETWEEN BS 579-598, 788-807 AT CABIN STRUCTURE. DAMAGE REMOVED, NDT INSPECTION CHECK NO CRACKS ANGLES AND SHIMS WERE FABRICATED AND INSTALLED IAW SRM 51-30-2 AND 51-30-5. SRM 53-05 FIG 122 AND ERA 487747-14MA REV A,SDR DALA2015081604994Pan · crackedCRACK ON WINDOW RING PAN BETWEEN BS 1098-1079, 1060-1079 AT FWD LOWER CORNER POSITION RT SIDE. RING PAN WAS REPAIRED IAW SRM 53-05, FIG 139, SRM 51-30-2, 51-30-5, 51-10-2, 51-10-4, 51-10-3 PAR 14, 21 AND ERA 487747-14MA, REV A.SDR DALA2015081604993Pan · crackedCRACKED PAN AT AFT LT EMERGENCY EXIT DOOR UPPER FWD AREA. DOUBLER WAS INSTALLED IAW SRM 52-05D, FIG 51, 51-30-1, 51-30-2, 51-30-5, 51-10-3 PARAGRAPH 14 AND 21.SDR DALA2015081604992Cusp Web · corrodedCORROSION ON RT CUSP WEB BS 1073-1074 BETWEEN X -54 & X -60. NEW DOUBLER AND FILLER FABRICATED IAW SRM 53-05, FIG 131A-14 AND TREATED AND PAINTED IAW SRM 51-10-3, PAR 11, 14 AND 21 AND INSTALLED IAW SRM 51-30-2.SDR DALA2015081604991Cusp Web · corrodedCORROSION ON CUSP WEB REPAIR, BS 830 BETWEEN X 54 TO X 60 RT. PREVIOUS REPAIR WAS REPLACED IAW SRM 53-05, FIG 131A-14 SHEET 1, 51-10-3, PAR 21 AND 14, 51-30-2.SDR DALA2015081604990Floor Panel · delaminatedDELAMINATION ON FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2015081604989Cusp Web · corrodedCORROSION ON RT CUSP WEB BS 1022 - 1023 BETWEEN X -54- X 60. REPAIRED IAW SRM 53-05, FIG 131A-10, SHEET 1.SDR DALA2015081604987Frame · corrodedCORROSION ON FRAME ANGLE BS 1212 BETWEEN LONGERONS 24 - 25L . FRAME ANGLE WAS REPAIRED IAW SRM 53-03D, FIG. 3.
Back to Mcdonnell Douglas MD-88