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 2025FA0000825Inlet · deterioratedLEFT ENGINE INLET MESH DETERIORATIONSDR 2025FA0000824Inlet · deterioratedLEFT ENGINE INLET MESH DETERIORATION.SDR AALA202512126160Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY SLIDE LIGHT FOR AFT ENTRY DOOR INOPERATIVE. REMOVED AND REPLACED LAMP FOR EMERGENCY SLIDE LIGHT ASSEMBLY ON AFT ENTRY DOOR. IAW AMM 33-51-04. OPERATIONAL TESTED GOOD.SDR SCNA20251212483Light · unsecureROW 12 ABC EMERGENCY FLOOR LIGHTING STRIP NEEDS TO BE RESECURED TO FLOORSDR DALA2025121209109Light · failedENROUTE FA'S NOTIFIED OF BURNING SMELL NEAR DOOR 2L. INDENTIFIED FUME COMING FROM CEILING NEAR LIGHTS. NO SMOKE. INSTRUCTED FAS TO TURN OFF CABIN LIGHTS SMELL DISAPIATED. QRH 8.4 COMPLIED WITH. PERFORMED OPS TEST OF CEILING LTS, FOUND BURNING SMELL FROM OVERSDR DALA2025121209105Seat Track · corrodedCORROSION ON FWD PORTION OF SEAT TRACK Y1137.1. REPAIRED PER 630957-14 REV ORIGINAL. (1347520)SDR 2DYA2025081300015Skin · debondedL/H WING TRAILING EDGE SLAT DEBOND SKIN @ STA. 772.2. 12-DEC-25 LP 43803SDR 2025FA0000823Fire Loop · chafedRH ENGINE FIRE INDICATION ON APPROACH TO LAND. USED BOTH FIRE BOTTLES AND SHUT DOWN THE ENGINE, AND THE LIGHT REMAINED ILLUMINATED. AFTER INSPECTION, NO EVIDENCE OF FIRE WAS FOUND. INSPECTION DETERMINED THE CAUSE WAS A CHAFFED ENGINE FIRE DETECTION LOOP RUBSDR KCSA202512121244Web · crackedAFTER NDT INSPECTION A DEFECT NOTED ON HOLE AT BONDED WEB ASSEMBLY STA 2598 WL 265 AND RBL 39SDR 2025FA0000822Unknown · unknownTHE PARTS RECORDED UNDER EASA FORM 1 TRACKING NR 44543 AND 44538 HAVE BEEN DETECTED AS SUSPICIOUS. DISCREPANCY ON MISSING SIGNATURE, (SECTION 14B), APPROVAL/CERTIFICATE NO (SECTION 14C) AND ORGANIZATION NAME AND ADDRESS (SECTION 4) HAVE BEEN DETECTED. AUTHORISDR COEA2025121206779Display · failedFLIGHT 4701 ENROUTE: GEG-PSC DURING FLIGHT, THE PRIMARY FLIGHT DISPLAY (G600), LEFT SIDE, FAILED. THE AIRCRAFT LANDED WITHOUT INCIDENT AND NO EMERGENCY WAS DECLARED. MAINTENANCE REPLACED THE GDU 620 DISPLAY UNIT. OPS CHECK GOOD.SDR KCSA202512121243Tension Tie · crackedAFTER NDT ACCOMPLISHED A HFEC OPEN INSPECTION ON TENSION TIE STA 1180 L/H SIDE FOUND 3 EA FASTENER HOLE WITH DEFECT INDICATIONSDR DALA2025121209082Radome · delaminatedDURING WALK AROUND, FOUND DELAMINATION TO RADOME. R & R RADOME IAW A319 AMM 53-15. (7892405).SDR KCSA202512121242Tension Tie · crackedAFTER NDT INSPECTION 3 EA FASTENER HOLES FOUND WITH DEFECT INDICATION ON TENSION TIE BS 1140 LT.SDR KCSA202512121241Seat Track · corrodedDURING " OK TO INSTALL " FOUND SEAT TRACK AT FUSELAGE STA 1960 RBL 11.33 WITH EXFOLIATION CORROSION AT THE LOWER SURFACE FLANGESDR ABXA20251212328Warning Message · false activationR ENG BLEED OFF MESSAGE APPEARED INTERMITTENT WHILE TAXIING AND AFTER TAKING THE RUNWAY FOR IDLE UP DEICE RUN-UP. AIRCRAFT RETURNED TO BLOCKS (BTB). ACCOMPLISHED THUMB TEST OF RT HPSOV IAW AMM 36-11-07 NO FAULTS PRESENT CYCLED PRV AND PRSOV NO ISSUES NOTED BSDR FDEA202512122242Seat Track · corrodedMAIN CARGO BAY SEAT TRACK LBL 58.22, BS 1180 - 1420 WITH CORROSION IN MULTIPLE AREAS. REMOVED THE SEAT TRACK SECTION IAW SRM 51-40-02-0G. TRIMMED, LOCATED, DRILLED AND INSTALLED A NEW SEAT TRACK REPLACEMENT SECTION IAW SRM 51-40-05-0G, SRM 51-40-08-0G, SRMSDR FDEA202512122241Seat Track · corrodedMAIN CARGO COMPARMENT SEAT TRACK LBL BETWEEN BS 1180 - 900 WITH CORROSION IN MULTIPLE AREAS. REMOVED THE SEAT TRACK SECTION OUT OF LIMITS AT MAIN CARGO BAY BS 900 - 1180, LBL 58.22 IAW SRM 51-40-02-0G; TRIMMED, LOCATED, DRILLED AND INSTALLED A NEW SEAT TRACSDR FDEA202512122240Skin · delaminatedLEFT WING OTBD MAIN FLAP T/E UPPER SURFACE HAD POSSIBLE DELAMINATION. APPLIED PERMANENT REPAIR ON AREAS WITH DELAMINATION AT LT WING OTBD MAIN FLAP T/E UPPER SURFACE BTW WBL 471 - WBL 501 IAW SRM 57-53-01-2R, TABLE III, AND SRM 51-70-07-0G.SDR FDEA202512122239Torque Tube · damagedWHEN CONFIGURING AFTER START SETTING FLAPS TO 5 RECEIVED LE SLAT DISAG EICAS. UPON INSPECTION FOUND THE CONTROL CABLE INPUT FOR THE LE SLAT PDU BROKEN AND FRAYED. THE CABLE IS IDENTIFIED AS LESA IAW FIM 27-81, FAULT TREE 803, FIGURE 104, & IPC 27-51-25-0SDR KCSA202512121240Tension Tie · crackedAFTER NDT INSPECTION FOUND TWO CRACKS ON TWO FASTENER HOLES AT TENSION TIE 1120 LT SIDE.SDR KCSA202512121239Intercostal · crackedA CRACK INDICATION WAS IDENTIFIED BETWEEN FASTENERS AT BL 0 BETWEEN STA 320 AND STA 340SDR CALA2025121212074Cover · missingEMERGENCY LIGHTS OPS CHECK, ROW 20 SEAT UPPER EMERGENCY PATHWAY EXIT RED LIGHT IS MISSING LENS COVER. REPLACED LIGHT ASSY, OPS CHECK GOOD.SDR CALA2025121212048Lamp · inoperativeFLOOR PROXIMITY EMERGENCY LIGHT INOP AT SEAT 31 C PERFORMED FLOOR PROXIMITY LIGHT - LAMP.REPLACEMENT AT SEAT 31C IAW AMM 33-51-11-960-801 OPS CHECK GOOD. PARTS USED: 29-3326-3-0013, QTY :1SDR SWIA2025121175858Skin · dentedFWD FUSELAGE JUST FWD OF GPU RECEPTICLE DOOR FS 187.25 4 INCHES BELOW ADG CUTOUT SMALL CIRCULAR DENT 0.5 IN. IN DIAMETER 0.012 IN. DEEP. PERFORMED CUT-AWAY OF DAMAGED SECTION, FABRICATED FUSELAGE SKIN REPAIR DOUBLER -1 AND WET INSTALLED REPAIR DOUBLER AT FWDSDR SWIA2025121175768Stop Fitting · corrodedCARGO DOOR LOWER AFT STOP FITTING CORRODED. REMOVED CORROSION ON CARGO DOOR, LOWER AFT STOP FITTING, PER REF.CRJ/200 SRM.51-21-06-00. COMPLIED WITH REO 601R-53-61-8451 REV -. OPS AND FITS AND CLEARANCES CHECKS OK AT THIS TIME. LEAK CHECK GOOD. COMPLIED WITH TSDR SWIA2025121175763Stop Fitting · corrodedCARGO DOOR UPPER AFT STOP FITTING CORRODED. REMOVED CORROSION ON CARGO DOOR, UPPER AFT STOP FITTING, PER SRM.51-21-06-00. COMPLIED WITH REO 601R-53-61-8451 REV-. OPS AND FITS AND CLEARANCES CHECKS OK AT THIS TIME. LEAK CHECK GOOD. COMPLIED WITH TASK CARD 51-SDR SWIA2025121175747Stop Fitting · corrodedCARGO DOOR AFT LOWER CENTER STOP FITTING CORRODED. REMOVED CORROSION ON CARGO DOOR, AFT LOWER CENTER STOP FITTING, IAW SRM.51-21-06-00. COMPLIED WITH REO 601R-53-61-8451 REV--.SDR SWIA2025121175740Stop Fitting · corrodedCARGO DOOR LOWER FWD STOP FITTING CORRODED. REPAIRED CARGO DOOR LOWER FWD STOP FITTING REF ALL STEPS OF REO 601R-53-61-8451 REV. --. FITS AND CLEARANCES GOOD. LEAK CHECK GOOD. COMPLIED WITH TASK CARD 51-900-1003-SKY.SDR SWIA2025121175739Stop Fitting · corrodedCARGO DOOR FWD LOWER CENTER STOP FITTING CORRODED. REMOVED CORROSION ON CARGO DOOR, FWD LOWER CENTER STOP FITTING, PER SRM.51-21-06-00. COMPLIED WITH ALL STEPS OF REO 601R-53-61-8451 REV--, OPS AND FITS AND CLEARANCES CHECKS OK AT THIS TIME. LEAK CHECK GOOD SDR SWIA2025121175316Stiffener · crackedFS 280.00 FWD STIFFENER ANGLE, BL26.00 IS CRACKED. (C-CHECK RO 02/22/2026)REMOVED AND REPLACED THE FS 280.00 FWD STIFFENER ANGLE,(CORRECTED LOCATION) LBL26.00 IN REFERERENCE WITH THE CRJ-700 SRM 51-42-06 AND SRM 53-11-10. COMPLIED WITH TASK CARD 51-900-1002-SSDR SWIA2025121175245Doubler · misinstalledDURING AUDIT OF RA 44067, FUSELAGE SKIN DOUBLER BTWN BS 349 AND 364, S19 - 23L IAW REO 670-53-21-504, REV. A. FOUND THAT ONE EXTRA FASTENER INSTALLED IN THE REPAIR AS DEPICTED IN THE REO DRAWING. RECEIVED MHI REO 670-53-21-504 REV -B, UPDATES THE REPAIR PERSDR HNAA2026020900113Floor Support · crackedLEFT OMEGA BEAM OTBD ANGLE CRACKED AT BTW FR47-50. R & R ANGLE IAW SRM 51-40-02.SDR VNAA20260201001Plate · corrodedDURING INSPECTION OF THE TASK CARD 53-20-220-JIC WAS DETECTED CORROSION ON KICKPLATE AND MID CAP BTW FS 310.00 TO FS 349.00 AT SURROUND STRUCTURE PASSENGER DOOR. KICKPLATE AND MID CAP BTW FS 310.00 TO FS 349.00 AT SURROUND STRUCTURE PASSENGER DOOR WERE EVALSDR JJBA20260130052Seat Track · corrodedCORROSION ON THE RT INBOARD SEAT TRACK AT STR 17R BETWEEN FRAMES 24-25. REMOVED OLD SEAT TRACK AND INSTALLED NEW SEAT TRACK FROM STOCK TO RH INBOARD SEAT TRACH AT STR 17R BETWEEN FRAMES 24-25SDR JJBA20260130044Rivet · damagedEXTERNAL SKIN MID SECTION, LT, FROM FR 2 TO FR 3, DAMAGED. INSTALLED NEW RIVET AND WASHER FOR DAMAGE B AT FR 2 - FR 3 STRG 15L AND INSTALLED NEW RIVET AND WASHER DAMAGE A AT FR 1 - FR 2 STRG 15LSDR HNAA2026012900106Shear Tie · corrodedSHEAR CLIP CORRODED AT FR 52 BTW STR 20-21R. R & R SHEAR CLIP IAW SRM51-40-02SDR HNAA2026012900101Shear Tie · corrodedSHEAR TIE CORRODED AT FR51 BTW S20 - 21R. REMOVED, FABRICATED, AND INSTALLED SHEAR TIE IAW ETD2026-145-000952.SDR HNAA2026012900100Stringer · corrodedSTRINGER 21R CORRODED AT BTW FR 50-53. R & R THE STRINGER BETWEEN FRMS 50-53 IAW SRM 51-40-02.SDR HNAA2026012900099Support · crackedLEFT OMEGA BEAM CRACKED AT FR36. REPAIRED IAW ETD 2025-145-934098 AND EO1-53-26-0001.SDR HNAA2026012800090Support Angle · crackedCARGO DOOR LIFTING MECHANISM SUPPORT ANGLE CRACKED AT FR 62 BTW S4 - 5R. R & R THE SUPPORT ANGLE IAW SRM 51-40-02.SDR HNAA2026012700084Angle · crackedRIGHT OVERWING PANEL 194ER, NR 1 LWR ANGLE CRACKED, YA-1085, RIB1A. REMOVED, FARICATED, AND INSTALLED A NEW ANGLE IAW SRM 57-20-01RE.SDR VNAA20260125023Seat Track · corrodedCORROSION ON THE SIDE SEAT TRACK TWO SEGMENTS AT S15L, BS 785 TO BS 847 + 8.40. AND BS 847 + 35 - BS 902. EVALUATED, THE SEAT TRACKS WERE OUT OF LIMITS IAW SRM 53-41-49-101-001-A02, AND SRM 53-51-49-101-001-A02, AND REPLACED IAW AMM 53-00-49.SDR VNAA20260125022Seat Track · corrodedGOUGES & SCRATCHES ON THE SIDE SEAT TRACK, S15R BTW BS 379 TO 720.85 AND SIDE SEAT TRACK, S15L BTW BS 379 TO BS 720.85. THE TWO SIDE SEAT TRACKS WERE EVALUATED OUT OF LIMITS IAW SRM 53-21-49-101-001-A01, SRM 53-41-49-101-001-A02, AND REPLACED IAW AMM 53-00-SDR VNAA20260125014Seat Track · corrodedCORRODED SEAT RAIL AT LBL 9 BS 374 TO 485. THE SEAT TRACK WAS EVALUATED OUT LIMITS IAW SRM 53-21-49-101-001-A01, SRM 53-21-49-101-001-A02, & REPLACED IAW AMM 53-00-49-400-801, CONFIG A12.SDR VNAA20260125013Seat Track · corrodedCORRODED SEAT TRACK, 3 SEGMENTS AT RBL 9, BS 348 TO 360, BS 360 TO 485, AND BS 485 TO 581. THE SEAT TRACK SEGMENTS WERE EVALUATED OUT OF LIMITS IAW SRM 51-10-06-001-001-A01, & REPLACED IAW AMM 53-00-49-400-801, CONFIG A12.SDR VNAA20260125012Seat Track · corrodedCORROSION ON SIDE SEAT RAIL 02 SEGMENTS AT STGR15L, (01 SEG.) FS785.00 TO FS847.00 + 8.40. AND (02 SEG.) FS847.00 + 35.00 TO FS902. DUE TO EXCESS DAMAGE ALONG THE RAIL ON SIDE SEAT RAIL 02 SEGMENTS AT STGR15R, (01 SEG.) FS785.00 TO FS847.00 + 8.40. AND (02 SESDR HNAA2026012300078Floor Support · crackedLEFT OMEGA BEAM INBD ANGLE CRACKED AT BTW FR47-50. R & R ANGLE IAW SRM 51-40-02SDR HNAA2026012300077Floor Support · cracked53-2132 RH OMEGA BEAM IB ANGLE CRACKED AT BTW FR48-50. R & R ANGLE IAW SRM 51-40-02SDR HNAA2026012300076Floor Support · cracked53-2131 RH OMEGA BEAM OB ANGLE CRACKED AT BTW FR48-50. RAR ANGLE IAW SRM 51-40-02