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 DALA2026011200259Engine · fireON NR 2 ENGINE START, GROUND ADVISED FIRE & THAT THEY OBSERVED FLAMES COMING FROM THE ENGINE. T/S IAW TSM 72-00-00-810-801-A. NO DISCREPANCIES NOTED. NO 30-DAY HISTORYSDR DALA2026011200258Receptacle · corrodedNR 1 ENGINE PYLON SPIGOT RECPTACLE AND SPIGOT BALL JOINT CORRODED. REPLACED BALL AND RECEPTACLE IAW SRM 54-51-12-300-001 AND AMM 54 -51-41/400. (LP: 1397020)SDR DALA2026011200257Receptacle · corrodedNR 2 ENGINE, PYLON SPIGOT RECEPTACLE AND SPIGOT BALL JOINT CORRODED. REPLACED BALL AND RECEPTACLE IAW SRM 54-51-12-300-001 AND AMM 54 -51-41/400. (LP: 1397017)SDR AALA202601120596Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: OUT LIMIT LT AFT DOOR (8MM) IAW JC 26C71032007 IN NOSE WHEEL WELL. MAINTENANCE REPLACED AFT HINGE FITTINGS ON NLG AFT DOOR LH I.A.W CMM 52-82-32-000-801-B01; CMM 52-82-32-000-803-C01; CMM 52-82-32-400-805-B01, CMM 52-82-32-400-802SDR AALA202601124485Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: OUT LIMIT RT AFT DOOR (6MM) IAW JC 26C71032007 IN NOSE WHEEL WELL. MAINTENANCE REPLACED FWD HINGE FITTINGS ON NLG AFT DOOR RH I.A.W CMM52-82-32-000-801-B01; CMM 52-82-32-000-803-C01; CMM 52-82-32-400-805-B01 AND CMM 52-82-32-400-SDR AALA202601124703Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L2 CABIN DOOR EMERGENCY ASSIST ACCUMULATOR REQUIRE SERVICING. MAINTENANCE SERVICED CYLINDER IAW AMM 52-10-00.SDR AALA202601129005Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: OUT OF LIMITS RT AFT DOOR (6MM) IAW JC 26C71032007 IN NOSE WHEEL WELL. MAINTENANCE REPLACED AFT HINGE FITTINGS ON NLG AFT DOOR RT IAW CMM 52-82-32-000-801-B01; CMM 52-82-32-000-803-C01; CMM 52-82-32-400-805-B01 AND CMM 52-82-32-4SDR AALA202601123077Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: OUT LIMIT LH AFT DOOR (8MM) IAW JC 26C71032007 IN NOSE WHEEL WELL. MAINTENANCE REPLACED FWD HINGE FITTINGS ON NLG AFT DOOR LH I.A.W CMM52-82-32-000-801-B01; CMM 52-82-32-000-803-C01; CMM 52-82-32-400-805-B01, CMM 52-82-32-400-802SDR AALA202601129432Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202601124921Girt Bar · bindingAIRCRAFT WAS GROUNDED: L1 ARM HANDLE FEELS SPONGY. MAINTENANCE FOUND GIRT BAR BINDING UNDER L1 DOOR. READJUSTED L1 SLIDE GIRT BAR ENGAGEMENT WITHOUT DISTURBING THE ESCAPE SLIDE ASSEMBLY INSTALLATION. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED PER AMM 25SDR AALA202601127369Lever · looseAIRCRAFT WAS NOT GROUNDED: ARMING LEVER 3R LOOSE. MAINTENANCE RESECURED ARMING LEVER AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-10-00.SDR AALA202601125823Battery · 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 WITH NO FAULTS NOTED.SDR AALA202601120048Bottle · 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 AALA202601128619Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT FOR EMERGENCY POWER SUPPLY UNIT 10WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38 WITH NO FAULTS NOTED.SDR AALA202601121825Cids · fault messageAIRCRAFT WAS NOT GROUNDED: CIDS MALFUNCTIONING. RED EVACUATION COMMAND INDICATION ON OVERHEAD PANEL, NO HORN AND NO ECAM. MAINTENANCE REPLACED CIDS DIRECTOR #1 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 23-73-34 WITH NO FAULTS NOTED.SDR GTIA2026011239244Unknown · odorFUME EVENT INFLIGHT AT CRUISE FL 360 SOURCE PACK 2--DESCRIPTION OF FUMES / ODOR(S)-DIRTY SOCKS, APPARENT CABIN SOURCE-CABIN AIR SUPPLY VENTS,VISIBLE SMOKE / HAZE-NO,MEDICAL ATTENTION REQUIRED NONESDR IPXA2026011253273Anti-Ice Valve · faulted**ATB** DURING CLIMB R ENG ANTI ICE DISPLAYED RUN QRH CHECKLIST. CONSULTED WITH FLT CONTROL AND RETURNED TO MIA DUE TO WX IN SDF. REMOVED AND REPLACED RH ENG INLET TAI VALVE AMM 30-21-03. OPS CHECKS NORMAL. NO LEAKSSDR FDEA202601110022Apu · leakingPRIOR TO PUSHBACK, WITH ALL DOORS CLOSED EXCEPT CREW ENTRANCE DOOR, RECEIVED AN ECAM ALERT FOR MAIN DECK CARGO SMOKE DETECTED MID & EXPERIENCED SMOKE IN COCKPIT FROM GASPERS. SMOKE ON SET RAPID & HIGHLY CONCENTRATED. SMOKE CLEARLY VISIBLE IN COCKPIT, APSDR QXEA2026011200009Light · inoperativeFLIGHT 2224. PHOTO ILLLUMINESCENT LIGHTING STRIP INOP BETWEEN SEATS 1A-2A. REMOVED FROM SERVICE. REPLACED PHOTOLUMINESCENT INDICATOR STRIP & LIGHT BETWEEN 1A-2A SEATS IAW E175 AMM 33-50-21-000/400-801-A. OPS TEST GOOD. RETURNED TO SERVICE.SDR SCNA20260129022Engine · no discrepancyMARSHALER SAW SPARKS COMING FROM NR 1 ENGINE. SHUTDOWN. MECHANIC SAYS IT WAS JUST SAND.SDR SCNA20260129021Window · overtempR3 WINDOW VERY HOT TO THE TOUCH ( ELECTRICALLY HEATED WINDSHIELDS; NO. 3 WINDOW HEAT SYSTEM(S) . REF GMM/MTI MDDR#136262 WINDOW OVERHEAT OVER REF AMM 30-41-00 REF LOG PAGE 829340 ITEM #1 R/H #3 WINDOW R&R THIUS CLEARS MEL 30-11-4 MDDR#136261SDR IXXA20260111002Bracket · corrodedEDIT (NEW CONTROL NUMBER) FROM DUPLIACATE CONTROL NUMBER IXXA20260111001 - FOUND CORROSION ON THE BLOCK SUPPORT TUBING IN THE OUTBOARD UPPER AREA OF THE LEFT WHEEL WELL OUTBOARD OF THE ANTISKID VALVES.SDR IXX2026F00000Bracket · corrodedFOUND CORROSION ON THE BLOCK SUPPORT TUBING IN THE OUTBOARD UPPER AREA OF THE LEFT WHEEL WELL OUTBOARD OF THE ANTISKID VALVES.SDR QMLA2026011120002Unknown · odorMED CREW REPORTS A FUEL ODOR WHILE IN FLIGHT. PERFORMED VISUAL INSPECTION OF ALL VIABLE FUEL LINES, FUEL SUMPS, FUEL NOZZLE, AND FUEL FILTERS, IAW AMM DMC 407-A-24-00-00-130A-A. NO LEAKS NOTED AT THIS TIME.SDR DALA2026011100250Battery Pack · inoperativeON SERVICE CHECK, FOUND 3 EMERGENCY AISLE LIGHTS INOP. REPLACED EMERGENCY EXIT LIGHT BATTERY PACK M2335 REF AMM 33-51. (LP 7994582)SDR JR2R20260111219Doubler · corrodedFWD CARGO COMPARTMENT BETWEEN FR 20 - 21, S25 - 26R ANTENNA DOUBLER HAS CORROSION AROUND FASTENERS. REPLACED IAW SRM.SDR JR2R20260111271Web · corrodedFWD WET AREA RT SILL WEB AFT OF R1 DOOR BETWEEN FR 17 - 19 IS CORRODED. REPLACED IAW SRM.SDR JR2R20260111261Shear Tie · corrodedAFT CARGO AT FR89 FWD OF WASTE TANK SHEAR TIE IS CORRODED. REPLACED PER SRM.SDR JR2R20260111229Shear Tie · corrodedFR83 SHEAR TIE BETWEEN S27 - 28R IS CORRODED. REPLACED PER SRM.SDR JR2R20260111264Doubler · corrodedFWD WET AREA FWD OF R1 DOOR FR 12 - 14 FLOOR DOUBLER CORRODED. REPLACED PER SRM.SDR MAS2026F00000Seal Rest · corrodedFWD CARGO DOOR LOWER AFT SEAL REST IS CORRODED. REPLACED PER SRM.SDR MAS2026F00001Seal Rest · corrodedFWD CARGO DOOR LOWER MIDDLE SEAL REST IS CORRODED. REPLACED IAW SRM.SDR JR2R20260111011Seal Rest · corrodedFWD CARGO DOOR LOWER FWD SEAL REST IS CORRODED. REPLACED IAW SRM.SDR JR2R20260111270Floor Support · corrodedFWD WET AREA AFT SIDE OF L1 DOOR FLOOR STRUCTURE AT FR19 INTERCOSTAL AT LBL36 IS CORRODED. REPAIRED PER ETD.SDR JR2R20260111267Floor Support · corrodedFWD WET AREA LBL 10 HAS CORROSION FROM FR 12 - 20 IN MUTIPLE SPOTS. REPAIRED IAW SRM.SDR JR2R20260111065Skin · gougedFUSELAGE SKIN HAS GOUGE BETWEEN FR 85 - 86, S20 - 21L. REPAIRED PER ETD.SDR JGVR20260111001Hinge Bracket · corrodedREMOVED THE VERTICAL STABILIZER UPPER RUDDER HINGE LOWER BRACKET DUE TO CORROSION AND REPLACED WITH NEW TEXTRON P/N 6931050-59.SDR JR2R20260111012Doubler · corrodedDOUBLER ON TOP OF FLOORBEAM 84 AND RBL12 CORRODED. REPLACEDSDR JR2R20260111013Seat Track · corrodedSEAT TRACK AT RBL11 CORRODED ON THE SIDE AT FR84. REPAIR.SDR CALA2026092319695Skin · crackedFRAME 35, STR 30L, HOLE NR 2 HAD A CRACK INDICATION IN FWD & AFT SKINS LAYERS, 100 PERCENT S.H AT 4 AND 5 OCLOCK POSITION. ACCOMPLISHED AN INTERIM REPAIR IAW ECRA 5331-03189, PART 1.1.SDR REXA2026052700698Floor Support · crackedCRACKED FLOOR SUPPORT BTW FS=295.00 TO 319.70 AND RBL 27 AT PASSENGER FLOOR STRUCTURE FLOOR SUPPORT BTW FS=295.00 TO 319.70 AND RBL 27 AT PASSENGER FLOOR STRUCTURE WAS REPLACED PER CRJ900 SRM 51-42-13-001-001-A01 & SRM 51-42-06-001-001-A01SDR REXA2026052700695Fitting · corrodedCORROSION FLOOR FITTING ON ACCESS 107 (1EA) AISLE SIDE AND ACCESS 109 (1EA) ON GALLEY 1. SUMMARY OF NRC 00251: FLOOR FITTING (1EA) AND DOUBLER FLOOR FITTING (1EA) AISLE SIDE ON ACCESS 107 AND FLOOR FITTING (1EA) ON ACCESS 109 AT GALLEY 1 WERE REPLACED PER SAFRSDR REXA2026052700693Fitting · corrodedCORROSION FLOOR FITTING ON ACCESS 107 (1EA) AISLE SIDE AND ACCESS 109 (1EA) ON GALLEY 1. SUMMARY OF NRC 00251: FLOOR FITTING (1EA) AND DOUBLER FLOOR FITTING (1EA) AISLE SIDE ON ACCESS 107 AND FLOOR FITTING (1EA) ON ACCESS 109 AT GALLEY 1 WERE REPLACED PER SAFRSDR REXA2026052700679Door · crackedCRACKED TOP EDGE STRUCTURE OF LEFT FORWARD OVERWING EMERGENCY EXIT DOOR. TOP EDGE STRUCTURE OF LEFT FORWARD OVERWING EMERGENCY EXIT DOOR WAS REPAIRED PER REO 670-52-21-103 REV. --SDR SWIA2026011075991Drag Angle · crackedLT VERTICAL STAB AFT DRAG ANGLE SHOWS EVIDENCE OF CRACKING. REMOVED AND REPLACED L/H VERTICAL STAB AFT DRAG ANGLE WITH NEW DRAG ANGLE IAW CRJ 700 SRM 51-42-13-001-001-A01.SDR SWIA2026011075984Drag Angle · crackedRH VERTICAL STAB AFT DRAG ANGLE SHOWS EVIDENCE OF CRACKING. REMOVED AND REPLACED RT VERTICAL STAB AFT DRAG ANGLE WITH NEW DRAG ANGLE P/N AV670-21186-004 IAW CRJ 700 SRM 51-42-21-001-001-A01SDR SWIA2026011075649Skin · chafedFUSELAGE SKIN BELOW FORWARD POTABLE WATER SERVICE DOOR - SKIN CHAFED. REPAIRED FUSELAGE SKIN IAW MHIRJ REO 670-53-21-2790 REV --.SDR SWIA2026040375648Skin · corrodedFUSELAGE SKIN BELOW TCAS OMNIDIRECTIONAL ANTENNA - CORRODED. CUT AWAY DAMAGE FROM FUSELAGE SKIN, FABRICATED DOUBLER AND INSTALLED IAW REO 670-53-21-2794 REV -- .SDR SWIA2026040375641Skin · gougedSKIN BELOW FORWARD DRAIN MAST GOUGED IN MULTIPLE LOCATIONS. BLENDED OUT GOUGES IAW 51-12-00-001-001-A01. PERFORMED UT THICKNESS MEASUREMENTS OF REWORKED AREAS IAW NDTM, PART 1, 51-20-004-270-A01, REV-37. FOUND LOWEST REMAINING THICKNESS OF .057 OR GREATER. SDR IPXA2026033045598Adapter · corrodedMAIN CABIN FLOOR STRUCTURE, FR 30 Y0 CLS ADAPTER HAS CORROSION. RESTORED SURFACE PROTECTION IAW SRM 51-21-10 & SRM 51-75-10-201. MAJOR REPAIR.