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 AALA2009012900399Battery Pack · corrodedDFW - CAT WALK OVERHEAD EMERGENCY LIGHTS INOPERATIVE. CLEANED BATTERY CONTACTS AND CHARGED CELLS.SDR AALA2009012900398Battery Pack · dischargedDFW - OVERHEAD EMERGENCY LIGHTS FROM ROWS 17 THRU 21 INOPERATIVE. REPLACED BATTERY PACK FOR ROWS 17 THRU 21.SDR AALA2009012900397Lamp · burned outORD - EMERGENCY LIGHTS ON CEILING AT SEATS 18BCD, SEATS, 20BCD, SEATS 21BCD, AND SEATS 30D INOPERATIVE. REPLACED LAMPS AT SEATS 18BCD, 20BCD 21BCD AND 30D.SDR AALA2009012900396Battery Pack · dischargedLGA - EMERGENCY LIGHTS AT FORWARD GALLEY AREA INOPERATIVE. REPLACED BATTERY PACK AT FORWARD GALLEY AREA.SDR AALA2009012900395Battery Pack · dischargedLGA - EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK.SDR AALA2009012900394Battery Pack · not seatedLGA - EMERGENCY CEILING LIGHTS AT AFT STAIRWELL DOOR PANEL INOPERATIVE. RESEATED BATTERY PACK FOR AFT STAIRWELL DOOR PANEL.SDR AALA2009012900393Battery Pack · not seatedLGA - AFT INTERIOR OVERWING EXIT EMERGENCY LIGHTS INOPERATIVE. RESEATED BATTERY PACK AT AFT INTERIOR OVERWING EXIT.SDR AALA2009012900392Battery Pack · not seatedLGA - EMERGENCY CEILING LIGHTS INOPERATIVE. RESEATED BATTERY PACK.SDR AALA2009012900391Battery Pack · dischargedLGA - AFT EMERGENCY AISLE LIGHT INOPERATIVE. REPLACED BATTERY PACK AT AFT AISLE.SDR AALA2009012900390Battery Pack · not seatedLGA - EMERGENCY LIGHT AT AFT LAVATORY INOPERATIVE. RESEATED BATTERY PACK AT AFT LAVATORY.SDR AALA2009012900247Actuator · failedJFK - INFLIGHT BWI TO DFW. AFTER TAKEOFF NOSE GEAR WOULD NOT RETRACT. LANDED JFK WITHOUT INCIDENT. REPLACED NOSE LANDING GEAR RETRACT ACTUATOR AND NOSE GEAR SHOCK SEAL. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA2009021600136Stiffener · crackedCRACK AT TOP OF STIFFENER FORWARD SIDE PRESSURE BULKHEAD ABOVE VAULT DOOR. REMOVED AND REPLACED STIFFENER PER SRM 51-01-00.SDR AALA2009021600132Cusp Web · corrodedCORROSION BOTTOM SIDE OF RIGHT CUSP STATION 1275 TO 1295. INSTALLED NEW CUSP BETWEEN STATION 1250 AND 1309 PER AARD 53-20-00-16.SDR AALA2009021600130Cargo Track · corrodedLEFT TIE DOWN TRACK INBOARD SIDE CORRODED AT STATION 1214 OF AFT CARGO. INSTALLED NEW SPLICE PER SRM 51-10-03.SDR RYNA2009012900002Pump · malfunctionedON DESCENT WITH TRANSFER PUMP & AUX PUMPS ON AND BOTH HYD PUMPS SET IN HIGH POSITION. RT HYD PUMP PRESS LOW AT APPROX 2000 PSI (LEFT PRESS NORMAL). ON FINAL APPROACH GEAR EXTENSION RESULTED IN BOTH MLG DOWN AND LOCKED. NLG EXTENSION (RED NOSE LIGHT ON & VISSDR AALA2009012800386Battery Pack · dischargedLGA - EMERGENCY LIGHTS IN FIRST CLASS INOPERATIVE. REPLACED BATTERY PACK IN FIRST CLASS.SDR AALA2009012800385Battery Pack · dischargedLGA - EMERGENCY CEILING LIGHTS IN FORWARD ENTRY INOPERATIVE. REPLACE BATTERY PACK IN FIRST CLASS.SDR AALA2009012800384Power Supply · inoperativeLGA - CEILING EMERGENCY LIGHTS ABOVE ROWS 5 AND 6 INOPERATIVE. REPLACED POWER SUPPLY AT ROW 6.SDR AALA2009012800383Power Supply · inoperativeLGA - EMERGENCY CEILING LIGHTS IN FORWARD ENTRY INOPERATIVE. REPLACED POWER SUPPLY AT ROW 6AB.SDR AALA2009012800370Battery Pack · dischargedLGA - CEILING EMERGENCY LIGHT AT ROW 6 INOPERATIVE. REPLACED BATTERY PACK AT ROW 6.SDR AALA2009021600128Door Frame · corrodedCORROSION ON VERTICAL AND HORIZONTAL LEG OF DOOR JAMB BEAM AT MID CARGO. INSTALLED DOUBLER IN ACCORDANCE WITH 53 10 00 3.SDR AALA2009021600126Skin · crackedSKIN CRACKED AT CANT STATION 1474 LONGERON 24 LEFT. INSTALLED DOUBLER PER SRM 53-01-00 PG 12.SDR AALA2009021600124Cargo Track · corrodedAFT CARGO LEFT TIE DOWN TRACK CORRODED AT STATION 1117 TO 1212. INSTALLED NEW TIE DOWN TRACK PER SRM 51-30.SDR AALA2009012700373Battery Pack · not seatedLGA - CEILING EMERGENCY LIGHTS BETWEEN ROWS 27 THRU 32 INOPERATIVE. RESEATED BATTERIES IN CHARGER.SDR AALA2009012700372Battery Pack · dischargedLGA - CEILING EMERGENCY LIGHTS BETWEEN ROWS 4 THRU 7 INOPERATIVE. REPLACED CHARGER AND BATTERIES FOR CEILING EMERGENCY LIGHTS.SDR AALA2009012700371Battery Pack · not seatedLGA - TAIL CONE EMERGENCY LIGHTS INOPERATIVE. RESEATED BATTERIES IN CHARGER.SDR AALA2009021600122Seat Track · corrodedNUMBER 5 SEAT TRACK BLENDED OUT OF LIMITS. INSTALLED NEW SEAT TRACK AND SPLICE PER SRM 53-05-00.SDR AALA2009021600121Cusp Web · corrodedRIGHT CUSP CORRODED AT STATION 1161 TO 1174. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA2009021600119Cusp Web · crackedCRACK ON LEFT CUSP BETWEEN STATION 218 AND 237. INSTALLED CUSP SHEET PER AARD 53-20-10-16.SDR AALA2009012600358Battery Pack · dischargedLGA EMERGENCY LIGHTS FROM ROW 7 THRU 11 INOPERATIVE. REPLACED BATTERY PACK FOR ROWS 7 THRU 11.SDR AALA2009012600194Downlock Sensor · failedDFW INFLIGHT - ON APPROACH MAIN LANDING GEAR INDICATION WAS GREEN FOR ABOUT TWO SECONDS AND THEN WENT TO RED. HYDRAULIC PRESSURE NORMAL. RECYCLED GEAR AND ABORTED APPROACH. LANDING GEAR GREEN LIGHTS ON THIRD TRY LANDING GEAR INDICATION WAS GREEN. LANDED DFSDR AALA2009021600138Skin · dentedDENT IN SKIN AT RIGHT STATION 213 BETWEEN LONGERON 24 RIGHT AND LONGERON 25 RIGHT. AREA OF DISCREPANCY IS 4.3 INCHES AND .248 INCH DEEP. INSTALLED DOUBLER CLASS I PER SRM 53-04-00 FIGURE 12B PAGE 36 SHEET 4.SDR AALA2009021600117Seat Track · corrodedCORROSION ON NUMBER 2 SEAT TRACK. REPLACED SEAT TRACK PER SRM 51-01-00.SDR AALA2009021600115Cusp Web · crackedRIGHT CUSP CRACKED STATION 1244. INSTALLED DOUBLER PER AARD 53-20-00-16.SDR AALA2009021600114Bracket · crackedSEAT TRACK BRACKET CORRODED AT STATION 864. AREA OF DISCREPANCY IS 4 INCHES BY 4 INCHES. REPLACED SEAT TRACK BRACKET PER SRM 51-01-00.SDR AALA2009012500357Battery Pack · not seatedLGA - OVERWING EMERGENCY LIGHTS LEFT TO RIGHT INOPERATIVE. BATTERIES RESEATED IN CHARGER FOR OVERWING EMERGENCY LIGHTS.SDR AALA2009012500345Battery Pack · dischargedLGA - EMERGENCY LIGHTS BY LEFT NUMBER 1 DOOR INOPERATIVE. REPLACED BATTERY PACK BY LEFT NUMBER 1 DOOR.SDR AALA2009012500188Cylinder · leakingORD INFLIGHT - RIGHT HYDRAULIC QUANTITY WENT TO ZERO IN FLIGHT. LANDED ORD WITHOUT INCIDENT. FOUND BLOWN CYLINDER SEAL IN THE RIGHT WHEEL WELL. REPLACED CYLINDER. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA2009012400343Charger · inoperativeLGA - EMERGENCY LIGHTS AT AFT STAIRS INOPERATIVE. REPLACED CHARGER AT AFT STAIRS.SDR AALA2009012300342Battery Pack · dischargedLGA - EMERGENCY LIGHTS AT AFT STAIRS INOPERATIVE. REPLACED BATTERY PACK AT AFT STAIRS.SDR AALA2009021600137Cusp Web · corrodedCORROSION ON LEFT CUSP OUTER EDGE AT CENTER LIGHTING HOLE BETWEEN STATION 636 TO 655. REMOVED CORROSION PER SRM 53-01 AND INSTALLED DOUBLER REPAIR PER AARD 53-20-00-10.SDR AALA2009012300339Battery Pack · dischargedLGA - EMERGENCY ESCAPE PATH LIGHTING INOPERATIVE. REPLACE BATTERY PACK FOR EMERGENCY ESCAPE PATH LIGHTING.SDR AALA20090417TUL02Static Port · debondedLEFT STATIC CASTING IS DISBONDED FROM SKIN AT STATION 465 AND LONGERON 27 LEFT. REMOVED AND INSTALLED SERVICEABLE STATIC PORT CASTING PER MM 53-30-00-7, RVSM CHECK ACCOMPLISHED PER E-58 6256771.SDR AALA2009021600140Skin · crackedATTACH TAB CRACKED FROM FRAME TO LONGERON 11 LEFT AT STATION 207 AFT OF FORWARD ENTRY DOOR. INSTALLED REPAIR STRAP PER AARD 53-10-00-11.SDR AALA2009021600134Stop · crackedFORWARD LOWER DOOR STOP PAD CRACKED. INSTALLED NEW DOOR STOP SUPPORT FITTING PER ESO 80174.SDR AALA2009021600112Cusp Web · crackedCORROSION AND CRACK ON LEFT CUSP AT STATION 965 TO 984. REMOVED DAMAGE AND INSTALLED DOUBLER IN ACCORDANCE WITH AARD 53 20 00 16.SDR AALA2009021600135Pan · crackedRIGHT WINDOW PAN AT UPPER CORNER STATION 1231 CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA2009021600133Window Frame · crackedLOWER WINDOW FRAME TAB CRACKED AT LEFT STATION 1022 TO 1041. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25, MSR 018352.SDR AALA2009021600131Window Frame · crackedFORWARD LOWER WINDOW FRAME TAB AT LEFT STATION 1079 TO 1098 CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25, MSR 018339.SDR AALA2009021600129Window Frame · crackedAFT UPPER WINDOW FRAME TAB CRACKED AT LEFT STATION 1022 TO 1041. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25 MSR 018353.
Back to Mcdonnell Douglas DC-9-82