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 CALA2025073107177Wire · brokenEMERGENCY LIGHTS - OPERATIONAL TEST WITH THE TEST SWITCH PROCEDURE - AISLE PATH LIGHTING AT ROW 31 DOES NOT ILLUMINATE. FOUND BROKEN GROUND WIRE AT SPLICE LOCATED UNDER SEAT ROW 31. RESPLICED WIRE UNDER SEAT ROW 31 IN REF. SWPM 20-30-12 AND DRAWING BR2013-P-75SDR DXTA2025080104418Overheat Sensor · false indicationAFTER LANDING, LEFT BRAKE TEMP ROSE TO 14, RIGHT BRAKES WERE A MORE TYPICAL 4. UNLOADING BAGGAGE LEFT MAINS WERE SMOKING. PF OBSERVED SLIGHT PULLING TO THE LEFT. JACKED AIRCRAFT AND FOUND #1 AND #2 BRAKES NOT DRAGGING OR ANY OTHER DISCREPANCIES. #1 BRAKE PINSSDR AALA202507311364Sensor · out of adjustAIRCRAFT WAS GROUNDED: AFTER TAKEOFF NOSE GEAR DISAGREE WHEN LANDING GEAR LEVER IN THE OFF POSITION. TROUBLESHOT PER FIM 32-30-00-810-811. FOUND NOSE LANDING GEAR AIR GROUND SENSORS OUT OF ADJUSTMENT. ADJUSTED SENSOR, PER AMM 32-09-02-400-801. OPERATIONAL CHESDR NACA2025073000001Elec Connector · out of limitsFOUND THE LEFT ENG EEC C2 MAINT MSG. PERFORMED TIS FOUND LT ENG 21B LVDT CONNECTOR 0834OP BETWEEN P2N & PIN 2 RESISTANCE OUT OF LIMITS IAW FIM TASK 8038-71-01, TASK 848, REV 145. REMOVED AND REPLACED LT ENG INBD TR LOCK HYD ACTUATOR & CARRIED OUT INSTALL TESDR HALA20250731042Vane · dentedDENT ON LH WING FLAP FIXED VANE INBOARD DENETIONS 5" X 1 ". REPLACED LT WING INBRD FLAP FIXED VANE PER AMM 27-50-02 OPS CHECK GOOD.SDR HALA20250731041Power Supply · inoperativeOVERWING EMERGENCY LIGHTING INOPERATIVE. REMOVED AND REPLACED OVERWING EMERGENCY BATTERY POWER SUPPLY PER AMM 33-51-06. OPS CHECK GOOD. AC OK TO CONTINUE SERVICE.SDR COEA2025073101901Acm · seizedFLIGHT 7820, ENROUTE GTF-MSO EXCESS CABIN ALTITUDE ALERT/WARNING LIGHT ILLUMINATED IN FLIGHT. AFTER EXTENSIVE TROUBLESHOOTING, MAINTENANCE REPLACED THE #1 ACM AND TIC VALVE. ALL CHECKS GOOD.SDR SWAA2025073196729Sign · looseEMERGENCY EXIT SIGN IN AFT GALLEY NEEDS SECURED. PERFORMED EA M-24-133-00396, SECURED EMERGENCY EXIT SIGN IAW TSR 2025006998, OK TO CONTINUE.SDR SWI2025F01063A/C Pack · smokeSMOKE IN THE CABIN. TURN OFF BOTH PACKS SEEMED TO STOP THE SMOKEY CONDITIONS (FLIGHT 6374) PERFORMED TROUBLESHOOTING OF SMOKE IN CABIN IAW FIM 21-22-00, TROUBLESHOOTING & TALKING WITH FLT CREW, FLT CREW REPORTED SMOKE IN CABIN SOON AFTER PACKS WHERE TURNED SDR SWIA202507310001Window · crackedLEFT WINDOW SHATTERED CLIMBING THROUGH 26000 FT (FLIGHT 6444) REMOVED AND REPLACED CAPTAINS SIDE WINDOW IAW TASK CARD 56-220-1000-SKY. OPS CHECK OF WINDOW HEAT GOOD. LEAK CHECK GOOD. AIRCRAFT SAFE FOR RETURN TO SERVICE.SDR GTIA2025073139026Unknown · odorFUME EVENT DURING DESCENT BEGINING AT 9000FT. DESCRIPTION OF ODOR/FUMES: CONTINUOUS AND DISCOMFORTABLE, SOUR SMELL. APPARENT CABIN SOURCE: CABIN AIR SUPPLY VENTS. FLIGHT DECK. NO VISIBLE SMOKE/HAZE. NO MEDICAL ATTENTION REQURIED.--SDR DALA2025073105754Engine · faultedDURING MTC DIRECTED #1 MANUAL ENGINE START, THE EGT EXCEEDED START LIMIT MOMENTARILY WITH AN ENG 1 START FAULT EGT OVER LIMITS MESSAGE, APPROXIMATED TO BE AROUND 723 OC FOR 2 - 3 SECONDS, RETURN TO GATE. GVI INLET AND EXHAUST. NO DAMAGE FOUND. REQUIRED BOROSCSDR DALA2025073105751Fitting · damagedDAMAGE ON FITTING OB SIDE - FORWARD SIDE OF 62 STRINGER 3L. REMOVED AND REPLACED BRACKET PER ERA 627461-14 REV A.SDR DALA2025073105750Tiller · faultedSHIP 3120 NWS TILLER STICKY. ADJUSTED CAPTAIN NWS TILLER, REF A319 AMM 32-51. OK FOR SVC.SDR DALA2025073105748Ecs · odorODOR AND FUME DETECTED IN FLT DECK. PERFORMED W/C 0550-2001, 0550-2002 & 2100-2005. AFTER ECS DECONTAMINATION REVERSE DUCT BURN PROCEDURE. NO FURTHER SMELLS NOTED IN FLIGHT DECK OR CABIN.SDR DALA2025073105745Stop Fitting · deterioratedDETERIORATED PASSENGER CREW DOOR STOPS IN AFT POSITION 4, 5, 6. REPLACED PASSENGER CREW DOOR STOPS SCREWS IN AFT POSITION #4, #5, #6 IAW AMM 52-13-31-000-002-A AND AMM 52-13-31-400-002-A.SDR DALA2025073105744Arming Lever · no testDID NOT PASS OPERATIONAL TEST, PAX DOOR ARMING LEVER WITH DOOR IN UP POSITION. PERFORMED ADJUST ON ARMING LEVER TO LOCK WITH DOOR IN UP POSITION OF PASSENGER CREW DOOR IAW AMM 52-11-22 -000-001-A AND AMM 52-11-22-400-001-A.SDR DALA2025073105743Mechanism · deterioratedDETERIORATED PASSENGER CREW DOOR 832 FLEXIBLE CONTROL OF EMERGENCY ESCAPE SLIDE MECHANISM AT AFT GALLEY AREA. REPLACED PASSENGER CREW DOOR 832 FLEXIBLE CONTROL OF EMERGENCY ESCAPE SLIDE MECHANISM AT AFT GALLEY AREA AS PER A320 FAM AMM 52-13-22-000-001-A AND ASDR DALA2025073105742Seat Track · corrodedCORRODED SEAT TRACK -Y765 AND FR68 IN PASSENGER CABIN. FEPLACED THE SEAT TRACK IAW SRM 51-42-11 AND SRM 51-72-11.SDR DALA2025073105741Web · corrodedCORROSION WEB, FRAME 16, STR23L FWD GALLEY AREA. REPLACED WEB IAW SRM 51-42-11.SDR DALA2025073105740Seat Track · corrodedCORRODED SEAT TRACK -Y1292 AT FR20 FWD GALLEY AREA. REPLACED THE SEAT TRACK IAW SRM 51-72-11 AND SRM 51-42-11.SDR DALA2025073105739Seat Track · corrodedCORRODED SEAT TRACK +Y765 AT FR66 AT AFT GALLEY AREA. REPLACED THE SEAT TRACK IAW SRM 51-72-11 AND SRM 51-42-11.SDR DALA2025073105738Floorbeam · corrodedCORRODED FLOORBEAM -Y1292 -1162, FR 67 RT AT AFT GALLEY AREA. REPAIRED THE FLOORBEAM IAW SRM 51-72-11 AND A319 SRM 51-42-11.SDR DALA2025073105737Seat Track · corrodedCORROSION SEAT TRACK -Y1162.5 LOC. AT LEVEL FR 68 RH AT AFT GALLEY AREA. REPLACED THE SEAT TRACK IAW SRM 51-72-11 AND SRM 51-42-11.SDR DALA2025073105736Seat Track · corrodedCORROSION SEAT TRACK -Y1292 LOC. AT LEVEL FR 66 RT AT AFT GALLEY AREA. REPLACED THE SEAT TRACK IAW SRM 51-72-11 AND SRM 51-42-11.SDR SCNA20250731290Bearing · failedLOUD NOISE FROM NLG DURING TAXI. FOUND L/H NOSE TIRE BEARING HAD FAILED. WHEEL ASSY IS DAMAGED AND THERE HAS ALSO BEEN DAMAGE TO THE AXEL.SDR DALA2025073105735Snubber · leakingL4 PASENGER DOOR SNUBBER LEAKING FLUID. REPLACED L4 DOOR SNUBBER TO BE INSTALLED ON AMDS CARD 5211-6005- 4L STEP 6.SDR DALA2025073105734Snubber · leakingL2 PASSENGER DOOR SNUBBER LEAKING AND NO FLUID INDICATION. REPLACED L2 PASSENGER DOOR SNUBBER.SDR AALA202507317926Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: ON FLIGHT ATTENDANTS SCREEN DISPLAY AT 1L, CHECK DOOR PRESSURE IN AMBER FOR THE 1L DOOR POSITION. MAINTENANCE SERVICED L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 25-22-00.SDR AALA202507316212Priority Valve · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO CLT DUE TO THE FLIGHT CREW REPORTING TJHAT A GREEN HYDRAULIC SYSTEM ENGINE #1 PUMP LOW PRESSURE ECAM MESSAGE DISPLAYED FOLLOWED BY A COMPLETE LOSS OF THE GREEN HYDRAULIC SYSTEM. THE SDR AALA202507311135Light · no testAIRCRAFT WAS NOT GROUNDED: CABIN CEILING EMERGENCY LIGHT INOPERATIVE AT SEAT ROW 27. REPLACED CABIN CEILING EMERGENCY LIGHT ASSEMBLY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-11.SDR FDEA202507301343Bulb · inoperativeR1 OVERHEAD EMERGENCY EXIT SIGN BARELY LIT. REMOVED AND REPLACED 9 FAULTY BULBS AT THE R1 EMERGENCY EXIT SIGN IAW AMM 33-51-01-2. OPS CHECK GOOD. A/C OK FOR SERVICE.SDR AALA202507316100Flashlight · no testAIRCRAFT WAS NOT GROUNDED: AFT GALLEY LEFT JUMP SEAT FLASHLIGHT NOT FLASHING GREEN. REMOVED AND REPLACED BATTERY. PER 25-64-00. OPERATIONAL CHECK GOOD.SDR AALA202507318470Door · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORT THAT LAVATORY DOOR FOR AFT LEFT LAVATORY-D IS DIFFICULT TO OPEN. REPORT IS THAT PASSENGERS ON INBOUND FLIGHT WERE BECOMING TRAPPED IN LAVATORY AND COULD NOT OPEN THE DOOR. INSPECTED AND LUBRICANT LATCH ASSEMBSDR AALA202507310404Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: L1 FLIGHT ATTADNETS REPORTS THE L1 DOOR GIRT BAR IS HARD TO INSTALL AND REMOVE. ADJUSTED L1 DOOR ESCAPE SLIDE PACK GIRT BAR BRACKET. PER AMM 25-66-01. OPERATIONAL CHECK GOOD.SDR AALA202507319089Slide · out of positionAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR SLIDE VISIBLE BENEATH COVER. REINSTALLED ESCAPE SLIDE PACK AT FORWARD SERVICE DOOR. PER AMM 25-66-01.SDR UIEA2025073001069Lens · scratchedOBSERVER SMOKE GOGGLES LENS SCRATCHED. REPLACED OBS SMOKE GOGGLE PER IPC 25-64-54-01B ITEM 30. NO FURTHER DEFECTS NOTED.SDR UIEA2025073001071Software · faultedL NAV WON'T ENGAGE. RELOADED ALL ASSOCIATED SOFTWARE INTO BOTH LT & RT FMC IAW AMM 34-61-00. ALL GROUND TEST PASSED. VERIFIED ALL SOFTWARE CORRECT CONFIG.SDR DALA2025073105733Sensor · out of rigDECLARED EMERGENCY DUE TO A FLAPS LOCKED MESSAGE. SYSTEM IS FAULTING LT MECHANICAL DRIVE. FOUND LEFT FLAP INTERCONNECT STRUT SENSORS OUT OF RIG. REPLACED STRUT AND RIGGED SENSORS. (LP 7043614)SDR DALA2025073105732Bleed Air Sys · faultedATB DUE TO A RT ENGINE BLEED FAULT WITH A REPORTED MUSTY ODOR BY THE CABIN CREW. SYSTEM FAULTING THE PRV. REPLACED OVP, PRV, HPV, AND SENSE LINE 1 BETWEEN HP AND PRV.SDR DALA2025073105730Valve · faultedDIVERTED TO SLC DUE TO AN ENGINE 2 BLEED FAULT. COULD NOT CONTINUE DUE TO ICING CONDITIONS. REPLACED ENGINE 2 FAN AIR VALVE. (LP 7057006)SDR DALA2025073105729Spinner · leakingFA REPORTS DIRTY SOCK SMELL IN COMFORT PLUS WHILE DESCENDING THROUGH 11,000 FEET. PERFORMED SMOKE CHECKLIST IN E-QRH. FA REPORTED SMELL DISSIPATED APPROXIMATILY 2 MINUTES LATER. FOUND OIL IN #1 ENG SPINNER. REMOVED AND REPLACED #1 ENG FAN SHAFT COVER SEAL IAW SDR YENA2025073100789Skin · corrodedDURING HEAVY MAINTENANCE: FUSELAGE SKIN HAS CORROSION AT LAV VENT FR69-70 STR 32R-31R. RESOLVED ON W/O: 1428515 TASKCARD: NR-00002. REF HAECO WO 440633 NR 40009. PERFORMED REPAIR IAW SRM 53-41-11-300-004. TO BE REINSPECTED AT 60000FC FROM ACFT FIRST FLIGHT PSDR CALA2025073107147Slide · out of positionEMERGENCY SLIDE AT 1R MATERIAL TOUCHING FLOOR. REMOVED AND REINSTALLED EMERGENCY SLIDE PACK AND COVER AT DOOR 1R REF AMM TASK 25-66-01-400-803. NO DEFECTS AT THIS TIME. SLIDE RENDER CHECKLIST COMPLETED. ACCOMPLISHED RII REQUIREMENTS FOR DOOR 1 RT REMOVEL ASDR CALA2025073107146Window Frame · damagedREPAIR THE RH #3 WINDOW FRAME E-F POST REF TO ECRA 5611-01314 R EV C PART 3. REPAIRED PER ECRA 5310-08655 REPAIR THE R3 WINDOW FRAME E-F POST REF TO ECRA 5611-01314 R EV C PART 3.SDR CALA2025073107145Lens · missingSEAT 1B EMERG LIGHT COVER MISSING. REPLACED FLOOR PROXIMITY EMERGENCY LIGHT AT SEAT 1B, CHECKS OK. REF AMM 33-51-11.SDR CALA2025073107144Light · damagedCREW REPORT - SEAT 12C AISLE PATH WHITE EMERGENCY LIGHT DAMAGED AND INOPERATIVE. REMOVED AND REPLACED WHITE LIGHT LENS AND FUSE TO POWER SUPPLY M2503. ALL EMERGENCY LIGHTS FUNCTIONALLY CHECK GOOD. REF AMM 33-51-00SDR CALA2025073107143Sensor · dirtyDOOR 4L KNUCKLE KNOCKER NOT COMING OUT AND SLIDE ARMED LIGHT NOT ILLUMINATING FOUND DOOR ARMING PROPERLY BUT MICROSWITCH THAT SENSES SIGNAL TO ARM LIGHT WAS CAKED IN DIRT AND GRIME. CLEANED MICRO SWITCH SENSOR AND OPS CHECK GOOD AT THIS TIME REF AMM TASK 25-66SDR CALA2025073107142Battery Pack · no testEMERGENCY PASSENGER CABIN LIGHTS M1674 FAILS BATTERY CAPACITY CHECK. REMOVED AND REPLACED EMERGENCY LIGHTS BATTERY PACK M01674 AND PERFORMED INSTALLATION TEST IAW B737 A.M.M. 33-51-06-960-805. TEST OK.SDR CALA2025073107140Lamp · inoperativeEMERGENCY LIGHTING SYSTEM OPS CHECK, DOOR 1L EXTERIOR EMERGENCY LIGHT IS INOPERATIVE. RELAMPED DOOR L1 EXTERIOR EVAC LAMP IAW AMM 33-51-04-960-801. OPS CHECKS GOOD.