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 AALA20110602TUL04Shear Tie · corrodedCORROSION ON SHEAR TIE STATION 1155 BETWEEN LONGERONS 30 AND 29 RIGHT. REMOVED AND REPLACED SHEAR TIE STATION 1155 LONGERONS 30 TO 29 RIGHT PER AARD 51-10-00-5, BOEING DRAWING NUMBER 9936073 AND SRM 51-30-05.SDR AALA20110602TUL03Door Frame · corrodedAFT CARGO DOOR FRAME WEBBING HAS CORROSION STATIONS 1212 TO 1205 STRINGERS 28 TO 29 RIGHT. INSTALLED NEW WEB PER AARD 51-10-00-5.SDR AALA20110602TUL02Doubler · crackedAFT ACCS DOUBLER CRACKED 1485 CANT FRAME AT STAIR RETRACT ACTUATOR. INSTALLED NEW DOUBLER IN PLACE OF OLD CRACKED DOUBLER USING EXISTING HOLES IN FRAME PER AARD 53-10-00-33.SDR AALA20110602TUL01Fitting · wornRIGHT NUMBER 5 SLAT INBOARD KNUCKLE FITTING WORN. REPLACED WORN KNUCKLE FITTING BUSHING AND PIVOT PIN AT RIGHT SLAT PER ESO 80117.SDR AALA20110601TUL15Cusp Web · damagedDUE TO NUMEROUS REPAIRS AND DAMAGE, CUSP SHEET AT STATIONS 598 TO 712 NEEDS TO BE REMOVED. INSTALLED NEW CUSP SHEET, RIGHT HAND SIDE STATIONS 598 TO 712 PER AARD 51-10-00-5.SDR AALA20110601TUL14Skin · scratchedFUSELAGE FORWARD SCRATCHES IN SKIN STATION 207 BETWEEN LONGERONS 4 AND 5 LEFT. INSTALLED INTERNAL DOUBLER PER BOEING DRAWING SG09530001.SDR AALA20110601TUL13Skin · scratchedFUSELAGE FORWARD SCRATCHES IN SKIN STATION 200, BETWEEN LONGERONS 4 AND 5 LEFT. INSTALLED INTERNAL DOUBLER PER BOEING DRAWING SG09530001.SDR AALA20110601TUL12Frame · crackedAFT ACCESSORY 1510 CANT FRAME CRACKED ABOVE MAINTENANCE LIGHT SWITCH. INSTALLED DOUBLER PER EA MD80-53-017199.SDR AALA20110601TUL05Cusp Web · corrodedRIGHT CUSP IS CORRODED STATION 559. INSTALLED RIGHT CUSP SHEET STATIONS 503 TO 598 PER AARD 51-10-00-5.SDR AALA20110601TUL02Rib · crackedRIGHT NUMBER 5 SLAT NUMBER 14 RIB CRACKED INDICATION. REPLACED RIB RIGHT NUMBER 14 POSITION PER ESO 80117 27-80-1.SDR AALA20110601TUL01Rib · crackedLEFT NUMBER 5 SLAT NUMBER 14 RIB CRACK INDICATION. REPLACED NUMBER 14 RIB WITH NEW ONE IAW ES0 27-80-1.SDR AALA20110531TUL06Membrane · corrodedCORROSION ON SUBFLOOR FROM STATIONS 160 TO 200 RIGHT JUST INBOARD OF FORWARD SERVICE DOOR. ACCOMPLISHED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA20110531TUL05Web · crackedAFT ACCESSORY WEB CRACKED 1485 CANT FRAME LEFT OF RUDDER PACK. DOUBLER INSTALLED PER AARD 53-10-00-32.SDR AALA20110531TUL01Intercostal · crackedFORWARD RIGHT SIDE OF CENTER FUEL TANK AT TOP SIDE HAS CRACK IN INTERCOSTAL ANGLE AT ABOUT STATION 826 AND BELOW NUMBER 5 SEAT TRACK. INSTALLED REPAIR DOUBLERS PER EA MD80-57-017085.SDR AALA20110531LGA01Battery Pack · dischargedAFT CABIN EMERGENCY PATH LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR AFT CABIN EMERGENCY PATH LIGHTS. OPS CHECK NORMAL.SDR AALA20110530TUL01Pan · corrodedFUSELAGE AFT LAVATORY SERVICE PANEL LOWER PAN CORRODED FROM FORWARD END TO AFT END. INSTALLED DOUBLER PER EA MD80-53-017119.SDR AALA20110530LGA01Battery Pack · dischargedFORWARD OVERWING EMERGENCY EXIT SIGN INOPERATIVE. REPLACED BATTERY PACK FOR FORWARD OVERWING EMERGENCY EXIT SIGN. OPS CHECK NORMAL.SDR AALA20110529TUL06Unlock Switch · out of adjustDEN - INFLIGHT STL-LAX. CREW REPORTED LEFT TRUST REVERSER UNLOCK INDICATION LIGHT ILLUMINATED. EMERGENCY DECLARED FLIGHT DIVERTED DEN LANDED WITHOUT INCIDENT. ADJUSTED LEFT ENGINE THRUST REVERSER UNLOCK SWITCH. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20110529TUL09Cusp Web · crackedCRACKS TWO PLACES ON LEFT CUSP STATION 222. INSTALLED CUSP SHEET AND DOUBLER AT STATIONS 218 TO 317 LEFT SIDE PER AARD 51-10-00-5.SDR AALA20110529TUL05Pan · crackedWINDOW RING PAN CRACKED LEFT SIDE, LOWER FORWARD CORNER AT STATION 984. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20110529TUL04Pan · crackedWINDOW RING PAN CRACKED RIGHT SIDE, LOWER FORWARD CORNER AT STATION 984. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20110529TUL03Pan · crackedWINDOW RING PAN CRACKED RIGHT SIDE, LOWER AFT SIDE OF STATION 845. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20110529TUL02Pan · crackedWINDOW RING PAN CRACKED RIGHT SIDE, UPPER FORWARD CORNER AT STATION 886. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20110529TUL01Pan · crackedWINDOW RING PAN CRACKED RIGHT SIDE, UPPER FORWARD CORNER AT STATION 927. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20110529DFW01Periseal · leakingDFW - (REPEAT ITEM) CREW REPORTED DURING CLIMB TAIL TEMP HIGH LIGHT ILLUMINATED. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND LEAK COMING FROM PERI AIR SEALS ON DUCT TO HEAT EXCHANGER ON LEFT SIDE. RESDR AALA20110528DFW01Pump · failedDFW - CREW REPORTED ON APPROACH AIRCRAFT YAWED TO THE RIGHT, BOTH PACKS SHUTDOWN AND THE RIGHT ENGINE APPEARED TO QUIT PRODUCING THRUST FOR A VERY SHORT PERIOD OF TIME. FLIGHT LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RIGHT ENGINESDR AALA20110528PHX03Seal · leakingPHX - (REPEAT ITEM) CREW REPORTED TAIL COMPARTMENT HIGH TEMPERATURE LIGHT ILLUMINATED. EMERGENCY DECLARED FLIGHT RETURNED PHX LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND LEFT PERI AIR SEALS LEAKING NEAR HEAT EXCHANGER. REPLACED SEALS. SYSDR AALA20110528TUL02Cusp Web · corrodedSUBFLOOR AT STATION 200 HAS CORROSION FORWARD OF SEAT TRACK NUMBER 6. INSTALLED SUBFLOOR DOUBLER STATIONS 200 TO 218 RIGHT PER AARD 53-20-00-16.SDR AALA20110528PHX01Clamp · loosePHX - CREW REPORTED TAIL COMPARTMENT HIGH TEMPERATURE LIGHT ILLUMINATED. EMERGENCY DECLARED FLIGHT RETURNED PHX LANDED WITHOUT INCIDENT. FOUND LEFT PNEUMATIC DUCT CLAMP LOOSE. TIGHTENED CLAMP. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20110528TUL01Sense Line · looseIAH - CREW REPORTED TAIL COMPARTMENT HIGH LIGHT ILLUMINATED. EMERGENCY DECLARED FLIGHT RETURNED IAH LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND LOOSE SENSE LINE AT FLOW CONTROL VALVE. TIGHTENED SENSE LINE. SYSTEM GROUND CHECK NORMAL OPERSDR AALA20110528LGA01Battery Pack · not seatedTAIL COMPARTMENT EMERGENCY LIGHTS WILL NOT TEST. RE-SEATED BATTERY PACK. OPS CHECK NORMAL.SDR AALA20110527TUL13Cusp Web · crackedTWO CRACKS ON CUSP STATION 222. INSTALLED CUSP SHEET AND DOUBLER PER AARD 51-10-00-05.SDR AALA20110527TUL12Seat Track · corrodedNUMBER 1 SEAT TRACK STATION 1174 CORROSION OUT OF LIMITS. REPLACED NUMBER 1 SEAT TRACK STATIONS 1174 TO 1309 PER AMM 53-40-01-2.SDR AALA20110527TUL11Beam · bentNUMBER 8 BEAM FORWARD END AT HINGE ATTACH AREA BENT. INSTALLED NEW NUMBER 8 BEAM PER ESO 80172.SDR AALA20110527TUL09Pan · crackedWINDOW RING PAN CRACKED LEFT SIDE UPPER FORWARD CORNER AT STATION 788. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20110527TUL08Pan · crackedWINDOW RING PAN CRACKED RIGHT SIDE FORWARD LOWER CORNER AT STATION 1155. TRIMMED OUT CRACKED TAB AND INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20110527TUL07Pan · crackedWINDOW RING PAN CRACKED LEFT SIDE LOWER AFT CORNER AT STATION 826. CUT OUT CRACKED AREA OF WINDOW RINGPAN. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20110527TUL06Pan · crackedWINDOW RING PAN CRACKED RIGHT SIDE FORWARD LOWER CORNER AT STATION 1211. TRIMMED OUT CRACKED TAB AND INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20110527TUL05Pan · crackedWINDOW RING PAN CRACKED LEFT SIDE LOWER FORWARD CORNER AT STATION 1041. INSTALLED REPAIR ANGLE AS PER AARD 53-10-00-25.SDR AALA20110527TUL04Pan · crackedWINDOW RING PAN CRACKED LEFT SIDE UPPER AFT CORNER AT STATION 1041. INSTALLED REPAIR ANGLE AS PER AARD 53-10-00-25.SDR AALA20110527TUL03Pan · crackedWINDOW RING PAN CRACKED LEFT SIDE LOWER FORWARD CORNER AT STATION 984. INSTALLED REPAIR ANGLE DOUBLER AT STATION 984 LOWER FORWARD CORNER PER AARD 53-10-00-25.SDR AALA20110527TUL02Pan · crackedWINDOW RING PAN CRACKED RIGHT SIDE LOWER FORWARD CORNER AT STATION 984. INSTALLED REPAIR ANGLE DOUBLER AT STATION 984 RIGHT LOWER FORWARD CORNER PER AARD 53-10-00-25.SDR AALA20110527TUL01Mount · corrodedFORWARD OUTBOARD G4 GALLEY MOUNT CORROSION OUT OF LIMITS. INSTALLED NEW G4 FORWARD OUTBOARD MOUNT IN NUMBER 1 SEAT TRACK PER SRM 51-30-5.SDR AALA20110526TUL03Floorbeam · corrodedRIGHT AFT LAVATORY HAS CORROSION ON FLOORBEAM STATION 1322. INSTALLED DOUBLER PER SRM 53-05-00 AND AARD 53-00-00-06.SDR AALA20110526TUL02Frame · puncturedRIGHT AFT LAVATORY HAS PUNCTURE IN FRAME STATION 1322. INSTALLED J ANGLE REPAIR PER AARD 53-10-00-17 AND EA MD80-53-017145.SDR AALA20110525TUL05Seat Track · corrodedNUMBER 6 SEAT TRACK AT STATION 728 CORROSION OUT OF LIMITS. INSTALLED SEAT TRACK PLUG AT STATION 728 PER AARD 53-20-00-10.SDR AALA20110525TUL04Seat Track · corrodedNUMBER 6 SEAT TRACK AT STATION 665 CORROSION OUT OF LIMITS. INSTALLED SEAT TRACK REPAIR PLUG ON SEAT TRACK NUMBER 6 STATION 665 PER AARD 53-20-00-10.SDR AALA20110525TUL03Seat Track · corrodedNUMBER 6 SEAT TRACK AT STATION 625 CORROSION OUT OF LIMITS. INSTALLED SEAT TRACK REPAIR PLUG ON SEAT TRACK NUMBER 6 AT STATION 625 PER AARD 53-20-00-10.SDR AALA20110525TUL02Web · corrodedAFT CARGO, STATIONS 1155 TO 1174 CORROSION ON WEB. INSTALLED SERVICEABLE WEB PER AARD 51-10-00-5.SDR AALA20110525TUL01Support · crackedLEFT STATION 927 SEAT TRACK SUPPORT CRACKED. MISDRILLED HOLE IN WEBBING AT STATION 927. INSTALLED DOUBLER REPAIR ON WEBBING AND INSTALLED DOUBLER AND FILLER REPAIR ON SEAT TRACK SUPPORT PER EA MD80-53-017063 AND EA MD80-53-017065.
Back to Mcdonnell Douglas DC-9-82