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 R61A20100348Bracket · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK. LEVEL 2 CORROSION WAS FOUND ON THE AFT LAV SINGLE SPLIT JOINT. MAINTENANCE REPLACED THE SINGLE SPLIT JOINT IAW EMB 170 CMM 25-42-03 AND AMM 20-10-01. P/N CDSP2200-3. A/C STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETIONSDR R61A20100347Structure · corrodedWHILE A/C WAS IN FOR HEAVY CHECK. CORROSION LEVEL 2 WAS FOUND AT FLOOR CROSSBEAM AT FRAME 85. MAINTENANCE REMOVED & REPLACED UPPER SHEET IAW EMB 170 SRM 51-40-02, 51-41-01 & 51-43-01. P/N 170-86101-001. A/C STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100346Gusset · corrodedWHILE A/C WAS IN FOR HEAVY CHECK. LEVEL 2 CORROSION WAS FOUND ON FLOOR CROSSBEAM SPLICE PLATE AT FRAME 90. MAINTENANCE REMOVED AND REPLACED GUSSET IAW EMB 170 SRM 51-41-02 & 51-40-02. P/N 170-60259-001. A/C STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100345Gusset · corrodedWHILE A/C WAS IN HEAVY CHECK. LEVEL 2 CORROSION WAS FOUND ON FLOOR CROSSBEAM AT FRAME 89. MAINTENANCE REMOVED & REPLACED GUSSET IAW EMB 170 SRM 51-41-02. P/N 170-60257-001. A/C STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100337Door · lack of lubeCREW REPORTED L-1 DOOR WAS DIFFICULT TO CLOSE. MAINTENANCE LUBED THE L-1 DOOR PER EMB AMM, AND OPS CHECK WAS GOOD. A/C WAS THEN RETURNED TO SERVICE.SDR R61A20100338Service Panel · corroded*** GENERATED WHILE A/C WAS IN HEAVY CHECK *** LEVEL TWO CORROSION WAS FOUND ON WASTE SERVICE PANEL. MAINTENANCE REMOVED & REPLACED WASTE SERVICE PANEL BOX & DOUBLERS IAW EMB 170 SRM 51-43-02. P/N'S 170-85084-405, 170-86655-003 & 170-86654-003.SDR R61A20100335Battery · dischargedCREW REPORTED COCKPIT EMERGENCY LIGHTS INOP. MAINTENANCE REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PER EMB AMM. A/C WAS THEN RETURNED TO SERVICE.SDR R61A20100334Floorbeam · corrodedGENERATED WHILE A/C WAS IN HEAVY CHECK. LT FLOORBEAM CORRODED AT FR 87. MAINTENANCE REMOVED AND REPLACED FLOORBEAM IAW EMB 170 SRM 51-40-02, 51-40-00, AND 51-43-01.SDR R61A20100333Gusset · corrodedGENERATED WHILE A/C WAS IN HEAVY CHECK. CORROSION ON GUSSET AT FR90 RT FLOORBEAM. MAINTENANCE REMOVED AND REPLACED GUSSET IAW EMB 170 SRM 51-41-02.SDR R61A20100332Gusset · corrodedGENERATED WHILE A/C WAS IN HEAVY CHECK. CORROSION ON GUSSET AT FR 91 RT CTR FLOORBEAM. MAINTENANCE REMOVED AND REPLACED GUSSET IAW EMB 170 SRM 51-41-02.SDR R61A20100331Floor Splice · corrodedGENERATED WHILE A/C WAS IN HEAVY CHECK. LT FLOOR SPLICE FOR SILL TO SHEAR PLATE CORRODED. MAINTENANCE REMOVED AND REPLACED LT FLOOR SPLICE IAW EMB 170 SRM 51-40-02, 51-40-04, 51-42-02.SDR R61A20100329Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT GUSSET AT FR 90. MAINTENANCE REMOVED AND REPLACED THE GUSSET PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100328Shear Plate · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT SHEAR PLATE AT FR 87 AND FR 88. MAINTENANCE REMOVED AND REPLACED THE SHEAR PLATE PER THE SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100327Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT GUSSET AT FR 90 FLOORBEAM. MAINTENANCE REMOVED AND REPLACED THE GUSSET PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100326Shear Plate · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON CENTER SHEAR PLATE AT FR 87 AND FR 88. MAINTENANCE REMOVED AND REPLACED THE CENTER SHEAR PLATE PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100325Shear Plate · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT SHEAR PLATE AT FR 87 AND FR 88. MAINTENANCE REMOVED AND REPLACED THE LT SHEAR PLATE PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100324Panel · crackedWHILE AC WAS IN FOR HEAVY CHECK, A MAJOR REPAIR WAS ACCOMPLISHED. RIGHT ENGINE OUTBOARD PYLON PANEL WAS FOUND CRACKED. MAINTENANCE REQUESTED EMB ENGINEERING SUPPORT AND RECEIVED ETD 2010-170/05893 FOR THE REPAIR. MAINTENANCE REPAIRED THE PANEL PER THE EMB ESDR R61A20100323Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON GUSSET AT FR 91 RIGHT SIDE OF FLOORBEAM. MAINTENANCE REMOVED AND REPLACED THE GUSSET PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100318Splice Plate · corrodedGENERATED WHILE A/C WAS IN HEAVY CHECK, SPLICE PLATE AT FR 89 LT SEAT TRACK HAS CORROSION. MAINTENANCE REMOVED AND REPLACED LT SPLICE PLATE IAW EMB SRM 51-43-01. A/C IS CURRENTLY STILL OUT OF SERVICE FOR HEAVY CHECK.SDR R61A20100317Gusset · corrodedGENERATED WHILE A/C WAS IN HEAVY CHECK, GUSSET AT FWD WASTE TANK SUPPORT FRAME 90 HAS CORROSION. MAINTENANCE REMOVED AND REPLACED GUSSET AT FWD WASTE TANK SUPPORT FRAME 90 IAW EMB SRM 51-41-02. A/C IS STILL CURRENTLY OUT OF SERVICE FOR HEAVY CHECK.SDR R61A20100316Gusset · corrodedGENERATED WHILE A/C WAS IN HEAVY CHECK, FR 90 GUSSET AT RT SEAT TRACK BEAM HAS CORROSION. MAINTENANCE REMOVED AND REPLACED GUSSET AT RT SEAT TRACK BEAM IAW EMB SRM 51-41-02. A/C IS STILL CURRENTLY OUT OF SERVICE FOR HEAVY CHECK.SDR R61A20100315Sill · corrodedGENERATED WHILE A/C WAS IN HEAVY CHECK, SILL PLATE AT FR 89 TO RT CREASE HAS CORROSION. MAINTENANCE REMOVED AND REPLACED RT SILL PLATE IAW EMB SRM 51-40-02, 51-42-01, AND 51-43-01. A/C IS CURRENTLY STILL IN HEAVY CHECK.SDR R61A20100314Shear Plate · corrodedGENERATED WHILE A/C WAS IN HEAVY CHECK, SHEAR PLATE BETWEEN FRAME 87 TO FRAME 88 AND RT SEAT TRACK BEAM AND RT CREASE BEAM HAS CORROSION. MAINTENANCE REMOVED AND REPLACED RT SHEAR PLATE IAW EMB SRM 51-42-01 AND REPAIRED TOPCOAT ON RT SEAT TRACK IAW EMB SRM 51SDR R61A20100313Shear Plate · corrodedGENERATED WHILE A/C WAS IN HEAVY CHECK, SHEAR PLATE BETWEEN FR 87 TO FR 88, LT SEAT TRACK BEAM, AND LT CREASE BEAM HAD CORROSION. MAINTENANCE REMOVED AND REPLACED LT SHEAR PLATE IAW EMB SRM 51-41-01 AND REPAIRED TOPCOAT ON LT SEAT TRACK IAW EMB SRM 51-32-06, SDR R61A20100312Shear Plate · corrodedGENERATED WHILE A/C WAS IN HEAVY CHECK, SHEAR PLATE BETWEEN FR 87 AND FR 88 BETWEEN LT SEAT TRACK BEAM AND RT SEAT TRACK BEAM HAS CORROSION. MAINTENANCE REMOVED AND REPLACED CENTER SEAT PLATE IAW EMB SRM 51-42-01. A/C IS STILL CURRENTLY IN HEAVY CHECK.SDR R61A20100321Ramp · dirtyCREW REPORTED L-1 DOOR DIFFICULT TO OPEN. MAINTENANCE CLEANED AND LUBED L-1 DOOR RAMP PER EMB AMM, OPS CHECK GOOD.SDR R61A20100301Seat Track · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT SEAT TRACK AT FR 17. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK PER THE EMB SRM.SDR R61A20100310Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT GUSSET AT FR 90A. MAINTENANCE REMOVED AND REPLACED THE GUSSET PER THE EMB SRM.SDR R61A20100307Fastener · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT SHEAR PLATE FASTENERS AT FR 19. MAINTENANCE REMOVED AND REPLACED THE FASTENERS AS REQUIRED ON SHEAR PLATE PER THE EMB SRM.SDR R61A20100309Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT AND RT GUSSETS AT FR 90. MAINTENANCE REMOVED AND REPLACED THE GUSSETS PER THE EMB SRM.SDR R61A20100308Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON GUSSET AT FR 91. MAINTENANCE REMOVED AND REPLACED THE GUSSET PER THE EMB SRM.SDR R61A20100306Sill · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT SILL PLATE AT FR 19. MAINTENANCE FOUND CORROSION TO BE ON FASTENERS. REMOVED AND REPLACED THE FASTENERS AS REQUIRED PER THE EMB SRM.SDR R61A20100305Seat Track · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT SEAT TRACK AT FR 17. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK PER THE EMB SRM.SDR R61A20100304Seat Track · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT SEAT TRACK BEAM AT FR 16 TO FR 19. THIS WAS ALSO CLASSIFIED AS A MAJOR REPAIR. MAINTENANCE REQUESTED EMB ENGINEERING SUPPORT AND RECEIVED ETD 2010-170/05632. MAINTENANCE REPAIRED PER THE ESDR R61A20100303Shear Plate · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON SHEAR PLATES AT FR 87. MAINTENANCE REMOVED AND REPLACED THE SHEAR PLATES PER THE EMB SRM. (P/N'S 170-91919-001 AND 170-65928-001).SDR R61A20100302Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT AND RT GUSSETS ON FLOOR BEAM AT FR 89. MAINTENANCE REMOVED AND REPLACED THE GUSSETS PER THE EMB SRM. (P/N'S 170-86125-001 AND 17086127-001).SDR R61A20100300Shear Plate · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND UNDER FWD LAV ON SHEAR PLATE AT FR 16. MAINTENANCE REMOVED AND REPLACED THE SHEAR PLATE PER THE EMB SRM.SDR R61A20100299Floorbeam · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT FLOORBEAM AT FR 87. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100298Fitting · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND IN AFT CARGO BAY ON A SHEAR CLIP BETWEEN FR 82 AND FR 83, STR 29R AND STR 26R. MAINTENANCE REMOVED AND REPLACED THE SHEAR CLIP PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100297Sill · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT FLOOR SILL UNDER GALLEY AT FR 14 JUST FORWARD OF FWD SERVICE DOOR. MAINTENANCE REMOVED AND REPLACED THE DOUBLER PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK.SDR R61A20100295Floorbeam · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND, IN WHICH DUE TO THE EXTENT OF DAMAGE WAS ALSO CLASSIFIED AS A MAJOR REPAIR, ON RT FLOORBEAM AT FR 17. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM PER THE EMB SRM. AC STILL OUT OF SERVICE FOR SDR R61A20100293Structure · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON THE AFT LAV SERVICE PANEL. MAINTENANCE REMOVED AND REPLACED THE LAV SERVICE PANEL BOX ASSEMBLY PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100276Sill · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT SILL FROM FR 88 TO FR 90. MAINTENANCE REMOVED AND REPLACED RT FLOOR SILL PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100275Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT CENTER I BEAM GUSSET AT FR 90. MAINTENANCE REMOVED AND REPLACED THE GUSSET PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100274Beam · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT CENTER I BEAM BETWEEN FR 85 AND FR 86. MAINTENANCE REMOVED AND REPLACED THE UPPER SHEET PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100292Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT SEAT TRACK FLOOR SUPPORT GUSSET AT FR 90. MAINTENANCE REMOVED AND REPLACED THE GUSSET PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100291Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT SEAT TRACK FLOOR SUPPORT GUSSET AT FR 90. MAINTENANCE REMOVED AND REPLACED GUSSET PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100284Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT GUSSET AT FR 91. MAINTENANCE REMOVED AND REPLACED THE GUSSET PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100289Intercostal · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON REPAIR DOUBLER RT INTERCOSTAL SEAT TRACK FLOOR SUPPORT FROM FR 89 TO FR 90. MAINTENANCE REMOVED AND REPLACED THE INTERCOSTAL PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETIONSDR R61A20100288Splice · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT FLOOR SPLICE AT FR 89. MAINTENANCE REMOVED AND REPLACED THE RT FLOOR SPLICE PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.
Back to Embraer ERJ 170-100SU