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 CALA2025110210820Skin · crackedPOSSIBLE DAMAGE FOUND ON APU HINGE POINT. DAMAGE IS REFER TO SRM 53-00-01 , TWO CRACKS & EDGE DAMAGE BEYOND LIMITS OF 0.150" , OUT OF ALLOWABLE LIMITS. REMOVED FASTENERS AT DAMAGED AREA IAW SRM 53-80-01-2R-1 STEP 4.A. REMOVED DAMAGED SKIN IAW SRM 53-80-01SDR CALA2025110210818Skin · damagedWHILE ACCOMPLISHING EC/RA 5760-01117 (AVO15691) THERMOGRAPH INSPECTIONS ON LT & RT OTBD AILERONS, FOUND INGRESS LIQUIDS ON THE RT OTBD AILERON INBOARD CAP, AT THE SPAR AREA. ALL STEPS OF THE ECRA: 5760-01117 (THERMOGRAPHIC INSPECTION) AND ECRA: 5760-01114 WESDR DALA2025110207998Seat Track · corrodedDURING C2 + 6 YEAR (HEAVY) CHECK VISIT IN MSP, EXTENSIVE CORROSION WAS FOUND AT FR20 ON THE FWD END OF RBL 23 CABIN SEAT TRACK P/N C02312798-003 WHICH EXCEEDS PDL LIMITS. REPLACED SEAT TRACK PER ER/A 629516-14. (LP 1283324)SDR DALA2025110207997Wire · damagedWHILE PERFORMING WAKE UP CHECK LIST FOUND MULTIPLE SEAT MOUNTED EMERGENCY LIGHTS INOP IN SR 15-20 ABD 30-37. FOUND SHORT AT SEAT ROW 20ABC, REPAIRED WIRE AT CONNECTOR SEAT IAW A321 ESPM 20-53-55 AND ASM 33-51-02. (LP 1283846)SDR REXA2026072701135Support · corrodedCORROSION ON SETTLEMENT AREA OF BODY FAIRING SUPPORTS BTW FS881.00 AND FS 847.00. CORROSION ON SEATTLEMENT AREA OF BODY FAIRING SUPPORTS BTW FS881.00 TO FS 847.00 +16.00 WAS REMOVED PER CRJ/900 SRM 51-21-06-001-001-A01 AND WERE EVALUATED WITHIN LIMITS PER CRJ-SDR REXA2026051200570Web · crackedCRACK ON LT ELECTRICAL BAY WEB FLOOR FS 193.00 (BELOW ACCUMULATOR GAUGE INDICATOR) AT FWD EQUIPMENT COMPARTMENT LH ELECTRICAL BAY WEB FLOOR FS 193.00 (BELOW ACCUMULATOR GAUGE INDICATOR) AT FWD EQUIPMENT COMPARTMENT WAS REPAIRED PER EA NO: CRJ953-20697 REV. B ASDR REXA2026051200568Channel · corrodedCORROSION ON SUPPORTS OF SETTLEMENT AREA RT AND LT SIDE OF BINS WHEEL CORROSION ON SUPPORTS OF SEATTLEMENT AREA RT AND LT SIDE OF BINS WHEEL WAS REMOVED IAW SRM 51-21-06-001-001-A01 AND EVALUATED WITHIN OF LIMITS IAW SRM 53-00-00-101-001-A01.SDR REXA2026051200558Angle · crackedCRACK ON WING TO FUSELAGE AFT FAIRING SUPPORT STRUCTURE AT FS849, LBL17'' WING TO FUSELAGE AFT FAIRING SUPPORT STRUCTURE AT FS849, LBL17' WAS REPAIRED PER EA CRJ953-20683 REV. IRSDR REXA2026051200557Doubler · crackedINITIAL INSPECTION: CRACK ON RH ELECTRICAL BAY FLOOR WEB FS 193.00 (BELOW ADG SUPPORT DOUBLER) AT FWD ACCESORY COMPARTMENT RH ELECTRICAL BAY FLOOR WEB FS 193.00 (BELOW ADG SUPPORT DOUBLER) AT FWD ACCESORY COMPARTMENT WAS FABRICATED PER CRJ-900 SRM-53-11-43-20SDR REXA2026051200556Web · corrodedOUT OF SCOPE': CORROSION AT SERVICE DOOR LOWER SILL, FLOOR PROTECTOR WEBS (4 EAS), LOWER SILL ANGLE, PROTECTOR PLATES & STRIKER SEAL. PROTECTOR PLATES, FLOOR PROTECTOR WEB (2EAS) AND LOWER SILL ANGLE WERE CLEANED AND NOT DAMAGE WAS FOUND PER CRJ900 SRM 51-26-0SDR REXA2026051200555Angle · corrodedOUT OF SCOPE: CORROSION AT SERVICE DOOR LOWER SILL, FLOOR PROTECTOR WEBS (4 EAS), LOWER SILL ANGLE, PROTECTOR PLATES & STRIKER SEAL. PROTECTOR PLATES, FLOOR PROTECTOR WEB (2EAS) AND LOWER SILL ANGLE WERE CLEANED AND NOT DAMAGE WAS FOUND PER CRJ900 SRM 51-26-00SDR REXA2026051200553Seat Track · corrodedCORROSION AT PASSENGER SEAT TRACK, LBL 9, RBL 9 & LBL 27, BTW 349 TO FS 469.00. (INCLUDED SEAT TRACK FITTING). CORROSION AT PASSENGER SEAT TRACK, LBL 9, RBL 9 & LBL 27, BTW 349 TO FS 469.00. WAS EVALUATED OUT OF LIMITS PER CRJ-900 SRM 53-21-49-101-001-A01 THESDR REXA2026051200551Bracket · corrodedCORROSION ON RT & LT MLG HYDRAULIC LINES SUPPORT PLATE (IN BK, LG EXT, LG RET) ON WHEEL WELL AREA, RBL 45/LBL 45. CORROSION ON LH MLG HYDRAULIC LINES SUPPORT PLATE WAS REMOVED AND EVALUATED WITHIN OF LIMITS PER CRJ-900 SRM 51-21-06-001-001-A01, CRJ-900 SRM 53-SDR SWIA202602275372Skin · corrodedCORROSION FOUND ON INNER FUSELAGE BELLY SKIN 2 INCHES FWD OF BS 265 RIGHT NEXT TO STR 27. COMPLIED REO 670-53-11-2208, REV-. DISPOSITION FOR BLENDED CORROSION DAMAGE TO FUSELAGE SKIN PANEL NEAR BS 265 BTWN STR 26R-STR27. PERFORMED EDDY CURRENT INSPECTION WISDR SWI2026F00061Intercostal · crackedFS 621-625 INTERCOSTAL CLIP IS CRACKED AT STRG 13L. REPLACED INTERCOSTAL CLIP AT FS 621 - 625 STR 13L IAW CRJ 200 SRM 51-42-06, COMPLETED SKYWEST TASK CARD 51-900-1003-SKY AND ATTACHED COMPLETED FORM 337. NO WEIGHT CHANGE NOTEDSDR SWIA20260112031Intercostal · crackedFS 621-625 INTERCOSTAL CLIP IS CRACKED AT STRG 14L. REMOVED FS 621-625 INTERCOSTAL CLIP AND FABRICATED AND INSTALLED A NEW CLIP P/N 601R350121-3 IAW BOMBARDIER DRAWING 601R350121 REV A CRJ 200 SRM 51-24-21 HEAT TREATED IT IAW CRJ 200 SRM 51-24-06 DRILLED AND SDR SWIA2026010531Door · corrodedLOW PRESSURE GROUND AIR DOOR FWD INTERNAL STRUCTURE IS CORRODED. REMOVED FWD ANGLE IAW SRM 51-42-06 AND INSTALLED NEW FWD ANGLE IAW SRM 51-42-06. PERFORMED LEAK CHECK GOOD.SDR AALA202512308660Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK SHEAR PLATE STR 23R BTW FR69 AND FR70 AT AFT GALLEY AREA ,MEASURE OF CRACK IS 1.735 INCH. MAINTENANCE REPLACED SHEAR PLATE LOC. AT LEVEL STR 23R BTW FR69 AND FR70 AT AFT GALLEY AREA IAW A319 SRM 51-42-11-801 AND DWG D5347418SDR AALA202512237648Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK SHEAR PLATE STR 23 L BTW FR69 AND FR70 AT AFT GALLEY AREA L=0.976 INCH. MAINTENANCE REPLACED SHEAR PLATE LOCATED BTW FR69 AND FR70 STR23 LEFT AT AFT GALLEY AREA IAW A319 SRM 51-42-11-801 AND DWG D53474180.SDR SWIA20251223031Stringer · corrodedUNDER FLOOR FROM BS 280 TO 409, S23R WAS CORRODED. REPAIRED STRINGER 23R FROM BS 280 - 349 IAW SRM 53-00-03-02, SRM 51-42-06, & 51-42-21.SDR AALA202512181903Doubler · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON EXTERNAL FUSELAGE SKIN PANEL DOUBLER BETWEEN FR 56 AND FR 57 AT S41L. REPAIRED SKIN PANEL PER EA 370128.SDR REXA2025121201037Angle · crackedCRACK ON LEFT VERTICAL STABILIZER TO FUSELAGE ATTACHMENT FWD & AFT DRAG ANGLE BTW 55.625% STGR DATUM TO 67.5% REAR SPAR DATUM (TRACE AT BL0.00). LEFT VERTICAL STABILIZER TO FUSELAGE ATTACHMENT FWD & AFT DRAG ANGLE BTW 55.625% STGR DATUM TO 67.5% REAR SPAR DATUSDR REXA2025121201036Angle · crackedCRACK ON RIGHT VERTICAL STABILIZER TO FUSELAGE ATTACHMENT FWD & AFT DRAG ANGLE BTW 55.625% STGR DATUM TO 67.5% REAR SPAR DATUM (TRACE AT BL0.00). RIGHT VERTICAL STABILIZER TO FUSELAGE ATTACHMENT FWD & AFT DRAG ANGLE BTW 55.625% STGR DATUM TO 67.5% REAR SPAR DASDR REXA2025121201034Support · crackedCRACK ON WING TO FUSELAGE AFT FAIRING SUPPORT STRUCTURE AT FS849, LBL17'' WING TO FUSELAGE AFT FAIRING SUPPORT STRUCTURE AT FS849, LBL17'' WAS REPAIRED PER EA CRJ953-20784 REV IR.SDR REXA2025121201033Channel · corrodedCORROSION AT LT / RT P-SEAL GANG CHANNELS AND ATTACHED RETAINERS WS10-WS14.T (NUT CHANNEL, 2 EAS, BOTH SIDES LH/RH) LH P-SEAL GANG CHANNELS AND ATTACHED RETAINER WS10-WS14.T (NUT CHANNEL,1EA, SIDE LH) WAS REPLACED PER CRJ900 SRM 51-42-06-001-001-A01 AND RH P-SSDR REXA2025121201031Rib · crackedCRACK ON MACHINED RIB LEADING EDGE SS57.16 AT LEFT WING. MACHINED RIB LEADING EDGE SS57.16 AT LEFT WING WAS REPAIRED PER REO 690-57-41-240 REV - -SDR REXA2025121201030Support · crackedCRACK ON RH FWD CORNER TO SUPPORT OF THE JB6 AT FWD EQUIPMENT COMPARTMENT. RH FWD CORNER TO SUPPORT OF THE JB6 AT FWD EQUIPMENT COMPARTMENT WAS REPLACED PER CRJ 900 SRM 51-42-06-001-001-A01SDR REXA2025121201029Floorbeam · crackedCRACK ON UNION ANGLES OF CROSS BEAM AND LONGITUDINAL BEAM BTW FS 280.00 AND RBL 12 AND LBL 12 AT PASSENGER FLOOR STRUCTURE UNION ANGLES OF CROSS BEAM AND LONGITUDINAL BEAM BTW FS 280.00 AND RBL 12 AND LBL 12 AT PASSENGER FLOOR STRUCTURE WERE REPLACED PER CRJ-9SDR REXA2025121201028Stringer · corrodedCORROSION ON STGR 20RH BTW FS349.00 TO FS379.00 AT MAIN AVIONICS COMPARTMENT STGR 20RH BTW FS349.00 TO FS379.00 AT MAIN AVIONICS COMPARTMENT WAS REPAIRED PER EA CRJ953-20756 REV. IRSDR REXA2025121201027Rib · crackedCRACK ON MACHINED RIB LEADING EDGE SS57.16 AT RIGHT WING MACHINED RIB LEADING EDGE SS57.16 AT RIGHT WING WAS REPLACED PER CRJ 900 SRM 51-42-21-001-001-A01 AND SRM 51-42-10-001-001-A01SDR REXA2025121201024Bulkhead Web · corrodedCORROSION ON LOWER WEB OF AFT FACE OF THE BULKHEAD ASSY ON FS 280.00 RH SIDE LOWER WEB OF AFT FACE OF THE BULKHEAD ASSY ON FS 280.00 RH SIDE WAS EVALAUTED PER CRJ900 SRM 53-00-00-101-001-A01 AND IT WAS REPAIRED PER CRJ900 SRM 53-11-10-201-004-A01SDR REXA2025121201022Stringer Splice · corrodedCORROSION ON INTERNAL FUSELAGE STRUCTURE OVER STGR23L SPLICE BTW FS469.00 / FS485.00 AT FWD BAGGAGE COMPARTMENT INTERNAL FUSELAGE STRUCTURE OVER STGR23L SPLICE BTW FS469.00 / FS485.00 AT FWD BAGGAGE COMPARTMENTWAS REPLACED PER CRJ900 SRM 51-42-06-001-001-A01 ASDR REXA2025121201021Floorbeam · corrodedCORROSION ON LH BEAM OVER FS 280.00 AT PASSENGER FLOOR STRUCTURE LH BEAM OVER FS 280.00 AT PASSENGER FLOOR STRUCTURE WAS REPLACED PER CRJ900 SRM 51-42-21-001-001-A01 AND CRJ900 SRM 51-42-06-001-001-A01SDR REXA2025121201020Bulkhead Web · corrodedCORROSION ON LOWER WEB OF AFT FACE OF THE BULKHEAD ASSY ON FS 280.00 LH SIDE LOWER WEB OF AFT FACE OF THE BULKHEAD ASSY ON FS 280.00 WAS REPAIRED PER CRJ900 SRM 53-11-10-201-004-A01SDR REXA2025121201018Floorbeam · corrodedSECONDARY NRC: AFTER ANGLE FLOOR SUPPORT REMOVAL, CORROSION WAS FOUND ON RH BEAM OVER FS 280.00 AT PASSENGER FLOOR STRUCTURE, IN REF. TO NRC 00259. AFTER ANGLE FLOOR SUPPORT REMOVAL, CORROSION WAS FOUND ON RH BEAM OVER FS 280.00 AT PASSENGER FLOOR STRUCTURE, SDR SWAA2025120930608Light · brokenBROKEN PHOTOLUMINESCENT STRIPS RT AT PASSENGER CABIN ( 6 EA). REPLACED PHOTOLUMINESCENT STRIP IAW AMM-33-51-15-400-802.SDR SWAA2025120930609Light · crackedCRACKED PHOTOLUMINESCENT STRIPS LT IN PASSENGER CABIN (5 EA). REPLACED PHOTOLUMINESCENT STRIP AT LT PASSENGER CABIN (5 EA) IAW AMM-33-51-15-400-802SDR SWAA2025120430613Strap · corrodedCORRODED STRAP, WL154 BETWEEN BS 794 - 794 + 5 INCHES, RBL 21 IN AFT CARGO BAY. REPLACED THE STRAP AND FASTENERS IAW SRM 51-40-02-0G-0 AND DWG 146A8340, SHEET 21, REV-.SDR SWAA2025120430610Support · corrodedCORRODED SUPPORT ZEE, WL 156 BETWEEN BS 727C + 10 INCHES - BS 787 + 10 INCHES, LBL 22, S25L IN THE AFT CARGO BAY. PERFORMED REPAIR ON THE SUPPORT, BS 727+4 TO BS 847 IAW SRM 53-00-53-2R-6, REPAIR 6.SDR SWAA2025120430612Web · corrodedCORRODED SHIELD WEB, WL156 BETWEEN BS 767 - 794, RBL 22, S25R IN AFT CARGO. REPLACED THE SHIELD WEB IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 146A0081, SHEET 31, REV -.SDR SWAA2025120430614Sill Drain · corrodedCORRODED LOWER SILL DRAIN, WL 156, BS 794 - 847, RBL 22, S25R IN THE AFT CARGO BAY. REPLACED THE LOWER SILL DRAIN IAW SRM 51-40-02, AND DWG 146A8340, SHEET 21, REV -.SDR SWAA2025120430617Nut Plate · crackedCRACK RAIL NUT PLATES, LEADING EDGE INTERNAL CAVITY LOCATED OF SS 499, LT WING. REPLACED RAIL NUT PLATES ON LEADING EDGE INTERNAL CAVITY LOCATED OFSS499, LT WING; IAW 51-40-02, DWG 112A4402, SHEET 13, REV - CRACK LENGTH: 0.449 IN.SDR VNAA20251204018Rib · crackedCRACK ON OTBD MACHINED RIB OF WS 163.00 TRAILING EDGE AT LH AND RH WING CORRECTIVE ACTION: CRACK ON OTBD MACHINED RIB OF WS 163.00 TRAILING EDGE AT LH AND RH WING WERE REPAIRED PER REO 690-57-51-488 REV. - AND REO 690-57-51-487 REV. - -SDR VNAA20251204012Roller Guide · wornWEAR ON ROLLER GUIDE (FWD DOOR TRACK LOWER SIDE) AT AFT BAGGAGE-BAY. CORRECTIVE ACTION: WAS EVALUATED, DUE TO EXCESSIVE DAMAGE ON ROLLER GUIDE (FWD DOOR TRACK LOWER SIDE) AT AFT BAGGAGE-BAY PER CRJ-900 SRM 53-00-01-101-001-A01 AND REPLACED PER CRJ/900 SRM 51-4SDR JJBA20251204006Shear Tie · crackedLEFT FR 73 BTW STR 8L-10L, SHEAR TIE FOUND CRACKED. CRACKED LT FR 73 SHEAR TIE BTW STR 8L-10L REMOVED AND INSTALLED.SDR SWAA2025120330615Intercostal · corrodedCORRODED WEB, INTERCOSTAL LOCATED WL 154, BS 794 - 847, RBL 21 IN THE AFT CARGO BAY. REPLACED THE WEB - INTERCOSTAL AND FASTENERS IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 146A8120, SHEET 34, REV -.SDR SWAA2025120330611Support · corrodedCORROSION SUPPORT ZEE LOCATED WL 156 BETWEEN BS 727 - 767, RBL 22, S25R IN THE AFT CARGO COMPARTMENT. REPLACED SUPPORT ZEE IAW SRM 51-40-02, & DWG 146A7500, SHEET 85, REV A.SDR SWAA2025120130501Intercostal · corrodedCORRODED INTERCOSTAL FL SEAL, BS 1016, BETWEEN LBL10 - LBL 8.39. REPLACED INTERCOSTAL FL SEAL AND FASTENERS IAW SRM 51-40-02, SRM 51-10-02, AND DWG 148A0922, SHEET 20, REV -.SDR SWAA2025120130518Plate · crackedRIGHT WING T/E WIGGLE PLATE COMMON TO PANEL 651EB ON THE I/B SIDE IS CRACKED. REMOVED AND REPLACED THE RT WING T/E WIGGLE PLATE COMMON TO PANEL 651EB ON THE INBD SIDE IAW SRM 51-40-02, AND DWG 115A2781, REV B.SDR IPXA2025112157102Strap · corrodedWORKING FAULT T3F18E007KJYV LINE 920 STA 879 FLOOR BEAM FOUND CORROSION ON LWR. FWD STRAP ATA-53-05.FABRICATED STRAP P/N 143N5553-1SAAU FOR LWR FWD FLOOR BEAM, IAW DWG 143N5553. WORK ACCOMPLISHED ON TRAVELER #7003269899