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 AALA202601223832Cam · out of adjustAIRCRAFT WAS NOT GROUNDED: LEFT AFT DOOR SLIDE ARM AND DISARM BRACKET IS STICKING AND DIFFICULT TO ARM AND DISARM. ADJUSTED AFT LEFT HAND DOOR BRACKETS. OPS CHECK GOOD. PER AMM 25-64-00.SDR DALA2026012200487Structure · corrodedAFT FUSELAGE FLOOR STRUCTURE, BETWEEN FR67+300 MM & FR 67+ 480 MM , Y1160 MM LONGITUDINAL BEAMS CORRODED. REPLACED LONGITUDINAL BEAMS IAW SRM 51-41-03A, FIG 303, ITEMS 195A AND 190A INSTALLED IAW DWG D534 72780, ISSUE D, ITEMS 42, & 44. DWG D53472088, ISSUE FSDR DALA2026012200486Seat Track · corrodedAFT CABIN SEAT TRACK AT FR 66, Y765 CORRODED. REMOVED AND EVALUATED CORROSION ON THE SEAT TRACK. FOUND TO BE OUT OF LIMITS, R & R THE SEAT TRACK FROM FR 64 - 66 IAW SRM 51-72-11-911-001. (LP: 1411425)SDR DALA2026012200485Seat Track · corrodedAFT CABIN SEAT TRACK, FR 66, Y1292 CORRODED. REMOVED AND EVALUATED THE SEAT TRACK, FOUND NO DAMAGE TO BE OUT OF LIMITS. R & R THE SEAT TRACK, FR 64 - 68, Y1292 IAW SRM 51-72-11-911-001. (LP: 1411421)SDR DALA2026012200484Seat Track · corrodedAFT CABIN SEAT TRACK AT Y-765 HAS CORROSION FROM FR 66 - FR 68. REMOVED AND EVALUATED CORROSION ON AFT CABIN FLOORBEAM AND SEAT TRACK FROM FR 64-68 AT Y-765 FOUND DAMAGE ON FLOORBEAM TO BE WITHIN LIMITS AND DAMAGE ON SEAT TRACK TO BE OUT OF LIMITS. R & R THSDR DALA2026012200483Seat Track · corrodedAFT CABIN SEAT TRACK FR 66, Y-1292 CORRODED. REMOVED AND EVALUATED CORROSION ON AFT CABIN SEAT TRACK. FOUND DAMAGE TO BE OUT OF LIMITS. R & R THE SEAT TRACK FROM FR 64 - 66 IAW SRM 51-72-11-911-001.SDR CALA2026012213152Rib · wornLEFT OTBD FLAPS NR 1, 2, 3, & 4 AFT FLAP TRACK RIB SUPPORTS HAVE WEAR ON LOWER SURFACES. REMOVED DAMAGE, HFEC AREA, NO DEFECTS NOTED, ROTO PEENED AREA, ALODINED AND PRIMED IAW UAL ECRA 5754-01273, AND ENGINEERING DOC REO-G25762.SDR CALA2026012213150Skin · damagedDURING INSPECTION, FOUND A CREASE MARK ON LE SKIN OF INBD SLAT NR 6, LT WING, ONE AT ISS 170.56 & THE OTHER AT ISS 180.56. REPAIRED IAW SRM 57-43-01-2R2, REPAIR 2, CLASSIFIED AS RII IAW GMM 03-20-20, & GMM 09-25-05.SDR DALA2026012200479Skin · corrodedSKIN CORRODED, LEFT AFT FUSELAGE AT LAV EXHAUST VENT. WHILE IN ATL FOR C-CHECK, MAINTENANCE REMOVED CORROSION ON AFT LAVATORY EXHAUST VENT CUTOUT IAW SRM 53-70-01-2R, REPAIR 3, AND ER/A 631684-14. (LP 1411210)SDR DALA2026012200476Overheat Sensor · faultedRETURNED TO ATL DUE TO RT WING BODY OVERHEAT. REPLACED M371 AND M1763 OVERHEAT ELEMENTS AND OVERHEAT DETECTION MODULE. CHECKED FOR BLEED AIR LEAKS, NONE FOUND. OPS CHECK GOOD. (LP 7725874)SDR DALA2026012200475Lamp · inoperativeAIRCRAFT 3823, AFT RIGHT DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IN THE LIGHT IAW AMM 33-51. (LP 6688808)SDR DALA2026012200474Power Supply · inoperativeLEFT FWD OVERWING EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE BATTERY PACK AND POWER SUPPLY M2335. OPS CHKD GOOD IAW AMM 33-51. (LP 6688809)SDR SIMA202601210001Slat System · multiple failSHAKER ANTICIPATED, AOA LIMIT FAIL, SLAT FAIL, SPDBRK FAIL EICAS MESSAGES APPEARED DURING APPROACH. QRH PROCEDURE FOLLOWED. MESSAGES CLEARED. WORK SCOPE FOR SLAT FAIL EVENT PER FIM 27-81-00-810-802-A BLOCK DIAGRAM 2 EXTENDED SLATS/FLAPS TO POSITION 4 AND DEACTSDR DALA2026012100473Door · fodL2 DOOR WOULD NOT ARM. REMOVED DEBRIS. L2 DOOR OPS OK PER B757 AMM 52-11. (8079160)SDR DALA2026012100471Lanyard · out of positionON CLOSING MAIN CABIN L1 DOOR ARMING LIGHT DID NOT ILLUMINATE, GRIT BAR DID NOT ARM ENGAGE. ATTACHED GIRT BAR LANYARD TO ORIGINAL POSITION, OP CHECKED NORMAL (7990638)SDR SWAA2026012162990Megaphone · inoperativeFWD MEGAPHONE INOPERATIVE. REMOVED AND REPLACED THE MEGAPHONE IAW AMM 25-64-00-SWA-804-NG-01.SDR SWAA2026012163105Megaphone · inoperativeFORWARD MEGAPHONE INOPERATIVE. REMOVED AND REPLACED FWD MEGAPHONE IAW AMM 25-64-00. OPS CHECKED GOOD.SDR SWAA2026012163375Slide · out of adjustCREW REPORTED R2 DOOR SLIDE PROTRUDING FROM BOTTOM OF HOUSING. ADJUSTED THE SLIDE IN R2 DOOR IAW AMM 25-66-01 AND MT 725-61-06.SDR SWAA2026012163383Panel · looseROW 14 DEF EMERGENCY OVER WING EXIT DOOR CLOSING STRAP PANEL LOSE. ATTACHED EMERGENCY EXIT DOOR CLOSING PANEL IAW SIPSDR SWAA2026012162835Door · crackedRIGHT MLG MIDDLE DOOR LEADING EDGE RIB CRACKED. OK TO CONT IAW CDL 32-10-3 AUTH 302757. REMOVED CENTER AND INNER DOOR IAW MM 32-13-11.SDR SWAA2026012162836Light · inoperativeSEAT 14ABC EMERGENCY EXIT LIGHTS INOPERATIVE. REMOVED AND REPLACED M1670 POWER SUPPLY ASSY AT SEAT ROW 20ABC IAW MM 33-51-06. NO HELP. OK TO CONT IAW MEL 33-15-02 SP 01.SDR SWIA2026012075086Fitting · brokenMAIN CABIN DOOR GIRT BAR FORWARD RETAINING SLIDER ON FLOOR DID NOT RETRACT WHEN MCD WAS OPENED. (FLIGHT 3863) REPLACED THE FWD PAX DOOR FWD ESCAPE SLIDE FITTING IN REF TO AMM CH 53-10-21. OPS AND RIG CHECK IS GOOD.SDR AALA202601210036Unknown · odorAIRCRAFT WAS GROUNDED: DESCENDING THROUGH 10,000 FEET AT IDLE, FLIGHT ATTENDANT CALLED INDICATED SMELL IN CABIN LIKE DUST ON OILS. WHILE PERFORMING J/C 08L00021001 FOUND PACK 1 TO HAVE STRONG MUSTY AND OILY SMELL. (OPEN).SDR AALA202601211385Life Raft · high pressureAIRCRAFT IN BASE MAINTENANCE: RAFT NUMBER 1 POSITION PRESSURE READING EXCEEDS MAXIMUM PRESSURE PER CHART. INSTALLED SERVICEABLE LIFE RAFT NUMBER 1. PER AMM 25-64-00.SDR AALA202601210029Carpet · unsecureAIRCRAFT WAS NOT GROUNDED, APPROX FOOT LONG SECTION OF CARPET IN FRONT OF 1L LAV AND LEADING TO FLIGHT DECK DOOR IS CURLED UP 1/2 INCH HIGH, THE CARPET TRIPS PASSANGERS AND AIR CREW. MAINTENANCE LIFTED CARPET AND REFITTED AT FORWARD EDGE, FLIGHT DECK ISLE TO SDR AALA202601217160Bottle · low pressureAIRCRAFT WAS NOT GROUNDED, L2 DOOR ASSIST LOW PRESSURE. MAINTENANCE SERVICE L2 DOOR ASSIST BOTTLE IAW AMM 52-10-00.SDR 141A202601200001Comms Unit · faultedAIRCRAFT EXPERIENCED AN IN-FLIGHT COMMUNICATION MALFUNCTION. THE AIRCRAFT’S COMMUNICATION SYSTEM BECAME STUCK IN THE TRANSMITTING (TX) POSITION, PREVENTING THE CREW FROM RECEIVING ANY TRANSMISSIONS AND EFFECTIVELY BLOCKING THE ACTIVE FREQUENCY. TROUBLESHOOTINGSDR DXTA2026012106619Light Sys · malfunctionedFORWARD CABIN EMERGENCY EXIT LIGHT NOT ILLUMINATING IN THE AUTO POSITION. PERFORMED EMERGENCY LIGHTING ADUSTMENT/TEST IAW MM 33-50-00. ALL EMERGENCY LIGHTS OPERATING NORMALLY.SDR ABXA20260120023Anti-Skid Valve · leakingAFTER ENGINE START UP RT HYD QTY - 0. RH ANTI-SKID SELF RESETTING FUSE VALVE HYD LEAK. AIRCRAFT RETURNED TO BLOCKS (BTB). FOUND #2 SELF RESETTING VALVE FUSE ON THE RH ANTI-SKID MODULE LEAKING. REMOVED AND REPLACED SELF RESETTING VALVE FUSE IAW AMM 32-42-03,SDR ABXA20260120022Bulb · burned outDURING MAINT INSP, EMERGENCY LIGHTS UNARMED LIGHT INDICATION IS HALFWAY BURNED OUT. REMOVED AND REPLACED LIGHT BULBS IAW AMM 33-16-02. OPS CHECK GOOD. REF. LP 38676-39/2. AIRCRAFT RETURNED TO SERVICE.SDR ABXA20260120021Target · out of adjustDURING TAXI OUT, LE SLAT ASYM EICAS MESSAGE ILLUMINATED. A/C RETURNED TO BLOCKS (BTB). MEG CHECKED AND VERIFIED INDUCTANCE OF PROX SWITCH S305.. ADUSTED GAP TO TARGETS REF B767 AMM 27-22-01. SLAT FUNCTIONS AND INDICATIONS NORMAL, REF B767 AMM 27-22-01. AISDR HNAA2026012100052Wheel · abnormalHEAVY NOSE WHEEL SHIMMY AROUND 35 TO 100 KNTS. R & R 100 & 200 NLG TIRE ASSY IAW AMM 32-49-05. NO FURTHER DEFECTS FOUND AT THIS TIME #1,#2 PN:3-1551, #1 SN:04530453 TAT:36464.1 TAC:34125 TSO:683.1; #2 SN:23092309 TAT:24768.6 TAC:23012 TSO:924.7SDR AALA202601212172Bottle · low pressureAIRCRAFT WAS NOT GROUNDED. R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202601214843Bottle · low pressureAIRCRAFT WAS NOT GROUNDED. R2 DOOR DAMPENER AND EMERGENCY OPS CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202601215577Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS FLASHLIGHT BY DOOR 1L NEEDS A BATTERY. MAINTENANCE REPLACED FLASHLIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK IAW AMM 25-65-00.SDR AALA202601210745Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: AFT RIGHT PASSENGER / CREW DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202601212113Elec Connector · looseAIRCRAFT WAS NOT GROUNDED: SEAT ROWS 11,12,13 ABC EMERGENCY PATHWAY LIGHTS INOPERATIVE. MAINTENANCE FOUND LOOSE CONNECTOR (7261VC3-A) AT ROW 12ABC, RESECURED CONNECTOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK OF THE EMERGENCY LIGHTS PER AMM 33-51-19.SDR AALA202601211323Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: AFT LEFT PASSENGER / CREW DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR SCNA20260121039View Port · missingL1 DOOR SLIDE VIEWING WINDOW MISSING. OPENSDR DXTA2026012106608Battery Pack · faultedEMER LIGHTS DO NOT COME ON IN THE ARM POSITION ON PREFLIGHT. REMOVED NR 1 EMERGENCY LIGHT POWER SUPPLY AND INSTALLED A NEW #1 OUTRIGHT EMERGENCY LIGHT POWER SUPPLY IAW MM 33-50-06. OPS TEST IS GOOD AND NO DEFECTS NOTED.SDR DXTA2026012106607Door · faultedMAIN CABIN DOOR LOCKING PIN IS SLIGHTLY EXTENDED WITH THE DOOR CLOSED AND FACING THE DOOR. IT'S THE BOTTOM LEFT PIN. UNABLE TO CLOSE THE DOOR. THE DOOR HANDLE WILL NOT NOT MOVE. ADDITIONALLY, CANNOT CLOSE IT FROM THE OUTSIDE EITHER. PERFORMED DETAILED INSPECSDR CALA2026012113124Bulb · failedFA REPORTS POSSIBLE VAPOR OR SMOKE VISIBLE BEHIND OVERHEAD LIGHT LENS IN AFT GALLEY. PERFORMED A VISUAL INSPECTION FOR EVIDENCE OF BURNING OR ARCING. FOUND THE AFT CENTER FLUORESCENT LIGHT BUZZING & FLICKERING. FOUND THE AFT GALLEY NIGHT LIGHT BURNT OUT, RESDR CALA2026012113122Battery Pack · no testDURING THE EMERGENCY LIGHT BATTERY CAPACITY TEST PER AMM 33-51-06-200-801, FLOOR PROX LIGHTS AT ROW 1-4 AND 7-15 FAILED THE REQUIREMENT. BATTERY PACKS AT M1674 AND M2503 NEEDS TO BE REPLACED.SDR CALA2026012013119Warning Message · illuminatedRIGHT DOOR FWD AND AFT OVERWING FAULT ECAM ON SHUTDOWN. CONDUCTED FIM 52-22-00-810-816-A. FAULT NOT PRESENT FOR CONFIRMATION. VERIFIED INBD HANDLES ARE IN CLOSED POSITION.SDR CALA2026012013117Battery Pack · no testDURING THE EMERGENCY LIGHT BATTERY CAPACITY TEST PER AMM 33-51-06-200-801, FLOOR PROX LIGHTS AT ROW 1-4 AND 7-15 FAILED THE REQUIREMENT. BATTERY PACKS AT M1674 AND M2503 NEEDS TO BE REPLACED. PARTS ARE PLACED ON AOG. REMOVED AND REPLACED BOTH EMERGENCY SUPPLYSDR CALA2026012013116Unknown · odorF/A REPORTS BURNING/ACRID ODOR IN FWD GALLEY WALK THROUGH THE CABIN AFTER TALKING TO THE CREW, CHECK ALL THE LAV, FWD, AFT GALLEY OVEN TURN ON FOR CHK COULD NOT DUPLICATE ANY BURNING ODOR AND ALSO TURN ON THE PACK FOR CHK TO SUSPECT THE ODOR CAME FROM OUTSIDE SDR DALA2026012000434Cover · unsecureEXIT SIGN COVER NOT SECURE AT 3R JUMPSEAT / INTERIOR. SECURED THE COVER ON HOUSING. (LP 1410392)SDR DALA2026012000433Wire Harness · damagedFOUND EMERGENCY LIGHTS OUT AT ROWS 43 - 45 A, B, C & ROWS 33 & 34 A, B, C. BUTT SPLICED WIRE HARNESS AT ROW 32 A, B, C IAW ESPM 20-43. CRIMPED NEW PIN ON WIRE HARNESS AT ROW 45 A, B, C IAW ESPM 20-48. ALL CHKD GOOD IAW AMM 33-51. (LP 8574411)SDR DALA2026012000432Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT - YC1, FR 73 TO FR 74, REFER TO CPCP TASK NR 534159-01-2. THE SEAT TRACK WAS REPLACED IAW SRM 51-72-11-911-001. REV 27. (LP 1410770)SDR DALA2026012000431Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT YC1, FR 73 TO FR 74, REFER TO CPCP TASK NR 534159-01-2. SEAT TRACK WAS REPLACED IAW SRM-NEO 51-72-11-911-001. REV 27. (LP 1410753)