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 YENA2025072500768Apu · odorFLT#66, ABQ-JFK. "FUMES EVENT DURING APPROACH AND AT SHUT DOWN. ( APU SYSTEM )" (SUPPLEMENTAL INFORMATION TO FOLLOW)SDR YENA2025072500767Control Unit · failedFLT#73, JFK-EDI. (ETOPS) FUEL CLASS II MX MESSAGE, CLASS II MAINTENANCE MESSAGES DISPLAYED ON ECAM STATUS PAGE OF ECAM SYSTEM DISPLAY 1, FAULTS INDICATED BY FUEL, REMOVED AND REPLACED FLSCU 7QJ IAW AMM 28-46-34. OPS CHK OK. MX-4 UPDATED. PLACARD REMOVED. MSDR IPXA2025072515035A/C Pack · odorOILY SMELL WHEN RIGHT PACK IS ON, SOUR SMELL, WET DOG SMELL. ++RAN RIGHT PACK ON APU, NO OIL SMELL FOUND, SMELLED SOUR ODOR ONLY. PERFORMED REMOVAL OF OIL CONTAMINATION FROM THE AIR CONDITIONING AND PNEUMATIC SYSTEMS IAW AMM TASK 21-00-21-102-030 SUBTASK 21-00SDR AALA202507258975Light · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY ESCAPE PATH LIGHTING ASSEMBLY MISSING AT SEAT 35 ABC. INSTALLED EMERGENCY ESCAPE PATH LIGHTING ASSEMBLY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER CMM 25-21-61.SDR N3XR202507250941Hinge · crackedDURING A ROUTINE INSPECTION, THE LOWER RUDDER HINGE FITTING WAS FOUND CRACKED ON THE LOWER PORTION AROUND EACH CORNER BETWEEN RIVET HOLESSDR N3XR202507250821Hinge · crackedDURING A ROUTINE INSPECTION, THE LOWER RUDDER HINGE FITTING WAS FOUND CRACKED ON THE LOWER PORTION AROUND EACH CORNER BETWEEN RIVET HOLESSDR N3XR202507250811Hinge · crackedDURING A ROUTINE INSPECTION, THE LOWER RUDDER HINGE FITTING WAS FOUND CRACKED ON THE LOWER PORTION AROUND EACH CORNER BETWEEN RIVET HOLESSDR YENA2025072500765Valve · failedFLT#2260, MAD-BOS. (ETOPS) "FAN AIR VALVE BODY HAS BEEN BROKEN CONNECTING ROD TO ACTUATOR ON #1 ENG; REMOVED AND REPLACED #1 ENG FAN AIR VALVE BODY IAW AMM 36-11-54. OPS CHK AND GROUND VERIFICATION OK."SDR 2025FA0000522Trunnion · crackedFCP RUDDER PEDAL TRUNNION, DRAWING 5ST31, IS CRACKING AROUND THE WELDS IN VARIOUS LOCATIONS ON THE PART. MAINTAIN 18 OF THE DG1000S AIRCRAFT IN A TRAINING ENVIRONMENT, & ALMOST ALL ARE EXPERIENCING CRACKS TO SOME DEGREE. LOSS OF RUDDER CONTROL CAN OCCUR IF SDR QR9R2025072500002Fitting · brokenDURING A HOVER TAXI, LEFT SIDE DOOR STRUT BRACKET BROKE. REPLACED BRACKET FITTING IAW SRM 51-00-00, 8-2.SDR QR9R2025072500001Display · failedVEMD LANE 1 FAILED DURING HOVER TAXI. REMOVED AND REPLACED VEMD V2006 NVG; MOC SUCCESSFULLY COMPLETED IAW AMM 31-60-00, 4-2.SDR 2025FA0000521Brake Assy · out of limitsW.O. 9267, JULY 22, 2025. DURING THE INBOUND INSPECTION THE BRAKE ASSEMBLY LEFT OUTBOARD PN: GAC1159SCL5045 SN:5034JT AND BRAKE ASSEMBLY LEFT INBOARD PN: GAC1159SCL504-5 SN: 5033JT WERE FOUND WITH THE END OF BRAKE WEAR INDICATOR IS BELOW BRAKE HOUSING. I.A.W.SDR DALA2025072505592Door Frame · misinstalledSHIP 3360 FR 64 L2-R2 HAS INCORRECT FASTENERS. CORRECTIVE ACTION: REPAIRED PER ERA 627465-14 REV ORIGINAL. (1104867)SDR DALA2025072505591Door Frame · misinstalledSHIP 3360 FR 63 - R2 HAS INCORRECT FASTENERS. CORRECTIVE ACTION: REPAIRED PER ERA 627465-14 REV ORIGINAL. (1104860)SDR DALA2025072505590Bracket · misinstalledSHIP 3360 FR 64 BRACKET BETWEEN R2-3 HAS INCORRECT FASTENERS. CORRECTIVE ACTION: REPAIRED PER ERA 627465-14 REV ORIGINAL. (1104853)SDR DALA2025072505589Bracket · misinstalledSHIP 3360 FR 63 BRACKET BETWEEN R2-3 HAS INCORRECT FASTENERS. CORRECTIVE ACTION: REPAIRED PER ERA 627465-14 REV ORIGINAL. (1104844)SDR DALA2025072505588Bracket · misinstalledSHIP 3360 FR 64 BRACKET BETWEEN L2-3 HAS INCORRECT FASTENERS. CORRECTIVE ACTION: REPAIRED PER ERA 627465-14 REV ORIGINAL. (1104832)SDR DALA2025072505587Bracket · misinstalledSHIP 3360 FR 63 BRACKET BETWEEN L2-3 HAS INCORRECT FASTENERS. CORRECTIVE ACTION: REPAIRED PER ERA 627465-14 REV ORIGINAL. (1104752)SDR 2025FA0000520Bolt · looseDURING INSPECTION FOUND 2 OF 4 MOUNT BOLTS ON #2 PCM LOOSE. UPON REMOVAL OF PCM FOUND CRACK IN FWD DECK AT FWD INBOARD MOUNT INSERT. REQUIRES REPAIR IAW AW139 AMP. THIS IS 3RD OR 4TH AIRCRAFT WE HAVE FOUND IN THE LAST 2 YEARS WITH A SIMILAR CONDITION.SDR FDEA202507251320Skin · crackedL.E. SLAT NO 1 INB MAIN TRACK AREA, INTERNAL SKIN WITH CRACK. FABRICATED, LOCATED AND DRILLED REPAIR PARTS SLAT #1 INB MAIN TRACK AREA, REMOVED SLAT #1 IAW B 757 AMM 27-81-02-4, INSTALLED REPAIR PARTS IAW B 757 SRM 57-43-01-2R FIG 201 REP 4, RE-INSTALLED #SDR FDEA202507251319Skin · bentL4 DOOR FWD / LWR CORNER SKIN BENT. REPAIRED L4 DOOR FWD, LWR CORNER SKIN, INSTALLED DOUBLER, FILLER IAW SRM 52-10-01-2R AND EA F - 5210-T0384238 P1. THIS IS MAJOR REPAIR.SDR FDEA202507251318Floorbeam · crackedHIGH FREQUENCY EDDY CURRENT INSPECTION ON RIGHT HAND OVERWING FLOOR BEAM UPPER FLANGE AT STATION 1275, X=103 FOUND CRACK INDICATION APPROXIMATELY 0.1 INCH. HIGH FREQUENCY EDDY CURRENT INSPECTION ON RIGHT HAND OVERWING FLOOR BEAM UPPER FLANGE AT STATION 127SDR FDEA202507251317Trunnion · crackedDURING HIGH FREQUENCY EDDY CURRENT INSPECTION ON NOSE LANDING GEAR LEFT HAND TRUNNION FITTING AT STATION 595 EXISTING REPAIR SLOT OUT AREA FOUND LONGERON 49 LEFT HAND SIDE WITH CRACK APPROXIMATELY 0.125". (REFER TO SPECIAL/NONROUTINE MAINTENANCE FORM #N0SDR YENA2025072500763Support · corrodedDURING HEAVY MAINTENANCE: CORROSION LOWER SILL LOCATED FR68 STR 23L AT AFT GALLEY AREA (CPCP FIN DINGS); (RESOLVED ON W/O: 1369191 TASKCARD: NR-00007) REF AEROMAN WO # 2025-184/1 NR # 2025-387274 PERFORMED PERMANENT REPAIR LOC. ON LOWER SILL FR 67 PLUS 20 INCSDR YENA2025072500762Support · corrodedDURING HEAVY MAINTENANCE: CORROSION LOWER SILL LOCATED FR68 AND STR23R AT AFT GALLEY AREA (CPCP FINDING); (RESOLVED ON W/O: 1369191 TASKCARD: NR-00011) REF AEROMAN WO #2025-184/1 NR # 2025-387276 PERFORMED PERMANENT REPAIR LOC. ON LOWER SILL FR67 PLUS 15.620 SDR YENA2025072500761Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON FRAME 16 RH SIDE IN UPPER DOUBLE JOGGLE AREA OPEN FASTENER HOLE 5, CRACK DIRECTION AT 6 OCLOCK, D=0.125 INCH, CONF IRM INDICATION USING BOROSCOPE VIEW AS PER NTM 51-90-00;(RESOLVED ON W/O: 1396919 TASKCARD: NSDR YENA2025072500760Power Supply · no testDURING HEAVY MAINTENANCE: REF AEROMAN WO# 2025 189/1. NR# 2025-397167. EPSU 13WL ( EMERGENCY POWER SUPPLY UNIT ) IN PAX CABIN FAILS OPERATIONAL TEST; (RESOLVED ON W/O: 1396919 TASKCARD: NR-00043) REF AEROMAN WO# 2025 189/1. NR# 2025-397167. REMOVED AND REPLACESDR YENA2025072500759Power Supply · no testDURING HEAVY MAINTENANCE: REF AEROMAN WO# 2025 189/1. NR# 2025-397167. EPSU 13WL ( EMERGENCY POWER SUPPLY UNIT ) IN PAX CABIN FAILS OPERATIONAL TEST; (RESOLVED ON W/O: 1396919 TASKCARD: NR-00043) REF AEROMAN WO# 2025 189/1. NR# 2025-397167. REMOVED AND REPLACESDR SCNA20250725272Light · looseROW 9-12 LEFT SIDE EMERGENCY PATH LIGHTING HAS BECOME LOOSE AND NEEDS TO BE REATTACHED. RESECURED EMERGENCY PATH STRIP IAW AMM 25-27-31. OK FOR SERVICE.SDR SCNA20250725271Girt Bar · looseBOARDING DOOR GIRT BARS ARE LOOSE AND THE APRON IS TOO LONG ON THE RIGHT - TIGHTENED CLIP AND SECURED L1 DOOR GIRT BAR IAW AMM 25-66-01. GIRT BAR IS SECURED TO DOOR. OK FOR SERVICE.SDR SCNA202507252271Girt Bar · looseBOARDING DOOR GIRT BARS ARE LOOSE AND THE APRON IS TOO LONG ON THE RIGHT. - RESOLUTION: TIGHTENED CLIP AND SECURED L1 DOOR GIRT BAR IAW AMM 25-66-01. GIRT BAR IS SECURED TO DOOR. OK FOR SERVICE.SDR CALA2025072506909Battery Pack · no testEMERGENCY LIGHTS OPERATIONAL CHECK EMERGENCY LIGHTS OPERATIONAL CHECK - EMERGENCY LIGHTS INOP FROM ROW 22ABC TO THE AFT OF A/C. REMOVED AND REPLACED BATTERY PACK FROM POWER SUPPLY AT LOCATION M1670 IN REF W AMM 33-51-06-960-805 OPS CHECK GOOD.SDR CALA2025072506908Light · looseTEST SHOW EPSU INT LOAD AFT L MSG ---PROCEDURE - PERFORMED VISUAL CHECK OF THE CABIN EMERGENCY-LIGHT SYSTEM REF AMM 33-51-00-710-009-A. FOUND L2 AND R2 OVER DOOR LIGHTS INTERMITTENT. LIGHT IS NORMALLY OFF BUT ILLUMINATES AND STAYS ON AFTER LIGHT PRESSURE IS ASDR CALA2025072506907Light · looseTEST SHOWS EPSU INT LOAD EMER R MSG---PROCEDURE - PERFORMED VISUAL CHECK OF THE CABIN EMERGENCY-LIGHT SYSTEM REF AMM 33-51-00-710-009-A. FOUND OVERWING EXIT-FWD AISLE LIGHT INTERMITTENT. LIGHT IS NORMALLY OFF BUT ILLUMINATES AND STAYS ON AFTER LIGHT PRESSURE SDR JR2R20250725840Hinge Fitting · gougedLH ELEVATOR #3 HINGE FITTING DAMAGED. REPAIREDSDR HK0Y2025072500519Shaft · corrodedHAESL REPORTED THE CORROSION PITTING FOUND ON THE IPC REAR STUB SHAFT OF ESN 51224 WERE TOO EXTENSIVE AND NO FEASIBLE REPAIR TO SALVAGE THE PART TO SERVICEABLE. THE PART WAS REJECTED BY RR. IPC REAR STUB SHAFT (CSN: 4198 SDC) IS RETIRED BEFORE ITS DECLARED LIFSDR AALA202512157902Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: WHILE ACCOMPLISHING MOD OF THE RUDDER HINGE LINE PER EO 5520Y001 , SEVERAL END FITTING ATTACHMENT HOLES ON THE BR3 HINGE ARM WERE FOUND WITH HOLE DAMAGE. (REPLACEMENT HINGE ARM REQUIRED BY EA 344724). MAINTENANCE ACCOMPLISHED FINASDR AALA202512153926Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: WHILE ACCOMPLISHING MOD OF THE RUDDER HINGE LINE PER EO 5520Y001 , SEVERAL END FITTING ATTACHMENT HOLES ON THE BR3 HINGE ARM WERE FOUND WITH HOLE DAMAGE. (REPLACEMENT HINGE END FITTING REQUIRED BY EA 344724). MAINTENANCE ACCOMPLISSDR SWIA20251110724Door Frame · corrodedRIGHT DOOR POST AT FS280 HAS SIGNS OF CORROSION AT FLOOR LEVEL (C-CHECK RO 11/07/2025)REPAIRED DAMAGE TO RH DOOR POST AT FS280 FLOOR LEVEL IAW CRJ900 SRM 53-11-10, 51-24-21, 51-40-11, 51-21-11, 51-25-06, 51-25-16, 51-42-13. NDT PERFORMEDSDR SWI2025F01532Bulkhead Web · corrodedLEFT BS280 BULKHEAD WEB AT LBL9 HAS SIGNS OF CORROSION AT FLOOR LEVEL (C-CHECK RO 11/07/2025)PERFORMED REPAIR AT L/H 280 BULK HAED WEB AT LBL9 FLOOR LEVEL IAW CRJ 900 AMM 20-70-00 SRM 51-42-06, 51-42-13, 51-42-20, BOMBARDIER REO 670-53-11-594 REV -A DATE 2015SDR AALA202511053381Hinge Fitting · gougedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND MAIN LANDING GEAR FORWARD HINGE FITTING FORWARD LUG FORWARD FACE GOUGED AT KEEL BEAM RIB W10 AND S41R. REPLACED HINGE FITTING PER EA 368507.SDR JJBA20251024080Shear Tie · crackedCRACKED SHEAR CLIP AT FRAME 22A STRINGER 16R. REMOVED AND REPLACED CRACKED SHEAR CLIP AT FRAME 22A STRINGER 16RSDR VNAA20251015008Block · damagedOUTSIDE TOLERANCE HOLES OF STEADY FITTING PER STEP #11.4. STEADY FITTING AND STEADY BLOCK WERE REPLACED BY SERVICEABLE PER CRJ-900 SRM 51-42-21-001-001-A01 AND SRM 51-41-02-001-001-A01SDR SWIA2025F01390Floorbeam · corrodedSTRAP ON THE PRESSURE FLOOR BEAM BL27L TO SILL -BL43L FS559.00 HAS TWO AREAS OF CORROSION. MARKED (C-CHECK RO 09/24/2025)BLENDED CORROSION FROM STRAP FROM PRESSURE FLOOR BEAM BL27L TO SILL BL43L AT FS559.00 AREAS 2 EA REF: CRJ 200 SRM 51-21-06-00. MATERIAL LOSDR SWIA2025F01389Web · corrodedCORROSION FOUND ON LOWER WEB BETWEEN FS 333.0 AND 349.0 AT INTERCOSTAL 20R. MARKED (C-CHECK RO 09/24/2025)REPLACED INTERCOSTAL 20R BTWN FS333.0-FS349.0 REF. DWG 601R38303 REV. -AR, CRJ200 SRM 51-42-06 AND CRJ200 SRM 51-42-21 AND COMPLIED WITH TASK CARD 51-90SDR SWIA2025F01388Floorbeam · corrodedSTRAP ON THE PRESSURE FLOOR BEAM BL27R TO SILL -BL43R FS559.00 HAS MULTIPLE AREAS OF CORROSION. MARKED (C-CHECK RO 09/24/2025)COMPLETED REPLACEMENT OF STRAP ON PRESSURE FLOOR BEAM RBL 27 TO RBL 43 AT FS 559.00 AS PER CRJ200 SRM 51-42-06 & DWG 601R31025 REV: SDR SWIA2025F01387Floor Support · corrodedRIGHT PRESSURE FLOOR SILL ANGLE, FS409.0+128 TO FS559.0, HAS MULTIPLE AREAS OF CORROSION. MARKED (C-CHECK RO 09/24/2025)REPAIRED RH PRESSURE FLOOR SILL ANGLE FS409.0+128 TO FS559.0 4 LOCATIONS IAW REO 601R-53-41-666 REV C DATED 2012-11-06, REO 601R-53-41-33SDR SWIA2025F01386Floorbeam · corrodedPRESSURE FLOOR SUPPORT BEAM, BL27R, OUTBOARD FLANGE HAS CORROSION, FS559.00. MARKED (C-CHECK RO 09/24/2025)REPAIRED PRESSURE FLOOR SUPPORT BEAM AT RBL 27 FS 559 IAW ALL STEPS OFL REO 601R-53-41-3343 REV -- DATE 2025-08-14. COMPLIED WITH M-337 AND SKYWEST TASSDR SWIA2025F01385Web · corrodedRIGHT PRESSURE FLOOR SILL WEB, FS409.0+128 TO FS559.0, HAS MULTIPLE AREAS OF CORROSION. MARKED (C-CHECK RO 09/24/2025)REMOVED CORROSION ON 7EA AREAS AT RH PRESSURE FLOOR SILL WEB, FS409.0+128 TO FS 559.0, REF. CRJ-200, SRM 51-21-06. COMPLIED WITH STEPS 1-7 RSDR SWIA202509250724Web · corrodedLEFT PRESSURE FLOOR SILL WEB, FS409.0+128 TO FS559.0, HAS MULTIPLE AREAS OF CORROSION. MARKED (C-CHECK RO 09/24/2025)REPAIRED LEFT PRESSURE FLOOR SILL WEB, FS409.0+128 TO FS559.0 IAW REO 601R-53-41-3342 REV -- DATED 2025-08-22 AND COMPLIED WITH TASK CARD 51-9