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 CALA2025112711528Seat Track · corrodedSEAT TRACK AT LT +Y1292 BETWEEN FR35-39 HAS EVIDENCE OF CORROSION. REMOVED AND REPLACED THE SEAT TRACK AT FR35-39 IAW SRM 51-42-11-001/51-72-11.SDR CALA2025112711526Fitting · corrodedAFT FLOOR LT WEB AT FR 66 FWD OF GIRT BAR FITTING CORROSION. PERFORMED FITTING REPAIR AT FR 66 WEB FWD OF GIRT BAR IAW SRM 53-41-14-300-001.SDR CALA2025112711524Floor Support · corrodedMAIN DECK FLOOR AREA RBL 1 AT FR 352 FLOOR SUPPORT HAS SURFACE CORROSION. PERFORMED REPAIR AT MAIN DECK FLOOR SUPPORT BETWEEN RBL 1 FR 352 IAW SRM 51-70-11-0G-0.SDR CALA2025112711522Skin · debondedRIGHT WING, OTBD FLAP, AFT FLAP, INBD END, UPPER SKIN DEBONDED SIGNAL NOTED, AREA L=1X1.25 INCHES. CLEANED, PREPPED, REPAIRED & RESTORED PAINT AT RT WING, OTBD FLAP, AFT FLAP, INBD END, UPPER SKIN IAW SRM 57-5 3-01-2R-16, SRM 51-70-10-2R-0, AMM 51-21-41-370SDR CALA2025112711520Transition Panel · corrodedAFT CARGO COMP TRANSITION PANEL BS 1300 - 1380 HAS EXFOLIATION.SDR CALA2025112711518Fuel Cap · missingFUEL CAP MISSING CONFIRMED FUEL CAP MISSING. INSTALLED REFUEL COUPLING CAP IAW AMM 28-25-41. OPS CHECKED GOOD.SDR CALA2025112711516Skin · damagedRT WING OTBD AILERON, WATER INGRESSION FOUND. PERFORMED PERMANENT COMPOSITE REPAIR AT WATER INGRESSION AREA IAW ECRA 5760-01124 REV A.SDR CALA2025112711514Skin · damagedLEFT OTBD AILERON HAD WATER INGRESSION. LT OTBD AILERON PERFORRMED PERMANENT COMPOSITE REPAIR AT WATER INGRESSION AREA PER ECRA 5760-01123 REV A.SDR YENA2025112801124Unknown · odorFLT#193, EWR-STI. DIRTY SOCK SMELL FROM PACKS ON CLIMBOUT AND DESCENT BELOW 10,000; COMPLIED WITH INFO NOTICE 2017-T015 SECTION B1. IDENTIFY ODOR ON APU, SEE ITEM OF LOG PAGE 4448986 FOR APU MEL, A/C OK FOR SVC.SDR DALA2025112708679Seal · leakingFLIGHT ATTENDANTS SMELLED DIRTY SOCK SMELL FORWARD SECTION OF PLANE AFTER GEAR DROPPED. DISSIPATED SOON AFTER. FOUND OIL WETTING ON NR 2 ENG SPINNER. REPLACED ORING ON FANSHAFT COVER & INSTALLED FANSHAFT COVER IAW AMM 72-15. (LP 8139258, 8139260)SDR DALA2025112708677Elec Connector · disconnectedL1 DOOR EMERGENCY EXIT LIGHT NOT ILLUMINATED. FOUND ELECTRICAL CONNECTOR FOR 1L DOOR EMERGENCY EXIT LIGHT DISCONNECTED. CONNECTED ELECTRICAL CONNECTOR, DOOR EXIT LIGHT OPS NORMAL IAW AMM 33-51. (LP 7658282).SDR DALA2025112708676Light · malfunctionedEXIT LIGHTS ABOVE OVERWING EXITS KEPT FLICKERING THROUGHOUT FLIGHT. EXIT SIGNS CURRENTLY OPS CK NORMAL. UNABLE TO DUPLICATE FLICKERING. REF AMM 33-51. (8171861).SDR DALA2025112708675Pin · missingDOOR DISARM PIN MISSING LOCKING BALLS, PIN WON'T STAY LOCKED IN. REPLACED DISARM PIN PER AMM 52-13. CKS OK. (1323557)SDR DALA2025112708674Door Frame · dentedLOWER FUSELAGE, RT AVIONICS COMPARTMENT DOOR CUT OUT, FWD UPPER CORNER AT FR12 DENT. REPAIRED PER ERA 630214-14. (1323547)SDR DALA2025112708673Flap Track · corrodedRIGHT WING OTBD FLAP TRACK NR 3, OUTER RIB 5, AT ECCENTRIC BEARING AREA, CORRODED. REPAIRED IAW ER/A 630238-14. (1323092)SDR DALA2025112708672Buffer · out of adjustOUT OF ADJUSTMENT BUFFER OF PASSENGER CREW DOOR 832 IN FULL OPEN POSIT ION AT PASSENGER CABIN. PERFORMED ADJUSTMENT BUFFER OF PASSENGER CREW DOOR 832 IN FULL OPEN POSITION AT PASSENGER CABIN AS PER FAM AMM52-13-00-820 -001-A. (1323165)SDR DALA2025112708671Door · out of adjustOUT OF ADJUSTMENT RIGGING POINT K ON PASSENGER CREW DOOR 832 IN UP POSITION AT PASSENGER CABIN. PERFORMED ADJUSTMENT RIGGING POINT K ON PASSENGER CREW DOOR 832 IN UP POSITION AT PASSENGER CABIN AS PER A320 FAM AMM 52-13-21- 400-001-A. (1323175)SDR DALA2025112708670Bearing · damagedLEFT WING FLAP INTERCONECTION STRUT ATTACHED POINTS ROD END AND BEARING DAMAGED. REPLACED BEARING AT LT WING INBD FLAP INTERCONNECTING STRUT ATTACH POINT IAW CMM TASK 57-52-21-300-803-A01. (1323073).SDR DALA2025112708669Bearing · damagedRIGHT WING FLAP INTERCONNECTION STRUT ATTACHED POINTS ROD END AND BEARING DAMAGED. REPLACED BEARINGS AT RT WING INBD FLAP INTERCONNECTING STRUT ATTACH POINT IAW CMM TASK 57-52-21-300-803-A01. (1323054).SDR DALA2025112708668Tab · wornLEFT WING, SLAT NR 4 INBD TRACK FWD BOLT, ANTI-ROTATION TAB WORN. REPAIRED ANTI-ROTATION LOWER LUG SLAT 4, TRACK RIB 9 IAW SRM 57-40-00-300-113. (1322886).SDR DALA2025112708667Tab · wornLEFT WING, SLAT NR 3 INBD TRACK, FWD BOLT, ANTI-ROTATION TAB WORN. REPAIRED ANTI-ROTATION LOWER LUG SLAT 3, TRACK RIB 7 IAW SRM 57-40-00-300-112. (1322881).SDR DALA2025112708666Bearing · excess playLEFT WING NR 2 SPOILER HAS PLAY, IT HAS 1.50 MM. REPLACED BEARINGS, SLEEVES AND BUSHINGS AT CENTER HINGE BRACKET ASSY IAW CMM TASK 57-72-21-010-803-A01. (1323295).SDR DALA2025112708665Bearing · excess playLEFT WING NR 3 SPOILER HAS PLAY, IT HAS 1.64 MM. REPLACED BEARINGS, SLEEVES AND BUSHINGS AT CENTER HINGE BRACKET ASSY IAW CMM 57-73-21-000-803-A01. (1323285).SDR DALA2025112708664Bearing · excess playLEFT WING NR 1 SPOILER HAS PLAY, IT HAS 1.31 MM. REPLACED BEARINGS, SLEEVES AND BUSHINGS AT SPOILER NR 1 IAW CMM 57-71-21-000-805-A01. (1323273).SDR DALA2025112708663Bearing · excess playLEFT WING NR 4 SPOILER HAS PLAY, IT HAS 1.48 MM. REPLACED BEARINGS, SLEEVES AND BUSHINGS AT CENTER HINGE BRACKET ASSY IAW CMM 57-74-21-000-804-A01. (1323262).SDR DALA2025112708662Bearing · excess playRIGHT WING NR 2 SPOILER HAS PLAY, IT HAS 1.77 MM. REPLACED BEARINGS, SLEEVES AND BUSHINGS AT CENTER HINGE BRACKET ASSY IAW CMM TASK 57-72-21-010-803-A01. (1323256).SDR DALA2025112708661Bearing · excess playRIGHT WING NR 3 SPOILER HAS PLAY, IT HAS 1.20 MM. REPLACED BEARINGS, SLEEVES AND BUSHINGS AT CENTER HINGE BRACKET ASSY IAW CMM 57-73-21-000-803-A01. (1323249).SDR DALA2025112708660Bearing · excess playRIGHT WING NR 5 SPOILER HAS PLAY, IT HAS 1.80 MM. REPLACED BEARINGS, SLEEVES AND BUSHINGS AT CENTER HINGE BRACKET ASSY IAW CMM 57-75-21-000-806-A01. (1323240).SDR DALA2025112708659Spoiler · excess playRIGHT WING NR 4 SPOILER HAS PLAY, IT HAS 1.60 MM. REPLACED BEARINGS SLEEVES AND BUSHINGS AT CENTER HINGE BRACKET ASSY IAW CMM 57-74-21-000-804-A01. (1323235).SDR DALA2025112708658Access Panel · corrodedRIGHT WING TANK, ACCESS PANEL 640QB WITH BOLT HOLES WITH CORROSION IN SEVERAL PLACES. REPLACED ON RT WING TANK FUEL ACCESS PANEL 640QB IAW SRM 51-72-11-911-001. (1322924).SDR DALA2025112708657Access Panel · corrodedRIGHT WING TANK, ACCESS PANEL 640NB WITH BOLT HOLES WITH CORROSION IN SEVERAL PLACES. REPLACED ON RT WING TANK ACCESS PANEL 640NB IAW SRM 51- 72-11-911-001. (1322918).SDR DALA2025112708656Access Panel · corrodedRIGHT WING TANK, ACCESS PANEL 640MB WITH ELONGATED HOLES AND SCRACHES IN THE LOWER SURFACE. REPLACED ON R/H WING TANK ACCESS PANEL 640MB IAW SRM 51- 72-11-911-001. (1322913).SDR DALA2025112708655Access Panel · corrodedRIGHT WING TANK, ACCESS PANEL 640KB WITH BOLT HOLES WITH CORROSION IN SEVERAL PLACES. REPLACED ON RT WING TANK ACCESS PANEL 640KB IAW SRM 51- 72-11-911-001. (1322909).SDR DALA2025112708654Access Panel · corrodedRIGHT WING TANK, ACCESS PANEL 640JB WITH BOLT HOLES WITH CORROSION IN SEVERAL PLACES. REPLACED ON RT WING TANK ACCESS PANEL 640JB IAW A319 SRM 51- 72-11-911-001. (1322904).SDR DALA2025112708653Access Panel · corrodedLEFT WING TANK, ACCESS PANEL 540PB WITH BOLT HOLES WITH CORROSION AND ELONGATED. REPLACED ON LT WING FUEL TANK ACCESS PANEL 540PB IAW A319 SRM 51-72-11-911-001. (1322890).SDR 2025F00274Battery · dischargedBOTH L1 AND R2 HAD THEIR EPAS BATTERIES DEPLETED, REPLACED PER AMM.SDR 2025FA0000787Elec Connector · dirtyYAW ACTUATOR LIGHT ILLUMINATED ON AUTO PILOT TEST. INSPECTED, CLEANED, AND RESEATED THE YAW SEMA CANNON PLUG PROBLEM WENT AWAY.SDR IPXA2025112650436Door · slowON DEPARTURE AFTER GEAR RETRACTED BOTH MAIN LANDING GEAR DOORS REMAINED OPEN OPENED AND CLOSED MAIN GEAR DOORS IAW AMM 32-12-11/301. NO DEFECTS NOTED. TECH SUPPORT SUSPECTS DOORS SLOW TO CLOSE ON GEAR HANDLE OPERATION. FURTHER TROUBLESHOOTING REQUIRED.SDR AALA202511260049Bottle · low pressureAIRCRAFT WAS GROUNDED: R2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202511266192Bottle · low pressureAIRCRAFT WAS GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202511264782Bottle · low pressureAIRCRAFT WAS GROUNDED: R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202511269785Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: RIGHT EMERGENCY EXIT DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202511263042Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT FOR EMERGENCY POWER SUPPLY UNIT 12WL DISPLAYED DURING SYSTEM TEST. REPLACED BATERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202511266537Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT FOR EMERGENCY POWER SUPPLY UNIT 14WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202511260077Bottle · low pressureAIRCRAFT WAS GROUNDED: L2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202511268092Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202511268923Lamp · inoperativeAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT DOES NOT ILLUMINATE IN FORWARD LAVATORY. REPLAMPED FORWARD LAVATORY EMERGENCY LIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-24-12SDR 2025FA0000786Switch · meltedPASSENGER READING LIGHT CONTROL STARTED SMOKING AFTER IT WAS SELECTED ON, SWITCH PLASTIC CONTINUED TO MELT DURING TAKEOFF ROLL. TAKEOFF WAS ABORTED AIRCRAFT POWER REMOVED AND SMOKE STOPPED IMMEDIATELY.SDR DALA2025112608635Frame · damagedRT SIDE- FRAME C57.3 O/B OF STRINGER P6- BRACKET HAS TOOLING DAMAGE. REPAIRED PER ERA 628248-14 REV ORIG. (1322514)SDR DALA2025112608634Frame · damagedRT SIDE- FRAME C57.3 O/B OF STRINGER P6 HAS TOOLING DAMAGE. REPAIRED PER ERA 628248-14 REV ORIG. (1322513)