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 DALA2015062603967Housing · wornMID-CARGO DOOR HANDLE HOUSING WORN. DAMAGED HOUSING WAS REPLACED IAW SRM 51-30-2.SDR DALA2015062603964Floorbeam · corrodedCORROSION ON FLOORBEAM, BS 255, BETWEEN X 22-44. THE FLOORBEAM WAS REPLACED IAW SRM 53-14-2.SDR DALA2015062503958Cusp Web · crackedCRACK ON RT CUSP WEB, BS 224, X -56. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-1, 51-30-5, 51-30-2, 51-10-4, PAR 21, 14.SDR DALA2015062303954Cusp Web · corrodedINITIAL CORROSION ON RT CUSP WEB BETWEEN X -54 TO -60 AND BS 680 - 693. REPAIRED IAW SRM 51-10-3, PAR 14, 21, 38, 51-30-2, 51-30-8, 51-30-1 AND SRM 53-05, FIG 131A-1.SDR DALA2015062403943Cusp Web · corrodedCORROSION ON LT CUSP WEB BETWEEN STA X=54 TO 60 AND Y=647 TO 655 AT PAX CABIN FLOOR STRUCTURE. RII:N ENTR 537749 W SUMMARY, CORROSION ON CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131-A.SDR DALA2015062403942Support Fitting · damagedSCRATCH ON RT MLG SUPPORT FITTING BORE IN REF CARD 12, ZONE 18, CARD 14, ZONE 018. DAMAGE ON BEARING BORE WAS REPAIRED IAW ETI-88-15-182, REV ORIGINAL AND ER/A 474111-14AD REV A.SDR DALA2015062403941Stop Fitting · crackedCRACK ON STOP FITTING NR 4 OF AFT CARGO COMPARTMENT DOOR FWD EDGE. STOP FITTING NR 4 WAS REPLACEMENT IAW SRM 51-30-1, CRACK LONG: 0.125.SDR DALA2015062403940Cusp Web · corrodedINITIAL CORROSION ON PREVIOUS REPAIR DOUBLER. RT CUSP WEB BETWEEN BS X=-54 TO -60 AND Y= 733 TO 739 AT PAX CABIN FLOOR STRUCTURE. PREVIOUS REPAIR WAS REPLACED, IAW SRM 53-05, FIG 131A-9.SDR DALA2015062403939Skin · scratchedSCRATCHES ON RT WINDOW BELT, BS 750-769, LWR EDGE. REPAIRED.SDR DALA2015062403974Fuse · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY PATHWAY LIGHTING AT SEAT 31DE IN THE CABIN WAS INOPERATIVE. MAINTENANCE REPLACED A BAD FUSE ON THE BATTERY PACK AND THE SYSTEM RETURNED TO NORMAL OPERATION.SDR DALA2015062403944Skin · damagedLIGHTNING STRIKES ON RT WINDOW BELT STA Y=731-750, AFT UPPER CORNER. RT WINDOW BELT STA Y= 731-750 WAS REPAIRED IAW ETI-88-15-192, REV 1 AND ER/A 536436-14AD, REV ORIGINAL PERFORM HFEC INSPECTION EVERY 24 MONTHS IAW ERA 536436-14AD. RII COMPLETED.SDR DALA2015062303937Pan · crackedCRACKED DOOR PAN ON DOOR STOP NR 4 AT LT FWD OVERWING EMERGENCY EXIT DOOR. PAN WAS REPAIRED IAW SRM 52-050, FIG 51, 51-30-2, 51-30-5, 51-10-2, 51-10-4, 51-10-3 PARA 14 AND 21. PRIMARY STRUCTURE, RII COMPLETED.SDR DALA2015062303936Frame · corrodedDURING MAINTENANCE ACTIVITIES WAS FOUND, CORROSION OUT OF LIMITS BS 1307 BETWEEN LONGERON 26LT AND 30 AT AFT CARGO COMPARTMENT IN REF CARD 248, ZONE 100, CARD 273, ZONE 100. FRAME WAS REPAIRED IAW SRM 53-03D, FIGURE 2A.SDR DALA2015062303935Cusp Web · crackedCRACK ON CUSP WEB AT BS 469-471, X=-54 TO X=-60. CUSP WEB REPAIRED IAW SRM 53-05, FIG 131A-13.SDR DALA2015062303934Keelbeam · crackedCRACKED ANGLE BELOW KEEL BEAM AT RT MLG W/W AFT INBD CORNER. ANGLE BELOW KEEL BEAM AT RT MLG W/W AFT INBD CORNER WAS REPAIRED IAW ER/A 413026-14 MA, REV ORIGINAL CRACK .125.SDR DALA2015062303933Longeron · corrodedCORROSION ON LONGERON 19R BETWEEN FRAME Y=1287 AND Y=1309 AT AFT CARGO COMPARTMENT. FASTENER WAS REMOVED, CORROSION SECTION LONGERON DAMAGE WERE REMOVED. NEW SECTION LONGERON WAS DRILLED, TREATED, PAINTED, INSTALLED SPLICES. REPAIRS WERE DRILLED, ADJUSTED, TSDR DALA2015062303938Power Supply · inoperativeSEVERAL EMERGENCY LIGHTS OUT IN TAIL COMPARTMENT. RII: N ENTRY 486044 W, R & R EMERGENCY POWER SUPPLY B5-28 IAW AMM 33-53. LIGHTS CHECK GOOD. OK FOR SERVICE.SDR DALA2015062203930Floor Panel · crackedCRACKED FLOOR PANEL PAX CABIN . FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2015062203929Cusp Web · wornWEAR ON LT CUSP WEB BS Y=465 BETWEEN X=44 TO 54 AT PAX CABIN FLOOR STRUCTURE. WEAR WAS BLENDED OUT IAW SRM 53-01, FIG. 1 AND REPAIRED AREA SRM 53-05, FIG 131A-1 AND SRM 51-10-3, PAR 21 AND 14 NDT SPM 04-00-07, PAR 5, FIG 3, SHEET 1 AND 2 WAS ACCOMPLISHED ORIGSDR DALA2015062203928Window Frame · crackedCRACK ON WINDOW RING PAN AFT UPPER CORNER STA Y=1136, Y=1174, Y=1193, Y=1212 AND Y=1250 AT PAX CABIN, CARD 71, ZONE 100. WINDOW RING PAN AFT UPPER CORNER WERE REPAIRED IAW SRM 53-05, FIG. 122 AND ER/A 487747-14MA, REV. ORIGINAL ER/A 493648-14MA, REV. A ASSOCISDR DALA2015062203927Window Frame · crackedCRACK ON WINDOW RING PAN FWD LOWER CORNER STA Y=946, Y=788, Y=984 AND Y=1022 AT PAX CABIN, CARD 73, ZONE 100. WINDOW RING PAN FWD LOWER CORNER STA Y=946, Y=788, Y=984 AND Y=1022 WERE REPAIRED IAW SRM 53-05, FIG.122 AND ER/A 493648-14MA, REV A ER/A 487747-14MASDR DALA2015062203926Window Frame · crackedCRACK ON WINDOW RING PAN AFT LOWER CORNER BS 905 AT PAX CABIN, CARD 72, ZONE 100. CRACK ON WINDOW RING PAN AFT LOWER CORNER ON BS Y=905 WAS REPAIRED IAW SRM 53-05 FIG.122 AND ER/A 493648-14MA, REV A, ER/A 487747-14MA, REV ORIGINAL.SDR DALA2015062203925Window Frame · crackedCRACK ON WINDOW RING PAN AFT UPPER CORNER, STA Y=408, Y=1022, Y=1041, Y=1060 AND Y=1098 AT PAX CABIN. WINDOW RING PAN AFT UPPER STA Y=408, Y=1022, Y=1041, Y=1060 AND Y=1098 WERE REPAIRED IAW SRM 53-05, FIG 122 AND ER/A 493648-14MA, REV A, ER/A 487747-14MA, RESDR WX0A2015062272682Ballast · faultyFLIGHT ATTENDANT REPORTS BURNING ELEC SMELL COMING FROM REAR OF ACFT AROUND ROW 36. SMELL GOES AWAY WHEN LIGHTS GO OUT. COMPLIED WITH CABIN ODOR & SMOKE TROUBLESHOOTING CARD 21-059-002, DID NOT FIND ANY ELEC ODORS IN BACK OF CABIN, FOUND LAMP SOCKET OVER 36 SDR WX0A2015062272681Connector · dirtyAFTER TAKEOFF WITH APU RUNNING, TAIL COMPARTMENT TEMP HIGH MASTER CAUTION ILLUMINATED. COMPLIED WITH THE QRH PROCEDURE 21.4 & THE WARNING EXTINGUISHED AFTER TURNING BOTH AC SUPPLY SWITCHES TO HP BLEED, AT 10,000 FT APU WAS SHUT DOWN. FLIGHT CONTINUED AS DIRESDR DALA2015062203893Intercostal · crackedCRACKED INTERCOSTAL X=0 BETWEEN STA Y=1307 TO Y=1287 ALSO X=3 BETWEEN STA Y=1287 TO Y=1279 AT FLOOR STRUCTURE CABIN. SM, W2, CARD 301, ZONE 201. INTERCOSTAL WERE REMOVED IAW SRM 51-30-2, 51-30-5, NEW INTERCOSTAL STA: Y=1287-1307 WAS DRILLED IAW SRM 51-10-4. SDR DALA2015062203891Longeron · corrodedDURING MAINTENANCE ACTIVITIES, FOUND CORROSION OUT OF LIMITS ON LONGERON 22 LT FROM STA Y=1155 TO STA Y =1174 IN REF. CARD156, ZONE 100. CARD 269, ZONE 100. SECTION LONG 22 LT FROM STA Y=1155 TO STA Y=1174 WAS R & R IAW SRM 51-30-2 AND 51-30-5. SPLICE TO LOSDR DALA2015062203931Skin · damagedLIGHTNING STRIKE ON LT FUSELAGE WINDOW BELT AFT EDGE BETWEEN BS Y=408 TO Y=427. LIGHTNING STRIKE ON LT FUSELAGE WINDOW BELT AFT EDGE BETWEEN BS Y=408 TO Y=427 WERE REPAIRED IAW ERA 536438-14, REV. ORIGINAL. ORIGINAL THICKNESS 0.086". REMAINING THICKNESS 0.0SDR DALA2015062103918Seal · missingFLIGHT DIVERTED DUE TO LOSS OF CABIN PRESSURIZATION. FLOW LIGHT ILLUMINATED ON OVERHEAD PANEL AND CREW INITIATED AN EMERGENCY DESCENT. PASSENGER OXYGEN MASKS DID DEPLOY. MAINTENANCE FOUND THE RT PACK DISCHARGE BOOT SEPARATED FROM THE DUCT AND THE LT PACK FUNCSDR DALA2015062203892Skin · damagedLIGHTNING STRIKES ON RT WINDOW BELT BETWEEN STA Y= 655-674 FWD WAS REPAIRED ON UPPER CORNER: WITH DIMENTIONS AS FOLLOWS (UT) WAS ACCOMPLISHED IAW NDT-SPM PART 4, 04-00-078 PAR 5 FIG 3, STA Y=655-674 RT, PLACE FWD UPPER CORNER, ORIGINAL THICKNESS 0.120, REMAINISDR DALA2015062103888Channel · crackedCRACKED CHANNEL ON FLOOR PANEL NR 886C AND 886D. CHANNELS WERE REPLACED ON FLOOR PANELS 886C AND 826D IAW DWG 9936639, REV P.SDR DALA2015062103887Stiffener · crackedCRACK ON STIFFENER OF AFT PRESSURE BULKHEAD AT 12HRS POSITION. STIFFENER WAS REPLACED IAW SRM 51-30-2, 51-30-5, 51-10-4 AND 51-10-3 PAR 21 AND 14 AND DWG 9915562, REV "P". DIMENTION CRACK IS 0.750".SDR DALA2015062103886Tee Fitting · corrodedCORROSION ON MID CARGO DOOR TEES AT STA Y=655 AND 674 BTW LWR EDGE AND BEAM 1 ALSO CORROSION ON ANGLE BESIDE TEE STA Y=674. TEES WERE REPLACED IAW SRM 51-30-2 AND 51-30-1.SDR DALA2015062103885Cargo Track · damagedELONGATED HOLE ON CARGO TRACK BETWEEN LONGERON 28 AND 27 BS 218-332. THE CARGO TRACKS WERE REPAIRED IAW SRM 51-1014/21/38, 51-30-1, 51-30-2 AND 51-30-5 AND ER/A NR 529371-14MA, REV. ORIGINAL.SDR DALA2015062103884Cusp Web · puncturedCRACKED LT CUSP WEB STA X=48 AND X=906 AT PAX CABIN FLOOR STRUCTURE. CRACKED ON CUSP WEB SIDE LT, THIS DAMAGE WAS REMOVED IAW SRM 53-05, FIG 131-A-1, REPAIR PARTS WERE FABRICATED IAW SRM 53-05, FIG 131-A-1, THIS PARTS WERE TREATED AND PAINTED IAW SRM 51-10-0SDR DALA2015062103883Cusp Web · puncturedPUNCTURE ON LT CUSP WEB STA X=53 AND Y=896 AT PAX CABIN FLOOR STRUCTURE. DAMAGE WAS REMOVED-NEW PART REPAIR WAS FABRICATED -PART WAS TREATED AND PAINTED-NEW PART WAS INSTALLED IAW SRM 53-05, FIG 131 A-1, SRM 53-05, FIG 131 A-1 SRM 51-10-3, PAR 21, PAR 14 -SRMSDR DALA2015062103882Frame · crackedMAIN OVERWING FRAME BS 886 RT SIDE IS CRACKED, CONFIRMED WITH EDDY REWORKED OVERWING FRAME AT BS 886. ACCOMPLISHED HFEC INSPECTION OF REWORKED AREA IAW NDTSPM 06-10-01.001, NO CRACKS NOTED.SDR DALA2015062203932Skin · damagedLIGHTNING STRIKE ON FUSELAGE WINDOW BELT AFT UPPER CORNER BETWEEN BS Y=560 TO Y=579 AND STA Y=579 TO Y=598. LIGHTNING STIKE ON FUSELAGE WINDOW BELT AFT UPPER CORNER BS Y= 579 TO Y=598 IN REF. CARD 19, ZONE 100 WERE REPAIRED IAW ER/A 536451-14, REV ORIGINAL, WSDR DALA2015062203898Release Cable · frayedMAINTENANCE DISCOVERED THAT THE TAILCONE EMERGENCY RELEASE CABLE WAS FRAYED BEYOND ALLOWABLE LIMITS. THE CABLE WAS REPLACED AND THE SYSTEM WAS RIGGED TO SPECIFICATIONS.SDR DALA2015062203899Release Cable · misriggedMAINTENANCE FOUND THAT THERE WAS EXCESSIVE TENSION IN THE RELEASE CABLE SYSTEM. SO MUCH TENSION THAT THE CONE RELEASED WITHOUT PULLING THE CABLE. ALSO, THE KEVLAR SLEEVE OVER THE RELEASE CABLE FOR THE TAILCONE WAS WORN OUT OF ALLOWABLE LIMITS. THE CABLE WASSDR DALA2015062003881Floor Panel · puncturedPUNCTURE ON FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2015062003880Tee Fitting · crackedCRACKED AFT CARGO DOOR INBD TEE BS 1174 ALSO INBD AND OTBD TEE BS 1193 BETWEEN BEAM 5 AND UPPER EDGE. REMOVED AND REPLACED IAW SRM 51-30-2, AND SRM 51-30-2.SDR DALA2015062003879Longeron · crackedCRACKED LONGERON 4L BS 1437. THE LONGERON WAS REMOVED, LONGERON FABRICATED AND DRILLED, SPLICE LONGERON WAS TREATED AND PAINTED AND INSTALLED IAW SRM 53-02, FIG 18, 51-10-3 PAR 14 AND 21 AND 51-30-5. CLASSIFIED AS MAJOR REPAIR.SDR DALA2015062003878Frame · crackedCRACKED CANTED FRAME BS 1510 BETWEEN 10-2 O'CLOCK POSITION. FRAME WAS REPLACED IAW SRM 51-30-2, 51-10-4, 51-10-3 PARR 21, 14, AND DWG 9911843 REV AC.SDR DALA2015061903869Frame · crackedCRACKED FRAME BS 1307 AT INTERSECTION WITH LONGERON 1 AT PAX CABIN. FRAME WAS REPAIRED IAW ER/A 536426-14 REV ORIG CRACK LENGTH: .675".SDR DALA2015061903868Skin · corrodedCORROSION ON BARREL NUT HOLE NR 14 BS XH=7 AT HORIZONTAL STABILIZER. DAMAGE ON BARREL NUT HOLE NR 14 WAS REPAIRED IAW ETI 88-15-177, REV 1 AND ER/A 536424-14 REV ORIG FINAL DIAMETER OF REWORK 0.778.SDR DALA2015061903867Skin · crackedCRACKED SKIN AND BRACKET OF LT SLAT TRACK DOOR NR 7 AT LT WING. SLAT TRACK DOOR WERE BONDED IAW DWG 512356-14.SDR DALA2015061803863Support Angle · crackedCRACKED FRAME ANGLE BS 1380 BETWEEN LONGERONS 15-16L . SUPPORT FRAME ANGLE WERE REMOVED, TREATED, PAINTED AND INSTALLED NEW SECTION WAS FABRICATED FRAME IAW SRM 51-30-5, 51-30-2, 51-30-3, 51,10-3 PAR 21,14.SDR DALA2015061803862Longeron · crackedCRACKED LONGERON 3R BS 1437. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2015061803861Skin · damagedWORN REPAIR DOUBLER ON RT WING INBD FLAP INBD VANE. INBD FLAP INBRD VANE WAS REPAIRED.
Back to Mcdonnell Douglas MD-88