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 ASAA2026010362669Light · inoperativeFLOOR LIGHTING IN FWD GALLEY UNDER GALEY CART DO NOT ILLUMINATE. GROUNDED - YES. INSTALLED FLOOR LIGHTING IN FWD GALLEY UNDER CARTS PER AMM 33-51-21-400-801-A OPS CHECK OK. OK FOR SVC.SDR SWAA2026010657926Cover · brokenLIGHT COVER BROKEN AT ROW 10 CABIN AISLE EMERGENCY LIGHT HOUSING MOUNTED IN THE OVERHEAD BIN BULLNOSE. OK TO CONTINUE IAW MEL 33-15-02 SP1. REMOVED AND REPLACED ROW 10 DEF EMERGENCY LIGHT LENS COVER REFERENCING AMM 33-51-03. OPS CHECK GOOD.SDR SWAA2026010657802Hook · out of adjustFORWARD ENTRY GIRT BAR DIFFICULT TO DISARM. ADJUSTED GIRT BAR HOOKS PER SIPSDR SWAA2026010657905Lens · missingEMERGENCY AREA LIGHT LENS MISSING ABOVE SEAT ROW 8 ABC. REPLACED EMERGANCY AREA LIGHT LENS IAW AMM 33-51-03.SDR SWAA2026010657828Cover · detachedFO SIDE EMERGENCY EXIT PLASTIC COVER FELL OFF. REPLACED THE RT OVERWING EXIT EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51 04. OPS CHECKED GOOD.SDR SWAA2026010657914Sign · looseMID CABIN EXIT SIGN ON CEILING LOOSE. SECURED EXIT SIGN PER MM 33-51-01SDR R61A2026010300004Spda · failedCOULD NOT SELECT THE GEAR HANDLE TO THE UP POSITION ON TAKEOFF. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. REPLACED SPDA NR 1 DC POWER R MODULE.SDR AALA202601061491Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT SERVICE DOOR RIGHT BRACKET IS BENDED RESULTING IN GIRT BAR JAMING GIRT BAR IT CANNOT SAFELY BE MOVED OUT OF THE ARMED POSITION. ADJUSTED AND SECURED GRIT BAR CLIP ON LEFT SERVICE DOOR RIGHT HAND CLIPPER. PER AMM 25-66-00.SDR AALA202601061105Sign · missingAIRCRAFT WAS NOT GROUNDED: SEAT 16 AND 17DEF MISSING EMERGENCY EXIT LIGHT. REMOVED AND REPLACED EMERGENCY EXIT SIGN. PER AMM 33-51-01.SDR AALA202601063248Door · not openedAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR HARD TO OPEN. INSTALLED MISSING SCREW FOR LAVATORY-D DOOR ROLLER. PER CMM 25-40-64.SDR AALA202601064177Fuel Filter · cloggedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: AFTER TAKEOFF RIGHT FUEL BYPASS LIGHT ILLUMINATED, FUEL WAS ONLY BEING FEED FROM THR RIGHT WING FUEL TANK. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT CVG. REMOVED AND REPLACED FUEL FILTER SDR AALA202601060136Pressure Switch · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: AFTER TAKEOFF RIGHT FUEL BYPASS LIGHT ILLUMINATED, FUEL WAS ONLY BEING FEED FROM THR RIGHT WING FUEL TANK. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT CVG. REMOVED AND REPLACED FUEL FILTER SDR AALA202601062621Apu · contaminatedAIRCRAFT WAS GROUNDED: REPEATED FUMES IN THE COCKPIT. **SUPPLEMENTAL REPORT FOR (AALA202601052621): SUBMITTED 01/05/2025 BY DFW: ACCOMPLISHED TROUBLESHOOTING IAW JC 08L00021001 AND FOUND DEICING FLUID NEAR APU INLET ACCOMPLISHED PROCEDURES IN JOB CARD TO REMOVSDR AALA202601069455Circuit Breaker · defectiveAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO DEN DUE TO THE FLIGHT CREW REPORTING THAT THE BLUE HYDRAULIC SYSTEM PUMP FAILED WHILE IN CRUISE AT FL320 AFTER APPROXIMATELY 1 HOUR IN FLIGHT. THE FLIGHT CREW NOTED THAT CIRCUIT BREASDR AALA202601062502Terminal Block · defectiveAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO DEN DUE TO THE FLIGHT CREW REPORTING THAT THE BLUE HYDRAULIC SYSTEM PUMP FAILED WHILE IN CRUISE AT FL320 AFTER APPROXIMATELY 1 HOUR IN FLIGHT. THE FLIGHT CREW NOTED THAT CIRCUIT BREASDR AALA202601065933Pump · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO DEN DUE TO THE FLIGHT CREW REPORTING THAT THE BLUE HYDRAULIC SYSTEM PUMP FAILED WHILE IN CRUISE AT FL320 AFTER APPROXIMATELY 1 HOUR IN FLIGHT. THE FLIGHT CREW NOTED THAT CIRCUIT BREASDR DXTA2026010606426Spring · brokenUPON MAIN CABIN DOOR CLOSURE FROM INSIDE OF AIRCRAFT COUNTER SPRING BROKE. CABIN DOOR IS CLOSED MANUALLY FROM OUTSIDE AND WILL FREE FALL OPEN WHEN UNLATCHED. GAINED ACCESS TO MED COUNTERBALANCE SPRING. COMPLETED GVI AND NOTED FWD SPRING IS BROKEN. REMOVED RESDR VNAA2026010611101Controller · faultedRIGHT PITOT HEAT CAUTION MSG. REMOVED AND REPLACED RT ADSHC IAW AMM 30-31-15-000/400-801. OPS CHECK GOOD. CYCLED AC AND RT PITOT HEAT NO FAULT.SDR DXTA2026010606416Control Valve · faultedSIX HOURS INTO THE FLIGHT R ENG OIL FILTER CAS MESSAGE DISPLAYED FOLLOWED R ENG OIL LOW PRESS CAS MESSAGE. OIL PRESSURE WAS 40 PSI LESS THAN THE LEFT ENGINE. FAULT CODES: 7321218ENGRA AND 7321218ENGRB. AFT TRIM AIR VALVE REPLACEMENT PERFORMED IAW AMP BD700-A-SDR SCNA20260106009Light · inoperativeABOVE AISLE EMERGENCY LIGHTS INOP. AT ROW 5, 10, AND 14DEF. ( INTERIOR EMERGENCY EXIT LIGHTING SYSTEM; EMERGENCY AISLE LIGHTS ) REMOVED AND REPLACED BATTERY PACK AT ROW 11 IAW AMM 33-51-06 OPS CHECK GOOD. OK FOR SERVICE THIS CLEARS MEL.SDR SCNA20260106008Light · inoperativeRIGHT EMERGENCY EXIT AFT SIDEWALL LIGHT INOPERATIVE. R & R THE EMERGENCY LIGHT IAW AMM 33-21-00. OPS CHECKED GOOD.SDR CALA2026010612706Fuel Cap · missingFUELER REPORTED THAT THE FUEL CAP IS MISSING. NO LEAKS NOTED FROM COUPLING. REPLACED FUEL CAP. OK FOR SVC.SDR CALA2026010612705Protector · damagedFOUND DAMAGE TO AFT EDGE PROTECTOR. REF ECRA 5308-01193. PERFORMED INTERIM REPAIR PER STEP 1. NO FURTHER DEFECTS NOTED AT THIS TIME.SDR CALA2026010612698Window Frame · crackedCRACK FOUND AT LH SIDE NUMBER 3 WINDOW FRAME HOLE #3 AT 3 O'CLOCK POSITION. ACCOMPLISHED REPAIR AT L/H #3 WINDOW FRAME E-F PER ESR 6-13332-WI-P3 AND ECRA 5310-08764.SDR CALA2026010612694Door · fod1R DOOR DIFFICULT TO ARM/DISARM REMOVED DEBRIS FROM 1R ENTRY/SERVICE DOOR AND PERFORMED OPERATIONAL TEST REF AMM TASK 52-11-00-715-128 WITH GOOD RESULTS. OK FOR FURTHER SERVICE.SDR ASAA2026010363543Door · stiffL1 DOOR EXCESSIVELY HARD TO SWING OPEN OR CLOSED. FEELS HEAVY ON HINGE POINTS AND REQUIRES UNUSUALLY ADDITIONAL EFFORT. GROUNDED - YES. PERFORMED AMM TASK 52-11-00-200-801. FOUND NO EXCESSIVE WEAR OR DRY AREAS. FOUND NO LEAKAGE OR WEAR ON SNUBBER. DOOR OPERASDR QXEA2026010500003Hydraulic Line · leakingFLIGHT 2035. ON APPROACH RECEIVED A HYD 2 LO QTY FOLLOWED BY THE HYD 2 LO PRESS MESSAGE. EMERGENCY DECLARED WITH ATC. LANDED SAFELY AND WAS TOWED INTO THE GATE. NO ADVERSE PASSENGER REACTION. REMOVED FROM SERVICE. REPLACED NR 2 ENGINE DRIVEN HYDRAULIC PUMP. SDR QXEA2026010500004Door · fodFLIGHT 2307. FLIGHT ATTENDANT UNABLE TO DISARM FROM INSIDE R2 DOOR. REMOVED FROM SERVICE. INSPECTED AND FOUND TO DEBRIS JAMMING THE R2 DOOR. CLEANED AREA AND REMOVED OBJECTS INSPECTED AREA NO DAMAGE FOUND OPERATED DOOR AS NORMAL. NO DEFECTS NOTED. RETURNED TO SDR SWAA2026010557829Fan · odorSMELL OF ELECTRICAL CIRCUIT IN CABIN NO SMELLS IN COCKPIT. SMELL WAS MID CABIN SOURCE UNKNOWN NO SMOKE JUST SMELL. BOTH ENGINE BLEEDS ON BOTH PACKS AUTO. APU OFF. FOUND LT RECIRC FAN CIRCUIT BREAKER OPEN; REMOVED AND REPLACED LT RECIRC FAN IAW AMM 21-25-02; SDR SWAA2026010557910Battery · no testFWD FA JUMPSEAT FLASHLIGHT WILL NOT TEST. REMOVED AND REPLACED FWD FA FLASHLIGHT BATTERY IAW AMM 25-64-00. OPS CHECKED GOOD.SDR SWIA2026010500003Thrust Reverser · warning messageLEFT THRUST REVERSER UNLOCKED IN CLIMB. REF FIM 78-30-00 FIG. 103 FOR TROUBLE SHOOTING (FLIGHT 5029) DEFERRED PER MEL 78-30-1 MX ACTION C/W AIRCRAFT OK FOR CONTINUED SERVICESDR AALA202601052621Unknown · fumesAIRCRAFT WAS GROUNDED: REPEATED FUMES IN THE COCKPIT. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR UIEA2026010300003Plug · leakingDIVERSION ENGINE 3 OIL QUANTITY LOSS. INSPECTED #3 ENG AND FOUND OIL LEAKING FROM #3 IDG. DEACTIVATION BLANKING PLATE, REMOVED BLANKING PLATE AND FOUND DRIVE SEAL PLUG MISSING & INSTALLED DRIVE SEAL PLUG PER MEL 24-11-01A. RAN ENG IAW AMM 71-00-00, LEAK CHECKSDR DALA2026010500086Proximity Sensor · faultedDOOR R AFT CABIN ECAM MESSAGE OCCURRED IN FLIGHT, PRESSURIZATION IS NORMAL. REPLACED PROX SENSORS PER A330 AMM 52-71. OK FOR SERVICE. (7380486)SDR DALA2026010500081Wire · damagedEMERGENCY LIGHTS AT SEATS 51J, 52A,52J, 53J, 56J, 57J AND ABOVE COMMON AREA SMOKE DETECTOR IN THE LDMCR NOT WORKING. REPAIRED WIRING AND REPLACED BATTERY PER A330 AMM 33-51. OK FOR SERVICE. (1383978)SDR GTIA2025010539234Flashlight · inoperativeFA L2 DOOR JUMPSEAT EMERG FLASHLIGHT FLASHING RED. . R & R THE FLASHLIGHT AT L2 JUMPSEAT. AMM 25-63-00SDR JJBA20260105002Elec Connector · loose18CD LOWER EXIT IDENTIFIER LIGHT INOPERATIVE. FOUND 18CD LOWER EXIT IDENTIFIER LIGHT CONNECTIONS LOOSE, RESECURED LOWER EXIT IDENTIFIER. OPS CHECK SAT.SDR AALA202601057014Stay · stickingAIRCRAFT WAS NOT GROUNDED: MAIN CABIN DOOR DOES NOT LOCK IN THE OPEN POSITION. MAINTENANCE LUBRICATED MAIN CABIN DOOR STAY MECHANISM AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECKED IAW AMM 52-11-12.SDR DALA2026010500074Light · inoperative(LOG 7994335) 30D EMERGENCY PATH LIGHT INOP. REPLACED EMERGENCY PATH LIGHT AT SEAT 30D LIGHT OPS CHECK GOOD. OK SVC. REF B737 AMM 33-51.SDR DXTA2026010506418Light · inoperativeDURING PREFLIGHT LIGHT CHECK, THE CENTER FLOOR EMERGENCY LIGHT WAS FOUND TO BE NOT LIT UP. REPLACED CENTER FLOOR EMERGENCY LIGHT DUE TO LIGHT BEING INOP. REPLACED WITH NEW CUSTOMER PROVIDED EMERGENCY FLOOR LIGHT . WORK DONE IN REF TO AMM 33-52-11. OPS CHECK GSDR YENA2026010200007Inspection · noneFLT # 348 LAS- JFK (ETOPS). GROUND VERIFICATION REQUIRED DUE TO REMOVAL AND REPLACEMENT OF FDU NR 1. PERFORMED OPC OF ENGINE 1 FIRE AND OVERHEAT DETECTION SYS & OPS CHKD ENG 1 LOOP & SQUIB IAW AMM 26-12-00. BOTH OPC GOOD. NO FAULTS.SDR EVCA20260105001Bracket · leakingFUEL FUMES COMING OUT OF NURSE'S STATION SEAT BELT SLOT. REPAIRED BY REMOVING ROLLOVER ACCESS PANEL AND APPLIED SEALANT AROUND THE INERTIAL REEL RESTRAINT BRACKETSDR DALA2026010500057Unknown · odorFUME - DECLARED EMERGENCY DUE TO A DIRTY SOCK SMELL IN THE CABIN. COULD NOT DUPLICATE. NO SOURCE OF SMELL WAS FOUND. PERFORMED LEVEL A DECONTAMINATION. (LP 8498654)SDR DALA2026010500055Apu · contaminatedFUME - DECLARED EMERGENCY DUE TO A STRONG ODOR IN THE COCKPIT. POSSIBLE SOURCE OF SMELL WAS DE-ICING FLUID IN THE APU INLET, BUT THE SMELL COULD NOT BE DUPLICATED. PERFORMED LEVEL A DECONTAMINATION. (LP 8068890, 1382926)SDR DALA2026010500054Unknown · smokeSMOKE - CREW REPORTED BLACK SMOKE IN THE COCKPIT AND CABIN DURING LANDING ROLL OUT AND DECLARED AN EMERGENCY. AARF COULD NOT SEE ANY SMOKE. EVENT WAS POSSIBLY CAUSED BY RUNWAY TREATMENT CONTAMINATION. NO TROUBLE FOUND. PERFORMED NO-GO ECS DECONTAMINATION. (LPSDR SCNA20260105006Proximity Sensor · malfunctionedRED TAKEOFF CONFIG LIGHT AND TAKE OFF WARNING DURING TLCC WITH FLAPS 5 AND CONFIGURED FOR TAKEOFF NR 1 LEADING EDGE FLAP TRANSIT LIGHT DURING EXTENSION OR RETRACTION. R & R NR 1 KRUGER FLAP NR 1 PROX SENSOR IAW AMM 27-88-11-400-802. OPS CHECKED, LIGHTS OPERASDR AALA202601055247Light · dislodgedAIRCRAFT WAS NOT GROUNDED: SEAT 8D FWD. EMERGENCY EXIT LIGHT INOP. MAINTENANCE FOUND LIGHT ASSEMBLY DISLODGED , RE-SECURED AS REQUIRED.SDR AALA202601058756Hinge · looseAIRCRAFT WAS GROUNDED: FLIGHT DECK DOOR VERY DIFFICULT TO OPERATE IN FLIGHT. DOOR DRAGS ON FLOOR AND STRIKE LATCHES APPEAR TO PROTRUDE TOO FAR. DOOR CANNOT BE PULLED CLOSED FROM OUTSIDE FLIGHT DECK. MAINTENANCE REPLACE UPPER HINGE HARDWARE IAW AMM 52-51-11.SDR FDEA202601030004Door · inoperativeUNABLE TO CLOSE L-1 DOOR FROM INSIDE OR OUTSIDE. AMM 52-11-00-2 ACCESSED L1 DOOR VIA R1 DOOR, OPERATED L1 DOOR FROM INSIDE ACFT DOOR OPERATED NORAMLLY. OPENED AND CLOSED L1 DOOR FROM EXTERIOR, DOOR OPERATED NORMALLY. ALL OPENINGS AND CLOSINGS OF L1 DOOR NORMSDR FDEA202601030003Repair · not reportedEXISTING REPAIR FOUND AT # 2 CARGO DOOR AFT LOWER CORNER CUTOUT AREA COMPLIED WITH EA # F-5330-T0305556 B TITLE: FUSELAGE PLATES & SKINS - REPLACEMENT OF EXISTING STA 1440 FUSELAGE SKIN REPAIR AT 24R-25R (# 2 CARGO DOOR OPENING)