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 DALA2016031602008Longeron · crackedCRACK ON LONGERON END FITTING 1 BS 1338. LONGERON END WAS REPLACED IAW SRM 53-14-3, 51-30-5 AND 51-10-3, PAR 21 AND 14.SDR DALA2016031602007Skin · wornWEAR ON INBD EDGE ON OTBD FLAP, INBD GUIDE VANE RT WING. INBD GUIDE VANE RT WING WAS REPAIRED IAW SRM 57-03D, PAR 11.SDR DALA2016031602006Membrane · corrodedCORROSION FOUND ON MEMBRANE, X -52 TO -56, BS 210 - 218. REPAIRED IAW SRM 51-10-3, PAR 26, 14, 21 AND 38 AND ER/A 511165-14MA, REV C.SDR DALA2016031602005Floor Panel · damagedBROKEN AND MISSING NUT ON FLOOR PANEL 200A. THE FLOOR PANEL WAS REPAIRED IAW SRM 51-70-10, SRM 51-30-2 AND DWG 9952523.SDR DALA2016031602004Floor Support · crackedCRACKED CHANNEL AT FLOOR PANNEL 1079A, CHANNEL WAS REPAIRED IAW 51-70-1D.SDR DALA2016031602022Cusp Web · corrodedCRACKED RT CUSP WEB X=-60 TO X=-54 BETWEEN BS 808 TO BS 813 AT FLOOR STRUCTURE CABIN. CUSP WEB REPAIRED IAW SRM 51-30-2, 51-01, PAR 4, 21, FIG 131A-1 AND 51-10-3, PAR 38.SDR DALA2016031501955Intercostal · crackedCRACKED INTERCOSTAL BS 193 X+30 TO X=+50 Z=1, AT W1. INTERCOSTAL WAS REPAIRED IAW SRM 51-70-5, 51- 30-2, 51-30-1, 51-30-5.SDR DALA2016031501954Exhaust Duct · crackedCRACKED EXHAUST DUCT OF APU BETWEEN LONGERON 12 RT AND 14 RT BS 1401 TO BS 1416. CRACKS EXHAUST DUCT OF APU WERE REPAIRED, WELD CRACKS IAW ER/A 473221-14MA REV ORIGINAL.SDR DALA2016031501953Skin · dentedDENT AT VERTICAL STABILIZER TIP AT BS YV 215.200. DENT ON VERTICAL STABILIZER WAS REPAIRED IAW SRM 55-01, FIG 4, SHEET 2.SDR DALA2016031501952Intercostal · corrodedAFTER CARGO INTERCOSTAL CORRODED AT UPPER HORIZONTAL ANGLE UNDER SIDE BETWEEN BS 1309-1322 L27L- L28L. INTERCOSTAL WAS REPLACED IAW DWG N9936718, REV M SRM 51-30-2, 51-10-4, 51-10-3 PAR. 14, 21 51-30-5.SDR DALA2016031501951Skin · damagedDAMAGED METALIZER ON RUDDER ACCESS NR 6513G, 6508G AND 6502G. METALIZER ON RUDDER ACCESS NR 6513G, 6508G AND 6502G WERE REPAIRED IAW SRM 51-70-1A.SDR DALA2016031501950Longeron · crackedCRACKED LONGERON 16 LT FROM BS 1437 AT AFT ACCESSORY COMPARTMENT. LONGERON WAS REPLACED IAW SRM 51-30-2, 51-10-4, 51-10-3, PAR 21 /14 AND 51-30-5.SDR DALA2016031501949Cusp Web · corrodedCORROSION ON RT CUSP WEB FROM BS 665 TO BS 664 AND X=-54 TO X=-60 AT CPAX. AREA WAS REPAIRED IAW SRM 53-05, FIG 131A-5, SHEET 1, 51-30-2, 51-30-8, 51-10-3 PAR.14,21,26-38.SDR DALA2016031501948Longeron · crackedCRACKED LONGERON 4 RT BS 1437 AT AFT ACC COMPARTMENT. LONGERON WAS REPAIRED IAW SRM 53-02 FIG 1, 51-30-5, 51-10-3 PAR 21 AND 14 51-10-4.SDR DALA2016031501947Finger Doubler · corrodedCORROSION ON INNER FINGER DOUBLER AT SPLICE 26 LT BETWEEN BS 1193 AND BS 1231. FASTENERS WERE REMOVED IAW SRM 51-30-2. CORROSION WAS REMOVED IAW SRM 51-10-3, PAR 26. FINGER DOUBLER WAS REMOVED IAW SRM 51-30-2 AND 51-30-5. FINGER DOUBLER WAS FABRICATED IAW SRMSDR DALA2016031501943Cusp Web · not reportedAREA OUT OF LIMITS ON LEFT CUSP WEB X=54/60 FROM BS 772 TO 775 AT CABIN PASSENGER AREA. AREAS WAS REPAIRED IAW SRM 53-05, FIG 131A-113, SHEET 1.SDR DALA2016031401916Unknown · unknownNOSEWHEEL STEERING REQUIRES EXCESSIVE FORCE ON TAXI. DURING TAKEOFF ROLL, ACFT VEERED TO THE LT AT APPROXIMATELY 80 KTS. POWER SETTING WAS EVEN AND NO TRANSWIND PRESENT. REPLACED BOTH NOSE TIRES, CHECKED SPEED BRAKES, REPLACED LT AND RT NOSE WHEEL STEERINGSDR DALA2016031501946Intercostal · corrodedCORROSION ON INTERCOSTAL FROM BS 769 TO BS 788 BETWEEN LONGERON 27RT TO 28RT AT MID CARGO COMPARTMENT. INTERCOSTAL WAS REMOVED AND NEW INTERCOSTAL WAS INSTALLED IAW SRM 51-30-2, 51-30-5 NEW INTERCOSTAL WAS FABRICATED IAW DWG 9915554, REV J AND SRM 51-10-2.SDR DALA2016031501945Intercostal · corrodedCORROSION ON INTERCOSTAL FROM BS 769 TO BS 788 BETWEEN LONGERON 28LT TO 27LT AT MID CARGO COMPARTMENT. INTERCOSTAL WAS REPLACED BY NEW 1 IAW SRM 51-30-2, 51-30-5, 51-10-4.SDR DALA2016031501944Pressure Panel · corrodedCORROSION ON SLANT PRESSURE PANEL BS 939 BETWEEN BS 939 BETWEEN X=22 TO X=44 AT WING BOX. SLANT PRESSURE PANEL WAS REPLACED IAW SRM 51-30-2, 51-10-3 PAR 14, 21, 38 51-10-4 DWG 9923419, REV AG, AMM 20-30-01.SDR DALA2016031401942Charger · failedMAINTENANCE FOUND EMERGENCY LIGHTS INOPERATIVE FROM SEAT ROWS 1 TO 30. THE BATTERY CHARGER AND DIODE WAS REPLACED.SDR DALA2016031401915Bushing · corrodedCORROSION ON BUSHING HOUSING AT REACTION LEVER FITTING LT INBD SPOILER AREA. BUSHINGS HOUSINGS WERE REPAIRED IAW ER/A 543179-14, REV ORIGINAL.SDR DALA2016031401914Bushing · corrodedCORROSION ON BUSHING HOUSING AT REACTION LEVER FITTING RT INBD SPOILER AREA. BUSHINGS HOUSINGS WERE REPAIRED IAW ER/A 543179-14, REV ORIGINAL.SDR DALA2016031401912Angle · crackedCRACK ON ANGLE BS 237 BETWEEN LONGERON 27 TO 28R IN FWD CARGO COMPARTMENT. NEW ANGLE WAS INSTALLED IAW SRM 51-30-2, 51-30-5, 51-10-3. PAR 14/21, 51-10-4, 51-10-2 AND DWG 9915554, REV U.SDR DALA2016031401911Doubler · corrodedCORROSION ON DOUBLER REPAIR FROM BS 640 TO BS 651 BETWEEN X=60 TO X=54 AT RT FLOOR CABIN PASSENGER AREAS WERE REPAIR IAW SRM 53-05, FIG 131A-2, SHEET 5.SDR DALA2016031401910Skin · out of limitsSKIN OUT OF LIMITS BETWEEN LONGERONS 3 & 4L AT BS 610 - 695. REPAIRED IAW SRM 51-30-2, 51-10-4, 51-10-3. PAR 14 AND 21 AND 53-04-2, FIG 2, SHEET 6 AND 17.SDR DALA2016031401909Support Fitting · corrodedCORROSION ON LT HORIZONTAL STABILIZER SUPPORT FITTINGS BORES AT VERTICAL STAB REAR SPAR. BORES AT VERTICAL STAB WERE REPAIRED, REAMED WITH FINAL DIMENTION: ID=1.436", THEREFORE WITHIN LIMITS OF REPAIR. REPAIR BUSHINGS WERE FABRICATED AND INSTALLED IAW SRM 55-0SDR DALA2016031401906Hinge · corrodedCORROSION ON BORE TO ATTACH BUSINGS AT LT ELEVATOR HINGE NR 1. BORES WERE REPAIRED IAW ETI-88-16-101, REV 1 AND ER/A 543191-14 REV ORIGINAL.SDR DALA2016031401905Frame · crackedCRACKED WEB ON FRAME STA 463 CANT POS 11 HRS AT AFT ACCESORIES COMPARTMENT. WEB, STIFFENERS AND DOUBLERS WERE REMOVED IAW SRM 51-30-2 AND 51-30-5. WEB WAS FABRICATED IAW DWG 9953015, REV. CB ITEM-53. NEW WEB AND STIFFENERS DOUBLER WERE INSTALLED IAW SRM 51-3SDR DALA2016031401904Stiffener · crackedCRACKED STIFFENER ON FRAME BS 1463 CANT POS 11 HRS AT AFT ACCESSORIES COMPARTMENT. STIFFENER WAS REPLACED IAW SRM 51-10-3, 51-30-5 AND 51-10-4 AND DWG 9953015 REV. CB.SDR DALA2016031401903Frame · crackedCRACKED WEB ON FRAME BS 1463 CANT 2 HRS POS AT AFT ACCY COMPARTMENT. WEB AND DOUBLER WERE REPLACED IAW DWG 9953015, REV CB ITEMS -58 AND -38 AND SRM 51-10-3, 51-10-3, 51-30-5 AND 51-30-2.SDR DALA2016031602024Pan · crackedCRACKED DOOR PAN ON AFT, FWD SIDE AND BEAM NR 5 AT AFT CARGO DOOR INNER STRUCTURE. C3 DOOR WAS REPLACED IAW IPC-52-30-02.SDR DALA2016031401908Skin · crackedCRACKS OF 1.156" AND 0.093" ON FUSELAGE SKIN ON BS 374 AT THE UPPER FWD DOOR JAMB CORNER OF THE FWD CARGO COMPARTMENT. FUSELAGE SKIN WAS REPAIRED IAW ER/A 543154-14AD, REV ORIG.SDR DALA2016031401907Frame · crackedCRACKED FRAME, BS 1510 CANT 5 HRS POS AT AFT ACC COMPARTMENT. FRAME WAS REPLACED IAW SRM 51-30-2, 51-30-5, 51-10-4, 51-10-3, PAR 21, 14.SDR DALA2016031301901Cusp Web · corrodedCORROSION ON REPAIR DOUBLER LT CUSP WEB X=54 TO X=60 BETWEEN BS 693 TO 710, 712 TO 723 AND 731 TO 741 AT FLOOR STRUCTURE CABIN. REPAIR DOUBLERS WERE REPLACED IAW SRM 53-05, FIG 131A-13 AND FIG 131A-6. REPAIR DOUBLER 693 TO 710 WILL BE ATTENDED WITH CARD NR SDR DALA2016031301900Cusp Web · corrodedCORROSION ON REPAIR DOUBLER LT CUSP WEB X=54 TO X=60 BETWEEN BS 560 TO BS 579, Y=585 TO Y=598 AT FLOOR STRUCTURE CABIN. REPAIR DOUBLERS WERE REPLACED IAW SRM 53-05, FIG 131A-6.SDR DALA2016031301899Doubler · delaminatedDELAMINATED UNDER DOUBLER UPPER SKIN STA- XOVIF 66 ON LT INBOARD FLAP OUTBOARD GUIDE VANE. DAMAGE AREA WAS REAPAIRED IAW ERA NR 543167-14, REV ORIG.SDR DALA2016031301898Cusp Web · corrodedCORROSION ON REPAIR DOUBLER ON RH CUSP WEB X=-54, X=-60 BETWEEN BS 446 - 500 AT FLOOR STRUCTURE CABIN. REPAIR DOUBLERS WERE REPLACED NEW REPAIR, 3 EA WERE FABRICATED AND INSTALLED IAW SRM 53-05, FIG 131A-14 AND 131A-7.SDR DALA2016031301897Cusp Web · damagedREWORK OUT OF LIMITS ON CUSP WEB BETWEEN X=60 TO X=54 AND BS 715 - 716. CUSP WEB WAS REPAIRED IAW SR, 53-05, FIG 131A-6 SRM 51-10-4, SRM 51-10-3, PAR 14, 21 & 38 SRM 51-30--5.SDR DALA2016031301896Cusp Web · corrodedDUE TO EXCESSIVE CORROSION ON CUSP WEB X=-54 TO X=-60 BETWEEN BS 806 AND 817. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-13, FIG 131A-2, 51-10-3 PAR 14 AND 21, 51-30-2.SDR DALA2016031301895Cusp Web · corrodedCORROSION ON LT CUSP WEB UPPER AND LOWER SURFACE FROM BS 541 TO BS 560 BETWEEN X=54 TO X=60. CUSP WEB WAS REPAIRED IAW 53-05, FIG 131A-14.SDR DALA2016031301894Floor Panel · delaminatedFLOOR PANEL DELAMINATED FROM BS 110 TO 256 AT CABIN PAX. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2016031301893Longeron · crackedCRACKED LONGERON 16R BS 1437 AT AFT ACC COMPARTMENT. THE LONGERON WAS REPLACED IAW SRM 51-30-2 , 51-30-5, 51-10-3 PAR 14 AND 21.SDR DALA2016031301892Cusp Web · corrodedCORROSION ON RT CUSP WEB FROM BS 317 TO 320 BETWEEN X=-54 TO X =-60. REPAIR WAS ACCOMPLISHED IAW SRM 53-05, FIG 131A-13.SDR DALA2016031201891Skin · damagedLIGHTNING STRIKE ON LT FUSELAGE SKIN WINDOW BELT LOWER EDGE AND LOWER CORNER BETWEEN BS 389 TO BS 408. DAMAGE WAS BLENDED OUT, IAW SRM 53-05, FIG 111. AREA WAS MEASURED: BLENDED OUTS WERE FOUND IN ZONE 3 AND NO CRITICAL ZONE THEREFORE ALL ARE WITHIN LIMITS ISDR DALA2016031201890Cusp Web · deformedDEFORMED LIGHTNING HOLE ON RT CUSP WEB X=-54 TO X=-60 BETWEEN BS 770 TO 775 AT FLOOR STRUCTURE CABIN. REPAIR PARTS WAS FABRICATED IAW SRM 53-05, FIG 131A-13, SHEET 1, TREATED AND PAINTED IAW SRM 51-10-3, PAR 21 AND 14 AND INSTALLED IAW SRM 51-30-2.SDR DALA2016031201889Skin · corrodedCORROSION WAS FOUND ON FASTENER HOLES COMMON TO THE LT LOWER ACCESS DOOR CUTOUT, AT THE XRS 199- 200 AND BETWEEN STR 12 AND 15. CORROSION WAS REPAIRED IAW ER/A 543177-14AD, REV ORIG.SDR DALA2016031201888Skin · corrodedCORROSION WAS FOUND ON FASTENER HOLES COMMON TO THE RT LOWER ACCESS DOOR CUTOUT, AT THE XRS=191-211 BETWEEN STR 12 AND 15. CORROSION WAS REPAIRED IAW ER/A 543177-14AD, REV ORIGINAL.SDR DALA2016031201887Intercostal · crackedCRACK ON INTERCOSTAL BS 173, Z=0, X=55 BELOW SIDE OF W1 AT LT FLOOR CABIN PAX. INTERCOSTAL WAS REPAIRED IAW SRM 51-70-5, FIG 1.SDR DALA2016031201886Frame · crackedCRACKED UPPER CAP FRAME BS 1418, LONG 2 LT AT AFT ACCESSORY COMPARTMENT. UPPER CAP FRAME WAS REPAIRED IAW SRM 53-01, FIG 2 , SRM 51-30-5 AND DWG SR09530003.
Back to Mcdonnell Douglas MD-88