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 AALA20090402TUL02Fitting · corrodedCORROSION ON GALLEY TIE DOWN FITTING AT STATION 208, 12 INCHES INBOARD OF NR 4 SEAT TRACK. REMOVED AND REPLACED FITTING PER SRM 51-01.SDR AALA2009031400593Battery Pack · dischargedLGA - AFT RIGHT OVERWING HATCH BOTTOM EXIT LIGHT INOPERATIVE. REPLACED BATTERY PACK FOR LIGHT AT AFT RIGHT OVERWING HATCH BOTTOM EXIT.SDR AALA2009031400592Battery Pack · dischargedLGA FORWARD LEFT HAND OVERWING HATCH BOTTOM EXIT LIGHT INOPERATIVE. REPLACED BATTERY PACK FOR LIGHT AT FORWARD LEFT HAND OVERWING HATCH BOTTOM EXIT.SDR AALA2009031400591Battery Pack · dischargedLGA - FORWARD CABIN EXIT EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FORWARD CABIN EXIT.SDR AALA2009031300002Tube · rupturedMCO - CREW REPORTED NUMBER 2 ENGINE BLEED LIGHT AND FULL FIRE WARNING INDICATION CAME ON. EMERGENCY DECLARED, RETURNED MCO WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND ANTI-ICING TUBE RUPTURED. REPLACED TUBE ASSEMBLY. SYSTEM GROUND CHECK NORMAL SDR AALA20090402TUL18Casting · crackedLEFT WING GROUND SPOILER ACTUATOR CASTING CRACKED IN RADIUS ABOVE FORWARD END OF ACTUATOR, INBOARD SIDE. INSTALLED NEW SPOILER CASTING PER SRM 51-30.SDR AALA20090402TUL17Cusp Web · corrodedRIGHT CUSP CORRODED AT STATION 602. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090402TUL12Cusp Web · crackedRIGHT CUSP CRACKED AT STATION 992. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090402TUL11Cusp Web · crackedRIGHT CUSP CRACKED AT STATION 1264. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA2009031300589Lamp · burned outLGA - FORWARD GALLEY CEILING EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT FORWARD GALLEY CEILING.SDR AALA2009031300588Wire · damagedLGA - LOWER AFT STAIR EMERGENCY EXIT STRIP LIGHT INOPERATIVE. REPAIRED AND SECURED WIRE AT AFT STAIR EMERGENCY EXIT STRIP LIGHT.SDR AALA2009031300586Battery Pack · dischargedMSP - AFT ZONE SEAT MOUNTED EMERGENCY LIGHTS ALL INOPERATIVE. REPLACED AFT ZONE BATTERY PACKS.SDR AALA2009031300585Shroud · brokenMSP SEAT MOUNTED EMERGENCY LIGHT SHROUD AT SEAT 30D INOPERATIVE. REPLACED SEAT MOUNTED EMERGENCY LIGHT SHROUD ST SEAT 30D.SDR AALA2009031200002Hydraulic System · contaminatedOKC - INFLIGHT FAT-DFW. CREW REPORTED A RIGHT HYDRAULIC SYSTEM LOSS. EMERGENCY DECLARED, LANDED OKC WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. INSPECTED AIRCRAFT FOR POSSIBLE LEAKS, NO INDICATION OF LEAK. BLED AIR FROM LEFT AND RIGHT RESERVOIRS AND SDR AALA20090403TUL09Stop Fitting · crackedAFT CARGO DOOR UPPER FORWARD STOP PAD FITTING CRACKED. REMOVED AND REPLACED STOP PAD FITTING PER ESO 80174.SDR AALA20090402TUL16Skin · damagedDENT IN FUSELAGE LEFT SIDE STATION 237, LONGERON 17L TO 18L. INSTALLED DOUBLER PER SRM 53-04 FIGURE 12B.SDR AALA20090316TUL03Pan · corrodedFORWARD CARGO DOOR THRESHOLD PAN IS CORRODED. REPAIRED PER SRM 53-05-00.SDR AALA20090313TUL05Fitting · corrodedLEFT CARGO TIE DOWN TRACK FITTING CORRODED AT STATION 1271. INSTALLED NEW TIE DOWN FITTING PER SRM 51-30-05.SDR AALA20090313TUL04Fitting · corrodedRIGHT TIE DOWN TRACK FITTING CORRODED AT STATION 271. INSTALLED NEW CARGO TIE DOWN TRACK FITTING PER SRM 51-30-05.SDR AALA20090312TUL01Battery Pack · dischargedMIDDLE AISLE BATTERY PACK FOR EMERGENCY LIGHTS HAS LOW OUTPUT. REMOVED AND REPLACED BATTERY PACK PER M/M 33-60-98-4.SDR AALA2009031200584Light · inoperativeLGA AFT CATWALK EMERGENCY LIGHT ABOVE TAILCONE SLIDE INOPERATIVE. REPLACED LAMP AT AFT CATWALK EMERGENCY LIGHT ABOVE TAILCONE SLIDE.SDR AALA20090402TUL13Skate Angle · crackedRIGHT SKATE ANGLE CRACKED. INSTALLED DOUBLER AND FILLER PER AARD 53-10-00-2.SDR AALA20090402TUL10Door Frame · crackedFORWARD ENTRY DOOR CUTOUT AFT FRAME WEB TANG IS CRACKED AT LONGERON 11L STATION 208. REPLACED WEB TANG DOUBLER PER AARD 53-10-00-11.SDR AALA20090402TUL09Pan · crackedTOP AFT FLANGE CRACKED ON LEFT WINDOW PAN AT STATION 1079. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20090402TUL08Pan · crackedFORWARD UPPER FLANGE ON LEFT WINDOW PAN CRACKED AT STATION 1212. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20090316TUL02Cusp Web · corrodedCORROSION ON RIGHT CUSP AREA LOWER SURFACE AFT OF STATION 160. REPAIRED CUSP PER EA MD80-53-005680.SDR AALA20090316TUL01Structure · corrodedCORROSION UNDER THE G1 GALLEY DRAIN PAN SUBFLOOR. INSTALLED DOUBLER UNDER G1 GALLEY DRAIN PAN SUBFLOOR PER AARD 53-20-00-16.SDR AALA20090312TUL03Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK INOPERATIVE. REMOVED AND REPLACED BATTERY PACK PER 33-50-00-12.SDR AALA20090312TUL02Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK INOPERATIVE. REMOVED AND REPLACED BATTERY PACK PER 33-50-00-12.SDR AALA2009031100577Battery Pack · dischargedLGA - FIRST CLASS EXIT LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR FIRST CLASS EXIT LIGHTS.SDR AALA2009031100576Battery Pack · dischargedLGA - EXIT LIGHTS AT AFT SECTION DIM. REPLACED BATTERY PACK FOR EXIT LIGHTS AT AFT SECTION.SDR AALA2009031100575Battery Pack · dischargedLGA - EXIT LIGHTS AT AFT SECTION INOPERATIVE. REPLACED BATTERY PACK FOR EXIT LIGHTS AT AFT SECTION.SDR AALA2009031100574Battery Pack · dischargedLGA - OVERWING EXIT SIGN INOPERATIVE. REPLACED BATTERY PACK FOR OVERWING EXIT SIGN.SDR AALA20090402TUL07Pan · crackedFORWARD UPPER TANG CRACKED ON LEFT WINDOW PAN AT STATION 1098. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20090317TUL11Skin · damagedKNIFE EDGE FASTENER HOLES COMMON TO THE RIGHT SKIN, STATION 1338, LONGERON 12R-14R. REPAIRED FASTENER HOLES IN ACCORDANCE WITH EA MD80-53-005666 DATED 03/06/09.SDR AALA2009031000570Battery Pack · not seatedLGA - EMERGENCY LIGHT AT CEILING LEFT SIDE JUST FORWARD OF LAVATORY INOPERATIVE. RESEATED EMERGENCY LIGHT BATTERY FOR EMERGENCY LIGHT AT CEILING LEFT SIDE JUST FORWARD OF LAVATORY.SDR AALA2009030900004Engine · failedAUS - DURING CLIMBOUT RIGHT ENGINE FAILED. SINGLE ENGINE TIME UNKNOWN. EMERGENCY DECLARED, RETURNED AUS WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NUMBER 2 ENGINE ON MARCH 9, 2009 AT AUS. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20090309TUL02Battery Pack · dischargedAFT AISLE BATTERY PACK HAS VERY LOW OUTPUT. INSTALLED SERVICEABLE BATTERY PACK PER 33-50-00-12D.SDR AALA20090309TUL01Longeron · damagedFASTENER HOLES KNIFE EDGED IN LONGERON 10L AT STATION 1338. INSTALLED FREEZE PLUGS PER EA MD80-53-005667.SDR AALA2009030700559Battery Pack · dischargedLGA - EMERGENCY LIGHTS JUST FORWARD OF AFT GALLEY AREA INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT AFT GALLEY AREA.SDR AALA20090313TUL08Angle · corrodedAFT CARGO DOOR JAMB LOWER CHORD ANGLE CORRODED AT STATION 1170. REMOVED CORROSION, INSTALLED REPAIR DOUBLER OVER CONDITION 4 AREA PER AARD 53-10-00-3.SDR AALA20090313TUL07Frame · crackedFOUR (4) CANT FRAME AT STATION 1480 REPAIR DOUBLER HAS TWO CRACKS. REMOVED CRACKED REPAIR DOUBLER AND INSTALLED INTERIM REPAIR DOUBLER PER ONE TIME ESO 80559 DATED 3/6/09.SDR AALA20090309TUL05Intercostal · crackedINTERCOSTAL CRACKED ABOVE RIGHT MAIN LANDING GEAR DOOR ACTUATOR. STOP DRILLED AND INSTALLED DOUBLER PER EA MD80-53-005651.SDR AALA20090309TUL04Battery Pack · dischargedOVERWING EMERGENCY LIGHTS DO NOT COME ON. INSTALLED SERVICEABLE BATTERY PACK PER M/M 33-53-00-4, OPERATIONAL CHECK GOOD.SDR AALA20090626TUL07Casting · crackedLEFT WING GROUND SPOILER CASTING CRACKED AT INBOARD LEG. REMOVED AND REPLACED LEFT WING GROUND SPOILER CASTING PER 51-01-00.SDR AALA20090318TUL18Beam · corrodedAFT CARGO DOOR BEAM IS CORRODED ON VERTICAL LEG FROM STATION 1155-1211. INSTALLED DOOR BEAM DOUBLER PER AARD 53-10-00-3.SDR AALA20090309TUL12Shear Tie · crackedSHEAR TIE CRACKED AFT SIDE OF 1431 FRAME LONGERON 2L. REPLACED SHEAR TIE PER SRM 51-01-00.SDR AALA20090309TUL06Skin · gougedGOUGE IN FUSELAGE SKIN AT STATION 1486 CANT, 16 INCHES UP FROM AFT AIRSTAIRS DOOR CUTOUT. INSTALLED DOUBLER PER SRM 53-01-00 FIGURE 25.SDR AALA2009030500551Battery Pack · dischargedLGA - AFT CABIN EXIT LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR AFT CABIN EXIT LIGHTS.SDR AALA2009030500550Battery Pack · dischargedLGA - AFT CABIN EXIT LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR AFT CABIN EXIT LIGHTS.
Back to Mcdonnell Douglas DC-9-82