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 AALA20130508037Transmitter · inoperativeLAX - INFLIGHT FAT-DFW. CREW REPORTED LEFT ENGINE COMPRESSOR STALL FOLLOWED BY SMOKE IN COCKPIT AND CABIN. EMERGENCY DECLARED FLIGHT DIVERTED LAX LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT ENGINE PRESSURATION TRANSMITTER. SYSTEMSDR AALA20130508006Controller · inoperativeABQ - CREW REPORTED UNABLE TO PRESSURIZE AIRCRAFT IN AUTO. EMERGENCY DECLARED FLIGHT RETURNED ABQ LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED BOTH PESSURE CONTROLLERS. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20130509006Connector · looseTAIL COMPARTMENT EMERGENCY LIGHTS INOPERATIVE. SECURED LOOSE CONNECTION ON BATTERY PACK B5-27 TERMINAL 5 FOR TAIL COMPARTMENT EMERGENCY LIGHTS. OPS CHECK NORMAL.SDR AALA20130509005Socket · dirtyCEILING CENTER EMERGENCY LIGHT JUST FORWARD OF AFT BULKHEAD DOOR INOPERATIVE. CLEANED LIGHT SOCKET CONTACT ON BASE. OPS CHECK NORMAL.SDR AALA20130509004Battery Pack · dischargedLEFT NUMBER 2 DOOR EMERGENCY EXIT SIGN INOPERATIVE. REPLACED BATTERY PACK AT B5-4 POSITION FOR LEFT NUMBER 2 DOOR EMERGENCY EXIT SIGN. OPS CHECK NORMAL.SDR AALA20130509003Battery Pack · dischargedAFT GALLEY CEILING EMERGENCY LIGHTS INOPERATIVE. SECURED LOOSE CONNECTION ON BATTERY PACK B5-107, TERMINAL 5. OPS CHECK NORMAL.SDR AALA20130508008Wire · damagedAFT AIRSTAIR SIDEWALL EMERGENCY LIGHTS INOPERATIVE. REPAIRED WIRE FOR AFT AIRSTAIR EMERGENCY LIGHTS.SDR AALA20130507029Portable Light · defectiveLEFT NUMBER ONE DOOR PORTABLE EMERGENCY LIGHT DIM. REPLACED LEFT NUMBER ONE PORTABLE EMERGEMCY LIGHT. OPS CHECK NORMA.LSDR AALA20130507023Connector · looseMEX - CREW REPORTED FIRST OFFICERS LOST AIR SPEED INDICATOR, ALTIMETER AND AUTO PILOT FAILED. EMERGENCY DECLARED FLIGHT RETURNED MEX LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND STATIC PORT QUICK DISCONNECT CONNECTOR LOOSE. RE-SECURED STATSDR AALA20130506020Frame · wornCOCKPIT TEMPERATURE CONTROL VALVE WEARING INTO FRAME 1380. INSTALLED DOUBLER PER AARD 53-10-00-28, FIGURE 28.SDR AALA20130506016Frame · crackedCANT 1510 IS CRACKED AT THE TAIL CONE ALIGNMENT PIN AT THE 7 O` CLOCK POSITION. INSTALLED DOUBLER PER EA MD80-53-029565.SDR AALA20130506012Frame · crackedCANT FRAME 1510 IS CRACKED AT THE TAIL CONE ALIGNMENT PIN JUST LEFT OF THE SLIDE TRAY. INSTALLED 1510 CANT FRAME PIN DOUBLER PER EA MD80-53-029565.SDR AALA20130506004Cusp Web · crackedLEFT CUSP CRACKED AT STATION 225. STOP DRILLED AND INSTALLED DOUBLER PER EA MD80-53-029678.SDR AALA20130506003Portable Light · damagedFOUND FORWARD PORTABLE EMERGENCY LIGHT LOOSE AND NOT SECURED. FOUND LIGHT ASSEMBLY DAMAGED. REPLACED FORWARD PORTABLE EMERGENCY LIGHT PACK. OPS CHECK NORMAL.SDR AALA20130501016Skin · dentedFUSELAGE DENT AT STATION 207 BETWEEN LONGERON 4 AND 5 LEFT WITH DEEP GOUGE. REMOVED DAMAGE SKIN PER 53-04-03 AND INSTALLED DOUBLER PER SRM 53-04-03 FIGURE 3 AND EA MD80-53-029559.SDR AALA20130501015Longeron · crackedLONGERON 4 LEFT IS CRACKED AT STATION 200. INSTALLED LONGERON SPLICE PER SRM 53-02-00 FIGURE 18.SDR AALA20130430003Battery · dirtyTAIL COMPARTMENT EMERGENCY LIGHTS ABOVE CATWALK INOPERATIVE. CLEANED BATTERIES IN CHARGER. OPS CHECK NORMAL.SDR AALA20130430002Battery · dirtyCEILING EMERGENCY LIGHTS FROM ROWS 7 TO 11 INOPERATIVE. CLEANED BATTERIES IN CHARGER. OPS CHECK NORMAL.SDR AALA20130430001Battery · dirtyCEILING EMERGENCY LIGHTS FROM ROWS 3 TO 6 INOPERATIVE. CLEANED BATTERIES IN CHARGER. OPS CHECK NORMALSDR AALA20130426001Frame · crackedCANT FRAME 1510 IS CRACKED AT THE TAIL CONE ALIGNMENT PIN AT 11 O` CLOCK POSITION. INSTALLED DOUBLER REPAIR PER SRM 53-01-00.SDR AALA20130426004Battery Pack · dischargedRIGHT AND CENTER CEILING EMERGENCY LIGHTS, BETWEEN AFT LAVATORIES INOPERATIVE. REPLACED BATTERY PACK AT AFT RIGHT LAVATORY CEILING ACCESS. OPS CHECK NORMAL.SDR AALA20130426003Battery Pack · dischargedLEFT AND RIGHT FORWARD OVERWING DOOR UPPER EXIT SIGNS INOPERATIVE. REPLACED BATTERY PACK IN OVERWING CEILING PANEL. OPS CHECK NORMAL.SDR AALA20130424010Doubler · corrodedCORROSION ON DOUBLER UNDER G2 GALLEY MOUNT AT STATION 218. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20130424009Cusp Web · corrodedCORROSION ON RIGHT CUSP AT STATION 560. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20130423013Structure · crackedCRACK IN VERTICAL STABILIZER, LEFT SIDE AT STATION 1410. STOP DRILLED CRACK AND INSTALLED DOUBLER PER SRM 55-01-00 FIGURE 2 SHEET 2.SDR AALA20130423006Longeron · crackedLONGERON 2 LEFT CRACKED AT STATION 160. CUT OUT SECTION OF LONGERON FROM STATIONS 150 TO 171 AND INSTALLED SPLICE REPAIR PER SRM 53-02, FIGURE 18.SDR AALA20130423004Battery Pack · dischargedTAIL COMPARTMENT EMERGENCY LIGHTS INOPERATIVE. REPLACED EMERGENCY LIGHT BATTERY PACK FOR TAIL COMPARTMENT EMERGENCY LIGHTS. OPS CHECK NORMAL.SDR AALA20130423003Portable Light · inoperativeLEFT NUMBER 1 DOOR PORTABLE EMERGENCY LIGHT INOPERATIVE. REPLACED LEFT NUMBER 1 DOOR PORTABLE EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20130422032Cusp Web · corrodedCORROSION ON LOWER SIDE OF RIGHT CUSP AT STATION 218 BELOW NUMBER 6 SEAT TRACK. REMOVED CORRODED CUSP AND INSTALLED NEW CUSP PER AARD 51-00-05-1.SDR AALA20130422002Battery Pack · not seatedTAIL COMPARTMENT EMERGENCY LIGHTS ABOVE CATWALK INOPERATIVE. RESEATED BATTERY PACK FOR TAIL COMPARTMENT EMERGENCY LIGHTS ABOVE CATWALK. OPS CHECK NORMAL.SDR AALA20130422001Battery Pack · not seatedCEILING EMERGENCY LIGHTS FROM ROWS 7 TO ROW 11 INOPERATIVE. RESEATED BATTERY PACK FOR CEILING EMERGENCY LIGHTS FROM ROWS 7 TO 11. OPS CHECK NORMAL.SDR AALA20130421001Pan · crackedFORWARD CARGO DOOR, NUMBER 1 BEAM FORWARD SIDE PAN CRACKED. STOP DRILLED PER ESO 80174 AND INSTALLED DOUBLER PER EA COMP-52-029331.SDR WX0A2013042271566Battery Pack · 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 POWER SUPPLY BATTERY PACK AND MADE ASDR AALA20130419018Skin · crackedLEFT SIDE FUSELAGE SKIN CRACKED AT STATION 1309 ABOVE LONGERON 7 LEFT. INSTALLED DOUBLER PER SRM 53-04-00 FIGURE 32.SDR AALA20130419017Cusp Web · damagedDAMAGE TO RIGHT CUSP AT STATION 237 BETWEEN STRINGERS 5 AND 6. INSTALLED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA20130419014Attach Angle · corrodedFORWARD DOOR JAMB LOWER ATTACH ANGLE HAS CORROSION STATION 1155. REMOVED AND REPLACED DOOR JAMB ANGLE PER SRM 51-30-05.SDR AALA20130419013Shear Tie · corrodedCORROSION ON SHEAR TIE AT STATION 1287 BETWEEN LONGERONS 30 TO 29. INSTALLED FORMER REPAIR SPLICE DOUBLERS PER SRM 53-03-00.SDR AALA20130419010Skin · crackedRIGHT SIDE OF FUSELAGE SKIN CRACKED AT STATION 1309 ABOVE LONGERON 7 RIGHT. INSTALLED REPAIR DOUBLER SRM 53-04-00 FIGURE 32.SDR AALA20130419003Skin · crackedCRACK IN SKIN AT STATION 1309 BETWEEN LONGERONS 6 AND 7 LEFT. STOP DRILLED CRACKS AND INSTALLED EXTERNAL DOUBLER PER SRM 53-04-00 FIGURE 32 AND SUPPORTING EA 53 029420.SDR AALA20130419006Skin · crackedCRACK IN FUSELAGE TAIL SECTION LEFT SIDE AT STATION 1477. INSTALLED DOUBLER PER AARD 53-30-00-4 AND SRM 53-01-00.SDR AALA20130418009Cusp Web · crackedFASTENER HOLE CRACKED IN CUSP AT STATION 187, RIGHT BUTTLINE 63. INSTALLED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA20130418006Stiffener · crackedCRACK IN VERTICAL SUPPORT AT STATION 1338 BELOW LONGERON 1 LEFT. REPLACED VERTICLE STIFFENER PER AARD 51-00-05-1.SDR AALA20130417018Cusp Web · crackedRIGHT CUSP IS CRACKED AT STATION 1022. INSTALLED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA20130416014Cusp Web · crackedRIGHT CUSP SHEET IS CRACKED UNDER SEAT TRACK SPLICE AT STATION 800. REPALCED CUSP SHEET PER AARD 51-00-05-1.SDR AALA20130416012Pan · crackedFORWARD CARGO DOOR, NUMBER 1 BEAM FORWARD SIDE PAN CRACKED. ACCOMPLISHED NESTED ANGLE REPAIR PER EA COMP-52-029331 AND ESO 80174 PAGE 601B BASED ON SRM 52-03-00 FIGURE 8 WITH SOME EXCEPTIONS.SDR AALA20130416010Door Frame · crackedDOOR FRAME WEB CRACKED AT SCREW GOUGE, STATION 634, LONGERON 27 RIGHT. INSTALLED DOUBLER PER AARD 53-10-00-24 FIGURE 1 (SHEET 3).SDR AALA20130415003Membrane · corrodedCORROSION ON SUB-FLOOR UNDER G-1 GALLEY DRAIN PAN. INSTALLED SUB-FLOOR DOUBLER UNDER G1 GALLEY PAN PER AARD 53-20-00-16.SDR AALA20130414002Light · inoperativeEMERGENCY LIGHTS NOT ARMED ON ANNUNCIATOR PANEL LAMPS INOPERATIVE. REPLACED LAMPS FOR "EMERGENCY LIGHTS NOT ARMED" ON ANNUNCIATOR PANEL. OPS CHECK NORMAL.SDR AALA20130412018Cusp Web · corrodedRIGHT CUSP AT STATION 494 CORRODED. CUT OUT DAMAGED AREA AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20130412016Frame · wornFRAME 1380 HAS WEAR ON FORWARD SIDE, CONTACT WITH TEMPERATURE CONTROL VALVE, LEFT. CUT OUT DAMAGE AND INSTALLED DOUBLER PER AARD 53-10-00-28.
Back to Mcdonnell Douglas DC-9-82