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 AALA20120120TUL35Skin · damagedDURING PUSHBACK AIRCRAFT WAS DAMAGED OCCURED TO LEFT FUSELAGE, AFT OF LEFT NUMBER 1 DOOR AT STATION 207, LONGERON 23 LEFT. REPLACED LONGERON PER SRM 53-04 FIGURE 12C AND PRELIMINARY EA3.SDR AALA20120120TUL34Longeron · corrodedAFT CARGO HAS CORROSION ON LONGERON 29 LEFT BETWEEN STATIONS 1287 TO 1309. REMOVED DAMAGED SECTION OF LONGERON AND SPLICED IN NEW LONGERON SECTION FROM STATIONS 1280 TO 1300 PER SRM 53-02-00.SDR AALA20120120TUL31Shear Tie · corrodedAFT CARGO HAS CORROSION ON SHEAR TIE STATION 1287 BETWEEN LONGERON 28 RIGHT 28 LEFT. INSTALLED NEW SHEAR TIE PER SRM 51-10-00-5, 53-03-00 FIGURE 3, SHEET 1 AND DRAWINGS #9957739, AND EDK2742 REVISION A.SDR AALA20120120TUL15Wedge · damagedRIGHT INBOARD FLAP WEDGE HAS DAMAGE TO TOP INBOARD AND OUTBOARD EDGES. REPAIRED FLAP WEDGE PER SRM 51-70-06, AARD 51-00-00-014 AND EA MD80-57-021341.SDR AALA20120120TUL08Cusp Web · damagedRIGHT CUSP HAS DAMAGE AT STATIONS 1172 AND 1174. INSTALLED CUSP DOUBLER PER AARD 53-20-00-16.SDR AALA20120120TUL02Seat Track · corrodedCORROSION ON SEAT TRACK NUMBER 5 BETWEEN STATIONS 200 AND 246. ACCOMPLISHED SPLICE REPAIR PER SRM 53-05-00 FIGURE 4F.SDR AALA20120120TUL01Intercostal · crackedAFT CARGO HAD A CRACKED INTERCOSTAL BETWEEN STATIONS 1287 TO 1309. INTERCOSTAL REPLACED AARD 51-10-00-5.SDR AALA20120120LGA01Battery Pack · not seatedTAIL COMPARTMENT EMERGENCY LIGHTS ABOVE CATWALK INOPERATIVE. RESEATED AFT BATTERY PACK. OPS CHECK NORMAL.SDR AALA20120119DFW01Duct · leakingDFW - CREW REPORTED THE MASTER WARNING LIGHT AND TAIL COMPARTMENT TEMP HIGH LIGHT CAME ON INTERMITTENTLY FOR 3 OR 4 CYCLES. RAN QRH CHECKLIST AND LIGHT WENT OUT AFTER 30 SECONDS AND STAYED OFF FOR REMAINDER OF FLIGHT. EMERGENCY DECLARED FLIGHT RETURNED DFW LSDR AALA20120119TUL13Web · corrodedCORROSION ON AFT DOORWAY WEB, STATION 1213 ABOVE LONGERON 26 RIGHT. BLENDED AND REMOVED CORROSION PER SRM 51-10-03. CUT OUT SECTION OF WEB AND SPLICED IN A NEW SECTION PER AARD 53-10-00-24.SDR AALA20120119TUL12Intercostal · corrodedCORROSION ON FORWARD SIDE OF INTERCOSTAL STATION 1183 LONGERONS 28 TO 29 RIGHT. INSTALLED NEW INTERCOSTAL AT STATION 1183 LONGERONS 28 TO 29 RIGHT (AFT CARGO).SDR AALA20120119TUL09Intercostal · crackedAFT CARGO HAS A CRACK IN INTERCOSTAL BETWEEN CEILING BEAMS BETWEEN STATIONS 1271 TO 1287. INSTALLED INTERCOSTAL IN AFT CARGO BETWEEN CEILING BEAMS STATIONS 1271 TO 1287 PER AARD 51-10-00-5.SDR AALA20120126TUL03Skin · damagedFORWARD CARGO DOOR HAS DENT WITH GOUGES, BETWEEN NUMBER 2 AND 3 BEAMS. REMOVED AND REPLACED OUTER DOOR SKIN PER ESO 80174.SDR AALA20120118TUL22Cusp Web · corrodedCORROSION UNDER AFT GIRT BAR BRACKET ON CUSP AT STATION 1170 LEFT. INSTALLED DOUBLER LEFT SIDE STATION 1170 PER AARD 53-20-00-16 AND SRM 51-30-05.SDR AALA20120118TUL21Seat Track · corrodedSEAT TRACK NUMBER 5 FROM STATIONS 200 TO 246 CORRODED. INSTALLED NUMBER 5 SEAT TRACK SECTION FROM STATIONS 200 TO 248 RIGHT PER SRM 51-30-01, SRM 51-30-05 AND SRM 53-05-00 FIGURE 4F SHEET 1.SDR AALA20120118TUL20Intercostal · crackedAFT CARGO HAS A CRACK IN INTERCOSTAL BETWEEN CEILING BEAMS FROM STATIONS 1287 TO 1309. INSTALLED INTERCOSTAL IN AFT CARGO BETWEEN CEILING BEAMS FROM STATIONS 1287 TO 1309 PER AARD 51-10-00-5.SDR AALA20120201TUL01Skin · damagedMID CARGO DOOR, OUTER SKIN DENTS BETWEEN NUMBERS 4 AND 5 BEAMS. INSTALLED DOUBLER REPAIR PER SRM 53-04-02 FIGURE 2.SDR AALA20120121TUL02Skin · dentedEXTERIOR SKIN CENTER AT FORWARD CARGO DOOR DENTED AND GOUGED. REMOVED DAMAGE AND DYE CHECKED AREA WITH NO CRACKS FOUND PER ESO 80174. INSTALLED REPAIR DOUBLER AND FILLER PER ESO 80174 AND SRM 52-05-00.SDR AALA20120117TUL08Frame · crackedTHE 1418 FRAME CRACKED AT LONGERON 2 LEFT. INSTALLED REPAIR DOUBLERS PER SRM 53-03-0.SDR AALA20120117TUL07Casting · crackedRIGHT WING GROUND SPOILER CASTING IN TRAILING EDGE OF WING IS CRACKED AT FORWARD OUTBOARD SIDE. INSTALLED NEW CASTING PER AARD 51-10-00-05.SDR WX0A071087Battery · 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 WX0A071086Battery · 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 AALA20120117TUL01Downlock Sensor · inoperativeTUS - CREW REPORTED LOWERED GEAR AND GOT ALL 3 GREEN, BUT ON FINAL GOT GEAR WARNING HORN AND UNSAFE LIGHT ILLUMINATED. RECYCLED GEAR AND WARNING INDICATION REMAINED. EMERGENCY DECLARED FLIGHT LANDED TUS WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLSDR RYNA201201160004Battery · defectiveDURING ACCOMPLISHMENT OF FCD 33-08, FOUND NUMEROUS UPPER EMERGENCY FLOOR TRACK SECTIONS WITH WARPED, CRACKED AND BROKEN AREAS. EMERGENCY FLOOR TRACK LIGHTING SYSTEM BATTERIES FAILED CAPACITY CHECK. REPLACED DAMAGED SECTIONS PER AMM 33-21-27. REPLACED EMERGSDR AALA20120116TUL16Bracket · corrodedSTATION 1212 DOOR BEAM TEE BRACKET CORRODED. INSTALLED SERVICEABLE NEW TEE BRACKET PER AARD 51-10-00-5.SDR AALA20120116TUL15Longeron · crackedCABIN - LONGERON 4 LEFT HAS CRACK INDICATIONS AT STATION 200 IN THE INBOARD AND OUTBOARD LEGS. INSTALLED NEW LONGERON PER SRM 53-02-00 FIGURE 18.SDR AALA20120116TUL11Mount · corrodedG-1 GALLEY MOUNT HAS CORROSION ON THE SURFACE AND IN THE BORE AT STATION 160 OUTBOARD SIDE OF THE DRAIN PAN. INSTALLED OUTBOARD G-1 GALLEY SUPPORT FITTING PER SRM 51-30-02 AND SRM 51-30-05.SDR AALA20120116TUL10Floor Support · corrodedCORROSION ON THE FLOORBOARD SUPPORT FROM THE NUMBER 5 SEAT TRACK OUTBOARD TO THE FORWARD SERVICE DOOR FRAME AT STATION 200. INSTALLED FLOORBOARD SUPPORT AT STATION 200 RIGHT PER SRM 51-30-02.SDR AALA20120116TUL09Mount · corrodedG-1 GALLEY MOUNT HAS CORROSION ON THE SURFACE AND IN THE BORE AT STATION 160 INBOARD SIDE OF THE DRAIN PAN. INSTALLED MIDDLE G-1 GALLEY MOUNT PER SRM 51-30-02 AND SRM 51-30-05.SDR AALA20120116TUL08Cusp Web · corrodedE AND E COMPARTMENT STATION 155, CORROSION ON LOWER SIDE OF LEFT CUSP AT GALLEY 1 DRAIN LINE. INSTALLED SUBFLOOR DOUBLER UNDER G-1 GALLEY DRAIN PAN PER AARD 53-20-00-16.SDR AALA20120116TUL01Stiffener · crackedSTIFFENER CRACKED AT STATION 1338 LNGERON 1 LEFT, JUST UNDER TOP FASTENER. INSTALLED DOUBLER AFT CABIN BULK HEAD STATION 1338 OVER AFT ENTRY DOOR PER AARD 53-10-00-15.SDR AALA20120115TUL03Cusp Web · corrodedCUSP FROM STATIONS 145 TO 170 RIGHT BUTTLINE 56 CORRODED. ACCOMPLISHED DOUBLER REPAIR PER AARD 53-20-00-14.SDR WX0A071078Battery 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 AALA20120114DFW01Connector · not seatedDFW - CREW REPORTED PRESSURIZATION FAILED DURING CLIMBOUT. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. RESEATED LOOSE CONNECTOR ON PRESSURE CONTROL PANEL. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20120114TUL03Module · inoperativeBNA - CREW REPORTED LOSS OF FUEL QUANTITY INDICATION. FLIGHT RETURNED BNA LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED FUEL QUANTITY ELECTRONICS MODULE AND FUEL QUANTITY DISPLAY. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20120201TUL07Cusp Web · corrodedCORROSION ON SUB FLOOR UNDER NUMBER 6 SEAT TRACK FROM FRAME STATIONS 200 TO 218. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20120112DFW01Vertical Gyro · failedDFW - CREW REPORTED LOSS OF SEVERAL FLIGHT INSTRUMENTS. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NUMBER 1 AND 2 VERTICAL GYROS. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20120113LGA03Battery Pack · not seatedLEFT AND RIGHT AFT OVERWING DOOR UPPER EXIT SIGNS INOPERATIVE. RESEATED BATTERY PACK. OPS CHECKS NORMAL.SDR AALA20120113LGA02Battery Pack · dischargedLEFT AND RIGHT FORWARD OVERWING DOOR UPPER EXIT SIGNS INOPERATIVE. REPLACED BATTERY PACK. OPS CHECKS NORMAL.SDR AALA20120113LGA01Light · inoperativeFORWARD CABIN EMERGENCY SIGN ACROSS FROM FIRST CLASS LAVATORY INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY SIGN. OPS CHECKS NORMAL.SDR AALA20120112TUL01Cusp Web · corrodedRIGHT CUSP AT STATION 342 CORRODED. ACCOMPLISHED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA20120111TUL08Cusp Web · corrodedRIGHT CUSP AT STATION 535 TO 539 CRACKED. ACCOMPLISHED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA20120111TUL07Cusp Web · corrodedLEFT CUSP AT STATION 1142 CORRODED. ACCOMPLISHED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA20120109TUL04Doubler · defectiveLEFT ALTERNATE STATIC PORT HAS INTERNAL DOUBLER THAT FAILED WAVINESS INSPECTION. INSTALLED DOUBLER PER SRM 53-04-2 AND SG0953001.SDR AALA20120109TUL03Door Frame · corrodedAFT CARGO DOOR JAMB BEAM STATIONS 1155 TO 1212 CORRODED. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-3.SDR WX0A071063Battery · 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 AALA20120107TUL03Bracket · crackedTOP BRACKET CRACKED ON AFT PRESSURE BULKHEAD STIFFENER, 34 INCHES ABOVE FLOOR AT LEFT OUTBOARD END. INSTALLED ANGLE BRACKET ON AFT BULKHEAD STIFFENER LEFT OUTBOARD END PER AARD 51-10-00-5.SDR AALA20120106TUL03Cusp Web · crackedCARGO AFT CX LT CUSP CRACKED STA 1266. INSTALLED CUSP SHEET AT STA1250-1309 LT SIDE PER AARD 53-20-00-16.SDR AALA20120115TUL01Cusp Web · damagedCUSP AT STATIONS 1244 TO 1250 DAMAGED. REMOVED DAMAGE AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20120105TUL17Cusp Web · damagedLEFT CUSP SHEET IS DAMAGED FROM STATIONS 1244 TO 1250. INSTALLED DOUBLER PER AARD 53-20-00-16 AND EA MD80-53-021127.
Back to Mcdonnell Douglas DC-9-82