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 AALA2009041300002Access Door · openDEN - AFTER TAKEOFF WHEN RETRACTING LANDING GEAR EXCESSIVE NOISE AND VIBRATION IN NOSE GEAR AREA. EMERGENCY DECLARED, RETURNED DEN WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND LEFT NOSE GEAR ACCESS DOOR OPEN UPON RETURN. INSPECTED NOSE GEAR, WHEESDR AALA2009041300763Lamp · burned outLGA - EMERGENCY LIGHT BELOW SEAT 23D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT BELOW SEAT 23D.SDR AALA20090512TUL33Bracket · crackedBRACKET CRACKED INSIDE RT WING VENT BOX. REMOVED AND REPLACED BRACKET PER SRM 51-01-00.SDR AALA20090512TUL53Cusp Web · crackedCRACK IN LT CUSP AT STA. 222. INSTALLED NEW CUSP SHEET PER AARD 53-20-00-16, STA 218 TO 237.SDR AALA20090512TUL42Seat Track · damagedNR 1 SEAT TRACK DAMAGED AT STA 636. INSTALLED SEAT TRACK PLUG PER AARD 53-20-00-10.SDR AALA20090512TUL25Cusp Web · corrodedCORROSION ON BOTTOM OF CUSP, RT SIDE, STA 1060-1079. REMOVED CORROSION, INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090512TUL30Seat Track · corrodedCORROSION ON SEAT TRACK NR 5 BEYOND LIMITS, STA 234-237. INSTALLED SEAT TRACK PLUG PER AARD 53-20-00-10.SDR AALA20090512TUL22Cusp Web · crackedLT CUSP CRACKED AT STA 814. ROUTED OUT CRACK AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090512TUL11Seat Track · corrodedCORROSION BEYOND MANUAL LIMITS AT SEAT TRACK NR 6 AT STA 854-859. INSTALLED SEAT TRACK PLUG PER AARD 53-20-00-10.SDR AALA20090422TUL11Skin · damagedRIGHT WING NR 1 SLAT SKIN IS BENT AT AFT INBOARD SIDE. INSTALLED DOUBLER REPAIR PER AARD 57-50-00-5, FIGURE 1 SHEET 1, AND SRM 51-60-00 FIGURE 1, SHEET 1.SDR AALA2009041100759Battery Pack · unsecureLGA - TAIL COMPARTMENT EMERGENCY LIGHTS INOPERATIVE. SECURED TAIL COMPARTMENT EMERGENCY BATTERY PACK.SDR AALA2009041100754Light · brokenDFW RIGHT NUMBER 1 DOOR EMERGENCY EXIT LIGHT LENS IS BROKEN. REPLACED EMERGENCY LIGHT ASSEMBLY AT RIGHT NUMBER 1 DOOR.SDR AALA2009041100751Light · inoperativeLGA CATWALK EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR CATWALK EMERGENCY LIGHT.SDR AALA20090414TUL02Angle · crackedAFT CARGO DOOR, T-ANGLE UPPER AFT CRACKED. INSTALLED NEW T-ANGLE PER ESO 80174.SDR AALA20090414TUL11Shear Tie · crackedAFT ACCESSORY, LONGERON 3L SHEAR TIE CRACKED, STATION 1451. INSTALLED A SERVICEABLE SHEAR TIE INBOARD SIDE OF LONGERON 3L PER SRM 51-10-0.SDR AALA20090414TUL09Longeron · crackedAFT ACCESSORY, LONGERON 3R CRACKED STATION 1451. INSTALLED DOUBLER PER SRM 53-01-00.SDR AALA20090414TUL07Shear Tie · crackedAFT ACCESSORY, STATION 1451 SHEAR TIE CRACKED, LONGERON 3R. INSTALLED A SERVICEABLE SHEAR TIE PER SRM 51-10-0.SDR AALA20090414TUL05Fitting · crackedAFT ACCESSORY LONGERON 3L, CLIP CRACKED STATION 1451. INSTALLED A SERVICEABLE CLIP AT IN BOARD OF LONGERON 3L STATION 1451 PER SRM 51-10-0.SDR AALA20090414TUL03Longeron · crackedLONGERON CRACKED, AFT ACCESSORY, STATION 1451. INSTALLED DOUBLER PER SRM 53-01-00, LONGERON 1 STATION 1451.SDR AALA2009041000750Battery Pack · not seatedLGA CEILING EMERGENCY LIGHTS FROM ROW 8 TO 11 INOPERATIVE. RESEATED BATTERY PACK AT ROW 9DEF.SDR AALA2009041000749Battery Pack · not seatedLGA CEILING EMERGENCY LIGHTS FROM ROW 8 TO ROW 11 INOPERATIVE. RESEATED BATTERY PACK FOR CEILING EMERGENCY LIGHTS FROM ROW 8 TO ROW 11.SDR AALA20090512TUL12Gusset · crackedGUSSET CRACKED AT LT STA 207 L11L. STOP DRILLED AND INSTALLED DOUBLER PER AARD 53-10-00-11.SDR AALA20090512TUL04Longeron · corrodedFUSELAGE AFT SERVICE PAN HAS CORROSION. INSTALLED LONGERON SPLICE AT L22L, BETWEEN STA 1287 AND 1338 PER AARD 53-00-00-05.SDR AALA20090512TUL01Skin · crackedCRACK IN WINDOW BELT UPPER FORWARD CORNER. INSTALLED WINDOW BELT DOUBLER PER AARD 53-10-00-25.SDR AALA20090422TUL13Skin · crackedSKIN CRACKED UNDER LONGERON 2R AT STATION 1418. STOP DRILLED CRACK AND INSTALLED INTERNAL AND EXTERNAL DOUBLERS PER SRM 53-04-00.SDR AALA20090422TUL12Longeron · crackedCRACK IN LONGERON 2R AT STATION 1418. INSTALLED LONGERON SPLICE PER AARD 53-30-00-2.SDR AALA20090414TUL01Angle · crackedAFT CARGO DOOR, T-ANGLE SKIN SIDE LOWER FORWARD CRACKED AROUND FASTENER HOLE.SDR AALA20090413TUL02Casting · crackedRIGHT GROUND SPOILER ACTUATOR ATTACH FITTING CASTING IN TRAILING EDGE OF WING IS CRACKED IN RADIUS AT FORWARD OUTBOARD CORNER. INSTALLED NEW GROUND SPOILER CASTING PER SRM 51-30-00.SDR AALA20090413TUL01Casting · crackedLEFT WHEEL WELL GEAR DOOR ACTUATOR UPPER CASTING IS CRACKED. STOP DRILLED CRACK AND INSTALLED DOUBLER PER AARD 53-10-00-38 REPAIR 38 AND ESO 80559 DATED 04/08/09.SDR AALA2009040800001Adc · inoperativeSTL CAPTAINS AIRSPEED FAILED ON TAKEOFF. RETURNED STL WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NUMBER ONE AIR DATA COMPUTER AND NUMBER THREE VERTICAL GYRO. SYSTEM GROUND CHECK NORMAL OPERATION. (CLOSED)SDR AALA20090415TUL02Longeron · crackedCRACK IN AFT END OF LONGERON 2R AT STATION 1418. REPAIRED PER AARD 53-30-00-2.SDR AALA20090422TUL09Longeron · crackedLEFT SIDE LONGERON 2 IS CRACKED IN RADIUS AT FRAME STATION 1418. SPLICE REPAIR ACCOMPLISHED PER AARD 53-30-00-2.SDR AALA2009040700985Light · inoperativeLGA - AFT RIGHT FUSELAGE EMERGENCY LIGHTS INOPERATIVE. CHECKED OPERATION OF AFT RIGHT FUSELAGE EMERGENCY LIGHT OPERATION CHECKED OK.SDR AALA2009040700984Light · inoperativeLGA - EMERGENCY LIGHT AT AFT LEFT FUSELAGE INOPERATIVE. CHECKED OPERATION OF AFT LEFT FUSELAGE, OPERATIONS CHECKED OK.SDR AALA2009040700729Battery Pack · dischargedLGA - FIRST CLASS EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN FIRST CLASS.SDR AALA2009040700728Battery Pack · dischargedLGA - EMERGENCY LIGHTS AT AFT GALLEY INOPERATIVE. REPLACED BATTERY PACK AT AFT GALLEY.SDR AALA2009040700727Battery Pack · dischargedLGA - EMERGENCY LIGHTS AT ROW 20 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT ROW 20.SDR AALA20090423TUL07Web · corrodedLEVEL 1 CORROSION ON WEB INSIDE THE LOWER DOOR AREA FROM STATION 1155-1174. REMOVED SECTION OF WEB AND SPLICED IN NEW SECTION FROM STATION 1143-1163 PER AARD 53-10-00-24, AND BLENDED SPOTS OF LIGHT CORROSION FROM STATION 1163-1174 WITHIN LIMITS.SDR AALA20090422TUL10Beam · damagedFASTENER HOLE DAMAGED IN AFT CARGO DOOR BEAM STATION 1163. INSTALLED FREEZE PLUG PER EA MD80-53-005908.SDR AALA20090422TUL07Frame · crackedAFT ACCESSORY LEFT SIDE CANTED FRAME 1463 HAS A CRACKED DOUBLER AT LONGERON 18L. INSTALLED DOUBLER PER SRM 53-01-00 FIGURE 2, SHEET 4 AND AARD 51-00-00-014.SDR WX0A070286Battery Pack · inoperativeDURING A ROUTINE OVERNIGHT SERVICE CHECK INSPECTION MAINTENANCE DEPARTMENT PERSONNEL REPORTED A PORTION OF THE EMERGENCY EVACUATION LIGHTING SYSTEM WOULD NOT TEST. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE APPROPRIATE BATTERIES IN THE POWER SUPPLY BATTERSDR AALA2009040600001Pressure Switch · inoperativeDFW CREW REPORTED CABIN FAILED TO PRESSURIZE. RETURNED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED COMPRESSOR INLET AND OUTLET PRESSURE SWITCHES FOR LEFT HAND SIDE AND RIGHT PACK TEMPERATURE CONTROL VALVE. VAL5425. SYSTEM GROUND CHECK SDR AALA20090626TUL05Battery Pack · dischargedFORWARD AISLE BATTERY PACK HAS LOW OUTPUT. REPLACED BATTERY PACK WITH SERVICEABLE UNIT AND PERFORMED OPERATIONAL CHECK PER WORK CARD 4854.SDR AALA20090407TUL01Frame · crackedAFT ACCESSORY, FORWARD SIDE OF FRAME 1418 CRACKED AT STRINGER 2 RIGHT. INSTALLED DOUBLER PER SRM 53-03-00 AND EA MD80-53-005869.SDR AALA20090409TUL13Skin · crackedFUSELAGE SKIN CRACKED AT STATION 1380 LONGERON 14R. INSTALLED DOUBLER PER SRM 53-30-00-02.SDR AALA20090409TUL12Battery Pack · dischargedEMERGENCY LIGHT BATTERY INOPERATIVE. INSTALLED SERVICEABLE BATTERY PACK AND PERFORMED OPERATIONAL CHECK PER WORK CARD 4289.SDR AALA20090409TUL11Battery Pack · dischargedEMERGENCY LIGHT BATTERY INOPERATIVE. INSTALLED SERVICEABLE BATTERY PACK AND PERFORMED OPERATIONAL CHECK PER WORK CARD 4289.SDR AALA20090409TUL10Battery Pack · dischargedEMERGENCY BATTERY PACK FOR EPL DEAD AND WILL NOT CHARGE. REPLACED EMERGENCY BATTERY PACK WITH SERVICEABLE UNIT AND PERFORMED OPERATIONAL CHECK PER WORK CARD 4854.SDR AALA20090409TUL09Battery Pack · dischargedFORWARD AISLE BATTERY PACK HAS LOW OUTPUT. REPLACED BATTERY PACK WITH SERVICEABLE UNIT AND PERFORMED OPERATIONAL CHECK PER WORK CARD 4854.SDR AALA20090409TUL08Battery Pack · dischargedAFT AISLE BATTERY PACK HAS VERY LOW OUTPUT. INSTALLED SERVICEABLE BATTERY PACK AND PERFORMED OPERATIONAL CHECK PER WORK CARD 4854.
Back to Mcdonnell Douglas DC-9-82