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 AALA20090714TUL03Pan · crackedLEFT HAND LOWER AFT WINDOW PAN CRACKED. INSTALLED REPAIR ANGLE AT STATION 1022 LEFT HAND LOWER AFT WINDOW PAN PER AARD 53-10-00-25.SDR AALA20090709LGA02Battery Pack · dischargedEMERGENCY BATTERY PACK INOPERATIVE ROW 6. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT ROW 6.SDR AALA20090709LGA01Battery Pack · dischargedEMERGENCY LIGHTS AT ROW 8 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT ROW 8.SDR AALA20090714TUL02Cusp Web · crackedMID-CARGO RIGHT HAND CUSP CRACKED, STATION 594. INSTALLED DOUBLER AT STATION 594 RIGHT HAND SIDE PER AARD 53-20-00-16.SDR AALA20090713TUL02Battery Pack · dischargedEMERGENCY BATTERY PACK AB5-2 AT STATION 850 INOPERATIVE. INSTALLED SERVICEABLE BATTERY PACK AT STATION 850.SDR AALA20090708TUL04Mount · corrodedCORROSION ON FORWARD GALLEY FLOOR MOUNT AT STATION 210, JUST INBOARD TO THE RIGHT OF CENTERLINE. INSTALLED SERVICEABLE GALLEY MOUNT PER SRM 51-01SDR AALA20090708DFW01Sign · looseEXIT SIGN AT AFT FLIGHT ATTENDANT JUMPSEAT FELL OFF AND NEEDS TO BE REATTACHED. REMOVED AND REPLACED EMERGENCY EXIT LIGHT ASSEMBLY AT AFT CABIN ENTRY DOOR, OPS CHECKS GOOD.SDR AALA20090708TUL09Seat Track · corrodedNR 4 SEAT TRACK CORRODED STATION 237. INSTALLED PLUG REPAIR PER AARD 53-20-00-10 AND SRM 53-050 FIGURE 4A.SDR AALA20090708TUL30Seat Track · damagedLUG BLEND OUT OF LIMITS ON NR 6 SEAT TRACK STATION 614. INSTALLED SEAT TRACK PLUG PER AARD 53-20-00-10.SDR AALA20090708TUL05Battery Pack · dischargedEMERGENCY BATTERY PACK INOPERATIVE STATION 243. REMOVED AND REPLACED BATTERY PACK PER 33-60-98-04.SDR AALA20090708TUL03Pan · crackedWINDOW PAN CRACKED AT STATION 1041 RIGHT SIDE. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20090708TUL02Pan · crackedWINDOW PAN CRACKED STATION 985 RIGHT. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20090707TUL21Stop Fitting · crackedMID CARGO DOOR STOP FITTING CRACKED. REPLACED WITH NEW STOP FITTING PER ESO 80174 (DWMS 1189062).SDR AALA20090707TUL20Stop Fitting · crackedMID CARGO DOOR STOP FITTING CRACKED. REPLACED WITH NEW STOP FITTING PER ESO 80174, DWMS 1189056.SDR AALA20090706DFW01Pump · inoperativeDFW - AFT CENTER FUEL TANK BOOST PUMP CIRCUIT BREAKER POPPED IN FLIGHT. EMERGENCY DECLARED, RETURNED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT FORWARD FUEL BOOST PUMP AND CONDUIT ASSEMBLY. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20090705EWR01Seal · failedDFW - AIRCRAFT UNABLE TO RETRACT NOSE LANDING GEAR. EMERGENCY DECLARED, RETURNED TO DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND METERING TUBE BAD AND NOSE STRUT FLAT. REPLACED NOSE LANDING GEAR SHOCK STRUT SEALS. SYSTEM GROUND CHECK NORMAL SDR AALA20090702LGA08Fitting · brokenFOUND RIGHT NUMBER 1 DOOR SLIDE COVER CLIP BROKEN DURING OVERNIGHT MAINTENANCE. REMOVED AND REPLACED RIGHT NUMBER 1 DOOR SLIDE COVER.SDR AALA20090702LGA07Light · inoperativeFORWARD PORTABLE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED FORWARD PORTABLE EMERGENCY FLASHLIGHT PER MM, OPS CHECK OK.SDR AALA20090702LGA06Battery Pack · dischargedEMERGENCY LIGHT AT FORWARD LOWER EMERGENCY OVERWING DOOR INOPERATIVE. REPLACED BOTH BATTERY PACKS AT BIN 20, OPS NORMAL.SDR AALA20090702LGA05Battery · dischargedEMERGENCY LIGHT AT FORWARD LOWER EMERGENCY OVERWING DOOR INOPERATIVE. REPLACED BOTH BATTERY PACKS AT BIN 20, OPS NORMAL.SDR AALA20090702LGA04Battery · not seatedEMERGENCY LIGHTS OVER RIGHT AFT EMERGENCY DOOR INOPERATIVE. RESEATED BATTERY AT ROW 19 AND 20, OPS NORMAL.SDR AALA20090702LGA03Battery Pack · not seatedEMERGENCY LIGHTS IN AFT GALLEY CEILING AREA INOPERATIVE. RESEATED BATTERY PACK AT ROW 27, OPS NORMAL.SDR AALA20090702LGA02Battery Pack · not seatedEMERGENCY LIGHTS IN AFT CABIN AND TWIL COMPARTMENT INOPERATIVE. RESEATED BOTH BATTERY PACKS IN CEILING OF AFT RIGHT LAVATORY, OPS NORMAL.SDR AALA20090702LGA01Battery Pack · dischargedEMERGENCY LIGHTS IN FORWARD CABIN AND COCKPIT INOPERATIVE. REPLACED BATTERY PACK IN FORWARD CEILING, OPS NORMAL.SDR AALA20090703TUL13Fitting · crackedFORWARD SPAR LEFT SIDE FITTING CRACKED. INSTALLED NEW FITTING PER SRM 51-30-01.SDR AALA20090703TUL09Casting · crackedGROUND SPOILER ACTUATOR CASTING CRACKED, LEFT WING. REPLACED ACTUATOR CASTING PER SRM 51-30-01.SDR AALA20090630TUL01Vane · wornFLAP VANE LEADING HAS WEAR AT OUTBOARD FLAP INBOARD HINGE. INSTALLED DOUBLER PER SRM 51-70-2.SDR AALA20090630LGA03Battery Pack · dischargedAFT EMERGENCY LIGHT ON SEAT INOPERATIVE. REPLACED BATTERY PACK FOR AFT EMERGENCY LIGHT ON SEAT.SDR AALA20090703TUL07Casting · crackedGROUND SPOILER CASTING CRACKED. INSTALLED NEW SPOILER CASTING PER SRM 51-30-02.SDR AALA20090630LGA01Battery Pack · dischargedAFT EMERGENCY LIGHT INOPERATIVE. REPLACED EMERGENCY BATTERY PACK FOR AFT EMERGENCY LIGHT AND OPS CHECK GOOD.SDR DU4R2009381Skin · dentedDURING SCHEDULED INSP, FOUND DENT OF FUSELAGE SKIN AT FS 215, BELOW LONGERON 15R.SDR AALA20090630LGA02Battery · inoperativeFORWARD EMERGENCY SEAT LIGHT INOPERATIVE. REPLACED FORWARD AFT EMERGENCY BATTERY AND OPS CHECK GOOD.SDR AALA2009062800006Battery Pack · dischargedLGAM - TAIL COMPARTMENT EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR TAIL COMPARTMENT EMERGENCY LIGHTS.SDR AALA2009062800005Battery Pack · dischargedLGAM - CEILING PANEL EMERGENCY LIGHTS FROM ROW 23 TO ROW 26 INOPERATIVE. REPLACED BATTERY PACK FOR CEILING PANEL EMERGENCY LIGHTS FROM ROW 23 TO ROW 26.SDR WX0A070339Battery Pack · inoperativeDURING A ROUTINE OVERNIGHT SERVICE CHECK INSP, MX REPORTED A PORTION OF THE EMERGENCY EVACUATION LIGHTING SYS WOULD NOT TEST. MX REMOVED AND REPLACED THE APPROPRIATE BATTERIES IN THE POWER SUPPLY BATTERY PACK. A SATISFACTORY OPS CHECK WAS ACCOMPLISHED IAW AMSDR AALA2009062700004Battery · not seatedLGAM - CEILING EMERGENCY LIGHTS FROM ROW 13 TO 16 INOPERATIVE. RESEATED BATTERIES FOR CEILING EMERGENCY LIGHTS FROM ROW 13 TO 16.SDR AALA20090630TUL44Battery Pack · dischargedFORWARD BLUE BATTERY PACK FOR EMERGENCY LIGHTS INOPERATIVE AT STATION 243. REMOVED AND REPLACED BAT5016 OPERATIONAL CHECK GOOD PER WORK CARD 4289.SDR AALA20090630TUL39Battery Pack · dischargedMID BATTERY PACK FOR EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK PER AMM 33-60-98-4. OPERATIONAL CHECKED PER WORK CARD 4289.SDR AALA20090630TUL38Battery Pack · dischargedBATTERY PACK FOR EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK PER MM 33-60-98-4. OPERATIONAL CHECK GOOD PER WORK CARD 4289.SDR AALA20090630TUL35Battery Pack · dischargedBLACK BATTERY PACK FOR EMERGENCY LIGHT INOPERATIVE IN AFT LAVATORY. REMOVED AND REPLACED BAT5014 SERIAL 20640,B 528, STATION 1338 WITH BAT5014 SERIAL 28703 IN ACCORDANCE WITH IPC 33-50-00-12D AND AMM 33-53-00-6 CHECKS GOOD PER WORK CARD 4289 AND 4854.SDR AALA20090630TUL31Battery Pack · dischargedMIDDLE BLUE BATTERY PACK FOR EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED BAT5016 PER MM 33-60-98-4. OPERATIONAL CHECK GOOD PER WORK CARD 4289.SDR AALA2009062400007Pump · shearedDFW - AFTER TAKEOFF RIGHT ENGINE DRIVEN HYDRAULIC PUMP FAILED AND THE NUMBER 2 AUTOPILOT FAILED. EMERGENCY DECLARED, RETURNED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND NUMBER 2 ENGINE DRIVEN PUMP SHAFT SHEARED. REPLACED NUMBER 2 ENGINE DRISDR AALA20090630TUL28Skate Angle · crackedCRACK IN RIGHT SKATE ANGLE BETWEEN VERTICAL STABILIZER AND FUSELAGE AT STATION CANT FRAME 1474. REPAIRED PER SRM 53-05-00 AND AARD 53-10-00-2.SDR AALA20090708TUL21Frame · crackedTHE 1510 CANT FRAME CRACKED AT LOWER LT ALIGNMENT PIN. INSTALLED REPAIR DOUBLER IAW EA NR MD 80-53-006585.SDR AALA20090630TUL17Battery · dischargedOVERWING EMERGENCY LIGHTS COME ON WHEN ELECTRICAL POWER TURNED OFF. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PER MM 33-53-00-4.SDR DU4R2009375Track · corrodedDURING SCHEDULED INSPECTION, FOUND LT FWD TRANSITION TRACK HAD CORROSION FROM FS 1007 TO FS 1212 (AROUND NUT PLATE HOLES, AND AT ATTACH POINTS).SDR AALA2009062200003Connector · defectiveSFO - EMERGENCY LIGHT AT SEAT 31D INOPERATIVE. REMOVED AND REPLACED CONNECTOR AND CONTACTS AT SEAT 31D.SDR AALA20090623TUL08Battery Pack · dischargedBATTERY PACK AB5-3 INOPERATIVE. REMOVED AND REPLACED BAT5016 S/N OFF 18667 S/N ON 14940 IN ACCORDANCE WITH AMM 33-60-98-4, OPERATIONALLY CHECKED PER MCM CARD 4289.SDR AALA20090623TUL07Battery Pack · dischargedBATTERY PACK AB5-4 INOPERATIVE. REMOVED AND REPLACED BATTERY PACK S/N OFF 19032 S/N ON 20770 PER AMM 33-60-98-4, OPERATIONALLY CHECKED GOOD PER MCM CARD 4289.SDR AALA20090623TUL02Battery Pack · dischargedFORWARD CABIN OVERHEAD LIGHTS INOPERATIVE. REMOVED AND REPLACED EMERGENCY BATTERY PACK PER AMM 33-53-00-4.
Back to Mcdonnell Douglas DC-9-82