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 DALA2017013000777Frame · crackedAFT ACCESSORY COMPARTMENT HAD A CRACKED FRAME BS 1452, LONGERON 1. THE FRAME WAS REPAIRED IAW SRM 53-01 FIG 2 AND 51-30-5.SDR DALA2017013000776Doubler · wornC2 DOOR HAD WEAR ON A PRODUCTION DOUBLER FWD, LOWER CORNER. THE DOUBLER WAS REPLACED IAW SRM 51-30-2 AND DWG 5910141 REV FE.SDR DALA2017013000792Fuse · inoperativeAFT CABIN EMERGENCY LIGHTS INOPERATIVE AT ROWS 30-36. REPLACED THE FUSE IN THE BATTERY ASSEMBLY AT ROW 35 IAW SWPM 20. EMERGENCY LIGHTS OPERATE NORMALLY.SDR DALA2017013000788Cusp Web · corrodedCORROSION ON LEFT CUSP WEB FROM BS 450 TO 460 BETWEEN LBL 44 TO 60 UPPER AND LOWER SURFACES. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG. 131A-14.SDR DALA2017013000784Stiffener · crackedCRACKED STIFFNER ON THE AFT PRESSURE BULKHEAD UNDER LONGERON END 3R. THE STIFFENER WAS REPLACED IAW SRM 51-30-5, 51-30-2, AND 51-10-3 PAR. 14 AND 21.SDR DALA2017012900775Longeron · crackedCRACKED LONGERON 11L, BS1380. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG. 18.SDR DALA2017012900774Frame · crackedAFT ACCESORIES COMPARTMENT HAD A CRACKED TITANIUM FRAME AT BS 1345, LONGERON 28L. THE FRAME WAS REPAIRED IAW ER/A 094719 -14 MA, REV A.SDR DALA2017012900773Doubler · wornWEAR ON AFT/FWD SKIN DOUBLERS AT AFT CARGO DOOR. DAMAGE ON FWD LOWER CORNER DOUBLER BLENDED OUT IAW SRM 52-01 FIGURE 1 (SHEET 3).SDR DALA2017012900772Fitting · crackedR1 DOOR CRACKED FITTING ON BEAM NR 4 AFT EDGE. THE FITTING WAS REPLACED IAW SRM 51-30-01, 51-30-05, AND DWG 9911582 REV. T.SDR DALA2017012900771Pan · crackedCRACK ON LT WINDOW RING PAN FWD/LOWER CORNER BS 1041, 1060. THE RING PAN WAS REPAIRED IAW SRM 53-05 PAR 139, FIG. 122, ER/A 487747-14MA, REV. A, AND ER/A 493648-14MA REV. A.SDR DALA2017012900770Pan · crackedCRACK ON LT WINDOW RING PAN AFT/LOWER CORNER BS 598. PAN WAS REPAIRED IAW SRM 53-05, PAR 139, FIG 122, ER/A 487747-14MA REV. A, AND ER/A 493648-14MA REV. A.SDR DALA2017012900769Pan · crackedCRACK ON LT WINDOW RING PAN AFT/UPPER CORNER BS 1041. RING PAN WAS REPAIRED IAW SRM 53-05 PAR. 139 FIG. 122, ER/A 487747-14MA REV. A AND ER/A 493648-14MA REV. A.SDR DALA2017012900768Beam · crackedL1 DOOR HAD A CRACKED BEAM NR 8 AND ANGLE AT AFT EDGE. THE BEAM WAS REPAIRED IAW SRM 52-05 FIG. 111 SHEET 8.SDR DALA2017012900735Cable · misroutedTAILCONE CABLE MISROUTED. NOT THROUGH TAILCONE FAIRLEAD. TAILCONE INSTALLED IAW AMD S5350-4642. CABLE ROUTED CORRECTLY.SDR DALA2017013000738Battery Pack · inoperativeAFT CABIN EMERGENCY LIGHT IS INOPERATIVE. R & R THE BATTERY PACK AMM 33-53. ALL CHECKS GOOD.SDR DALA2017013000737Bushing · crackedCRACKED HINGE BUSHING ON RT OUTBOARD LUG OF HORIZONTAL STABILIZER ATTACH POINT AT VERTICAL STABILIZER REAR SPAR. NEW REPAIR BUSHINGS WERE FABRICATED PER DC-9/MD80 SRM 55-02 PAR.24(C). (LP2867305)SDR DALA2017013000736Pan · crackedCRACK ON RT WINDOW RING PAN AFT UPPER CORNER. THE PAN WAS REPAIRED IAW SRM 53-05 PAR. 139 FIG. 122, ER/A NO. 487747-14MA REV. A, AND ER/A 493648-14MA REV. A.SDR DALA2017012800734Hinge · corrodedCORRODED HINGE FACE ON VERTICAL STABILIZER. CORROSION REMOVED IAW SRM 55-02 PAR.24.A.SDR DALA2017012800733Angle · crackedL1 DOOR HAD A CRACKED FWD ANGLE AT UPPER EDGE. THE ANGLE WAS REPLACED IAW SRM 51-30-2.SDR DALA2017012800732Support Fitting · damagedELONGATED VERTICAL ADJUSTMENT PIN HOLE ON FWD CARGO DOOR AFT HINGE. FITTING SUPPORT ON FWD CARGO DOOR AFT HINGE WAS REPLACED PER MD88 AMM 52-31-02-201. (LP2867655)SDR DALA2017012800731Access Panel · corrodedCORROSION ON ACCESS PANEL 1414C. THE ACCESS PANEL WAS REPLACED.SDR DALA2017012800730Pan · crackedCRACK ON RT WINDOW RING PAN FWD UPPER CORNER BS 845. REPAIRED IAW SRM 53-05, PAR 139, FIG 122, ER/A 487747-14MA, REV A, AND ER/A 493648-14, REV A.SDR DALA2017012800729Pan · crackedCRACK ON RT WINDOW RING PAN FWD/UPPER CORNER BS 886. REPAIRED IAW SRM 53-05, PAR 139, FIG 122, ER/A 487747-14MA, REV.A, AND ER/A 493648-14MA, REV.A.SDR DALA2017012800728Pan · crackedCRACK ON LT WINDOW RING PAN AFT LOWER CORNER BS 905. REPAIRED IAW SRM 53-05, PAR 139, FIG 122, ER/A 487747-14MA, REV. A, AND ER/A 493648-14MA, REV. A.SDR DALA2017012800727Skin · crackedDURING NDT INSPECTION A DISCREPANT AREA WAS FOUND ON THE FUSELAGE SKIN, DOUBLER AND TRIPLER REPAIR BTW BS 161.5 - 188.25 AND LONGERONS 11 TO 14R.SDR DALA2017012800726Pan · crackedCRACK ON RT WINDOW RING PAN FWD/LOWER CORNER BS 946 - 1022. RING PAN REPAIRED IAW SRM 53-05, PAR 139, FIG 122, ER/A 487747-14 MA, REV A, AND ER/A 493648-14 MA, REV A.SDR DALA2017012800725Frame · puncturedPUNCTURE ON FRAME ANGLE AT BS 275 AND LONGERONS 17-18R. THE FRAME ANGLE WAS REPLACED IAW SRM 51-30-2, 51-30-5 AND DWG 9911524. REV. N.SDR DALA2017012700724Clamp · brokenRIGHT MLG AND WHEEL WELL AREA BROKEN ISULATION CLAMP AND TORN INSULATION OF HYD AUXILIAR PUMP CONECTOR. NEW CLAMP AND INSULATION ON CONNECTOR WERE REPLACED IAW SWPM 20-10-01, SWPM 20 31-20 AND ERA 467688-14 MAAD REV D.SDR DALA2017012700671Frame · puncturedPUNCTURE ON FRAME ANGLE AT BS 275 AND LONGERONS 17-18R. THE FRAME ANGLE WAS REPLACED IAW SRM 51-30-2, 51-3-5 AND DWG 9911524.SDR DALA2017012700670Finger Doubler · corrodedAFT CARGO COMPARTMENT, CORROSION WAS FOUND ON FINGER DOUBLER FROM BS 1193 TO 1250 AND LONGERON 26L. THE FINGER DOUBLER WAS FABRICATED IAW DWG 5911423 REV CD, THE FINGER DOUBLER WAS REMOVED AND INSTALLED IAW SRM 51-30-2 AND 51-30-5.SDR DALA2017012700668Beam · crackedL1 DOOR HAD A CRACKED BEAM NR 7 AFT END. THE BEAM WAS REPAIRED IAW SRM 52-05 PARAGRAP 74 FIG. 93.SDR DALA2017012700667Intercostal · crackedL1 DOOR HAD A CRACKED INTERCOSTAL BETWEEN BEAMS 4 AND 5. THE INTERCOSTAL WAS REPLACED IAW SRM 51-30-2.SDR DALA2017012600673Pin · pulledL1 DOOR SLIDE PINS PULLED. REPLACED L1 DOOR SLIDE IAW JIC 2561-4964, OK FOR SERVICE.SDR DALA2017012600649Mount · corrodedCORROSION ON UPPER HOUSING FWD ENGINE MOUNT. THE PYLON FRONT SPAR BEAVER TAIL FITTING HOLE WAS REPAIRED IAW SRM 54-04D PAR 15.SDR DALA2017012600648Bulkhead Web · crackedA CRACK WAS FOUND ON THE PRESSURE BULKHEAD WEB BS 69, LBL 12 . THE CRACK WAS STOP DRILLED IAW SRM 53-01 FIG.2. A DOUBLER WAS INSTALLED IAW SRM 53-01 FIG.2 SH. 3.SDR DALA2017012600647Spar Cap · crackedDURING BHEC INSPECTION ON HORIZONTAL STABILIZER, RT UPPER REAR SPAR CAP CRACKED WAS FOUND. THE SPAR CAP WAS REPLACED DWG SR09550030 REV D AND SRM 51-30-2 AND 51-30-5.SDR DALA2017012600646Floor Support · crackedCRACK ON FLOOR SUPPORT BETWEEN BS 1287 - 1309, BL 0. THE FLOOR SUPPORT WAS REPLACED IAW SRM 51-30-1,51-30-2,51-30-5.SRM 51-10-4 AND 51-10-3 PAR 14 AND 21.SDR DALA2017012600644Pan · crackedCRACK ON OUTER PAN BELOW STOP FITTING NR 4 AT AFT EDGE FROM AFT CARGO DOOR. THE PAN WAS REPAIRED IAW SRM 52-05 FIG.50.SDR DALA2017012500642Lamp · inoperativeR1 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED GOOD IAW MM 33-50.SDR DALA2017012500636Longeron · crackedCRACKED LONGERON 16L ON BS 1437. THE LONGERON WAS REPLACED IAW SRM. 51-30-2, 51-30-5, 51-14-4, 51-10-4 AND 51-10-3 PAR. 21 AND 14.SDR DALA2017012500637Seat Track · corrodedCORROSION ON RT SEAT TRACK REPAIR PLUGS RBL 54, BS 304 AND 381. THE REPAIR PLUGS WERE REPLACED IAW SRM 51-30-1.SDR DALA2017012500635Longeron · crackedCRACKED LONGERON 16R ON BS 1437. THE LONGERON WAS REPLACED IAW SRM 51-30-2, 51-30-5, 53-14-4, 51-10-4 AND 51-10-3 PAR. 21 AND 14.SDR DALA2017012500634Beam · crackedL1 DOOR BEAM NR 1 CRACKED. THE BEAM WAS REPAIRED IAW SRM 52-05 FIG 81, 82.SDR DALA2017012400608Slide · damagedL1 DOOR SLIDE GIRT BAR HARD TO INSTALL. FOUND SLIDE BUSTLE DAMAGED AND NOT ALLOWING GIRT BAR TO ENGAGE COMPLETELY. R & R THE L1 DOOR SLIDE ASSY IAW AMDS WC 2561-4964. CHECKED GOOD.SDR DALA2017012400607Spar · corrodedVERTICAL STAB CORRODED ON THE LT & RT PLATES REAR SPAR BETWEEN HSS 150-160. THE CORROSION WAS REMOVED. UT INSPECTION WAS ACCOMPLISHED IAW SPM 04-00-07 PAR. 5 FIG. 3 SHEET 1 AND 2. FOUND TO BE WITHIN LIMITS IAW SRM 55-02 PAR. 24 FIG. 28.SDR DALA2017012400606Seat Track · corrodedCORROSION ON RT SEAT TRACK REPAIR PLUGS RBL 22, BS 446 - 465. THE REPAIRPLUGS WERE REPLACED IAW SRM 53-05 FIG. 4 AND 51-30-1.SDR DALA2017012400605Spar Cap · crackedCRACKED RT HORIZONTAL STABILIZER REAR UPPER SPAR CAP. DRILLED TO NOMINAL SIZE IAW SR09550032 REVISION B.SDR DALA2017012400604Seat Track · corrodedCORROSION ON LT REPAIR ON SEAT TRACK PLUG LBL 22, BS 547-550 AND BS 606-609. THE REPAIR PLUGS WERE REPLACED IAW SRM 53-05 FIG.4, 51-10-3 PAR. 21, 14, 38, AND 51-30-1.SDR DALA2017012400603Seat Track · corrodedCORROSION ON RT SEAT TRACK REPAIR PLUGS RBL 22 BS 446 AND 465. THE REPAIR PLUGS WERE REPLACED IAW SRM 53-05 FIG. 4.SDR DALA2017012300576Battery Pack · inoperativeCEILING EMERGENCY LIGHTS 4DC & 24DC INOPERATIVE. REPLACED THE BATTERY PACKS IAW AMM 33-53. OPS CHECKED OK. OK FOR SERVICE.
Back to Mcdonnell Douglas MD-88