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 AALA20090422TUL20Support Fitting · crackedRIGHT MAIN LANDING GEAR DOOR ACTUATOR SUPPORT FITTING CRACKED. INSTALLED DOUBLER PER ESO 80559 DATED 04/08/09.SDR AALA20090422TUL19Stop Fitting · crackedLEFT MAIN LANDING GEAR DOOR ACTUATOR SUPPORT FITTING CRACKED. INSTALLED DOUBLER PER ESO 80559 DATED 04/08/09.SDR AALA2009042000003Control Box · inoperativeONT - ANTI-SKID LIGHT ILLUMINATED. EMERGENCY DECLARED LANDED ONT WITHOUT INCIDENT. REMOVED AIRCRAFT FROM SERVICE. REPLACED ANTI SKID CONTROL BOX. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA2009042000796Receptacle · faultyDCA - ROW 25 EMERGENCY PATH LIGHTS INOPERATIVE. REPLACED LIGHT RECEPTACLE FOR ROW 25 EMERGENCY PATH LIGHTS.SDR AALA2009042000795Connector · not seatedDCA - ROW 25 EMERGENCY PATH LIGHTS INOPERATIVE. RESEATED CONNECTOR FOR ROW 25 EMERGENCY PATH LIGHTS.SDR AALA2009042000794Light · inoperativeDCA - ROW 25 EMERGENCY PATH LIGHTS INOPERATIVE. REPLACED LAMP FOR ROW 25 EMERGENCY PATH LIGHTS.SDR AALA2009042000793Lens · missingDCA - ROW 25 EMERGENCY PATH LIGHTS INOPERATIVE. REPLACED LENS FOR ROW 25 EMERGENCY PATH LIGHTS.SDR AALA20090512TUL24Beam · corrodedAFT CARGO DOOR BEAM HAS CORROSION. INSTALLED DOOR BEAM DOUBLER PER AARD 53-10-00-03.SDR AALA20090512TUL02Pan · corrodedFWD CARGO THRESHOLD PAN CORRODED. REPLACED PAN PER SRM 53-05-00 FIG 44.SDR AALA20090422TUL18Stop Fitting · crackedSTOP PAD FITTING CRACKED ON FORWARD CARGO DOOR. REMOVED AND REPLACED FITTING PER ESO 80174.SDR AALA20090422TUL17Stop Fitting · crackedSTOP PAD CRACKED ON FORWARD CARGO DOOR. REMOVED AND REPLACED FITTING PER ESO 80174.SDR AALA20090422TUL16Stop Fitting · crackedSTOP PAD FITTING CRACKED ON FORWARD CARGO DOOR. REMOVED AND REPLACED FITTING PER ESO 80174.SDR AALA20090422TUL15Frame · crackedFRAME CRACKED AT ALIGNMENT PIN HOLES FOR TAIL CONE AT STATION 1510. STOP DRILLED CRACK AND INSTALLED DOUBLER PER AARD 53-01-00.SDR AALA20090512TUL26Cargo Track · corrodedCORROSION ON LT TIE DOWN TRACK IN THE AFT CARGO. INSTALLED NEW TIEDOWN TRACK PER AARD 51-00-00-12.SDR AALA2009041800001Oxygen Mask · damagedDFW CAPTAINS O2 MASK JACK PUSHED INTO SIDEWALL PANEL. REPLACED CAPTAINS O2 MASK JACK AND PANEL COVER.SDR AALA2009041801007Connector · corrodedPHL - FORWARD ZONE SEATS 3 TO 19 INOPERATIVE. REPLACED CORRODED CONNECTORS FOR LIGHT ASSEMBLY.SDR AALA2009041801006Battery Pack · dischargedPHL - FORWARD ZONE SEAT 3 TO 19 INOPERATIVE. REPLACED BATTERY AT CONTROL MODULE AB5-1.SDR AALA2009041700001Fuse · blownDFW - AIRCRAFT EXPERIENCED RIGHT HYDRAULIC QUANTITY LOSS AND LANDING GEAR DOORS DAMAGED DURING LANDING DUE TO NO PRESSURE TO RETRACT ON LANDING. AIRCRAFT REMOVED FROM SERVICE. FOUND TWO BRAKE FUSES BLOWN AT LEFT WING SPAR. REPLACED HYDRAULIC FUSE AND HYDRAUSDR AALA20090512TUL67Cusp Web · corrodedCORROSION ON SUB-FLOOR AT STA 200 12 INCHES FORWARD OF NR 6 SEAT TRACK. REMOVED CORROSION ON SUB-FLOOR AT STA 200 12 INCHES FORWARD OF NR 6 SEAT TRACK AND INSTALLED / DOUBLER AT STA 200 TO 218 PER AARD 53-20-16-00.SDR AALA20090512TUL61Cusp Web · corrodedCORROSION ON RT CUSP AT STA 1168. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090512TUL65Angle · corrodedAFT CARGO J-ANGLE, RT SIDE OF L30, STA 1147-1155 CORROSION.SDR AALA20090512TUL64Seat Track · corrodedG-2 MOUNT, FWD END OF NR 6 SEAT TRACK HAS CORROSION. REMOVED AND REPLACED G-2 MOUNT AT FWD END OF NR 6 SEAT TRACK PER SRM 51-10-00.SDR AALA20090512TUL27Cusp Web · corrodedCORROSION ON RT CUSP. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090512TUL23Beam · corrodedCORROSION ON MID CARGO THRESHOLD BEAM. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-3SDR AALA20090512TUL21Cusp Web · crackedCRACK IN RT CUSP STA 802-807. NEW CUSP SHEET WAS INSTALLED PER AARD 53-20-00-16.SDR AALA20090512TUL20Longeron · crackedLONGERON L4 CRACKED. REMOVED AND REPLACED L4 FROM STA 148-226 PER SRM 53-02-00.SDR AALA20090512TUL19Doubler · damagedDAMAGE HOLE ON HORSE SHOE COLLAR DOUBLER AT STA 845 RT. NEW REPAIR DOUBLE WAS INSTALLED PER 51-30-05.SDR AALA20090512TUL16Intercostal · crackedINTERCOSTAL CRACKED BETWEEN FLOORBEAMS AT BL NR 0. INSTALLED NEW INTERCOSTAL PER SRM 51-30-02.SDR AALA20090512TUL17Cusp Web · corrodedCORROSION ON CUSP. REPLACED CUSP PER AARD 53-20-00-16.SDR AALA2009041600001Transponder · failedDEN - ON APPROACH AT 9000 FEET AIRCRAFT WAS STRUCK BY LIGHTNING CAUSING THE TRANSPONDERS TO FAIL. EMERGENCY DECLARED, LANDED DEN WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. ACCOMPLISHED LIGHTNING INSPECTION CARD 05-53-00-6. NO DAMAGE NOTED DUE TO LIGHSDR AALA20090512TUL55Cusp Web · corrodedCORROSION ON RT CUSP AT STA 196-200. REMOVED CORRODED AREA AND INSTALLED 7075-T6 DOUBLER PER AARD 53-20-00-16.SDR AALA20090512TUL36Structure · corrodedCORROSION ON SUBFLOOR AT STA 200, 12 INCH FORWARD OF NR 6 SEAT TRACK. INSTALLED DOUBLER AT STA 200 TO 218 PER AARD 53-20-16-00.SDR AALA20090512TUL15Cusp Web · corrodedCORROSION ON LT CUSP AT AFT SERVICE DOOR UNDER GIRT BAR BRACKET. INSTALLED REPAIR DOUBLER PER AARD 53-20-00-16.SDR AALA20090512TUL13Bracket · corrodedCORROSION ON LT CUSP UNDER GIRT BAR BRACKET AT AFT SERVICE DOOR. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090512TUL10Bracket · corrodedCORROSION ON FWD GIRT BAR BRACKET AT AFT SERVICE DOOR. INSTALLED NEW GIRT BAR BRACKET PER SRM, 51-01-00.SDR AALA20090512TUL09Bracket · corrodedCORROSION ON GIRT BAR FITTING BRACKET AT AFT SERVICE DOOR. INSTALLED NEW GIRT BAR BRACKET PER SRM 51-01-00.SDR AALA20090512TUL07Cusp Web · corrodedRT CUSP CORRODED. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA20090513TUL09Skin · dentedDENT IN FUSELAGE AT RT STA 355 ABOVE LONG 21R. COLD WORK DENT AND INSTALLED DOUBLER PER SRM 53-04 FIG 38.SDR AALA20090512TUL03Cusp Web · corrodedRT CUSP CORRODED. INSTALLED NEW CUSP SHEET PER SRM 51-01-00.SDR WX0A070288Battery 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 POWER SUPPLY BATTERY PACK. A SATISFSDR AALA20090423TUL01Pan · corrodedSKIN BULGING IN AREA OF AFT LAV SERVICE PANEL, FORWARD LOWER CORNER. REPAIRED PER EA MD80-53-005988 DATED 04/14/09. FOUND TO BE LEVEL 1 CORROSION.SDR AALA20090422TUL14Flashlight · inoperativeEMERGENCY HELD LIGHT INOPERATIVE. INSTALLED SERVICEABLE EMERGENCY LIGHT AT FORWARD ENTRY DOOR/FLIGHT ATTENDANT SEAT AREA AND PERFORMED OPERATIONAL CHECK PER MCM CARD 4289.SDR AALA20090415TUL05Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK WEAK FORWARD DROP DOWN CEILING PANEL. REPLACED BATTERY PACK AND CHECKED PER WORK CARDS 4289 AND 4854.SDR AALA20090512TUL41Rib · crackedSECOND RIB FROM OTBD END CRACKED ON LT WING NR 5 SLAT. REPLACED RIB PER ESO 80117.SDR AALA20090512TUL39Rib · wornSECOND RIB CRACKED FROM OTBD END ON RT WING NR 5 SLAT. REMOVED AND REPLACED RIB PER ESO 80117.SDR AALA20090512TUL08Stop · crackedAFT LOWER STOP PAD FITTING CRACKED ON AFT CARGO DOOR. INSTALLED NEW FITTING PER ESO 80174.SDR AALA20090512TUL05Seat Track · corrodedNR 3 SEAT TRACK CORRODED OUT OF LIMITS. INSTALLED PLUG REPAIR PER AARD 53-20-00-10.SDR AALA2009041400002Line · leakingDFW - HYDRAULIC LEAK AT RT INBOARD GEAR DOOR. AIRCRAFT REMOVED FROM SERVICE. FOUND HYDRAULIC SYSTEM RETURN LINE LEAKING IN RIGHT WHEEL WELL. REPLACED HYDRAULIC LINE FITTING AND PACKING. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20090415TUL04Frame · crackedSTATION 1485 CANTED FRAME WEB IS CRACKED AT UPPER HI-LOK IN THE LOUVER BOX ANGLE JUST OUTBOARD OF THE EMERGENCY LIGHT ASSEMBLY. INSTALLED DOUBLER PER AARD 53-10-00-32.SDR AALA20090415TUL03Skin · crackedSMALL CRACK AT FASTENER IN SKIN .25 INCH LONG AT STATION 1380 LONGERON 13R-14R. FABRICATED AND INSTALLED REPAIR DOUBLER PER AARD 53-30-00-02.
Back to Mcdonnell Douglas DC-9-82