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 AALA20090911TUL08Rib · crackedHIGH FREQUENCY EDDY CURRENT INSPECTION INDICATES A CRACK AT OUTBOARD RIB ON RIGHT WING NUMBER 5 SLAT AT NUMBER 15 SLAT TRACK ATTACHMENT. INSTALLED NEW ATTACH FITTING PER ESO 80117.SDR AALA20090911TUL07Rib · crackedHIGH FREQUENCY EDDY CURRENT INSPECTION INDICATES A CRACK AT OUTBOARD RIB ON LEFT WING NUMBER 5 SLAT AT NUMBER 15 SLAT TRACK ATTACHMENT. REPLACED CRACKED OUTBOARD RIB AT NUMBER 15 TRACK ATTACHMENT POSITION PER ESO 80117.SDR AALA20090911MCI03Battery Pack · dischargedEMERGENCY CEILING LIGHTS AT STA 1200 INOPERATIVE. REPLACED BATTERY PACK B5-107. CHECKS GOOD.SDR AALA20090911MCI02Battery Pack · dischargedEMERGENCY CEILING LIGHTS AT SEAT ROW 14 INOPERATIVE. REPLACED BATTERY PACK B5-102. CHECKS GOOD.SDR AALA20090911MCI01Battery Pack · dischargedTAIL CONE AREA EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK B5-27.SDR AALA20090911TUL06Skin · scratchedFORWARD CARGO DOOR HAS SEVERAL SCRATCHES ON OUTER SKIN. INSTALLED DOUBLER REPAIRS PER ESO 80174.SDR AALA20090916TUL14Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK IN CABIN FAILED FUNCTIONAL TEST. REPLACED BATTERY PACK IN CABIN.SDR AALA20090911TUL03Battery Pack · dischargedEMERGENCY LIGHT IN AFT ACCESSORY WILL NOT TURN OFF WITH POWER REMOVED FROM AIRCRAFT. REPLACED BATTERY PACK.SDR AALA20090909TUL10Pan · crackedHIGH FREQUENCY EDDY CURRENT INSPECTION DETECTS CRACK IN PAN AT FORWARD LOWER STOP. DYE CHECKED AND STOP DRILLED CRACK, FABRICATED AND INSTALLED DOUBLER PER SRM 52-05-00 FIG 8-1.SDR AALA20090909DCA02Tire · blownNUMBER 2 MAIN LANDING GEAR TIRE BLEW ON LANDING. REPLACED NUMBER 1 & 2 MAIN TIRES, CHECKS NORMAL.SDR AALA20090911TUL01Battery Pack · dischargedOVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK FOR OVERWING EMERGENCY LIGHT.SDR AALA20090909LGA03Strap · brokenAFT FLASHLIGHT AT AFT JUMPSEAT HAS SECURITY STRAP BROKEN. INSTALLED NEW SECURITY STRAP.SDR AALA20090909LGA02Battery Pack · looseCENTER RIGHT CEILING EMERGENCY LIGHTS INOPERATIVE BETWEEN AFT LAVATORIES. RESEATED BATTERY PACK AT RIGHT LAVATORY. OPS CHECKS NORMAL.SDR AALA20090909LGA01Connector · looseSEAT MOUNTED EMERGENCY LIGHT INOP AT SEAT 10D. CONNECTED LOOSE PLUG AT SEAT 10D. OPS CHECKS NORMAL.SDR AALA20090906DFW01Generator · failedON TAKEOFF ELECTRICAL SYSTEM CYCLED ON AND OFF. AIRCRAFT WOULD NOT CROSS TIE. STARTED APU AND RETURNED TO DFW. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. REPLACED LEFT GENERATOR AND CONSTANT SPEED DRIVE, MPN 696233B.SDR AALA20090904DFW02Lens · missingSEAT 27D LENS AND GUARD MISSING. REPLACED SEAT 27D LENS AND GUARD LIGHT. OPS CHECK GOOD.SDR AALA20090908TUL02Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK FAILED OPERATIONAL CHECK. REPLACED BATTERY PACK.SDR AALA20090903LGA01Battery · looseAFT OVERWING EXIT EMERGENCY LIGHT SIGNS INOPERATIVE BOTH LEFT AND RIGHT SIDE. RESECURED EMERGENCY BATTERIES IN BATTERY PACK ROW 21. OPS CHECK OK.SDR AALA20090902TUL20Battery Pack · dischargedMID AISLE BATTERY PACK HAS LOW OUTPUT. REPLACED BATTERY PACK IN MID AISLE UNDER IAW 33-60-98-4.SDR AALA20090902TUL04Battery Pack · dischargedMID AISLE BATTERY PACK LOW OUTPUT. REPLACED BATTERY PACK IN MID AISLE UNDER MM 33-60-98-4.SDR AALA20090902TUL03Battery Pack · dischargedMID AISLE BATTERY PACK LOW OUTPUT. REPLACED BATTERY PACK AT MID AISLE UNDER IAW 33-60-98-4.SDR AALA20090902TUL02Battery Pack · dischargedMID AISLE BATTERY PACK LOW OUTPUT. REPLACED BATTERY PACK IAW MM 33-60-98-4.SDR AALA20090831DFW05Battery Pack · dischargedTHE CEILING EMERGENCY LIGHTS ROW 26 TO 30 ARE DIM. REPLACED BATTERY PACK B5-106. THE CEILING EMERGENCY LIGHTS ROW 26 TO 30. CHECK NORMAL.SDR AALA20090831DFW04Battery · out of positionTHE CEILING EMERGENCY LIGHTS ROW 3 TO 6 ARE DIM. REPOSITIONED THE BATTERIES IN THE RETAINER CLIP. THE CEILING EMERGENCY LIGHTS ROW 3 TO 6. OPS CHECK NORMAL.SDR AALA20090831DFW03Battery Pack · dischargedTHE CEILING EMERGENCY LIGHTS ROW 12 TO 18 ARE INOPERATIVE. REPLACED BATTERY PACK ASSEMBLY B5-102. THE CEILING EMERGENCY LIGHTS ROW 12 TO 18. OPS CHECK NORMAL.SDR AALA20090831DFW02Battery · out of positionTHE CEILING EMERGENCY LIGHTS ROW 12 TO 18 ARE INOPERATIVE. REPOSITIONED THE BATTERIES IN THE RETAINER CLIP. THE CEILING EMERGENCY LIGHTS ROW 3 TO 6. OPS CHECK NORMAL.SDR AALA20090831DFW01Light · brokenTHE EMER EXIT MARKER LIGHT ASSEMBLY FORWARD OF THE RIGHT NUMBER 1 SERVICE DOOR NEAR THE FLOOR IS BROKEN. REPLACED THE EMERGENCY EXIT MARKER LIGHT ASSEMBLY FORWARD OF THE RIGHT NUMBER 1 SERVICE DOOR NEAR THE FLOOR. OPS CHECKED NORMAL.SDR AALA20090830LGA05Battery Pack · dischargedFLOOR EXIT LIGHT ACROSS FORWARD LAVATORY INOPERATIVE. RECHARGED EMERGENCY LIGHTS BATTERY PACK PER MM, OPS CHECK GOOD.SDR AALA20090830LGA04Battery Pack · dischargedFORWARD HATCHES OVERWING LOWER FLOOR EXIT LIGHTS INOPERATIVE. RECHARGED EMERGENCY LIGHTS BATTERY PACK PER MM, OPS CHECK GOOD.SDR AALA20090830LGA03Battery Pack · dischargedFORWARD GALLEY FLOOR EXIT LIGHTS INOPERATIVE. RECHARGED EMERGENCY LIGHTS BATTERY PACK PER MM, OPS CHECK GOOD.SDR AALA20090830LGA02Battery Pack · not seatedAFT OVERWING HATCHES TOP EXIT LIGHTS INOPERATIVE. RESEATED BATTERY PACK AT BIN 20DEF AFT. AFT OVERHEAD EXIT SIGN OPS CHECKS GOOD.SDR AALA20090830LGA01Battery Pack · dischargedSEAT MOUNTED EMERGENCY ESCAPE PATH INOPERATIVE FROM ROW 3 TO ROW 19. RECHARGED EMERGENCY LIGHTS BATTERY PACK PER MM. OPS CHECK GOOD.SDR AALA20090902TUL18Battery Pack · dischargedEMERGENCY LIGHT BATTERY IS DEAD. REPLACED UNDER MM 33-60-98-4.SDR AALA20090902TUL17Battery Pack · dischargedDEAD BATTERY. REPLACED PER MM 33-60-98-4.SDR AALA20090902TUL16Battery Pack · activatedEMERGENCY LIGHT BATTERY PACK IS WEAK. REPLACED UNDER MM 33-60-98-4.SDR AALA20090902TUL15Module · defectiveEMERGENCY LIGHT BATTERY PACK MODULE INTERMITTENT. INSTALLED SERVICEABLE MODULE PER MM 33-60-98-4.SDR AALA20090902TUL11Portable Light · inoperativeEMERGENCY PORTABLE LIGHT AT EXTERNAL POWER CONTACTOR INOPERATIVE. REPLACED LIGHT, OPS CHECK GOOD.SDR AALA20090902TUL01Web · crackedAFT ACCESSORY WEB IS CRACKED AT TAIL CONE ALIGNMENT PIN, JUST ABOVE LOWER LEFT HAND TAIL CONE LATCH. REPAIRED UNDER SRM 51-70-05 FIGURE 1 SHEET 3.SDR AALA20090829LGA01Shield · missingTAMPER SHIELD MISSING FORWARD FLASHLIGHT AT AFT JUMPSEAT. REPLACED TAMPER SHIELD AT FORWARD FLASHLIGHT AFT JUMPSEAT.SDR AALA20090828TUL05Battery Pack · dischargedBATTERY PACK IN CABIN HAS LOW OUTPUT. INSTALLED SERVICEABLE BATTERY PACK.SDR AALA20090828TUL03Battery Pack · dischargedBATTERY PACK IN CABIN HAS WEAK OUTPUT. INSTALLED SERVICEABLE BATTERY PACK.SDR AALA20090828TUL02Battery Pack · dischargedBATTERY PACK IN CABIN HAS WEAK OUTPUT. INSTALLED SERVICEABLE BATTERY PACK.SDR AALA20090828MCO01Power Supply · dischargedFOUND GALLEY/COCKPIT AND FORWARD AISLE WHITE EMERGENCY LIGHTING INOPERATIVE DURING FUNCTIONAL CHECK. REPLACED BATTERY POWER SUPPLY IN FORWARD AISLE OF AIRCRAFT.SDR AALA20090828LGA01Battery · dischargedFORWARD OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY AND CHARGER AT POSITION B5-23. OPS CHECK NORMAL.SDR AALA20090827TUL01Vane · wornWORN AREA ON OUTBOARD FLAP VANE NEXT TO FLEX JOINT. INSTALLED HOT-BOND DOUBLER PER SRM-51-70-02.SDR AALA20090827LGA03Battery Pack · dischargedFORWARD FEED, FORWARD SECTION OF EMERGENCY PATH LIGHTS INOPERATIVE. REPLACED AB5-1 BATTERY PACK. FORWARD FEED NOW OK.SDR AALA20090827LGA02Battery Pack · dischargedEMERGENCY LIGHTS AFT OF ROW 20 INOPERATIVE. FOUND AB5-4 BATTERY PACK DEFECTIVE. REPLACED BATTERY PACK. EMERGENCY LIGHTS NOW GOOD.SDR AALA20090827LGA01Battery Pack · dischargedEMERGENCY LIGHTS AFT OF ROW 20 INOPERATIVE. FOUND AB5-3 BATTERY PACK DEFECTIVE. REPLACED BATTERY PACK. EMERGENCY LIGHTS NOW GOOD.SDR AALA20090826TUL09Vane · wornWORN AREA ON LEADING EDGE OF INBOARD FLAP VANE AT INBOARD AREA. INSTALLED HOT BOND DOUBLER UNDER SRM-51-70-02.SDR AALA20090826MCI01Link · failedINFLIGHT OMA TO DFW CREW REPORTED NOSE LANDING GEAR WOULD NOT RETRACT WITH VIBRATION AND BURNING RUBBER SMELL IN COCKPIT. AIRCRAFT LANDED MCI DUE TO WEATHER AND WITHOUT INCIDENT. REPLACED BOTH NOSE GEAR DOOR LINKS. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to Mcdonnell Douglas DC-9-82