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 AALA20090818DFW01Pump · failedDFW - CREW REPORTED RIGHT ENGINE DRIVEN HYDRAULIC PUMP FAILED. RETURNED TO DFW WITHOUT INCIDENT. FOUND RIGHT ENGINE DRIVEN HYDRAULIC PUMP SHAFT SHEARED. REMOVED AND REPLACED RIGHT ENGINE DRIVEN HYDRAULIC PUMP. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20090819TUL09Cusp Web · corrodedLEFT CUSP HAS CORROSION AT STATION 1170 UNDER SERVICE DOOR AFT GIRT BAR FITTING. INSTALLED DOUBLER AND FILLER UNDER AARD 53-20-00-16.SDR AALA20090819TUL08Web · corrodedCORROSION ON SUB FLOOR WEB OUTBOARD OF NUMBER 2 SEAT TRACK. INSTALLED DOUBLER UNDER AARD 53-20-00-16.SDR AALA20090817TUL01Stop Fitting · crackedFORWARD ENTRY DOOR HAS INTERNAL CRACK IN RADIUS, FORWARD JAMB AT LOWER SIDE OF NUMBER 2 STOP BRACKET SUPPORT STRUCTURE. STOP DRILLED CRACK, DYE-CHECK CONFIRMED, INSTALLED DOUBLER UNDER SRM 52-05-00 FIG 31 (SHEET 3).SDR AALA20090817LGA05Battery Pack · dischargedEMERGENCY LIGHT FOR ROW 20DEF INOPERATIVE. REPLACED AFT BATTERY PACK FOR EMERGENCY LIGHT FOR ROW 20DEF.SDR AALA20090817LGA04Battery Pack · dischargedFIRST CLASS EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR FIRST CLASS EMERGENCY LIGHTS.SDR AALA20090817LGA03Battery Pack · dischargedFORWARD EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR FORWARD EMERGENCY LIGHTS.SDR AALA20090817LGA02Battery Pack · dischargedCEILING EGRESS LIGHTS INOPERATIVE ON ROW 7-14. REPLACED BATTERY PACK FOR CEILING EGRESS LIGHTS FROM ROWS 7-14. OPS CHECK GOOD.SDR AALA20090817LGA01Battery Pack · dischargedCEILING EGRESS LIGHTS ROW 7-16 INOPERATIVE. REPLACED BATTERY PACK FOR CEILING EGRESS LIGHTS FROM ROWS 7-16. OPS CHECK GOOD.SDR AALA20090825TUL22Strap · corrodedCORROSION ON STRAP LONGERON 23L STATION 1303-1309. REPLACED STRAP UNDER SRM 51-30-05.SDR AALA20090814TUL22Beam · crackedFORWARD ENTRY DOOR NUMBER 6 BEAM CRACKED AT BAYONET CRANK MOUNT HOLE. STOP DRILLED CRACK, DYE CHECKED, INSTALLED PASSENGER DOOR BEAM DOUBLER.SDR AALA20090814TUL23Sill · dirtyDFW - CREW REPORTED AIRCRAFT UNABLE TO PRESSURIZE AND A LOUD RUSH OF AIR WAS HEARD NEAR AFT GALLEY DOOR. RETURNED TO DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REMOVED DEBRIS AND CLEANED AND LUBED ALL DOOR SILLS. PRESSURIZED AIRCRAFT AND NO LEAKSSDR AALA20090814DFW01Duct · rupturedDFW - CREW REPORTED BOTH FIRE LOOPS INDICATION FOR LEFT ENGINE ILLUMINATED ON CLIMBOUT THEN FIRE WARNING INDICATION ILLUMINATED. EMERGENCY DECLARED, RETURNED TO DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. OPENED LEFT ENGINE COWLINGS AND FOUND ANTISDR AALA20090814TUL02Rib · crackedRIGHT WING NUMBER 5 SLAT RIB IS CRACKED AT NUMBER 14 SLAT TRACK ATTACHMENT. REPLACED RIB UNDER SRM 57-50-13.SDR AALA20090814TUL01Rib · crackedRIGHT WING NUMBER 5 SLAT OUTBOARD RIB IS CRACKED AT NUMBER 15 SLAT TRACK ATTACHMENT. REPLACED RIB UNDER SRM 57-50-13.SDR AALA20090813DFW03Circuit Breaker · failedDFW - CREW REPORTED AFT CENTER FUEL TANK BOOST PUMP POPPED IN CLIMBOUT. EMERGENCY DECLARED, RETURNED TO DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED THE AFT CENTER BOOST PUMP CIRCUIT BREAKER. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20090814TUL05Pan · crackedTOP AFT CORNER OF WINDOW PAN IS CRACKED BETWEEN STATION 1060-1041 LEFT. INSTALLED DOUBLER UNDER AARD 53-10-00-25.SDR AALA20090814LGA02Battery Pack · dischargedCEILING EMERGENCY LIGHTS ROW 11-22 INOPERATIVE. REMOVED AND REPLACED EMERGENCY BATTERY PACK ROW 20 CENTER POSITION. GROUND OPS CHECK NORMAL.SDR AALA20090814LGA01Battery Pack · dischargedFORWARD CABIN EMERGENCY LIGHTS INOPERATIVE. REPLACED EMERGENCY BATTERY PACK B5-23 FOR FORWARD CABIN EMERGENCY LIGHTS. OP CHECK NORMAL.SDR AALA20090813DFW01Gyro · inoperativeDFW - WHEN AIRCRAFT WAS MAKING A TURN OF FIFTEEN DEGREES THE CAPTAINS ATTITUDE INDICATOR FLUCTUATED WILDLY CAUSING THE AUTO PILOT AND AUTO THROTTLES TO DISENGAGE. RETURNED DFW WITHOUT INCIDENT. REMOVED AND REPLACED ALL THREE GYROS. SYSTEM GROUND CHECKED NORSDR AALA20090825TUL03Seat Track · corrodedSEAT TRACK NUMBER 5 IS CORRODED STATION 204. REPLACED NUMBER 5 SEAT TRACK UNDER SRM 51-30-05, 51-30-01, 53-05-00.SDR AALA20090819TUL12Longeron · crackedLONGERON L2 CRACKED AT STATION 160. REMOVED AND REPLACED LONGERON AT STATION 148 TO 170 UNDER SRM 53-02-00.SDR AALA20090819TUL11Seat Track · corrodedSEAT TRACK NUMBER 5 HAS CORROSION STATION 204. REPLACED NUMBER 5 SEAT TRACK FROM STATION 218 TO 246 UNDER SRM 51-30-05.SDR AALA20090819TUL10Cusp Web · corrodedCUSP CRACKED STATION 218-237. REPLACED CUSP UNDER SRM 51-30-05.SDR AALA20090814TUL08Frame · crackedCANT FRAME 1485 LEFT SIDE IS CRACKED. INSTALLED DOUBLER UNDER AARD 53-10-00-32.SDR AALA20090812LGA01Light · inoperativeEMERGENCY LIGHT INOPERATIVE BETWEEN AFT CABIN LAVATORY. REPLACED LAMP FOR EMERGENCY LIGHT AT AFT CABIN LAVATORY. OPS CHECKS NORMAL.SDR AALA20090810DFW01Transformer · inoperativeDFW - CREW REPORTED AIRFOIL ANTI-ICE ABNORMAL PRESSURE LIGHT ON IN FLIGHT AND FIRST OFFICER WINDSHIELD CIRCUIT BREAKER POPPED. RETURNED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED THE WINDSHIELD, CONTROLLER, AND TRANSFORMER. SYSTEM GROUNDSDR AALA20090811LGA04Lamp · burned outCEILING EMERGENCY LIGHT RIGHT SIDE ABOVE SEAT 4E INOPERATIVE. REPLACED LAMP FOR CEILING EMERGENCY LIGHT. OPS CHECK OK.SDR AALA20090811LGA03Lamp · burned outCEILING EMERGENCY LIGHT RIGHT SIDE ABOVE SEAT 6E INOPERATIVE. REPLACED LAMP FOR CEILING EMERGENCY LIGHT. OPS CHECK GOOD.SDR AALA20090811LGA02Battery · not seatedCEILING EMERGENCY LIGHTS INOPERATIVE FROM ROWS 23 TO 30. RESEATED BATTERY FOR LIGHTS FROM ROWS 23 TO 30. OPS CHECK NORMAL.SDR AALA20090811RDU01Battery Pack · dischargedCOCKPIT EMERGENCY EVACUATION LIGHTS DO NOT ILLUMINATE WHEN TURNED ON. FOUND BATTERY PACK BAD. REPLACED BATTERY PACK FOR COCKPIT EMERGENCY LIGHTS.SDR AALA20090811LGA01Battery · not seatedRIGHT FORWARD OVERWING HATCH LOWER EXIT LIGHT INOPERATIVE. RESEATED BATTERY FOR RIGHT FORWARD OVERWING HATCH LOWER EXIT LIGHT. OPS CHECK NORMAL.SDR AALA20090810TUL06Stop Fitting · crackedFORWARD CARGO DOOR: NUMBER FIVE BEAM FORWARD STOP FITTING CRACKED. REMOVED AND REPLACED FITTING PER ESO 80174.SDR AALA20090810TUL05Stop Fitting · crackedFORWARD CARGO DOOR: NUMBER FOUR BEAM FORWARD STOP FITTING CRACKED. REMOVED AND REPLACED FITTING UNDER ESO 80174.SDR AALA20090810TUL04Stop Fitting · crackedFORWARD CARGO DOOR: NUMBER THREE BEAM FORWARD STOP FITTING CRACKED. REMOVED AND REPLACED FITTING UNDER ESO 80174.SDR AALA20090810TUL03Pan · crackedFORWARD CARGO DOOR: HIGH FREQUENCY EDDY CURRENT INDICATES CRACK IN PAN AT LOWER STOP FITTING ON AFT LOWER CORNER AT STOP FITTING. STOP DRILLED CRACK, DYE CHECKED AND INSTALLED DOUBLER UNDER ESO 80174.SDR AALA20090809LGA01Battery Pack · looseLEFT AND RIGHT FORWARD OVERWING DOOR UPPER EXIT SIGNS INOPERATIVE. SECURED FORWARD OVERWING LIGHTS BATTERY PACK TERMINALS.SDR AALA20090811TUL24Beam · corrodedFORWARD CARGO DOOR BEAM AT STATION 398 HAS CORROSION. BEAM REPAIRED UNDER EA MD80-53-007068.SDR AALA20090810TUL01Battery Pack · dischargedLOWER TAIL CONE EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK FOR LOWER TAIL CONE EMERGENCY LIGHT.SDR AALA20090811TUL29Battery Pack · dischargedAFT EMERGENCY LIGHTS WEAK. INSTALLED SERVICEABLE BATTERY PACK FOR AFT EMERGENCY LIGHTS.SDR AALA20090806TUL15Stop Fitting · crackedLOWER AFT STOP FITTING CRACKED AT NUMBER 1 BEAM AREA. REMOVED AND REPLACED FITTING UNDER ESO 80174.SDR AALA20090806TUL01Skin · crackedFUSELAGE SKIN CRACKED STATION 1474 L23L. INSTALLED DOUBLER UNDER SRM 53-01-00 AND AARD 53-30-00-02.SDR AALA20090805TUL13Stop Fitting · crackedMID CARGO DOOR TOP FORWARD STOP BRACKET (FITTING) CRACKED. INSTALLED NEW TOP FORWARD STOP BRACKET (FITTING) UNDER ESO 80174.SDR AALA20090804EWR01Indicator · failedLEFT WING FUEL INDICATION FAILED DURING FLIGHT. DUE TO FLIGHT PLAN CHANGE CREW MADE PRECAUTIONARY LANDING IN BNA TO ADD FUEL. LANDED WITHOUT INCIDENT. REPLACED LEFT WING FUEL TANK DIGITAL FUEL QUANTITY INDICATOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20090805LGA03Battery Pack · unsecureCABIN OVERHEAD EMERGENCY LIGHT ROW 27-30 INOPERATIVE. REPOSITIONED AND SECURED BATTERY PACK AT MID CABIN. OPS NORMAL.SDR AALA20090805LGA02Battery Pack · dischargedCOCKPIT OVERHEAD EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK AT FORWARD CABIN. OPS, NORMAL.SDR AALA20090805LGA01Strap · missingFORWARD UPPER FLASHLIGHT SAFETY STRAP MISSING. REPLACED SAFETY STRAP FOR FORWARD UPPER FLASHLIGHT.SDR AALA20090821TUL06Battery Pack · dischargedEMERGENCY BATTERY IS WEAK AT STATION 1190. REPLACED EMERGENCY LIGHT BATTERY PACK AT STATION 1190 UNDER MM 33-53-00-6.SDR AALA20090805TUL12Battery Pack · dischargedEMERGENCY BATTERY IS WEAK AT STATION 1322. REPLACED EMERGENCY LIGHTING BATTERY PACK UNDER MM 33-53-00-6.SDR AALA20090805TUL11Light · defectivePORTABLE EMERGENCY LIGHT IS DIM. REPLACED EMERGENCY LIGHT IAW MM 33-53-00-5.
Back to Mcdonnell Douglas DC-9-82