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 IPXA2025111380204Seat Track · corrodedMAIN DECK SEAT TRACK AT FR79/FR80, Y0 HAS CORROSION. INSTALLED SEAT TRACK AT Y '0' FR 79 TO FR 80 USING FASTNERS PN HL10VF8-6 B# 0004989789, NSA5075-8 38 EACH B# 0004145036, HL12-6-6 B# 0004304262 16 EACH, HL10VF6-5 B# 0004426225 6 EACH, NSA5075-6 B# 00042919SDR SWAA2025111224458Web · corrodedMAIN CABIN - AFT BULKHEAD FRAME 1016; UPPER WEB STRUCTURE FITTING HAS CORROSION AT BS 1016; BL 0. REPLACED FITTING LOC. AFT BULKHEAD FRAME BS 1016; UPPER WEB STRUCTURE AND BL 0 I.A.W B737-700 SRM 51-40-02 AND SRM 51-10-02 ITEM 9 DWG 148A2237 SHEET 1 REV-.SDR SWAA2025111224461Floorbeam · crackedAAI INSPECTION: MAIN CABIN - FLOOR STRUCTURE SUPPORT HAS CRACK AT STA 540; BL 0 TO RBL 24.75. REPLACED BREAK PANEL SUPPORT AND FASTENERS ON FLOOR STRUCTURE STA 540 BL0 TO RBL 24.75 AT MAIN CABIN B737-700 SRM 51-10-02 Ï¿½TEM 9 AND DWG 143A0060 SHEET 46 REV-.SDR SWAA2025111224462Floorbeam · crackedMAIN CABIN - FLOOR STRUCTURE SUPPORT HAS A CRACK AT BS 540; BL 0 TO LBL 24.75. REPLACED BREAK PANEL SUPPORT AND FASTENERS ON FLOOR STRUCTURE STA 540 BL 0 TO LBL 24.75 AT MAIN CABIN I.A.W B737-700 SRM 51-10-02 Ï¿½TEM 9 AND DWG 143A0060 SHEET 46 REV-.SDR SWAA2025111024735Strap · crackedFWD ENTRY DOOR CUTOUT UPPER HINGE POCKET H-STRAP CRACKED. REPAIRED FUSELAGE - ENTRY DOOR SURROUND STRUCTURE - FR 303.9 AT STR S10L - UPPER HINGE POCKET H-STRAP - EXISTING TRIMOUT.) IAW EA #25-153-02961-WIP1.SDR SWIA2025110700005Skin · damagedLIGHTNING STRIKE DAMAGE TO LOCK FASTENER LOCATED AT STRG 25 AND FR 11 FOUND LOCK FASTENER WITH INTERFACE DAMAGE AT STRG 25 AND FR 11. COMPLIED WITH FREEZE PLUG INSTALLATION IAW SRM 51-10-07 AND ETD2025-170-930286 REV.SDR IPXA2025110470051Skin · crackedRH WING, UPPER SURFACE, CLOSE TO RIB 18, REAR SPAR, SKIN HAS A CRACK DOT 103-51. REMOVED RIVETS AND BOLTS AFFECTED BY THE REPAIR ON RH WING UPPER SURFACE CLOSE TO RIB 18 REAR SPAR IAW A300-600F SRM 57-51-12. INSTALLED BUTTSTRAP, PACKING STRIP, REINFORCEMENT PLSDR IPXA2025110570051Skin · crackedRIGHT WING, UPPER SURFACE, CLOSE TO RIB 18, REAR SPAR, SKIN HAS A CRACK.SDR IPXA2025110382369Floorbeam · bentMAIN DECK FLOOR STRUCTURE- CROSSBEAM BENT AT FR48 BETWEEN -Y450 AND -Y953, VERIFIED CROSSBEAM REPLACED ON SREO. COMPLIED WITH SREO-75878-REQ001.SDR CALA2025110410885Frame · damagedFUSELAGE FRAME STATION 520 HAS PUNCTURE DAMAGE FOUND AT RH SIDE BETWEEN STRINGERS 13R AND 12R. REFERENCE BAM N/R 002865843 FOR ALL WORK ACCOMPLISHED PERFORMED INTERIM REPAIR PER EC/RA#: 5311-03402. PLACED ON DIPON BS 520 FRAME WEB BETWEEN S-11R AND S-13R, ACCOSDR IPXA2025102882408Floorbeam · crackedFAULT - STR - Z241 -MAIN DECK FLOOR STRUCTURE- CROSSBEAM CRACKED (BUCKLING) AT FR51 BETWEEN -Y450 AND -Y953, DOT 78-20. ACCOMPLISHED WITH SREO-75878-REQ001. REVIEWEDSDR IPXA2025102280275Retainer · corrodedCORROSION FOUND AT MAIN CARGO COMPARTMENT ANGLE RETAINER SUPPORT FROM BS 1610 - 1681.80, LBL 60. REMOVED CORRODED ANGLE RETAINER IAW SRM 51-40-02. INSTALLED ANGLE RETAINER SUPPORT IAW SRM-51-40-02.SDR REXA2025102900968Engine · contaminatedAFTER ROTATION CA AND FO STARTED TO SMELL SMOKE . VERY FAINT WHITE SMOKE SEEN BY PILOTS AND FAS WITH CHEMICAL ODOR. RAN CHECKING CARD AND QRH SMOKE AND FUMES REMOVAL PROCEDURE. TURNING PACKS AND RECIRC FAN OFF REDUCED ODOR SIGNIFICANTLY. FIRE RESCUE DID NOT NSDR 2025F00251Blades · fracturedFLIGHT AR1526, CREW REPORTED FEELING A LOUD EXPLOSION AND SEVERE VIBRATION IN THE AIRCRAFT, IN ENGINE NUMBER 1. AFTER ARRIVAL, THE ENGINE WAS INSPECTED WITH THE FOLLOWING RESULTS: EXTERNAL VISUAL INSPECTION REVEALED DAMAGE TO THE LPT STG 4 BLADES. THERE WAS SDR SIMA20251015001Floorbeam · corrodedLH FLOOR BEAM UNDER FLOOR SILL BETWEEN FR19-20 HAS CORROSION UNDER ROUND STAINLESS STRIP. (LEVEL 2 CORROSION). RAR LH FLOOR BEAM UNDER FLOOR SILL BETWEEN FR19 AND FR20 IAW ERJ 175 SRM 51-40-08SDR SWAA2025102724678Light · crackedPHOTO LUMINESCENT DAMAGED, CRACKED IN SEVERAL AREAS. REMOVED AND REPLACED THE PHOTO LUMINESCENT THAT WAS DAMAGED THROUGH OUT CABIN IAW AMM 33-51-15-960-801.SDR SWAA2025102724834Light · damagedEMERGENCY EXIT LIGHT LENS HOUSING LOCATED MID CABIN UPPER CEILINGS IS DAMAGED. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY HOUSING; MID CABIN CEILING AND PERFORMED A GOOD OPS CHECKED IAW AMM 33-51-01-960-802 STEPS 3. C; (4) (C) (6) (7) (11) (12).SDR CALA2025102710550Stop Fitting · gougedAFT ENTRY DOOR (L2) UPPER STOP FITTING HAS GOUGE. REMOVED AND REPLACED L-2 DOOR UPPER FWD STOP FITTING IAW DWG 147A6125 REV- AND SRM 51-40-02-0G-0.SDR CALA2025102710548Battery Pack · inoperativeM1694 LT OVERWING EMERGENCY LIGHTS BATTERY PACK WILL NOT CHARGE. REMOVED AND REPLACED BATTERY PACK AND POWER SUPPLY AND OPS CHECKED GOOD IAW B737-NG AMM 33-51-06.SDR CALA2025102710546Battery Pack · inoperativeM1695 RH OVERWING EMERGENCY LIGHTS BATTERY PACK WILL NOT CHARGE. REMOVED AND REPLACED BATTERY PACK M1645 AND OPS CHECK GOOD IAW AMM 33-51-06.SDR DXTA2025102005318Strut · faultyREPEAT WRITEUP. HIGH PITCH NOISE FROM NOSE GEAR ON GROUND DURING HIGH SPEEDS. NO SHIMMY OR VIBRATION OR DIRECTIONAL CONTROL PROBLEMS NOTED. POST FLIGHT REVEALS NO APPARENT DAMAGE TO NOSE GEAR ASSEMBLY. CORRECTIVE ACTION: REMOVED NLG SHOCK STRUT WITH NLG SHOCKSDR DALA2025102007651Sign · inoperativeEMERGENCY EXIT SIGNS INOPERATIVE / LOCATIONS: 3R. C/W ERA 625342-14TR. (1253654)SDR DALA2025102007645Skin · corrodedSHIP 1812 AFT CARGO COMPARTMENT FOUND DRAIN HOLE AREA CORROSION AT BS 1087 BETWEEN S39R AND 39L. THE PRI629503-14 REV.0 COMPARED AND COMPLIED WITH (1253239)SDR DALA2025102007644Skin · crackedNUMBER 2 NACELLE STRUT FWD TORQUE BOX UPPER SPAR INBD FWD WIRING OPEN HOLE CUT-OUT FOUND CRACK AT ABOUT NAC STA 229. CORRECTIVE ACTION: REPAIRED AS PER PRI629501-14 (1253202)SDR MASA2025101500088Cradle · brokenFO EMER FLASHLIGHT BRACKET BROKEN. R & R FO EMER FLASHLIGHT ASSY. OPS CHECK GOOD.SDR DALA2025102107688Door Sill · no discrepancyERA 622251-14 REV A HAS FOLLOW-ON INSPECTION FOR THE FORWARD CARGO DOOR SILL AREA. ACCOMPLISH SECTION II WITHIN 28,600 FC OR 50,050 FH. THEN EVERY 9,400 FC OR 16,450 FH THEREAFTER. ASSOCIATED ER/A 00-622251 ADDED FOR AC 8125. (LP# 1253477)SDR CALA2025102110325Fairing · crackedNUMBER 2 ENGINE AFT STRUT FAIRING POSSIBLE ON THE AFT BRACKET. REMOVED AND INSTALLED NR 2 ENGINE AFT STRUT FAIRING IAW SRM-51-40-02-0G-0, SRM 51-040-05-0G-0, SRM 51-40-08-0G-0, AIPC-54-52-04-02 ITEM 85, AMM 54-52-04-410-802.SDR ASAA2025101561635Lamp · inoperativeR2 DOOR EXTERNAL EMERGENCY EXIT LIGHT INOP. GROUNDED - YES. RELAMPED R2 EXT EMERGENCY EXIT LIGHT, OPS CHECKS GOOD. REF B737 AMM.SDR AALA202510208766Light · brokenAIRCRAFT IN BASE MAINTENANCE: BROKEN EMERGENCY LIGHTS ASSY ON DOOR WAY PANELS 2R IN PASSENGER CABIN. REPLACED EMERGENCY LIGHTS ASSY ON DOOR WAY PANELS 2R IN PASSENGER CABIN IAW AMM 33-51-01-960-803.SDR AALA202510204666Power Supply · no testAIRCRAFT WAS GROUNDED: SEAT ROWS 1AC, 4ABC,9ABC, 9DEF, 11ABC AND 11DEF EMERGENCY LIGHTS NOT WORKING TRIED TO RELAMP NO HELP. MAINTENANCE EPSU SYSTEM TEST FAILED. FOUND ALL 4 EPSU WILL NOT TEST. REPLACED AFT (13WL) IAW AMM 33-51-38.SDR AALA202510207358Power Supply · no testAIRCRAFT WAS GROUNDED: SEAT ROWS 1AC, 4ABC,9ABC, 9DEF, 11ABC AND 11DEF EMERGENCY LIGHTS NOT WORKING TRIED TO RELAMP NO HELP. MAINTENANCE EPSU SYSTEM TEST FAILED. FOUND ALL 4 EPSU WILL NOT TEST. REPLACED FWDL(10WL) IAW AMM 33-51-38.SDR SWAA2025102024630Unknown · odorELECTRICAL SMELL IN THE COCKPIT. C/W SMOKE OR FUMES IN CABIN. SERVICED HYD RESERVOIRS A & B TO CORRECT LEVEL REF AMM 12-12-00. NO OTHER DEFECTS NOTED.SDR SWAA2025102024901Cover · missingL1 DOOR SLIDE PULL TO INFLATE HANDLE COVER MISSING. REMOVED L1 DOOR SLIDE LOCATED PULL TO INFLATE COVER INSTALLED COVER OVER HANDLE. INSTALLED L1 DOOR SLIDE FRE AMM 25-66-01 AND MT 725-61-06.SDR SWAA2025102024903Sign · missingOVERHEAD EXIT SIGN ROW IS MISSING. RESECURED IAW M/M 33-51-01.SDR AALA202510206891Wire · brokenAIRCRAFT WAS GROUNDED: FLOOR EMERGENCY LIGHT AT SEAT ROW 31C IS INOPERATIVE. MAINTENANCE FOUND BROKEN WIRES AT P2 CONNECTOR AT SEAT 31C, REPLACED EMERGENCY LIGHT HARNESS AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER CMM 25-21-61.SDR DALA2025102007622Door Sill · no discrepancyERA 622251-14 REV A HAS FOLLOW-ON INSPECTION FOR THE FORWARD CARGO DOOR SILL AREA. ACCOMPLISH SECTION II WITHIN 32,191 FC OR 57,868 FH. THEN EVERY 9,400 FC OR 16,450 FH THEREAFTER. ASSOCIATED ER/A 00-622251 ADDED FOR AC 8145. (LP# 1253822)SDR DXTA2025102005329Actuator · failedWHILE CLOSING MED DOOR, SOMETHING CAME LOOSE & ENTIRE DOOR CAME SLAMMING DOWN. MX CORRECTED THE PAX DOOR DISCREPANCY BY REMOVING UNSERVICEABLE DOOR ACTUATOR & REPLACING IT WITH A REPAIRED SERVICEABLE UNIT IAW AMM 52-11-25-400-801, FOLLOWED BY FULL RIGGING OF SDR DXTA2025102005328Wire Harness · defectiveAT FL410 AND JUST PULLED THE POWER BACK FROM A CRUISE SETTING. WHEN THE POWER WAS PULLED BACK THE LEFT ENGINE ITT WENT TO TOP OF ITT SCALE & TURNED RED. PULLED POWER BACK TO ABOUT 60 PERCENT N1 AND ITT IMMEDIATELY CAME BACK TO A NORMAL TEMPERATURE. DURING THISDR DXTA2025102005325Control Unit · defectiveON APPROACH SELECTED FLAPS 10. FLAPS TRACKED ONLY TO 2 DEGREES AND FLAP FAULT AMBER CAS APPEARED. COMPLIED WITH QRH SELECTED FLAPS BACK TO ZERO AND FLAPS FAIL AMBER CAS APPEARED. COMPLIED WITH QRH FOR ZERO FLAP LANDING. LANDED UNEVENTFULLY. B3 CODE #006786 FPSDR DXTA2025102005316Filter · defectiveCLIMBING THROUGH FL380 FOR FL410 THERE WAS A STRONG BURNING SMELL IN THE ENTIRE CABIN AND COCKPIT. NO SMOKE WAS OBSERVED. NO CASS MSG WAS DISPLAYED AND ANTI-ICE WAS OFF. DIVERTED TO MYNN. UPON POST FLIGHT INSPECTION, NO OIL WAS LEAKING FROM THE ENGINES. THE SMSDR 2025F00245Brake Assy · malfunctionedTAXIING ON TAXIWAY D AT KPGD. WE CROSSED RUNWAY 33-15 GOING WEST ON TAXIWAY D. APPLIED BRAKES TO SLOW THE AIRCRAFT PRIOR TO THE 90 DEGREE TURN TO HEAD SOUTHBOUND ON D. APPLYING BRAKES, INITIALLY THE AIRCRAFT SLOWED, THEN YOU FELT THE LEFT BRAKE RELEASE AND THESDR ASAA2025101561636Power Supply · no testWHILE ACCOMPLISHING TC 78233001, BATTERY PACKS FOR BOTH AFT WING DOORS AND AFT FLAP EMERGENCY LIGHTS INOP. EMERGENCY LIGHT FOR R2 DOOR INOP AS WELL. GROUNDED - YES. REPLACED EMERGENCY LT BATTERY & POWER SUPPLY 3 EA, M1670, M1671, M1672. REF AMM 33-51-06. OP CHSDR ASAA2025101561623Power Supply · inoperativeWHILE ACCOMPLISH TC 78233001 NOTED THE FOLLOWING LIGHTS INOPERATIVE EXTERIOR L2 DOOR, OVERWING LH AND RH AND EXIT SIGN ABOVE FLIGHT DECK DOOR. GROUNDED - YES. REMOVED & REPLACED QTY 4 BATTERY PACKS (M1668, M1669, M1673, & M1675) IAW AMM 33-51-06-960-806, OPS CSDR GRTA20251017001Bayonet · shearedAT FLIGHT LEVEL 27,000 CABIN PRESSURE 6.1. EXPERIENCED RAPID CABIN DEPRESSURIZATION. MX FOUND FAILURE OF THE UPPER AFT BAYONET (BOLT) 23.2HRS AFTER REPLACEMENT. THE AIRCRAFT HAD A RAPID DE-PRESSURIZATION, CABIN MASKS DEPLOYED AND LANDED WITH NO ISSUES. THE DASDR 2025FA0000722Compressor · crackedAC COMPRESSOR CRACKS THAT WE ARE CURRENTLY ENCOUNTERING ACROSS OUR FLEET. THESE CRACKS PRESENT A POTENTIAL FAULT THAT RAISES SERIOUS SAFETY. WE HAVEN’T EXPERIENCED A FULL SEPARATION YET, GIVEN OUR FLEET SIZE AND OUR OPERATIONS TOTALING OVER 4,000 FLIGHT HOURSDR WX0A2025101732602Battery Pack · not reported(AIRCRAFT NOT GROUNDED) EPSU BATTERIES REQUIRE REPLACEMENT. INSTALLED 10,11,12,13 WL (FIN) EPSU BATTERIES IN REF TO AMM 33-51-38-000-002-A"SDR DALA2025101707595Spar Cap · crackedSHIP 9506 CRACK WAS FOUND ON HOLE 6 HRS AT STA ZFS=51.267 APROX. FRONT SPAR CAP FORWARD FLANGE VERTICAL STABILIZER LH SIDE. CORRECTIVE ACTION: REPAIR ON FRONT SPAR CAP FORWARD FLANGE VERTICAL STABILIZER LH SIDE WAS PERFORMED PER PRI 606161-14 (1254228)SDR N6WA2025101704Stringer · corrodedCORROSION ON STRG23R AT FS379. REMOVED AND REPLACED STGR23R BETWEEN FS333.00-FS379.00 IAW CRJ SRM 51-42-06SDR ABXA20251015272Engine · smokeSMELL OF FUMES. SMOKE IN CKPT 5 MILES OUT. LANDED, TOWER SAW SMOKE OUT OF #2 ENG ON TAXI. FIRE MASTER CAUTION CAME ON. SHUT #2 ENG DOWN, FIRE MASTER CAUTION WENT OUT. FIRE & SMOKE SEEN BY FIRE CREW. A/C CURRENTLY IN WORK. AN UPDATED SDR REPORT WILL BE FILED SDR AALA202510172735Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.