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 AALA20100707TUL05Seat Track · corrodedHEAVY CARGO/AFT- CORROSION ON TIE-DOWN TRACK LEFT SIDE STATIONS 1212 TO 1287, TOP AND BOTTOM SIDES. BLENDED OUT CORROSION PER SRM 51-10-03. BLEND OUT WITHIN LIMITS ON TRACK OUT OF LIMITS ON FACTORY SPLICE PER SRM 53-01-00. TREATED AND PRIMED BLEND AREA PER SDR AALA20100707TUL04Vane · puncturedPUNCTURE IN LEFT INBOARD FLAP VANE OUTBOARD VANE LOWER SURFACE. INSTALLED HOT BOND DOUBLER PER SRM 51-70-2.SDR AALA20100707TUL10Frame · crackedTHE 1497 CANT FRAME CRACKED BELOW RIGHT LOUVER BOX. INSTALLED DOUBLER PER EA MD80-53-011694.SDR AALA20100707TUL09Cusp Web · corrodedRIGHT CUSP STATION 1193 CORROSION IS OUT OF LIMITS. INSTALLED CUSP DOUBLER PER AARD 53-20-00-16.SDR AALA20100706AUS02Door · openAUS - CREW REPORTED VIBRATIONS FROM NOSE GEAR AREA. EMERGENCY DECLARED FLIGHT RETURNED AUS LANDED WITHOUT INCIDENT. FOUND LEFT FORWARD NOSE GEAR DOOR PARTIALLY OPEN ON ARRIVAL. INSPECTED NOSE GEAR DOOR RELEASE MECHANISM AND LINKAGE-NO DEFECTS/DAMAGE NOTED. SDR WX0A070573Battery · dischargedIT HAS BEEN REPORTED BY THE FLIGHT CREW THE EMERGENCY EVACUATION LIGHTING SYSTEM HAS BEEN FOUND TO BE DEFECTIVE. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE APPROPRIATE BATTERIES IN THE BATTERY PACK AND MADE ALL REQUIRED CORRECTIONS AND OPERATIONAL CHECK WSDR AALA20100910TUL02Battery Pack · dischargedCOACH CLASS OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK AT ROW 21. OPS CHECKED NORMAL.SDR AALA20100910TUL01Battery Pack · dischargedCOACH CLASS OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK AT ROW 14. OPS CHECKED NORMAL.SDR AALA20100703DFW02Battery Pack · dischargedCOACH CLASS OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACKS AT ROW 9. OPS CHECKED NORMAL.SDR AALA20100702DFW01Apu · failedDFW - CREW REPORTED AUXILIARY POWER UNIT FAILED AND LEFT ENGINE GENERATOR ON PLACARD. EMERGENCY DECLARED RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT ENGINE GENERATOR AND CONSTANT SPEED DRIVE. SYSTEM GROUND CHECKED NORSDR AALA20100702TUL02Cusp Web · crackedRIGHT CUSP STATION 455 HAS A CRACK WITH A HOLE. INSTALLED CUSP DOUBLER PER AARD 53-20-00-16.SDR AALA20100701TUL06Cusp Web · crackedRIGHT CUSP AFT STATION 218 HAS TWO CRACKS. INSTALLED NEW CUSP SECTION STATION 218 TO STATION 237 FROM SEAT TRACK NUMBER 5 OUTBOARD PER SRM 51-01-00.SDR AALA20100701TUL05Seat Track · corrodedNUMBER 6 SEAT TRACK LUG OUT OF LIMITS AT STATIONS 563 TO 567. INSTALLED PLUG PER AARD 53-20-00-10 AND SRM 53-05-00.SDR AALA20110701DFW01Connector · burnedDFW - CREW REPORTED ELECTRICAL SMOKE AND FUMES IN CABIN. AFTER TURNING OFF GALLEY POWER, RECIRCULATION FAN INTERNET POWER POT AND RELATED CIRCUIT BREAKERS, SMOKE DISSIPATED IN CABIN. FLIGHT LANDED DFW WITHOUT INCIDENT. FOUND CONNECTOR R-5 3292 AT ROW 27AB BSDR AALA20100630TUL09Engine · faultyBHM - CREW HEARD LOUD BANG FOLLOWED BY LEFT ENGINE SHUTTING ITSELF DOWN INFLIGHT. EMERGENCY DECLARED FLIGHT RETURNED BHM LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. LEFT ENGINE WAS REPLACED AT BHM ON 07/02/2010. SYSTEM GROUND CHECK NORMAL OPERASDR AALA20100630TUL02Rib · wornSLAT BRACKET ON OUTBOARD SKIN AT RIB NUMBER 15 WORN. REPLACED SLAT BRACKET AND NEW SKIN ON LEADING EDGE OUTBOARD PER ESO 80117SDR AALA20100630TUL13Seat Track · corrodedNUMBER 6 SEAT TRACK CORRODED BEYOND LIMITS STATION 321. INSTALLED SEAT TRACK PLUG ON SEAT TRACK NUMBER 6 STATION 321 PER SRM 53-05-00 FIGURE 4A. TREATED AND PRIMED AREA PER SRM 51-10-03.SDR AALA20100630TUL06Cusp Web · tornRIGHT CUSP STATION 989 TORN. REMOVED DAMAGE AND INSTALLED DOUBLER AARD 53-20-00-16.SDR AALA20100630DFW01Line · leakingDFW - DURING TAXI IN AFTER LANDING, CREW WAS CONTACTED BY A PASSING AIRCRAFT THAT THE BRAKES APPEARED TO BE SMOKING. CREW NOTED RIGHT HYDRAULIC FLUID QUANTITY HAD DROPPED TO ALMOST ZERO. FOUND NUMBER 1 BRAKE FORWARD BRAKE LINE LEAKING AROUND QUICK CONNECT. SDR AALA20100629TUL12Seal · looseIAD - INFLIGHT LGA-DFW. AUXILIARY POWER UNIT LOW OIL PRESSURE LIGHT ILLUMINATED IN FLIGHT APU SHUT DOWN. LEFT ENGINE GENERATOR ON MEL. EMERGENCY DECLARED DIVERTED IAD ON ACCOUNT SINGLE GENERATOR OPERATION. FOUND LOOSE SEAL ON AXILIARY POWER UNIT OIL CAP. SDR AALA20100629TUL11Strap · crackedT-STRAP CRACKED AT LONGERON 11 LEFT STATION 207. INSTALLED REPAIR STRAP AT LONGERON 11 LEFT STATION 207 PER AARD 53-10-00-11.SDR AALA20100629TUL10Window Frame · crackedRIGHT WINDOW FRAME CRACKED AT LOWER FORWARD SIDE AT STATIONS 1117 TO 1136. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100629TUL09Pan · crackedWINDOW PAN CRACKED AT STATION 1079 LEFT SIDE UPPER AFT CORNER. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR AALA20100629TUL08Pan · crackedWINDOW PAN CRACKED BETWEEN STATIONS 886 TO 905 AT UPPER FORWARD CORNER ON LEFT SIDE. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20100629TUL07Window Frame · crackedRIGHT WINDOW FRAME CRACKED AT UPPER FORWARD SIDE AT STATIONS 946 TO 965 MARKED. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20100629TUL06Window Frame · crackedRIGHT WINDOW FRAME CRACKED AT UPPER FORWARD SIDE AT STATIONS 927 TO 946 MARKED. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20100629TUL04Pan · crackedWINDOW PAN CRACKED AT STATION 1098 LEFT SIDE LOWER AFT CORNER. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR AALA20100628TUL08Module · inoperativeIND - CREW REPORTED ALL FUEL QUANTITY INDICATIONS WENT BLANK. EMERGENCY DECLARED FLIGHT RETURNED IND LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED STANDARD ELECTRIC MODULE IN FUEL QUANTITY INDICATOR. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20100628TUL07Skin · crackedFUSELAGE SKIN CRACKED AT 1474 CANT FRAME APPROXIMATELY LONGERON 22 LEFT. INSTALLED EXTERNAL DOUBLER ON SKIN AT 1474 CANT FRAME AND LONGERON 22 LEFT PER SRM 53-01-00 FIGURE 2.SDR WX0A070572Battery Pack · inoperativeDURING 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 BATTERY PACK AND MADE ALL REQUIRED CSDR AALA20100623TUL04Membrane · corrodedCORROSION ON SUBFLOOR FROM STATIONS 160 TO 178 JUST AFT OF G1 GALLEY DRAIN PAN. INSTALLED SUBFLOOR DOUBLER FROM STATION 148 RIGHT TO STATION 200 RIGHT PER AARD 53-20-00-16.SDR AALA20100623TUL03Cusp Web · corrodedCABIN RIGHT CUSP CRACKED STATION 223. INSTALLED NEW SECTION CABIN RIGHT CUSP STATIONS 218 TO 223 PER AARD 53-20-00-16.SDR AALA20100623TUL02Membrane · corrodedCORROSION ON SUBFLOOR AT STATION 201 RIGHT SIDE OUTBOARD EDGE. INSTALLED REPAIR DOUBLER ON SUBFLOOR AT STATION 201 RIGHT SIDE OUTBOARD EDGE PER AARD 53-20-00-16.SDR AALA20100622TUL02Pan · corrodedCORROSION ON CARGO DOOR PAN FROM STATIONS 389 TO 427. REPAIRED FORWARD CARGO LOWER DOOR JAMB/PAN PER SRM 53-05-00 FIGURE 44.SDR AALA20100621DFW03Placard · damagedLEFT AND RIGHT OVERWING EMERGENCY EXIT MARKER DECALS DAMAGED. REPLACED DECALS.SDR AALA20100621DFW02Guard · damagedSEAT 15D EMERGENCY LIGHT GUARD DAMAGED. REPLACED LIGHT GUARD.SDR AALA20100619TUL03Skin · corrodedCORROSION BETWEEN AFT LAVATORY PAN AND SKIN AT LOWER FORWARD CORNER OF CUTOUT. INSTALLED SKIN DOUBLER AT AFT LAVATORY SERVICE PAN PER EA MD80-53-011325.SDR AALA20100618TUL02Frame · crackedAFT 1463 CANT FRAME WEB CRACKED ABOVE RIGHT LOUVER BOX. INSTALLED REPAIR DOUBLERS ON 1463 CANT FRAME ABOVE RIGHT LOUVER BOX IAW EA MD80-53-011275 DATED 6/15/10 AND SRM 53-03 FIGURE 38.SDR AALA20100618TUL08Cusp Web · corrodedCORROSION ON CUSP UNDER GIRT BAR FITTINGS AT AFT SERVICE ENTRY DOOR. INSTALLED TITANIUM DOUBLER UNDER GIRT BAR FITTINGS AT AFT SERVICE ENTRY DOOR PER SRM 51-10-03.SDR AALA20100624ORD02Skin · crackedLEFT WING LEADING EDGE CRACK BELOW SLAT NUMBER 2 APPROXIMATELY 4.5 INCHES LONG. ACCOMPLISHED DOUBLER REPAIR PER SRM 57-06B-00 FIGURE 14.SDR AALA20100618TUL10Cusp Web · corrodedCORROSION ON BOTTOM OF LEFT CUSP STATION 511. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100618TUL13Cusp Web · crackedLEFT CUSP CRACKED AT STATION 225. REPLACED CUSP SHEET STATIONS 218 TO 237 PER AARD 53-20-00-16.SDR AALA20100618TUL01Bracket · crackedBRACKET BROKEN INSIDE OF AFT VAULT DOOR FRAME ON RIGHT SIDE AT 13 INCHES FROM FLOOR. INSTALLED NEW SERVICABLE BRACKET PER SRM 51-01-00.SDR AALA20100619LGA01Battery Pack · dischargedFIRST CLASS EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK FOR FIRST CLASS EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20100617TUL05Cusp Web · corrodedCRACK AND CORROSION IN LEFT CUSP STATIONS 845 TO 820. REMOVED DAMAGED SECTION AND INSTALLED DOUBLER ON CUSP STATIONS 840 TO 820 LEFT SIDE PER AARD 53-20-00-16.SDR AALA20100617TUL03Cusp Web · corrodedCORROSION ON BOTTOM OF LEFT HAND CUSP STATION 511., INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20100617TUL02Beam · crackedNUMBER 6 BEAM CRACKED AT OUTBOARD AFT BOLT. INSTALLED REPAIR DOUBLER PER AARD 52-10-00-3.SDR AALA20100616TUL01Strap · corrodedREMOVED CORRODED STRAP IN LONGERON CHANNEL. NO CORROSION FOUND UNDER STRAP IN LONGERON CHANNEL. INSTALLED NEW STRAP IN LONGERON 23 LEFT AT STATION 1309 PER SRM 51-30-02.SDR AALA20100616TUL19Casting · crackedLEFT HAND GROUND SPOILER CASTING CRACKED. INSTALLED NEW CASTING PER SRM 51-02-00SDR AALA20100616TUL18Casting · crackedRIGHT HAND GROUND SPOILER CASTING CRACKED. INSTALLED NEW CASTING.
Back to Mcdonnell Douglas DC-9-82