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 CALA2025111111133Cam · out of adjustLEFT FWD ENTRY DOOR ARMING LEVER IS VERY STIFF, HARD TO ARM COMPARED TO RT IAW.AMM TASK 52-25-825-01, CHECKED L1 DOOR ARMING MECHANISM. CHECKED GIRT BAR SLIDE LOCKS, BOTH OPERATED NORMALLY WHEN ARMING AND DISARMING. GIRT INSTALLED CORRECTLY. SUSPECT LINKAGESDR CALA2025111111132Slide · no discrepancyR1 DOOR SLIDE NEEDS REATTACHING TO GIRT BAR. VERIFIED R1 DOOR DISARMED. PERFORMED GVI OF R1 DOOR SLIDE. NO DEFECTS NOTED. Z FOLD DIMENSIONS OK IAW AMM 25-66-01-601-804. R1 DOOR ARMS AND DISARMS NORMAL. PERFORMED R1 DOOR OPERATIONAL TEST REF AMM 52-41-00-86SDR CALA2025111111131Cover · looseDOOR 2L SLIDE COVER LOOSE AND DETACHES EASILY SECURED COVER, CHK OK.SDR CALA2025111111130Girt Bar · no discrepancyFA REPORTS LEFT GIRT BAR CLIP ON DOOR 1R LOOSE. INSPECTED BOTH J HOOKS FOR GIRT BAR ON 1R, J HOOKS ARE SECURED, NO DEFECTS NOTED. REF AMM TASK 25-66-01- 200-802.SDR CALA2025111111125Switch · damagedEMER LIGHTS GUARD ON OVHD PANEL SWITCH CATCH DETACHED. ON CENTE R CDU RE-ATTACHED GUARD TO SWITCH, OPS CHECK GOOD.SDR CALA2025111111124Light · brokenEMERGENCY LIGHT ON 11D AISLE BROKEN. REMOVED AND REPLACED EMERGENCY LIGHT ON SEAT 11D AISLE PER AMM 33-51-06-00A-720A-A.SDR N6WA2025111205Landing Gear · icedNOSE DOOR OPEN MASTER WARNING IN FLIGHT. PERFORMED GVI OF AIRCRAFT. FOUND NLG TO BE COVERED IN ICE, NO OTHER DEFECTS FOUND OR NOTED. REMOVED ICE PRIOR TO DEPARTURE. INSTALLED THE LG GROUND LOCK PINS IN NLG AND MLG. DETERMINED AIRCRAFT TO BE SAFE FOR A ONE TSDR N6WA2025111204Smoke Warning · false activationSMOKE AFT LAV WARNING, NO SMOKE PRESENT. PERFORMED OPS CHECK IAW CRJ AMM 26-16-00. OPS CHECK GOOD.SDR N6WA2025111202Door · no discrepancyLH OVERWING EMERG. EXIT DOOR HARD TO OPEN. OPS CHECKED LH EMERG. EXIT DOOR IAW CRJ AMM 52-21-00. OPS CHECK GOOD. NO DEFECTS NOTED.SDR N6WA2025111201Door · obstructedOVERHEAD BIN AT LT EMERG. EXIT OBSTRUCTING DOOR OPERATION. ADJUSTED OVERHEAD BIN IAW CRJ AMM 25-23-00. OPS CHECK GOOD.SDR SCNA20251111435Oven · dirtyAFT GALLEY OVEN OVERLY DIRTY CREATTTES FUMES WHEN COOKING - CATERING NOTIFIED TO CHANGE OUT INSERSSDR SCNA20251111434Unknown · no discrepancyFLIGHT ATTENDENTS REPORT BANGING NOISE FROM BACK OF AIRCRAFT - PERFORMED FIM 49-55 TASK 809 NO DEFECTS NOTED PERFORMED APU BITE PER FIM 49-60 TASK 801 NO FAULTS NOTED PERFORMED INPUT MONITORING OF BLEED AIR SYSTEM OPS CHECKS NORMAL OK SERVICESDR AALA202511113944Flashlight · burned outAIRCRAFT IN BASE MAINTENANCE. EMERGENCY FLASHLIGHT AT DOOR 3R FLIGHT ATTENDANT SEAT BURNED OUT. REPLACED FLASHLIGHT.SDR AALA202511115142Flashlight · burned outAIRCRAFT IN BASE MAINTENANCE. EMERGENCY FLASHLIGHT AT DOOR 2L FLIGHT ATTENDANT SEAT BURNED OUT. REPLACED FLASHLIGHT.SDR AALA202511118054Flashlight · burned outAIRCRAFT IN BASE MAINTENANCE. EMERGENCY FLASHLIGHT AT DOOR 2R FLIGHT ATTENDANT SEAT BURNED OUT. REPLACED FLASHLIGHT.SDR AALA202511112889Flashlight · burned outAIRCRAFT IN BASE MAINTENANCE. EMERGENCY FLASHLIGHT AT DOOR 1L FLIGHT ATTENDANT SEAT BURNED OUT. REPLACED FLASHLIGHT.SDR DXTA2025111105649Bolt · brokenAS US CUSTOMS AGENT WALKED DOWN THE AIRSTAIR, THE FORWARD AIRSTAIR DOOR GAS STRUT BROKE OFF THE ATTACH POINT OF THE DOOR. IT APPEARS THE BOLTS SHEERED OFF. EXTRACTED BROKEN HARDWARE AND VERIFIED NO FURTIIER DAMAGE NOTED. INSTALLED NEW HARDWARE AND OPS CHECKED SDR DALA2025111108266Pushrod · corrodedWHILE PERFORMING W/C 5210-01065-03-4R, 4R PAX DOOR NEEDS ADJUSTMENT. DURING INSPECT OF EMERGENCY MECHANISM OF R4 DOOR, FOUND PUSHROD A WITH CORROSION. REMOVED PUSHROD IAW CMM 52-11-25. REMOVED CORROSION. INSTALLED PUSHROD IAW CMM 52-11-25. (7534662)SDR DALA2025111108265Rope · unsecureR4 DOOR WOULD NOT ARM. FOUND SLIDE ROPE OBSTRUCTING DOOR ENGAGEMENT. TUCKED SLIDE ROPE. DOOR CLOSE NORMAL. (7954240)SDR DALA2025111108264Girt Bar · detachedL3 GIRT BAR DETACHED FROM FLOOR. REINSTALLED GIRT BAR IAW AMM 25-66. (7581556)SDR AALA202511118451Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER UPPER ATTACH ANGLE, LOCATED IN RIGHT HAND ECS BAY, AT STA 663, RBL 35. REPLACED ANGLE PER SRM 57-10-10-2R-5.SDR CALA2025111111106Lamp · inoperativeEMERGENCY LIGHTS OPS TEST WITH THE TEST SWITCH PROCEDURE, R4 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-06-962-001-002. OPS CHECK GOOD.SDR CALA2025111111104Fuel Tank · corrodedDURKING OK TO INSTALL OF FLOOR PANEL, FOUND BETWEEN BS 984 - 996 BELOW ACCESS PANEL 242BF, EXFOLIATION IN THE LOWER SURFACE. REF NRC 135215. REMOVED CORROSION ON UPPER SURFACE OF FUEL TANK SKIN BETWEEN BS 989 - 996 IAW SRM 51-10-02, SRM 57-10-01, REPAIR APB-1SDR DALA2025111108257Seal · leakingCREW REPORTED PAINT THINNER TYPE SMELL IN CABIN OCCURRED AFTER TAKEOFF AND DURING FLIGHT. FOUND OIL BEHIND NR 1 ENGINE SPINNER. REPLACED NR 1 ENGINE FAN DRIVE SEAL. (LP 6851020, 1296686)SDR R61A2025111000490Flap System · faultedSLAT FLAP FAIL IN FLIGHT. SLATS 3 FLAPS 0. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. FOUND TO BE A TRANSITORY CONDITION OF THE FLAP CONTROL SYSTEM.SDR AALA202511117215Bottle · 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.SDR AALA202511116920Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202511112600Gust Lock · stickingAIRCRAFT WAS NOT GROUNDED: MAIN CABIN DOOR GUST LOCK NOT ENGAGING. MAINTENANCE CLEANED / LUBRICATED GUST LOCK MECHANISM AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-10-00.SDR AALA202511112196Proximity Sensor · out of adjustAIRCRAFT WAS NOT GROUNDED: LEFT OVER WING EXIT DOOR OPEN INDICATOR INTERMITTENT. MAINTENANCE ADJUSTED PROXIMITY DETECTOR SENSOR FOR THE LEFT-OVER WING HANDLE COVER AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-71-00.SDR AALA202511113959Wire · damagedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS ON SEAT ROWS 26ABC ,27ABC, AND 28ABC INOPERATIVE. MAINTENANCE FOUND EXPOSED DAMAGED WIRING AT SEAT ROW 29ABC, REPAIRED DAMAGED WIRE AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK WITH NO ISSUES NOTED.SDR DALA2025111108239Frame · crackedCRACK FOUND ON THE HORIZONTAL FALNGE RADIUS OF THE FR68 LOCATED BETWEEN THE FRAME WEB AND FRAME STIFFENER AT LEVEL OF S22L. COMPLIED WITH ER/A 605954-14AD. (1297446).SDR DALA2025111108238Frame · crackedCRACK FOUND ON THE HORIZONTAL FALNGE RADIUS OF THE FR68 LOCATED BETWEEN THE FRAME WEB AND FRAME STIFFENER AT LEVEL OF S22L. COMPLIED WITH ER/A 605954-14AD. (1297432).SDR DALA2025111108237Frame · crackedCRACK FOUND ON THE HORIZONTAL FALNGE RADIUS OF THE FR68 LOCATED BETWEEN THE FRAME WEB AND FRAME STIFFENER AT LEVEL OF S22L. COMPLIED WITH ER/A 605954-14AD. (1297420).SDR DALA2025111108236Frame · crackedCRACK FOUND ON THE HORIZONTAL FALNGE RADIUS OF THE FR68 LOCATED BETWEEN THE FRAME WEB AND FRAME STIFFENER AT LEVEL OF S22L. COMPLIED WITH ER/A 605954-14AD. (1297300).SDR DALA2025111108235Frame · crackedCRACK FOUND ON THE HORIZONTAL FLANGE RADIUS OF THE FR68 LOCATED BETWEEN THE FRAME WEB AND FRAME STIFFENER AT LEVEL OF S22L. COMPLIED WITH ER/A 605954-14AD. (1297285).SDR DALA2025111108233Frame · crackedCRACK FOUND ON THE HORIZONTAL FALNGE RADIUS OF THE FR68 LOCATED BETWEEN THE FRAME WEB AND FRAME STIFFENER AT LEVEL OF S22L. CORRECTIVE ACTION: COMPLIED WITH ER/A 605954-14AD. (1297278).SDR DALA2025111108232Frame · crackedCRACK FOUND ON THE HORIZONTAL FLANGE RADIUS OF THE FR68 LOCATED BETWEEN THE FRAME WEB AND FRAME STIFFENER AT LEVEL OF S22L. COMPLIED WITH ER/A 605954-14AD. (1297326).SDR DALA2025111108231Dampener · no testDONT PASS OPERATIONAL TEST EMERGENCY DOOR DAMPER ON PASSENGER CREW DOOR 832. REMOVED UNSERVICEABLE DOOR DAMPER AND EMERGENCY OPERATION CYLINDER AT PASSENGER CREW DOOR 832 AS PER A320 FAM AMM 52-13-14-000-001-B. (1297664).SDR DALA2025111108230Bushing · excess playEXCESSIVE PLAY AT BUSHINGS BTW UPPER LINK, LOWER LINK AND SUPPORT ARM (8EA) PASSENENGER CREW DOOR 832. REPLACED BONDED BUSHES UPPER, LOWER LINK AND SUPPORT ARM (8EA)AT PASSENGER CREW DOOR 832 AS PER A320 FAM AMM 52-13-21-000-001-A, AS PER A320 FAM AMM 52-10-SDR DALA2025111108229Plate · crackedCRACK FOUND AFFECTING THE UPPER PLATE OF LT PAX/CREW DOOR 831 CREW DOOR 831 IN PASSENGER CABIN. COMPLIED WITH ER/A 630181-14. (1297839).SDR DALA2025111108228Bearing · looseLEFT STABILIZER HINGE ATTACH ELEVATOR N 1, 4, 5, 6 WITH BEARINGS LOOSE AND SUPPORT STRUT BEARING LOOSE. REPLACED BEARINGS AND SLEEVE'S AT EMPENNAGE L/H ELEVATOR HINGE ARM END FITTINGS #1,4,5 AND 6 IAW A319 AMM TASK 55-16-42-960-801 -A. (1297414).SDR DALA2025111108227Window Frame · crackedCRACK FOUND AT RH WINDSHIELD CENTER POST LOWER ATTACHMENT AREA. COMPLIED QITH ER/A 629316-14AD. (1297842).SDR DALA2025111108226Door Frame · crackedSHIP 3154 DOOR STOP FITTING #7 ON FR16 R/H SIDE, HOLE #3, WITH CRACK INDICATION AT INTERCOSTAL LAYER. CORRECTIVE ACTION: REPLACED INTERCOSTAL FITTING IAW A319 SRM 51-72-11-911-001 AND 51-42-11-801. (1297441).SDR DALA2025111108225Shear Tie · mechanic errorMISDRILLED HOLE INTERNAL STRUCTURE ON SHEAR TIE FR29 AND FR30 STR41 TO STR42 LH SIDE IN FWD CARGO COMPARTMENT. REPLACED SHEAR TIE FR29 AND FR30 STR41 TO STR42 LH SIDE IN FWD CARGO COMPARTMENT AS PER A319 SRM 51-42-11 AND A319 SRM 51-72-11. (1297363).SDR DALA2025111108255Hinge Fitting · excess playRH STABILIZER HINGE ATTACHED ELEVATOR N 1 THRU 6, AND SUPPORT STRUT, BEARING WITH PLAY. CORRECTIVE ACTION: REPLACED BEARINGS AND SLEEVES AT EMPENNAGE R/H ELEVATOR HINGE-ARM END FITTINGS #1 THRU #6 IAW A319 AMM TASK 55-16-42-960-801-A. (1297429).SDR DALA2025111108251Floorbeam · corrodedBS 986 FLOORBEAM HAS CORROSION AT FLOORBOARD HOLES FROM BL0 TO RBL50. DAMAGED TEE ANGLE ON FLOORBEAM 986 BL50-RBL50 FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 53-70-51-2R-4.SDR DALA2025111108250Wire · brokenROW 29 DEF SEAT EMERGENCY LIGHT IS INOPERATIVE. FOUND BROKEN WIRE ON SEAT 29 DEF TO EMERGENCY LIGHT. SPLICED WIRE PER SWPM 20-30-12 AND PERFORMED GOOD OPS CHECK PER AMM 33-51-11-960-802.SDR FDEA202511102155Door · out of sequenceL1 DOOR HARD TO OPEN & CLOSE. UPPER & LOWER DOOR GATES WILL NOT CLOSE. OUTER HANDLE ROTATES APPROX 3 INCHES PAST THE CLOSE POSITION WHEN ATTEMPTING TO CLOSE. INNER DOOR HANDLE WILL NOT ROTATE TO THE FULL CLOSE POSITION. & AS PREV STATED UPPER & LOWER GATESDR DALA2025111108249Elec Connector · unsecureSEAT 49 A EMERGENCY LIGHT INOP. SECURED THE CONNECTOR PER AMM 33-51. OK FOR SERVICE. (7832942)SDR DALA2025111108248Bottle · low pressureR1 DOOR ASSIST LOW. SERVICED DOOR ASSIST BOTTLE PER AMM 52-15. OK FOR SERVICE. (7971560)