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 DALA2016041903029Beam · crackedFWD GALLEY SERVICE DOOR- BEAM NR 4 CRACKED AT FWD END. INSTALLED REPAIR PART REF MD 88, SRM 52-05, FIG 25, SHEET 17.SDR DALA2016041903028Cusp Web · corrodedCORROSION ON CUSP WEB UPPER AND LOWER SURFACE FROM 1041-1060 BETWEEN X=54 -X=60 LT SIDE. AREA WAS REPAIRED IAW SRM 53-05, FIG 131, A-6, 51-10-3 PAR 14, 21, 38 , 51-30-2, 51-30-5, 51-30-1.SDR DALA2016041903027Cusp Web · corrodedCORRODED PREVIOUS REPAIR CUSP WEB BETWEEN BS 674-693, X=54-60, RT AT CPAX. PREVIOUS REPAIR ON CUSP WEB WAS REPLACED IAW SRM 53-05, FIG 131A-21 AND 51-10-3 PAR 14 AND 21 AND 51-30-2.SDR DALA2016041903026Longeron · crackedCRACK ON LONGERON 4L BS 200. LONGERON WAS REPLACED IAW SRM 53-02, FIG 18, PAR 12, 51-30-5, AND CARD 5330-01204-02-03.
SDR DALA2016041903025Cusp Web · corrodedCORROSION ON RT CUSP WEB BETWEEN BS 1063 TO 1075 AT PAX CABIN. CORROSION ON RT CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-14.SDR DALA2016041903024Longeron · crackedCRACKED LONGERON 29R BS 180. LONGERON WAS REPLACED IAW SRM 53-02, FIG 18, SHEET 2, 51-30-2, 51-10-4, 51-30-5, PAR 7, FIG 10, PAR 14, 21.SDR DALA2016052604153Skin · damagedLEFT ELEVATOR TIP LIGHTNING EXIT DAMAGE. REPLACED LT ELEVATOR.SDR DALA2016041802999Bearing · corrodedRUSTED BEARING OF AILERON DAMPER LINK, OTBD POSITION, BS XA=404 APPROXIMATELY AT RT WING REAR SPAR. BEARING AT AILERON DAMPER LINK OTBD RT WING REAR SPAR WAS REPLACED IAW CMM 20-10-7.SDR DALA2016041802997Bushing · damagedSCRATCHES ON LOWER BUSHINGS XF=49 ON ATTACH POINT LT ELEVATOR. BUSHINGS OF BS XF=49 ON ATTACH POINT LT ELEVATORS WERE REPLACED IAW CMM 24-30-1.SDR DALA2016041802994Spar · not reportedDURING NDT INSPECTION, A DISCREPANT AREA WAS FOUND, 7 DIFFERENT FASTENERS OF PSE, ON LOWER SKIN REAR SPAR BETWEEN XRS=163 TO 168 AT RT WING. THESE NRC IS ATTENDED WITH ER/A NR 545093-14AD, REV ORIGINAL. WILL BE MONITORED WITH LOG PAGE NR 2427428.SDR DALA2016041802993Spar · not reportedDURING NDT INSPECTION A DISCREPANT AREA WAS FOUND, 7 DIFFERENT FASTENERS OF PSE, ON LOWER SKIN REAR SPAR BETWEEN XRS=163 TO 168 AT LT WING. THESE NRC IS ATTENDED WITH ER/A NR 545093-14AD, REV ORIGINAL.SDR DALA2016041802991Longeron · crackedCRACKED LONGERON 29R BS 180 AT ELECTRONIC EQUIPMENT COMPARTMENT. LONGERON WAS REPLACED IAW SRM 53-02, FIG 18, SHEET 2, 51-30-2, 51-10-4, 51-30-5 PAR 7, FIG 10, PAR 14, 21.SDR DALA2016041802990Web · corrodedCORRODED DIAPHRAGM BETWEEN BS 210 TO 218 X=54 TO 60 RT AT CPAX. DIAPHRAGM BETWEEN BS 210 TO 218 X=54 TO 60 RT WAS REPAIRED IAW SRM 51-70-4, FIG 2, SRM 51-30-2, SRM 51-30-5, SRM 51-30-8, SRM 51-10-3, PAR 14, 21, 38.SDR DALA2016041802989Cargo Track · crackedCRACK ON LOWER SUPPORT OF TIE TRACK BETWEEN BS 1212 TO 1231 AND PROJECTION LONGERONS 28LT TO 27LT AT AFT CARGO COMPARTMENT. SUPPORT WAS REPLACED IAW SRM 53-05, FIG 4G, 51-10-3, PAR 21,14, 51-30-2, 51-30-5.SDR DALA2016041802988Seat Track · corrodedCORROSION ON LT SEAT TRACK FROM BS 966 TO BS 967 AND X=-54 AT PAX CABIN. DAMAGE AT LT SEAT TRACK WAS REMOVED IAW SRM 53-05, FIG 4A. NEW PLUG WAS ADJUSTED IAW SRM 53-05 PAR 4A. PLUG AND REWORKED AREA WERE TREATED AND PAINTED IAW SRM 51-10-3, PAR 14/21.SDR DALA2016041802987Support Fitting · corrodedCORROSION ON BUSHING BORE AT RT MLG ACTUATOR SUPPORT FITTING. DAMAGE ON BORE WAS REMOVED WITH FINAL DIMENTIONS AFTER REWORK: ID=2.406", THEREFORE WITHIN LIMITS IAW DWG SR09570087, REV B, NOTE 11.SDR DALA2016041802983Support Fitting · corrodedCORROSION ON BUSHING BORE AT LT MLG ACTUATOR SUPPORT FITTING. DAMAGE ON BORE WAS REMOVED WITH FINAL DIMENSIONS AFTER REWORK: ID=2.315", THEREFORE WITHIN LIMITS IAW DWG SR09570087, REV B, NOTE 11.SDR DALA2016041802982Frame · crackedCRACK ON FRAME OF BS 1322 AND LONGERON 17R. FRAME WAS REPAIRED IAW ER/A 493697-14MA, REV B.SDR DALA2016041802981Cusp Web · corrodedCRACK ON LT CUSP WEB, BS 885, X=53, LOWER SURFACE, AT PASSENGER CABIN CRACKED ON LT CUSP WEB BS 85, X=53 WAS REPAIRED IAW SRM 53-05, FIG 131A-1 AND 51-30-2, 51-30-5, 51-10-3 PAR 14, 21, 38.SDR DALA2017060504453Skin Splice · crackedER/A 545885-14 SECTION I ADDRESSES CRACK DAMAGE FOUND ON SKIN SPLICE AT FS1429 BETWEEN L2L/L3L AND L2R/L3R. THIS REPAIR COMPLETED 16APR16.SDR DALA2016041802992Pan · crackedCRACK ON RING PAN STRUCTURE AT FWD LOWER CORNER AND AFT UPPER CORNER BETWEEN BS 1193-1212 RT SIDE. FASTENERS AND DAMAGE WERE REMOVED, REPAIR PARTS WERE FABRICATED AND INSTALLED IAW SRM 51-30-2, 51-30-5, 53-05, FIG 122 AND ER/A 487747-14MA, REV ORIGINAL AND 4SDR DALA2016041802986Channel · crackedCRACK ON CHANNEL AT FLOOR PANEL NR 693A. CRACK ON CHANNEL WAS ATTENDED IAW SRM 53-05 FIG 131B, SH 3, 51-10-3 PAR 14, 21 AND 38, 51-30-2.SDR DALA2016041802985Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PLATE NR 1466C. FOUND NR 1 HOLE OUT OF LIMITS WITH .571" BUSHING WAS FABRICATED AND INSTALLED WITH OD .329" AND COUNTERSINK .508" IAW SRM 51-22-2A, PAR 6, COND II.SDR DALA2016041802984Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PLATE NR 1472C. ACCESS WAS REPLACED IAW SRM 51-22-2A, COND. II.SDR DALA2016041802980Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PLATE NR 2302C. FOUND NR 1 HOLE OUT OF LIMITS WITH .671" BUSHING WAS FABRICATED AND INSTALLED WITH OD .439" AND COUNTERSINK .635" IAW SRM 51-22-2A PAR 6, COND. II.SDR DALA2016041802979Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PLATE NR 1464C. FOUND NR NR 1 HOLE OUT OF LIMITS WITH .540" BUSHING WAS FABRICATED AND INSTALLED WITH OD .329" AND COUNTERSINK .517" IAW SRM 51-22-2A, PAR 6 COND II.SDR DALA2016041802978Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA AT FUEL ACCESS PLATE 1335 C. CORROSION WAS REMOVED, ACCESS WAS MEASURED AND WAS FOUND NR 1 HOLE OUT OF LIMITS WITH .675", BUSHING WAS FABRICATED AND INSTALLED WITH OD .439", COUNTERSINK .635" IAW SRM 51-22-2A, PAR SDR DALA2016041802977Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PLATE 1478C. FOUND 5 HOLE OUT OF LIMITS, MAXIMUM HOLE MEASURED WITH .543" BUSHING WAS FABRICATED AND INSTALLED WITH OD .329" COUNTERSINK .509" IAW SRM 51-22-2A, PAR 6, CONDITION II.SDR DALA2016041802976Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PLATE NR 1436C. ACCESS WAS REPLACED IAW SRM 51-22-2A CONDITION II.SDR DALA2016041802975Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PLATE NR 1307C. ACCESS WAS REPLACED IAW SRM 51-22-2A CONDITION II.SDR DALA2016041802974Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PLATE NR 2301C. ACCESS WAS REPLACED IAW SRM 51-22-2A, CONDITION II.SDR DALA2016041802973Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINK OF FUEL ACCESS PLATE NR 1410C. ACCESS WAS REPLACED IAW SRM 51-22-2A, CONDITION II.SDR DALA2016041702972Cusp Web · corrodedCORROSION ON RT CUSP WEB PREVIOUS REPAIR BETWEEN BS 1231-1250 AND X=-54 TO X=-60. CORROSION WAS REPAIRED IAW SRM 53-05, 51-30-5, 51-10-3, PAR 14, 21, 38. REPAIR DOUBLER WAS REPLACED.SDR DALA2016041702969Cusp Web · corrodedCORROSION ON CUSP WEB UPPER AND LOWER SURFACE BS 541-560 BETWEEN X=54-X=60 LT SIDE. DAMAGE AREA WAS REPAIRED IAW SRM 53-05, FIG 131A-14 , 51-10-3 PAR 14/21, 51-30-1, 51-30-2 AND 51-30-5.SDR DALA2016041803000Floor Panel · puncturedPUNCTURE ON FLOOR PANEL 769G. THE FLOOR PANEL WAS REPAIRED SRM 53-01, FIG 4 , 51-30-2.SDR DALA2016041802996Battery Pack · inoperativeMSP MAINTENANCE FOUND THE EMERGENCY PATH LIGHTING INOPERATIVE BETWEEN SEAT ROWS 25 AND 31. THE BATTERY PACK WAS REPLACED AND GROUND WIRE L1844B16N WAS FOUND LOOSE AND WAS RESECURED.SDR DALA2016041802995Skin · damagedDAMAGE METALIZED ON RUDDER. DAMAGE METALIZED WAS REPAIRED IAW ERA NR 092613-14MA.SDR DALA2016041702971Rib · crackedCRACKED RIB ON RT WING FIXED L/E BS XRS 324. THE RIB WAS REPAIRED IAW SRM 57-06 B, D, FIG 18.SDR DALA2016041702970Floor Panel · crackedCRACKED FLOOR PANEL 693A. THE FLOOR PANEL WAS REPAIRED IAW SRM 53-05,51-30-2.SDR DALA2016041702968Floor Panel · corrodedCORROSION ON FLOOR PANEL 160G. THE FLOOR PANEL WAS REPLACED IAW SRM 51-10-2, DWG 9957828, REV: Y.SDR DALA2016041702967Cusp Web · corrodedSURFACE CORROSION ON RT CUSP WEB BETWEEN BS 579-598 AND X=-54 TO X=-60, CARD 83, ZONE 201. CUSP WEB RT 503 TO 598 WAS REPLACED IAW SRM 51-30-1, AMM 20-30-1, 51-30-2, 51-30-5, DWG 9930538, REV BF.SDR DALA2016041702966Floor Panel · crackedCRACK ON FLOOR PANEL NR 389A AND DISBONDED RUBSTRIP AT CAB PAX. CRACK WAS REPAIRED AND STRIP WAS BONDED IAW SRM 53-01, FIG 4 , 51-30-2 , 51-20-0.SDR DALA2016041602965Rib · corrodedCORROSION AND WEAR ON BORES OF LT WING SLAT PANEL NR 2, RIBS BS XOS=196, XOS=240 AND XOS=286. RIBS BORES WERE REPAIRED WITH NEXT FINAL DIMENTIONS: XOS=196, 4 HOLES: 0.938" XOS=240, 2 HOLES: 0.940" XOS=286, 2 HOLES:1.123" AND REPAIR BUSHINGS WERE FABRICATED SDR DALA2016041602962Cusp Web · corrodedCORROSION ON CUSP WEB, UPPER AND LOWER, BS 1028 TO 1030 BETWEEN X=54-X=60 LT SIDE. CORROSION WAS REPAIRED IAW SRM 53-05, FIG 131-A -13 , 51-30-2, 51-30-5 , 51-10-3 PAR 14, 21, 38.SDR DALA2016041502937Battery Pack · inoperativeMAINTENANCE FOUND THE AFT CABIN EMERGENCY LIGHTS INOPERATIVE. BATTERY PACK WAS REPLACED AND THE LIGHTS CHECKED OK.SDR DALA2016041802998Bearing · corrodedCORROSION ON RUDDER YOKE BEARING. BEARING WAS REPLACED IAW AMM 27-20-03.SDR DALA2016041602964Cusp Web · corrodedCORRODED RT CUSP WEB NEAR TO PREVIOUS REPAIR BETWEEN BS 1003 TO 1022, X=54-60 RT AT CPAX. RT CUSP WEB WAS REPLACED IAW SRM 51-30-2, SRM 53-05, FIG 131A, SRM 51-10-3 PAR 14, 21, 38.SDR DALA2016041602963Support Fitting · corrodedCORROSION ON MLG SUPPORT FITTING LOWER AREA BS XCW=98.500. AREA WAS REPAIRED IAW SRM 57-03, FIG 34, 51-10-3, P 14-21 AND 51-30-5.SDR DALA2016041502936Seat Track · corrodedCORROSION ON LT SEAT TRACK BS 577 TO 578 AND 671 TO 672 AND X=22 AT PAX CABIN. DAMAGED AREAS ON LT SEAT TRACK BS 577 TO 578 AND 671 TO 672 AND X=22 WERE REPAIRED IAW SRM 53-05, FIG 4A.SDR DALA2016041502934Cusp Web · crackedCRACK ON CUSP WEB BS 864-868 BETWEEN X=+54 TO X=+60. REMOVED DAMAGE AND FABRICATE A REPAIR IAW SRM 53-05, FIG 131, A-1, SH 1.
Back to Mcdonnell Douglas MD-88