Service difficulty reports
1,771,708 reports of malfunctions and defects, newest first. Air carriers must report; 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' 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' 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 SWAA2025090804491Floorbeam · corrodedCORROSION ANGLE FLOOR STRUCTURE ON BS 695 AT LEVEL STR 18L AND LBL 64 AT PASSENGER CABIN. REPLACED ANGLE AND FASTENERS LOCATED ON FLOOR STRUCTURE ON BS 695 AT LEVEL STR 18L AND LBL 64 AT PASSENGER CABIN IAW SRM 51-40-02-0G-0 AND DWG# 144A7730; SHEET 9; REV SDR SWAA2025090804742Angle · corrodedCORROSION ANGLE LOCATED BS706 RBL64 WL203.1 AT PASSENGER CABIN. REPLACED ANGLE AND FASTENERS LOCATED BS706 RBL64 WL203.1 AT PASSENGER CABIN IAW SRM 51-40-02 AND DWG 144A7700 SHEET 130 REV-.SDR SWAA2025090804744Web · corrodedCORROSION WEB LOCATED BS663.5 RBL64 WL203.1 AT PASSENGER CABIN. REPLACED WEB LOCATED BS663.5 RBL64 WL203.1 AT PASSENGER CABIN IAW SRM 51-40-02 AND DRAWING #144A7730 SHEET 12 REV -.SDR IPXA2025090571710Skin · cracked(STR) LH WING L.E. #19 SLAT TRACK CUT OUT O/B SIDE SKIN SURFACE HAS CRACKED AS MARKED.74-016 ATA CODE 57 AUDITED.CUT OUT AND REMOVED THE DAMAGE IN LH WING FIXED L/E AT #19 SLAT TRACK CUT OUT O/B SKIN SURFACE STA XOS=1160 REF. MD-11 SRM 57-40-01-2R-9.FABRICATEDSDR AALA202509082357Hinge Fitting · seizedAIRCRAFT IN BASE MAINTENANCE: DURING REMOVAL ON RIGHT ELEVATOR FOUND HARDWARE STUCK ON HINGE#4. REPLACED HINGE-ARM END FITTING PER AMM 55-16-42.SDR SWAA2025090504735Floorbeam · crackedCRACK ANGLE FLOOR STRUCTURE ON BS 694 AT BL 0 AND WL 203.1 AT PASSENGER CABIN. REPLACED ANGLE 1(E/A) AND FASTENERS LOCATED ON FLOOR STRUCTURE ON BS 694 AT BL 0 AND WL 203.1 AT PASSENGER CABIN IAW SRM 51-40-02 AND DWG 273A9110 SHEET 6 REV-A.SDR SWAA2025090504492Floorbeam · corrodedCORROSION ANGLE FLOOR STRUCTURE ON BS 706 AT LEVEL STR 18L AND LBL 64 AT PASSENGER CABIN. REPLACED ANGLE FLOOR STRUCTURE ON BS 706 AT LEVEL STR 18L AND LBL 64 AT PASSENGER CABIN AND FASTENERS IAW SRM 51-40-02 AND DWG 144A7730 SHEET 7 REV-.SDR SWAA2025090404740Angle · corrodedCORROSION ANGLE LOCATED BS705 RBL64 WL203.1 AT PASSENGER CABIN . REPLACED ANGLE AND FASTENERS LOCATED BS705 RBL64 WL203.1 AT PASSENGER CABIN IAW B737-700 SRM 51-40-02 AND DWG 144A7730 SHEET 8 REV:-.SDR IPXA2025081966036Skin · wornMAJOR REPAIR, DURING PERFORMANCE OF EO-85445-JIC 1, FOUND FASTENER HOLES (CODE G) WORN NEAR FRONT SPAR AREA AT ELEVATOR STA 244.3. I.A.W AMM 51-24-11-477-083 REV 48, REPAINT REWORK AREA.SDR SWAA2025090304630Floorbeam · crackedCRACK ON FLOORBEAM AT STA 540 BTW LBL24.75 AND LBL45.5 PASSENGER CABIN., REPLACED PANEL BRAKE ASSY AND FASTENERS LOCATED AT STA 540 BTW LBL24.75 AND LBL45.5 PASSENGER CABIN IAW B737-700 SRM 51-10-02 Ï¿½TEM 9; SRM 51-40-02 AND DWG: 143A0060 SHEET: 46 REV: - .SDR IPXA2025090270617Strap · corrodedFWD CARGO COMPT, BS 800-820 CEILING DECOMPRESSION PANEL SUPPORT HAS CORROSION AND (1EA) NUTPLATE LOOSE. STRAP INSTALLED ACCORDING TO IAW SRM 51-40-02. INSTALLED ANGLES (4 EA) ON FWD CARGO COMPT, STA 800-820 CEILING DECOMPRESSION PANEL, IAW B757-200PF, SRM 51-SDR IPXA2025090271962Tee Fitting · corrodedLOWER CENTER FUSELAGE, STA 1040-1060 LBL 40, LT PACK EXHAUST SUPPORT INTERCOSTAL TEE FITTING HAS EXFOLIATION. INSTALLED 1 NEW TEE FITTING IAW SRM-51-40-02.SDR IPXA2025082770574Support · corrodedFWD CARGO COMPT, BS 580 - 600 CEILING DECOMPRESSION PANEL SUPPORT HAS CORROSION. INSTALLED NEW SUPPORT PANEL IN FWD CARGO COMPT BS 580 - 600 CEILING DECOMPRESSION IAW B757-200 SRM 51-40-02-0G SRM 51-70-13-0G-0.SDR IPXA2025090270230Tee Fitting · corrodedLEFT AFT BODY FAIRING BS 1220, LBL 65, TEE FITTING HAD CORROSION. INSTALLED A NEW TEE FITTING IAW SRM 51-40-02-0G.SDR IPXA2025090276350Skin · ground damageFAULT-COMP-Z500- LH WING, SLAT 4 AREA, FIXED L/E SKIN, BY I/B MAIN TRACK, HAS COMPOSITE BROKEN. INSTALLED NEW PANEL ASSY-UPPER SKIN OTBD FIXED L/E. IAW B757-200PF, SRM 51-40-02. REVIEWEDSDR SIMA20250814001Seal Rest · corrodedSSI 53-21-009 FWD CARGO DOOR CUTOUT LWR SILL LWR SURFACE HAS NUMEROUS SCREW HOLES CORRODED. (MAJOR REPAIR) (LEVEL 2 CORROSION). RAR FWD CARGO DOOR CUTOUT LWR SILL LWR IAW ERJ 175 SRM 51-40-08SDR AALA202509024926Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND AFT PASSENGER / CREW DOOR CUT OUT LOWER FORWARD CORNER SHAPE FITTING AT FR 66 AND S23R. REPLACED FORWARD CORNER SHAPE FITTING PER SRM 51-72-11.SDR AALA202509022610Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND AFT PASSENGER / CREW DOOR CUT OUT LOWER AFT CORNER SHAPE FITTING AT FR 68 AND S23R. REPLACED AFT CORNER SHAPE FITTING PER SRM 51-72-11.SDR IPXA2025082965432Duct · crackedNUMBER 1 ENG LPT ACC MANIFOLD 6:00 POS.I.A.W. AMM 75-24-03-004-050-H00 REV.145 AND AMM 75-24-03-404-037-H00 REV.145 REPLACED THE DUCT.SDR 2025FA0000589Exhaust Valve · departedAIRCRAFT WAS IN CRUISE FLIGHT IN BANNER TOW CONFIGURATION. A LOUD AUDITABLE BANG WAS HEARD. ENGINE EXPERIENCED EXTREME VIBRATION FOLLOWED BY TOTAL LOSS OF POWER. PILOT CONDUCTED A FORCED LANDING IN A SOCCER FIELD. UPON ENGINE INSPECTION, #2 CYL. EXPERIENCESDR SWIA2025082500014Smoke Detector · false activationCREW REPORTS 2 LAV SMOKE TOILET IN CRUISE 32000 (FLIGHT 5070) REPLACEMENT AND OPS CHECK OF THE LAV SMOKE DETECTOR. AMM 21-51-10-000-801 SUBTASK 21-51-00-210-001 & VISUALLY INSPECT THE INLET FACE & CORE OF THE RT DUAL HEAT EXCHANGER AND FAN SECTION OF THE ACMSDR CALA2025082508073Battery Pack · dischargedPASSENGER CABIN EMERGENCY LIGHT BATTERY PACK M1673 FAILS CAPACITY CHECK. REPLACED BATTERY PACK M1673 IAW B737 AMM 33-51-06-960-805 AND AM M 33-51-00-710-801 OPS CHECK GOOD.SDR SWAA2025082204462Isolation Mount · damagedAFT SERVICE DOOR FWD UPPER ESCAPE SLIDE MOUNTING ASSY HAS 2 EA DAMAGED ISOLATORS.<[01] ALL STEPS COMPLETED REMOVED ASD ESCAPE SLIDE MOUNTING ASSY AND BACKPLATE PER SRM 51-40-02 & BOEING DWG 149A9480 REV: - SHEET 27 REMOVED AND REPLACED DAMAGED ASD FWD UPPER ESSDR SWAA2025082204445Battery Pack · inoperativeL/H OVERWING EMERGENCY LIGHT BATTERY PACK INOP AT. STA 565L<[01] REMOVED AND REPLACED BATTERY PACK PER MM 33-51-06;[02] L/H OVERWING EMERGENCY LIGHTS OPS CHECKED GOOD PER MM 33-51-06SDR ASMF2025082200219Warning Light · false activationENGINE CONTROL LIGHT IS ON FOR ENGINE 2 (732 201 52) DURING ENGINE START MESSAGE CLEARED NO FAULTS NOTED IAW IFIM TASK G80.00.00.810-857SDR 3EJA2025082200004Sensor · failedAFTER FLAPS CAME UP, POINTER INDICATED UP BUT THE AIRCRAFT WAS STILL SPEED LIMITED TO 200 KNOTS ON SPEED TAPE. CYCLING THE FLAPS DID NOT CLEAR THE ISSUE AND PROBLEM STILL REMAINS AFTER RETURNING TO FIELD. HYD PRESS DID GO OUT AS NORMAL.SDR 3EJA202508220014Warning Light · illuminatedI OBSERVED THE RED GEAR UNLOCK LIGHT WAS ILLUMINATED. OBSERVED A HYD PRESS ANNUNCIATOR AND STAB MIS COMP ANNUNCIATOR LIGHT WAS ILLUMINATED.SDR 3EJA202508221425Hose · wornCAB, DOOR ILLUMINATED AT APPROX 11,000 FT CAB ALT, ILLUMINATED AT APPROX 13200 CAB ALT INDICATED 10,000FT ON INDICATOR MADE IMMEDIATE DECENT TO 10000 AND RETURNED TO JAX DURING DECENT CAB ALT AND CABIN DOOR WENT OUT. PURGED DOOR SEAL AND REPLACED DEFECTIVE CABSDR AALA202508202898Pressure Switch · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT AFT FUEL PUMP LOW PRESSURE LIGHT ILLUMINATED DURING LEVEL FLIGHT. REMOVE AND REPLACED LEFT HAND AFT LOW PRESSURE SWITCH. PER AMM 28-42-11.SDR AALA202508209706Light · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY ASILE PATH LIGHTING FIXTURE AT ROW 25 IS HANGING DOWN OFF SEAT EDGE. REMOVE AND REPLACED EMERGENCY LIGHT AISLE LIGHT ROW 25ABC. PER AMM 33-51-00.SDR AALA202508202617Light · dislodgedAIRCRAFT WAS NOT GROUNDED: SEAT 24C EXIT PATH LIGHT IS DANGLING FROM SEAT. REPLACED SEAT EMERGENCY LIGHT ASSEMBLY AT SEAT 24C. PER AMM 33-51-00.SDR AALA202508200939Flashlight · not seatedAIRCRAFT WAS NOT GROUNDED: ONE FLASHLIGHT AT THE AFT LEFT FLIGHT ATTENDANT JUMPSEAT POSITION FAILS THE TEST. THE GREEN LIGHT DOES NOT ILLUMINATE. RESEAT FLASHLIGHT, OPERATIONAL CHECK NORMAL. PER AMM 25-64-00.SDR AALA202508201370Flashlight · not seatedAIRCRAFT WAS NOT GROUNDED: BOTH FLASHLIGHTS AT THE FORWARD FLIGHT ATTENDANT JUMPSEAT POSITIONS FAIL THE TEST. THE GREEN LIGHT DOES NOT ILLUMINATEM. RESEATED LIGHT, PER AMM 25-64-00. OPERATIONAL CHECK NORMAL.SDR AALA202508205498Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: 1R GIRT BAR DOES NOT COME OUT OF THE CLIPS CORRECTLY. EXTREMELY DIFFICULT TO PULL OUT AND CAUSES UNSAFE CONDITION WHILE ATTEMPTING TO ARM. ADJUSTED GRIT BAR RETAINER CLIPS, PER AMM 25-66-00.SDR AALA202508207275Pressure Switch · failedAIRCRAFT WAS GROUNDED: LOW PRESSURE INDICATION WHEN LEFT AFT MAIN FUEL PUMP TURNED ON. REMOVED AND REPLACED LEFT AFT MAIN FUEL PUMP LOW PRESSURE SWITCH. PER AMM 28-42-11. OPERATIONAL CHECK NORMAL.SDR DALA2025081906218Interface Unit · faultedATB DUE TO LOSS OF VHF AND INTERPHONE COMMUNICATIONS FROM THE FLIGHT DECK. REPLACED RADIO INTERFACE UNIT (RIU)1 AND THE CAPTAINS MIC JACK. (LP# 7750241)SDR DALA2025081906215Frame · not reportedFRAME REPLACED ON WORKCARD 5352-01038-08A ASSOCIATED AA 5352-01038 ADDED FOR AC 8302. (LP# 7852131)SDR DALA2025081906214None · noneSDR LOG CREATED PER WORKCARD 5352-01038-07A. MFG P/N C02383111-001 REPLACED ON WORKCARD 5352-01038-07A ASSOCIATED AA 5352-01038 ADDED FOR AC 8302. (LP# 7852130)SDR DALA2025081906211Seat Track · corrodedCORROSION ON PASSENGER CABIN SEAT TRACK RBL 22 BETWEEN FR20 TO FR 22. REMOVED AND REPLACED SEAT TRACK AT RBL 23 FR20-30 IAW BOMBARDIER DWG C02312600 REV E. (LP# 1142990)SDR YENA2025081900851Computer · failedFLT #2144, PBI-EWR. DURING CLIMBOUT 310KTS FL260 SHIMMY SHUDDER FELT LIGHT INTONSITY WITH MANUAL ROLL INPUTS VIBRATION STOPED RETURED WITH AP ON DIMINISHED CLIMBING THROUGH FL330 SURVEY FORM COMPLETED DFDR PUSHED; INSPECTED AILERON SERVO AND HINGE BEARINGS FORSDR YENA2025081900850Computer · failedFLT #2144, PBI-EWR. DURING CLIMBOUT 310KTS FL260 SHIMMY SHUDDER FELT LIGHT INTONSITY WITH MANUAL ROLL INPUTS VIBRATION STOPED RETURED WITH AP ON DIMINISHED CLIMBING THROUGH FL330 SURVEY FORM COMPLETED DFDR PUSHED; INSPECTED AILERON SERVO AND HINGE BEARINGS FORSDR AALA202508193872Access Door · stuckAIRCRAFT WAS NOT GROUNDED: MANUAL GEAR EXTENSION ACCESS DOOR IS STUCK SHUT. VERIFIED MANUAL GEAR EXTENSION ACCESS DOOR STUCK. LUBRICATE DOOR, PER AMM 32-34-00. OPERATIONAL CHECK GOOD.SDR AALA202508193120Slide · unsecureAIRCRAFT WAS NOT GROUNDED: L1 DOOR SLIDE HANGING OUT OF CASE ON DOOR. RESECUREDL1 SLIDE PACK AS REQUIRED. PER AMM 25-66-01.SDR IPXA2025081976192Floor Panel · damagedMAJOR REPAIR, FLOOR PANEL FROM STA 1865 TO STA 1940 LBL 75.92 TO LBL 33.69 IS SPOMGEE INSTALLED AND SEALED AND TAPE FLOOR PANEL REF AMM 53-21-02.SDR AALA202508195512Processor · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: WEATHER RADAR FAILED. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT MIA. REMOVED AND REPLACED WEATHER RADAR PROCESSOR. PER AMM 34-41-42, OPERATIONAL TEST GOOD, PER AMM 34-41-00.SDR AALA202508197007Sensor · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: BLEED TRIP LIGHT ILLUMINATED IN CLIMB. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT CLT. TROUBLESHOT PER FIM 36-10-00-810-809. REPLACED ENGINE NUMBER 2 PRECOOLER CONTROL VALVE SENSOR. PER AMM 36-12-03-4SDR AALA202508192180Handle · missingAIRCRAFT IN BASE MAINTENANCE: REPLACEMENT SLIDE FOR THE RIGHT HAND AFT DOOR WAS FOUND TO BE BAD FROM STOCK DUE TO BOTH SLIDE PULL HANDLES WERE MISSING. THE DEFECTIVE SLIDE WAS ROUTED TO BE REPAIRED AND A SERVICEABLE SLIDE WAS INSTALLED PER TASK CARD 26C8425200SDR AALA202508194690Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 4 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM 4 ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR CHIA202508149805Transmission · overheatedTHE NR 2 ENGINE TRANSMISSION TEMPERATURE EXCEEDED UPPER TEMPERATURE LIMIT IN FLIGHT RESULTING IN PILOTS INITIATING ENGINE XMSN HOT EMERGENCY PROCEDURES AND RETURNING TO BASE FOR AN UNSCHEDULED LANDING. REMOVED THE NR 2 ENGINE TRANSMISSION ASSEMBLY AS UNSERVICSDR CHIA202508149804Switch · failedNR 1 ENGINE BEEP SWITCH ON THE LT COLLECTIVE BECAME INTERMITTENTLY UNRESPONSIVE IN FLIGHT, RESULTING IN PILOTS INITIATING ENGINE BEEP FAILURE/FREEZE EMERGENCY PROCEDURES AND RETURNING TO BASE FOR AN UNSCHEDULED LANDING. SUBSEQUENT INSPECTION DETERMINED THE LT