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 DALA2016032102136Skin · dentedSEVERAL DENTS ON OUTER SKIN OF C3 DOOR. DENTS ON OUTER SKIN WERE MEASURED ARE CONSIDERED ADJACENT THEREFORE ARE OUT LIMITS IAW SRM 53-04-1, PAR 7C DENTS ADJACENT WERE ATTENDED WITH ERA 543153-14, REV ORIGINAL.SDR DALA2016032102135Pan · crackedCRACK ON RT FWD LOWER CORNER RING PAN BS 1060-1079. REASON FOR RE-WRITE: IMPROPERLY DRILLED RT FWD LOWER CORNER AT RING PAN BS 1060-1079. RT FWD LOWER CORNER RING PAN BS 1060-1079 WAS REPAIRED IAW ER/A 543190-14, REV ORIGINAL.SDR DALA2016032102133Spar Cap · damagedDAMAGED AT TEE OF LT HORIZONTAL STABILIZER REAR SPAR UPPER CAP. TEE OF LT HORIZONTAL STABILIZER WAS REPAIRED IAW SRM 55-01, FIG 1, SHEET 2, 51-10-3, PAR 21 AND 14-51-30-1.SDR DALA2016031902095Floor Support · damagedBROKEN REPAIR DOUBLER ON FLOOR SUPPORT AT FLOOR PANEL 1079E. DOUBLER ON FLOOR SUPPORT WAS REPAIRED IAW SRM 53-05, FIG 131C.SDR DALA2016031902094Panel · damagedNICK ON RIB BORE AT RT SLAT PANEL NR 3 XOS= 286. BORE WAS REPAIRED IAW ER/A 543189-14 REV ORIG.SDR DALA2016031902092Frame · crackedCRACKED FRAME BS 1485 CANT AND 5 HRS POSITION RT SIDE AT AFT ACCESSORY COMPARTMENT. FRAME WAS REPARED IAW SRM 53-03, FIG 43.SDR DALA2016031902091Channel · wornWEAR ON FRAME C-RECEIVER OF W-CHANNEL X= 20 AND X= -20 BS 845, BS 864, BS 886, BS 905 AND BS 927 AT FLOOR STRUCTURE CABIN. CHANNELS WERE INSTALLED ON FLOOR PANELS NRS 826D SIDE LT AND 886 C SIDE LT IAW REMOVED AND INSTALLED, SRM 51-30-1 DRILLED SRM 51-10-4 DWSDR DALA2016031902090Cusp Web · corrodedCORROSION ON CUSP WEB BETWEEN BS 1244 TO BS 1249 BETWEEN X=-60 TO X=-54. CUSP WEB BETWEEN BS 1244 TI BS 1249 WAS REPAIRED IAW SRM 53-05, FIG 131A-13.SDR DALA2016031802069Heater · odorAFTER TAKEOFF, A F/A REPORTED THAT THE CABIN FILLED WITH A WHITE COLORED HAZE WITH AN ELECTRICAL ODOR. THE QRH WAS FOLLOWED AND THE GALLEY AND SIDEWALL LIGHTS WERE TURNED OFF. THE SMOKE SLOWLY DISSIPATED. THE ACFT WAS DIVERTED. MAINTENANCE PERFORMED AMDS TRSDR DALA2016031802081Frame · crackedCRACKED FRAME BS 1322 AND LONGERON 17L. DAMAGED FRAME AREA WERE REMOVED, HFEC INSPECTION WAS PERFORMED ON FRAME, REPAIR PARTS AND REWORKED AREA WERE TREATED, PAINTED, INSTALLED IAW SRM 51-10-2, 51-10-2A, 51-10-3 PAR 14/21, 51-30-1, 51-30-2, 51-30-5, 51-30-3, SDR DALA2016031802080Exhaust Duct · crackedCRACKED APU EXHAUST DUCT AT FUSELAGE SKIN. EXHAUST DUCT APU AT FUSELAGE SKIN WAS REPAIRED, REWELDED IAW ER/A 473221-14 MA, REV ORIGINAL.SDR DALA2016031802079Channel · crackedCRACKED CHANNELS AT REAR SPAR LT HORIZONTAL STABILIZER BETWEEN BS XHS = 23 TO 38 AND XHS= 62 APPROXIMATE CHANNELS WERE REPLACED IAW SRM 55-12-0D, FIG 4; 51-10-3, PAR 21 AND 14; 51-30-2 AND 51-10-2.SDR DALA2016031802077Longeron · crackedCRACK ON LONGERON 16L AND BS 1437 AT AFT ACCESSORY COMPARMENT. SECTION OF LONGERON WAS REPLACED IAW SRM 53-14, 4, 51-30-2, 51-30-5, 51-10-4, 51-10-1, 51-10-3 PAR 14, 21.SDR DALA2016031802076Cusp Web · corrodedDUE TO EXCESIVE CORROSION REPLACE LT CUSP WEB FROM BS 598 TO BS 712. LT CUSP WEB FROM STA 598 TO BS 712 WAS REPLACED IAW SRM 53-05, FIG 131A-24 AND DWG 9930538, REV CF SRM 51-30-2, SRM 51-30-1.SDR DALA2016031802075Longeron · corrodedCORROSION ON LONGERON 28LT BETWEEN BS 1231 TO BS 1240 AT AFT CARGO COMPARTMENT. FASTENERS AND CORROSION WERE REMOVED, REWORKED AREA WITHIN LIMITS WAS TREATED AND PAINTED, FASTENERS WERE INSTALLED IAW SRM 51-10-3 PAR 26, 21/14, 51-30-2, 53-02 PAR 13, 51-10-1.SDR DALA2016031802074Floor Panel · delaminatedDELAMINATED FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2016031802073Cusp Web · crackedCRACKED LT CUSP WEB AT BS 905, X 54 PAX CABIN FLOOR STRUCTURE. REPAIRED IAW SRM 53-05, FIG 131A-1, SHEET 1- 10.SDR DALA2016031802072Cusp Web · corrodedCORROSION ON PREVIOUS CUSP WEB REPAIR DOUBLER BETWEEN BS 1155 AND 1174, RT X -44 TO X -60. CORROSION WAS ATTENDED IAW SRM 51-30-2, 51- 10-3, PARS 14 AND 21, 53-05, FIG 131A-5.SDR DALA2016031802071Cusp Web · corrodedCORROSION ON PREVIOUS REPAIR DOUBLER ON RT CUSP WEB BS 795 TO 807, X=-60 TO X=-54 AT FLOOR STRUCTURE CABIN. RT CUSP WEB BS Y=788 TO Y=807 WAS REPLACED IAW SRM 53-05, FIG 131A-2, DWG 9930538 REV CF, SRM 51-30-2, 51-30-5.SDR DALA2016031802070Floor Support · crackedCRACK AND CORROSION ON FLOOR SUPPORT BETWEEN BS 1287 TO 1309 AND X=0 AT CABIN PAX. FLOOR SUPPORT WAS REPLACED IAW DWG 9936580, REV BW AND BS, AND SRM 51-10-3 PAR 21 AND 14; 51-10-4; 51- 30-2; 51-30-5.SDR DALA2016031902093Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINK AT FUEL ACCES PLATE NR 1367C. CORROSION ON COUNTERSKIN WAS REMOVED AND MEASURE 3 HOLES ADJACENT WERE FOUND WITH .545", .542", .540". THEREFORE IT IS OUT LIMITS FUEL ACCESS DOOR 1369C WAS REPLACED IAW IPC 57-30-00 ASDR DALA2016031802078Web · crackedCRACKED INNER WEB XRS 173 AT RT WING FIXED L/E INNER STRUCTURE. WEB CREAKED WAS REPAIRED IAW ETI-88-16-06 REV 2 AND ER/A 543205-14 REV ORIGINAL.SDR DALA2016031702052Pan · crackedCRACK ON RT FWD LOWER CORNER RING PAN BS=1212- BS 1231. REASON FOR RE-WRITE: IMPROPERLY DRILLED ON RT FWD LOWER CORNER RING PAN BS=1212-BS 1231. DAMAGE AREA WAS REPAIRED IAW ETI 88-16-104, REV 3 AND ER/A 543194-14, REV ORIGINAL.SDR DALA2016031702048Access Panel · corrodedCORROSION ON COUNTERSINK FUEL ACCES PLATE NR 1466C. ACCESS DOOR 1466C WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016031702047Door Frame · corrodedCORROSION ON WEB BETWEEN LONGERON 9 - 24R BS 629 - 700 MID CARGO BAY DOOR FRAME. CORROSION REMOVED IAW SRM 51-10-3, PAR 26, 14, 21 UT MD/DC NDT SPM 04-00-07, PAR 5, FIG 3.SDR DALA2016031702046Cusp Web · crackedDUE TO EXCESSIVE CORROSION ON CRACKED CUSP WEB BETWEEN BS 826 AND 845, RBL 54 - 60. CUSP WEB REPAIRED IAW SRM 53-05, FIG 131A-16, 51-10-3 PAR 14 AND
21, 51-30-2.SDR DALA2016031702045Channel · crackedCRACKS ON FLOOR CHANNEL. CHANNEL REPAIRED IAW 53-05, FIG 131B.SDR DALA2016031702044Skin · delaminatedDELAMINATION ON LWR SURFACE OF LT OTBD FLAP INBD VANE, BELOW PREVIOUS REPAIRED DOUBLER AREA. DELAMINATION ON LWR SURFACE OF LT OTBD FLAP, INBD VANE, BELOW PREVIOUS REPAIR DOUBLER AREA WAS REPAIRED IAW SRM 57-03, PARR 11 AND CARD 2000-8149-06, 1996707, JOB 00SDR DALA2016031702043Floor Panel · delaminatedFLOOR PANEL DELAMINATED IN CABIN PAX. FLOOR PANEL REPLACED IAW AMM 53-20-01-201.SDR DALA2016031702042Cusp Web · corrodedCORROSION ON LT CUSP WEB BS 1220. LT CUSP WEB BS 1220 WAS REPAIRED IAW SRM 53-05, FIG 131A-13.SDR DALA2016031702041Cusp Web · misrepairedIMPROPER REPAIR ON RT CUSP WEB X=-50 TO X=-60 BETWEEN BS 994 TO BS 1003 AT FLOOR STRUCTURE CABIN. DUE EXCESIVE DAMAGE CUSP WEB WAS REPLACED IAW SRM 53-05, PAR 144.C.(2) AND 51-30-2, 51-30-5, 51-30-1, 51-30-8, 51-10-4, 51-10-3 PAR 14 AND 21 DWG 9930612, REV CGSDR DALA2016031702040Cargo Track · corrodedCORROSION AND ELONGATED HOLES ON LT CARGO TRACK FROM BS 1003 - 1220 AT AFT CARGO COMPARTMENT. THE CARGO TRACK WAS REPLACED IAW SRM 51-30-1, 51-30-2 AND 51-30-5.SDR DALA2016031702039Floor Panel · damagedELONGATED HOLES ON FLOOR PANEL NR 1155A. ENLONGATED HOLE ON FLOOR PANEL NR 1155A WERE REPAIRED IAW SRM 51-70-1D.SDR DALA2016031702038Floor Support · brokenBROKEN FLOOR CHANELS ON FLOOR PANEL NR 1155A LOWER SURFACE. BROKEN FLOOR CHANELS ON FLOOR PANEL NR 1155A LOWER SURFACE WAS REPAIRED IAW SRM 51-70-1D.SDR DALA2016031702037Floor Panel · crackedCRACKED FLOOR PANEL 1250A. CRACKED FLOOR PANEL WAS REPAIRED IAW SRM 51-70-1D, PAR 10.SDR DALA2016031702036Floor Panel · delaminatedFLOOR PANEL DELAMINATED IN CABIN PAX. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2016031602023Pan · crackedDURING REMOVAL OF THE STOP WAS FOUND CRACK ON INNER PAN OF AFT CARGO DOOR. REPAIRED IAW SRM 52-03-D FIG 10. FOUND WITHIN LIMITS IAW SRM 52-03, FIG. 10.SDR DALA2016031602021Cusp Web · corrodedCORROSION ON LT CUSP WEB X=55 TO X=60 BETWEEN BS 1036 TO BS 1038 AT FLOOR CABIN STRUCTURE. CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-14, 51-30-5, 51-10-3 PAR 21, 14 AND 38.SDR DALA2016031602020Angle · crackedCRACK ON ANGLE BETWEEN X 34 TO X 44, BS 1309 . ANGLE WAS REPLACED IAW 51-30-5, DWG 9912243, REV JS.SDR DALA2016031602019Access Panel · corrodedCORROSION ON COUNTERSINK AT FUEL ACCESS PLATE NR 1335C. FUEL ACCESS DOOR 1335C WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016031602018Access Panel · corrodedCORROSION ON COUNTERSINK AT FUEL ACCES PLATE NR 1311C. FUEL ACCESS DOOR 1311C WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016031602017Access Panel · corrodedCORROSION ON COUNTERSINKS FUEL ACCESS PANEL 1357C LT WING. FUEL ACCESS DOOR 1357C WAS REPLACE IAW SRM: 51-22-2A.SDR DALA2016031602016Cusp Web · corrodedCORROSION ON RT CUSP WEB, UPPER AND LOWER SURFACE, BS 1098 TO BS 1117 X=-54 TO X=-60 AT FLOOR STRUCTURE CABIN PASSENGER AREA WAS REPAIRED IAW SRM 53-05, FIG 131A-13, SHEET 1-9.SDR DALA2016031602015Access Panel · corrodedCORROSION ON COUNTERSINK FUEL ACCESS PANEL 1355C LT WING. FUEL ACCESS DOOR 1355C WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016031602014Access Panel · corrodedCORROSION ON COUNTERSINK FUEL ACCESS PANEL 1363C LT WING. ACCESS DOOR WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016031602013Access Panel · corrodedCORROSION ON COUNTERSKIN FUEL ACCESS PANEL NR 1456C RT WING. FUEL ACCESS DOOR 1456C WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016031602012Access Panel · corrodedCORROSION ON COUNTERSINK FUEL ACCESS PANEL 1371C LT WING. FUEL ACCESS DOOR 1371C WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016031602011Frame · crackedCRACKED CAP ON FRAME, BS 1463, CANT 4 HRS POS AT AFT ACCESSORY COMPARTMENT. CAP WAS REPAIRED IAW SRM 53-01, FIG 1, FIG 2, SRM 51-30-5, SRM 51-01, PAR 21.SDR DALA2016031602010Longeron · crackedCRACKED LONG 12 LT FROM BS 1437 AT AFT ACCESSORY COMPARTMENT. LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2016031602009Cusp Web · corrodedCORROSION ON CUSP WEB FROM BS 503 TO 579 BETWEEN X=60 TO X=54 AT RT FLOOR CABIN PAX. CUSP WEB 503 TO 598 WAS REPLACED DUE TO EXCESSIVE DAMAGE IAW SRM 51-300-2, 51-30-5, 51-10-3 PAR 14, 21 AND DWG 9930538, REV BF.
Back to Mcdonnell Douglas MD-88