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 CALA2025080707416Door · no discrepancyREMOVED LT FWD OVERWING EMERGENCY EXIT HATCH TO FOM IAW AMM 52-22-02-002-001. INFO ONLY UPDATED REFERENCE FOR REMOVED AMM 52-22-01-902-001 INSTALLED L/H FWD OVERWING EMERGENCY EXIT HATCH IAW AMM 52-22-01-402-074. OPS CHECK OK. C/W RII INSP OF INSTALL OF ORIGINSDR CALA2025080707415Girt Bar · no discrepancyMATERIAL AROUND GIRT BAR STIFF. HARD TO POSITION GIRT BAR. INSPECTED GIRT BAR MATERIAL AT ALL DOORS, NO DEFECTS NOTED. REF AMM 25-66-01. OK FOR SVC.SDR CALA2025080707414Proximity Sensor · out of adjustR FWD DOOR ECAM AFTERT/O TWICE SPORADICALLY.PRESS NORMAL. ADJUSTMENT OF THE FWD PAX/CREW DOOR.AMM TASK 52-71-00-820-002-A: ADJUSTMENT OF THE PROXIMITY SWITCHES LOCKED FOR FIX..WAS A DIVERSION INTO TPA YESTERDAY FOR THE SAME ISSUE. HAS HISTORY.CONTACT TOMC ONCSDR CALA2025080707413Sensor · dirtyENTRY DOORS LIGHT SHOWS OPEN EVEN WHEN DOOR IS CLOSED FWD DOOR 1 LEFT IS CLOSED, LOCKED AND LATCHED. REF MEL 5271C. INITIAL DEFFERAL CHECKS CARRIED OUT. PSEA TARGET FAR. SECOND DEFFEREAL ENTERED. ENTRY DOORS LIGHT / EICAS MESSAGE(S) INOPERATIVE OR REMAINS ON ASDR CALA2025080707412Girt Bar · no discrepancyRT SIDE OF 1R GIRT BAR APPEARS TO BE LOOSE. GIRT BAR NOT ANYMORE LOOSE THAN ANY OTHERS. OPS CHECK GOOD. NO FAULTS FOUND.SDR CALA2025080707411Warning Light · false activationDURING CLIMB AT FL300, FWD SERVICE DOOR LIGHT ILLUMINATED. BEFORE RUNNING CHECKLIST LIGHT WENT OUT, REQUEST DEFERRAL OF FWD SERVICE DOOR INDICATION, DEBRIEFED FLIGHT CREW, NO MOVEMENT OF HANDLE DETECTED IN FLT OR ON GROUND, DOOR OPERATES NORMALLY. APPROVEDSDR CALA2025080707410Bottle · no discrepancyR2 DOOR SLIDE AND BOTTLE, PLEASE VERIFY R2 DOOR-MOUNTED ESCAPE SLIDE BOTTLES EXPIRATION DATE AND THE SLIDE EXPIRATION DATE AND CONTACT TOMC WITH THE DATES ON BOTH AND DOCUMENT HERE ALSO PLEASE RECORD THE SLIDE P/N AND SN AND THE BOTTLE P/N AND S/N ON THIS LOGSDR CALA2025080707409Slide · unsecure1R DOOR BUSTLE IS HANGING OUT, TUCKED IN 2 INCHES OF EXCESS SLIDE MATERIAL WITHOUT OPENING SLIDE PACK IAW AMM TASK 25-66-01-400-801 OK TO CONTINUE.SDR CALA2025080707408Warning Message · false activationDOOR FLIGHT LOCK 3R EICAS STATUS NR 3 RIGHT PASSENGER ENTRY DOOR FLIGHT LOCK COMMAND/FLT LK RLY/SEN SOR DISAGREEMENT. FOLLOWED FIM 52-11 TASK 806. PERFORMED FLIGHT LOCK OPS TEST SEVERAL TIMES, LOCK ENGAGES NORMALLY. MAINTENANCE MESSAGE DOES NOT SHOW. CLEANED SDR CALA2025080707407Slide · not reportedR1 ESCAPE SLIDE ASSEMBLY REPLACED REF AMM 25-62-44. REPLACED R1 ESCAPE SLIDE ASSEMBLY REF AMM 25-62-44. ACP RII INSP REF GMM 09-25-05.SDR JJBA20250806011Nut Plate · brokenLH LEADING EDGE #2 OUTBD RIB, X2 NUT PLATE FOUND BROKEN. LH WING LEADING EDGE #2, LOWER SKIN CUT-OUT AND FILLER INSTALLED INBD OF STA YS=6405.SDR WX0A2025080632528Unknown · odorAIRCRAFT NOT GROUNDED, BOTH FWD AND REAR FLT ATTND REPORT DIRTY SOCK SMELL ON LAST TEN MINUTES OF DESCENT. NO SMELL NOTED IN COCKPIT. RESOLVED ON W/O: 528294 TASKCARD: NR-00003, TC 21-000-002 OIL TYPE SMELL - PHASE 2 C/W.SDR WX0A2025080632526Strap · unsecure(AIRCRAFT NOT GROUNDED) L1 DOOR SLIDE ARMED INDICATOR STRAP WILL NOT STAY ATTACHED. / INSTALLED NEW BUTTON IAW ALLEGIANT PROCEDURES/ SIP. A/C OK FOR SVC"SDR JJBA20250806007Support · crackedLH SILL #1 BTW FR 18-22 FOUND CORRODED. LH SILL #1 BTW FR 18-22 CORRODED OUT OF LIMITS. REMOVED AND REPLACEDSDR ASAA2025080459902Door · no discrepancyDOOR R1 HARD TO OPEN REPORTED BY OPS FROM FOOD CONTRACTOR. GROUNDED - YES. OPERATED R1 DOOR MULTIPLE TIMES. OPERATIONAL CHECK GOOD IAW AMM 52-41-00.SDR FDEA202508041375Seat Track · no discrepancyAIRCRAFT REPAIR ASSESSMENT : EXISTING SPLICE REPAIR FOUND ON MDCC SEAT TRACK BTW FR31~34,-Y450 COMPLIED WITH ATTACHMENT B OF EO: E6-5100-7-5000 D7 PT1, TITLE: STRUCTURES - REPAIR CATALOG - A300/A310 REPAIR IDENTIFICATION & TRACKING REQUIREMENTS 14 CFR 121.SDR DALA2025080605885Plate · corrodedCORROSION ON LH FLOOR SIDE PLATES; FROM STA 727F+10 TO STA 794 ANDFROM STA 794 TO STA 847 AT AFT CARGO COMPARTMENT. LH FLOOR SIDE PLATES; FROM STA 727F+10 TO STA 794 ANDFROM STA 794 TO STA 847 AT AFT CARGO COMPARTMENT WERE REPLACED PER B737-800 SRM 51-40-02-0GSDR DALA2025080605883Flap System · faultedDECLARED EMERGENCY DUE TO THE FLAPS BEING LOCKED AT POSITION 2 WITH A FLAPS FAULT MESSAGE. RESET WING-TIP BRAKES. NO TROUBLE FOUND.SDR YENA2025080600807Skin · damagedDURING HEAVY MAINTENANCE: DURING INSTALL OF RUDDER L/R SIDES @ HINGE ARM AREA ON RUDDER HAS COMPOSITE DAMAGE; REF HAECO NON-ROUTINE 38246. REPAIRED RUDDER L/H AND R/H BR1 AND BR2 AREAS ZONE AJ 4EA AREAS IAW SRM 55-41-13-300-008 CAT A REPAIR. (CONSIDERED A MASDR SIMA20250804003Slide · detachedL1 SLIDE ASSEMBLY FELL OF WHILE CLOSING DOOR INSTALLED L1 DOOR SLIDE ASSY.OPC GOOD IAW ERJ AMM 25-65-01. SLIDE REMOVED AT TXK 08-05-25 LOG PG 106401511.MEL ITEM RESTORED.SDR CALA2025080607362O-Ring · wornHYDRAULIC CENTER SYSTEM, SUSPECT LEAK IN AREA OF AIR DRIVEN PUMP FILTER MODULE, LT WHEEL WELL HYDRAULIC PRESSURIZATION WITH ADP CUT OUT IAW AMM 29-11-00-862-216, LH WHEEL WELL ADP FILTER MODULE INLET PRESSURE UNION FOUND LEAKING HYD FLUID. O-RING ON THE INLET SDR CALA2025080607361Unknown · odorWET CHEMICAL STINGING ODOR DURING DECENT AT 5000 FT. NON-NORMAL PROC ACCOMPLISHED PERFORMED TSM TASK 05-50-00-810-831-A FOR INDENTIFICATION OF THE CAUSE FOR CABIN ODOR,SMOKE OR FUME. IAW TABLE CHART, THE RESULTS HAS CONCLUDED TO BE TYPE 10. NO SMELL OR LEAK SDR CALA2025080607360Oven · odorSMELL OF SMOKE, BURNING IN AFT SECTION OF ACFT. RAN APU & NR 2 ENGINE TO SIMULATE CONDITIONS WHEN SMOKE WAS REPORTED. MX, CAPTAIN, & FIRST OFFICER WALKED CABIN & SMELLED FOR SMOKE OR BURNING WITH ACFT DOOR CLOSED. NO SMOKE OR BURNING SMELL OBSERVED. RAN BOTSDR ASAA2025080459878Light · inoperativeROW 17 ABC SIDEWALL EMERGENCY EXIT LIGHT ROW INOP. GROUNDED - YES. REMOVED & REPLACED OVERWING EMERGENCY EXIT LIGHT ASSY IAW AMM 33-51-00. OPS CHK GOOD.SDR ASAA2025080459877Switch · malfunctionedFA REPORTS AFT ATTENDANT PANEL EMERGENCY EXIT LIGHTS SWITCH IS ILLUMINATED WITH A RED LED, NORMALLY LED IS GREEN. GROUNDED - YES. ACCOMPLISHED EMERGENCY LIGHTS FUNCTIONAL TEST PER AMM 33-51-00-006, ALL LIGHTS OPERATE NORMAL, A/C OKAY OF SERVICE. SEAMC NOTIFIESDR QXEA2025080500286Selector Valve · malfunctionedAFTER TAKEOFF, WHEN WE MOVED UP LANDING GEAR LEVER, WE GOT MASTER WARNING MESSAGE "LG LEVER DISAG'. WE DID QRH CHECKLIST AND MESSAGE DISAPPEARD. REMOVED FROM SERVICE. FERRIED FOR REPAIRS. REPLACED LG SELECTOR VALVE REF W/O: 354415 N/R-00004. OPS CHECK GOOD. RSDR QXEA2025080500287Door · no discrepancyL1 DOOR DIFFICULT TO OPEN. REMOVED FROM SERVICE.PERFORMED GVI OF L1 DOOR. NO DEFECTS NOTED. DOOR OPENS AND CLOSES NORMALLY. AC RETURNED TO SERVICE. NO PARTS REPLACED.SDR SWAA2025080598513Latch · dirtyAFT GALLEY SERVICE DOOR GIRT BAR LATCH BROKEN.<[01] REMOVED DEBRIS FROM AFT GALLEY SERVICE DOOR WITH NO DAMAGE OR DEFECTS NOTED PER AMM 25-66-01. OP'S CK'D GOOD. A/C OK FOR SERVICE.SDR DXTA2025080504470Control Valve · faultedWHEN WE PUT THE LANDING GEAR DOWN RECIEVED AN ICAS MESSAGE. AUTO BRAKE FAIL AND BRAKE 50% DEGRADE. THE MESSAGEFROM THE MX LOG SAID RIGHT OUT BOARD BRAKE CONTROL VALVE CONTROL ERROR. FAULT CODE 32-43-00. SEE PICTURES TECHS REMOVED THE RH OUTBOARD BRAKE CONTROLSDR QMLA20250820083Fuel Cap · leakingPILOT REPORTED AT 0410 THAT THE CREW SMELT FUEL IN THE CABIN. AIRCRAFT TAKEN OUT OF SERVICE. ARRIVED AT BASE AND HEARD FROM THE PILOT THAT THE CREW HAD SMELT A PROPANE LIKE SMELL. ASKED IF THEY HAD GOTTEN FUELED BEFORE RETURNING TO BASE, THEY DID GET FUEL BEFSDR AALA202508056958Plunger · missingAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FORWARD OVERWING EXIT, LATCH HANDLE IS MISSING A BUSHING, THE SPRINGS AND THE PLUNGERS. MAINTENANCE INSTALLED NEW BUSHING, SPRINGS AND PLUNGERS ON LATCH HANDLE ASSEMBLY. MAINTENANCE INSTALLED LATCH HANDLE ASSEMBLY PER ASDR AALA202508050447Spring · missingAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FORWARD OVERWING EXIT, LATCH HANDLE IS MISSING A BUSHING, THE SPRINGS AND THE PLUNGERS. MAINTENANCE INSTALLED NEW BUSHING, SPRINGS AND PLUNGERS ON LATCH HANDLE ASSEMBLY. MAINTENANCE INSTALLED LATCH HANDLE ASSEMBLY PER ASDR AALA202508055760Bottle · 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 AALA202508052455Bushing · missingAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FORWARD OVERWING EXIT, LATCH HANDLE IS MISSING A BUSHING, THE SPRINGS AND THE PLUNGERS. MAINTENANCE INSTALLED NEW BUSHING, SPRINGS AND PLUNGERS ON LATCH HANDLE ASSEMBLY. MAINTENANCE INSTALLED LATCH HANDLE ASSEMBLY PER ASDR AALA202508053342Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: R2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202508055807Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: L2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202508050927Unknown · odorAIRCRAFT WAS GROUNDED: DIRTY SOCK SMELL ON DESCENT IN FLIGHT DECK. (OPEN)SDR AALA202508053216Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202508050360Bottle · 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 AALA202508056747Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: LEFT EMERGENCY EXIT DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202508059395Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #1 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR IPXA2025080500763Light · inoperativeL1 EMERGENCY LIGHT ABOVE DOORWAY HAS LIGHT INOPERATIVE ON LOWER SIDE OF ASSY. REMOVED AND REPLACED LIGHT PER AMM 33-51-13. OPS CHECK OK.SDR IPXA2025080583394Selector Valve · inoperativeDURING CRUISE, NOTICED SLOW DEPLETION OF GREEN SYSTEM HYDRAULIC RESERVOIR. SHORTLY THEREAFTER, RECIEVED €ŒGREEN RSVR LO LEVEL€? ECAM MESSAGE. RAN ECAM ITEMS AND QRH / AOM ASSOCIATED CHECKLISTS. ENGAGED. FOUND LANDING GEAR SELECTOR VALVE 3GA LEAKING BEYOND SDR HNAA2025080500535Warning System · false activationABORTED TAKE OFF DUE TO RUD SYS 1 INOP CAUTION MSG R & R #100 AND AT 00 RUDDER PRESSURE SWITCHES IRT AMM 27-23-04. OPS CHECK OF RUDDER SYSTEMS SATISFACTORY IRT AMM 27-23-00. BOTH SYSTEMS BLED AS NECCESSARY. NO ABNORMAL MSGS SEEN DURING HIGH POWER CHECK. OK SDR HNAA2025080500534Inverter · abnormalEMERGENCY EXIT LIGHT AT ROW 3B INOP FACT 04AUG25 07:56 SBY R&R #300 INVERTER IAW AMM 33-50-11SDR FDEA202508041366Oxygen Bottle · overservicedWALK AROUND OXYGEN BOTTLE IN CLOSET ON FLIGHT DECK OVER PRESSURIZED. NEEDLE OVER RED BAND. AMM: 35-30-00-2 DUE TO WARM TEMPERATURE IN CDG, PORTABLE O2 CYLINDER PX CAN BE READ AT THE CORRECT SERVICEABLE BAND, ACUTALLY 82 *F, CORRECTION CHART APPROVED SESDR UIEA2025080401084Flashlight · no discrepancyL1 DOOR ENTRY WAY EMERGENCY FLASHLIGHT INOPERATIVE. OPS CHK ENTRY WAY FLASHLIGHT IAW AMM 25-05-03, OPS CHECK GOOD.SDR AALA202508050886Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORT THAT THE AFT RIGHT LAVATORY DOOR STICKS AND IS DIFFICULT TO OPEN AND CLOSE. ADJUSTED DOOR THRESHOLD TO ALLOW PROPER DOOR CLEARANCE. PER AMM 25-40-08. OPERATIONAL CHECK GOOD.SDR AALA202508055175Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR IS STUCK CLOSED. LUBRICATED AFT LEFT LAVATORY DOOR TRACK AND LOCK. PER AMM 25-40-15. OPERATIONAL CHECK GOOD.SDR AALA202508053568Light · dislodgedAIRCRAFT WAS NOT GROUNDED: 24C EMERGENCY AISLE LIGHT HANGING BY A WIRE. SECURED 24C AISLE EMERGENCY LIGHT.