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 AALA202512319503Flashlight · activation errorAIRCRAFT WAS NOT GROUNDED: RIGHT-HAND AFT #4 FLIGHT ATTENDANT FLASHLIGHT NOT TESTING. REPLACED FLASHLIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-64-00.SDR AALA202512311106Flashlight · abnormalAIRCRAFT WAS NOT GROUNDED: RIGHT-HAND FORWARD FLIGHT ATTENDANT FLASHLIGHT NOT TESTING. REPLACED FLASHLIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-64-00.SDR AALA202512312498Girt Bar · out of positionAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS GIRT FLAP ON FORWARD ENTRY DOOR TOO LONG. MAINTENANCE TUCKED IN GIRT FLAP IN THE L1 DOOR SLIDE BUSTLE PER AMM 25-66-00.SDR AALA202512311716Flashlight · no testAIRCRAFT WAS NOT GROUNDED: LEFT-HAND FORWARD FLIGHT ATTENDANT FLASHLIGHT NOT TESTING. REPLACED FLASHLIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-64-00.SDR AALA202512310377Flashlight · no testAIRCRAFT WAS NOT GROUNDED: RIGHT-HAND AFT #3 FLIGHT ATTENDANT FLASHLIGHT NOT TESTING. REPLACED FLASHLIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-64-00.SDR AALA202512317690Girt Bar · out of positionAIRCRAFT WAS NOT GROUNDED: FLIGHT CREW REPORTED POTENTIAL SLIDE MATERIAL HANGING OUT OF HOUSING ON R1 DOOR. MAINTENANCE REPOSITIONED GRIT BAR FABRIC FOLD AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK OF THE GIRT BAR PER AMM 25-66-01 WITH NO ISSUES NOTED.SDR REXA2025123101060Lug · chippedLEFT AILERON SIDE LUG LABELED D HAD A CHIP IN THE INSIDE OF THE BORE . COMPLIED WITH REO 690-57-61-476 REV-.SDR DXTA2025123106361Tiller · faultyDURING TAXI OUT TILLER BOUND AND STUCK LEFT. HAD TO STOP THE AIRCRAFT IN ORDER FOR IT TO FREE UP. ALSO NOTICE DURING THE LANDING PHASE AT LOWER SPEEDS AIRCRAFT, TENDED TO TRACK LEFT AND RIGHT. ALSO NOTICED A CLICK AND BIND IN THE TILLER. CORRECTIVE ACTION:REMOSDR HNAA2025123100869Light · inoperativeFWD EMERGENCY LIGHT STRIP INOP. RAR STRIP IAW AMM 33-50-12. OPS CHECK GOOD.SDR SWIA2025123000029Floor Support · corrodedGALLEY FLOOR SUPPORT FWD OUTBOARD FITTING IS CORRODED. OPEN.SDR DALA2025123009523Fuel Control · faultedATB/DE, LEFT ENGINE COMPRESSOR STALL DURING CLIMB. PULLED THROTTLES BACK AND ENGINE WAS STABLE. BORESCOPE COMPLETED WITH NO FINDINGS, REPLACED FCU.SDR DALA2025123009522Actuator · faultyCREW PERFORMED GO AROUND AND ALTERNATE GEAR EXTEND DUE TO RIGHT GEAR NOT SHOWING DOWN AND LOCKED. R & R RT MLG UPLOCK ACTUATOR AND RT MLG DOOR SEQUENCING VALVE.SDR IPXA2025123066036Bulb · inoperativeFLIGHT DECK EXIT LIGHT HAS 11 INOP BULBS. RE-LAMPED FLIGHT DECK EXIT SIGN 11 EACH BULBS IAW AMM 33-51-01-962-001SDR DALA2025123009512Frame · damagedFRAME 63 FWD SIDE AT STRINGER 2R NOTED WITH TOOLING DAMAGE IN HORIZONTAL FACE. REPAIRED PER A330 SRM 53-11. (1376069)SDR DALA2025123009511Frame · damagedFRAME 64 FWD SIDE. STRINGER 2R NOTED WITH TOOLING DAMAGE ON INBD UPPER RADIUS OF STRINGER. REPAIRED PER SRM 51-73-00. (1376066)SDR DALA2025123009510Stringer · damagedTOOLING DAMAGE ON STRINGER 2R FWD OF FRAME 61. REPAIRED PER SRM 53-11. (1376060)SDR DALA2025123009509Frame · damagedFR 64 FWD SIDE AT STRINGER 1R NOTED WITH TOOLING DAMAGE ON INBD UPPER RADIUS OF STRINGER. REPAIRED PER SRM 53-11. (1376058)SDR DALA2025123009508Frame · damagedFORWARD SIDE OF FR 64 AT STRINGER 1R NOTED WITH TOOLING DAMAGE ON OTBD FACE AND UPPER EDGE. REPAIRED PER A330 SRM 53-11. (1376055)SDR DALA2025123009507Stringer · damagedTOOLING DAMAGE ON STRINGER 1R FWD OF FRAME 63. REPAIRED PER SRM 53-11. (1376053)SDR DALA2025123009506Stringer · damagedSTRINGER 1L VERTICAL FLANGE JUST ABOVE FRAME 63 HAD TOOLING DAMAGE. REPAIRED PER SRM 53-11. (1376052)SDR DALA2025123009505Frame · damagedFRAME 63 AND STRINGER 1L HAD TOOLING MARKS IN LIP OF J. REPAIRED IAW SRM 51-73-00. (1376045)SDR DALA2025123009504Stringer · gougedSTRINGER 1L BETWEEN FR61-62 ON BULB SIDE GOUGED INSIDE STRINGER. REPAIRED PER A330 SRM 53-11. (1376043)SDR DALA2025123009503Stringer · damagedSTRINGER 1L HAS TOOLING DAMAGE JUST FWD OF FRAME 64. REPAIRED PER A330 SRM 51-73-00. (1376039)SDR DALA2025123009502Stringer · damagedTOOLING DAMAGE ON STRINGER AT FRAME 60 AFT SIDE AT STRINGER 2L. REPAIRED PER A330 SRM 53-11. (1375999)SDR DALA2025123009501Stringer · gougedSTRINGER 4R JUST FWD OF FR 61 GOUGED ON INSIDE LIP OF J. REPAIRED PER SRM 51-73-11. (1375897)SDR DALA2025123009500Stringer · gougedSTRINGER 3L BETWEEN FR 61 AND FR 62 HAS SMALL GOUGE ON INNER LIP OF J AT FWD HILOK THRU SKIN. REPAIRED IAW SRM 51-73-11. (1375711)SDR DALA2025123009499Stringer · gougedSTRINGER 1R 4 INCHES FWD OF FR61 HAD A SMALL GOUGE ON SKIN ATTACH FLANGE. REPAIRED IAW SRM 51-73-11. (1375706)SDR DALA2025123009498Bracket · damagedBRACKET AT FR 45, S7R HAS TOOLING DAMAGE. REPAIRED IAW ERA 628335-14. (1375646)SDR DALA2025123009496Light · inoperativeEMERGENCY LIGHT INOPERATIVE ABOVE DOOR 2R. REPLACED LIGHT ASSY IAW AMM 33-51. OK FOR SERVICE. (7934073)SDR DALA2025123009494Bottle · low pressureDOOR 3L DOOR BOTTLE PRESSURE IN YELLOW BAND. SERVICED DOOR BOTTLE PER AMM 52-15. (7934070)SDR DALA2025123009492Connecting Rod · disconnectedR1 DOOR WILL NOT OPEN. FOUND TORQUE TUBE CONNECTING ROD DISCONNECTED. REPLACED H/W. DOOR OP CK NORMAL. R1 SLIDE REMOVED & REPLACED TO FOM REFER AMDS WORKCARD 2560-4427. A/C OK FOR SERVICE.SDR DALA2025123009491Fan · odorSTRONG ELECTRICAL SMELL IN FLIGHTDECK BLOWER FAULT QRH COMPLIED WITH. FOUND 20HQ VIBE MONITOR TRIPPED AND FOUND 18HQ CONNECTOR DAMAGED PER A320 AMM 21-26. REPLACED (18HQ) CONNECTOR PER A321 WDM 21-26-09, AND (18HQ) EXTRACT FAN PER A321 AMM 21-26. OPS CHK NMLSDR AALA202512301359Bottle · leakingAIRCRAFT WAS NOT GROUNDED: DUE TO RECENT PIREPS OF 4R DOOR ASSIST BOTTLE REQUIRING SERVICING, REF MICS 1771520 AND 1788556, NEXT MAINT ACCOMPLISH THE FOLLOWING TO PREVENT FUTURE DELAY OR CANCEL. MAINTENANCE REPLACED R4 DOOR DAMPER IAW AMM 52-13-14.SDR SCNA20251230512Screw · missingL1 SLIDE COVER MISSING SCREW. INSTALLED SCREW ON L1 SLIDE IAW AMM 25-66-01SDR SIMA20251229001Power Supply · inoperativeOVERHEAD EMERGENCY LIGHT INOPERATIVE, FIRST LIGHT LOCATED IN FORWARD GALLEY AND 3RD LIGHT LOCATED OIN CABIN CEILING. R & R NR 2 EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01 OPC CHECK GOOD.SDR KCSA202512302978Warning System · false activationDOOR F/D OVHD ADVISORY, PERFORMED OPERATIONAL TEST OF THE DOOR WARNING SYSTEM IAW AMM 52-71-00. OPS CHECK GOOD, NO DEFECTS NOTED.SDR FDEA202512292295Stringer · corrodedMEC BETWEEN BS 418 - 440, S24R CORRODED. PERMANENTLY REPAIRED STRINGER 24R IAW SRM 53-00-03-2R, REP 2, FIG 201.SDR FDEA202512292294Stringer · corrodedAFT CARGO COMPARTMENT, DURING REMOVAL OF PRODUCTION STRINGER SPLICE TO GAIN ACCESS FOR STRINGER REPAIR FOUND STRINGER 21L, BS 1460 - 1465 EXFOLIATED. REPAIRED THE STRINGER IAW SRM 53-00-03-2R, REPAIR 2, FIG 201, DETAIL I, SHEET 6, AND SRM 51-40-02-OG.SDR FDEA202512292293Stringer · crackedAFTER DVI OF THE LAPPED AND OVERLAPPING SKIN UNDERNEATH OF THE EXISTING REPAIR DOUBLER BETWEEN BS 1430 TO BS 1475, STR 20L TO STR 21L FOUND STRINGER 21L CRACKED AT BS 1454. REPAIRED STRINGER 21L BETWEEN STA 1426 TO STA 1456 IAW B 757 SRM 53-00-03-2R REPAIR SDR DALA2025123009489Actuator · excess playLEFT WING, INBD FLAP TRACK NR 1 POSITION, ACTUATOR LEVER WITH EXCESIVE PLAY. REPLACED THE LT FLAP TRACK NR 1 ACTUATOR IAW AMM 27-54-49-000 -001-A AND AMM TASK 27-54-49-400-001-A. (1375546)SDR SCNA20251230511SSkid · nonePOSSIBLE TAIL STRIKE. PERFORMED TAIL STRIKE INSPECTION PER AMM 05-51-32 FOUND TAIL SKID AND SHOW TO STILL IN SERVICEABLE CONDITIONSDR SCNA20251230511Skid · no discrepancyPOSSIBLE TAIL STRIKE. PERFORMED TAIL STRIKE INSPECTION PER AMM 05-51-32 FOUND TAIL SKID AND SHOW TO STILL IN SERVICEABLE CONDITIONSDR HNAA2025123000868None · noneSEVERE TURBULANCE EXPERIENCED. INSPECTED AIRCRAFT IAW W/C 05-20-03. NO DFECTS NOTED. OK FOR SERVICE.SDR CALA2025123012544Fuel Cap · missingFUEL CAP MISSING ON ARRIVAL. REPLACED MISSING FUEL CAP.SDR CALA2025123012542Light · brokenFOUND ROW 32 EMERGENCY SEAT LIGHT BROKEN OFF. R & R THE EMERGENCY LIGHT ASSY IAW AMM 33-51-19-000-002-A, & AMM 33-51-19-400-002-A. OPS CHECKED GOOD.SDR CALA2025123012540Light · inoperativeFOUND SEAT 30ABC EMERGENCY LIGHT INOPERATIVE. R & R ROW 30 EMERGENCY LIGHT ASSY IAW AMM 33-51-19-000-002-A, & AMM 33-51-19-400-002-A. OPS CHECKS GOOD.SDR CALA2025123012538Light · inoperativeFOUND AFT EMERGENCY LIGHT INOPERATIVE, SEAT 27 ABC. R & R THE EMERGENCY LIGHT ASSY IAW AMM 33-51-19-000-002-A, & 33-51-19-400-002-A. OPS CHECKS GOOD.SDR CALA2025123012536Light · brokenFOUND FWD EMERGENCY LIGHT INOPERATIVE, SEAT 25 ABC. R & R THE EMERGENCY LIGHT ASSY IAW AMM 33-51-19-000-002-A, & 33-51-19-400-002-A. OPS CHECKED GOOD.SDR CALA2025123012518Light · brokenSEAT 5F FWD EMERGENCY PATH LIGHT BROKEN. REPLACED 5F EMERGENCY LIGHT, OPS CHECK GOOD IAW AMM 33-51-06.SDR WX0A2025122932684Megaphone · broken(AIRCRAFT NOT GROUNDED) FWD MEGAPHONE BROKEN / FOUND REPLACEMENT FWD MEGA PHONE. REMOVED AND REPLACED FWD MEGA PHONE IAW AMM 25-65-21. OPS CHECK GOOD"