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 REXA2026052800862Intercostal · corrodedCORROSION ON INTERCOSTAL AT STGR 20RH BTW FS333.00 TO FS 349.00 DUE TO EXCESIVE CORROSION ON INTERCOSTAL AT STGR 20RH BTW FS333.00 TO FS 349.00 WAS REPLACED PER CRJ900 SRM 53-21-23-101-002-A02, SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01SDR REXA2026051200567Angle · crackedCORROSION ON SILL AND ANGLE KICKPLATE AT PASSENGER DOOR SURROUND. ANGLE KICKPLATE AT PASSENGER DOOR SURROUND WAS REPLACED PER SRM 51-21-06-001-001-A01, SRM 53-21-23-101-001-A02 AND SILL WAS CLEANED PER SRM 51-26-00-001-001-A01 AND NOT DAMAGE WAS FOUND.SDR REXA2026051200541Beam · corrodedSECONDARY NRC FROM NRC 00244 - AFTER PAINT REMOVAL, CORROSION AT TRANSVERSAL BEAM, FS 333.00, BTW BL 0.0 & RBL 27 TRANSVERSAL BEAM, FS 333.00, BTW BL 0.0 & RBL 27 WAS REPAIRED PER EA NO: CRJ953-20738 REV. ASDR REXA2026051200540Skin · wornWEAR ON EXTERNAL FUSELAGE SKIN FS913.00 TP FS 927.00 BTW STGR 26LH TO STGR 26RH DISTRIBUTION DUCT FS913.00 TP FS 927.00 WAS REMOVED AND INSTALLED PER CRJ-900 AMM 21-23-38, LEAK TEST WAS PERFORMED PER CRJ-900 AMM 21-23-00. WEAR ON EXTERNAL FUSELAGE SKIN FS913.0SDR VNAA20260511023Skin · dentedTHE FUSELAGE SKIN HAS TWO DENTS BETWEEN FS 265 AND FS 280, STGR 27 AND 26L. REPAIRED DENTS IAW REO 670-53-11-2251 REV -- DATED 2026-01-19SDR SWIA2026030275394Skin · chafedRH WING IB FLAP LOWER SURFACE SKIN AT IB FLAP FAIRING LAND HAS SIGNS OF CHAFFING (C-CHECK RO 02/28/2026)REPAIRED DAMAGED SKIN ON RH INBD FLAP LOWER SURFACE IAW BOMBARDIER REO 670-57-52-160 REV-A DATE 2016-10-21 AND CRJ700 550 SERIES SRM 51-26-01, 57-52-01, 5SDR SWIA202602275375Bracket · crackedBS 280 STICK PUSHER BRACKET CRACKED. REMOVED AND REPLACED THE RT FWD BS 280 STICK PUSHER BRACKET IAW SRM 51-42-06.SDR 3EJA202601143025Thrust Reverser · faultedAT ABOUT 14,000 FEET. THE THRUST REVERSER ARM LIGHT CAME ON, WITH ASSOCIATED MASTER CAUTION, AND MASTER WARNING, AND HYDRAULIC PRESSURE. TROUBLE SHOT THRUST REVERSER SYS AND COULD NOT DUPLICATE ISSUESDR 3EJA202601140001Switch · failedAT ROTATION ACM OVERHEAT ANNUNCIATOR ILLUMINATED WITH MASTER CAUTION. REMOVED ECU OVERTEMP SWITCH AND REPLACED WITH A NEW SWITCH IAW AMM 21-51-01. REMOVED OTBD ACM EXHAUST DUCT AND REPLACED WITH A SERVICEABLE DUCT IAW AMM 21-51-00. REMOVED ACM EXHAUST ELBOW SDR SWIA20260112030Vane · chafedRIGHT INBD FLAP, FLAP VANE LEADING EDGE HAS CHAFE DAMAGE AT (3EA) LOCATIONS. REPAIRED CHAFES ON RH INBOARD FLAP VANE LEADING EDGE INBD AND OTBD LOCATIONS IAW BOMBARDIER REO 601R-57-52-004 THEY WERE WITHIN LIMITS, MID LEADING EDGE WAS OUT OF LIMITS REMOVED ANDSDR CALA2025122212290Shield · corrodedAFT CARGO BAY SHIELD BTW BS 767 - 787 HAS CORROSION. REMOVED AND REPLACED THE DAMAGE AFT CARGO COMPARTMENT SHIELD IAW SRM 51-40-02-0G.SDR AALA202512160005Attach Fitting · wornAIRCRAFT IN BASE MAINTENANCE: NOSE LANDING GEAR LEG DOOR IS LOOSE. REPLACED LEG DOOR ATTACH FITTING ON THE NOSE LANDING GEAR DOOR IAW AMM 32-22-15.SDR SWAA2025121030190Vapor Barrier · crackedCRACK VAPOR BARRIER WEB, BS 663.75, BTW RBL 25 - 35. REPAIRED THE VAPOR BARRIER WEB IAW SRM 51-70-04-2R-10, REPAIR 10.SDR AALA202512091284Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE, CRACK IN FLOORBEAM LOCATED AT BS 540 BETWEEN LBL 1 AND LBL 24. REPLACED FLOORBEAM IAW AARD 51-00-05-01.SDR AALA202512065874Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT BS 540 FROM RBL 1 TO RBL 24. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR SWAA2025120430196Rib · crackedCRACKED INSPAR RIB, HSS 120.30 29 INCHES FROM SPAR, LT HORIZONTAL STAB. PERFORMED PERMANENT REPAIR ON INSPAR RIB LOCATED STAB STA 120.30 29 INCHES OF FROM SPAR LT HORIZONTAL STAB IAW B737-700 EA 25-155-03220-WIP1 SUMMARY EA 25-155-03220.SDR VNAA20251204016Skin · corrodedCORROSION ON CUTOUT STRUCTURE OF AVONICS COMPARTMENT DOOR. REPAIRED IAW REO 690-53-21-032 REV --SDR VNAA20251204015Web · crackedCRACK ON WEB LH SIDE AND WEB RH SIDE (BELOW ADG SUPPORT DOUBLER) FS193 AT FWD ELECTRICAL BAY. CRACK ON WEB LH SIDE AND WEB RH SIDE (BELOW ADG SUPPORT DOUBLER) FS193 AT FWD ELECTRICAL BAY WERE REPAIRED PER CRJ900 SRM 53-11-43-201-001-A01SDR VNAA20251204014Stringer · corrodedCORROSION ON STGR 24RH AND 23RH BTW FS280 TO FS295 AT MAIN AVIONICS COMPARTMENT. WERE EVALUATED, VISUAL INSPECTION OF STGR 23RH BTW FS280 TO FS295 AT MAIN AVIONICS COMPARTMENT WAS PERFORMED PER CRJ 900 NDT MANUAL 51-20-009-210. NO CORROSION FOUND AFTER REMOVSDR SWAA2025120130385Bulkhead · crackedBS 663 LOWER COMPOSITE BULKHEAD IS CRACKED AT LBL 45, WL 173. THE COMPOSITE BULKHEAD WAS REPAIRED IAW SRM 51-70-04-2R-10.SDR SWAA2025120130272Stringer · corrodedCORROSION ON STRINGER 25R, BETWEEN BS 360 - 380, WL156 IN E & E BAY. PERFORMED PERMANENT REPAIR ON THE STRINGER IAW SRM 53-00-03-2R-1, REPAIR 1.SDR SWAA2025120130273Angle · corrodedCORRODED ANGLE, BETWEEN BS 351.2 - 360, S28L, WL 148.8. REPLACED THE ANGLE IAW SRM 51-40-02, SRM 51-10-02, AND DWG 140A9101, SHEET 23, SHEET 26, REV -.SDR HNAA2025120100846Seat Track · corrodedRIGHT INBD SEAT TRACK CORRODED AT BTW FR 36-47. R & R SEAT TRACK IAW AMM 53-01-06.SDR AALA202511250995Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING ON FWD FITTING MLG DOOR LH. MAINTENANCE REPLACED FWD HINGE FITTING MLG DOOR LH IAW AIRBUS CMM 52-81-18.SDR AALA202511252512Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING MLG DOOR RH FWD ATTACHMENT. MAINTENANCE REPLACED FWD HINGE FITTING MLG DOOR RH IAW AIRBUS CMM 52-81-18.SDR HNAA2025112500820Shear Tie · crackedSTRINGER 15-16R SHEAR CLIP CRACKED AT FRAME 25. RAR SHEAR CLIP ON FR25 BTWN STGR 15R-16R IAW EMB 145 SRM 51-40-02SDR HNAA2025112500819Floor Support · corrodedLEFT OMEGA BEAM CENTER FLOORBOARD SUPPORT AND RH SIDE OF BEAM HAS CORROSION BETWEEN FRAMES 24-27. BLENDED OUT CORROSION ON LH OMEGA BEAM CENTER FLOORBOARD SUPPORT AND RH SIDE OF BEAM BETWEEN FRAMES 24-27 IAW EMB 145 SRM 51-10-03. REMAINING THICKNESS AT BLENDESDR HNAA2025112500806Seat Track · corrodedLEFT UPPER SEAT TRACK #3 HAS CORROSION. RAR LH #3 UPPER SEAT TRACK IAW EMB 145 AMM 53-01-06SDR HNAA2025112500805Seat Track · corrodedLEFT UPPER SEAT TRACK #2 HAS CORROSION. RAR LH UPPER SEAT TRACKS # 2 IAW EMB 145 AMM 53-01-06SDR HNAA2025112500803Floor Support · corrodedLEFT OUTBD FLOOR SILL #2 IS CORRODED. REMOVED AND REPLACED LH #2 FLOOR SILL IAW EMB 145 SRM 51-40-02SDR HNAA2025112500801Floor Support · corrodedRIGHT OUTBD FLOOR SILL NR 1 IS CORRODED. R & R RT NR 1 OTBD FLOOR SILL IAW SRM 51-40-02.SDR CALA2025112111386Channel · corrodedFWD CARGO COMPARTMENT RT ZEE CHANNEL POSSIBLE CORROSION BTW BS 500D - 500L. REMOVED, FABRICATED, LOCATED, DRILLED, AND PERFORMED COUTERSINK ON FWD CARGO RT ZEE CHANNEL. APPLIED ALODINE A ND PRIMER ALL WORK DONE IAW SRM 51-40-02-0G-0, 53- 00-53-2R-5, 51-40-0SDR CALA2025112111384Shield · corrodedAFT CARGO, FOUND MULTIPLE POINTS OF CORROSION ON RT SHIELD, BTW BS 767 - 787, REMOVED AND INSTALLED NEW SHIELD ON AFT CARGO COMPARMENT BTW BS 767 - 787, STRINGER 25 IAW SRM 51-40-05-0G-0, SRM 51-40-08-0G-0, AND 51-40-02-0G-0. ALL WORK PERFORMED CAPTURED ONSDR SWAA2025112030269Seat Track · crackedSEAT TRACK NR 4 ATTACH BRACKET CRACKED ON BOTH INBD & OTBD RADII BS 727B UNDER FLOORBOARD 242DF. HFEC VERIFIED THE ATTACHED BRACKET IS CRACKED IAW NDT PART 6; 51-00-00 PROCEDURE 23. REMOVED AND REPLACED SPLICE STRAP BRACKET IAW SRM 51-10-02, AND SRM 51-40SDR SWAA2025112030268Attach Bracket · crackedSEAT TRACK NR 1 ATTACH BRACKET CRACKED ON BOTH INBD & OTBD RADII AT BS 727B UNDER FLOORBOARD 241FF. HFEC VERIFIED THE ATTACHED BRACKET IS CRACKED AT BOTH LOCATIONS IAW NDT PART 6; 51-00-00, PROCEDURE 23. REMOVED DAMAGED SPLICE STRAP BRACKET AT BS 727B, LBLSDR R61A2025112000515Skin · gougedLH WING LEADING EDGE HAS GOUGES AT SLAT #4 SKEW SENSOR. REPAIRED LH WING LEADING EDGE PER ETD2025-170-931502.SDR R61A2025112000514Frame · corrodedFRAME 88 AT STGR 27L-28R CORRODED. REMOVED AND REPLACED LOWER CENTER SECTION STGR 25L-26R IAW SRM 51-40-08SDR JJBA20251120084Floorbeam · corrodedMID FLOOR BEAM GUSSET AT FR 73, STR 1R, HAS CORROSION. REMOVED AND REPLACED MID FLOOR BEAM GUSSET AT FR73.SDR HNAA202511200782Floor Support · crackedF081154 LH OMEGA BEAM CRACKED AT THE FR27 SUPPORT. PERFORMED PERMANENT REPAIR OF CRACKED LH OMEGA BEAM AT THE FRAME 27 SUPPORT IAW PIEDMONT EO1-53-25-0384 AND ETD2025-145-931299.SDR HNAA2025112000781Floor Support · crackedLH OMEGA BEAM CRACKED AT THE FR26 SUPPORT. REPAIRED THE LH OMEGA BEAM CRACKED AT THE FR26 SUPPORT IAW EMBRAER ETD2025-145-931300 REV A AND PIEDMONT EO1-53-25-0383.SDR SWAA2025111830014Scuff Plate · crackedCRACK FWD POSITION CORNER SCUFF PLATE CUT OUT DOOR AT FWD CARGO BAY. REPAIRED FWD POSITION CORNER SCUFF PLATE CUT OUT DOOR IAW SRM 53-30-15-2R-1, REPAIR 1, & BAC 5975.SDR SWAA2025111830197Floorbeam · crackedCRACKED PLATE ON FLOORBEAM LOCATED BS 540 BETWEEN BL 0 TO RBL 24.75. REPLACED PLATE ON THE FLOORBEAM IAW SRM 51-40-02 AND DRAWING 143A0060, SHEET 36, REV A.SDR SWAA2025111830200Stiffener · crackedCRACKED FLOORBEAM LOCATED BS540 BETWEEN BL 0 TO LBL 24.75. REPLACED THE FLOORBEAM IAW SRM 51-40-02 AND DRAWING 143A0060, SHEET 36, REV A.SDR SWAA2025111830407Lens · brokenBROKEN EMERGENCY LIGHT LENS ON SIDEWALL PANEL 242YAW AT PASSENGER CABIN. REPLACED EMERGENCY LIGHT LENS ON SIDEWALL PANEL 242YAW AT PASSENGER CABIN IAW AMM 33-51-01-960-802 OPS TESTED OK.SDR SWAA2025111730206Skin · crackedCRACK ON LH LOWER HORIZONTAL STABILIZER SKIN. AT STAB STA 193.90; 26' FROM FWD EDGE; .4' LENGTH. REPAIRED LT LOWER HORIZONTAL STABILIZER SKIN. AT STAB STA 193.90 PER REF SRM 55-10-01-2R-11. VERIFIED COMPLETED RII STEPS IN CORRECTIVE ACTION 1.SDR SWAA2025111730043Panel · damagedPANEL 661CB HAS SEVERAL ELONGATED FASTENER HOLES. PANEL 661CB WITH SEVERAL ELONGATED FASTENER HOLES WAS REPAIRED PER. SRM 51-70-04-2R-9.SDR IPXA2025111135069Skin · corrodedLEFT WING HAS DISBOND PLY ON LOWER SURFACE OF THE OUTBOARD TRAILING EDGE COVERED BY SPEED TAPE. INSTALLED NEW EXTRUSION (SECTION PANEL TRAILING EDGE) AT LT WING O/B IAW SRM 51-40-21. REMOVED CORROSION AT ALUMINUM EXTRUSION IAW SRM 51-74-10. FOUND TO BE OUT LISDR AALA202511134290Splice · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LEFT PASSENGER, CREW DOOR CUTOUT LOWER SILL UPPER INBOARD SPLICE AT FR 66 AND S23L. REPLACED SPLICE PER SRM 51-42-11.SDR AALA202511131224Splice · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LEFT PASSENGER / CREW DOOR CUTOUT LOWER SILL UPPER OUTBOARD SPLICE AT FR 66 AND S23L. REPLACED SPLICE PER SRM 51-42-11.SDR CALA2025111211141Skin · corrodedRIGHT WING LEADING EDGE LOWER SKIN UPPER SURFACE FROM OFSS 706 TO 696 HAS CORROSION. ACCOMPLISHED INTERIM REPAIR FOR CORROSION ON RT WING LOWER SKIN PANEL FORWARD OF FRONT SPAR BETWEEN OFSS 692 AND OFSS 704 IAW ECRA 5724-01040 REV A, PART 1.