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 AALA20090521TUL29Tab · burnedTAIL, STATIC DISCHARGE BURN ON TRAILING EDGE OF RUDDER TAB. BLENDED AND FILLED AREA PER ESO 81094.SDR AALA20090521TUL28Tab · burnedTAIL, GEARED TAB TRAILING EDGE HAS STATIC DISCHARGE BURN MARKS. INSTALLED DOUBLER WITH HOT BOND PER SRM 51-70-2.SDR AALA20090521TUL27Fitting · crackedMID CARGO DOOR LOWER AFT STOP FITTING CRACKED. REPLACED DOOR LOWER STOP PAD FITTING PER ESO 80174.SDR AALA20090512TUL40Skate Angle · crackedCRACK IN VERTICAL STABILIZER SKATE ANGLE DOUBLER. REMOVED AND REPLACED WITH NEW SKATE ANGLE DOUBLER PER AARD 53-10-00-2SDR AALA20090513TUL35Longeron · crackedFWD SIDE OF FRAME UNDER LONG 2L IS CRACKED. INSTALLED DOUBLER PER EA MD80-53-006183.SDR AALA2009050200001Sensor · inoperativeUNSAFE NOSE GEAR INDICATION. EMERGENCY DECLARED LANDED AUS WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED NOSE GEAR SENSOR AND RELAY.RELR066. SYSTEM GROUND CHECK NORMAL OPERATION. (CLOSED)SDR AALA2009050200860Light · inoperativeLGA FORWARD CEILING BY AFT GALLEY EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT FORWARD CEILING BY AFT GALLEY.SDR AALA2009050200859Lens · missingLGA SEAT MOUNTED EMERGENCY EXIT LIGHT AT SEAT 13D MISSING LENS. REPLACED LENS FOR SEAT MOUNTED EMERGENCY EXIT LIGHT AT SEAT 13D.SDR AALA2009050200858Light · inoperativeLGA SEAT MOUNTED EMERGENCY EXIT LIGHT AT SEAT 13D INOPERATIVE. REPLACED LAMP FOR SEAT MOUNTED EMERGENCY EXIT LIGHT AT SEAT 13D.SDR AALA20090512TUL57Bracket · crackedVERTICAL BRACKET CRACKED ON FWD WALL BELOW SLANT PANEL IN LT WHEEL WELL 21 INCHES FROM I/B CORNER. REPLACED SLANT PANEL BRACKET PER 51-30-00.SDR AALA2009050100001Seal · failedNOSE GEAR WOULD NOT RETRACT AFTER TAKEOFF. HAD A RED NOSE GEAR LIGHT AND A FLUSH INDICATOR. RETURNED SFO WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED STRUT SEALS AND SERVICED NOSE LANDING GEAR STRUT. REMOVED AND REPLACED D1-31 NOSSDR AALA2009050100856Battery · not seatedLGA CEILING EMERGENCY LIGHTS BETWEEN AFT LAVATORIES INOPERATIVE. RESEATED BATTERIES FOR CEILING EMERGENCY LIGHTS BETWEEN AFT LAVATORIES.SDR AALA2009050100855Light · inoperativeLGA AFT EXTERIOR FUSELAGE EMERGENCY LIGHTS INOPERATIVE. REPLACED LAMP AFT EXTERIOR FUSELAGE EMERGENCY LIGHTS.SDR AALA2009050100854Battery · not seatedLGA TAIL COMPARTMENT EMERGENCY LIGHTS INOPERATIVE. RESEATED BATTERIES FOR TAIL COMPARTMENT EMERGENCY LIGHTS.SDR AALA2009043000001Switch · inoperativeTUL - INFLIGHT SAT-ORD. LEFT ENGINE OIL STRAINER CLOG LIGHT ILLUMINATED. EMERGENCY DECLARED, LANDED TUL WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED NEW FILTER. FOUND OIL DIFFERENTIAL SWITCH BAD REPLACED WITH SWI3004.SDR AALA2009013000405Lens · brokenMSP - EMERGENCY LIGHT LENS AT SEAT 18DEF BROKEN. REPLACED LENS AT SEAT 18DEF.SDR AALA20090512TUL50Battery Pack · dischargedAFT AISLE BATTERY PACK HAS LOW OUTPUT. REMOVED AND REPLACED BATTERY PACK PER AARD 4289.SDR AALA20090512TUL47Battery Pack · dischargedFWD AISLE BATTERY PACK AB5-1 LOW OUTPUT. REMOVED AND REPLACED BATTERY PACK, OPS CHECK GOOD PER MM 33-60-98-4.SDR AALA2009042900001Valve · defectiveEWR - CREW REPORTED STRONG BURNING SMELL THROUGHOUT CABIN. EMERGENCY DECLARED, RETURNED EWR WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. PERFORMED MCM CARD 21-96-01 CABON ODOR TROUBLESHOOTING. REPLACED LEFT PILOT VALVE AND LEFT PACK PRESS REGULATING VASDR AALA20090512TUL49Battery Pack · dischargedCEILING EMERGENCY LIGHTS ARE INOP FROM SEAT 7 TO 16. REMOVED AND REPLACED BATTERY PACKS IN RT BIN PER MM 33-60-98-4.SDR AALA20090512TUL45Skin · crackedCRACK AT FASTENERS LONG 22L STA 188. INSTALLED DOUBLER PER EA 53-006148 DATED 4/28/09.SDR AALA2009042800002Bracket · damagedJFK - INFLIGHT LGA-ORD. CAPTAIN REPORTED HE HAD GEAR LIGHT INDICATING GEAR DOWN WHEN IT SHOULD HAVE BEEN UP AND THERE WAS A BURNING RUBBER SMELL IN COCKPIT. EMERGENCY DECLARED LANDED JFK WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACEDSDR AALA20090428001AValve · inoperativeCREW REPORTED STRONG BURNING ELECTRICAL ODOR. EMERGENCY DECLARED RETURNED EWR WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT PACK PILOT VALVE AND LEFT PACK PRESS REGULATING VALVE. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA2009042700816Battery Pack · dischargedDFW - AFT OVERWING LEFT AND RIGHT EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK IN BIN 20.SDR AALA2009042600002Radar · inoperativeDFW INFLIGHT LAX-ORD. WEATHER RADAR FAILED INFLIGHT. LANDED DFW WITHOUT IONCIDENT. REPLACED WEATHER RADAR RIGHT UNIT AND WEATHER RADAR CONTROL PANEL. SYSTEM GROUND CHECK NORMAL OPERATION. (CLOSED)SDR AALA2009042600831Battery Pack · dischargedLGA - INSIDE RIGHT AFT OVERWING HATCH EXIT SIGN INOPERATIVE. REPLACED BATTERY PACK AT RIGHT AFT OVERWING HATCH EXIT.SDR AALA2009042500002Pump · inoperativeINFLIGHT TPA-DFW. LEFT HAND FUEL BOOST PUMP FAULT. EMERGENCY DECLARED LANDED TLH WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT AFT FUEL BOOST PUMP. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA2009042500826Battery Pack · dischargedLGA - LEFT AND RIGHT AFT EXTERIOR FUSELAGE EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK AT AFT CARGO COMPARTMENT.SDR AALA2009042500825Light · inoperativeLGA - CEILING EMERGENCY LIGHTS FROM ROWS 31 TO 32 INOPERATIVE. REPLACED LAMP FOR CEILING EMERGENCY LIGHTS FROM ROWS 31 TO 32.SDR AALA2009042400819Battery Pack · dischargedDFW - CEILING EMERGENCY LIGHTS AT ROW 20 INOPERATIVE. REPLACED BATTERY PACK FOR CEILING EMERGENCY LIGHTS AT ROW 20.SDR AALA2009042400818Light · inoperativeDFW - RIGHT EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR RIGHT EXTERIOR EMERGENCY LIGHT.SDR AALA2009042400817Battery Pack · dischargedDFW - REMOVED TWO EMERGENCY LIGHT BATTERY PACKS FROM MOUNTS AT BAG BIN 20DEF. INSTALLED BATTERY PACKS IN MOUNTS IN BIN 20DEF.SDR AALA20090512TUL66Battery · defectiveEPL BATTERY NOT TAKING CHARGE. REPLACED BATTERY WITH NEW BATTERY BAT5016 S/N18714.SDR AALA20090512TUL38Skin · damagedLT ALT STATIC PORT, 7 INCH WAVINESS CHECK IS OUT OF LIMITS. INSTALLED DOUBLER PER SRM 51-30-2.SDR AALA2009042300812Battery Pack · dischargedDFW - OVERHEAD EMERGENCY LIGHT ON ROW 7 INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY LIGHT ON ROW 7.SDR AALA20090513TUL15Skin · dentedDENT IN FUSELAGE STA 333 ABOVE LONG 23L. INSTALLED DOUBLER PER SRM 53-04 FIG 38.SDR AALA20090513TUL14Skin · dentedDENT IN FUSELAGE BETWEEN LONG 17L-18L. REPAIRED PER SRM 53-04 FIG 38 SHEET 30 VIEW P.SDR AALA20090512TUL18Skin · damagedLT ALTERNATE STATIC PORT FAILED WAVINESS CHECK. INSTALLED FLUSH DOUBLER PER SRM 53-03-00.SDR AALA20090513TUL13Channel · crackedNOSE LANDING GEAR WHEEL WELL C-CHANNEL IS CRACKED AT SPRAY DEFLECTOR GUIDE LT SIDE. REPAIRED PER AARD 53-10-00-4 REPAIR NR 4.SDR AALA20090513TUL06Fitting · crackedFWD CARGO DOOR STOP PAD FITTING CRACKED CENTER PAD AFT SIDE OF DOOR. REMOVED AND REPLACED FITTING PER ESO 80174.SDR AALA20090513TUL04Fitting · crackedMID CARGO DOOR CENTER STOP PAD FITTING CRACKED ON AFT SIDE OF DOOR. REMOVED AND REPLACED FITTING PER ESO 80174.SDR AALA2009042200001Switch · faultedDFW TAIL COMPARTMENT OVERHEAT LIGHT ILLUMINATED. EMERGENCY DECLARED RETURNED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND SWITCH FAULTED. REPLACED LEFT AND RIGHT HAND SWITCH IN AFT TAIL CONE AREA. SYSTEM GROUND CHECK NORMAL OPERATION. (CLOSSDR AALA20090513TUL10Skin · dentedDENT IN FUSELAGE AT STA 254 AND LONG 18L-19L. INSTALLED DOUBLER PER SRM 53-04 FIG 12B.SDR AALA2009042100002Valve · leakingPSP - CREW REPORTED TAIL COMPARTMENT TEMPERATURE HIGH LIGHT ILLUMINATED. EMERGENCY DECLARED, RETURNED TO PSP WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED TEMPERATURE SENSOR PNEUMATIC GROUND CONNECTION VALVE.SDR AALA2009042100804Light · inoperativeDCA - EMERGENCY PATH LIGHTING AT ROW 25 INOPERATIVE. REPLACED LAMPS FOR EMERGENCY PATH LIGHTS AT ROW 25.SDR AALA2009042100803Receptacle · inoperativeDCA - EMERGENCY PATH LIGHTING AT ROW 25 INOPERATIVE. REPLACED RECEPTACLE FOR EMERGENCY PATH LIGHTS AT ROW 25.SDR AALA2009042100802Light · inoperativeDCA - EMERGENCY PATH LIGHTING AT ROW 25 INOPERATIVE. REPLACED LENS FOR EMERGENCY PATH LIGHTS AT ROW 25.SDR AALA20090512TUL06Floorbeam · crackedFLOOR BOARD SUPPORT CRACK AT STA 1212 AT DOOR FRAME WEB, L28R-L29R. REPLACED FLOORBOARD SUPPORT AT STA 1212, L28R-L29R PER SRM 51-30-00.SDR AALA20090513TUL11Cusp Web · crackedRT CUSP CRACKED UNDER NUMBER 5 SEAT TRACK. CUT OUT CRACKED AREA AND INSTALLED DOUBLER PER 53-20-00-16.SDR AALA20090513TUL07Skin · corrodedLT ALTERNATE STATIC PORT HAS CORROSION. INSTALLED NEW DOUBLER PER SRM 51-30-2.
Back to Mcdonnell Douglas DC-9-82