Mcdonnell Douglas DC-9-82
Service difficulty reports · 23,866
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 = 'DC982' 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 = 'DC982' 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 T48R200500003Compressor · damagedENGINE WAS REMOVED NR 2 POSITION FOR COMPRESSOR SURGE AT TAKEOFF. TEARDOWN AND INSPECTION REVEALED IMPACT DAMAGE STARTING AT THE 8TH STAGE OF THE N2 COMPRESSOR. ONE EACH VANE WAS MISSING FROM THE C-8 STATOR WITH INCREASING LEVELS OF DAMAGE REARWARD OF THE MISDR GTIA050125O-Ring · wornFUEL SEEPAGE FROM RIGHT WING OVER RIGHT MAIN LANDING GEAR, TAIL SWAP WITH AIRCRAFT 829. REPLACED O-RING ON JUNCTION PROBE. LEAK CHECK GOOD. (M)SDR AALA20050246Battery Pack · dischargedSFO - AFT OVERWING EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK AT STATION 909R FOR AFT OVERWING EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR MWEA050030Skin · crackedRIGHT WING LEADING EDGE SKIN CRACKED AT STATION X15 = 136.421 AT SLAT TRACK. INSTALLED DOUBLER AND TRIPLER.SDR AALA20050244Wire · damagedEWR - EMERGENCY LIGHTING FROM ROWS 1 TO 20 INOPERATIVE. REPAIRED WIRING AT SEAT ROW 1 FOR EMERGENCY LIGHTING FROM ROWS 1 TO 20. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA050123Connector · faultyNR 1 VOR NEEDLES WON’T POINT TO STATION AND DOESN’T PULL BARBER POLE, FLAGS INDICATOR. AIRCRAFT TAIL SWAP WITH 817. REMOVED R50-318 NR 1 NAV RECEIVER RACK CONNECTOR. REPLACED ALL PINS, RETERMINATED BOTH VOR/ILS COAX AND SHIELD CONNECTORS. REINSTALLED CONNESDR GTIA050119Slide · failedAFT SERVICE DOOR EVAC SLIDE DID NOT DEPLOY DURING OPS CHECK, FIRING LANYARD FAILED TO PULL OUT OF FIRING MECHANISM. AFT SERVICE DOOR EVAC SLIDE TO BE REPLACED ON WORK CARD 7809-1-01086/05. (M)SDR GTIA050099Web · puncturedAT STA 200, NR 1 SEAT TRACK LT FLOOR WEB HAS A PUNCTURE. CUT OUT PUNCTURE FROM FLOOR WEB STA 200, NR 1 SEAT TRACK. FABRICATE DOUBLERS AND FILLERS. TREATED AND PRIMED, INSTALLED DOUBLER AND FILLER IAW SRM. (K)SDR AALA20050237Wire · damagedDFW - ENTRY AISLE EMERGENCY LIGHT ASSEMBLY ON FORWARD GALLEY WALL NEAR FLOOR WITH DOUBLE ARROW IS INOPERATIVE. REPAIRED DAMAGED WIRES AT THE BASE OF THE WINDSCREEN FORWARD OF SEAT 3EF WITH ENVIRONMENTAL SPLICES FOR ENTRY AISLE EMERGENCY LIGHT ASSEMBLY ON FORWSDR AALA20050240Spool · malfunctionedDFW - DURING CLIMBOUT AT FL200 LEFT ENGINE FAILED. N2 SPOOL READ ZERO. OIL PRESSURE READ ZERO. N1 SPOOL READ 20. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. PER ENGINEERING REIVEW OF DFDR N2 SPOOL UNCOUPLED FROM GEARBOX. REPLACED NUMBER ONE ENGINE. SYSSDR AALA20050236Module · inoperativeDTW - EMERGENCY EXIT LIGHTS FROM SEAT 21 TO AFT OF CABIN INOPERATIVE. REPLACED MODULE AT ROW 20 FOR EMERGENCY EXIT LIGHTS FROM SEAT 21 TO AFT OF CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA050121Indicator · faultyON APPROACH, RECEIVED NO DOWN AND LOCKED INDICATION (GREEN LIGHT) ON FORWARD PANEL, MECHANICAL PIN ON PEDESTAL WAS EXTENDED, AIRCRAFT TAIL SWAP WITH 818. REMOVED AND REPLACED LANDING GEAR POSITION INDICATORS. OPS HEK NORMAL. (M)SDR AALA20050234Battery · dischargedSFO - EMERGENCY LIGHT ON LEFT AND RIGHT OVERWING EXIT DOORS INOPERATIVE. LEFT EMERGENCY LIGHT SYSTEM IN ARM TO CHARGE LEFT AND RIGHT OVERWING EXIT DOOR EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050235Battery Pack · dischargedTUL - OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK AT STATION 1050 LEFT FOR OVERWING EMERGENCY LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050224Link · inoperativeSTL INFLIGHT T1245/28MAR - AFTER TAKEOFF AND GEAR HANDLE RAISED AIRCRAFT BEGAN VIBRATING TOWARD NOSE AND BELOW OUR FEET. CYCLED GEAR DOWN. VIBRATION REDUCED BUT CONTINUED. RETURNED TO STL AND LANDED WITHOUT INCIDENT. REPLACED RIGHT NOSE GEAR DOOR ACTUATOR.SDR AALA20050231Turbine · failedLAX INFLIGHT T1950/28MAR - RIGHT ENGINE CONTAINED TURBINE FAILURE. ENGINE SHUTDOWN. RETURNED TO LAX AND LANDED WITHOUT INCIDENT. REPLACED ENGINE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050222Battery Pack · inoperativeLGA - EMERGENCY LIGHTS FROM FIRST CLASS TO ROW 20 INOPERATIVE. REPLACED BATTERY PACK AT SEAT 20DEF FOR EMERGENCY LIGHTS FROM FIRST CLASS TO ROW 20. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA050077Knob · defectiveAC VOLT/FREQ SELECTOR KNOB DOES NOT ROTATE TO ANY POSITION, AIRCRAFT TAIL SWAP TO 825NK. REMOVED AND REPLACED VOLT/FREQ DEFLECTOR KNOB. OPS CHECK GOOD. (K)SDR GTIA050097Support Angle · crackedAFT CARGO DOOR FWD UPLOCK SUPPORT ANGLE CRACKED. REMOVED AND FABRICATED NEW ANGLE IAW SRM. TREATED AND PRIMED, INSTALLED SUPPORT ANGLE IAW SRM. (K)SDR ASMF200503018Connector · failedAIRCRAFT WAS RECEIPT AT GDL WITH CAPTAIN REPORT "VHF 1 OUT OF SERVICE", AS A CORRECTIVE ACTION BOTH VHF WERE REPLACED AN TESTED, ALL CORRECT. AIRCRAFT RETURNED OF FLIGHT AS A CONSEQUENCE OF VHF FAILURE CONTINUED. COAXIAL CABLE AND VHF NR 1 WERE CHECKED IAW MMSDR AALA20050213Girt Bar · inoperativeDFW - THE GIRT BAR AT AFT GALLEY DOOR BECAME DISLODGED AND PIN CAME PARTIALLY OUT PREVENTING RESETTING SLIDE LANYARD. REPLACED SLIDE ASSEMBLY FOR AFT GALLEY DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050209Battery Pack · inoperativePHX - EMERGENCY LIGHTS AT OVERHEAD MID CABIN INOPERATIVE. REPLACED BATTERY CHARGER FOR EMERGENCY LIGHTS AT MID CABIN OVERHEAD. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050210Battery Pack · inoperativeDTW - OVERHEAD EMERGENCY LIGHTS AT ROW 6 INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY LIGHTS AT ROW 6. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050205Light · inoperativeDFW - SEAT MOUNTED EMERGENCY LIGHT ASSEMBLY AT 12D INOPERATIVE. REPLACED THE SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT ASSEMBLY AT 12D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR GTIA050084Web · corrodedCABIN STA 180-200, RBL 54, RBL59, SUB FLOOR CORRODED. REMOVED CORROSION AT WEB. MATERIAL LOSS OUT OF LIMITS. REMOVED FWD AIRSTAIR. REMOVED FLOOR SUPPORT RT STA 160 TO 200. CUT OUT DAMAGED AREA AND FABED DOUBLER. PRIMED AND TREATED, INSTALLED FLOOR SUPPORSDR GTIA050072Indicator · intermittentF/O`S VSI INDICATOR GOES ON AND OFF, INTERMITTENT. TAIL SWAP WITH AC N819. REMOVED AND REPLACED VSI INDICATOR. (K)SDR GTIA050059Proximity Sensor · faultyON TAKEOFF, THE GEAR RETRACTED BUT THE NOSE (RED) UNSAFE LIGHT REMAINED ON, AIRCRAFT TAIL SWAP WITH 819NK. T/S FOUND NOSE GEAR DOWNLOCK PROX SENSOR AT MAX CLEARANCE. REMOVED AND REPLACED PROXIMITY SENSOR AND RESHIMMED PROXIMITY SWITCH FOR DESIRED TARGET SENSSDR AALA20050193Battery Pack · inoperativeATL FORWARD ENTRY AND FORWARD GALLEY OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD LIGHTS AT FORWARD ENTRY AND FORWARD GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR GTIA050078Support Angle · corrodedG-2 GALLEY, UPPER SECTION, LOWER EDGE AND SUPPORT ANGLE ARE CORRODED. REMOVED CORROSION ON LOWER EDGE AND SUPPORT ANGLE. FOUND SUPPORT ANGLE OUT OF LIMITS FABRICATED SUPPORT ANGLE IAW SRM. PRIMED AND INSTALLED SUPPORT ANGLE. (K)SDR GTIA050079Doubler · corrodedG-2 GALLEY, CART ENCLOSURE, AFT LOWER LIP AND (2 EA) DOUBLERS ARE CORRODED. REMOVED LOWER LIP AND DOUBLERS, FOUND LIP AND DOUBLERS OUT OF LIMITS. FABRICATED LIP CHANNEL AND DOUBLERS OUT OF LIMITS. FABRICATED LIP CHANNEL AND DOUBLERS. TREAT AND PRIMED. INSSDR GTIA050093Strap · corrodedALUMINUM STRAP ON LOWER SIDE OF L2 DOOR THRESHOLD HAS CORROSION. STRAP CORROSION IS OUT OF LIMITS. FABRICATED NEW STRAP IAW SRM. TREATED AND PRIMED, INSTALLED STRAP ON L2 DOOR THRESHOLD IAW SRM. (K)SDR GTIA050101Stiffener · crackedFS 190 RBL 34 FLOOR WEB STIFFENER IS CRACKED. REMOVED DAMAGE STIFFENER, FOUND OUT OF LIMITS. FABRICATE NEW STIFFENER IAW SRM 51-10-2 AND 51-10-4. TREAT AND PRIMED, INSTALLED STIFFENER IAW 51-30-2. (M)SDR GTIA050102Structure · wornAFT AIRSTAIRS STATION 1370 AT FLOOR LINE HAS A HOLE WORN IN IT FROM THE CATWALK ON LEFT SIDE. TRIMMED OUT DAMAGED SECTION AT FLOOR LINE LEFT SIDE AT STATION 1370. FABRICATED REPAIR DOUBLER AND HEAT TREATED. TREATED AND PRIMED. INSTALLED DOUBLER IAW 51-70-4SDR GTIA050103Support Bracket · crackedFTW - MID PIT BARRIER DOOR AFT SKIN SUPPORT BRACKET CRACKED TWO PLACES. REMOVED AND REPLACED MID PIT BARRIER DOOR IAW SRM 51-30-1 AND 51-30-2. (M)SDR GTIA050104Structure · dentedDENT ON R1 DOOR FS 199 ONE INCH FROM AFT EDGE AND 13 INCHES FROM BOTTOM EDGE, D=.3, X=0.018 INCH, D/X=16/6. REMEASURED DENT AT R1 DOOR (D=0.3, X=.026 D/X 11.5). CUTOUT DAMAGED (DENTED) AREA. FABRICATED REPAIR DOUBLER AND FILLER. TREATED AND PRIMED, INSTALLSDR GTIA050105Skin · dentedDENT ON AFT CARGO DOOR FS 1183 22.5 INCH FROM TOP EDGE AND 26 INCHES FROM AFT EDGE OF DOOR, D=1 INCH, X=.016 INCH, D/X=62. DENT ON AFT CARGO DOOR FS 1183 UNDER CONDITION 1B IS ACCEPTABLE. DYE PENETRANT INSPECTION AFT CARGO DOOR FS 1183. CUTOUT DAMAGED SECTISDR GTIA050106Skin · dentedFOUND DENT ON FUSELAGE SKIN FS 421 BETWEEN LONGERONS 19R AND 20R, D=.5, X=.008, D/X=62.5. REMOVED FORWARD CARGO DOOR TO FOM. REMOVED DAMAGED AREA OF SKIN 1.5 INCH BY .8 INCH. FABRICATED DOUBLER AND FILLER IAW 53-04. TREATED AND PRIMED, INSTALLED REPAIR DOUSDR GTIA050107Skin · gougedFTW - GOUGE ON FUSELAGE SKIN FS 497 BETWEEN LONGERONS 20R AND 21R. BLEND OUT GOUGE FUSELAGE SKIN FS 497. AFTER BLENDED OUT LIFT .036 FOUND TO BE OUT OF LIMITS. CUT OUT DAMAGED AREA. FABRICATED SKIN PLUG AND FINGER DOUBLER. TREATED AND PRIMED SKIN PLUG ANDSDR GTIA050115Fairing · crackedLEFT ELEVATOR FAIRING EDGE CRACKED STATION XE 171. TRIMMED LEFT ELEV FAIRING EDGE AT STATION XE 171. MATERIAL LOSS WITHIN LIMITS. TREAT AND PRIMED IAW SRM 51-10-3. (M)SDR GTIA050116Angle · crackedFTW - MID PIT FORWARD BULKHEAD STATION 522 LEFT LOWER CORNER HAS CRACKED ANGLE. REMOVED CRACKED ANGLE STATION 522. FABRICATED NEW ANGLE IAW SRM 51-10-2. TREATED AND PRIMED, INSTALLED ANGLE AT STATION 522 IAW SRM 51-30-2. (M)SDR GTIA050118Fairing · gougedVERT STAB TIP FAIRING HAVE SCRATCHED/GOUGED ON BOTH SIDE. BLENDED DAMAGED AREA AT VERT STAB MATERIAL LOSS OUT OF LIMITS. REMOVED DAMAGED AREA, FABRICATED FILLER AND DOUBLER IAW SRM 55-01 FIG 4. TREATED AND PRIMED, INSTALLED FILLER AND DOUBLER IAW SRM 51-30-SDR GTIA050081Seat Track · crackedRT OB SEAT TRACK HAS AREA OF CORROSION AT FS 229. REMOVED CORROSION, FOUND OUT OF LIMITS. FABRICATED NEW SEAT TRACK. FOUND WEB OB OF SEAT TRACK FS 218 CRACKED, FABED DOUBLER AND FILLER IAW SRM. PRIMED AND TREATED. INSTALLED DOUBLER, FILLER AND SEAT TRACK SDR GTIA050082Cusp Web · corrodedMID PIT STA 522-636, A LONG 18, RBL 52, FLOOR PANEL UNDER FEDDER CABLES CORRODED. REMOVED CORROSION FROM 522-636, FOUND OUT OF LIMITS. REMOVED WEB STA 503-598, FABED NEW WEB, PRIMED AND TREATED. INSTALLED WEB AT STA 503-598, RBL 52, IAW SRM. (K)SDR GTIA050095Skin · dentedDENT ON FUSELAGE SKIN FS421 BETWEEN LONGERONS 19R AND 20R (D=0.5 INCH, X=0.008 INCH, D/X - 62.5 INCHES). REMOVED CARGO DOOR TO FOM IAW SRM. FOUND DENT HAS GOUGED IN CENTER, REMOVED DAMAGED AREA OF SKIN (1.5 INCH X 0.8 INCH) IAW SRM. FABRICATED DOUBLER AND FSDR GTIA050096Skin · dentedDENT ON AFT CARGO DOOR SKIN 21 INCHES FROM AFT EDGE AND 11 INCHES FROM BOTTOM EDGE OF DOOR (X=0.035 INCH, D=1.75 INCH, D/X=50). STRIPPED AREA OF DENT ON AFT CARGO DOOR FS 1185 IS UNDER CONDITION IAW SRM. DYE PENETRANT INSP, NO CRACK FOUND. REMOVED LATCH HANSDR GTIA050098Doubler · crackedHORIZONTAL STABILIZER, RT SIDE IB UPPER BRACKET SUPPORT HAS CRACK ON DOUBLER. REMOVED CRACKED DOUBLER. FABRICATED NEW DOUBLER. TREATED AND PRIMED, INSTALLED DOUBLER IAW SRM. (K)SDR GTIA050058Cover · damagedLT AILERON IB UPPER ATTACH FITTING COVER DAMAGED, AIRCRAFT TAIL SWAP WITH 819NK. INSTALLED LT AILERON IB UPPER ATTACH FITTING COVER. (K)SDR AALA20050181Clamp · brokenDFW - ON CLIMBOUT NOTICED HOT SMELL. FLIGHT ATTENDANT REPORTED SMOKE IN CABIN. LEFT HAND PACK WAS IN MANUAL PER MEL. TURNED OFF LEFT HAND PACK AND REQUESTED RETURN TO DFW. NEVER GOT OVER 13K FEET. DID AIRCRAFT SMOKE IN CABIN CHECK LIST PULLED CIRCUIT BREASDR GTIA050100Support · damagedFORWARD PIT CEILING, STATION 484 RBL 34, BUSTED NUT PLATE AND DAMAGED STRUCTURE SUPPORT. REMOVED AND REPAIRED DAMAGED SUPPORT IAW SRM 53-01. TREATED AND PRIMED, INSTALLED DOUBLER AND SUPPORT IAW 51-30-2. (M)SDR AALA20050180Rivet · shearedBNA - AIRCRAFT WOULD NOT TAXI FORWARD AFTER PUSHOUT. LEFT HAND BRAKES LOCKED. FOUND RIVET SHEARED ON LEFT HAND BRAKE PAW ASSEMBLY ON CAPTAINS LEFT HAND BRAKE PEDAL LINKAGE. REPLACED RIVET ON LEFT HAND BRAKE PAW ASSEMBLY ON CAPTAINS LEFT HAND BRAKE PEDAL LINK
Back to Mcdonnell Douglas DC-9-82