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 AALA20100128TUL19Rib · wornRIGHT WING SLAT EXCESSIVE PLAY IN KNUCKLE AT OUTBOARD END OF NUMBER 4 SLAT. REPLACED WORN RIB OUTBOARD MOST POSITION RIGHT NUMBER 4 SLAT PER ESO 80117.SDR AALA20100128TUL14Pan · crackedWINDOW PAN CRACKED UPPER AFT EAR IS CRACKED AT STATION 1060 LEFT. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100128TUL13Pan · crackedWINDOW PAN CRACKED UPPER AFT EAR IS CRACKED AT STATION 1041 LEFT. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100128TUL12Cusp Web · corrodedLEFT CUSP FOUND CORRODED OUT OF LIMITS ON LOWER SURFACE FROM STATIONS 1174 TO 1176 LEFT. INSTALLED REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA20100128TUL10Skin · damagedAFT CARGO DOOR SKIN DENTED AT REPAIR RIVET ABOVE NUMBER 3 BEAM 14 INCHES FROM LEADING EDGE. INSTALLED DOUBLER ON OUTER SKIN OF AFT CARGO DOOR PER SRM 52-05-00 FIG 1 SHEET 1.SDR AALA20100128TUL09Pan · crackedWINDOW PAN CRACKED UPPER FORWARD EAR IS CRACKED AT STATION 946 LEFT. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20100128TUL07Longeron · crackedLONGERON 3 LEFT FOUND CRACKED IN RADIUS AT STATION 160. INSTALLED LONGERON REPAIR SPLICE PER SRM 53-02-00 AND SRM 53-14-01.SDR AALA20100128TUL06Longeron · crackedLONGERON 2 LEFT FOUND CRACKED IN RADIUS AT STATION 160. INSTALLED LONGERON SPLICE REPAIR PER SRM 53-02-00 AND SRM 53-14-01.SDR AALA20100128TUL05Angle · crackedCABIN FORWARD SERVICE DOOR CRACK IN ANGLE TOP FORWARD CORNER. INSTALLED DOUBLER AND 2 EACH ANGLES PER SRM 52-10 FIG 25.SDR AALA20100128TUL04Skin · crackedSKIN FOUND CRACKED AT CANT 1474 AT LONGERON 23 RIGHT. INSTALLED REPAIR DOUBLER PER SRM 53-01-00 FIG 2 SHEET 3.SDR AALA20100128TUL03Cusp Web · corrodedCUSP CORRODED OUT OF LIMITS AT STATIONS 522 TO 541 RIGHT. INSTALLED REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA20100128TUL02Longeron · crackedLONGERON 4 LEFT CRACKED AT STATIONS 160 TO 200. INSTALLED NEW SECTION OF LONGERON FROM STATIONS 148 TO 225.SDR AALA20100128TUL01Longeron · crackedLONGERON 3 LEFT CRACKED AT STATION 160. INSTALLED NEW LONGERON AND SPLICE PER SRM 53-02-00 FIGURE 18.SDR AALA20100128JFK03Seal · defectiveJFK - INFLIGHT LGA-ORD - CREW REPORTED NOSE GEAR WOULD NOT RETRACT. EMERGENCY DECLARED, DIVERTED JFK LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NOSE LANDING GEAR STRUT SEAL. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20100127TUL08Structure · damagedDAMAGE AT AFT SERVICE DOOR FORWARD GIRT BAR FITTING. INSTALLED DOUBLER AND NEW GIRT BAR BRACKET.SDR AALA20100127TUL09Csd · inoperativeSDF - INFLIGHT DFW-PIT. CAPTAIN REPORTED, SHUT DOWN LEFT GENERATOR DUE TO LOW OIL PRESSURE AND HIGH TEMPERATURE. EMERGENCY DECLARED, DIVERTED SDF LANDED WITHOUT INCIDENT. REPLACED NUMBER ONE ENGINE CONSTANT SPEED DRIVE. SYSTEM GROUND CHECKED NORMAL OPERATISDR AALA20100127TUL05Cargo Track · corrodedAFT CARGO TIE DOWN TRACK CORRODED OUT OF LIMITS AT ATTACH POINTS AT STATIONS 1136, 1147, 1155. REPLACE CARGO TIE DOWN TRACK PER SRM 51-30-01 REF MPN 5936663-505.SDR AALA20100127TUL04Frame · corrodedCORROSION FOUND OUT OF LIMITS AT J FRAME AT STATION 1271 BETWEEN LONGERON 29 LEFT AND 29 RIGHT. INSTALLED FRAME SPLICE REPAIR PER AARD 53-10-00-17.SDR AALA20100127TUL03Pan · gougedAFT SERVICE DOOR HANDLE PAN GOUGED. REMOVED OLD HANDLE PAN AND INSTALLED NEW PAN PER ESO 80175.SDR AALA20100127TUL02Cusp Web · corrodedCORROSION ON CUSP FOUND OUT OF LIMITS AT STATION 1068 TO 1070. INSTALLED DOUBLER AARD 53-20-00-16.SDR AALA20100127TUL01Skin · bentCABIN FORWARD ENTRY DOOR SKIN IS BENT IN SEVERAL PLACES ALONG BOTTOM EDGE OF DOOR. INSTALLED REPAIR DOUBLER PER AARD 52-10-00-2 FIG 1.SDR AALA20100126TUL04Seat Track · corrodedNUMBER 4 SEAT TRACK CORRODED AND BLENDED OUT OF LIMITS. REPAIRED WITH PLUG PER SRM 53-05 FIG 4A.SDR AALA20100126TUL03Support · crackedCABIN VERTICAL SUPPORT CRACKED AT STATION 927 BELOW SEAT TRACK NUMBER 2. INSTALLED NEW VERTICAL SUPPORT AT STATION 927 BELOW SEAT TRACK NUMBER 2 PER SRM 51-01.SDR AALA20100126TUL02Seat Track · corrodedNUMBER 5 SEAT TRACK AT STATION 200 CORRODED. REMOVED CORROSION AND INSTALLED REPAIR STRAP PER MD-80 AARD 53-20-00-13.SDR AALA20100126TUL01Bracket · corrodedLOWER FORWARD CORNER BRACKET HAS CORROSION IN DOOR OPENING. REMOVED AND REPLACED BRACKET PER SRM 51-01-00-2 AND 51-30-05.SDR AALA20100125TUL02Support · crackedCABIN VERTICAL SUPPORT CRACKED AT STATION 927 BELOW SEAT TRACK NUMBER 5. REMOVED AND REPLACED SUPPORT PER SRM 51-30-05.SDR AALA20100125TUL01Rib · crackedCRACK AT NUMBER 5 SLAT OUTBOARD RIB AT NUMBER 15 SLAT TRACK ATTACHMENT. REPLACED CRACKED OUTBOARD MOST ATTACH RIB AT RIGHT NUMBER 5 SLAT PER ESO 80117.SDR AALA20100124LGA01Battery Pack · dischargedEMERGENCY EXIT LIGHTS FORWARD OF OVERWING EXIT INOPERATIVE. REPLACED BATTERY PACK.SDR AALA20100122TUL05Casting · crackedFOUND PULLEY BRACKET SUPPORT CASTING CRACKED ON FORWARD WING SPAR. REMOVED CASTING PER SRM 51-01.SDR AALA20100122TUL04Pan · crackedLEFT WINDOW PAN CRACKED AT UPPER FORWARD CORNER STATION 946. CUT OUT DAMAGE AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100122TUL03Pan · crackedRIGHT WINDOW PAN CRACKED AT UPPER AFT CORNER STATION 1022. CUT OUT DAMAGE AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100122TUL02Pan · crackedRIGHT WINDOW PAN CRACKED AT UPPER AFT CORNER STATION 1060. CUT OUT DAMAGE AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100122TUL01Pan · crackedRIGHT WINDOW PAN CRACKED AT UPPER AFT CORNER STATION 1174. CUT OUT DAMAGE AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100121TUL10Pan · wornHANDLE PAN ON CARGO DOOR HAS DEEP WEAR. REMOVED DAMAGED HANDLE PAN, DRILLED AND INSTALLED NEW HANDLE PAN PER ESO 80174.SDR AALA20100121TUL09Beam · crackedCRACK FOUND IN CABIN FORWARD ENTRY DOOR IN CENTER OF NUMBER 6 BEAM AT FASTENER HOLE. INSTALLED DOUBLER AT NUMBER 6 BEAM OF FORWARD ENTRY DOOR PER ESO 80172.SDR AALA20100121TUL02Angle · crackedFORWARD CARGO DOOR HAS CRACKED ANGLE INSIDE UNDER STRAP. REPLACED CRACKED ANGLE UNDER ESO 80174.SDR AALA20100121TUL01Skin · dentedRIGHT NUMBER THREE SLAT DENTED 22 INCHES FORM OUTBOARD END OF LEADING EDGE. REWORKED DENTED AREA BACK TO ORIGINAL CONTOUR AND NO CRACKS FOUND UNDER ESO 80117.SDR AALA20100120TUL09Oxygen Bottle · low pressurePIT DURING FLIGHT IT WAS DISCOVERED CREW OXYGEN BOTTLE PRESSURE LOSS. FLIGHT DIVERTED PIT LANDED WITHOUT INCIDENT. SERVICED CREW OXYGEN BOTTLE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20100121LGA01Battery Pack · dischargedEMERGENCY LIGHT BATTER PACK IN CABIN FAILED FUNCTIONAL TEST. REPLACED TWO BATTERY PACKS IN CABIN.SDR AALA20100120TUL07Rib · crackedCRACK FOUND ON RIGHT WING NUMBER FIVE SLAT OUTBOARD SLAT RIB BY HIGH FREQUENCY EDDY CURRENT INSPECTION. REPLACED CRACKED OUTBOARD MOST ATTACH RIB NUMBER 5 RIGHT HAND SLAT PER ESO 80117.SDR AALA20100120TUL06Rib · crackedCRACK FOUND ON RIGHT WING NUMBER 5 SLAT 2ND OUTBOARD END SLAT RIB BY HIGH FREQUENCY EDDY CURRENT INSPECTION. REPLACED CRACKED ATTACH RIB 2ND FROM OUTBOARD NUMBER 5 RIGHT SLAT PER ESO 80117.SDR AALA20100120TUL04Cusp Web · crackedCRACK IN RIGHT CUSP, THREE INCHES INBOARD OF CUSP TEE STATION 842. CUT OUT DAMAGE AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100120TUL03Skin · dentedDENT AND SEVERAL SCRATCHES ON RIGHT SIDE OF FUSELAGE, AT LONGERON 20, STATION 285. BLENDED SCRATCHES AND INSTALLED INTERNAL DOUBLER PER SRM 53-04 FIGURE 38, SHEET 20.SDR AALA20100120TUL02Web · puncturedHOLE IN SUBFLOOR 13 INCHES INBOARD OF FORWARD ENTRY DOOR STATION 200. CUT OUT DAMAGE AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100120TUL01Seat Track · corrodedNUMBER 6 SEAT TRACK INSIDE TRACK CORROSION. REMOVED CORROSION FOUND SEAT TRACK TO BE OUT OF LIMITS. INSTALLED SEAT TRACK REPAIR PLUG PER 53-05 FIG 4A.SDR AALA20100119TUL04Pan · crackedRIGHT LOWER WINDOW PAN CRACKED AT STATION 1136. REMOVED DAMAGE AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100119TUL03Pan · crackedRIGHT AFT UPPER WINDOW PAN CRACKED AT STATION 1041. REMOVED DAMAGE AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100119TUL09Bracket · crackedAFT CABIN BULKHEAD DOOR JAMB CENTER BRACKET CRACKED LEFT HAND SIDE. REMOVED AND REPLACED BRACKET PER SRM 51-01.SDR AALA20100119TUL08Bracket · crackedAFT BULKHEAD DOOR JAMB CENTER DOOR BRACKET CRACKED ON RIGHT SIDE. REMOVED AND REPLACED BRACKET PER SRM 51-01.SDR AALA20100119TUL07Pan · crackedLEFT WINDOW PAN CRACKED AT UPPER CORNER STATION 1079. REMOVED DAMAGE AND INSTALLED DOUBLER PER AARD 53-10-00-25.
Back to Mcdonnell Douglas DC-9-82