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 AALA202512040901Sensor · false indicationAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED FUEL RIGHT WING TANK OVERFLOW ECAM MESSAGE ON DESCENT. MAINTENANCE REPLACED RIGHT WING SURGE TANK OVERFLOW SENSOR 28QJ2 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 28-46-16.SDR AALA202512048653Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202512043689Battery · no testAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT FLASHLIGHT BATTERY DEAD. MAINTENANCE REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-65-00.SDR AALA202512040514Life Vest · damagedAIRCRAFT WAS NOT GROUNDED: FIRST OFFICER LIFE VEST TRANSPARENT PACK IS DAMAGED. MAINTENANCE REPLACED FIRST OFFICER LIFE VEST PER AMM 25-66-00.SDR AALA202512044057Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202512042637Lever · looseAIRCRAFT WAS NOT GROUNDED: DOOR 3R ARMING LEVER LOOSE. MAINTENANCE RESECURED 3R ARMING LEVER AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-22-22.SDR AALA202512045358Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202512045020Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-11-00.SDR AALA202512045496Lamp · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT LEFT SIDE SEAT ROW 18 INOPERATIVE. MAINTENANCE RELAMPED AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-18.SDR DXTA2025120405926Pcb · faultedLEFT MAIN LANDING GEAR. GEAR DISAGREE. ON APPROACH TO LANDING RECEIVED GEAR DISAGREE. BLEW GEAR DOWN FOLLOWING QRH PROCEEDURE. STILL HAD GEAR DISAGREE AFTER BLOWDOWN. HAD TO USE MANUAL EXTENSION TO GET GEAR DOWN. AFTER POWER CYCLING THE CAS POSTED AGAIN SDR AALA202512048291Lock · inoperativeAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR IS LOCKED AND WILL NOT OPEN WITH THE CODE. CONFIRMED FLIGHT DECK DOOR AUTOMATIC UNLOCKING SYSTEM INOPERATIVE. PERFORMED OPERATIONAL CHECK OF THE DOOR LOCK PER AMM 52-51-00. OPERATIONAL CHECK GOOD AT THIS TIME. CHIME WASSDR JJBA20251204003Lamp · inoperativeRH LATERAL WING-TO-FUSELAGE FAIRING EMERGENCY LIGHT INOPERATIVE. RH SIDE CENTER FAIRING EXTERNAL EMERGENCY LIGHT ACCESS PANEL HAS 4 STRIPPED SCREWS. REMOVED AND REPLACED RH LATERAL WTF FAIRING EMERGENCY LIGHT LAMP. OPS CHECK FAIL. FOUND A PIN MISSING ON ELECTRSDR CALA2025120411781Windshield · failedFO OUTTER PANE SHATTERED. PERFORMED R1 WINDOW REMOVAL IAW AMM 56-11-11-000-801 UP TO AND INCLUDING STEP (11) SUBTASK (56-11-11-020-031). REMOVED AND REPLACED THE R1 WINDSHIELD IAW AMM 56-11-11. LEAK CHECKED GOOD. OK FOR SERVICE.SDR CALA2025120411780Transfer Tube · unsecureFLT CREW REPORTS HYD SYS A LOW & DROPPING WITH ENG NR 1 PUMP LOW PRESSURE. FOUND TRANSFER TUBE PLUG BACKED OUT ON NR 1 EDP DUE TO UNSECURED SAFETY WIRE. TORQUED TRANSFER TUBE PLUG IAW CMM 849589 29-10-61. PERFORMED IDLE RUN, LEAK CKD GOOD. PACKING WAS FOUND SDR CALA2025120411779Filter · faultedNUMBER 2 ENGINE VIBRATION REACHED 2.6 DURING CRUISE AT FL350, AMBER N1 CONDITI ON. RAN QRH, MAGNETIC CHIP DETECTORS INSPECTED, NO DISCREPENCIES FOUND IAW FIM 71-05, FAULT TREE 808 & AMM 79-00-00-216-001-R00. FOUND ECS MSG RT ENG BB VIB. & ON PERF/APU PAGE SDR CALA2025120411766Warning Light · false activationMASTER CAUTION DOORS REJECTED TAKEOFF 115KTS NO LIGHT ON OVERHEAD. PERFORMED A HIGH ENERGY STOP INSPECTION IAW AMM 05-71-07, NO DEFECTS NOTED. GVI FOUND FWD SERVICE DOOR SWITCH JAM NUT LOOSE. TIGHTENED JAM NUT AND SECURED IAW AMM 52-71-11-802-801. FWD SVC DOOSDR CALA2025120411764Warning Light · no discrepancyCHRONIC HISTORY OF R1 DOOR SLIDE ARMED ANNUN LIGHT INOP INTERMITTLY WHEN DOOR IS ARMED. IAW FIM 25-66 F T 802 FOR TROUBLESHOOTING GUIDE & AMM 52-11-25-825-001 FOR GIRT BAR M ECHANISM ADJUSTMENT. ISSUE IS CAUSED BY IMPROPER GIRT BAR ADJUSTMENT, INCORRECT PROXSDR MASA2025111800096Gasket · leakingBLEED 2 LEAK IN FLIGHT, R & R NR 2 ENGINE PRECOOLER GASKET OPS CK GOOD. CREW FOLLOWED QRH AND HAD TO AVOID ICING CONDITIONS LANDED IN ALTERNATE AIRPORT.SDR SWAA2025120341299Battery · no testAFT RIGHT INBD FLASHLIGHT NOT TESTING. REPLACED AFT RT INBD BATTERY FLASHLIGHT IAW AMM 25-64-00. OPS CHECKED GOOD.SDR SWAA2025120341772Slide · dislodgedFWD ENTRY DOOR SLIDE FELL OUT OF DOOR COMPARTMENT. REINSTALLED FWD ENTRY IAW AMM 25-66-00 AND TASK CARD 725-61-06.SDR SWAA2025120341409Handle · brokenFWD ENTRY DOOR ASSIST HANDLE BROKEN. RESECURED FWD ENTRY DOOR ASSIST HANDLE IAW AMM 52-11-31.SDR AALA202512033312Skin · gougedAIRCRAFT IN BASE MAINTENANCE: RIGHT SIDE OF FUSELAGE SKIN IS GOUGED ABOVE THE RIGHT HORIZONTAL STABILIZER, GOUGE LOCATION IS RIGHT HAND SIDE OF FUSELAGE APPROXIMATE 8 FASTENERS FORWARDOF BS 1156 ALONG STR 5R. INSTALLED REPAIRED. PER EA369709.SDR WX0A2025120332654Megaphone · inoperative(AIRCRAFT NOT GROUNDED) FWD MEGAPHONE INOPERATIVE. R & R FWD MEGAPHONE IAW AMM 25-60-51-90-001-A.SDR DALA2025120308818Hinge · damagedGALLEY 401 WORK DECK SUMP SCREEN DAMAGED. INSTALLED HINGE ON AFT GALLEY DRAIN SUMP SCREEN. IAW A319 AMM 25-31. (1330040).SDR AALA202512035597Elec Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTS FROM ROW 4 TO ROW 14 IS NOT FUNCTIONING. ELECTRICALLY HOOKED UP EMERGENCY LIGHTS FROM SEAT AT ROWS 4AB (AALA202512032140) AND 8ABC (AALA202512035597). PER AMM 25-22-00. OPERATIONAL CHECK OF EMERGENCY LIGHTS NORMALSDR AALA202512032140Elec Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTS FROM ROW 4 TO ROW 14 IS NOT FUNCTIONING. ELECTRICALLY HOOKED UP EMERGENCY LIGHTS FROM SEAT AT ROWS 4AB (AALA202512032140) AND 8ABC (AALA202512035597). PER AMM 25-22-00. OPERATIONAL CHECK OF EMERGENCY LIGHTS NORMALSDR AALA202512034907Sign · damagedAIRCRAFT IN BASE MAINTENANCE: OVERWING EXIT SIGN ON THE RIGHT SIDE ROW 17DEF DAMAGED. REMOVED AND REPLACED OVERWING EXIT SIGN LIGHT ASSEMBLY ON RIGHT SIDE ROW 17DEF. OPERATIONAL CHECK GOOD. PER AMM 33-561-11.SDR AALA202512033086Sign · damagedAIRCRAFT IN BASE MAINTENANCE: R2 DOOR EMERGENCY EXIT SIGN DAMAGED. REMOVED AND INSTALLED SERVICEABLE EXIT SIGN, OPERATIONAL CHECKED GOOD. PER AMM 33-51-01.SDR DXTA2025120205933Battery Pack · inoperativeSEAT 7 LIGHT INOP. EXIT ON BULKHEAD DIM. OUTSIDE RT OVERWING INOP. REMOVED & REPLACED BATTERY PACKS. OPS AND FUNCTIONAL CHECKS GOOD.IAW AMM 33-50-06SDR CALA2025120311731Angle · crackedLEFT WING TRAILING EDGE ONE ANGLE CRACKED. APPROX. AT WS 270 APPROX. 8 INCHES INBD OF THE FITTING. REMOVED AND REPLACED THE ANGLE IAW SRM 51-40-02-0G-0, DWG 115A2930 REV-, AND AMM 20-50-11-910-801.SDR CALA2025120311729Cover · missingRIGHT WING 1ST FLAP TRACK PIVOT COVER MISSING. REPLACED MISSING COVER REF AMM 57-55-11 PARTS USED: D5754052520200A,QTY :1SDR CALA2025120211700Light · inoperative42C EMER PATH LIGHTING NOT ILLUM. REQ MEL FOR EMER LIGHT ON 42C 3350B APPROVED ALL OTHER EMERGENCY LIGHTS ARE TURNING ON, INSTALLED INOPERATIVE STICKER ADJACENT TO EMER EXIT LT SWITCH ON OVERHEAD SIGNS PANEL REMOVED AND REPLACED EMERGENCY PATH LIGHT AT 42C IAWSDR SWIA2025120200001Oil System · warning messageAPU OIL TEMP CAUTION IN CRUISE. MEL 49-10-1ACAT C, ODI EVENT, (FLIGHT 5116) REFERENCE AML 1760814, REFERENCE AML 1760819, REFERENCE AML 1760821. DEFERRING APU IAW MEL 49-10-1A. MAINTENANCE PROCEDURES COMPLIED WITH. PLACARD INSTALLED.SDR AALA202512029568Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: EXTERIOR L2 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED EXTERIOR L2 DOOR EMERGENCY SIDELIGHT LAMP. PER AMM 33-51-04. OPERATIONAL CHECK GOOD.SDR AALA202512029294Sign · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN ON DANGLING OVER ROW 16. REATTACHED AND SECURED OVERHEAD EMERGENCY EXIT SIGN. PER AMM 25-63-00. OPERATIONAL CHECK GOOD.SDR AALA202512029118Door · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORT THAT THE AFT LEFT LAVATORY DOOR WILL NOT OPEN. FIXED AFT LEFT LAVATORY DOOR. PER CMM 25-40-64.SDR AALA202512028291Door · malfunctionedAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR IS LOCKED AND WILL NOT OPEN WITH THE CODE. CONFIRMED FLIGHT DECK DOOR AUTOMATIC UNLOCKING SYSTEM INOPERATIVE.SDR AALA202512026906Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT ASSEMBLY AT GALLEY M1 BROKEN LOCATED NEAR LAVATORY 2F-1R.SDR AALA202512020923Hinge · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR STICKS DIFFICULT TO OPEN. FOUND DOOR HINGE LOOSE, TIGHTENED HINGE. PER AARD 25-40-10-10.SDR AALA202512026165Connector · disconnectedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS (FLOOR PROXIMITY) SEAT ROWS 1 THROUGH 5 INOPERATIVE. FOUND CONNECTOR D9575 LOOSE, RECONNECTED CONNECTOR (D9575) (AALA202512016165), PER WDM 33-51-58. OPERATIONAL CHECK GOOD ON THE FLOOR PROX LIGHT 1-5C (LEFT AISLE), SDR AALA202512021215Light · shortedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS (FLOOR PROXIMITY) SEAT ROWS 1 THROUGH 5 INOPERATIVE. **SUPPLEMENTAL REPORT FOR (AALA202512016165) SUBMITTED 12/01/2025 BY DFW: FOUND CONNECTOR D9575 LOOSE, RECONNECTED CONNECTOR (D9575) (AALA202512016165), PER WDM 33SDR IPXA2025120116797Skin · crackedSECTION 18 LOWER SHELL REPLACEMENT AND INTERNAL STRUCTURE REPAIR. VERIFIED THAT REPAIR FOR SECTION 18 DAMAGE DUE TO TAILSTRIKE WAS REPAIRED ACCOMPLISHED ON AIRBUS WORK CARD 7086382 AND AIRBUS REPAIR DRAWING R53970080 ISSUE B. REPAIR THRESHOLD IS TO BE TRACKESDR QXEA2025120200360Switch · out of positionFLIGHT 2032. TRU 1 FAIL AT JET BRIDGE ON GPU DURING TAKEOFF ROLL. REJECTED TAKEOFF AT 65 KNOTS. REMOVED FROM SERVICE. FOUND TRU 1 SWITCH INADVERTENTLY SWITCHED TO THE "OFF" POSITION. PERFORMED DC ESSENTIAL GENERATION SYSTEM OPS TEST PER AMM TASK 24-31-00-710-8SDR DXTA2025120205923Battery Pack · malfunctionedDURING TEST OF EMER LIGHTS ON PRE FLIGHT WITH SELECTOR SELECTED ON DID NOT RECIEVE THE EMER LIGHTS ON CAS MESSAGE. UPON INSP, FOUND LIGHTS UNDER CREDENZA & DIVAN WERE NOT ILLUMINATED. TROUBLESHOT DOWN TO FAULTY ELPS NR 4, ELPS NR 3 & ELPS NR 2. ACCESSED TO ESDR DXTA2025120205924Handle · jammedMAIN CABIN DOOR HANDLE JAMMED OPEN. BOTH INSIDE AND OUTSIDE HANDLES WILL NOT WORK TO LATCH DOOR. ACCESSED DOOR PINS AND SECURED LOOSE HARDWARE AS NEEDED IAW SPM 20-00-00, OPS GOOD DOOR IS SATISFACTORY AT THIS TIME.SDR DXTA2025120205925Battery Pack · faultedALL EMERGENCY LIGHTS ARE ILLUMINATED WITH EMER LT SWITCH IN THE ARMED POSITION AND AIRCRAFT POWERED UP. REMOVED EMER LT FWD BATTERY. DUE TO ALL EMER LT ON IN ARMED POSITION. THEN INSTALLED CUSTOMER SUPPLIED NEW EMER LT BATTERY. REMOVED EMER LT AFT BATTERY. DSDR DXTA2025120205928Fuel Control · failedFUEL FEED 1 FAULT & FUEL FEED 2 FAULT MESSAGES DISPLAYED IN FLT, ACCOMPANIED WITH YELLOW XS OVER MOTIVE FLOW PUMPS ON FUEL SYNOPTIC PAGE. NR 1 MESSAGE APPEARED FIRST FOLLOWED BY NR 2 A FEW SECS LATER WHEN CLIMBING THROUGH APPROX FL280. ALL INDICATIONS REMAINESDR DXTA2025120205930Brake Sys · malfunctionedAFTER PARKING AND SETTING THE BRAKE THE RIGHT BRAKE CALIPER WAS SMOKING WITH BRAKES SET AND RELEASED. PERFORMED GVI OF BOTH RT MLG BRAKES AND WHEEL ASSEMBLIES WITH NO LEAKS OR DEFECTS NOTED. SET BRAKES AND LET SIT FOR 30 MINUTES WITH NO DEFECTS AND PUMPED BRSDR DALA2025120208801Floor Support · corrodedCORROSION ON THE ALC FLOOR SUPPORT AT BS 1470, LBL11. REPAIRED CORROSION ON ALC FLOOR SUPPORT AT BS 1470 LBL 11 IAW SRM 53-00-53-2R PROCEDURE 1. (1330771)SDR DALA2025120208800Floor Support · corrodedCORROSION ON THE LOWER SURFACE OF THE ALC FLOOR SUPPORT AT BS 1330, RBL15. REPAIRED FLOOR SUPPORT AT BS 1330, RBL 15 IAW SRM 53-00-53-WR REPAIR 1 FIG 201. JOB C/W REMOVED STREAMERS. SEE PW FOR ALL WORK COMPLETE. (1330758)