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 AALA20130216004Pump · inoperativeMSY - INFLIGHT MCO-DFW. CREW REPORTED CENTER TANK FUEL WILL NOT FEED. FLIGHT DIVERTED MSY LANDED WITHOUT INCIDENT. REPLACED CENTER TANK FUEL BOOST PUMP. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20130215008Frame · cracked1474 CANT FRAME CRACKED AFT OF LONGERON 18 LEFT. INSTALLED DOUBLER PER AARD 53-10-00-15.SDR AALA20130215007Shear Tie · crackedSHEAR TIE CRACKED AFT SIDE OF STATION 1451 AFT OF LONGERON 2 RIGHT. INSTALLED REPLACEMENT SHEAR TIE PER AARD 51-00-05-1.SDR AALA20130214012Oven · overheatedIAD - INFLIGHT DCA-DFW. CREW REPORTED FIRST CLASS GALLEY OVEN OVERHEATED CAUSING SMOKE IN CABIN. EMERGENCY DECLARED FLIGHT DIVERTED IAD LANDED WITHOUT INCIDENT. PLACARD FIRST CLASS GALLEY OVEN PER MEL. FLIGHT CONTINUED TO DESTINATION. REPLACED FORWARD GASDR AALA20130212009Shutoff Valve · damagedDEN - CREW REPORTED RIGHT HYDRAULIC FLUID LOSS DURING CRUISE. EMERGENCY DECLARED FLIGHT LANDED DEN WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RUDDER SHUT OFF VALVE. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20130212013Structure · tornLEFT SIDE OF RUDDER AT LOWER DAMPENER ATTACH HINGE HAS COMPOSITE TEAR. PERFORMED A SMALL RE-METALLIZING REPAIR AT REPAIR SITE PER AARD 55-40-00-2.SDR AALA20130211005Rib · crackedRIGHT NUMBER 4 SLAT OUTBOARD LEADING EDGE RIB CRACKED. REMOVED AND REPLACED OUTBOARD RIB (ATTACH FITTING) PER ESO 80117.SDR AALA20130211002Charger · inoperativeOVERHEAD EMERGENCY LIGHTS AT ROWS 8, 9 AND 10 WILL NOT TEST. REPLACED MID EMERGENCY LIGHT CHARGER. OPS CHECK NORMAL.SDR AALA20130210005Bracket · crackedBRACKET CRACKED AT STATION 886 BELOW SEAT TRACK NUMBER 3. REMOVED AND INSTALLED SERVICEABLE BRACKET SUPPORT BELOW SEAT TRACK NUMBER 3 AT STARION 886 PER AARD 51-00-05-1 AND SRM 51-30-05.SDR AALA20130210004Membrane · corrodedCORROSION ON SUB-FLOOR UNDER G-1 GALLEY DRAIN PAN. INSTALLED NEW DOUBLER ON SUB-FLOOR UNDER G-1 GALLEY PAN PER AARD 53-20-00-16.SDR AALA20130209006Skin · dentedDENT IN CROWN SKIN ABOVE FIRST OFFICER WINDOW FROM GEESE STRIKE. DAMAGED MATERIAL REMOVED, DOUBLER AND TRIPLER INSTALLED PER EA MD 80-53-028269. DAMAGED PORTION OF FRAME REMOVED, DOUBLER AND FILLER INSTALLED PER MD 80-53-028268.SDR AALA20130220022Skin · damagedMID CARGO DOOR, ABOVE NUMBER 5 BEAM ON OUTER SKIN HAS SEVERAL LIGHTNING STRIKES. INSTALLED NEW OUTER SKIN ON MID CARGO DOOR PER ESO 80174.SDR AALA20130209001Pin · corrodedPHX - CREW REPORTED NO GREEN LIGHT INDICATION WHEN GEAR WAS EXTENDED. CREW PERFORMED GO-AROUND, RECYCLED GEAR AND RECEIVED ALL THREE GREEN DOWN AND LOCK. EMERGENCY DECLARED FLIGHT LANDED PHX WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED PIN IN SDR AALA20130208045Bracket · crackedCENTER WING BRACKET IS CRACKED AT STATION 927 BELOW SEAT TRACK 5. INSTALLED NEW SUPPORT BRACKET PER AARD 51-00-05-1.SDR AALA20130208044Bracket · crackedCENTER WING BRACKET IS CRACKED AT STATION 927 BELOW SEAT TRACK 2. INSTALLED SUPPORT PER AARD 51-00-05-1 AND BOEING INSTALLATION DRAWING 9936637-1.SDR AALA20130208043Pan · crackedRIGHT WINDOW AT STATION 816, WINDOW RING PAN HAS CRACK AT BOTTOM FORWARD RADIUS. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20130207028Pan · crackedRIGHT WINDOW AT STATION 1183, WINDOW RING PAN HAS CRACK IN PAN BY UPPER AFT FASTENER. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20130207027Pan · crackedRIGHT WINDOW AT STATION 1050, WINDOW RING PAN HAS CRACK IN PAN BY UPPER AFT FASTENER. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20130207026Pan · crackedRIGHT WINDOW AT STATION 740, WINDOW RING PAN HAS CRACK IN PAN BY UPPER AFT FASTENER. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20130207025Pan · crackedRIGHT WINDOW AT STATION 816, WINDOW RING PAN HAS CRACK AT BOTTOM FORWARD RADIUS. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20130207023Pan · crackedLEFT WINDOW AT STATION 956, WINDOW RING PAN HAS CRACK IN UPPER AFT RADIUS. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20130207022Pan · crackedRIGHT WINDOW AT STATION 607, WINDOW RING PAN HAS CRACK IN BOTTOM FORWARD RADIUS. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20130305001Spar Cap · crackedCRACK ON THE AFT SIDE OF THE LEFT WING REAR SPAR LOWER CAP AT STATION XRS 164 LEFT. WING LOWER SPAR SPLICE REPAIR COMPLETED PER BOEING DRAWING J060165 AND EA MD80-57-028642.SDR WX0A071514Floorbeam · corrodedCORROSION NOTED ON FLOORBEAM AT STATION 237. REMOVED CORRODED AREAS, FABRICATED FILLERS AND REPAIR ANGLE AND INSTALLED.SDR AALA20130203004Generator · malfunctionedDFW - CREW REPORTED EXPERIENCED AC POWER INTERRUPTIONS AND RIGHT CONSTANT SPEED DRIVE OIL PRESSURE LOW LIGHT ILLUMINATED. TRIED TO DISCONNECT RIGHT CSD AND COULD NOT DISCONNECT. FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOSDR AALA20130204001Battery Pack · not seatedEMERGENCY LIGHTS FROM ROWS 24 TO 26 DO NOT TEST. RESEATED AFT BATTERY PACK. OPS CHECK NORMAL.SDR AALA20130202007Coupler · out of positionPVR - CREW REPORTED TAIL COMPARTMENT OVERHEAT WARNING. EMERGENCY DECLARED FLIGHT RETURNED PVR LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPOSITIONED LEFT PRIMARY HEAT EXCHANGER INLET DUCT SLIDING PNEUMATIC COUPLER. SYSTEM GROUND CHECK NORMAL OSDR AALA20130130022Battery Pack · out of positionCEILING EMERGENCY LIGHTS FROM ROWS 12 TO 16 INOPERATIVE. REPOSITIONED BATTERY PACK FOR CEILING EMERGENCY LIGHTS FROM ROWS 12 TO 16. OPS CHECK NORMAL.SDR AALA20130130008Lens · missingSEAT 7D ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 7D ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130130003Light · inoperativeSTANDBY EMERGENCY LIGHTS IN FORWARD GALLEY INOPERATIVE. REPLACED LAMP FOR STANDBY EMERGENCY LIGHTS IN FORWARD GALLEY. OPS CHECK NORMAL.SDR AALA20130130002Light · missingSEAT 7D ESCAPE PATH LIGHT MISSING LAMP. REPLACED LAMP FOR SEAT 7D ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130130001Portable Light · inoperativeLEFT NUMBER 1 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED PORTABLE EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20130129019Battery Pack · not seatedRIGHT CENTER EMERGENCY LIGHTS BETWEEN AFT LAVATORIES INOPERATIVE. RESEATED BATTERY PACK. OPS CHECK NORMAL.SDR AALA20130129018Battery Pack · not seatedTAIL COMPARTMENT EMERGENCY LIGHTS INOPERATIVE. RESEATED BATTERY PACK. OPS CHECK NORMAL.SDR AALA20130124004Battery · malfunctionedCEILING EMERGENCY LIGHTS FROM ROWS 28 TO 30 INOPERATIVE. RESET BATTERY TRAY AT OVERHEAD BIN 29D. OPS CHECKS NORMAL.SDR AALA20130124001Battery · not seatedCEILING EMERGENCY LIGHTS FROM ROWS 28 TO 30 INOPERATIVE. RESEATED BATTERY TRAY AT OVERHEAD 29E. OPS CHECK NORMAL.SDR AALA20130123014Duct · brokenDFW - CREW REPORTED "TAIL COMPT TEMP HI LIGHT" ILLUMINATED ON CLIMBOUT. FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED DUCT THAT WAS BROKEN. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20130123006Shear Tie · damagedTWO DOUBLE DRILLED HOLES IN SHEAR TIE, STATION 886, JUST ABOVE LONGERON 9 LEFT. INSTALLED FORMER REPAIR AND SPLICE DOUBLER PER SRM 53-03-00.SDR AALA20130122005Cusp Web · damagedRIGHT CUSP IS DAMAGED AT THE OUTBOARD EDGE BEHIND THE WIRE BUNDLE ATTACH CLIP AT STATION 574. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20130122004Longeron · crackedLONGERON CRACKED AT ATTACHMENTS TO FRAME, STATION 160 AND LONGERON 4 LEFT. INSTALLED SPLICE REPAIR PER SRM 53-02-00 FIGURE 18.SDR AALA20130122003Cusp Web · corrodedCORROSION ON CUSP UNDER FIBERGLASS HAT CHANNEL AT STATION 187, INBOARD OF FORWARD SERVICE DOOR. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20130122002Cusp Web · corrodedCORROSION ON LEFT CUSP, OUTBOARD OF SEAT TRACK NUMBER 1, APPROXIMATE STATION 565. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20130119006Portable Light · inoperativePORTABLE EMERGENCY LIGHT BY LEFT NUMBER 1 DOOR INOPERATIVE. REPLACED PORTABLE EMERGENCY LIGHT ASSMEBLY BY LEFT NUMBER 1 DOOR. OPS CHECK NORMAL.SDR AALA20130117007Actuator · malfunctionedDFW - CREW REPORTED SHARP TUG TO THE LEFT ON TAKEOFF. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED BOTH NOSE TIRES AND LUBRICATED SALAD BOWL AND NOSE STEARING ACTUATOR. SYSTEM GROUND CHECK NORMAL OSDR AALA20130116013Frame · crackedRIGHT STATION 886 FRAME HAS CRACK IN RADIUS AT 0 WATERLINE INBOARD SIDE OF FRAME. INSTALLED NEW BELLFRAME AT STATION 886 PER MCM CARD 5974, FAA-AD 2008-13-29 AND BOEING DRAWING SR09530282.SDR AALA20130116003Battery Pack · dischargedTAIL COMPARTMENT EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR TAIL COMPARTMENT EMERGENCY LIGHTS. OPS CHECK NORMAL.SDR AALA20130116002Battery · not seatedCEILING EMERGENCY LIGHTS FROM ROWS 7 TO 11 INOPERATIVE. RESEATED BATTERY FOR CEILING EMERGENCY LIGHTS FROM ROWS 7 TO 11. OPS CHECK NORMAL.SDR AALA20130115011Longeron · corrodedLONGERON 23 RIGHT AT STATION 1295 CORRODED ON OUTBOARD SIDE INSIDE CHANNEL. REMOVED AND REPLACED CORRODED SECTION OF LONGERON 23 RIGHT PER SRM 53-02-00 FIGURE 18.SDR AALA20130112009Clamp · looseFAT CREW REPORTED TAIL COMPARTMENT TEMPERATURE HIGH LIGHT ILLUMINATED DURING CLIMBOUT. EMERGENCY DECLARED FLIGHT RETURNED FAT LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. RETORQUED V DUCT CLAMP AND REPLACED BOTH AFT COMPARTMENT TEMP HIGH SENSORS.SDR AALA20130114004Skin · damagedDENT TO LEADING EDGE OF SLAT NUMBER 1, 33 INCHES FROM INBOARD END. REMOVED LOWER SKIN AND REWORKED DENTED AREA TO BE WITHIN LIMITS, DYE CHECKED REWORKED AREA NO CRACKS FOUND PER ESO 80117 AND SRM 57-03 FIGURE 18.
Back to Mcdonnell Douglas DC-9-82