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 R61A2019060150575Seat Track · corrodedWHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK, LEVEL II CORROSION WAS FOUND @ CENTER FUSELAGE III SEAT TRACK. SEAT TRACK REPLACED IAW SRM 51-43-03. AIRCRAFT REMAINS OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A2019060150574Gusset · corrodedWHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK, LEVEL II CORROSION WAS FOUND @ CENTER FUSELAGE III FLOOR STRUCTURE GUSSET PLATE. GUSSET PLATE REPLACED IAW SRM 51-40-02.AIRCRAFT REMAINS OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A2019060150573Gusset · corrodedWHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND @ CENTER FUSELAGE III GUSSET PLATE. GUSSET PLATE REPLACED IAW SRM 51-40-02. AIRCRAFT REMAINS OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A2019060150572Support · corrodedWHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND @ CENTER FUSELAGE III FLOOR STRUCTURE SUPPORT. SUPPORT WAS REPLACED IAW SRM 51-43-03, AIRCRAFT REMAINS OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A2019060150565Skin · corrodedWHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND @ EXTERNAL FUSELAGE SKIN WASTE SERVICING CUTOUT. REPAIR WORK DONE IAW SRM 51-70-03 AND ETD 2019-170-067922. AIRCRAFT REMAINS OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A201905140496Power Unit · inoperativeEMERGENCY LIGHT BATTERY FAULT EICAS MESSAGE BEFORE 15 MINUTE TIME LIMIT DURING FUNCTIONAL CHECK OF EMERGENCY LIGHTS. R&R FWD RT EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01.SDR R61A2019060512581Oxygen Mask · inoperativeDURING FUNCTIONAL CHECK THE PILOT (CAPT) OXYGEN MASK DID NOT BREATHE OUT. MASK ASSY WAS REPLACED IAW AMM 35-10-10-10-400-801A. AIRCRAFT REMAINS OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A2019060110570Sign · inoperativeWHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK, R2 DOOR EMERGENCY EXIT IDENTIFIER AT R2 DOOR FOUND NOT COMPLETELY ILLUMINATED. EXIT IDENTIFIER REPLACED IAW AMM 33-50-15. AIRCRAFT REMAINS OUT OF SERVICE FOR HEAVY CHECK COMPLETIONSDR R61A2019040427348Shear Tie · corrodedDURING HEAVY CHECK MAINTENANCE FOUND WHILE REMOVING FASTENERS FOR STRINGER REPAIR FOUND SHEAR CLIP CORRODED AT FR 89 BETWEEN
STRG 27R AND 28R. REMOVED AND REPLACED SHEAR CLIP AT FRAME 89 STRINGER BETWEEN 27R-28R REF. EMB SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A2019040432347Frame · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CORROSION INTERNAL FUSELAGE FRAME 88 ON STRINGER 27R. PERFORMED STRINGER 28R SPLICE REPAIR BETWEEN
FRAME 86/87 AND FRAME 90 REF SRM 53-23-03/REPAIR 03. A/C REMAINS IN CHECK.SDR R61A2019040431346Frame · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CORROSION ON FRAME 88 LOWER SURFACE BETWEEN STRINGERS 28R AND 27R. REMOVED AND REPLACED FRAME 88 BOTTOM
SECTION REF. EMB SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A2019040431345Shear Tie · corrodedDURING HEAVY CHECK MAINTENANCE FOUND SHEAR CLIP CORRODED AT FRAME 84 BETWEEN STRINGERS 29R AND 28R. REMOVED AND REPLACED CORRODED SHEAR
CLIP AT FRAME 84 BETWEEN STRINGERS 29R AND 28R REF SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A2019040432344Seat Track · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CORROSION/GOUGE ON RH OUTBD SEAT TRACK FRAME 20. REMOVED AND REPLACED RH OTBD SEAT
TRACK FR17-FR20, REF SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A2019040619351Rib · crackedDURING HEAVY CHECK INSPECTION MAINTENANCE FOUND CRACK ON RIB ON RH HORIZONTAL RIB 11A BETWEEN FRONT SPAR AND MID SPAR UPPER RIVET ROW OF RIB. REMOVED AND REPLACED RIB11A ON RH HORIZONTAL, REF EMB SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A201904063035Rib · crackedDURING HEAVY CHECK MAINTENANCE FOUND CRACK ON RIB ON RH HORIZONTAL RIB 11A BETWEEN FRONT SPAR AND MID SPAR UPPER RIVET ROW OF RIB. REMOVED AND REPLACED RIB11A ON RH HORIZONTAL, REF EMB SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A2019040419343Beam · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CORROSION AT FWD PASSENGER DOOR LOWER BEAM FORWARD AND AFT GIRT BAR
FITTING AREAS. REMOVED AND REPLACED L1 LOWER BEAM ON FWD PAX DOOR CUTOUT. REF EMB SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A2019040438342Beam · corrodedDURING HEAVY CHECK MAINTENANCE FOUND WHILE ACCOMPLISHING L2 DOOR LOWER BEAM REWORK, CORROSION FOUND AROUND FWD AND
AFT GIRT BAR FITTINGS. REMOVED AND REPLACED L2 DOOR LOWER BEAM REF. EMB SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A2019040418341Bracket · corrodedDURING HEAVY CHECK MAINTENANCE FOUND HEATED DRAIN MAST DOUBLER AFT BRACKET HAS SIGNS OF CORROSION AS MARKED BETWEEN FRAMES
86 AND 87 STRINGERS 28R AND 27R. REMOVED AND REPLACED NEW AFT HEATED DRAIN MAST AFT AND FWD BRACKETS BETWEEN FR 86/87
STRINGERS 27/28SDR R61A2019040418340Doubler · corrodedDURING HEAVY CHECK MAINTENANCE FOUND HEATED DRAIN MAST DOUBLER HAS SIGNS OF CORROSION BETWEEN FRAMES 86 AND 87 STRINGERS
28R AND 27R. REMOVED AND REPLACED AFT HEATED DRAIN MAST DOUBLER, REF SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A2019040418339Bracket · corrodedDURING HEAVY CHECK MAINTENANCE FOUND LAV WASTE BOX UPPER SURFACE IS CORRODED AT BRACKET. REMOVED AND REPLACED LAV WASTE BOX
UPPER SURFACE BRACKET AS MARKED REF. EMB SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A2019040418338Shear Tie · corrodedDURING HEAVY CHECK MAINTENANCE FOUND SHEAR CLIP CORRODED AT FRAME 88 BETWEEN STRINGERS 28R AND 27R. REMOVED AND REPLACED SHEAR CLIP AT FRAME
88 BETWEEN STRINGERS 28R AND 27R REF EMB SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A201902260233Structure · corrodedDURING HEAVY CHECK MAINTENANCE FOUND AFTER REMOVAL OF COPILOT'S INBOARD SEAT TRACK RAIL FOR SN 0086, FOUND CORROSION ON UNDERLYING
FLOOR STRUCTURE FROM FR 9 TO FR 10. REPAIRED CO-PILOT'S INBOARD SEAT TRACK RAIL UNDERLYING FLOOR STRUCTURE FROM FR9 TO FR10 REF.SDR R61A201902240252Angle · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CORROSION AT HEATED DRAIN MAST FWD OF FR87 BETWEEN STR. 28R AND 27R ON ANGLES. REMOVED AND REPLACED ANGLES AT HEATED DRAIN MAST FWD OF FR87 BETWEEN ST 28R AND 27R. REF SRM 51-40-08.A/C REMAINS IN CHECK.SDR R61A201902240251Fitting · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CORRODED SHEAR CLIP AT FR87, STR 27R-STR 28R. REMOVED AND REPLACED SHEAR CLIP AT FR-87, STR 27R-STR 28R, REF SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A201902200250Fitting · corrodedDURING HEAVY CHECK MAINTENANCE FOUND SHEAR CLIP ON FR89 BETWEEN STR 27R-28R IS CORRODED. REMOVED AND REPLACED SHEAR CLIP ON
FR89 BETWEEN STR 27R-28R REF. SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A201902200232Closeout Panel · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CORROSION AS MARKED ON FWD CARGO DOOR CLOSE OUT PANEL. REMOVED AND REPLACED FWD CARGO DOOR CLOSE OUT PANEL ON RACK REF AMM 20-10-01. A/C REMAINS IN CHECK.SDR R61A201902180231Angle · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CORRODED 3 EA LOWER ANGLES AND 4 CRACK RECEPTACLE ON PANEL 1441FR. REMOVED AND REPLACED 3 EA LOWER ANGLES ON PANEL 1441FR, REF AMM 20-10-01, SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A201902180230Angle · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CORRODED 3 EA LOWER ANGLES AND 2 CRACK RECEPTACLE ON PANEL 1431DL. REMOVED AND REPLACED 3EA. LOWER ANGLES ON SIDE OF PANEL 1431DL REF: SRM 51-40-08. AMM 20-10-07/200. A/C REMAINS IN CHECK.SDR R61A201902180229Threshold · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CORROSION AT FWD AND AFT GIRT BAR FITTING CUTOUT EDGE AND LOWER BOTTOM ON THRESHOLD. REMOVED AND REPLACED L1 DOOR THRESHOLD BEAM. REF SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A201902150249Fitting · corrodedDURING HEAVY CHECK MAINTENANCE FOUND SHEAR CLIP CORRODED AT FR 88 FWD SIDE AT STR 27R. REMOVED AND REPLACED SHEAR CLIP AT FR 88 FWD SIDE AT STGR 27R REF SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A201902150248Fitting · corrodedDURING HEAVY CHECK MAINTENANCE FOUND SHEAR CLIP CORRODED AT FR 88 FWD SIDE AT STR 27R. REMOVED AND REPLACED SHEAR CLIP AT FR 88 FWD SIDE AT STR 27R REF SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A201902150228Seat Track · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CORROSION-AFT WET AREA RT SEAT TRACK BEAM FR84. DAMAGE AT AFT WET AREA RT SEAT
TRACK BEAM FR84 REMOVED BY PERFORMING SPLICE REPAIR. SEE H6680 SN 419 FOR ALL WORK ACCOMPLISHED. REF SRM 53-00-10REPAIR 01P. A/C REMAINS IN CHESDR R61A201902150227Crossbeam · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CORROSION-AFT WET AREA FR 84 BETWEEN LT AND RT SEAT TRACK BEAMS. PERFORMED PERMANENT REPAIR BY BLENDING ON CROSSBEAM FR84 BETWEEN LT AND RT SEAT TRACK BEAMS IN ACCORDANCE WITH REF ETD-2019-170-023717. A/C REMAINS IN CHECK.SDR R61A201902150226Seat Track · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CORROSION-AFT WET AREA RH SEAT TRACK BEAM AT FR 87. REMOVED AND REPLACED NEW RH SEAT TRACK BEAM AFT WET AREA AT FR87 REF SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A201902150186Bracket · corrodedDURING HEAVY CHECK MAINTENANCE FOUND PANEL 226BRF FLOOR SUPPORT BRACKET HAS AN AREA OF CORROSION AT FR16. REMOVED AND REPLACED PANEL 226 BRF FLOOR SUPPORT BRACKET PN-170-04071-001 REF SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A201902150185Upper Sheet · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CORROSION AFT WET AREA LT SEAT TRACK BEAM UPPER SHEET FR85. REMOVED AND REPLACED AFT WET AREA LT SEAT TRACK BEAM UPPER SHEET FR 85 REF SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A201902150184Support · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CORROSION STRUCTURAL CENTER FUSELAGE III WET AREA FR87-88 RT AFT PANEL SUPPORT. REMOVED AND REPLACED AFT PANEL SUPPORT FR87-88 REF SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A2019020870165Door · corrodedDURING HEAVY CHECK MAINTENANCE FOUND WASTE SERVICE DOOR IS CORRODED. REMOVED AND REPLACED WASTE SERVICE
DOOR. REF EMB AMM 53-03-60. A/C REMAINS IN CHECK.SDR R61A2019020850164Shear Panel · corrodedDURING HEAVY CHECK MAINTENANCE FOUND AFT WET AREA RH SHEAR PANEL BETWEEN FR87-88 IS CORRODED AROUND GALLEY MOUNT HOLE. REMOVED AND REPLACED RH SHEAR PANEL
BETWEEN FR87-88 REF. EMB SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A2019020850163Shear Tie · corrodedDURING HEAVY CHECK MAINTENANCE FOUND SHEAR CLIP, FRAME, AND SKIN WITH CORROSION AT FR88, STR27R/28R. REMOVED AND REPLACED SHEAR CLIP AT FR-
88 STGR 27R-28R REF. EMB SRM51-40-08. BLENDED OUT CORROSION ON FRAME 88 AT STR27R/28R REF SRM 51-10-03, MATERIAL LOST SDR R61A201901250129Selector Valve · inoperativeLANDING LEVER DISAGREE MESSAGE ON GEAR RETRACTION. THE RT MAIN GEAR DID NOT FULLY RETRACT. RED X INDICATION FOR RT MLG. BRAKE CONTROL FAULT WHEN GEAR EXTENDED AND CLEARED WHEN GEAR RETRACTED. DECLARED EMERGENCY, RETURNED TO FIELD, LANDED WITHOUT INCIDENT. R&R SDR R61A2019020830162Shear Tie · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CORROSION - SHEAR CLIP FR86, STR27R/28R. REMOVED AND REPLACED NEW SHEAR CLIP
FR86, STR27R/28R REF SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A2019020830161Shear Tie · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CORROSION - SHEAR CLIP FR87, STR27R/28R. REMOVED AND REPLACED SHEAR CLIP AT
FR87, STR27R/28R AND RESTORED SURFACE PROTECTION. REF: SRM 51-40-08, 51-23-06, CPM 51-25-00. A/C REMAINS IN CHECK.SDR R61A2019020830160Floor Support · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CORROSION - PANEL SUPPORT RH SIDE FR86. REMOVED AND REPLACED PANEL SUPPORT ON R-H SIDE FR 86 PER REF SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A2019020830159Floor Support · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CORROSION - RH UPPER SHEET FR85/86. REMOVED AND REPLACED R/H UPPER SHEET FR85/86 AND RESTORED SURFACE PROTECTION. REF:
SRM 51-40-08, 51-23-06, CPM 51-25-00. A/C REMAINS IN CHECK.SDR R61A201901230158Beam · corrodedDURING HEAVY CHECK MAINTENANCE FOUND LVL 2 CORROSION RT BEAM FR87. REMOVED AND REPLACED RT BEAM AT FR-87 REF SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A201901230157Upper Sheet · corrodedDURING HEAVY CHECK MAINTENANCE FOUND LVL 2 CORROSION LT UPPER SHEET FR86. REMOVED AND REPLACED LT UPPER SHEET FR86 REF SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A201901230156Fitting · corrodedDURING HEAVY CHECK MAINTENANCE FOUND LVL 2 CORRODED SHEAR CLIP IN THE AFT CARGO ON FR 84 BETWEEN STR 26-27R. REMOVED AND REPLACED NEW SHEAR CLIP
FR84, STR27R/26R, REF SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A201901230155Floor Support · corrodedDURING HEAVY CHECK MAINTENANCE FOUND RT FLOOR PANEL SUPPORT IS CORRODED AT FR 16. REMOVED AND REPLACED RT FLOOR PANEL
SUPPORT AT FR16 REF SRM 51-40-02/ SRM 51-40-08. A/C REMAINS IN CHECK.SDR R61A201901230154Seat Track · corrodedDURING HEAVY CHECK MAINTENANCE FOUND RT SEAT TRACK BEAM IS CORRODED BETWEEN FR 14 AND FR 15. PERFORMED REPAIR ON RT SEAT TRACK BEAM BETWEEN FR 14-15 UPPER CAP REF SRM 53-10-10/REPAIR 03P. A/C REMAINS IN CHECK.
Back to Embraer ERJ 170-100SU