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 DALA2016092706896Skin · dentedDENT AT STA 416, LONGERON- NR 7, APROX 1.5" X 1.25", .031" BELOW SKIN SURFACE. REPAIRED IAW PRI 551073-14, REV 0 AND ERA 551073-14, REV ORIGINAL.SDR DALA2016092706895Skin · dentedDENT AT STA 662, LONGERON NR 6, APPROXIMATELY 1.5" X 1.25", .018 BELOW SKIN SURFACE. REPAIRED IAW PRI 551073-14, REV 0 AND ERA 551073-14, REV ORIGINAL.SDR DALA2016092706894Skin · dentedDENT AT STA 570, LONGERON NR 7, APPROXIMATELY 1.25" X .75", .029" BELOW SKIN SURFACE. REPAIR IAW PRI 551073-14, REV 0 AND ERA 551073-14, REV ORIGINAL.SDR DALA2016092706893Skin · dentedDENT AT FRAME STA 636, 1.75" BELOW LONGERON NR 6, APPROXIMATELY 1.0" X 1.125", .019 BELOW SKIN SURFACE. REPAIRED IAW PRI 551073-14 REV 0 AND ERA 551073-14, REV ORIGINAL.SDR DALA2016092706892Skin · dentedDENT AT STA 601, 3.5" ABOVE LONGERON NR 7, APPROXIMATELY 1.125 X 075", .015 BELOW SKIN SURFACE. REPAIR COMPLETED IAW PRI 551073-14, REV 0, AND ER/A 551073-14, REV ORIGINAL.SDR DALA2016092706891Skin · dentedDENT AT STA 475, LONGERON NR 7, APPROXIMATELY .75" X .-5", .025" BELOW SKIN SURFACE. REPAIRED IAW PRI 551073-14 REV 0 AND ERA 551073-14, REV ORIGINAL.SDR DALA2016092706899Battery Pack · malfunctionedEXTERIOR EMERGENCY LOWERING LIGHTS INOPERATIVE. RESET BATTERY PACK EMERGENCY LIGHT IAW AMM 33-53. OPERATED EMERGENCY LIGHTS, WORKS NORMAL , OK FOR SERVICES.SDR DALA2016092706890Frame · crackedDURING OPPORTUNITY INSPECTION, FOUND FRAME CRACKED AT STA 1437, L1. REPAIRED FRAME BY DAMAGE CUTOUT AND INSTALLING REPAIR ANGLE IAW PRI 551051-14, REV 0 AND REV 1.SDR DALA2016092706889Spacer · corrodedINITIAL: CORROSION ON PREVIOUS REPAIR AT AFT CARGO COMPARTMENT DOOR JAMB, LOWER POSITION. REPAIR SPACER WAS REPLACED IAW SRM 53-05, FIG 123.SDR DALA2016092706888Beam · crackedINITIAL: CRACK ON BEAM 1, FWD EDGE, AT MAIN ENTRANCE DOOR. CRACK ON BEAM 1 FWD EDGE WAS REPAIRED IAW SRM 52-05, FIG 82.SDR DALA2016092706887Skin · puncturedPUNCTURED LOWER SKIN ON OUTER VANE GUIDE OF OTBD FLAP AT RT WING. DUE TO EXCESSIVE DAMAGE ON OUTER VANE GUIDE OF OTBD FLAP AT RT WING WAS REPLACED IAW IPC 27-50-04-01A.SDR DALA2016092706900Turbine · damagedFLIGHT RETURNED TO DEPARTURE WITH A REPORTED ENGINE ISSUE. PILOT REPORTED BANG ON TAKEOFF. NR 1 ENGINE PARAMETERS DECLINED TO ZERO WITH EGT INCREASING. ENGINE SHUTDOWN. MAINTENANCE FOUND METAL IN TAIL PIPE AND TURBINE DAMAGE. ENGINE CHANGE COMPLETED.SDR DALA2016092606838Battery Pack · dischargedDURING EMERGENCY LIGHTS TEST, FOUND LT AND RT EXTERIOR LIGHTS INOPERATIVE. R & R B5-49 EXT EMERGENCY BATTERY PACK AND BATTERY IAW AMM 33-53. EXTERIOR EMERGENCY LIGHTS. CHECK NORMAL IAW AMM 33-53. ACFT OK FOR SERVICE.SDR DALA2016092606835Frame · crackedTAIL INTERIOR, CANTED FRAME RT WEB INBD EDGE HAS 1" CRACK AT OVERHEAD HORIZONTAL STIFFENER, CBS 1485. NR FOR ADDITIONAL INFORMATION 001-0392:5300-2551/027, 00161 CMOR; REPAIRED. REF; SRM 53-03, FIG 49.SDR DALA2016092606833Spacer · corrodedCORROSION ON PREVIOUS REPAIR AT AFT CARGO COMPARTMENT DOOR JAMB. REPAIR SPLACER WAS REMOVED IAW SRM 51-30-5 AND 51-30-4 NEW SPACER WAS FABRICATED IAW SRM 53-05, PAR 140 NEW SPACER WAS INSTALLED IAW SRM 51-30-5 AND 51-30.SDR DALA2016092606832Tab · delaminatedINITIAL: DELAMINATED LT CONTROL TAB. ELEVATOR CONTROL TAB LT WAS REPLACED IAW AMM 27-30-03-201.SDR DALA2016092606831Spacer · corrodedINITIAL: CORROSION ON MID CARGO COMPARTMENT LOWER DOOR JAMB BEAM PREVIOUS REPAIR SPACER FROM STA Y=636 TO Y=693. SPACER PREVIOUS REPAIR WAS REMOVED IAW SRM 51-30-5 SPACER WAS FABRICATED IAW SRM 53-05, PAR 140, FIG 123 AND SRM 51-10-4 NEW SPACER WAS INSTALLED SDR DALA2016092606830Stringer · crackedCRACK OF 0.5" ON STR 17LT XCW=12 AT LT CENTER TANK. STRINGER 17LT WAS REPAIRED IAW ER/A 549299-14, REV ORIGINAL. REPAIR APPROVAL IS LIMITED TO 24 MONTHS FROM THE FORM 8100-9 APPROVAL DATE: 16/SEP/16.SDR JR2R20160925255Doubler · corrodedE&E BAY INTERNAL DOUBLER CORRODED. REMOVED AND REPLACED INTERNAL DOUBLER IAW EA 40-2016-292.SDR DALA2016092606837Fuse · blownFOUND DURING SERVICE CHECK, AFT CABIN AND TAIL COMPARTMENT EMERGENCY LIGHTS WILL NOT TEST. REPLACED BLOWN FUSE AT POWER SUPPLY B5-212, POSITION 9, IAW WDM 33-51-14. CHECKS OK.SDR DALA2016092606834Door Frame · crackedRIGHT MLG DOOR FWD FRAME CRACKED. REMOVED RT MLG DOOR FORWARD FRAME AND BEGAN REPLACEMENT REF SEC II PERM REPAIR INSTRUCTION ERA 551071-14 AND DWG 5930584.SDR DALA2016092506829Pan · crackedAWR HIDDEN DISCREPANCY: CRACKED UPPER PAN STA Y=674 AT MID CARGO DOOR. CRACKED UPPER PAN STA Y=674 AT MID CARGO DOOR WAS REPAIRED IAW SRM 52-03D, FIG 8.SDR DALA2016092506828Intercostal · crackedINITIAL: CRACK ON INTERCOSTAL AND ANGLE OF MID CARGO DOOR ON STA PROJECTION Y = 674 BETWEEN BEAM NR 5 AND UPPER EDGE. INTERCOSTAL AND ANGLE OF MID CARGO DOOR ON STA PROJECTION Y = 674 BETWEEN BEAM NR 5 AND UPPER EDGE WERE REPALCED IAW SRM:51-30-1, 51-30-2, 51SDR DALA2016092506825Access Panel · puncturedHIDDEN DAMAGE: PUNCTURE ON SECONDARY ACCESS COVER 3070-100, LT WING. SECONDARY ACCESS COVER NR 3070-100 AT LT WING WAS EVALUATED AND IT WAS FOUND OUT OF LIMITS, SECONDARY ACCESS COVER NR 3070-100 WAS REPLACED IAW ERA 530866-14AD MA, REV ORIGINAL.SDR JR2R20160924174Skin · damagedLEFT MLG DOOR FWD OUTBOARD CORNER INNER SKIN CHAFED & CRACKED. REPAIRED THE LEFT MLG DOOR INNER SKIN IAW SRM 52-01 AND 51-10-3.SDR DALA2016092706898Frame · damagedER/A 551051-14 ISSUED TO ACCOMPLISH REPAIR TO FS 1451. FOLLOW ON ACTION IS REQUIRED. ACCOMPLISH SECTION II REPEAT INSPECTIONS EVERY 3,000 FLIGHT CYCLES FOLLOWING ACCOMPLISHMENT OF SECTION I IAW SRM 51-00-10, TABLE 2, THE DAMAGED FRAME IS NOT FCBS, THEREFORE,SDR DALA2016092406824Floor Panel · corrodedAWR CORROSION ON FLOOR PANEL NR 541E. FLOOR PANEL NR:541E WAS MANUFACTURED BY EXCESSIVE CORROSION IAW AMM 53-20-01-201.SDR DALA2016092406823Skin · crackedDAMAGE TO CRACKED UPPER SKIN, FORWARD OTBD STUD AREA, AT LT OTBD FLAP MID GUIDE VANE. LEFT OTBD FLAP MID GUIDE VANE WAS REPAIRED BY ER/A 550294-14, REV ORIGINAL.SDR DALA2016092406822Beam · crackedINITIAL: CRACKED BEAM 1, FORWARD EDGE, APPROXIMATELY STA Y=172 AT FORWARD SERVICE DOOR. DAMAGED BEAM NR 1WAS REPLACED IAW SRM 51-30-1, 51-30-2 AND 51-30-5.SDR DALA2016092406821Frame · crackedTAIL INTERIOR, CANTED FRAME WEB HAS 4" LONG CRACK, CBS 1485, APPROXIMATELY 8 O`CLOCK POSITION. REPAIRED IAW PRI 550919-14, REV 0 AND ERA 550919-14, REV ORIGINAL.SDR DALA2016092306798Power Supply · inoperativeFIRST CLASS AISLE EMERGENCY LIGHTS INOPERATIVE. FOUND FIRST CLASS POWER SUPPLY BAD. REMOVED & REPLACED POWER SUPPLY IAW AMM 33-53. BATTERY NOT REPLACED. OPS CHECKED OK.SDR DALA2016092206775Fuse · defectiveCABIN EMERGENCY LIGHT AT SEAT 24 TO 30 INOPERATIVE. TROUBLESHOT IAW WDM 33-51 AND FOUND BAD FUSES. R & R FUSES IAW AMM 33-50. OPS CK GOOD.SDR DALA2016092206774Wire · out of position1R GALLEY OVERHEAD EMERGENCY LIGHTS INOPERATIVE. FOUND WIRES CROSSED BETWEEN 1R DOOR OVERHEAD EMERGENCY LIGHT SOCKET AND SWITCH FOR OVERHEAD WORK LIGHTS. RECONFIGURED WIRING IAW WDM 33-51-12. OPS CHECK GOOD.SDR DALA2016092206778Pan · crackedAWR: HIDDEN DAMAGE, CRACK ON INNER PAN BELOW PRESSURE SEAL AT STOP FITTING 1 AFT EDGE. THIS CARD WAS ATTENDED IAW ER/A 550269-14, REV ORIGINAL AND ETI-88-16-325.SDR DALA2016092206777Heater Blanket · crackedINITIAL, CRACK ON RT WING HEATER BLANKET AFT EDGE. CRACK WAS REPAIRED IAW ER/A 494597-14AD MA, REV A. CRACK WAS REPAIRED IAW ER/A 494597-14AD MA REV A.SDR DALA2016092206776Heater Blanket · crackedINITIAL, CRACK ON RT WING HEATER BLANKET AFT EDGE. CRACK WAS REPAIRED IAW ER/A 494597-14AD MA, REV A.SDR DALA2016092206773Skin · wornINITIAL: WEAR ON OTBD EDGE UPPER SKIN OF OUTBD VANE GUIDE ON INBD FLAP AT RT WING. RT WING INBD FLAP OTBD GUIDE VANE WAS REPAIRED IAW A/C 9007, CARD 2000-8149-02 AND SRM 57-03D, PARA 11, FIG 11.SDR DALA2016092106772Battery Pack · dischargedOVERWING EMERGENCY LIGHT INOPERATIVE. R & R B5-49 BATTERY PACK REF AMM 33-53. OPS CK GOOD.SDR DALA2016092106759Longeron · corrodedAFT CARGO BILGE-L28R CORRODED AT STA 1287 FWD AND AFT SIDES. REPAIRED LONGERON IAW SRM 53-02, PAR 12, FIG 18.SDR DALA2016092106758Scuff Plate · crackedCRACKED AND ELONGATED AND HOLES ON SCUFF PLATE, PN 5936070-29 AT MID CARGO. SCUFF PLATE WAS REPAIRED IAW ER/A 491023-14MA, REV A.SDR DALA2016092106757Skin · wornWORN PRODUCTION DOUBLER AND INTERNAL WING SKIN BETWEEN STA XW=540 TO STA XW=550, AT LT WING VENT BOX. DAMAGE WAS REMOVED IAW ER/A 094477-14, REV A.SDR DALA2016092106756Frame · crackedINITIAL: CRACK ON FRAME STA Y=1510 BETWEEN 10 AND 11 O`CLOCK POSITION AT AFT ACCESSORY COMPARTMENT. FRAME ON STA Y=1510 WAS REPLACED IAW SRM 51-30-2.SDR DALA2016092106755Pan · crackedINITIAL, CRACKED PAN BELOW STOP FITTING 1 AND 2 AT FWD CARGO COMPARTMENT DOOR AFT EDGE. THIS CARD WAS ATTENDED IAW ER/A 550269-14, REV ORIGINAL.SDR DALA2016092106754Skin · crackedCRACK ON LT RUDDER SKIN AT STA ZR=16 53" TO T/E. DAMAGE ON RUDDER SKIN AT STA ZR=16.53" TO T/E WAS REPAIRED BY SRM 51-70- 1AD, PARA 13 AND JIC CARD 2000-8149-03.SDR DALA2016092106753Frame · crackedTAIL INTERIOR, CBS FRAME WEB 1463-WEB AFT SIDE IS CRACKED AT RIVET APPROXIMATELY 10 O`CLOCK POSITION, 11" INBD OF L10L END FITTING. REPAIRED IAW SRM 53-03D, FIG 38B.SDR DALA2016092106752Structure · crackedINITIAL, AD, CRACKED AND SHEARED RIVET ON UPPER BEAVER TAIL STA XW=47 AT LT WING. SHEARED FASTENER WAS REPLACED IAW SRM 51-30-2 AND CRACK .656" WAS REPAIRED IAW ER/A 550300-14, REV: ORIGINAL AND ETI-88-16-341, REV: ORIGINAL.SDR DALA2016092006740Battery · dischargedCEILING EMERGENCY LIGHTS OUT AT ROWS 23, 24, AND 25. REPLACED BATTERIES IN POWER SUPPLY AT ROW 25, SN-22718. OPS CHECK OK. REF AMM 33-53-00-401.SDR DALA2016092006735Stringer · crackedCRACK ON STR STA Y= 1463 BETWEEN 10 AND 11 O`CLOCK POSITION AT AFT ACCESSORY COMPARTMENT. STR AT STA Y= 1463 BETWEEN 10 AND 11 CLOCK POSITION WAS REPLACED IAW SRM 51-30-5 AND DWG 9911839, REV DP.SDR DALA2016092006739Scuff Plate · crackedCRACKED AND ELONGATED HOLES AT AFT CARGO DOOR SCUFF PLATE. ELONGATE HOLES AND CRACKS WERE WELDED, HOLES WERE RE-DRILLED AND AREAS WERE GROUND, FPI WAS ACCOMPLISHED ON WELDED AREAS, NO CRACKS WERE FOUND IAW ER/A 491023-14MA, REV A.SDR DALA2016092006738Channel · corrodedCPCP INSPECTION- AFT CARGO BILGE, FLOOR SUPPORT LOWER-J ANGLE CORRODED FROM L29L TO L30, STA 1287. REPLACED J CHANNEL IAW SRM 53-03, FIG 2A.
Back to Mcdonnell Douglas MD-88