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 R61A2019020731153Floorbeam · corrodedDURING HEAVY CHECK MAINTENANCE FOUND LH OUTBOARD FLOOR SUPPORT IS CORRODED AT FR 16. REMOVED AND REPLACED L-H O/B FLOOR SUPPORT
AT FR 16. REF EMB SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A2018122421253Plate · wrong partR1 DOOR WILL NOT OPEN. FERRIED TO CMH. INSPECTED DOOR, FOUND SURROUND BRACKET GUIDE PLATE TO BE INCORRECT EFFECTIVITY. R&R WITH CORRECT EFFECTIVITY IAW AMM 25-23-10.SDR R61A201811141130Doubler · corrodedWHILE THE ACFT WAS IN HEAVY CHECK - MAINT FOUND RH FLOOR DOUBLER IS CORRODED BETWEEN FRAMES 12 AND 14. REMOVED AND REPLACED RH FLOOR DOUBLER BETWEEN FRS 12-14 REF SRM 51-40-08. ACFT REMAINS OUT-OF-SERVICE FOR HEAVY CHECK COMPLETIONSDR R61A2018081830894Slide · crackedMAINTENANCE FOUND THE L1 DOOR SLIDE HAD A CRACKED BACK BOARD. THE L1 DOOR SLIDE ASSY WAS REMOVED AND REPLACED IAW AMM 25-65-01.SDR R61A2018081870895Rib · crackedTHE RIGHT HORIZONTAL STAB INSIDE OF RIB 12A, ON UPPER FLANGE WAS FOUND CRACKED . THE RIB WAS REMOVED AND REPLACED IAW SRM 51-41-02, AND ETD 2018-170-082964.SDR R61A2018081850899Seat Track · corrodedCORROSION WAS FOUND ON THE AFT WET AREA, RT INBD SEAT TRACK. THE SEAT TRACK WAS REPAIRED IAW SRM 51-10-03, AND ETD 2018-170-081641.SDR R61A2018081850900Seat Track · corrodedCORROSION WAS FOUND AT THE AFT WET AREA, LT INBD SEAT TRACK. THE SEAT TRACK WAS REPAIRED IAW SRM 51-10-03, AND ETD 2018-170-081506.SDR R61A2018081850898Crossbeam · corrodedDURING HEAVY CHECK, FOUND THE AFT WET AREA CROSSBEAM AT FRAME 84, SHOWS EVIDENCE OF CORROSION ON THE RT SIDE. MX REPAIRED IAW SRM 53-00-10, REPAIR 03, FIG 203.SDR R61A2018081850897Support Bracket · corrodedDURING HEAVY CHECK, FOUND CREW OXYGEN BOTTLE AT FR 27 WAS CORRODED. MX REMOVED AND REPLACED THE OXYGEN BOTTLE SUPPORT BRACKET IAW SRM 51-41-01, AND 51-43-03.SDR R61A2018080720849Seat Track · corrodedCORROSION WAS FOUND ON THE FWD WET AREA RT INBD SEAT TRACK, FRAMES 17 - 18. REPAIR THE SEAT TRACK IAW ETD2018-170-081630.SDR R61A2018080720848Web · corrodedCORROSION WAS FOUND ON THE FWD WET AREA LT FLOOR WEB AT FRAME 16. THE WEB WAS REMOVED AND REPLACED IAW SRM 51-43-04.SDR R61A2018080720847Mount · corrodedCORROSION WAS FOUND ON THE FWD WET AREA LT LAVATORY MOUNT SUPPORT AT FRAME 16 INBOARD OF THE L1 DOOR. THE MOUNT WAS REMOVED AND REPLACED IAW SRM 51-75-16.SDR R61A2018080720846Floor Support · corrodedCORROSION WAS FOUND ON THE AFT WET AREA RT FLOOR SUPPORT, FRAMES 89 - 90. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-42-01.SDR R61A2018080720844Splice Plate · corrodedCORROSION WAS FOUND ON THE AFT WET AREA RT SPLICE PLATE AT FRAME 90. THE SPLICE PLATE WAS REMOVED AND REPLACED IAW SRM 51-41-02.SDR R61A2018080720843Splice Plate · corrodedCORROSION WAS FOUND ON THE AFT WET AREA LT SHEAR PANEL, OTBD SPLICE PLATE AFT OF THE L2 DOOR. THE SPLICE PLATE WAS REMOVED AND REPLACED IAW SRM 51-42-02.SDR R61A2018080720842Floor Support · corrodedCORROSION WAS FOUND ON THE AFT WET AREA LT FLOOR SUPPORT AT FRAME 84, FWD OF THE L2 DOOR. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-41-01.SDR R61A2018080620841Floor Support · corrodedCORROSION WAS FOUND ON THE AFT WET AREA RT FLOOR SUPPORT AT FRAME 84. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-41-01.SDR R61A201808070840Splice Plate · corrodedCORROSION WAS FOUND AT THE AFT WET AREA RT SIDE FRAME 91, THE SPLICE PLATE WAS REMOVED AND REPLACED IAW SRM 51-41-02.SDR R61A201807240896Attach Angle · crackedTHE ATTACH ANGLE AT THE LT RIB 52 INBOARD OF AILERON TORQUE TUBE WAS FOUND CRACKED. THE ANGLE WAS REMOVED, FABRICATED AND REPLACED IAW SRM 51-43-03.SDR R61A2018080720845Shear Tie · corrodedCORROSION WAS FOUND ON THE FRAME 76 SHEAR TIE. THE SHEAR TIE WAS REMOVED AND REPLACED IAW SRM 51-75-16.SDR R61A201807200893Skin · dentedFOUND DAMAGE AT THE LOWER LEFT RVSM AREA. REPAIRED IAW ETD 2018-170-081132.SDR R61A2018072460821Intercostal · corrodedWHILE AC WAS IN FOR HEAVY CHECK FOUND CORROSION FWD OF FR 87 BETWEEN STR 27R-28R INTERCOSTAL JUST AFT OF WATER DRAIN MAST CORRODED. MX REMOVED AND REPLACED PN 170-87562-001 IAW SRM 51-40-08, 51-40-02, 53-23-01. AC REMAINS IN IND FOR COMPLETION.SDR R61A2018072460820Fitting · corrodedWHILE AC WAS IN FOR HEAVY CHECK FOUND AFT CARGO FR 82 STR12R-28R SHEAR CLIP HAS CORROSION. MX REMOVED AND REPLACED AFT CARGO FR 82 STR 12R-28R SHEAR CLIP PN 170-66674-001 IAW SRM 51-40-08, ETD2018-170-078410. AC REMAINS IN IND FOR COMPLETION.SDR R61A201807150808Fitting · corrodedDURING HEAVY CHECK MAINTENANCE FOUND A SHEAR CLIP CORRODED AT FR83 BETWEEN STR27R AND 28R. OUT OF LIMITS IAW SRM 53-23-04. MAINTENANCE REMOVED AND REPLACED THE SHEAR CLIP IAW SRM 51-40-08,51-41-02. A/C REMAINS IN IND FOR CHECK COMPLETION.SDR R61A201807150807Fitting · corrodedWHILE IN HEAVY CHECK MAINTENANCE FOUND SHEAR CLIP CORRODED AT FR87 BETWEEN STR 27R AND 28R. FOUND OUT OF LIMITS IAW SRM 53-23-04. REMOVED AND REPLACED SHEAR CLIP IAW SRM 51-40-08. A/C REMAINS IN IND FOR CHECK COMPLETION.SDR R61A2018072340809Fitting · corrodedWHILE AC WAS IN FOR HEAVY CHECK FOUND AFT FUSELAGE FR88 BETWEEN STR 27R AND 28R SHEAR CLIP IS CORRODED. MX REMOVED AND REPLACED AFT FUSELAGE FR88 BETWEEN STR 27R AND 28R SHEAR CLIP PN 170-66531-001 IAW SRM 51-40-02, 51-40-08, SRMI 53-23-04. AC REMAINS IN IND FSDR R61A201807140806Fitting · corrodedWHILE A/C WAS IN HEAVY CHECK FOUND SHEAR CLIP CORRODED AFT FUSELAGE FR89 BETWEEN STR 27R AND 28R. FOUND TO BE CORRODED THROUGH 100% AND OUT OF LIMITS IAW SRM 53-23-04. MAINTENANCE REMOVED AND REPLACED SHEAR CLIP IAW SRM 51-40-08. A/C REMAINS IN IND FOR CHECK CSDR R61A201807100805Support Channel · corrodedWHILE AC WAS IN FOR HEAVY CHECK FOUND PAX CABIN FLOOR STRUCTURE AT AFT WET AREA SUPPORT CHANNEL AT FR 87-88 AND RBL 25 HAS CORROSION ON UPPER SURFACE AREA. MX REMOVED AND REPLACED AFT WET AREA SUPPORT CHANNEL AT FR 87-88 AND RBL 25 PN 170-86131-001. IAW SRM 51SDR R61A201807090804Fitting · corrodedWHILE AC WAS IN FOR HEAVY CHECK FOUND PAX CABIN FLOOR STRUCTURE AT AFT WET AREA RIGHT SHEAR CLIP HAS CORROSION ON UPPER SURFACE BETWEEN FR87-88 AND RBL 24. MX REMOVED AND REPLACED AFT WET AREA RIGHT SHEAR CLIP PN 170-19191-001 IAW SRM 51-40-08, 53-23-1051-40-0SDR R61A201807090803Shear Panel · corrodedWHILE AC WAS IN FOR HEAVY CHECK FOUND PAX CABIN FLOOR STRUCTURE AT AFT WET AREA LEFT SHEAR PANEL HAS CORROSION ON UPPER SURFACE BETWEEN FR 87-88 AND LBL 3.5. MX REMOVED AND REPLACED LEFT SHEAR PANEL PN 170-65928-001. IAW SRM 51-40-08, 51-75-16, ETD2011-190/013SDR R61A201807090802Shear Panel · corrodedWHILE AC WAS IN FOR HEAVY CHECK FOUND PAX CABIN FLOOR STRUCTURE AT AFT WET AREA CENTER SHEAR PANEL HAS CORROSION ON UPPER SURFACE BETWEEN FR87-88 LBL 23-33. MX REMOVED AND REPLACED CENTER SHEAR PANEL PN 170-65927-007 IAW SRM 51-75-16, ETD2011-190/013330REV C,SDR R61A201807090801Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK FOUND PAX CABIN FLOOR STRUCTURE AT AFT WET AREA PLATE SHOWS SIGNS OF PREVIOUS CORROSION AND BLEND OUT AT FR90 RBL25. MX REMOVED AND REPLACED GUSSET PLATE PN 170-60259-001 IAW SRM 51-75-16, 51-40-08. AC REMAINS IN IND FOR COMPLETSDR R61A201807090800Angle · corrodedWHILE AC WAS IN FOR HEAVY CHECK FOUND PASSENGER CABIN FLOOR STRUCTURE AT AFT WET AREA SKIRT ANGLE HAS CORROSION AT FR 89, RBL 36. MX REMOVED AND REPLACED FLOOR STRUCTURE AT AFT WET AREA SKIRT ANGLE PN 170-86181-005, IAW SRM 51-40-02 , SRM 71-40-08. AC REMAINS SDR R61A201807050799Support · corrodedWHILE AC WAS IN FOR HEAVY CHECK FOUND RT WING IN BOARD MAIN FLAP INMOST FLAP TRACK SUPPORT HAS CORROSION. MX REMOVED CORROSION FLAP TRACK FAIRING SUPPORT PN 170-14654-404. IAW ETD2018-170-076715. AC REMAINS IN IND FOR COMPLETION.SDR R61A2018060400648Nut Plate · corrodedMAINTENANCE FOUND CORROSION AT THE WASTE BOX NUT HOLDER AT FRAME 88 TO 98. THE NUT HOLDER WAS REMOVED AND REPLACED IAW SRM 51-43-03, 51-10-03, 51-75-16, AND 51-40-02.SDR R61A201806040649Seat Track · corrodedMAINTENANCE FOUND CORROSION ON THE FLOOR SEAT TRACK NEAR FORWARD GALLEY MOUNT POINTS, FRAMES 12 TO 14. THE CORROSION WAS REMOVED AND DETERMINED TO BE OUT OF SRM LIMITS. DOUBLERS WERE FABRICATED AND INSTALLED IAW ETD2018-170-057239, AND SRM 53-10-10, REPAIR SDR R61A201806040661Structure · corrodedMAINTENANCE DISCOVERED CORROSION ON THE WASTE BOX. REMOVED AND REPLACED THE WASTE BOX IAW SRM 51-43-04. SRM 51-75-16, SRM 51-41-02, AND AMM 53-01-09.SDR R61A201806040660Support Angle · corrodedMAINTENANCE DISCOVERED CORROSION ON THE SUPPORT ANGLE ON TOP OF WASTE BOX. REMOVED AND REPLACED THE SUPPORT ANGLE IAW SRM 51-40-02.SDR R61A201806040666Floorbeam · corrodedMAINTENANCE DISCOVERED CORROSION ON THE FLOORBEAM ANGLE AT FRAME 87. REMOVED AND REPLACED THE FLOORBEAM ANGLE IAW SRM 51-41-01.SDR R61A201806040659Floor Support · corrodedMAINTENANCE DISCOVERED CORROSION ON THE FLOOR SUPPORT AT FRAME 89, RBL35. REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM 51-42-01.SDR R61A201806040665Seat Track · corrodedMAINTENANCE DISCOVERED CORROSION ON THE RT INBD SEAT TRACK AT FRAME 84. BLENDED AND INSTALLED A FABRICATED REPAIR DOUBLER IAW SRM 53-23-10 .SDR R61A201806040658Shear Panel · corrodedMAINTENANCE DISCOVERED CORROSION ON THE CENTER SHEAR PANEL AT FRAME 87. REMOVED AND REPLACED THE SHEAR PANEL IAW SRM 51-42-01.SDR R61A201806040657Shear Panel · corrodedMAINTENANCE DISCOVERED CORROSION ON THE RT SHEAR PANEL AT FRAME 87. REMOVED AND REPLACED THE SHEAR PANEL IAW SRM 51-42-01.SDR R61A201806040663Shear Tie · corrodedMAINTENANCE DISCOVERED CORROSION ON A SHEAR TIE. REMOVED AND REPLACED THE SHEAR TIE IAW SRM 51-41-01, AND SRM 51-41-02.SDR R61A201806040656Reinforcement · corrodedMAINTENANCE DISCOVERED CORROSION ON FWD CARGO REINFORCEMENT ABOVE THE OXYGEN BOTTLE, WHERE THE BONDING WIRE ATTACHES. REMOVED AND REPLACED REINFORCEMENT IAW SRM 51-40-03.SDR R61A201806040662Bracket · corrodedMAINTENANCE DISCOVERED CORROSION ON THE BRACKET LOCATED ON TOP OF THE WASTE BOX. REMOVED AND REPLACED BRACKET IAW E170 SRM 510-10-03, SRM 51-75-16, SRM 51-40-02 AND SRM 51-43-03.SDR R61A201806040654Shear Tie · corrodedMAINTENANCE FOUND CORROSION AT FWD FUSELAGE SHEAR TIE, FRAME 17, STRINGERS 26 - 27. THE SHEAR TIE WAS REMOVED AND REPLACED IAW SRM 51-41-01, AND 51-41-02.SDR R61A201806040652Seal Rest · corrodedMAINTENANCE FOUND CORROSION AROUND AFT CARGO DOOR CUTOUT LOWER SEAL NUTPLATES AND ATTACH RIVETS AT FRAME 77 TO 79. THE LOWER SEAL REST WAS REMOVED AND REPLACED IAW SRM 51-41-01.SDR R61A201806040653Bracket · corrodedMAINTENANCE FOUND CORROSION ON THE AFT CARGO DOOR CUTOUT BRACKET JUST AFT OF LOWER CLOSURE PLATE AT FRAME 80. THE BRACKET WAS REMOVED AND REPLACED IAW SRM 51-41-01, AND SRM 51-41-12.SDR R61A201806040651Rib · corrodedMAINTENANCE FOUND CORROSION ON WING TO FUSELAGE FAIRING AT FRAME 45, RBL 6. CORROSION WAS BLENDED IAW SRM 51-10-03. RIB AND NUTPLATE WERE REMOVED AND REPLACED IAW SRM 51-41-01, AND 51-45-00.
Back to Embraer ERJ 170-100SU