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 UIEA2025082601143Flashlight · inoperativeCAPTAIN FLASHLIGHT INOP(<P>R/R CAPT FLASHLIGHT IAW AMM 20-11-00. OPS CHECK GOOD IAW AMM 25-64-01. THIS CLOSES MDDR 236966. PLACARD REMOVED.</P>)SDR UIEA2025082701144Skin · damagedRIGHT LOWER AFT FUSELAGE SKIN DAMMAGE FWD OF AFT LOWER CARGO DOOR. REPAIR TO DAMAGE AT FS 1802, STR 35R C/W IAW EO 4453C592 PART 1 CATEGORY C IAW SRM 53-00-01. REPEAT VISUAL INSP DUE EVERY 250 F/C. TRANSFERRED TO NON-MEL 237259. LP 1915290 M14: PERMANENT REPASDR DALA2025090206481Liner · out of adjustESCAPE SLIDE ARMED CONDITION INDICATORS 1R. FOUND R1 DOOR LINER RUBBING AGAINST INDICATOR, ADJUSTED DOOR LINER, PERFORMED DOOR EMERGENCY MECHANISM SYSTEM TEST IAW B757 AMM 52-11, ALL OPS NORMAL, INDICATOR EXTENDS AND RETRACTS NORMAL. (1167859)SDR DALA2025090206478Power Supply · inoperativeEMER LIGHTING ILLUMINATED IN DELTA ONE ON RIGHT SIDE ONLY WHEN COCKPIT EMER EXIT LT SW TURNED OFF, LIGHTS GO OUT WHEN SW ARMED LIGHTS COME ON. R/R EPSU IAW A350-A-33-51-32-A0001-520A-A OPS NML NO DEFECTS NOTED AT THIS TIME A/C OK FOR SVC. (LP# 7777822)SDR CVGA20250902001Relay · failedFLAPS FAIL CAS MESSAGE ON DEPARTURE. EMERGENCY DECLARED. REMOVED AND REPLACED FLAP RELAY BOX ASSEMBLY IAW CESSNA 750 MM 27-51-00. OPERATIONAL CHECK PASSED, REMOVED FLAP RELAY BOX ASSY . INSTALLED SERVICEABLE FLAP RELAY BOX.SDR AALA202509027003Door Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK AT EMERGENCY EXIT DOOR 844, AFT SEGMENT FR41. MEASURE OF CRACK IS 1.015 IN. MAINTENANCE REPLACED EMERGENCY EXIT DOOR 844, AFT SEGMENT FR41 IAW EO 5210Y228-001.SDR FDEA202508271583Floor Support · noneEXISTING REPAIR ON MAIN DECK FLOOR SUPPORT AT -Y1959 BETWEEN FR12A AND FR18 REQUIRES EVALUATION FOR CONFORMITY THE EXISTING REPAIR ON MAIN DECK FLOOR SUPPORT AT -Y1959 BETWEEN FR12A AND FR18 WAS EVALUATED AND FOUND IN CONFORMITY WITH DWG: A53612213(ISSUE: SDR AALA202509021286Bolt · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING LEADING EDGE NR 11 SLAT TRACK FORWARD BOLT BETWEEN WS 12277 AND WS 12870, BETWEEN RIBS 23 AND 24. REPLACED BOLT PER TASK CARD CARD 26C61057005.SDR AALA202509027240Bolt · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING LEADING EDGE NR 12 SLAT TRACK UPPER FORWARD BOLT BETWEEN WS 13464 AND WS 14057, BETWEEN RIBS 25 AND 26. REPLACED BOLT PER TASK CARD CARD 26C61057005.SDR DALA2025090206467Compressor · stalledATB TO ORD DUE TO LT ENGINE COMPRESSOR STALL. REPLACED LEFT ENGINE. (7851686)SDR DALA2025090106462Bracket · excess playATB DUE TO L/G DOORS NOT CLOSED, L/G GEAR NOT UPLOCKED, AND L/G SHOCK ABSORBER FAULT ECAM WARNINGS. FOUND EXCESSIVE PLAY OF FLIGHT/GROUND SENSING MECHANISM BRACKET DUE TO LOOSE BOLT AND WORN-OUT BUSHINGS. REPLACED FLIGHT/GROUND SENSING MECHANISM BUSHED LEVER,SDR AALA202508311960Handle · bindingAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND AFT PASSENGER / CREW DOOR EMERGENCY CONTROL HANDLE DOES NOT FULLY MOVE TO DISARM POSITION WITH SLIDE GIRT BAR INSTALLED. MAINTENANCE REPLACED SLIDE PER TASK CARD 26L00025011_R4. A SATISFACTORY OPERATIONAL CHECK OF THE DSDR N6WA2025083003Seat Track · corrodedCORROSION ON LH INBD SEAT RAIL AT FS581-FS708. REMOVED AND REPLACED LH SEAT RAIL AT FS581-FS708 IAW CRJ AMM 51-00-49SDR N6WA2025083002Seat Track · corrodedCORROSION ON RH SEAT RAIL AT FS708-FS847. REMOVED AND REPLACED SEAT RAIL AT FS708-847 RH SIDE IAW CRJ AMM 51-00-49SDR AALA202508300435Hydraulic Line · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED INBOUND INTO CLT DUE TO THE FLIGHT CREW REPORTING A GREEN HYDRAULIC SYSTEM RESERVOIR LOW LEVEL ECAM MESSAGE. THE FLIGHT CREW MANUALLY EXTENDED THE LANDING GEAR AND SAFELY LANDED AT CLT WHERE IT TAXIED TO THE GATSDR 2025FA0000591Reservoir · leakingAIRCRAFT DEPARTED KSHR AT APPROXIMATELY 0812 ENROUTE KBIL. ON APPROACH INTO KBIL, LANDING GEAR WAS SELECTED DOWN BUT FAILED TO FULLY EXTEND. THE PILOT FOLLOWED EMERGENCY LANDING GEAR EXTENSION PROCEDURES AND GOT ALL THREE LANDING GEAR DOWN AND LOCKED. THE AIRCSDR DALA2025082906395Dampener · no testDONT PASS OPERATIONAL TEST EMERGENCY DOOR DAMPER ON PASSENGER CREW DOO R 841. REPLACED EMERGENCY DOOR DAMPER ON PASSENGER CREW DOOR 841 AS PER A320 FAM AMM 52-11-14-000-001-B AND CLOSED CIRCUIT BREAKERS ASPER A320 FAM AMM 52-11-14-400-001-B. (11687053).SDR SWAA2025082908763Flashlight · no testEMERGENCY FLASHLIGHT IN AFT CABIN FAILED TO TEST. 0 REMOVED AND REPLACED AFT CAPT SIDE FLASHLIGHT BATTERY IAW AMM 25-64-00.SDR SWAA2025082908877Battery · inoperativeFWD GALLEY FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED BATTERY PACK IN REFERENCE TO AMM 25-64-00.SDR SWAA2025082909205Sign · brokenEMERGENCY EXIT SIGN AT MID CABIN IS BROKEN/MISSING A PANEL. INSTALLED PANEL ON SIGN PER AMM 33-51-01.SDR SWAA2025082908541Battery Pack · failedPASSENGER CABIN; BATTERY PACKS M2816 & M1673 FAILED CAPACITY TEST. R & R BATTERY PACKS M2816 & M1673 IAW AMM 33-51-06.SDR SWAA2025082908725Handle · looseL1 DOOR BOTH ASSIST HANDLES LOOSE.<[01] TIGHTENED L1 DOOR ASSIST HANDLES PER AMM 52-11-31SDR SWAA2025082908864Handle · looseR1 DOOR ASSIST HANDLE LOOSE. TIGHTENED R1 DOOR ASSIST HANDLE PER AMM 52-41-31.SDR HYIA20250829001Fitting · crackedDURING LIGHTED BORESCOPE INSPECTION (TEXTRON MEL54-02R3) TO SATISFY THE REQUIREMENT OF AD 2017-10-09, A CRACK WAS IDENTIFIED ON THE OUTBOARD SIDE OF THE LEFT HAND INBOARD NACELLE FITTING ( OEM: 5292029-21). THIS CRACK MEASURES APPROXIMATELY .287 INCHES LONG ANSDR AALA202508293411Bottle · low pressureAIRCRAFT WAS GROUNDED: 2R DOOR LOW PRESSURE INDICATED. MAINTENANCE SERVICED R2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202508294321Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202508291520Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202508299000Battery Pack · inoperativeAIRCRAFT WAS GROUNDED: LEFT AFT LAVATORY EMERGENCYLIGHT INOPERATIVE. REMOVED AND REPLACED EXIT LIGHT ASSEMBLY AT LAVATORY-D, BUT NO HELP. **SUPPLEMENTAL REPORT FOR (AALA202508289000): REPLACED LEFT LAVATORY EMERGENCY LIGHT BATTERY PACK. PER AMM 33-50-00. OPERASDR DALA2025082906391Limiter · trippedMISC/DE - DUE TO F/CTL SLATS FAULT ECAM WARNING AND SLATS STUCK IN THE UP POSITION. FOUND TORQUE LIMITER AT LEFT WING SLAT ACTUATOR #7 (6037CM) TRIPPED. REPLACED #7 SLAT ACTUATOR (6037CM) AT LEFT WING. (LP 7768702)SDR CNMA2025080001Fan · fault messageON CLIMB AT 5000 FEET R RECIRC FAN EICAS. AT 6500 FEET LOUD BAND AND YAW AND R RECIRC FAN EICAS EXTINGUISHED. WE HAD A BURNING SMELL, ENGINE INDICATIONS NORMAL. VIBRATION ON DECENT BUT ENGINE INDICATIONS NORMAL. OIL SMELL BACK OF CABIN AFTER SHUTDOWNSDR AALA202508294784Connector · brokenAIRCRAFT IN BASE MAINTENANCE: R-1 DOOR EMERGENCY LIGHT POWER WIRE THAT CONNECTS TO PANEL 222VW AT FORWARD LOWER DOOR FRAME HAS BROKEN TERMINAL END CLIP. MARKED WITH RED TAPE. MAINTENANCE REMOVED BROKEN CONNECTORS INSTALLED NEW CONNECTORS, IAW ESPM 20-48-14.SDR AALA202508290983Power Supply · faultyAIRCRAFT WAS NOT GROUNDED: EPSU BATTERY FAULT ON (10WL) FWD LEFT. MAINTENANCE REPLACED BATTERY FOR (10WL) IAW AMM 33-51-38.SDR OEJA2025082900001Warning Message · illuminatedON CLIMB OUT HEADING TOWARDS 25,000 FT A PACK 2 VAILVE FAIL CAS MESSAGE APPEARED , WHE THE AIRCRAFT REACHED 25,000 THE CABIN BEGAN TO RAPIDLY RISE. CREW PERFORMED A EMEGANCY DESENT TO 10,000 FEET AND CHOSE TO DEVERT TP KRAP . LANDED THE AIRCRAFT SAFTLEYSDR SCNA20250829343Nut Plate · missingREMOVED ESCAPE SLIDE GIRT BAR BRACKETS FOM, AFT ADAPTER PLATE AFT SCREW NUTPLATE FOUND TO BE MISSING, RTV HELD SCREW IN PLACE. REMOVE ESCAPE SLIDE GIRT BAR BRACKETS FOM, REF AMM 25-66-02. INSTALLED NUT PLATE AMM20-20 INSTALLED L1 DOOR ESCAPE SLIDE GIRT BAR SDR SCNA20250829342Attach Angle · damagedEMERGENCY LIGHT PANEL AT SEAT ROW 24, 25 DEF SAGGING / LOOSE. REPLACED MISSING BROKEN ATTACH CLIPS IAW MM 25-21-00. REATTACHED PANEL. OK FOR SERVICE.SDR CALA2025082908286Hook · out of adjustGIRT BAR DOOR 2L NOT ENOUGH TENSION, FAS REPORT THAT DOOR HOOKS THAT HOLD SLIDE BAR ARE NOT HOLDING SLIDE TIGHT. ADJUSTED DOOR HOOK MOUNTS AND INSPECTED SLIDE IAW AMM 25-66-01-200-802. NO DEFECTS NOTED.SDR CALA2025082908285Hook · out of adjustFA REPORTS LEFT SIDE OF GIRT BAR ON DOOR 1R IS DIFFICULT TO REMOVE ADJUSTED RETAINING HOOKSDR CALA2025082908284Cover · loose4L SLIDE LIGHT NOT ILLUM INATING WHEN DOOR IS ARMED. FOUND GIRT BAR SLIDER PROXIMITY SWITCH COVER LOOSE. SECURED THE PROTECTIVE COVER TO DOOR CUTOUT AND THRESHOLD IAW AMM 20-30-01-992-002. SLIDE ARMS WITH ARMED LIGHT ON.SDR CALA2025082908283Indicator · damagedOVER HEAD SLIDE TAMPER INDICATOR DAMAGED AT SEAT ROW 1 REPLACED OVER HEAD SLIDE TAMPER INDICATOR AT SEAT ROW 1.SDR CALA2025082908280Battery Pack · inoperativeEMERGENCY EXIT LIGHTS OUT ROWS 9-14 TROUBLESHOT IAW WDM 33-51-21-7. REPLACED THE M2503 BATTERY PACK AND POWER SUPPLY IAW AMM 33-51-06-960-805. OPS CHECKED GOOD.SDR CALA2025082908275Light · malfunctionedEMERGENCY EXIT SIGNS ABOVE SEATS 20-21A STAY ILLUM INATED THE WHOLE FLT. 20-21F SIDE DOES NOT NO RECENT HISTORY FOUND. PERFORMED OPS TEST OF EMERGENCY LIGHTING IN CABIN WITH THE 'EMER EXIT LT' SWITCH IAW AMM 33-51-00-710-008-A. ALL LIGHTS ON ROWS 20 - 21 OPESDR CALA2025082908272Pressure Switch · intermittentLEFT ENG ANTI-ICE EICAS C, LT ENGINE IS IN OPERATION & LT ENG COWL ANTI-ICE VALVE POSITION DOES NOT AGREE WITH THE LT ENG COWL ANTI-ICE SWITCH POSITION LT ENG ANTI ICE CAUTION MESSAGE. COMPLY WITH NNC CHKED, MEGGED & LOAD TESTED WIRES & CIRCUIT TO & FROM D13SDR CALA2025082908262Dummy Rail · corrodedFWD CABIN CTR DUMMY BEAM CORRODED AT FR21. REMOVED AND REPLACED NEW CTR DUMMY BEAM FROM FR 20 TO FR 24 IAW A319 SRM 51-42-11-001.SDR CALA2025082908261Seat Track · corrodedFWD CABIN SEAT TRACK -Y1292 CORRODED AT FR20. REMOVED AND REPLACED SEAT TRACK Y-1292 FROM FR 12 TO FR 24 AT MA IN CABIN IAW SRM 51-42-11 AND SRM 51-72-11-911-001.SDR CALA2025082908260Seat Track · corroded-Y1292 FR 35-36 IS OUT OF LIMITS. REPLACED SEAT TRACK -Y1292 BTW FR 35 TO 36 IAW A319 SRM 51-72-11 AND SRM 51-42-11. SFR #1698.SDR DXTA2025082904738Warning Message · false activationAT THE FINAL APPROACH FIX SELECTED FLAPS FULL. WITH FLAPS ALMOST INDICATING FULL THE INDICATION WENT YELLOW AND RECEIVED THE FLAPS FAIL CAUTION. CHECKED FLAP LEVER DETENT, PRESSED RESET BUTTON AND FLAPS FAIL CAUTION REAPPEARD. PERFORMED FLAP CONTROL SYS TROUBSDR DXTA2025082904740Sign · inoperativeEMER SIGN LIGHT, BEHIND SEAT 7, FACING FORWARD INTO CABIN- LIGHT INOP. NEITHER BATTERY OR SHIP POWER LIGHT THE SIGN CORRECTIVE ACTION: REMOVED THE DEFECTIVE EMER EXIT SIGN LIGHT, BEHIND SEAT 7, FACING FORWARD INTO CABIN, P/N 9919054-1, S/N 21A82 AND INSTALLED SDR DXTA2025082904741Wire · misinstalledDURING CLIMB OUT WE RECEIVED THE EMER LT NOT ARM CAS MESSAGE AND OUR BATTERIES BEGAN TO DISCHARGE. DURING THE SHUTDOWN CHECKLIST THE AIRCRAFT WENT INTO ELECTRICAL EMERGENCY ONCE THE ENGINES WERE SHUT DOWN. REPEAT WRITEUP. FOUND GROUND WIRE AT GS0389 NOT CORRECSDR YENA2025082800896Fire Loop · warning messageFLT#1177, BOS-LAS. (ETOPS) ENG 2 FIRE LOOP A FAULT ECAM ON CLIMB OUT-CLEARED,BUT CAME BACK DURNING FLIGHT; PERFORMED FDU OPS TEST IAW 26-12-00 OPS CHECKS GOOD NO DEFECTS NOTED AT THIS TIME.SDR DALA2025082806381Bpu · mechanic errorC53.1 RT SIDE UPPER BRACKET ON FORWARD SIDE OF FRAME DRILLED NO EDGE DISTANCE. COMPLIED WITH ER/A 628742-14 REV ORIGINAL. (1166164)