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 DALA2025102407800Skin · dentedRIGHT PYLON FWD UPPER SKIN PANEL SURFACE FOUND DENT. REPAIRED PER ER/A 629695-14. (1266721)SDR SWI2025F01456Floorbeam · corrodedFS280.00 RH FLOOR BEAM CORRODED (REF SRM 53-11-10 ITEM 119). OPEN)SDR SWIA2025102400023Floorbeam · corrodedFS280.00 LEFT FLOORBEAM CORRODED (REF SRM 53-11-10 ITEM 118). OPENSDR DALA2025102407794Rib · damagedHOUR GLASS PANEL LOWER WING RIB, UPPER ROW, FWD FASTENER HOLE DAMAGED. REPAIRED PER PRI 630032-14 REV. 0, 1 AND 2 AND ER/A 630032-14 REV ORIGINAL. (1267567)SDR FDEA202510232076Skin · corrodedAFT POTABLE WATER SERVICE DOOR PAN POSSIBLE CORROSION STA 1681 TO STA1701 BTW STRINGERS 26R TO STR 29R COMPLIED WITH FEDEX EA F-5330-T0385436 P1 TITLE: FUSELAGE-PLATES AND SKINS-AFT LAV PAN CUT OUT SKIN CORROSION REPAIR. MAJOR REPAIR.SDR DALA2025102407781Oil System · leakingDURING DESCENT AROUND 11,000 FT AFTER SELECTING ENGINE A/ICE SWITCH ON A VERY LIGHT DIRTY SOCK SMELL CAME THROUGH THE COCKPIT AND CABIN. IT LASTED FOR APPOX 1 MINUTE THEN CLEARED. ACCOMPLISHED W/C 0550-2002 FOUND WETTING BEHIND NR 1 ENGINE SPINNER. REPLACED NSDR DALA2025102407780Oil System · leakingDIRTY SOCK ODOR AT 8000 FT ON ARRIVAL. LASTED TO GATE. APU OFF DURING FUME EVENT. FOUND OIL LEAK IN #1 ENG SPINNER, #2 ENG IS GOOD. REPLACED #1 ENG SHAFT COVER SEAL PER A321 AMM 72-15. (LP 7203500)SDR QXEA2025102400329Latch · dirtyFLIGHT 2355. FLIGHT DECK DOOR DIFFICULT TO OPEN. REMOVED FROM SERVICE. CLEANED COCKPIT DOOR ELECTROMECHANICAL-LATCH. PERFORMED FLIGHT DECK DOOR OPERATIONAL CHECK. REF E175 MAINT MANUAL 52-51-03-820-801-A. OPS CHECK NORMAL. COULD NOT DUPLICATE. RETURNED TO SERVSDR AALA202510243441Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT MESSAGE FOR EMERGENCY POWER SUPPLY UNIT 14WL DISPLAYED DURING SYTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202510246741Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT MESSAGE FOR EMERGENCY POWER SUPPLY UNIT 13WL DISPLAYED DURING SYTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202510247481Bottle · 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 AALA202510245080Elec Connector · dirtyAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED THE DOOR 4R ARMING INDICATION INTERMITTENT AFTER TAKEOFF. ARMED ON GROUND AND SHOWED DISARMED IN THE AIR. FLIGHT ATTENDANT GENTLY PUSHED HANDLE AND INDICATION SHOWED REARMED. MAINTENANCE CLEANED R4 DOOR ARM PROXIMITYSDR AALA202510242585Battery · no testAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS REAR MEGAPHONE IS INOPERATIVE. MAINTENANCE REPLACED BATTERIES AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA202510244783Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT MESSAGE FOR EMERGENCY POWER SUPPLY UNIT 10WL DISPLAYED DURING SYTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202510241622Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202510240066Light · misinstalledAIRCRAFT WAS NOT GROUNDED: SEAT ROW 8ABC EMERGENCY FLOOR LIGHT STRIP INOPERATIVE. MAINTENANCE REINSTALLED LIGHT ASSEMBLY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-13.SDR AALA202510245272Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR DALA2025102407778Bracket · brokenOXYGEN BOTTLE BRACKET BROKEN. CORRECTIVE ACTION: FOUND LATCHES LOOSE. TIGHTENED AND RESECURED LATCHES AND BOTTLES AS REQUIRED PER A319 AMM 35-21. (1268132)SDR DALA2025102407777Fitting · corrodedCORROSION SPIGOT FITTING RECEPTACLE ON RH PYLON. REPLACED SPIGOT FITTING RECEPTACLE ON RH PYLON AS PER A319 SRM 54-51-12-300-001. (1268121).SDR DALA2025102407776Seat Track · corrodedCORROSION SEAT TRACK -Y765 LOCATED FROM FR12 TO FR24 AT FWD GALLEY AREA. CORRECTIVE ACTION: REPLACED SEAT TRACK -Y765 LOCATED FROM FR12 TO FR24 AT FWD GALLEY AREA AS PER A319 SRM 51-42-11 A319 SRM 51-72-11. (1267628).SDR CALA2025102410497Lens · detachedFWD RIGHT DOOR EMRGNCY EXIT SIGN DETACHED FROM HOUSING RESECURED LENS COVER. OPS CHECK OF DOOR 1R EMERGENCY LIGHTS GOOD REF AMM 33-51-01-960-802.SDR CALA2025102410496Fuel Cap · missingMISSING FUEL CAP IN REF LOG PAGE 6722035. INSTALLED FUEL CAP REF 28-25-41.SDR CALA2025102410492Warning Message · false activationDOOR FLIGHT LOCK 2L EICAS STATUS #2 LEFT PASSENGER ENTRY DOOR FLIGHT LOCK COMMAND/FLT LK RLY/SENS OR DISAGREEMENT. FIM TASK REF : FIM TASK REFERENCE NOT FOUND CMC MSG# 5211300. PSEU 2 (R2) CMC MSG# 5212090 FLIGHT STATUS: A INTERMITTENCE. PSEU 2 (R2) MSGSDR CALA2025102410491Battery · dischargedEMERGENCY POWER ASSIST SYSTEM (EPAS) 9 VOLT BACK-UP BATTERY INSTALLATION BACKUP 9-VOLT BATTERY INSTALLATION - REMOVED DOOR 1L BUSTLE FOR EPAS BATTERY REPLACMENT REINSTALLED DOOR 1L BUSTLE REF AMM25-66-06 ACP'D INSPECTION ITEM, CLEARED AREA FOR DR 1L SLIDE BUSTSDR CALA2025102410481Oxygen Bottle · usedEMERGENCY O2 4L USED. REMOVED AND REPLACED EMERGENCY O2 BOTTLE AT 4L DOOR WITH FULL SERVICEABLE UNIT. REF AMM 35-31-03. PARTS USED: 78-3531-3-0007, QTY :1SDR CALA2025102410480Light · inoperativeSEAT MOUNTED EMERGENCY LIGHT AT 35C INOPERATIVE. REMOVED AND REPLACED SEAT MOUNTED EMERGENCY LIGHT AT 36C, OPS CHECK GOOD.SDR SCNA20251024408View Port · detachedL1 SLIDE VIEWING WINDOW DETACHED. REATTACHED L1 DOOR SLIDE VIEWING WINDOW REF AMM 25-66-01SDR UIEA2025102301277Slide · activatedR4 ENTRY DOOR SLIDE ACTIVATED DUE TO FLT ATTENDANT INADVERTENT OPENING, DOOR ARMED. R & R DOOR SLIDE PER AMM 25-66-01. NO FURTHER DEFECTS NOTED.SDR AALA202510244542Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: INOP BATTERY EMERGENCY POWER SUPPORT UNIT 12WL IN PAX CABIN. MAINTENANCE REPLACED BATTERIES OF THE EMERGENCY POWER SUPPLY UNIT (EPSU) 12WL IAW A320 FAM AMM 33-51-38-000-002-A AND A320 FAM AMM 33-51-38-400-002-A.SDR AALA202510244234Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: INOP BATTERY EMERGENCY POWER SUPPLY UNIT 11WL IN PAX CABIN. MAINTENANCE REPLACED BATTERIES OF THE EMERGENCY POWER SUPPLY UNIT (EPSU) 11WL IAW A320 FAM AMM 33-51-38-000-002-A AND A320 FAM AMM 33-51-38-400-002-A.SDR AALA202510240661Slide · defectiveAIRCRAFT IN BASE MAINTENANCE: L1 EMERGENCE DOOR SLIDE BAD REQUIRES REPLACEMENT. MAINTENANCE REPLACED SLIDE PER JOB CARD 26L00025011.SDR 2025F00249Deck Plate · dentedA DENT WAS DISCOVERED ON THE TRANSMISSION DECK. THE DAMAGE MEASURES APPROX. 0.6" LONG, 0.6" WIDE WITH A MAXIMUM DEPTH OF 0.0120".SDR DALA2025102307769Power Supply · no testFOUND THE CIDS EPSU SYS TEST EPSU(FIN:16WL) DOOR 3 CLASS1 FAULT MESSAGE. REMOVED & REPLACED EPSU 16WL AND R/R THE EPSU BATTERY AS PER A330 AMM 33-51-38. (1267110).SDR DALA2025102307768Skin · gougedFOUND GOUGE ON FUSELAGE SKIN WITH BELLY FAIRINGS 197FB AND 197GB TOUCH AREA. COMPLIED WITH ER/A 629865-14. (1266831).SDR DALA2025102307767Skin · gougedSHIP 3314 FOUND GOUGE ON FUSELAGE SKIN WITH BELLY FAIRINGS 198HB AND 198GB TOUCH AREA.. COMPLIED WITH ER/A 629866-14. (1266681).SDR GTIA2025102339148Megaphone · inoperativeL1 MEGAPHONE NOT WORKING. R & R L1 MEGAPHONE IAW NK DRW A321NEO-EMER-EQUIP/CMM 25-60-01 OPS CK GOOD.SDR JR2R20251023504Gusset · corrodedFLOOR GUSSET AT FR84, LBL 24, IS CORRODED. OUT OF LIMITS. REPLACEDSDR AALA202510239555Power Supply · inoperativeAIRCRAFT WAS GROUNDED: DURING ACCOMPLISHMENT OF EPSU SYSTEM TEST ON P/S CHECK, HAD EPSU UNIT FAULT EMER R. T/S IAW TSM 33-51-00-810-801-A. EPSU BITE OF 12WL CONFIRMED UNIT FAULT. MAINTENANCE REPLACED EPSU 12WL IAW AMM 33-51-38.SDR FDEA202510232075Floor Panel · dentedMAIN CARGO COMP. APROX. STA 285 TO 412 & RBL33 TO RBL54.75, ABOVE FLOOR PANEL 222BFF HAS INDENTATION. FABRICATED NEW FLOOR PANEL 222BFF, RBL 33- RBL 54.75, BS 282-412 IAW DWG 141T5856-106. SEE JPF FOR ALL THE WORK PERFORMED. THIS IS A MAJOR REPAIR. INSTALSDR JR2R20251023271Profile · crackedLH HORIZONTAL STABILIZER, RIB 11 IS CRACKED. REPLACEDSDR JR2R20251023492Profile · gougedFWD AVIONICS HATCH ACCESS PROFILE HAS SEVERAL GOUGES. OUT OF LIMITS. REPAIREDSDR KCSA202510231221Battery · no testLOG BOOK ENTRY # 100211059 R1, EPAS FAILS BATTERY CHECKSDR YENA2025102301053Unknown · odorFLT#1189, JFK-SAN. "MILD PERSISTENT ODOR NOTED, IN CABIN DURING FINAL APPROACH. APPARENT SOURCE WAS AIR CONDITIONING SYSTEM. ODOR PERSISTENT THROUGHOUT CABIIN. ODOR SIMILAR TO DIRTY SOCKS ODOR DISSIPATED AFTER LANDING; PERFORMED IDLE AND HIGH POWER ENG RUN. COSDR JR2R20251023211Seat Track · corrodedRIGHT HAND SEAT TRACK BEAM AT RBL 11 BETWEEN FRAMES 84 AND 85 IS CORRODED. OUT OF LIMITS. REPAIREDSDR KCSA202510231220Skin · crackedDURING OPEN HOLE INSPECTION FOR BOEING SB 777-57A0125, FASTENER #5 ON L/H WING UPPER SKIN HAS A CRACK INDICATIONSDR DALA2025102307755Skin · dentedROUND DEPRESSION AND PAINT PEEL CENTER OF RADOME. REPAIRED PER A319 AMM 53-15. (7950966)SDR DALA2025102307754Housing · broken28D SEAT MOUNTED PATHWAY EMERGENCY LIGHT HOUSING BROKEN. R/R 28D E-LIGHT HOUSING, REF A 319 AMM 33-51. (6683113).SDR 4DSR20251023002Brake · out of toleranceDURING A SCHEDULED 12YR INSPECTION, THE MGB ROTOR BRAKE WAS FOUND TO BE OUT OF TOLERANCE/LOOSE AND REQUIRED REPLACEMENT. RECEIVED ROTOR BRAKE P/N: 350A32-0500-02 FROM NAMPA VALLEY HELICOPTERS IN "REPAIRED" STATUS/WORK. AFTER VISUAL RECEIVING INSPECTION, THE ATSDR KCSA202510231219Skin · crackedDURING OPEN HOLE INSPECTION FOR BOEING SB 777-57A0125 FASTENERS #5 & #6 ON R/H WING UPPER SKIN HAVE CRACK INDICATIONSSDR KCSA202510231218Floor Support · corrodedFLOOR SUPPORT FITTING STA 1769 APPROX RBL 92 HAS CORROSION