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 DALA2025120108746Inlet · contaminatedON APPROACH CREW REPORTED A CHEMICAL/OIL/SWEET BAKED GOODS IN COCKPIT AND CABIN. FOUND OIL IN NR 1 ENGINE INLET CONE. REPLACED FAN SHAFT COVER PACKING IN IAW WITH A321 AMM 72-15-00 AND PERFORMED WATER WASH. (LP 8118610)SDR DALA2025120108745Spinner · contaminatedDIRTY SOCK SMELL REPORTED IN CABIN ON DESCENT. FOUND RESIDUE IN NBR 2 ENG SPINNER. REPLACED NBR 2 ENG FAN SHAFT SEAL IAW A321 AMM 72-11-01. (LP 8139172)SDR VNAA202511290040Hinge Fitting · corrodedAILERON CORROSION WAS FOUND AT CENTER HINGES LUGS #R1, #R2, #R3, #R4 AND #R5. CENTER HINGE FITTING BORES LUGS R 1 AND R 2 OF AILERON RH WERE CLEANED NOT WAS FOUND CORROSION PER CRJ 700 SRM 51-26-00-001-001-A01 CLEANING, HINGE FITTING AILERON RH BORE LUG R 5 WSDR VNAA202511290039Hinge Fitting · corrodedLEFT AILERON BUSHINGS CORROSION WAS FOUND AT CENTER HINGES LUGS #L1,#L2, #L4,#L5 AND #L6(5 EA´S). BORES LUGS L 1 AND L 6 OF AILERON LH WERE CLEANED NOT WAS FOUND CORROSION PER CRJ 700 SRM 51-26-00-001-001-A01 CLEANING, HINGE FITTING AILERON LH BORES LUGS L 2SDR VNAA202511290038Crossbeam · elongatedSEVERAL ELONGATE HOLES ON ANGLE LOWER SPLICE OF CROSS BEAM FS280. ANGLE LOWER SPLICE OF CROSS BEAM FS280.00 WAS REPLACED PER CRJ-700 SRM 51-42-06-001-001-A01SDR VNAA202511290037Support Angle · corrodedCORROSION ON MID CAP ANGLE SUPPORT WAS FOUND. MID CAP ANGLE SUPPORT WAS REPLACED PER SRM 51-42-06-001-001-A01.SDR VNAA202511290036Crossbeam · corrodedCORROSION ON RH CROSSBEAM AT FS280.00 WAS FOUND AT CPAX FLOOR STRUCTURE. RT CROSSBEAM AT FS280.00 WAS FOUND AT CPAX FLOOR STRUCTURE WAS EVALUATED THEREFORE IS OUT LIMITS PER CRJ-700 SRM 53-21-43-101-001-A03 AND REPLACED PER CRJ-700 SRM 51-42-06-001-001-A01, SSDR VNAA202511290035Crossbeam · corrodedCORROSION ON LH CROSSBEAM AT FS280.00 WAS FOUND AT CPAX FLOOR STRUCTURE. CORROSION ON LH CROSSBEAM AT FS280.00 WAS FOUND AT CPAX FLOOR STRUCTURE WAS EVALUATED EXCESSIVE CORROSION PER CRJ-700 SRM 53-00-00-101- 001-A01 AND REPLACED PER CRJ-700 SRM 51-42-06-00SDR VNAA202511290034Skin · corrodedCORROSION ON EXTERNAL FUSELAGE SKIN BTW FS953.00 TO FS 969.00, STGR22R AND BTW FS939.00 TO FS953.00, STGR23R. EXTERNAL FUSELAGE SKIN BTW FS953.00 TO FS 969.00, STGR22R AND BTW FS939.00 TO FS953.00, STGR23R WAS REPAIRED PER REO 670-53-51-361 REV -.SDR VNAA202511290033Skin Panel · wornWEAR ON LH AND RH PANEL SKIN BTW FS 830-847 PROYECTION STRG 24-25RH AND 24-25LH AT EXTERNAL FUSELAGE. WEAR ON LH AND RH PANEL SKIN BTW FS 830-847 PROYECTION STRG 24-25RH AND 24-25LH AT EXTERNAL FUSELAGE WAS REPAIRED PER REO 670-53-42-142 REV: - - AND REO 670SDR VNAA202511290032Seat Track · corrodedCORROSION ON RT SEAT RAILS OF STGR 15RH IN FS375.00, FS377.00, FS390.00, FS398.00 TO FS404.00, FS437 TO FS450.00 AND FS552.00 AT PASSENGER CABIN.. CORROSION ON RH SEAT RAILS OF STGR 15RH IN FS375.00, FS377.00, FS390.00, FS398.00 TO FS404.00, FS437 TO FS450.00SDR VNAA2025120190031Frame · corrodedWEAR ON FRAME AND ON UPPER FRAME INNER ON FS349 BTW STGR0 AND STGR4LH AT PASSENGER COMPARTMENT. WEAR ON FRAME UPPER ON FS349 BTW STGR0 AND STGR4LH AT PASSENGER COMPARTMENT WAS BLEND OUT PER SRM 51-12-00-001-001- A01 AND EVALUATED WITHIN OF LIMITS PER CRJ700 SDR VNAA202511290030Access Panel · corrodedCORROSION AND WEAR ON ACCESS PANEL DOOR STEP OF L1 DOOR. SUMMARY: SKIN ACCESS PANEL DOOR STEP OF L1 DOOR WAS REPLACE PER CRJ-700 SRM 51-42-06-001-A01.SDR VNAA202511290029Seat Track · corrodedCORROSION, WEAR AND SCRATCHES ON THE SEAT RAILS - FS677.00 TO FS863.00 AND FS863.00 TO FS989.00, RBL9.00. CABIN. SEAT RAILS - FS677.00 TO FS863.00 AND FS863.00 TO FS989.00, RBL9.00. CABIN (2 EA'S) WERE EVALUATED OUT OF LIMITS PER CRJ-700 SRM 53-41-49-101-001-SDR VNAA2025120190028Seat Track · corrodedCORROSION, WEAR AND SCRATCHES ON THE SEAT RAIL - FS677.00 TO FS863.00 AND FS863.00 TO FS989.00, LBL9.00. CABIN. SEAT RAIL - FS677.00 TO FS863.00 AND FS863.00 TO FS989.00, LBL9.00. CABIN WERE EVALUATED OUT OF LIMITS PER CRJ-700 SRM 53-41-49-101-001-A01 AND RESDR VNAA2025120190027Stringer Clip · corrodedCORROSION ON STGR CLIPS (3 EAS) FS 985.00, FS 1015.00 AND FS 1031.00, STGR 20 LH AT AFT CARGO COMPARTMENT. CORROSION ON STGR CLIPS (3 EAS) FS 985.00, FS 1015.00 AND FS 1031.00, STGR 20 LH AT AFT CARGO COMPARTMENT WAS REMOVED PER SRM 51-21-06-001-001-A01 AND SDR VNAA202511290026Seat Track · corrodedCORROSION ON SEAT RAIL LBL9 BTW FS364 TO FS477 AT PAX CABIN. SEAT RAIL -FS364.00 TO FS467.00, LBL9.00. CABIN WERE EVALUATED OUT OF LIMITS PER CRJ-700 SRM 53-21-49-101-001-A01 AND REPLACED PER CRJ-700 AMM 53-00-49-400-801-A03SDR VNAA202511290023Seat Track · corrodedCORROSION ON SEAT RAIL LBL9 BTW FS517 TO FS581 AND BTW FS581 TO FS693 AT PAX CABIN. CORROSION ON SEAT RAIL LBL9 BTW FS517 TO FS581 AND BTW FS581 TO FS693 AT PAX CABIN WAS EVALUATED DUE TO EXCESSIVE DAMAGE PER CRJ-700 SRM 53-31-49-101-001-A01, AND SRM 53-41-49SDR SCNA20251201454Charger · inoperativeRIGHT EMERGENCY LIGHT AFT OF THE RH MAIN ENTRANCE DOOR (FWD) INOP. RELAMPED, NO HELP, PATCHED IN NEW LIGHT ASSEMBLE, NO HELP. PLACED LIGHT ON MEL 33-14 MDDR 135366. 819737-2 REMOVED AND REPLACED BATTERY AND CHARGER ASSY REF AMM 33-51-06. RELAMPED LIGHT ASSYSDR VNAA202511290022Seat Track · corrodedCORROSION ON SEAT RAIL RBL9 BTW FS349 TO FS485, BTW FS485 TO FS581 AND BTW FS581 TO FS677. CABIN. SEAT RAILS RBL9 BTW FS349 TO FS485, BTW FS485 TO FS581 AND BTW FS581 TO FS677. CABIN (3EA'S ) WERE EVALUATED OUT OF LIMITS PER CCRJ-700 SRM 53-21-49-101-001-A01SDR VNAA202511290021Crossbeam · corrodedCORROSION ON CROSSBEAM FS333 LBL24 AT PAX CABIN. CORROSION ON CROSSBEAM FS333 LBL24 AT PAX CABIN WAS REPAIRED PER REO 670-53-21-2728 REV - -.SDR VNAA202511290020Seat Track · corrodedCORROSION ON THE SIDE SEAT RAILS - FS674.50 TO FS713.00, FS713.00 TO FS761.00, FS785.15 TO FS860.50 AND FS860.50 TO FS977.00, STGR15R. CABIN. CORROSION ON THE SIDE SEAT RAILS - FS674.50 TO FS713.00, FS713.00 TO FS761.00, FS785.15 TO FS860.50 AND FS860.50 TO FSDR VNAA202511290019Seat Track · corrodedCORROSION ON THE SIDE SEAT RAIL - FS713.00 TO FS761.00, FS785.15 TO FS860.50 AND FS860.50 TO FS977.00, STGR15L. CABIN. CORROSION ON THE SIDE SEAT RAIL - FS713.00 TO FS761.00, FS785.15 TO FS860.50 AND FS860.50 TO FS977.00, STGR15L. CABIN WAS EVALUATED DUE TO ESDR VNAA202511290018Fitting · corrodedCORROSION ON GALLEY FLOOR FITTINGS AS FOLLOW: (8E/A) BTW FS280 AND FS320 AND BTW LBL42 AND RBL42, (1E/A) BTW FS349 AND FS364 ON RBL40; ALSO BROKEN NUT ON GALLEY FLOOR FITTING (1E/A) BTW FS349 AND FS364 ON RBL40 AT PASSENGER FLOOR STRUCTURE. GALLEY FLOOR FITTISDR VNAA202511290017Support Angle · corrodedCORROSION ON ANGLE SUPPORT ON FS280 BTW STGR26L AND STGR26R AT E/E COMPARTMENT. ANGLE SUPPORT ON FS280 BTW STGR26L AND STGR26R AT E/E COMPARTMENT WAS REPLACED PER CRJ 700 SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01SDR VNAA202511290016Post · corrodedCORROSION ON BULKHEAD FS280 LOWER POSTS; ON LBL11 ON POST AND ON PREVIOUS REPAIR ALSO ON RBL11 ON POST AT PASSENGER COMPARTMENT. CORROSION WAS REMOVED ON BULKHEAD FS280 LOWER POST RBL11 PER CRJ-700 SRM 51-21-06-001-001-A01 AND EVALUATED WITHIN OF LIMITS PER CSDR VNAA202511290015Bulkhead Web · corrodedCORROSION ON LOWER WEB OF BULKHEAD FS280, ON LBL11 AND BTW RBL11 AND RBL43 AT PASSENGER COMPARTMENT. PREVIOUS REPAIR ON LOWER WEB OF BULKHEAD FS280, BTW LBL43 & LBL11 AND BTW RBL11 & RBL43 AT PASSENGER COMPARTMENT WERE REPLACED PER CRJ-700 SRM 53-11-10-201-SDR VNAA202511290014Floor Support · corrodedCORROSION ON FLOOR PANEL SUPPORT ANGLE ON FS280 AT FLIGHT COMPARTMENT. FLOOR PANEL SUPPORT ANGLE ON FS280 AT FLIGHT COMPARTMENT WAS EVALUATED PER CRJ-700 SRM 53-51-06-101-003-A01 AND REPLACED PER CRJ-700 SRM 51-42-06-001-001-A01SDR VNAA202511290013Seat Track · corrodedCORROSION, WEAR AND SCRATCHES ON RH SEAT RAIL FROM STGR 15 RH FS 378.00 TO FS482.00, FROM FS 482.00 TO FS572.00, AND RAIL FROM FS572.00 TO FS661.00 AT PASSENGER CABIN. CORROSION ON RH SEAT RAIL FROM STGR 15 RH FROM FS572.00 TO FS661.00 AT PASSENGER CABIN WAS SDR VNAA202511290012Seat Track · corrodedCORROSION, WEAR AND SCRATCHES LH ON SEAT RAIL OF STGR 15LH: FROM FS 378.00 TO FS482.00, FROM FS 482.00 TO FS572.00, RAIL FROM FS 572.00 TO FS674.00, FROM FS 674.00 TO FS712.00 AT PASSENGER CABIN
SUMMARY: CORROSION, WEAR AND SCRATCHES LH ON SEAT RAIL OF STGR 1SDR VNAA202511290011Frame · crackedCRACK ON FRAME STA 333 BTW STGR 2R - 3R AT FWD FUSELAGE. FRAME STA 333 BTW STGR 2R - 3R AT FWD FUSELAGE WAS REPAIRED PER REO 670-53-21-2726 REV -.SDR VNA2025F00042Frame · crackedCRACK ON FRAME STA 333 BTW STGR 2R - 3R AT FWD FUSELAGE. FRAME STA 333 BTW STGR 2R - 3R AT FWD FUSELAGE WAS REPAIRED PER REO 670-53-21-2726 REV -.SDR VNAA202511290010Door Frame · corrodedCORROSION ON MID CAP BTW FS 310.00 TO FS 349.00 AT SURROUND STRUCTURE PASSENGER DOOR. MID CAP BTW FS 310.00 TO FS 349.00 AT SURROUND STRUCTURE PASSENGER DOOR WAS REPLACED PER CRJ-700 SRM 51-41-02-001-001-A01SDR VNAA202511290009Web · crackedCRACK ON REPAIR DOUBLER OF WEB BTW BS 195 TO BS 205 AND WL79.50 (RT SIDE) ON INTERNAL STRUCTURE AT FWD EQUIPMENT COMPARTMENT. PREVIOUS REPAIR DOUBLER OF WEB BTW BS 195 TO BS 205 AND WL79.50 (RT SIDE) ON INTERNAL STRUCTURE AT FWD EQUIPMENT COMPARTMENT WAS REPLSDR VNAA202511290008Skin · wornWEAR ON EXTERNAL FUSELAGE SKIN AT BS 988 AND STGR27. WEAR ON EXTERNAL FUSELAGE SKIN AT BS 988 AND STGR27 WAS EVALUATED OUT LIMITS PER SRM 53-61-01-101-003-A01 & REPAIRED IAW REO 670-53-00-290 REV - F.SDR VNAA202511290007Skin · wornWEAR ON DOUBLERS OF INTERNAL SKIN FWD AND AFT LOWER SIDE AT FORWARD BAGGAGE-BAY DOOR. DOUBLERS OF INTERNAL SKIN FWD AND AFT LOWER SIDE AT FORWARD BAGGAGE-BAY DOOR WERE REPLACED PER EA 21-C7-52-1250 REV IR SECTION III - PERMANENT REPAIR.SDR VNAA202511290005Skin · temp repairTEMPORARY DISPOSITION FOR BLENDED SCRATCH DAMAGE TO FUSELAGE SKIN AT THE PAX DOOR CUTOUT BETWEEN FS310.00- FS349.00 & STR17L-STR18L THE SUBJECT REWORKED CONDITION IS STRUCTURALLY ACCEPTABLE FOR 1850 FLIGHT HOURS FROM THE TIME OF INCORPORATION OF THIS REO AT RESDR VNAA202511290004Hinge · wornPAX DOOR HINGE WITHIN 2054 FLIGHT HOURS AFTER SECTION I, ACCOMPLISH A PERMANENT REPAIR AT DISCREPANT AREA IN ACCORDANCE WITH APPROVED PROCEDURES OR REPLACE PART. PAX DOOR HINGE WAS REPLACED PER CRJ-700 SRM 51-42-21-001-001-A01 AND SRM 53-21-23-201-007-A01SDR VNAA202511290003Drag Angle · crackedCRACK ON RT VERTICAL STABILIZER TO FUSELAGE ATTACHMENT AFT DRAG ANGLE ON 67.5% REAR SPAR DATUM AT AFT FUSELAGE. CRACK ON RH VERTICAL STABILIZER TO FUSELAGE ATTACHMENT AFT DRAG ANGLE ON 67.5% REAR SPAR DATUM AT AFT FUSELAGE WAS REPAIRED PER CRJ700 SRM 55-31-00SDR VNAA202511290002Drag Angle · crackedCRACK ON LH VERTICAL STABILIZER TO FUSELAGE ATTACHMENT AFT DRAG ANGLE ON 67.5% REAR SPAR DATUM AT AFT FUSELAGE. CRACK ON LH VERTICAL STABILIZER TO FUSELAGE ATTACHMENT AFT DRAG ANGLE ON 67.5% REAR SPAR DATUM AT AFT FUSELAGE WAS REPAIRED PER SRM 55-31-00-201-00SDR VNAA202511290001Skin · dentedDENTS (3 EAS) ON FUSELAGE SKIN BTW FS1031 AND FS1040 AND BTW STGR 22R/21R, NEAR TO GROUND CONNECTION ACCESS DOOR. DENTS (3 EAS) ON FUSELAGE SKIN BTW FS1031 AND FS1040 AND BTW STGR 22R/21R, NEAR TO GROUND CONNECTION ACCESS DOOR WAS REPAIRED PER REO 670-53-61-2SDR IXXA20251130002Failsafe · corrodedFLC DOOR CUTOUT STA 566 CORROSION AT FAILSAFE STRAP AND INNER CHORDSDR JR2R20251130414Seat Track · corrodedSEAT TRACK BEAM AT LBL 11, FRAME 16-19 IS CORRODED. OUT OF LIMITS. REPAIREDSDR IXXA20251130001Structure · crackedLEFT SIDE BS 1809.5 OUTER CHORD CRACKED WL 250-256, PN 148T2740-9SDR JR2R20251130410Seat Track · corrodedFORWARD WET AREA, RBL11, FR13-18, SEAT TRACK BEAM CORRODED OUT OF LIMITS. REPLACEDSDR IPXA2025112989925Door · dentedMAJOR REPAIR, DENT AT L/H GEAR MAIN DOOR AFT UPPER SEAM ON FUSELAGE, APPROX 2 INCHES BELOW WING TO BODY FAIRING. PERMANENT REPAIR C/W PER EO-95879-REQ3 REF BARCODE [T3F18E008WC9N] EO-95879-REQ3 (FUSELAGE SKIN AT LEFT MAIN LANDING GEAR DOOR CUTOUT DAMAGE AT APSDR REXA2026052700748Support Angle · corrodedCORROSION & CHAFE DAMAGE ON WHEEL BIN SUPPORT ANGLES( 2 EAS), AT RH / LH WHEEL WELL AREA. CORROSION & CHAFE DAMAGE ON WHEEL BIN SUPPORT ANGLES( 2 EAS), AT LH WHEEL WELL AREA WAS REPAIRED PER CRJ953-20960 REV IR AND DUE TO EXCESIVE DAMAGE MACHINED WEB ANGLE OSDR SWIA2026031075485Stringer · corrodedFWD CARGO COMPARTMENT, BS 589 - 592, S25R SHOWS SIGNS OF CORROSION. PERFORMED REPAIR ON THE STRINGER, FOUND TO BE WITHIN LIMITS IAW SRM 51-42-20, 51-21-06, 53-31-03, 51-42-06, 51-42-21, 53-00-03, 51-40-11, 51-21-11, 51-25-16, 51-25-16, 51-41-02, AMM 53-82-81SDR SWIA2026022575312Floorbeam · crackedSUPPORT ANGLE CRACKED ON COCKPIT FLOORBEAM, RBL 12 - LBL 12. REMOVED AND REPLACED THE BS 280 LH & RH COCKPIT CENTER FLOOR PANEL LANDING/ANGLE NEAR LBL 12 AND RBL 12, WL 72.10 IAW SRM 51-42-06, AND SRM 53-11-43.SDR SWIA2026022575309Floorbeam · crackedGUSSETS CRACKED FOR SUPPORT ANGLE ON COCKPIT FLOORBEAM AT RBL 12 AND LBL 12. REMOVED AND REPLACED THE BS 280 LT & RT GUSSETS FOR COCKPIT CENTER FLOOR PANEL LANDING/ANGLE IAW SRM 51-42-06 AND SRM 53-11-43.