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 AALA20111129TUL08Pan · crackedCRACK AT LEFT WINDOW PAN LOWER FORWARD CORNER, STATION 1022. ACCOMPLISHED NESTED ANGLE REPAIR PER AARD 53-10-00-25.SDR AALA20111129TUL07Shear Tie · crackedSHEAR TIE CRACKED AFT SIDE LONGERON 2 LEFT. REPLACED SHEAR TIE PER SRM 53-01-00.SDR AALA20111129TUL06Cusp Web · corrodedLEFT CUSP STATIONS 302 TO 303 CORROSION OUT OF LIMITS. ACCOMPLISHED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA20111127TUL07Circuit Breaker · defectiveABQ - INFLIGHT DFW-SJC. CREW REPORTED BOTH AUTOPILOTS, YAW DAMPER AND MACH TRIM FAILED. EMERGENCY DECLARED FLIGHT DIVERTED ABQ LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. SWAPPED OUT CIRCUIT BREAKER C17 WITH C15 DUE TO DFGS SWITCH A THAT WAS DESDR AALA20111123DWH01Stringer · damagedFOUND 2 CRACKED STRINGERS JUST ABOVE A DENT AT STATION 218 LONGERON 17. REPAIRED WITH SPLICE PER SRM 53-02-00 FIGURE 18.SDR FOTR2011112315020Spar · corrodedLT WING T/E LOWER AFT SPAR CAP CORRODED OTBD OF AILERON. REPAIRED ON FASI WO 21186, NR 15020.SDR FOTR2011112315114Spar · corrodedLT WING STA XRS 454 APPROX REAR SPAR LOWER SPAR CHORD HAS CORROSION. REPAIRED ON FASI WO 21186, NR15114.SDR FOTR2011112015007Floorboard · puncturedMAIN CABIN FLOORBOARD HAS MULTIPLE PUNCTURES AND DAMAGED INSERTS ON UPPER AND LOWER SURFACE FS 769-807, RBL54 TO LBL 62. REPAIRED ON FASI WO 21186, NR 15007.SDR FOTR2011112014801Support · gougedFWD E & E DOOR CUTOUT SUPPORT HAS A GOUGE ON FWD SIDE. REPAIRED ON FASI WO21186, NR14801.SDR FOTR2011112015030Floorboard · damagedMAIN DECK METAL FLOORBOARD LOWER SURFACE SUPPORTS ARE CRUSHED IN MULTIPLE AREAS RBL 44-52, FS 927-1003. REPAIRED ON FASI WO 21186, NR 15030.SDR FOTR2118614968Cargo Track · damagedAFT CARGO PIT RT FLOOR TRACK HAS A DOUBLE DRILLED HOLE AT STA 1195, RBL 17. REPAIRED ON FASI WO 21186, NR 14968.SDR FOTR2011111915013Floor Panel · damagedSCREW EMBEDDED IN LOWER SURFACE OF CABIN FLOOR PANEL STA656 LBL30. REPAIRED ON FASI WO 21186, NR 15013.SDR FOTR2011111915351Floor Panel · damagedMAIN CABIN FLOOR PANEL CENTER SECTION FROM FS 1338-1039 IS DAMAGED. REPAIRED ON FASI WO 21186, NR 15351.SDR FOTR2011111915315Floorboard · crackedFWD ENTRY MAIN DECK FLOORBOARD IS CRACKED FS 120-148, RBL48 TO RBL 62.5. REPAIRED ON FASI WO 21186, NR 15315.SDR FOTR2011111915313Floorboard · crackedFWD ENTRY, MAIN DECK FLOORBOARD IS CRACKED FS 120-148, BL0 TO LBL24.5. REPAIRED ON FASI WO 21186, NR 15313.SDR FOTR2011111915243Floorboard · delaminatedMAIN CABIN FLOORBOARD IS VERY SPONGEY AND APPEARS DELAMINATED, FS 1022-1041, LBL 22 TO RBL 22. REPAIRED ON FASI WO 21186, NR 15243.SDR FOTR2011111814760Torque Box · corrodedAFT CARGO DOOR CUTOUT LOWER TORQUE BOX INTERNAL CHORD APPROX FS 1207 HAS MULTIPLE TOOLING MARKS AND AREAS OF CORROSION. REPAIRED ON FASI WO 21186, NR14760.SDR FOTR2011111815077Frame · corrodedCORROSION AFT CARGO PIT BILGE AREA LWR AND AFT SURFACE OF FRAME 1309 FROM LONGERON 29L TO 28R. REPAIRED ON FASI WO21186, NR 15077.SDR FOTR2118614938Floorboard · crackedLEFT MAIN DECK METAL FLOORBOARD LOWER SURFACE SUPPORTS CRACKED AND DISBONDING, LBL 44-52, FS 927-1003. REPAIRED ON FASI WO21186, NR 14938.SDR FOTR2011111814871Cargo Track · damagedAFT CARGO PIT LEFT CARGO TRACK HAS BLOWN OUT HOLES WITH NO EDGE DISTANCE DRILLED IN THE INBD SIDE OF SCALLOP LBL 15 BETWEEN STA 1098 AND 1117. REPAIRED ON FASI WO 21186, NR 14871.SDR FOTR2118615052Shear Tie · corrodedCORROSION AFT CARGO PIT BILGE SHEAR TIE FWD AND AFT SIDE STA 1250, RBL 3 BETWEEN LONGERON 30 AND LONGERON 29R. REPAIRED ON FASI WO21186, NR 15052.SDR FOTR2011111815056Frame · corrodedCORROSION AND BARE METAL AFT CARGO PIT BILGE AREA ON LWR AFT SIDE OF FRAME STA 1250 BETWEEN LONGERON 28L AND 29R. REPAIRED ON FASI WO21186, NR15056.SDR FOTR2118615292Shear Tie · corrodedBS 1174 AT LONGERON 29R SHEAR TIE IS CORRODED ON FWD AND AFT SIDE. REPAIRED ON FASI WO21182, NR15292.SDR FOTR2118615372Floorboard · damagedBS 875, RBL 44, FLOORBOARD COVERING CENTER FUEL TANK ACCESS PANEL IS DAMAGED. REPAIRED ON FASI WO21186, NR15372.SDR FOTR2011111715314Floorboard · crackedFWD ENTRY MAIN DECK FLOORBOARD IS CRACKED FS 157-200, LBL 12-LBL 50. REPAIRED ON FASI WO 21186, NR 15314.SDR FOTR2118615084Longeron · corrodedCORROSION AFT CARGO PIT BILGE AREA STA 1297 IN LONGERON CHANNEL AT LONGERON 28L. REPAIRED ON FASI WO21182, NR15084.SDR AALA20111116TUL03Cusp Web · corrodedLEFT CUSP STATIONS 1088 TO 1091 CORROSION BEYOND LIMITS. REMOVED DAMAGE AND INSTALLED DOUBLER REPAIR PER AARD 53-20-00-16.SDR AALA20111116TUL01Pan · crackedCRACK IN LEFT RINGPAN AT UPPER AFT CORNER. REMOVED CRACK AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR FOTR2118615061Frame · damagedAFT CARGO PIT DOUBLE DRILLED HOLE FRAME, STA 1271, LBL 2. REPAIRED ON FASI WO 21186, NR 15061.SDR FOTR2118615249Cusp Web · corrodedLEFT MAIN DECK CUSP WEB SHOWS CORROSION AT FWD AIR GRILL ATTACH ANGLE FS 598-617. REPAIRED ON FASI WO 21186, NR 15249.SDR AALA20111116LGA01Battery Pack · not seatedLEFT AND RIGHT HAND FORWARD OVERWING DOOR UPPER EXIT SIGNS INOPERATIVE. RESEATED BATTERIES IN CHARGER. OPS CHECK NORMAL.SDR AALA20111115TUL04Skin · dentedDENTS IN SKIN AT STATION 256. INSTALLED DOUBLER REPAIR PER BOEING DRAWING SG09530002.SDR FOTR2118614580Vane · corrodedRIGHT WING OTBD FLAP OTBD FIXED VANE HAS SURFACE CORROSION ON VANE SUPPORT LWR SURFACE. REPAIRED ON FASI WO 21186, NR 14580.SDR FOTR2118615227Cusp Web · corrodedRIGHT MAIN DECK CUSP WEB EXFOLIATED FS 655-674. REPAIRED ON FASI WO 21186, NR 15227.SDR FOTR2118614935Web · chafedLEFT MAIN DECK FLOOR WEB CHAFED, LBL 44-52, FS 864. REPAIRED ON FASI WO 21186, NR 14935.SDR AALA20111114DFW01Unknown · odorDFW - CAPTAIN REPORTED SLIGHT POWER INCREASE THEN LOUD CRACK/BOOM SOUND WAS HEARD WITH SLIGHT SHAKING IN STICK NO FLUCTUATIONS IN PARAMETERS WERE NOTED. STRONG BURNING SMELL WAS INSIDE CABIN AND COCKPIT WAS THEN NOTED. EMERGENCY DECLARED FLIGHT LANDED DFW WISDR FOTR2118614774Skin · dentedDEEP CREASE IN LOWER FUSELAGE SKIN- AFT OF AFT CARGO DOOR- STA 1256 BETWEEN LONGERONS 28R-27R. REPAIRED ON FASI WO 21186, NR 14774.SDR AALA20111114LGA01Battery Pack · malfunctionedRIGHT NUMBER 1 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. RESET BATTERY PACK AT FORWARD OVERHEAD CEILING PANEL. OPS CHECK NORMAL.SDR AALA20111113TUL03Duct · leakingSHV - INFLIGHT DFW-EWR. CREW NOTICED ODOR IN THE COCKPIT ACCOMPANIED BY TAIL COMPARTMENT HIGH TEMPERATURE INDICATION. EMERGENCY DECLARED AND ON DESCENT INTO SHV CABIN PRESSURIZATION WAS LOST. FLIGHT LANDED SHV WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICSDR WX0A0071005Battery · dischargedLEFT SIDE LOWER SIDEWALL OVERWING EMERGENCY LIGHTS INOP. DURING 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 REPSDR WX0A071004Battery · dischargedTAIL CONE EMERGENCY LIGHTS INOP. DURING 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 BASDR WX0A071003Battery · dischargedROW 32-33 EMERGENCY LIGHTS INOP. DURING 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 BASDR FOTR2118615234Cusp Web · corrodedRIGHT MAIN DECK CUSP WEB SHOWS CORROSION ON TOP OF SURFACE FS 1287-1309. REPAIRED ON FASI WO21186, NR15234.SDR FOTR2118615251Cusp Web · corrodedLEFT MAIN DECK CUSP WEB SHOWS MULTIPLE AREAS OF CORROSION AT LIGHTNING HOLE AND AIR GRILL ATTACH ANGLE FS 541-560. REPAIRED ON FASI WO21186, NR15251.SDR AALA20111109DFW02Control Unit · inoperativeDFW - CREW REPORTED ALL INSTRUMENTS, COCKPIT LIGHTS, CHIMES AND BELLS STARTED FLASHING. FOUND RIGHT ENGINE GENERATOR INOPERATIVE. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED BCU. SYSTEM GROUND CHSDR AALA20111110LGA02Battery Pack · not seatedCEILING EMERGENCY LIGHTS FROM ROWS 18 TO 21 INOPERATIVE. RESEATED BATTERY PACK. OPS CHECKS NORMAL.SDR AALA20111110LGA01Battery Pack · not seatedCEILING EMERGENCY LIGHTS FROM ROWS 7 TO 11 INOPERATIVE. RESEATED BATTERY PACK. OPS CHECKS NORMAL.SDR FOTR2118614934Web · corrodedLEFT MAIN DECK WEB CHAFED IN MULTIPLE LOCATIONS ON UPPER SURFACE LBL-44 TO LBL-52, FS 807-845. REPAIRED ON FASI WO 21186, NR 14934.SDR AALA20111109LGA01Battery Pack · dischargedOVERHEAD AISLE EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK AT SEAT 28DEF. OPS CHECK NORMAL.SDR AALA20111108TUL04Frame · crackedTHE 1510 CANT FRAME CRACKED AT TAIL CONE ALIGNMENT PIN BELOW RIGHT LOWER TAIL CONE LATCH. INSTALLED DOUBLER PER EA MD80-53-020087 REVISION A.
Back to Mcdonnell Douglas DC-9-82