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 DALA2026010300039Oil System · leakingREPORTED ODOR ON DESCENT. CREW DONNED OXYGEN MASKS. CORRECTIVE ACTION: FOUND RIGHT ENGINE SPINNER WET WITH OIL. WIPED CLEAN AND PLACED ON REPETITIVE INSPECTION MON. PERFORMED LEVEL B DECONTAMINATION. NO HISTORY. DEFERRED TO MONITOR. LATER, C/W TERMINATING ACTISDR DALA2025123109557Wire · brokenSEAT MOUNTED WHITE EPATH LIGHT INOP AT 53 RIGHT. T/S PER B767 WDM 33-51-31, FOUND BROKEN WIRE AT 53G. REPAIRED AND SPLICED WIRE AS PER B767 SWPM 20-30, OPS CHECK OK. MEL AND PLACARD REMOVED. (8054695)SDR DALA2025123109554Skin · corrodedFUSELAGE SKIN BTW STA1395 AND STA1417, S35R TO S36R WHERE AFT DRAIN MAST INSTALLED FOUND CORROSION. THE DAMAGED SKIN REPAIRED AS PER PRI 631040-14 REV 0.COMAPRED AND COMPLIED WITH ER/A 631040-14 REV ORIGINAL. (1368590)SDR DALA2025123109553Web · crackedFOUND NR 1 PYLON UPPER WEB CRACKED AT OTBD SIDE OF PYLON TO WING INBD MID SPAR FITTING. REPAIRED AS PER PRI 630868-14 (1368270)SDR AALA202512313803Flap System · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED ON APPROACH INTO DEN DUE THE FLIGHT CREW REPORTING A FLIGHT CONTROL FLAPS LOCKED / ALIGNMENT FAULT WHEN MOVING FLAPS FROM 1 TO 2. THE FLIGHT CREW ACCOMPLISHED ECAM / QRH PROCEDURES AND LANDED SAFELY AT DEN WITHOSDR R61A2025122500548Windshield · crackedCAPTAIN WINDOW CRACKING IN FLIGHT. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. FOUND TO BE MOISTURE INGRESS GIVING CRACKING APPEARANCE.SDR DALA2025123009520Light · no testDURING CHECK 55 EMERGENCY LIGHTS CHECK, FOUND 4L & 4R EXTERIOR DOOR LIGHTS INOP. T/S PER B757 FIM33-51-00-815-803. PERFORMED WIRE CHECKS AT L56, HAS 6VDC & .4 OHM GROUND REF B757 WDM 33-51-15. REMOVED AND REPLACED 4L (L56) LIGHT FERRULE ASSY REF CMM 33-51-42SDR ASAA2025122563433Lamp · inoperativeRIGHT OVER THE WING EXIT EMERGENCY LIGHT (EXTERIOR) INOPERATIVE. FOUND DURING T/C 78233008. GROUNDED - YES. RELAMPED RT OVERWING EXIT LIGHT IAW AMM 33-51-04.SDR SWAA2025122955602Power Supply · smokeEMERGENCY LIGHT POWER SUPPLY IN FWD GALLEY (M01674) SMOKING. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY ASSY AND BATTERY PACK IAW AMM 33-51-06. REMOVED & REPLACED FWD GALLEY LIGHT ASSY IAW AMM 33-26-02. OPS CHECKED GOOD.SDR SWAA2025122956408Battery Pack · smokeEMERGENCY LIGHT POWER SUPPLY IN FWD GALLEY (M01674) SMOKING. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY ASSY AND BATTERY PACK IAW AMM 33-51-06. AND REMOVED AND REPLACED FWD GALLEY LIGHT ASSY IAW AMM 33-26-02. OPS CHECK GOOD.SDR SWAA2025122956409Light · smokeEMERGENCY LIGHT POWER SUPPLY IN FWD GALLEY (M01674) SMOKING. R & R EMERGENCY LIGHT POWER SUPPLY ASSY AND BATTERY PACK IAW AMM 33-51-06. AND R & R FWD GALLEY LIGHT ASSY IAW AMM 33-26-02. OPS CHECKED GOOD.SDR SWAA2025122955624Flashlight · inoperativeAFT FA RIGHT SIDE FLASHLIGHT INOP. R/R FLASHLIGHT PER AMM 25-64-00-SWA 807 OPS CHECK GOODSDR SWAA2025122955611Flashlight · inoperativeCAPT SIDE AFT INBOARD EMERGENCY FLASHLIGHT BLINKING RED. REMOVED AND REPLACE CAPT SIDE AFT INBOARD EMERGENCY FLASH LIGHT ASSY IAW AMM 25-64-00.SDR SWAA2025122955600Light · looseEMERGENCY LIGHT STRIP ON FLOOR UNGLUED AT ROW 12DEF. SECURED FLOOR PROXIMITY LIGHT STRIP AT 12DEF IAW AMM 33-51-15 A/C OK FOR SERVICESDR SWAA2025122955617Lens · brokenCREW REPORTS EMERGENCY LIGHT LENS COVER IN THE CEILING AT ROW 6DEF BROKEN. OKAY TO CONTINUE PER MEL 25-10-01 SP1B;[02] INSTALLED LENS COVER ON EAL AT ROW 6DEF REF AMM 33-51-03SDR SWAA2025122955517Lamp · inoperativeFWD EXIT SIGN FLIGHT ATTENDANT BLUE CALL LIGHT INOPERATIVE. PA OPERATES NORMAL. REPLACED THE LAMPS IN THE FWD EXT SIGN BLUE LIGHT IAW AMM 33-51-01.SDR SWAA2025122955665Sign · detachedEXIT/SALIDA SIGN FELL FROM FORWARD CABIN ON TAKEOFF. R & R FWD EXIT SIGN LIGHT ASSY IAW AMM 33-51-01.SDR DALA2025122909482Door · out of adjustLEFT AFT ENTRY DOOR EICAS AT FL380 ASSOCIATED WITH FA REPORT OF DOOR HANDLE SIMULTANEOUSLY MOVING ON ITS OWN FROM 3 O`CLOCK TO 2 O`CLOCK POSITION, CABIN PRESS REMAINED NORMAL. REMOVED DOOR LINING PER AMM 52-11 FAST CHECK C/W PER AMM 52-11. ALL CHECK NORMAL. PESDR DALA2025122909481Oil System · low pressureATB/IFSD/DE - AIRCRAFT RETURNED TO DTW DUE TO RIGHT ENGINE IFSD DUE TO ZERO OIL PRESSURE AND OIL QUANTITY. RIGHT ENGINE OPERATED ABOVE IDLE POWER WITH ZERO OIL PRESSURE AND OIL QUANTITY, REMOVED AND REPLACED ENGINE.SDR DALA2025122909473Elec Connector · unsecureSEAT 24 D/E/F EMERGENCY LIGHT INOPERATIVE. TROUBLESHOT IAW FIM 33-50 TASK 801, FOUND LOOSE CONNECTION, RESECURED, OPS TESTED GOOD.SDR DALA2025122909472Battery Pack · inoperativeFOUND AFT LEFT EMERGENCY EXIT LIGHT INOPERATIVE. R & R BATTERY M1673 IAW AMM 33-51. OPS CHECKED NORMAL.SDR DXTA2025122906292A/C Pack · failedUPON LANDING THERE WAS A HAZE IN THE CABIN AND COCKPIT. TAXIING TO THE RAMP WE GOT A L PACK FAIL CAS. BLACK FILM COATING EVERYTHING IN THE CABIN. REMOVED LEFT ACM AND INSTALLED REPAIRED LISTED BELOW I/A/W AMM 21-52-03. LEAK AND OPERATIONAL CHECKS SATISFACTOSDR DXTA2025122906294G Switch · trippedEMERGENCY EXIT LIGHT OVER THE MAIN CABIN DOOR STAYS ON AFTER ALL POWER FROM AIRCRAFT IS REMOVED AND EMER LIGHT SWITCH IS OFF. ALSO EXIT SIGNS ON EITHER SIDE OF DOOR AND THE LIGHT BELOW SEAT 10 REMAIN ILLUMINATED AS WELL. BEFORE CONNECTING AIRCRAFT BATTERIES, NSDR DXTA2025122906295Battery · faultedEMERGENCY LIGHTS CAME ON AND THEN STARTED BLINKING ON AND OFF MID FLIGHT. REMOVED AND REPLACED FWD AND AFT EMER BATTERIES IAW 33-52-01; OPS CHECK GOOD.SDR DXTA2025122906297Light · malfunctionedOBSERVED ALL EMER LIGHTS INTERMITTENTLY FLICKERING. OBSERVED ALL EMER LIGHTS REMAINING ON FOR 20+ MINUTES WHEN SWITCH IN ARM POSITION. POWERED THE PLANE AND CHARGED THE EMERGENCY LIGHTS AND OPS CHECKED THE EMERGENCY LIGHTS IAW EMB-505 AMM 33-52-01. OPS CHECK GSDR AALA202512297475Warning Message · illuminatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO IAD DUE TO THE FLIGHT CREW REPORTING ECAM MESSAGES FOR BRAKES-AUTO BRAKE FAULT AND BRAKE RELEASED. THE AIRCRAFT LANDED SAFELY AT IAD WITHOUT FURTHER INCIDENT. (OPEN)SDR AALA202512295919Light · missingAIRCRAFT WAS NOT GROUNDED: LEFT ROW 22 MISSING EMERGENCY LIGHT ASSEMBLY. INSTALLED EMERGENCY LIGHT ASSEMBLY AT SEAT ROW 22 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-19.SDR CALA2025122912504Sensor · out of adjustMAIN CABIN DOOR LIGHT ILLUMINATED ON TAXI REF FIM 52-10 TASK 801. UPON ARRIVAL PSEU SENSOR I/O MONITOR CHECK SHOWED S199 SENSOR AS TGT FAR WITH DOOR CLOSED. PERFORMED SENSOR ADJUSTMENT REF AMM TASK 52-71-11-820-801. SENSOR IS NOW WITHIN LIMITS. OPS CHECK GOOD.SDR CALA2025122912503Slide · out of adjustESCAPE SLIDE PACK BUSTLE DAMAGED. L2 SLIDE FABRIC EXPOSED. INSPECTED AND ADJUSTED MATERIAL IAW AMM 25-66-01-400-803. NO DEFECTS NOTED.SDR CALA2025122912499Receiver · faultedINVALID FMC MSG ON DEPARTURE. SELF CORRECTED AFTER 5 MIN REPLACED MMR1 REF AMM 34-31-42. FULLY CAT CAPABLE, LAND VERIFY PASSED. INSPECTED GPS ANTENNA AND OP TEST. ALL CHECK GOOD.SDR CALA2025122912498Lgciu · faultedMLG LGCIU 1 FAULTED, NR 1 ENG REVERSER, GEAR DOORS WOULDNT CLOSE I NITIALLY. R & R LGCIU 1 FIN (5GA1) IAW AMM 32-31-71-000-001-A, & 32-31-71-400-001-A. . PERFORMED BITE TEST OF LGCIU IAW AMM 32-69-00-740-001-A. LGCIU. 1/2 BITE TEST GOOD. R & R RT MLG PROXSDR G41A2025122800836Trim System · faultedDEPARTED KIAD HEADING TO KJAX, IN FLIGHT, TRIMMING THE HORIZONTAL STABILIZER, BOTH PRIMARY AND SECONDARY TRIM WERE INTERMITTENT, EVENTUALLY BECAME INOPERATIVE. THE CREW DIVERTED AND LANDED SAFELY INTO KVQQ MAINTENANCE WAS CALLED TO INVESTIGATE THE ISSUE. NO CASDR ABXA20251225360Transmitter · expiredDURING MAINTENANCE CHECK PORTABLE ELT FAIL OPERATIONAL TEST CODE FAULTED 3+2 FLASHES INDICATING LOW RF POWER .MTX REPLACED KANNARD ELT. PERFORMED OPS CHECK PER TASK CARD ABX-ALR-25-013 OPS CHECK GOOD RETURNED A/C TO SERVICESDR AALA202512284809Connector · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT ROW 27 ABC INOPERATIVE. MAINTENANCE FOUND EMERGENCY LIGHT CONNECTOR 7260VC LOOSE, AT ROW 27, CONNECTED EMERGENCY LIGHT CONNECTOR IAW WDM 33-51-08. OPS CHECK GOOD IAW AMM 33-51-00.SDR AALA202512287939Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R1 DOOR ASSIT BOTTLE NEEDS SERVICING. MAINTENANCE SERVICED R1 DOOR ASSIST BOTTLE IAW AMM 52-10-00.SDR ASAA2025122563341Guide Arm · lack of lubeFOLLOW UP TO REPORTS OF L-2 DOOR HARD TO OPEN. ACCOMPLISH FIM 52-10 TASK 807 TO SEE WHAT IS CAUSING L-2 DOOR HARD TO OPEN. GROUNDED - YES. WHILE PERFORMING FIM 52-10 TASK 807, FOUND CONDENSATION ON L2 DOOR FRAME, ROLLER BEARINGS, GUIDE ARM GUIDE PLATE & EXTERISDR AALA202512268845Spring · damagedAIRCRAFT WAS GROUNDED: DURING TAKEOFF ROLL #1 FLIGHT ATTENDANT HEARD A POP ON THE DOOR AREA. UPON LANDING GATE AGENT REPORT THE OUTSIDE DOOR HANDLE COMPLETE OPEN ON THE MAIN ENTRY DOOR BUT INDICATION INSIDE THE FLIGHT DECK WAS NORMAL. MAINTENANCE FOUND SPRING SDR AALA202512268045Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: RIGHT EMERGENCY DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202512263471Bottle · 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 AALA202512266087Handle · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS 3L DOOR DISARM HANDLE LOOSE. MAINTENANCE SECURED ARM/DISARM HANDLE PER AMM 25-23-46.SDR AALA202512266146Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: SLIDE DISARMED CHECK PRESSURE APPEARED INFLIGHT ON FLIGHT ATTENDANTS CONTROL PANEL. MAINTENANCE SERVICED L2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202512268624Handle · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS 2R DOOR DISARM HANDLE LOOSE. MAINTENANCE SECURED ARM/DISARM HANDLE PER AMM 25-23-46.SDR AALA202512260320Light · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT CEILING LIGHT INOPERATIVE AT SEAT ROW 36. REPLACED CEILING LIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-11.SDR AALA202512264162Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: FORWARD RIGHT PASSENGER / CREW DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202512267494Handle · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS 3R DOOR DISARM HANDLE LOOSE. MAINTENANCE SECURED ARM/DISARM HANDLE PER AMM 25-23-46.SDR F3LA202512260341Slide Raft · low pressureAIRCRAFT WAS GROUNDED AS A RESULT OF THIS SDR REPORTABLE EVENT. R2 DOOR SLIDE LOW PRESSURE AIRCRAFT REMOVED FROM SERVICE. PLACED ON MEL 25-61-02A, REMOVED AND REPLACED PAX DOOR R2 SLIDE REF IAW AMM 25-62-44-000/400-303-A OPS CHECK GOOD. THIS CLOSES MEL. PLACASDR DALA2025122609424Proximity Sensor · dirtyCLIMBING THRU FL350 RECIVED ECAM MSG '' DOOR L MID CABIN. CLEANED DOOR PROX SENSORS AND OK FOR SERVICE. WORK DONE PER A330 AMM 52-71. (8207390)SDR DALA2025122609423Seat Track · corrodedSEAT TRACK AT YA BETWEEN FRAME 73 AND 74 IS CORRODED. REPLACED SEAT TRACK PER A330 SRM 51-72-11. (1368721)SDR ABXA202512265354A/C Pack · illuminatedDURING TAXI, C/L IRS DC FAIL EICAS MESSAGE ILLUMINATED. AIRCRAFT RETURNED TO BLOCKS (BTB). CYCLED STANDBY POWER, PER AMM 24-33-00 AND PERF OPS CHECK OF L AND C IRS PER IAW FAULT TREE 34-21. PS CHECK GOOD, A/C REMAINS CAT IIIB. ONE TIME AUTH # 2025-047. AIRSDR ABXA20251225352Fire Loop · fault messageRIGHT ENGINE FIRE LOOP 2 STATUS MESSAGE ILLUMINATED. DEFERRED RT ENG FIRE LOOP 2 PER MEL 26-11-14. MAINTENANCE ACTION C/W PLACARDS INSTALLED. AIRCRAFT RETURNED TO SERVICE.