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 DALA2016020100775Intercostal · crackedCRACKED INTERCOSTAL BETWEEN BS 1497 CANT TO 1510 CANT APPROXIMATELY 7 HRS POSITION. INTERCOSTAL WAS R & R IAW SRM 51-30-2 AND D/DWG 9917701, REV ORG.SDR DALA2016020100774Frame · crackedCONTINUE CRACK AFTER STOP DRILL ON REPAIR FRAME 1418 WITH LONG 2R. CRACK WAS DRILLED, ANGLE WAS REMOVED, SUPPORT WAS REMOVED, NEW ANGLE WAS FABRICATED AND TREATED AND PAINTED. SUPPORT WAS INSTALLED IAW IAW SRM 53-03, FIG 31A. FRAME WAS REPLACED IAW SRM 53-0SDR DALA2016020100773Longeron · crackedCRACK LONGERON 9R WITH FRAME, BS 1380. LONGERON 9 RT WAS REPAIRED IAW SRM 53-02, FIG 18, AND DRILLED AND ADJUSTED IAW 51-10-4 AND WAS TREATED AND PAINT IAW SRM 51-10-3, PAR 21 AND 14 AND WAS INSTALLED IAW SRM 51-30-5 AND 51-30-2.SDR DALA2016013100770Access Panel · corrodedRT WING UPPER SURFACE FILIFORM CORROSION ON FUEL PANEL LOCATED ON ICE DETECTION STRIPS. R & R PANEL IAW AMM 30-80-02-401.SDR DALA2016111608865Intercostal · corrodedCORROSION ON INTERCOSTAL UPPER SURFACE BELOW OF LT TIE DOWN TRACK STA Y= 1307 TO Y= 1322. INTERCOSTAL WAS REPLACED.SDR DALA2016020100797Fitting · corrodedGALLEY HOLD FITTING CORRODED BS 215, RBL 55. FABRICATE AND INSTALL IAW PRI 543609-14, REV. 0.SDR DALA2016020100796Fitting · corrodedGALLEY HOLD DOWN FITTING CORRODED, BS 236, RBL 22. FABRICATED AND INSTALLED IAW PRI 543609-14, REV 0.SDR DALA2016020100795Support Fitting · corrodedGALLEY SUPPORT FITTING CORRODED BS 223, LBL 22. FABRICATED AND INSTALLED IAW PRI 543609-14, REV 0.SDR DALA2016020100794Fitting · corrodedGALLEY HOLD FITTING CORRODED BS 236, RBL 44. FABRICATED AND INSTALLED IAW PRI 543609-14, REV 0.SDR DALA2016013100772Cusp Web · corrodedCORROSION ON RT CUSP WEB UPPER AND LOWER SURFACE BETWEEN X=-54 TO X=-60 FROM BS 636 TO 639 AND 682 TO 684. CUSP WEB IN STA 636 TO 639 WAS REPAIRED IAW SRM 53-05, FIG 131A-1. CUSP WEB IN STA 682 TU 684 WAS REPAIRED IAW SRM 53-05, FIG 131A-21.SDR DALA2016013100771Fairing · crackedCRACK ON SETTLEMENT AREA OF ANTI-FLOAT FAIRING. RT ELEVATOR. REPAIR WAS ACCOMPLISHED IAW ET 88-16-030, REV 2 AND ER/A 541630-14, REV ORIGINAL.SDR DALA2016013100769Cargo Track · damagedELONGATED HOLES ON TIE TRACK RT BETWEEN BS 1007 TO 1079 AT C3. REPLACE TIE TRACK, NEW TIE TRACK WAS REPLACED IAW SRM 51-30-1, 51-30-2 AND DGW 5936660, REV BZ.SDR DALA2016013100768Access Panel · corrodedCORROSION ON COUNTERSKIN AND SEATING AREA OF FUEL ACCESS PLATE NR 1311C. FUEL ACCESS WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016013100766Former · crackedCRACKED FORMERS ON BS ZFS=23 LT SIDE AND BS ZFS=23 AND 36 AT VERTICAL STABILIZER L/E INTERNAL STRUCTURE. CRACKED FORMERS WERE REPAIRED IAW SRM 55-02D, FIG 27.SDR DALA2016013100765Cusp Web · corrodedCORROSION ON CUSP WEB BS 503 TO BS 598 BETWEEN X=-54TO X= -60 AT CABIN PASSENGER. CUSP WEB WAS REPLACED DUE TO EXCESIVE DAMAGE IAW SRM 53-05, FIG 131A, 24.SDR DALA2016013100764Pan · crackedCRACK PAN ON AFT EDGE BELOW STOP 5 AT MID CARGO DOOR. CRACKS WERE REWORKED IAW SRM 52-03D, FIG 10.SDR DALA2016013100763Stiffener · crackedCRACK STIFFENER AT FRAME BS 1463 CANT BETWEEN PROTECTION LONG 7L TO 8L. STIFFENER WAS REPLACED IAW SRM 51-30-5, 51-10-3 PARA 14 AND 21, 51-30-3 AND DWG 9911839-29.SDR DALA2016111608844Threshold · corrodedCORROSION FOUND ON L1 DOOR THRESHOLD AFT END. REPAIRED IAW SRM.SDR DALA2016111608843Access Door · crackedCRACK AND CORROSION ON POTABLE WATER SERVICE ACCESS DOOR. CRACK AND CORROSION WERE ATTENDED WITH ER/A.SDR DALA2016020100788Floorbeam · corrodedFLOORBEAM CORRODED BS 180, RBL 8-44. REPLACED FLOORBEAM IAW SRM 53-01, FIG 1.SDR DALA2016020100787Floor Support · corrodedCORROSSION ON FLOOR SUPPORT BETWEEN ST 160 AND 200, RBL 6. REPLACE FLOOR SUPPORT REF SRM 51-01, PG 1, PAR 2D.SDR DALA2016020100786Fitting · corrodedR1 DOOR AFT GIRT BAR FITTING CORRODED. REPLACED FITTING IAW PRINT 3936910.SDR DALA2016020100785Floorbeam · corrodedFLOORBEAM CORRODED BS 180, RBL 8-44. REPLACED FLOORBEAM IAW SRM 53-01, FIG 1.SDR DALA2016020100784Floorbeam · corrodedFLOORBEAM CORRODED BS 180, RBL 8-44. REPLACED FLOORBEAM IAW SRM 53-01, FIG. 1.SDR DALA2016020100783Floor Support · corrodedSURFACE CORROSION ON FLOORBOARD SUPPORT BETWEEN BS 160 AND BS 200, LBL 4. R & R FLOORBOARD SUPPORT BETWEEN BS 160 AND BS 200, LBL 4. IAW SRM 51-01, PG 1, PAR 2D.SDR DALA2016013000762Fitting · corrodedAA SCRATCHES AND CORROSION ON LT MLG FITTING BORE. BUSHING BORE WAS REPAIRED WITH FINAL MEASURE: ID 2.3365".SDR DALA2016013100760Wire · disconnectedTHE CREW ON FLIGHT 1428 FOUND 1 LT SIDE EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. MAINTENANCE FOUND WIRE L1594C18 AND L1598A18N DISCONNECTS NOT CONNECTED BEHIND THE AFT BAGBIN SIDE WALL AND CONNECTED THE SAME. LIGHTS CHECKED OK.SDR DALA2016013100759Floor Panel · damagedDAMAGE FERRULES ON FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2016013100758Floor Panel · damagedDAMAGE FERRULES ON FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2016013000757Angle · crackedCRACKED FRAME CLIP, BS 1380 BETWEEN LONGERONS 14RT AND 15RT. FRAME CLIP. BS 1380 WAS REPLACED IAW SRM 51-30-5, DWG 9912246, REV "CY".SDR DALA2016013000756Skin · damagedDAMAGE METALLIZED ON RUDDER TAB, CARD 162, ZONE 100. DAMAGE METALLIZED WAS REPAIRED IAW SRM 51-70-1AD.SDR DALA2016013000755Pan · crackedCRACK AFT EDGE PAN WITH BEAM 5 OF MID CARGO DOOR. AFT EDGE PAN WITH BEAM 5 OF MID CARGO DOOR WAS REPAIRED IAW SRM 52-03D, FIG 8.SDR DALA2016013000754Skin · crackedCRACKED PREVIOUS REPAIR DOUBLER ON INNER FUSELAGE SKIN BETWEEN LONGERONS 2L-2R NEXT TO BS 1463. DAMAGE AREA WAS REPAIRED IAW ER/A 541633-14, REV ORIGINAL.SDR DALA2016013000753Skin · corrodedCORROSION ON LT WING OTBD FLAP OTBD VANE LOWER SKIN AT BS XV2: 246 APPROXIMATELY CARD 122, ZONE 10. LT OTBD FLAP OTBD VANE WAS REPLACED IAW SRM 57-50-14, FIG 2A.SDR DALA2016013000752Skin · damagedELONGATED FASTENERS HOLE ON FUSELAGE SKIN AT BELLY DRAIN ATTACHMENT POINT BS 295-296 BETWEEN LONGERON 30 AND 29 LT C1 CARGO. DAMAGE WAS CUT OUT REPAIR PARTS WERE FABRICATED, TREATED AND PAINTED REPAIR PARTS WERE INSTALLED IAW SRM 53-04-2, FIG 2, 51-10-3 PAR SDR DALA2016013000751Doubler · wornWEAR ON DOUBLER AT CUTOUT ELEVATOR ACCESS. DOUBLER WAS R & R IAW SRM 53-34-0, 51-30-2 AND 51-10-3 PAR 21, 14.SDR DALA2016111608842Skin · corrodedFUSELAGE SKIN & DOUBLER CORRODED, BS 1231-1250, LONGERON 29R. REPAIRED IAW ER/A 541601.SDR DALA2016012900719Finger Doubler · corrodedCORROSION ON INTERNAL FINGER DOUBLER BETWEEN BS 1174-1193 BELOW LONGERON 26L AT AFT CARGO COMPARTMENT C3. FINGER DOUBLER WAS REPAIRED IAW SRM 51-30-2, 51-30-5, 51-10-3 PAR 14, 21 AND 38, AND 53-04-5, FIG 7.SDR DALA2016012900718Frame · corrodedCORROSION ON FRAME BS 1271 BETWEEN LONGERONS 28R TO 28L AT C3. PREVIOUS REPAIR PARTS WERE REPLACED IAW SRM 53-03D, FIG 2A SHEET 3.SDR DALA2016012900717Longeron · crackedCRACKED LONGERON 8L AT BS 1309 AT FUSELAGE CABIN STRUCTURE. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18, 51-30-2, 51-30-5 AND 51-10-3, PARR 14, 21.SDR DALA2016012900716Fitting · damagedSCRATCHES AND CORROSION ON RT MLG FITTING BORE. FITTING BORE WAS REWORKED WITH FINAL MEASURE ID 2.256" THEREFORE IT`S WITHIN LIMITS IAW DGW SR09570087, REV B AND AREA WAS TREATED IAW SRM 51-10-3, PAR. 21.SDR DALA2016012900715Fitting · crackedCRACKED FITTING OF LONGERON 17 AT LT CENTER FUEL TANK. NEW FITTING WAS DRILLED IAW SRM 51-10-4. FITTING WAS REPLACED AND WILL BE INSTALLED WITH CARD 123, ZONE 10.SDR DALA2016012900714Skin · crackedCRACK ON FUSELAGE SKIN BS 1309 BETWEEN LONGERONS 6 - 7L. REPAIRED IAW ETI-88-16-035 R2 AND ER/A 541634-14, REV. ORIGINAL.SDR DALA2016012900713Skin · dentedDENTS ON OTBD SKIN BETWEEN BEAM 3 TO 4, 6 DENTS AND BEAM 4 TO 5, 5 DENTS AT MID CARGO DOOR. NEW SKIN WAS REPLACED IAW SRM 51-30-2 AND DWG 5910141, REV FE.SDR DALA2016012900712Skin · dentedDENTS ON OTBD SKIN BETWEEN BEAM 1 AND 2, 1 DENTS BEAM 2 AND 3, 1 DENT BEAM 4 AND 5, 8 DENTS AND BEAM UPPER EDGE, 1 DENT AT AFT CARGO DOOR. SKIN WAS REPLACE IAW SRM 51-30-2, 51-30-5, DWG 5910141, REV. FE.SDR DALA2016012900709Longeron · crackedCRACK LONGERON 13R WITH FRAME BS 1380. LONGERON WAS REMOVED AND NEW SECTION LONGERON WAS DRILLED AND ADJUSTED TREATED AND PAINTED INSTALLED AND EXHAUST WAS INSTALLED IAW SRM 51-30-5, 51-30-2, 51-10-4, 51-10-3, PAR 21, 14.SDR DALA2016012800689Floor Support · corrodedFLOOR SUPPORT CORRODED BS 160-180, RBL 44. REPLACED THE FLOOR SUPPORT IAW SRM 51-30-02.SDR DALA2016012900711Angle · crackedCRACKED INNER ANGLE ON DORSAL FIN, REF BS 1427 BETWEEN LONGERONS 1 AND 2 RT. ANGLES WERE REPLACED IAW DWG 5912188 AND SRM 51-30-5.SDR DALA2016012800708Web · crackedCRACKED MEMBRANE OF BS 1485 AFT FACE AND 2HRS POSITION. CRACK WAS STOPPED AND REPAIRED ON MEMBRANE IAW SRM 51-01, PAR 21 AND SRM 53-01, FIG 2.SDR DALA2016012800707Vane · wornWEAR ON PREVIOUS REPAIR DOUBLER ON MID FLAP VANE GUIDE AT RT WING OTBD FLAP. MID FLAP VANE GUIDE AT RT WING OTBD FLAP WAS REPAIRED IAW SRM 57-03D, PAR 11.
Back to Mcdonnell Douglas MD-88