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 AALA202510036276Power Supply · no testAIRCRAFT WAS NOT GROUNDED: WHILE PERFORMING PS CHECK FOUND EPSU SYS TEST 11WL BATTERY FAULT. MAINTENANCE REPLACE 11WL ESPU BATTERY IAW AMM 33-51-38.SDR DALA2025100307227Seal · leakingLOUD SQUEL, STILL HEARD AROUND EXIT ROW RIGHT SIDE. REPLACED HATCH SEAL PER A319 AMM 52-21. (6999116).SDR 7C7A2025100300042Stop Fitting · gougedL4 DOOR FWD FRAME UPPER STOP FITTING IS GOUGED.SDR VNAA202510020003Helicoil · missingRH WING JACK POINT MISSING HELI-COIL AND NYLON PLUG. CORRECTIVE ACTION: COMPLIED WITH MHIRJ REO 670-57-22-155, REV -- DATED 2025-09-22 - TEMPORARY DISPOSITION FOR REMAINING THREADS AFTER REAMING RH WING JACKING FITTING BORE (DEVIATION TO GENERIC REO 670-57-22-SDR VNAA202510020002Bracket · brokenLH SLAT TRACK 2-3 LOWER BRACKET IS BROKEN. CORRECTIVE ACTION: REMOVED AND REPLACED BRACKET ASSEMBLY IAW CRJ-700 AMM 20-21-00-910-801-A01. CC670-12065-1SDR VNAA202510020001Skin · chafedR/H AILERON UPPER LEADING EDGE IS CHAFED IN SEVERAL AREAS. CORRECTIVE ACTION: PERFORMED REPAIR BY COMPLYING WITH MHIRJ REO 670-57-61-194 REV -C DATED 2019-01-07. CC670-1305-1,-2,-3,-4SDR JR2R20251003280Floorbeam · corrodedAFT WET AREA: AFTER REMOVING RBL10 FLOOR BEAM FOUND DEEP PITTING CORROSION ON FR87 CROSSBEAM. REPAIRED PER ETD.SDR JR2R20251003165Skin · dentedEXTERNAL SKIN HAS A DENT BETWEEN FR19-FR20 AT STR17R-STR18R. REPAIRED PER ETD.SDR JR2R20251003187Skin · scratchedHORIZONTAL STAB L/E PANEL 331AL HAS SCRATCH MARKS. REPAIRED PER ETD.SDR DALA2025100307201Actuator · leakingSHIP 3952 -HYD/DE- DECLARED EMERGENCY DUE TO LOSS OF HYDRAULIC SYSTEM A. CORRECTIVE ACTION: REPLACED LT WING O/B GROUND SPOILER ACTUATOR. OPS AND LEAK CHECK GOOD.SDR DALA2025100307199Frame · corroded(LOG 1231613) CORROSION ON FRAME OF STA 907 BTW STGR 24LH TO STGR 23LH AT AFT CARGO COMPARTMENT. FRAME OF STA 907 BTW STGR 24LH TO STGR 23LH AT AFT CARGO COMPARTMENT WAS REPAIRED PER ER/A 629014-1 REV ORIGINAL. SECTION I: REPAIR INSTRUCTIONS AND PRI 629014-1 RSDR 2025FA0000678Frame · corrodedDUE TO PREVIOUS REPAIR ON FRAME 11, REPAIR INTERFERES WITH A BRACKET FOR THE L5 STC. GRID MAP AND SUBMIT DATA TO AQRD FOR REPAIR. AQRD RFTS ON THE FRAME 11 AFT SIDE. FABRICATED AND INSTALLED NEW REPAIR DOUBLER AND REINSTALLED REPAIR ANGLE ON FRAME 11 FWD AND ASDR FDEA202510031878Sensor · illuminatedLE SLAT ASYM EICAS, LEADING EDGE LIGHT. ON APPROACH AT 160 KTS SELECTING FLAPS 30 FOR LANDING. G/A TO COMPLETE QRH. LANDED RWY 36C IAW QRH. TAXI IN FLAPS DOWN. EMERGENCY DECLARED. INSTALLED SLAT PROX SENSOR, ALL OPS AND RIG CHECKS ARE GOOD. REF MM 27-88SDR FDEA202510031877Warning Light · illuminatedDURING GEAR RETRACTION OUT OF ORD, GOT AMBER L/G DOORS NOT CLOSED ECAM. BOTH GEAR PANELS SHOWED NOSE GEAR DOOR AMBER DOOR LIGHT ON. COMPLETED ECAM AND QRH. WE FLEW TO IND AT 260 KIAS. AMBER DOOR LIGHT REMAINED ON ENTIRE FLIGHT UNTIL GEAR EXTENSION. JACKESDR CALA2025100309580Slide · no discrepancyDOOR 1R SLIDE FLAP DRAGGING FOUND GIRT MATERIAL TO BE WITHIN LIMITS CONTAINED WITH AMM 25-66-01-400-801.OPERATION FOUND NORMAL WHEN ENGAGING INTO FLOOR FITTINGS AND STOWING IN STOW BRACKETS.SDR REXA2026052800839Web · crackedCRACK ON ELECTRICAL BAY FLOOR WEB RIGHT SIDE (BELOW ADG SUPPORT DOUBLER) FS193.00 REPAIR ON ELECTRICAL BAY FLOOR WEB RIGHT SIDE (BELOW ADG SUPPORT DOUBLER) FS193.00 WAS PERFORMED PER CRJ900 SRM 53-11-43-201-001-A01SDR REXA2026052800828Floor Support · crackedCRACK ON FLOOR SUPPORT RBL 12.0 BTW FS 221.73 TO FS 229.00 AT FWD FUSELAGE INTERNAL STRUCTURE (FLIGHT COMPARTMENT FLOOR STRUCTURE BELOW WL79.50). CRACK ON FLOOR SUPPORT RBL 12.0 BTW FS 221.73 TO FS 229.00 AT FWD FUSELAGE INTERNAL STRUCTURE (FLIGHT COMPARTMENTSDR REXA2026052800813Support · crackedCRACK ON JB6 SUPPORT AT FWD EQUIPMENT COMPARTMENT. JB6 SUPPORT AT FWD EQUIPMENT COMPARTMENT/JUNCTION BOX 6 (JB-6) WERE REMOVED AND INSTALLED PER CRJ 900 SRM 51-42-06-001-001-A01, AMM 24-04-15-000-801-A01 AND AMM 24-04-15-400-801-A01. JB6 SUPPORT (P/N: CC670-5SDR SWI2025F01854Tie Down · no discrepancyREMOVED AFT CARGO TIE DOWN SUPPORT ANGLES BETWEEN FS605 - FS621 (ITEMS 9 & 10 SRM 53-61-43) TO FOM. INSTALLED AFT CARGO TIE DOWN SUPPORT ANGLES BETWEEN FS605 - FS621 (ITEMS 9 & 10 SRM 53-61-43) WITH REFERENCE TO SRM 51-42-06 AND SRM 51-42-21. COMPLIED WITH SDR SWI2025F01853Tie Down · no discrepancyREMOVED CENTER CARGO TIE DOWN SUPPORT ANGLES BETWEEN FS589 - FS605 (ITEMS 6 & 8 SRM 53-61-43) TO FOM INSTALLED CENTER CARGO TIE DOWN SUPPORT ANGLES BETWEEN FS589 - FS605 (ITEMS 6 & 8 SRM 53-61-43) WITH REFERENCE TO SRM 51-42-06 AND SRM 51-42-21. COMPLIED WITHSDR SWIA20251222002Drain Valve · corrodedLH WING WATER DRAIN VALVE COVER FOOTPRINT ADJACENT TO STANDBY BOOST PUMP HAS CORROSION ON WING PLANK. (C-CHECK RO 12/19/2025)PERFORMED REPAIR FOR CORROSION DAMAGE TO LHS LOWER WING PLANK AROUND ELECTRIC BOOST PUMP WATER DRAIN CUTOUT AT BL5.00 BTWN STR 5 - STRSDR ABXA2025122313Escape Reel · unwanted deployON LANDING, EMERGENCY ESCAPE IN SUPERNUMERARY SELF DEPLOYED ON LANDING. MAINTENANCE REMOVED AND REPLACED 4 EACH DECENT DEVICES IN SUPERNUMERARY IAW B767 AMM 25-61-03. THIS CLEARS DI 68427, PLACARD REMOVED. AIRCRAFT RETURNED TO SERVICE. ALL 4 P/N'S REMOVED:SDR SWIA202512011002Hinge · chafedAFTER REMOVAL OF THE PAX DOOR NOTED THE PAX DOOR HINGE (PAX DOOR SIDE) TO HAVE CHAFES ON ALL LUG LANDINGS (C-CHECK RO 11/30/2025)PERFORMED PASSENGER DOOR HINGE (PAX DOOR SIDE) REPAIR PER CRJ700 SRM 52-11-01-201-007-A01 STEP 5.D. TYPE IV, ALL STEPS COMPLIED WSDR 2025FA0000776Pump · defectiveDURING AIRCRAFT INSPECTION, THE LANDING GEAR HYDRAULIC PUMP WOULD INTERMITTENTLY FAIL DURING THE FUNCTIONAL TEST.SDR AALA202511174602Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR AALA202511176520Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23L. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR AALA202511143211Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #6 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511145292Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511146056Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #2 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511149445Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #5 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511145057Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #4 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511146732Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #1 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511137693Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT RIGHT PASSENGER, CREW DOOR CUTOUT LOWER SILL AT FR 68 AND S23R. REPLACED LOWER SILL PER SRM 51-42-11.SDR AALA202511135553Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LEFT PASSENGER, CREW DOOR CUTOUT LOWER SILL AT FR 66 AND S23L. REPLACED LOWER SILL PER SRM 51-42-11.SDR AALA202511121943Cleat · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT CLEAT AT FR 32, AT S40R. REPLACED CLEAT PER SRM 51-72-11.SDR SWAA2025110720572Housing · damagedAFT SERVICE DOOR HEADER PANEL EXIT LIGHT HOUSING IS DAMAGED AND WILL NOT KEEP EXIT LENS IN PLACE. REPLACED EXIT LIGHT HOUSING IAW AMM 33-51-01-960-802.SDR AALA202511069514Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #1 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511067821Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #4 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511069118Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #6 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511068495Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511061949Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #5 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511069597Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #2 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR SWAA2025110520670Support · corrodedCORROSION LOWER SILL LOCATED BTW BS 794.3 TO BS 847 RBL 22 WL 156.1. REMOVED AND REPLACED LOWER SILL AND FASTENERS LOCATED BTW BSTA 794.3 TO BSTA 847. RBL 22 AND WL 156.1. AT AFT CARGO COMPARTMENT. IAW SRM 51-10-02 PARAGRAPH 9. SRM 51-40-02. AND DWG 146A8340SDR SWAA2025110520667Skin · corrodedCORROSION INTERNAL SKIN LOCATED BTW STA 727D TO STA 727E BTW STR 27L TO STR 27R AND WL 148.5 AT AFT CARGO. GAINED ACCESS LOCATED BTW STA 727D TO STA 727E BTW STR 27L TO STR 27R AND WL 148.5 THE CORROSION FOUND ON VHF COMMUNICATION ANTENNA #2 ONLY AT LOWER FUSSDR SWAA2025110520561Tie Clip · crackedCRACK ON TIE CLIP LOCATED BS 500I AT LEVE STR 26R AT FWD CARGO COMPARTMENT. REPLACED TIE CLIP AND FASTENERS LOCATED BS 500I ON STRINGER 26R AT FWD CARGO COMPARTMENT IAW SRM 51-40-02 AND DWG 143A1234 SHEET 14 REV A.SDR SWAA2025110520562Support Angle · corrodedCORROSION ON SUPPORT ANGLE LOCATED BS 500I BTW STR26L TO STR 26R AT FWD CARGO. PERFORMED CLEAN ON AREA AND APPLIED PAINT SUPPORT ANGLE LOCATED BS 500I BTW STR26L TO STR 26R AT FWD CARGO COMPARTMENT IAW SOPM 20-30-03 AMM 51-21-99-300-801.SDR SWAA2025110520676Plate · corrodedCORROSION PLATE BTW STA 827 TO STA 847, STR 25R TO STR 26R WL 156. REPLACED THE PLATE IAW SRM 51-10-02; SRM 51-40-02 AND DWG 146A8340 SHEET 28 REV -.SDR SWAA2025110520672Plate · corrodedCORRODED PLATE BTW STA 794.3 TO STA 807 BTW STR 25R TO STR 26R WL 156. REPLACED PLATE IAW SRM 51-10-02; SRM 51-40-02 AND DWG 146A8340 SHEET 28 REV -.SDR SWAA2025110520567Web · crackedCRACKED WEB, BS 500 - 500A, STRINGER 26L. REPLACED THE WEB IAW SRM 51-10-02-0G-0, SRM 51-40-02-0G-0, & DWG 143A7505, SHEET 124, SHEET 125, REV -.SDR SWAA2025110520665Support · corrodedCORRODED SUPPORT ZEE, BS 727I - 807, LBL 21, WL 156.1. REPLACED SUPPORT ZEE IAW SRM-53-00-53-2R-5, REPAIR 5, SRM-51-40-02, DWG:146A7500, SHEET 233, REV-, & DWG 146A7500, SHEET 236, REV-.