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 CALA2025090508490Warning Message · illuminatedDOOR FLIGHT LOCK 3R EICAS STATUS R3 DOOR FLIGHT LOCK COMMAND, FLT LK RELAY & SENSOR DISAGREEMENT. MESSAGE IS NOT LATCHED, NO HISTORY, OK PER FIM 52-11-TASK 806 ITEM #E.SDR GTIA2025090539065Unknown · odorSTRONG BURNING SMELL IN COCKPIT. PERFORMED TSM 24-00-00-810-823-A, PERFORMED GVI OF E & E BAYS, ALONG WITH WIRE GVI, COCKPIT, C/B PANELS, CABIN GALLEYS, LAV'S, & CARGO BAYS. NO SMELL DETECTED, UNABLE TO DUPLICATE, ALSO PERFORMED ENG RUN, ONE AT THE TIME WSDR SCNA20250905359Lamp · inoperativeFOUND AFT RT EMERGENCY LIGHT BY R2 DOOR INOPERATIVE, DURING EMERGENCY LIGHTS TEST. REPLACED THE LAMPS IAW AMM 33-51-04-960-801. OPS CHECKED GOOD.SDR IPXA2025090405528Seal · dirtyL1 DOOR IS VERY DIFFICULT TO OPEN. ADJUSTED AND CLEANED L1 DOOR SEAL AND DOOR LINING REF. AMM 52-12-00. DOOR OPS CHECKS NORMAL.SDR 2025FA0000625Indication Sys · faultedDURING APPROACH THE PILOT SELECTED GEAR DOWN AND RECEIVED THREE GREEN AND A RED INDICATION. THE PILOT ELECTED TO FLY BY THE TOWER FOR VISUAL OF THE GEAR DOWN. THE TOWER CONFIRMED THE GEAR WAS DOWN. DURING THE DOWNWIND PHASE OF FLIGHT THE RED LIGHT EXTINGUISSDR DALA2025090406552Elec Connector · damaged(LOG 7612100) ROW 24 DEF EMERGENCY LIGHT INOP. FOUND WIRE BROKEN PAST CONNECTOR REPAIRED SAME IAW DAL PS 900-9-2 NO . OPS CHK NML.SDR DALA2025090406551Floorbeam · corroded(LOG 1180673) CORROSION ON FLOOR BEAM STA 947.5 BTW RBL 49 TO RBL 53 AT PAX CABIN. FLOOR BEAM STA 947.5 BTW RBL 49 TO RBL 53 AT PAX CABIN WAS REPAIRED DUE CORROSION LEVEL 2 PER B737-800 SRM 53-70-51-2R REPAIR 5.SDR DALA2025090406550Floor Support · corroded(LOG 1180584) CORROSION ON FLOOR SUPPORT UPPER AND LOWER SIDE STA 967 TO 986 BTW RBL 16 AT PAX CABIN. FLOOR SUPPORT STA 967 TO 986 BTW RBL 16 AT PAX CABIN WAS REPLACED AND INSTALLED PER B737-800 SRM 51-40-02-0G.SDR DALA2025090406542Skin · dentedDENT AND CREASE FOUND JUST BELOW STR 16LH AND AFT OF STA 620. CREASE CENTERED WITHIN THE DENT. PERFORMED CUT OUT OF DAMAGE AREA PER B757-200 51-10-02. ACCOMPLISHED HFEC OF DAMAGED/SURROUNDING AREA PER ERA 628978-14, STEP3 NO FINDINGS. INSPECTED FUSELAGE AREASDR EE4Y2025090423050Rib · wornENGINE #1 PYLON ACCESS PANEL 431CL O/B SUPPORT STRUCTURE WITH WEAR, THE RIB ASSY P/N: 116A5502-5 AND P/N: 116A5502-6 MUST BE FABRICATED PER THE APPLICABLE DWG116A5502 INSTRUCTIONS AND BCS COO-COO-25-0019-01B SMAL REQUESTED. HOWEVER, COOPESA DO NOTHAVE THE CAPASDR EE4Y2025090423049Rib · wornRIB ASSY P/N: 116A5502-5 AND P/N: 116A5502-6 MUST BE FABRICATED PER THE APPLICABLE DWG 116A5502 INSTRUCTIONS AND BCS COO-COO-25-0019-01B SMAL REQUESTED. HOWEVER, COOPESA DO NOT HAVE THE CAPABILITIES TO COMPLY WITH THE CONVERSION COATING APPLICATION BY IMMERSIOSDR EE4Y2025090423046Fan Cowl · damagedDURING THE ACCOMPLISHMENT OF 737-70-812-02_P1-OP-UP-ENG NAC TASK CARD, IT WAS FOUND THE ENGINE #2, O/B FAN COWL P/N: 314-2200-18 BR, S/N: 9112001, WITH ELONGATED HOLES (2EA). COLLINS WAS CONTACTED ASKING FOR REPAIR INSTRUCTIONS AND FINAL APPROVAL. THE CONDITIOSDR FDEA202509041616Pitot Tube · cloggedON TAKEOFF ROLL, CAPTAIN S AIRSPEED SHOWED 95 KTS WHILE FO SIDE SHOWED 60 KTS. TAKEOFF REJECTED. PERFORMED FLIGHT ENVIRONMENT DATA BITE TEST PER A300 AMM 34-10-00-05, TEST PASSED, NO FAULTS NOTED. PERFORMED VISUAL INSPECTION OF F/O PITOT TUBE PER A300 AMMSDR EE4Y2025090423045Door Sill · crackedDURING THE ACCOMPLISHMENT OF 737-53-360-00-01_P1-OP-UP-UF/001 NAC TASK CARD, WAS FOUND IN THE UPPER FUSELAGE FWD ENTRY DOOR, AT STA 303.9 LBL 55, WL208, LOWER SILL INNER CHORD WITH CRACK. THIS CONDITION WAS REPAIRED DUE TO CRACK IAW B737-800 SRM 53-10-15 REPAISDR EE4Y202509023040Cargo Track · crackedDURING THE ACCOMPLISHMENT OF 737-53-250-00_P1-OP-UP-LF/001 NAC TASK CARD WAS FOUND AT AFT CARGO C/C TRACK WITH CRACKS, LOCATED AT STA 727C, STA 727G, STA 727J AND STA 767, LBL 17.24. THE CONDITION REPORTED WAS REPLACED THE TRACK AT LBL 17.24 FROM STA 727+4" TOSDR EE4Y202509023039Angle · crackedDURING THE ACCOMPLISHMENT OF 737-26-550-02_P1-VISUAL-INSP-LF/003 NAC TASK CARD, WAS FOUND IN THE BULKHEAD STA 663 AT RBL 7.25, WING CENTER SECTION LOWER REAR SPAR VAPOR BARRIER ATTACH ANGLE WITH CRACK. THE CONDITION REPORTED WAS REPAIRED AT STA 663 BTWN RBL 6 SDR EE4Y202509023037Web · crackedDURING THE ACCOMPLISHMENT OF 737-26-550-02_P1-VISUAL-INSP-LF/002 NAC TASK CARD, WAS FOUND IN THE LOWER FUSELAGE L/H SIDE, CENTER WING REAR SPAR VAPOR BARRIER WEB WITH CRACKS, AT STA 663, BTWN LBL 15.54 AND LBL 54.21. THE CONDITION REPORTED WAS REPAIRED I//A/W SDR SCNA20250904358Slide · out of positionCREW REPORTS L1 DOOR SLIDE FLAP HANGING LOW. RE-POSITIONED L1 DOOR SLIDE FLAP AND INSPECTED SLIDE LATCH REF AMM 25-66-01SDR CALA2025090408480Probe · faultedDURING CLIMBOUT HAD INDICATION OF POSS FUEL LEAK SHOWED 8K LOSS REQUEST TO MEL. INSPECTED AIRCRAFT UPON ARRIVAL. NO FUEL LEAKS NOTED. RIGHT FUEL QTY INDICATION INOP PROBE #24 AT FAULT PLACARD INSTALLED. REPLACED PROBE #24 REF AMM 28-41-02-400-801 CHECKED SAFESDR EE4Y2025090423036Web · crackedDURING THE ACCOMPLISHMENT OF 737-26-550-02_P1-VISUAL-INSP-LF/001 NAC TASK CARD, WAS FOUND IN THE LOWER FUSELAGE R/H SIDE, CENTER WING REAR SPAR VAPOR BARRIER WEB WITH CRACKS, AT STA 663, BTWN RBL 31.83 AND RBL54.21. THE CONDITION REPORTED WAS REPAIRED I//A/W BSDR IXXA20250904006Skin · corrodedRW TOP EXTERNAL SKIN CORRODED AT AFT SPAR AT APPROX. WING STA 130 NUMBERED 126-128SDR IXXA20250904004Skin · corrodedRW TOP EXTERNAL SKIN CORRODED ON AFT SKIN AT APPROX. WING STA 95SDR QR9R2025090400002Bracket · brokenPILOT DOOR STRUT BRACKET BROKE OFF ON RUN-UP. REPLACED MOUNTING BRACKET IAW AMM 52-11-00, 8-4.SDR IXXA20250904003Skin · corrodedRW TOP EXTERNAL SKIN CORRODED AT SKIN SPLICE AT APPROX. WING STA 190-231SDR IXXA20250904002Skin · corrodedRW TOP EXTERNAL SKIN CORRODED AT FWD SPAR AT APPROX. WING STA 231SDR QR9R2025090400001Actuator · failedYAW ACTUATOR FAILED IN FLIGHT AND WOULD NOT RESET. TWO RESET ATTEMPTS WERE UNSUCCESSFUL. SEMA ACTUATOR WAS FOUND TO BE DEFECTIVE DURING TROUBLESHOOTING IAW AMM 22-10-00, 2-1. CAUSES YAW SAS, BACKUP SAS, AND ACTUATOR MESSAGES TO APPEAR ON CAD WITH "Y" ON PFD. RSDR DALA2025090406538Filter · odorSHIP 3252 DISC: WITH APU BLEED "ON" DIRTY SOCK ODOR STRONGER IN FLIGHT DECK AFT F/A ALSO COMPLAINED ABOUT ODOR IN AFT CABIN, APU BLEED WAS TURNED OFF SMELL DISSIPATED. C/A: AFTER COMPARTMENT WASH, RAN APU FOR 30+ MINUTES-NO LEAKS FOUND. C/W AMDS WORK CARD 491SDR IXXA20250904001Skin · corrodedRW TOP EXTERNAL SKIN CORRODED AT FWD SPAR AT APPROX. WING STA 610SDR 9WGA2026081354681Spar · corrodedNR# 474 - L/H WING UPPER FWD SPAR HAS CORROSION APPROX XOR & 372 ON FWD LEG. REPAIRED L/H WING FWD SPAR APPROX. XOR & 372 ON FWD LEG AS PER BOEING MESSAGES WGN-WGN-25-0038-010 0/-03C. AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR REXA2026073001313Angle · crackedAFTER ANGLE AND GUSSET REMOVAL :CRACK ON ANGLE BTW RBL12 AND FS280.00 WAS FOUND ANGLE BTW RBL12 AND FS280.00 WAS FABRICATED PER EA NO: CRJ953-20093 REV IR AND WAS REMOVED/INSTALLED WITH NRC 00145SDR REXA2026073001311Floor Support · corrodedCORROSION ON FLOOR SUPPORT BTW FS280/FS265 AND RBL12 AT CABIN FLOOR STRUCTURE DUE TO EXCESSIVE CORROSION ON FLOOR SUPPORT BTW FS280/FS265 AND RBL12 AT CABIN FLOOR STRUCTURE WAS REPLACED PER CRJ900 SRM 51-10-06-001-001-A01 AND SRM 51-42-21-001-001-A01SDR REXA2026073001307Door · crackedCRACK ON FWD MEMBRANE OF INBD DOOR AT LH MLG INBD DOOR AT LH MLG P/N: KBA670-10500-31 S/N: 15149 WAS REMOVED PER CRJ-900 AMM 32-12-01-000-802-A04 AND TS #: 005834B-R1 AND SERVICEABLE LH MLG INBD DOOR P/N: KBA670-10500-31, S/N: 15095 WAS INSTALLED PER CRJ-900 ASDR REXA2026073001305Fitting · corrodedAFTER BRUSH REMOVAL: CORROSION AND WEAR ON SEATTLEMENT AREA WAS FOUND. CORROSION AND WEAR ON SEATTLEMENT AREA WAS EVALUATED OUT OF LIMITS THEREFORE THEY WERE REPLACED PER CRJ-900 SRM 51-10-06-001-001-A01 AND AMM 20-21-00-910-801- A01SDR 9WGA2026032335602Pump · corrodedDURING HEAVY MAINTENANCE CHECK EVIDENCE OF CORROSION AROUND RIGHT CENTER TANK JETTISON PUMP. WORK ACCOMPLISHED IAW AGREEMENT NR WGN-RE-2500580. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWIA2025090375391Roller · damagedRH SLAT TRACK ROLLER 1-2 OUTBOARD AFT SIDE ROLLER HAS FLAT SPOTS. REPLACED RH 1-2 OUTBOARD AFT SIDE SLAT TRACK ROLLER AS PER AMM 27-81-44. SEE TASK CARD 27-630-101 IN CP 30270403-1 FOR OPS CHECK.SDR SWIA2025090375390Roller · wornRIGHT SLAT TRACK 3-2 INBD AFT SIDE ROLLER IS WORN. REMOVED AND REPLACED RT SLAT TRACK 3-2, INBD AFT SIDE ROLLER IN REFERENCE TO AMM 27-81-44.SDR SWIA2026022705389Roller · damagedLEFT SLAT TRACK 2-2 INBOARD FORWAD SIDE ROLLER IS FLAT SPOTTED. REMOVED AND REPLACED LT SLAT TRACK 2-2 INBOARD FORWARD SIDE ROLLER IN REFERENCE TO AMM 27-81-44.SDR SWIA2026022705388Roller · damagedL/H SLAT TRACK 1-2 INBOARD AFT SIDE ROLLER IS FLAT SPOTTED. (C-CHECK RO 02/25/2026)REMOVED AND REPLACED L/H SLAT TRACK 1-2 INBOARD AFT SIDE ROLLER, REFERENCE CP 30270403 FOR COMPLETION OF TASK CARD 27-520-120.SDR DALA2026022501343Floorbeam · corroded(LOG 1179641) STA 986 FLOORBEAM HAS CORROSION AT GIRT BAR FITTING HOLE AT LBL40. PERFORMED REPAIR ON THE FLOORBEAM AT STA 986 ST GIRT BAR FITTING HOLE LBL40 IAW B737-900 SRM 53-70-51-2R-6.SDR NACA2025090300001Boot · damagedRIGHT COOLING-HEAT EXCHANGER PLENUM BOOT IS DAMAGED. REMOVED AND REPLACED THE EXCHANGER BOOT IAW AMM 21-51-02-004-001 & AMM 21-51-02-404-019. OPS CKD GOOD.SDR SWI2025F01787Angle · corrodedFOUND CORROSION ON ANGLE BS 565 BETWEEN STRINGERS 15L TO 18L. REMOVED ANGLE FROM FRAME IAW SRM 51-42-06-001-001-A01 AND INSTALLED NEW REINFORCING ANGLE IAW DWG SH670-33119, REV NC, SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01, COMPLIED 51-900-1002-SKSDR SWIA2025120800903Angle · corrodedFOUND CORROSION ON ANGLE FS549.00 BETWEEN STRINGER 15L TO 18L P/N SH670-33119-1 (C-CHECK RO 12/07/2025)REPLACED ANGLE P/N: SH670-33119-1 REF CRJ700 SRM 51-42-06-001-001-A01. AND CRJ700 SRM 51-42-21-001-001-A01 AND DWG#SH670-33100 REV K ,SEE CONTINUE CARD FORSDR SWIA2025120200903Guide · wornDURING AAI AUDIT OF 2C TASK CARD 57-690-304, FOUND THE LT SIDE ROLLER GUIDE IS SHOWING SIGNS OF WEAR. COMPLIED WITH THE REPAIR OF THE LT SIDE ROLLER GUIDE IAW REO 690-57-51-467, REV -. OPS CHECK GOOD.SDR SWIA2025120100903Skin · dentedADM# N606SK-8233. LEFT INBOARD FLAP AT FS 27 NEAR THE TRAILING EDGE. DENT ON LOWER SKIN MEASURES WIDTH 1/4 IN. X DEPTH .035". SRM 57-53-01. PLOT, MAP, AND EVALUATE DAMAGE IF WITHIN ACCEPTABLE LIMITS OR REWORKED, ELIMINATE EVIDENCE USING STANDARD ACFT PRACTICESSDR AALA202511280086Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION ON FR 36 CENTER WING BOX FRONT SPAR VERTICAL STRINGER , Y 254 ZONA 2, CRACK POSITION 11 OCLOCK, CRACK DEPTH 0.120 INCHES. MAINTENANCE PERFORMED PERMANENT REPAIR INSTRUCTIONS ON FR 36 CENTER WING BOX FRONT SPAR VERSDR AALA202511282351Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION ON FR 36 CENTER BOX FRONT SPAR VERTICAL STRINGER, Y-254 ZONA 2, CRACK POSITION 12 OCLOCK, CRACK DEPTH 0.105 INCHES MAINTENANCE PERFORMED PERMANENT REPAIR INSTRUCTIONS ON FR 36 CENTER BOX FRONT SPAR VERTICAL STRINGSDR AALA202511289720Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION ON FR 36 CENTER BOX FRONT SPAR VERTICAL STRINGER , Y765 ZONA 1, CRACK POSITION 12 OCLOCK, CRACK DEPTH 0.117 INCHES. MAINTENANCE PERFORMED PERMANENT REPAIR INSTRUCTIONS ON FR 36 CENTER BOX FRONT SPAR VERTICAL STRINSDR AALA202511288315Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION ON FR 36 CENTER BOX FRONT SPAR VERTICAL STRINGER, Y-765 ZONA 1, CRACK POSITION 1 OCLOCK, CRACK DEPTH 0.125 INCHES . MAINTENANCE PERFORMED PERMANENT REPAIR INSTRUCTIONS ON FR 36 CENTER BOX FRONT SPAR VERTICAL STRISDR VNAA202511250004Angle · corrodedCORROSION ON SETTLEMENT AREA (UPPER SURFACE) OF ACCESS PANEL 362AR AT AFT FUSELAGE. ANGLE P/N: WA670-30111-3 ON SETTLEMENT AREA (UPPER SURFACE) OF ACCESS PANEL 362AR AT AFT FUSELAGE WAS REPLACED PER CRJ-900 SRM 51-42-06-001-001-A01 AND DWG 670-30111 REV. C.SDR AALA202511067793Support Frame · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT WING AILERON #1 HINGE SUPPORT FRAME HAS EXCESSIVE PLAY. REPLACED SUPPORT FRAME PER AMM 57-51-31.