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 DALA2015090705473Cusp Web · corrodedCUSP WEB HAS A CRACK UNDER SEAT TRACK AT LBL 54 BETWEEN BS 826 & 845. A NEW CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-18, 51-30-5, 51-300-2, 53-01 FIG 2, 51-01, PAR 21, INS 1 AND 51-10-3, PAR 14/21.SDR DALA2015090705471Cusp Web · not reportedCUSP WEB HAS OUT OF LIMITS AREA BS 984 - 1003. DOUBLER WAS FABRICATED, TREATED AND PAINTED. REPAIR INSTALLED. CIC WAS APPLIED IAW SRM 51-10-3 PAR 14, 21 AND 38, 53-05, FIG 131A-1, SHEET 9, 51-30-2.SDR DALA2015090705468Skin · crackedCRACKED FUSELAGE SKIN, BS 1437 BETWEEN LONGERONS 2 - 3R. SKIN WAS REPAIR IAW ERA 537758-14, REV ORIGINAL.SDR DALA2015091005539Doubler · corrodedACFT HAS CORROSION ON PRODUCTION DOUBLER CUTOUT OF AFT LAVATORY SERVICE PANEL AT LONGERON 22L, BS 1315. COMPLIED WITH STEPS 1-5 OF ERA 538253-14, REV ORIGINAL.SDR DALA2015090705472Cusp Web · corrodedCUSP WEB HAS CORROSION ON REPAIR DOUBLER BS 503 - 522 BETWEEN X 54 TO X 60. REPAIR WAS REMOVED, FABRICATED, TREATED, PAINTED AND INSTALLED AND CIC WAS APPLIED IAW SRM 51-30-2, 53-05 FIG 131A, 51-10-3, PAR 21, 14 AND 38 AND 51-30-5.SDR DALA2015090605466Access Panel · corrodedACCESS PANEL CORRODED IN THE SETTLEMENT AND COUNTERSINK. ACCESS PANEL REPLACED.SDR DALA2015090605465Access Panel · corrodedACCESS PANEL CORRODED. ACCESS PANEL REPLACED.SDR DALA2015090705461Duct · crackedRADIO RACK COOLING EXHAUST DUCT CRACKED. REPAIRED IAW ER/A 464964-14MA, REV C.SDR DALA2015090605459Support · corrodedCORROSION WAS FOUND ON CEILING SUPPORTS BELOW FLOOR PANEL 1250C AT PAX CABIN FLOOR STRUCTURE. CORROSION WAS REMOVED, AREAS MEASURED WITHIN LIMITS WAS TREATED AND PAINTED, CIC WAS APPLIED IAW SRM 51-10-3, PAR 26, 21, 14, 38 AND ER/A 511165-14MA, REV B AND SUPPSDR DALA2015090605458Angle · crackedA CRACK WAS FOUND ON AN ANGLE AT RT SIDE WINDOW BELT AFT, UPPER BS 965. ANGLE WAS REPLACED IAW DWG 3920346, ITEM 501, REV ORG, SRM 51-30-2 AND 51-30-5.SDR DALA2015090605456Pin · unsecureACFT MAINTENANCE FOUND L1 SLIDE PARACHUTE PIN IS NOT ENGAGED. 1L DOOR SLIDE WAS REPLACED.SDR DALA2015090605455Longeron · corrodedACFT HAS CORROSION ON ANGLE DOUBLER ON LONGERON 18R BETWEEN BS 503 AND 522. ANGLE WAS REMOVED IAW SRM 51-30-5, DUE TO EXCCESIVE CORROSION WILL BE REPLACED, NEW ANGLE WAS FABRICATED IAW SRM 53-14-2 AND BWG 9930538. NEW ANGLE WAS TREATED AND PAINTED IAW SRM 51-SDR DALA2015090605454Skin · crackedCRACKS ON FUSELAGE SKIN, LENGTH 0.156" AND 0.125", ON BS 1418 BETWEEN LONGERON 2L AND 3L AND BETWEEN LONGERON 2R AND 3R, LENGTH .156". IN SAME STATION REASON FOR RE-WRITE : SHIMS BELOW LONGERON AFT STRAPS 2L, 2R DOES NOT COVER THE ENTIRE AREA OF INTENDED CONTSDR DALA2015090605453Access Panel · corrodedCORROSION WAS FOUND ON THE COUNTERSINK OF THE ACCESS PANEL 1335C. THE ACCESS PANEL WAS REPLACED.SDR DALA2015090605452Skin · wornWEAR WAS FOUND ON A REPAIR DOUBLER BS 1380 BTW LONGERONS 4 - 5L. THE DOUBLER REPAIR WAS REMOVED AND A NEW REPAIR WAS FABRICATED, TREATED, PAINTED, AND INSTALLED IAW SRM 51-30-2, SRM 53-01 AND 51-10-3. PAR 21 & 14.SDR DALA2015090705470Cusp Web · corrodedCUSP WEB FOUND CORRODED BETWEEN X 54 TO X 60, BS 256 - 261. REPAIRED IAW SRM 53-05, FIG 131A-10, SHEET 1 AND TREATED AND PAINTED IAW SRM 51-10-3 PAR 14 AND 21.SDR DALA2015090605460Cusp Web · corrodedCUSP WEB HAS CORROSION BS 620 - 624, X 54 - 60. CUSP WEB WAS REPAIRED IAW SRM 53-02, FIG 131A-13, 51-30-2 AND 51-10-3, PAR 14, 21 AND 38.SDR DALA2015090505451Access Panel · corrodedHAS CORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PLATE NR 1414C. FUEL ACCESS 1414C WAS REPLACED AND WILL BE INSTALLED UNDER CARD 2800-0340.SDR DALA2015090505450Access Panel · corrodedHAS CORROSION ON COUNTERSINK AND ELONGATED HOLES OF FUEL ACCESS PLATE NR 1373C. ACCESS PLATE 1373C WAS REPLACE AND WILL INSTALL UNDER CARD 2800-0120.SDR DALA2015090505447Access Panel · damagedACFT HAS DAMAGED METALIZED ON ACCESS PLATE 6502A. ACCESS PLATE 6502A WAS REPAIRED IAW SRM 51-70-1A, PAR 23.SDR DALA2015090505446Longeron · crackedACFT HAS A CRACK ON LONGERON 11L BS 1380 AT AFT ACCESORY COMPARTMENT. LONGERON 11L BETWEEN BS 1368 TO 1406 WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2015090505445Skin · crackedACFT HAS FIVE CRACKS, WERE FOUND ON FUSELAGE SKIN: RT SIDE.- 0.250", 0.180" AND 0.100" AT BS Y=1418 AND BETWEEN LONGERON 2 AND 3 AND LT SIDE-0.125" AND 0.100" AT BS Y=1418 AND BETWEEN LONGERON 2 AND 3. FUSELAGE SKIN WAS REPAIRED IAW ER/A 537744-14 AD REV A ASDR DALA2015090505444Cusp Web · crackedHAS A CRACK ON RT CUSP WEB BETWEEN BS 1231 AND 1250 X -54 AND X -60. CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-6, SHEET 1.SDR DALA2015090405421Frame · crackedA CRACK WAS FOUND ON SPLICE OF CANTED FRAME BETWEEN BS 1463 AND LONGERON 18R. REPAIRED IAW ETI-88-15-311, REV 1 AND ER/A 537771-14, REV ORIGINAL.SDR DALA2015090405420Frame · crackedA CRACK WAS FOUND ON SPLICE OF CANTED FRAME BS 1463 AND LONGERON 18L. CRACK WAS ATTENDED ETI-88-15-311, REV 1 AND ERA 537771-14, REV ORIGINAL.SDR DALA2015090405424Skin · crackedCRACK ON RT WING FIXED L/E XRS=406. RT WING FIXED L/E WAS REPAIRED IAW ER/A 537770-14. REV ORIGINAL AND ETI 88-15-310.SDR DALA2015090405423Skin · delaminatedACFT HAS A DELAMINATED INBD FLAP OTBD GUIDE VANE LOWER AND UPPER SKIN LT WING. DUE TO SEVERAL DAMAGE INBD FLAP OTBD GUIDE VANE WAS REPLACE WITH REPAIRED INBD FLAP OTBD GUIDE VANE.SDR DALA2015090405419Cusp Web · corrodedACFT HAS CORROSION ON REPAIR OF CUSP WEB X 54 - 60 BS 606-613. REPAIR WAS REMOVED AND A NEW REPAIR WAS FABRICATED TREAT AND PAINT AND INSTALLED IAW SRM 51-30-5, 53-05, FIG 131A-14, AND 51-10-3, PAR 14, 21, 26.SDR DALA2015090405418Access Panel · crackedCORROSION ON COUNTERSINK, WEAR AND CRACK SUPPORT ON FUEL ACCESS PANEL 1361C. THE ACCESS PANEL WAS REPLACED.SDR DALA2015090405417Cusp Web · crackedDURING CUSP WEB INSPECTION FOUND A CRACK UNDER SEAT TRACK LBL 54 BETWEEN BS 886 AND 905. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A, 51-10-3, PARR 14 AND 21, 51-30-2 AND 51-10-3 PAR 38.SDR DALA2015090405416Web · crackedA CRACK WAS FOUND ON WEB ON BS 1437 BETWEEN LONGERONS 1 AND 2L. WEB REPAIRED IAW ETI NR 88-15-317, REV 1 AND ER/A 537778-14 REV ORIGINAL.SDR DALA2015090405415Skin · not reportedFUSELAGE SKIN BS 210, LONGERON 5L. REPAIRED IAW ER/A 518525-14AD, SEC III, REV A.SDR DALA2015090405414Skin · corrodedHAS A BULGE ON FUSELAGE SKIN BETWEEN BS 218 AND LONGERONS 29-30R. THE SKIN WAS REPAIRED IAW ETI88-15-295, REV 1 AND ER/A 537751-14, REV ORIGINAL.SDR DALA2015090405412Beam · corrodedCORROSION FOUND ON BEAM FROM BS 1158 - 1210 AT AFT LOWER CARGO COMP DOOR JAMB. REPAIR SPACER AND NUT STRIPS WERE REPLACED IAW SRM 53-05, FIG 123.SDR DALA2015090405413Access Panel · corrodedCORROSION FOUND ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS NR 1311C. FUEL ACCESS NR 1311C WAS REMOVED AND WILL BE INSTALLED UNDER CARD 2800-0120.SDR DALA2015090305402Skin · crackedACFT HAS CRACKS ON FUSELAGE SKIN, LENGTH 0.156"AND 0.125", ON BS 1418 BETWEEN LONGERON 2LT AND LONG 3LT. 1 CRACK ON FUSELAGE SKIN, LENGTH 0.156", ON BS 1418 BETWEEN LONGERON 2RT AND LONG 3RT, CARD 8, ZONE 65. CRACKS ON FUSELAGE SKIN WERE REPAIRED IAW ER/A SDR DALA2015090205397Bearing · stuckACFT HAS A STUCK BEARING ON AILERON CONTROL TAB SECTOR LINK AT LT WING T/E. STUCK BEARING ON LT AILERON CONTROL TAB SECTOR LINK WAS REPLACED IAW CMM 27-11-17.SDR DALA2015090605457Frame · crackedDURING SERVICE CHECK, FOUND T-SHAPED CRACK ON FORWARD EDGE OF GEAR OPENING RT SIDE. REPLACED FRAME FWD RT SIDE MAIN WHEEL WELL IAW DWG 5930584, OPS CHECKED, DOOR CHECKED GOOD.SDR DALA2015090305403Longeron · crackedACFT HAS A CRACK ON LONGERON 3RT AND BS 1429 AT AFT ACCESSORY COMPARTMENT. LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2015090205399Scoop · crackedACFT HAS A CRACK ON VERTICAL STABILIZER INTAKE AIR SCOOP LT SIDE APPROXIMATELY BS Y=1478. CRACK ON VERTICAL STABILIZER INTAKE AIR SCOOP LT SIDE APPROXIMATELY BS=Y=1478 WAS REPAIRED AND FPI WAS ACCOMPLISHED AND WELDED AREA OF INTAKE AIR SCOOP LT SIDE NO CRACKSSDR DALA2015090205395Frame · corrodedCORROSION FOUND ON REPAIR OF FRAME, BS 1309 BETWEEN LONGERON 28R & 28L . REPAIR REPLACED IAW SRM 53-03D, FIG 2A, 51-30-2, 51-30-5 & 51-10-3.SDR DALA2015090205393Skin · wornACFT HAS WEAR ON FWD/AFT CORNERS DOUBLERS OF OTBD SKIN OF C1 DOOR LOWER AREA. DOUBLERS WERE FABRICATED, TREATED, PAINTED, AND INSTALLED IAW ER/A 486624-14MA, REV ORIGINAL.SDR DALA2015090105374Doubler · crackedFOUND A CRACKED PRODUCTION DOUBLER BETWEEN BS 995 - 977. REPLACED THE DOUBLER IAW AND 51-30-2, CMM 32-17-05.SDR DALA2015090105373Cusp Web · corrodedFOUND CORROSION OUT LIMITS ON CUSP WEB, BS 889 - 908 BETWEEN RBL 54 - 60. REPAIRED IAW SRM 53-05, FIG 131A, 51-10-3, PAR 14 AND 21-38 AND 51-30-2.SDR DALA2015090405425Floor Panel · damagedHAS CORROSION AND CRACKS FOUND ON RT FLOOR PANEL 120E, FOUND OUT OF LIMITS IAW ER/A 511165-14MA, REV LP2119851.SDR DALA2015090205398Skin · corrodedACFT HAS CORROSION AND DELAMINATION OTBD FLAP MID GUIDE FLAP VANE LOWER SKIN AT LT WING. DUE TO SEVERAL DAMAGE OTBD FLAP MID GUIDE VANE FLAP AT LT WING WAS REPLACED WITH REPAIRED MID GUIDE VANE AND WILL BE INSTALLED WITH CARD 5730-0631.SDR DALA2015090105376Flange · crackedFOUND A CRACK ON FLANGE J1 AT RT ENGINE 6 RT SIDE POSITION. THE ENGINE WAS REPLACED.SDR DALA2015090105372Frame · wornFOUND WEAR ON LT LOWER FRAME, BS 1510, BELOW SERVICE LIGHT SWITCH AT AFT ACCESSORY COMPARTMENT. FRAME WAS REPLACED IAW SRM 51-30-2, 51-10-4, AND 51-10-3.SDR DALA2015090105368Battery Pack · inoperativeDURING PREFLIGHT, MAINTENANCE FOUND EMERGENCY LIGHTS IN OVERHEAD PANEL AFT NOT WORKING. BATTERIES WERE REPLACED IN FWD OVERHEAD CEILING. CHECKED OK.SDR DALA2015090105365Frame · crackedFOUND A CRACK ON FRAME BS 1455, LONGERON 1. THE FRAME WAS REPLACED IAW SRM 51-30-2 AND 51-30-5 AND DWG 99860.0 , REV L.
Back to Mcdonnell Douglas MD-88