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 AALA202512032424Bleed Valve · warning messageAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED ON FINAL APROACH INTO TPA DUE TO THE FLT CREW REPORTING THAT SHORTLY AFTER LEVEL OF AT FL 320, AN ENGINE 1 COMPRESSOR VANE FAULT ECAM MESSAGE DISPLAYED, SKYWISE SHOWED EEC CHANNEL B FAULT. THE FLT CREW FOLLOWED SDR AALA202512036732Filter · dirtyAIRCRAFT WAS NOT GROUNDED: LAVATORY SMOKE ECAM FOR LAVATORY "A" OCCURRED TWICE WHILE PASSENGERS WERE EXITING LAVATORY. CLEARED AFTER A FEW SECONDS NO SMOKE NOTED. MAINTENANCE NOTED NO FAILURE ON POST FLIGHT REPORT BUT DID FIND LAVATORY "A" SMOKE DETECTOR FILTESDR AALA202512038820Life Vest · missingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS AIRCRAFT IS MISSING NINE INFANT LIFE VESTS. INFANT LIFE VESTS PROVIDED PER EMERGENCY EQUIPMENT DRAWING DFD1061.SDR AALA202512034744Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: 1ST FLIGHT ATTENDANTS CIDS PANEL DISPLAYS MESSAGE TO CHECK DOOR PRESSURE FOR 1L. MAINTENANCE SERVICED L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202512030677Striker · stickingAIRCRAFT WAS NOT GROUNDED: UPPER STRIKE WILL NOT RELEASE WHEN D HANDLE IS ROTATED CLOCKWISE. MAINTENANCE LUBED DOOR STRIKES AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR DALA2025120308813Proximity Sensor · dirtyATB - DUE TO DOOR FWD CARGO ECAM WARNING. VERIFIED FORWARD CARGO DOOR CLOSED AND HANDLE STOWED, DEFERRED INDICATION PER MEL 52-70-01H. CLEANED PROX SENSOR 30MV, DOOR INDICATION ON ECAM SHOWED CLOSED AND OPEN WHEN APPROPRIATE. (LP 8082760)SDR CALA2025120311741Lamp · inoperativeR1 EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS FOR EMERGENCY LIGHT IAW AMM 33-51-04 -960-801. OPS CHECKED GOOD.SDR CALA2025120311739Frame · gougedAFTER REMOVAL OF THE AFT CARGO FLOOR SUPPORT SHIELD FOUND A GOUGE ON FRAME BS 856, S25R. PERFORMED A REPAIR TO THE FRAME WEB IAW ECRA 5360-02064 ,SDR CALA2025120311735Light · inoperative43G AND 49D SEATS - EMERGENCY PATH LIGHTS INOPERATIVE. ASSURED INOPERATIVE AREAS ILLUMINATION LIGHTS ARE NOT ADJACENT, CROSS-AISLE EXIT SIGNS OPERATE NORMALLY AND FLIGHT DECK EMERGENCY DOME LIGHT OPERATES NORMALLY. REQUIESTING MEL 3351A APPROVAL. APPROVED FORSDR CALA2025120311723Warmer · odorAFT GALLEY COFFEEMAKER 516 GIVES OFF ODOR SIMILAR TO BURNING RUBBER. SWITCHED OFF COFFEEMAKER. CONFIRMED WITH CREW HOTPLATE 516 IN AFT GALLEY WAS CAUSE OF THE ODOR. PER FA'S THERE WAS NO SMOKE, ODOR STOPPED WHEN HOTPLATE 516 WAS SWITCHED OFF. MAINT CHECKESDR CALA2025120311721Intercostal · corrodedMAIN E&E COMPARTMENT INTERCOSTAL IS CORRODED BE TWEEN BS 312 & 323 AT APPORX LBL4. CLEANED CORROSION BEGINNING MAT'L .040" REMOVED .006" REMAINING MAT'L .034" OUT OF LIMITS IAW B737-800 SRM 53-10-04-01-1. REMOVE REMOVED AND REPLACED INTECOSTAL ASSY IAW DWG 1SDR SWAA2025120240990Seat Back · out of adjustSEATS AT ROW 12 A;B;C WILL NOT STAY UPRIGHT. ADJUSTED HYDRO LOCS IAW AMM 25-22-00SDR SWAA2025120240988Battery · inoperativeCOCKPIT FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED THE BATTERY FOR FLIGHT DECK FLASHLIGHT IAW AMM 25-64-00.SDR SWAA2025120240997Pressure Switch · faultedON TAKEOFF ROLL BOTH FWD AND AFT PUMP LOW PRESSURE LIGHTS IN NR 2 TANK WERE ALTERNATING ON AND OFF. REMOVED AND REPLACED THE FUEL SYSTEM MODULE. OPS CHECKED GOOD. IAW AMM 28-22-43.SDR SWAA2025120240986Cover · missingEMERGENCY EXIT LIGHT COVER MISSING OVER WING. INSTALLED THE COVER IAW SIP.SDR SWAA2025120240641Lamp · inoperativeAFT ENTRY DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-04. OPS CHKD NORMAL.SDR SWAA2025120240639Pump · failedAFTER EXITING RUNWAY (AFTER LANDING), NR 1 ENGINE FAILED. FAIL ON ENGINE INSTRUMENTS. NR 1 GEN OFF LINE AT SAME TIME. NR 1 ENGINE SPOOLS UP MUCH SLOWER ON TAKEOFF COMPARED TO NR 2 ENGINE. NR 1 ENG FUEL PUMP & HMU R+R PER MT 773-11-00. PS3 CONNECTOR FOUND DISDR SWAA2025120241853Hmu · failedAFTER EXITING RUNWAY (AFTER LANDING) NR 1 ENGINE FAILED. FAIL ON ENGINE INSTRUMENTS. NR 1 GEN OFF LINE AT SAME TIME. NR 1 ENGINE SPOOLS UP MUCH SLOWER ON TAKEOFF COMPARED TO NR 2 ENGINE. NR 1 ENG FUEL PUMP & HMU R & R IAW MT 773-11-00. PS3 CONNECTOR FOUND DSDR SWAA2025120241854Elec Connector · disconnectedAFTER EXITING RUNWAY, AFTER LANDING. NR 1 ENGINE FAILED. FAIL ON ENGINE INSTRUMENTS.NR 1 GEN OFF LINE AT SAME TIME. NR 1 ENGINE SPOOLS UP MUCH SLOWER ON TAKEOFF COMPARED TO NR 2 ENGINE. NR 1 ENG FUEL PUMP AND HMU R & R PER MT 773-11-00. PS3 CONNECTOR FOUND DSDR DALA2025120208810Door Seal · out of positionDIVERTED TO HND DUE TO 4L DOOR SQUEAL. FOUND AERODYNAMIC AND PRESSURE SEALS STICKING OUT. REPOSITIONED PRESSURE SEAL. OK FOR SERVICE. (LP# 7995340)SDR AALA202512027127Circuit Card · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: STATUS MESSAGE WING ANTI-ICE ZONE; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT PHL. TROUBLESHOT PER FIM 30-10-F1-13A-421A. REMOVE AND REPLACED WIPS ZONE CONTROL CARD 9. PER AMM 30-11-03. TEST PASSED ANSDR DXTA2025120205895Uplock Switch · faultedDURING GEAR DOWN. RECEIVED NOSE GEAR DISAGREE LIGHT. RAN QRH (LANDING GEAR WILL NOT EXTEND) CHKLIST,. NOSE GEAR STILL HAD YELLOW DISAGREE LIGHT. AFTER APPROXIMATELY 5 MINS. GREEN LIGHT APPEARED AFTER MAKING A FEW TURNS. R & R NLG UPLOCK SWITCH IAW AMM 32-32-1SDR DALA2025120208809Sensor · fodPILOT REPORT RT AFT DOOR MSG INTERMITTENT ON TAKE OFF ROLL. REMOVED DEBRIS FROM RT AFT DOOR SENSORS. OPS NORMAL IAW AMM 52 -71. (7724858)SDR DALA2025120208808Indicator · fodL4 & R4 DOORS NOT SHOWING DOOR KNOCKERS WHEN ARMING DOORS. REMOVED TRIM DEBRIS OBSTRUCTING DOOR KNOCKERS. BOTH L4 & R4 DOORS OPERATE AND ARM CORRECTLY IAW AMM 52-11. (8143696)SDR DALA2025120208805Indicator · damagedL1 DOOR KNUCKLE KNOCKER STICKING AND THERE IS A LOUD SQUEALING NOISE FROM THE DOOR WHEN AIRBORNE. ADJUSTED L1 DOOR KNUCKLE KNOCKER. OPS GOOD. LUBED DOOR SEAL. PRESSURIZED CABIN TO 6PSI PER B7657 AMM 05-51. OPS GOOD. (7535016)SDR DALA2025120208804Lanyard · missingLANYARD HANGING OUT BENEATH L2 DOOR. L2 DOOR LANYARD RESECURED. (7973670)SDR DALA2025120208803Snubber · out of toleranceOUT OF LIMITS ROTARY SNUBBER PIN EXTENSION OF R1 DOOR AT CABIN PAX. R1 ROTARY SNNUBER WAS REMOVED AND REPLACED IAW AMM 52-11. (1327530)SDR DALA2025120208788Battery Pack · inoperativeFWD GALLEY EMERGENCY LIGHT BY R1 DOOR INOPERATIVE. REMOVED AND REPLACED M2816 BATTERY PACK IAW AMM 33-51, OPS CHECKED GOOD.SDR SCNA20251202456Lamp · inoperativeDURING L/O CHK FOUND RIGHT AFT OVERWING DOOR EMERGENGY LIGHT INOP. RELAMPED RT AFT OVERWING EMERGENCY LIGHT IAW AMM 33-51-04-960-801. NO HELP. RELAMPED RT AFT OVERWING EMERGENCY LIGHT IAW AMM 33-51-04-960-801. OPS CHECK GOOD.SDR CALA2025120211693Transmitter · faultedHYD NR 1 LOW PRESSURE ILLUMINATED ON DEPARTURE PERFORMED INITIAL EVALUATION IAW FIM 29-30 TASK 812. COULD NOT FIND ANY EXTERNAL HYD LEAKS, SYS RESERVOIR INDICATION WAS LOW & HAS FLUID WITHIN THE TRANSMITTER. SERVICED A SYS WITH 1 GALLON OF HYD WITH NO MOVENT SDR CALA2025120211680Channel · corrodedAFT CARGO, FOUND MULTIPLE POINTS OF CORROSION ON LT ZEE CHANNEL, BETWEEN BS 727B - 847, REMOVED, FABRICATED, LOCATED, DRILLED & PERFORMED COUTERSINK ON AFT CARGO BAY LT ZEE CHANNEL BTW 727B TO 847 APPLIED ALODINE, PRIMER AND INSTALLED NEW ZEE CHANNEL IAW SRMSDR CALA2025120211678Light · missingVERIFIED MISSING LENS OF THE FLOOR PROXIMITY LIGHT AT SEAT POSITIONS 6D AND 7D. INSTALLED NEW LIGHTS AT POSSITIONS 6D AND 7D. OPERATING PROPERLY AND GOOD FOR FLIGHT. IAW:AMM 33-51-06.SDR CALA2025120211676Spar · corrodedFOUND CORROSION AT LEFT WING INB REAR SPAR FUEL BOOST PUMP TANK 1 AFT FITTING SKIN CUTOUT LOWER EXFOLIATED CORROSION. PERFORMED A REPAIR ON AREAS IAW ESR-WI 27-13194 REV IR AND ECRA 5720-03582.SDR CALA2025120211674Skin · crackedLEFT WING SLAT NR 1 L/E HAS LOOSE FASTENERS WHERE ACTUATOR ATTACHES. PERFORMED A REPAIR IAW SRM 57-42-01-2R-8 FIG 202 SHEET 1 ALTERNATIVE 1.SDR CALA2025120211672Spar · corrodedCORROSION RT WING INBD REAR SPAR FUEL BOOST PUMP TANK 2 AFT BONDING STRAPS ATTACHED TO SKIN CUTOUT. PERFORMED REPAIR ON AREAS IAW WI 28-13197 REV IR, AND ECRA 5720-03583.SDR CALA2025120211670Battery Pack · no testEPSU BATTERY EMER L, FAULT MESSAGE FROM CIDS WHILE CONDUCTING EMER LIGHT SYSTEM TEST. REMOVED AND REPLACED EPSU BATTERY 11WL, IAW AMM 33-51-38-000-002-A, 33-51-38-400-002-A. OPS CHECKED GOOD, NO FAULT MESSAGES OR DEFECTS NOTED.SDR CALA2025120211668Power Supply · no testREMOVED EPSU (11WL) BATTERY, FOR USE ON A/C 4040, AND LOWER SIDEWALL PANEL AT LT WING EMERGENCY EXIT. REF 33-51-38-000-002-A. INSALLED NEW EPSU (11WL) AT LT WING EMERGENCY EXIT IAW AMM 33-51-38. OPS CHECKED GOOD.SDR CALA2025120211666Lamp · inoperativeEMERGENCY LIGHTS - OPERATIONAL CHECK EMERGENCY LIGHTS. L2 ESCAPE SLIDE EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-04. OPS CHECKED GOOD.SDR CALA2025120211633Seat Track · lack of lubeFO SEAT DONT SLIDE PROPERLY CLEANED LUBED FO, SEAT TRACK ASSY OPS CHK NORMAL.SDR CALA2025120211632Cover · damagedESCAPE SLIDE COVER DAMAGED AT DOOR R2. R & R NEW SLIDE COVER AT R2 DOOR REF CMM 25-66-01-400-803.SDR WX0A2025120132651Power Supply · no test(AIRCRAFT NOT GROUNDED) DURING EPSU BITE TEST, EMERGENCY BATTERY 10WL FAILED. EMERGENCY BATTERY 10WL REPLACED AND TESTED SERVICEABLE PER AMM 33-51-38-400-002-A.SDR QXEA2025120100359Lever · faultedAFT LEFT HAND DOOR ARMING LEVER DIFFICULT TO ARM. REMOVED FROM SERVICE. FERRIED FOR REPAIRS. INSPECTED AND FOUND AFT PASSENGER DOOR FORWARD GIRT BAR ATTATCH FITTING BINDING ON FLOOR FITTING WHEN ARM HANDLE APPROX 70% DOWN. REMOVED AFT PAX DOOR LINING & SURROUNSDR SWAA2025120140999Light · brokenCENTER AISLE EXIT LIGHT BROKEN. REINSTALLED MID CABIN OVERHEAD EMERGENCY EXIT LIGHT ASSY IAW AMM 33-51-01. ACFT OK FOR SERVICE.SDR SWAA2025120140677Girt Bar · missingFWD SERVICE DOOR GIRT BAR PLASTIC GRIP MISSING. REMOVED AND REPLACED FWD SERVICE DOOR GIRT BAR IAW AMM 25-66-01.SDR SWAA2025120140801Acm · seizedLEFT ACM LIGHT ILLUMANTED FOLLOWED BY AN ODOR IN THE FLIGHT DECK. OK TO CONTINUE IAW MEL 21-1-01, SP1, AUTH 295231, FOUND LT ACM DAMAGED & SEIZED. R & R LT ACM IAW AMM 21-51-04. OPS CHECKED GOOD.SDR SWAA2025120140659Light · inoperativeLEFT AFT MOST EMERGENCY LIGHT, AFT OF L2 DOOR, INOPERATIVE. RELAMPED IAW AMM 33-51-04. OPS CHECKED GOOD.SDR YENA2025120101133Computer · malfunctionedFLT#1970, BOS-PHX. WHILE DESCENDING AND SLOWING TO 210 KTS AT 9000 FEET, SELECTED FLAPS 1 AND RECEIVED ELAC 1 FAULT. PLANE ROLLED APPROX 15 DEGREES RIGHT. DISCONNECTED A/P AND HAND FLEW PLANE TO NORMAL LANDING; REF LG # 4520823 ITEM #2, # 4520824 ITEM #1 FOSDR YEN2025F00010Pump · failedFLT#1970, BOS-PHX. "WHILE DESCENDING AND SLOWING TO 210 KTS AT 9000 FEET, SELECTED FLAPS 1 AND RECEIVED ELAC 1 FAULT. PLANE ROLLED APPROX 15 DEGREES RIGHT. I DISCONNECTED A/P AND HAND FLEW PLANE TO NORMAL LANDING; REF LG # 4520823 ITEM #2, # 4520824 ITEM #1 FOSDR AALA202512012116Light · no testAIRCRAFT WAS GROUNDED: DURING EMERGENCY LIGHT TEST FOUND SEAT 3AB EMERGENCY LIGHTS INOPERATIVE. INSTALLED REAR (AALA202512015369) AND FORWARD (AALA202512012116) EMERGENCY LIGHT ASSEMBLY. PER AMM 33-51-11.SDR AALA202512015549Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: EXIT OVERHEAD SIGN CAME OFF THE AFT SIDE. REINTALLED OVER HEAD CABIN EXIT SIGN AFT SIDE.