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 AALA20090805TUL10Battery Pack · dischargedAFT EMERGENCY AISLE LIGHTING BATTERY PACK IS WEAK. REMOVED AND REPLACED WITH SERVICEABLE BATTERY PACK IAW MM 33-60-98-4.SDR AALA20090805TUL09Battery Pack · dischargedEMERGENCY AISLE BATTERY PACK IS WEAK. REMOVED AND REPLACED WITH SERVICEABLE BATTERY PACK IAW MM 33-60-98-4.SDR AALA20090802LGA06Strap · brokenFLASHLIGHT STRAP BROKEN OFF FLASHLIGHT BY FLIGHT ATTENDANT SEAT AFT GALLEY DOOR. REPLACED STRAP FOR FLASHLIGHT BY FLIGHT ATTENDANT SEAT AFT GALLEY DOOR.SDR AALA20090802LGA05Strap · brokenFLASHLIGHT STRAP BROKEN OFF FLASHLIGHT BY FLIGHT ATTENDANT SEAT AFT GALLEY DOOR. REPLACED STRAP FOR FLASHLIGHT BY FLIGHT ATTENDANT SEAT AFT GALLEY DOOR.SDR AALA20090802LGA04Strap · brokenFLASHLIGHT STRAP BROKEN OFF FLASHLIGHT OUTSIDE FORWARD AFT RIGHT LAVATORY. REPLACED STRAP FOR FLASHLIGHT OUTSIDE AFT RIGHT LAVATORY.SDR AALA20090802LGA03Battery Pack · dischargedFORWARD CEILING EMERGENCY LIGHTS OUT. REPLACED FORWARD EMERGENCY BATTERY PACK. OPS CHECK NORMAL.SDR AALA20090802LGA02Battery · not seatedCEILING EMERGENCY LIGHT BY AFT RIGHT LAVATORY INOPERATIVE. RESET AFT EMERGENCY BATTERIES. OPS CHECK NORMAL.SDR AALA20090802LGA01Battery · not seatedCEILING EMERGENCY LIGHT ABOVE FLIGHT ATTENDANT SEAT BY AFT VENTRAL DOOR INOPERATIVE. RESET AFT EMERGENCY BATTERIES. OPS CHECK NORMAL.SDR AALA20090803DEN01Slide · malfunctionedFORWARD GALLEY DOOR SLIDE, FLIGHT ATTENDANT FAILED TO DISARM SLIDE AND SKYCHEF FAILED TO CHECK TO SEE IF IT WAS DISARMED, SKYCHEF OPENED DOOR AND SLIDE CAME OFF DOOR AND DID NOT DEPLOY. SLIDE REPLACED ON E58 DURING PS CHECK.SDR AALA20090802PVR01Pitot Tube · obstructedBIRD STRIKE ON TAKEOFF CAUSING LEFT ENGINE SURGE 5-6 PERCENT AND FIRST OFFICER PITOT TUBE BLOCKED. INSPECTED AIRCRAFT FOR BIRD STRIKE AS PER MM AND RUN UP ENGINE TO TAKEOFF POWER OK FOR SERVICE. REPLACED FIRST OFFICER PITOT TUBE AS PER MM, OK FOR SERVICE.SDR AALA20090801DFW01Actuator · faultedDFW - AUTO SLAT FAIL LIGHT ILLUMINATED ON TAKEOFF OUT OF AUS THEN HAD FLAP DISAGREE LIGHT ON DESCENT. LANDED DFW WITHOUT INCIDENT. FOUND FORWARD AUTO SLAT ACTUATOR FAULTED. REPLACED ACTUATOR AND ADJUSTED CONTROL VALVE. SYSTEM GROUND CHECKED NORMAL OPERATIOSDR WX0A070375Engine · failedSEIZURE OF THE NR 2 (RIGHT) ENGINE AT 1200FT. PERFORMED EQRH, TRIED TO RELIGHT WITH NO SUCCESS. SECURED THE ENGINE AND LANDED AT FLL. MAINTENANCE DEPARTMENT PERSONNEL PERFORMED ALLEGIANT AIR TASK CARD R0807101, MD80, JT8D ENGINE REMOVAL AND REPLACEMENT. OK FSDR AALA20090731TUL19Stop Fitting · crackedFORWARD CARGO AFT SECOND FROM INBOARD DOOR STOP CASTING CRACKED. REMOVED AND REPLACED STOP BRACKET UNDER ESO 80174.SDR AALA20090805TUL08Battery Pack · dischargedEMERGENCY AISLE BATTERY PACK IS WEAK. REMOVED AND REPLACED WITH SERVICEABLE BATTERY PACK IAW MM 33-60-98-4.SDR AALA20090805TUL07Battery Pack · dischargedEMERGENCY AISLE BATTERY PACK IS WEAK. REMOVED AND REPLACED WITH SERVICEABLE BATTERY PACK IAW MM 33-60-98-4.SDR AALA20090805TUL06Battery Pack · dischargedEMERGENCY AISLE BATTERY PACK IS WEAK. REMOVED AND REPLACED WITH SERVICEABLE BATTERY PACK IAW MM 33-60-98-4.SDR AALA20090730LGA01Strap · missingLGA - FORWARD LOWER FLASHLIGHT SAFETY STRAP MISSING. REPLACED SAFETY STRAP FOR FORWARD LOWER FLASHLIGHT.SDR AALA20090729TUL02Stop Fitting · crackedTUL - NUMBER FIVE BEAM FORWARD STOP-PAD FITTING CRACKED. REPLACED STOP-PAD FITTING PER ESO-80174.SDR AALA20090729TUL01Stop Fitting · crackedTUL - NUMBER ONE BEAM FORWARD STOP-PAD BRACKET CRACKED. REPLACED STOP-PAD BRACKET UNDER ESO-80174.SDR AALA20090729LGA02Battery · dischargedLGA - FIRST CLASS EMERGENCY LIGHTS INOPERATIVE. REPLACED FIRST CLASS BATTERIES AND CHARGER. OPS CHECK NORMAL.SDR AALA20090729LGA01Battery Pack · malfunctionedLGA - FORWARD OVERWING HATCH EXIT LIGHTS LEFT AND RIGHT INOPERATIVE. RESET BATTERY AND CHARGER AT OVERHEAD BIN 19. OPS CHECK NORMAL.SDR AALA20090730TUL11Skin · crackedTUL - CRACK IN FUSELAGE SKIN. REPAIR DOUBLER WAS INSTALLED UNDER SRM 53-30-00-02.SDR AALA20090727TUL01Coalescer Bag · dirtyMSY - INFLIGHT DFW-RSW. AFTER ACTIVATING ENGINE ANTI-ICE CREW REPORTED STRONG ACRID ODOR ON FLIGHT DECK AND IN CABIN. EMERGENCY WAS DECLARED AND LANDED MSY WITHOUT INCIDENT. REPLACED COALESCER BAGS. SYSTEM GROUND CHECKED NORMAL OPERATIONS.SDR AALA2009072700002Shroud · brokenMSP - EMERGENCY LIGHT SHROUD AT SEAT 32D BROKEN. REPLACED EMERGENCY LIGHT SHROUD AT SEAT 32D.SDR AALA2009072700001Shroud · brokenMSP - EMERGENCY LIGHT SHROUD AT SEAT 24D BROKEN. REPLACED EMERGENCY LIGHT SHROUD AT SEAT 24D.SDR AALA20090727MCI01Splice · damagedMCI - EMERGENCY LIGHT INOPERATIVE IN REAR AIRSTAIR AREA. REPLACED WIRING SPLICE FOR EMERGENCY LIGHT IN REAR AIRSTAIR AREA.SDR AALA20090726TUL02Controller · failedCREW REPORTED BRAKE FAILURE DURING TAXI OUT AT TUL. AIRCRAFT WAS STOPPED WITH ENGINE REVERSE AND HARD LEFT TURN. REPLACED ANTI SKID MAIN LANDING GEAR WHEEL BRAKE CONTROL UNDER MM 32-43-04-2. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR WX0A070358Power Supply · dischargedDURING 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 AALA20090726SFO01Battery Pack · dischargedFORWARD OVERWING EMERGENCY LIGHT SIGNS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK FOR FORWARD OVERWING EMERGENCY LIGHT SIGN. OPS CHECK NORMAL.SDR AALA20090725TUL01Actuator · inoperativeTUL - ADVISED ON FINAL GEAR EXTENDED WITH 3 RED LIGHT/FAULT INDICATIONS. FLIGHT ACCOMPLISHED GO AROUND. EMERGENCY DECLARED, LANDED TUL WITHOUT INCIDENT. REPLACED RIGHT MAIN LANDING GEAR RETRACT ACTUATOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20090730TUL02Frame · damagedTUL - FASTENER MISSING IN HANGER BRACKET AND UNUSED RIVET HOLES IN FRAME HAVE NOT BEEN PLUGGED AT STATION 1287 BETWEEN L4L AND L5L. INSTALLED REPAIR PLATE AND REPAIR ANGLE UNDER SRM 53-03-00.SDR AALA20090730TUL29Battery Pack · dischargedTUL - PASSENGER SEAT EMERGENCY LIGHT BATTERY PACK IS WEAK. REPLACED WITH SERVICEABLE BATTERY PACK FOR PASSENGER SEAT EMERGENCY LIGHT.SDR AALA20090730TUL34Battery Pack · dischargedTUL - PASSENGER SEAT EMERGENCY LIGHT BATTERY PACK AB5-2 IS WEAK. REPLACED WITH SERVICEABLE BATTERY PACK FOR PASSENGER EMERGENCY LIGHT.SDR AALA20090730TUL33Battery Pack · dischargedTUL - PASSENGER SEAT EMERGENCY LIGHT BATTERY PACK AB5-3 IS WEAK. REPLACED WITH SERVICEABLE BATTERY PACK FOR PASSENGER SEAT EMERGENCY LIGHT.SDR AALA20090730TUL30Battery Pack · dischargedTUL - PASSENGER SEAT EMERGENCY LIGHT BATTERY PACK IS WEAK. REPLACED WITH SERVICEABLE BATTERY PACK FOR PASSENGER EMERGENCY LIGHT.SDR AALA200907240001ALens · missingCEILING EMERGENCY LIGHT ABOVE 7B MISSING LENS. REPLACED LENS FOR CEILING EMERGENCY LIGHT ABOVE 7B.SDR AALA20090724DFW02Ptu · inoperativeDFW - ON CLIMBOUT LEFT HYDRAULIC PRESS LOW AND LEFT HYDRAULIC TEMP HI LIGHTS ILLUMINATED. EMERGENCY DECLARED, LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND POWER TRANSFER UNIT INOPERATIVE. REPLACED POWER TRANSFER UNIT. SYSTEM GROUND CHESDR AALA20090724DFW03Ptu · failedDFW - ON CLIMBOUT AT 7000 FEET BOTH HYDRAULIC SYSTEMS INDICATED 1200 PSI. LEFT HYDRAULIC PRESS LOW AND LEFT HYDRAULIC HI LIGHTS ILLUMINATED. FOUND POWER TRANSFER UNIT HAD FAILED. REPLACED POWER TRANSFER UNIT. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20090730TUL31Battery Pack · dischargedTUL - PASSENGER SEAT EMERGENCY LIGHT BATTERY PACK AB5-1 IS WEAK. REPLACED WITH SERVICEABLE BATTERY PACK FOR PASSENGER SEAT EMERGENCY LIGHT.SDR AALA20090730TUL32Battery Pack · dischargedTUL - PASSENGER SEAT EMERGENCY LIGHT BATTERY PACK AB5-3 IS WEAK. REPLACED WITH SERVICEABLE BATTERY PACK FOR PASSENGER EMERGENCY LIGHT.SDR AALA20090723AUS01Detector · inoperativeAUS - RIGHT ENGINE WARNING INDICATION ILLUMINATED AFTER TAKEOFF. EMERGENCY DECLARED, RETURNED AUS WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED RIGHT ENGINE DETECTOR AMPLIFIER AND CAWS COMPUTER. SYSTEM GROUND CHECKED NORMAL OPERATIOSDR AALA20090724LGA02Placard · incorrectLGA - RIGHT OVERWING EXITS PLACARDS AT ROWS 20 AND 21 INCORRECT. REPLACED EMERGENCY EXITS PLACARDS AT ROWS 20 AND 21.SDR AALA20090724LGA01Placard · incorrectLGA - LEFT OVERWING PLACARDS AT ROWS 20 AND 21 INCORRECT. REPLACED EMERGENCY EXIT PLACARDS AT ROWS 20 AND 21.SDR AALA20090723TUL44Fitting · crackedTUL - AFT CABIN BULKHEAD DOOR LOWER DOOR BEAM LEFT SIDE BAYONET LATCH FITTING CRACKED. REMOVED CRACKED FITTING AND INSTALLED NEW LOWER BAYONET LATCH FITTING IN DOOR UNDER ESO-80186 E58-6375157 MRT-021974.SDR AALA20090723TUL04Door · crackedRIGHT MAIN LANDING GEAR BODY DOOR LOWER AFT END CRACKED. INSTALLED DOUBLER REPAIR PER 52-05-00.SDR AALA20090722LGA06Light · inoperativeCEILING EMERGENCY LIGHT BETWEEN AFT LAVATORIES INOPERATIVE. REPLACED LAMP FOR CEILING EMERGENCY LIGHT BETWEEN AFT LAVATORIES. OPS CHECK NORMAL.SDR AALA20090722LGA05Strap · missingFLASHLIGHT STRAP MISSING FROM FLASHLIGHT BY AFT GALLEY FLIGHT ATTENDANT SEAT. INSTALLED STRAP FOR FLASHLIGHT AT AFT GALLEY FLIGHT ATTENDANT SEAT.SDR AALA20090722LGA04Strap · missingFLASHLIGHT STRAP MISSING FROM FLASHLIGHT OUTSIDE RIGHT LAVATORY. INSTALLED STRAP FOR FLASHLIGHT AT RIGHT LAVATORY.SDR AALA20090722LGA03Strap · missingFLASHLIGHT STRAP MISSING FROM FLASHLIGHT BY AFT GALLEY FLIGHT ATTENDANT SEAT. REPLACED STRAP FOR FLASHLIGHT AT AFT GALLEY FLIGHT ATTENDANT SEAT.SDR AALA20090722LGA02Battery Pack · not seatedCEILING EMERGENCY LIGHTS INOPERATIVE FROM ROWS 23 TO ROW 29. RESEATED BATTERY PACK FOR CEILING EMERGENCY LIGHTS FROM ROWS 23 TO 29. OPS NORMAL.
Back to Mcdonnell Douglas DC-9-82