Embraer ERJ 170-100SU
Service difficulty reports · 2,953
Newest first. 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' WHERE aircraft_model_key = 'ERJ170100SU' 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' WHERE aircraft_model_key = 'ERJ170100SU' 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 R61A201507120449Seat Track · corrodedDURING HEAVY CHECK, FRAME 84 SEAT TRACK IS CORRODED. REPAIRED THE SEAT TRACK IAW ETD-2015-170-065652. MAJOR REPAIR.SDR R61A201507120448Seat Track · corrodedSEAT TRACK AT FRAME 84 RT IS CORRODED. MX REPAIRED IAW ETD 2015-170-065652. MAJOR REPAIR.SDR R61A201507110425Cover · brokenMAINTENANCE FOUND EMERGENCY LIGHT STRIP COVER BROKEN AT SEAT 10D & 10F. MAINTENANCE R & R EMERGENCY LIGHT STRIPS IAW AMM.SDR R61A201507090424Slide · inoperativeCREW REPORTED THAT THE R2 DOOR WOULD NOT DISARM. MAINTENANCE R & R AFT EMERGENCY EVAC SLIDE IAW AMM AND OPS CHECKED GOOD.SDR R61A201507070440Intercostal · corrodedDURING HEAVY CHECK, THE INTERCOSTAL BRACKET FRAMES 87-88, STRINGER 27-28R IS CORRODED. MAINTENANCE R & R INTERCOSTAL BRACKET IAW SRM 51-41-01, 51-41-02.SDR R61A201507070432Structure · crackedDURING HEAVY CHECK, LT WING STUB AT CF2 PRESSURE BULKHEAD SPAR 3 IS CRACKED. MAINTENANCE REAMED AND INSTALLED OVERSIZED BUSHING IAW ETD 2015-170-063981, AND FCBS 57-01-00-004.SDR R61A201507070431Structure · crackedDURING HEAVY CHECK, FASTENER HOLE OF RT WING STABILIZER AT CF2 PRESSURE BULKHEAD TO SPAR 3, WAS FOUND CRACKED. MAINTENANCE REAMED THE HOLE, INSTALLED OVERSIZED BUSHING IAW ETD2015-170-063981, FCBS 57-01-00-004.SDR R61A201507070429Shear Tie · corrodedDURING HEAVY CHECK, SHEAR TIE AT FRAME 88 BETWEEN STRINGER 27-28 RT IS CORRODED. MAINTENANCE R & R SHEAR TIE IAW SRM 51-44-01, AND 51-44-02.SDR R61A201507060441Bracket · corrodedDURING HEAVY CHECK, THE INTERCOSTAL BRACKET FWD OF THE AFT FUSELAGE HOT WATER DRAIN UNDER RT SIDE OF POTABLE WATER TANK IS CORRODED. MAINTENANCE R & R THE BRACKET IAW SRM 51-41-01, 51-42-02.SDR R61A201507060438Bracket · corrodedDURING HEAVY CHECK, THE UPPER MOUNTING BRACKET FOR OXYGNE BOTTLE TRAY AT BONDING WIRE TERMINAL IS CORRODED. MAINTENANCE R & R FABRICATED NEW BRACKET IAW EA 53-23-002 UPPER MOUNTING BRACKET FOR O2 BOTTLE TRAY AT BONDING WIRE TERMINAL, INSTALLED IAW SRM 51-40-SDR R61A201507060415Battery Pack · inoperativeCREW REPORTED THAT THE EMERGENCY LIGHT ON EICAS MESSAGE CAME ON AND THEN WENT OUT ON DESCENT AND CAME BACK ON ON THE GROUND. THEN ALL EMERGENCY LIGHTS WERE FLASHING ON AND OFF. ACFT WAS FLOWN VIA MAINTENANCE FERRY TO WHERE MAINTENANCE R & R BOTH LT AND RT FOSDR R61A201507040433Bulkhead · crackedDURING HEAVY CHECK, THE APU BULKHEAD PANEL 351BZ WAS FOUND CRACKED IN THE UPPER CORNER. MAINTENANCE PERFORMED PERMANENT REPAIR IAW SRM 53-31-21, REPAIR TYPE 1.SDR R61A201507040434Seat Track · corrodedDURING HEAVY CHECK, THE RT SEAT TRACK EXTENSION AROUND NUT PLATE HOLE 4, FORWARD OF FRAME 87 WAS CORRODED. MAINTENANCE R & R AFT WET AREA RT SEAT TRACK EXTENSION IAW SRM 51-40-02, 51-42-01, REF CONTINUATION CARD FOR WORK DETAILS, VP 021565-2015/593 C1-C2.SDR R61A201507030423Shear Plate · corrodedDURING HEAVY CHECK, LT SHEAR PLATE AT FRAME 87 NEAR L2 DOOR SHEAR PLATE IS CORRODED. MAINTENANCE R & R 2 RIVETS IAW SRM 51-40-02, 51-42-02, 51-42-00.SDR R61A201507030420Shear Web · corrodedDURING HEAVY CHECK, FRAMES 87-88 RT AFT WET AREA, RT SHEAR WEB BLIND FASTENER IS CORRODED. MX R & R FRAME 87-88 RT AFT WET AREA RT SHEAR WEB BLIND FASTENER IAW SRM 51-40-02, 51-42-00.SDR R61A201507020444Bolt · corrodedDURING HEAVY CHECK, THE LT SPOILER NR 4 HARDWARE ON ACTUATOR IS CORRODED. MX R & R HARDWARE IAW 27-64-02,SDR R61A201507020435Bulkhead · crackedDURING HEAVY CHECK, PANEL 351BZ CRACKED IN LOWER INBD CORNER. MAINTENANCE REPAIRED IAW ETD 2015-170-063112.SDR R61A201507020430Rib · crackedDURING HEAVY CHECK, LEFT HORIZONTAL STABILIZER L/E, RIB 4 IS CRACKED AT RIVET FLANGE. MAINTENANCE CUTOUT DAMAGE ARE IAW ETD 2015-170-062705 FABRICATED REPAIR AND FILLER DOUBLER IAW ETD 2015-170-062705. PERFORMED HFEC ON FABRICATED PARTS, NO CRACK NOTED IAWSDR R61A201507010439Cotter Pin · corrodedDURING HEAVY CHECK, FLAP TRACK SUPPORT 4 FWD MOUNT COTTER PIN IS CORRODED. MAINTENANCE R & R FLAP TRACK SUPPORT 4 FWD MOUNT COTTER PIN IAW AMM 57-57-31.SDR R61A201507010437Bolt · corrodedDURING HEAVY CHECK, THE AFT GALLEY FLOOR ATTACH BOLTS ARE CORRODED. MAINTENANCE R & R AFT GALLEY FLOOR ATTACH BOLTS IAW AMM 25-34-01. PN NAS6205L22, BOLT.SDR R61A201507010427Seat Track · corrodedDURING HEAVY CHECK, RT SEAT TRACK HAS MULTIPLE AREAS OF CORROSION. MX R & R THE SEAT TRACK IAW SRM 51-43-01.SDR R61A201507010421Support · corrodedDURING HEAVY CHECK, FLAP TRACK SUPPORT NR 3 FWD MOUNT COTTER PIN IS CORRODED. MX R & R FLAP TRACK SUPPORT NR 3 FWD MOUNT COTTER PIN IAW AMM 57-57-31, PN MS24665-319, FASTENER.SDR R61A201506300428Access Panel · corrodedDURING HEAVY CHECK, ACCESS PANEL 192CR IS CORRODED ON MATING SIDE. MAINTENANCE R & R SPACER IAW SRM 51-41-02.SDR R61A201506300422Support Bracket · crackedDURING HEAVY CHECK, LT RAM AIR DUCT SUPPORT BRACKET IS CRACKED. MAINTENANCE R & R LT RAM AIR DUCT SUPPORT BRACKET IAW SRM 51-40-02, 51-41-01, PN 170-92988-401 SUPPORT.SDR R61A201506250412Shear Tie · corrodedDURING HEAVY CHECK FRAME 16, STR 27LT, SHEAR CLIP IS CORRODED. MAINTENANCE R & R FRAME 16, STR 27 LT SHEAR CLIP IAW SRM 51-41-01, 51-23-04, 51-23-05, 51-23-06, 51-21-02.SDR R61A201506250411Shear Tie · corrodedDURING HEAVY CHECK, WAS REPORTED THAT FRAME 16, STRINGER 28 RT TO CENTERLINE SHEAR CLIP IS CORRODED. MAINTENANCE R & R FRAME 16, STRINGER 28 RT TO CENTERLINE SHEAR CLIP IAW SRM 51-41-01, 51-21-01, 51-23-06.SDR R61A201506250406Shear Tie · corrodedDURING HEAVY CHECK, FRAME 16 AT 28L TO CENTER LINE SHEAR CLIPS CORRODED. MAINTENANCE REMOVED FRAME 16, STRINGER 28 LT TO REMOVE CORROSSION NON SIGNIFICANT DAMAGE PART IS GOOD AS IS TOP COATED RE-INSTALLED IAW SRM 51-23-04, 51-23-05, 51-23-06, 51-41-0151-21-02SDR R61A201506250401Shear Tie · corrodedDURING HEAVY CHECK, FRAME 16, STRINGER 27R SHEAR CLIP IS CORRODED. MAINTENANCE REMOVED FRAME 16, STR 27R, SHEAR CLIP, BLENDED IT. FOUND DAMAGE THIS AREA, NO DAMAGE ALLOWED, LOCATED AND DRILLED NEW CLIP AND INSTALLED NEW CLIP IAW SRM 170 51-40-02, 51-41-02, 5SDR R61A201506240410Shear Tie · corrodedDURING HEAVY CHECK, FRAME 16, STR 27 RT, SHEAR CLIP IS CORRODED. MAINTENANCE R & R FRAME 16, STR 27 RT SHEAR CLIP IAW SRM 51-21-02, 51-23-06, 51-41-01, 51-40-02.SDR R61A201506240409Shear Tie · corrodedDURING HEAVY CHECK, FWD CARGO FRAME 17, STR 28 RT-27RT SHEAR CLIP IS CORRODED. MAINTENANCE R & R FWD CARGO FRAME 17, STR 28 RT-27 RT SHEAR CLIP IAW SRM 51-21-02, 51-23-06, 51-41-01, 51-41-02.SDR R61A201506240408Shear Tie · corrodedDURING HEAVY CHECK, FWD CARGO FRAME 17, STRINGER 28, LT -27 LT SHEAR CLIP IS CORRODED. MAINTENANCE R & R SHEAR CLIPS FWD CARGO FRAME 17, STRINGER 28 LT -27 LT IAW SRM 51-31-00, 51-40-02, 51-43-03, 51-43-04, 51-41-01, 51-23-04, 51-23-05, 51-23-06.SDR R61A201506240407Shear Tie · corrodedDURING HEAVY CHECK, FWD CARGO FRAME 17R-28R SHEAR CLIPS ARE CORRODED. MAINTENANCE REMOVED FWD CARGO FRAME 17R-28R SHEAR CLIPS, INSTALLED NEW SHEAR CLIPS IAW 51-41-01, 51-23-06, 50-40-02, 51-21-02, 51-23-3.SDR UHLA201506240498Gust Lock · inoperativeMLD GUST LOCK NOT LOCKING. READJUSTED L1 DOOR ARM TRIM PANEL IAW AMM 52-11-00. FOUND TRIM TO BE OBSTRUCTING PROPER OPERATION OF GUST LOCK. OPS CHECK OF GUST LOCK CHECKS GOOD.SDR R61A201506190379Battery Pack · inoperativeCREW REPORTED THAT THE AFT CABIN EMERGENCY LIGHTS WERE INOPERATIVE. ACFT WAS FLOWN VIA MAINTENANCE FERRY, WHERE MAINTENANCE R & R EMERGENCY BATTERY IAW AMM AND OPS CHECKED GOOD.SDR R61A201506180393Seal Rest · corrodedDURING HEAVY CHECK, AFT PASSENGER DOOR CENTER SEAL REST HAS CORROSION. MAINTENANCE R & R AFT PASSENGER DOOR CENTER SEAL REST IAW SRM 51-40-02, 51-41-01, 51-25-25, 51-23-06.SDR R61A201506170487Shear Tie · corrodedDURING HEAVY CHECK, SHEAR TIE AT FRAME 88 BETWEEN STRINGERS 28-29R FOUND CORRODED. MAINTENANCE R & R THE SHEAR TIE IAW SRM 51-40-01, AND 51-40-02.SDR R61A201506170486Frame · corrodedDURING HEAVY CHECK, FRAME 88, STRINGERS 27-28 ARE CORRODED. MAINTENANCE R & R THE FRAME IAW SRM 51-40-02, 51-23-04, 51-23-07, AND 51-41-01.SDR R61A201506170416Shear Plate · corrodedDURING HEAVY CHECK, IT WAS REPORTED THAT CENTER AFT FUSELAGE SHEAR PANEL BETWEEN FRAMES 87-88 IS CORRODED. MAINTENANCE R & R CENTER AFT FUSELAGE SHEAR PANEL BETWEEN FRAMES 87-88 IAW SRM 51-40-02, 51-42-01, 51-23-05, 51-23-06. PN 170-65928-001, PANEL SHEAR.SDR R61A201506170405Shear Tie · corrodedDURING HEAVY CHECK WAS REPORTED THAT FWD CARGO FRAME 17, STRINGER 28L TO CENTER LINE CLIPS ARE CORRODED. MX REMOVED FWD CARGO FRAME 17, STRINGER 28L TO CENTER LINE CLIPS BLENDED 100 PERCENT LOSS IN A NO DAMAGE AREA INSTALLED NEW SHEAR CLIPS AT FWD CARGO FRAME SDR R61A201506170395Floor Support · corrodedDURING HEAVY CHECK, RT AFT FUSELAGE ON FLOORBEAM BETWEEN FRAMES 85-86 IS CORRODED. MX R & R RT AFT FUSELAGE ON FLOORBEAM BETWEEN FRAMES 85-86 IAW 51-40-02, 51-41-01, 51-43-01, 51-23-05, 51-23-06, PN 170-86101-001. UPPER SHEET.SDR R61A201506170394Floor Support · corrodedDURING HEAVY CHECK, LT AFT FUSELAGE PANEL SUPPORT FRAMES 88-90 IS CORRODED AS MARKED. MAINTENANCE R & R LT AFT FUSELAGE PANEL SUPPORT FRAMES 88-90 IAW SRM 51-40-02, 51-41-01, 51-43-01, 51-23-05, 51-23-06. PN 170-86101-001 UPPER SHEET.SDR R61A201506170392Floor Support · corrodedDURING HEAVY CHECK, LT AFT FUSELAGE ON FLOOR PANEL BRACKET AT FRAME 86 IS CORRODED. MAINTENANCE FABRICATED AND INSTALLED NEW BRACKET IAW ETD 2015-170-060547, REF TASK CARD 2639 FOR INSTALLATION AND WORK DETAILS.SDR R61A201506160404Beam · corrodedDURING HEAVY CHECK, FWD PASSENGER DOOR LOWER BEAM HAS 2 FASTENERS BETWEEN FRAMES 15-18 THAT ARE CORRODED. MX R & R FASTENERS IAW SRM 51-43-02 TOP COATED IAW SRM 57-23-04, 51-23-01.SDR R61A201506160403Beam · corrodedDURING HEAVY CHECK, FWD PASSENGER DOOR LOWER BEAM HAS 2 FASTENER BETWEEN FRAMES 15-18 THAT ARE CORRODED. MAINTENANCE R & R FASTENERS IAW SRM 51-43-02, TOP COATED IAW SRM 57-23-04. 51-23-01.SDR R61A201506160402Seat Track · corrodedDURING HEAVY CHECK RT SEAT TRACK ON PREVIOUS REPAIR IS CORRODED. MX REMOVED DOUBLER, REMOVED CORROSION FROM RT SEAT TRACK ON PREVIOUS REPAIR STILL NO GOOD, R & R IAW 57-40-02.SDR R61A201506150488Shear Tie · corrodedDURING HEAVY CHECK, SHEAR TIE AT FRAME 83, STRINGERS 28-29R FOUND CORRODED. MAINTENANCE R & R THE SHEAR TIE IAW SRM 51-40-02, AND 51-23-00.SDR R61A201506040489Shear Tie · corrodedDURING HEAVY CHECK, SHEAR TIE AT FRAME 84 STRINGERS 27-28R WAS FOUND CORRODED. MX R & R THE SHEAR TIE IAW SRM 51-41-01, AND 51-40-02.SDR R61A201506040485Floor Support · corrodedDURING HEAVY CHECK WAS REPORTED THAT LT FLOOR SUPPORT FRAMES 88-90 FOUND CORRODED. R & R FLOOR SUPPORT IAW SRM 51-41-01, AND 52-42-01.SDR UHLA201506030587Floorbeam · corrodedFWD WET CROSSBEAM FRAME 14, RBL 12"-36" HAS CORROSION. C/W ETD 2015-170-048475.SDR UHLA201505310500Shear Tie · corrodedCORROSION ON RT SHEAR TIE FRAME 17, STRINGER 28L-28R CORRODED. R & R CORRODED SHEAR TIE IAW SRM 51-41-01 AND 51-41-02.
Back to Embraer ERJ 170-100SU