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 R61A20100074Floorbeam · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON CENTER LT FLOORBEAM AT FR 17. MAINTENANCE REQUESTED ENGINEERING SUPPORT FROM EMB AND RECEIVED ETD2010-170/01078. MAINTENANCE REPAIRED PER ETD. AC STILL OUT OF SERVICE FOR HEAVY CHECK INSPECTISDR R61A20100073Shear Plate · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT SHEAR PLATE AT FR 86 AND FR 87. MAINTENANCE REMOVED AND REPLACED SHEAR PLATE PER EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK INSPECTION.SDR R61A20100072Sill · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT SILL AT FR 89 TO FR 90. MAINTENANCE REMOVED AND REPLACED SILL PER EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK INSPECTION.SDR R61A20100066Power Unit · inoperativeTHIS WRITE-UP WAS GENERATED WHILE A/C WAS IN HEAVY CHECK. MTX REPORTED THE R-2 EMERGENCY BATTERY FAILED TO LIGHT. MAINTENANCE REMOVED AND REPLACED THE R-2 DOOR EMERGENCY LIGHT POWER UNIT PER EMB AMM.SDR R61A20100065Power Unit · inoperativeTHIS WRITE-UP WAS GENERATED WHILE A/C WAS IN HEAVY CHECK. MTX REPORTED NR 4 EMERGENCY LIGHT POWER UNIT WAS INOP AND FAILED TO LIGHT EXIT MARKING. MAINTENANCE REMOVED AND REPLACED THE NR 4 EMERGENCY LIGHT POWER UNIT PER EMB AMM.SDR R61A20100052Controller · malfunctionedCREW REPORTED, RECEIVED A SPOILER FAULT AFTER DEPARTING MCI, CREW COULDN'T CLEAR MSG AFTER FOLLOWING QRH. THE CREW DECIDED TO CONTINUE AND DECLARED AN EMERGENCY INTO LGA AND LANDED WITHOUT INCIDENT. MTX WAS DISPATCHED TO THE AIRCRAFT TO TROUBLESHOOT, AND RESSDR R61A20100069Shear Plate · corrodedWHILE AC WAS IN HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON SHEAR PLATE AT FR 87 BETWEEN L2 DOOR AND THE LT SEAT TRACK BEAM. MAINTENANCE REMOVED AND REPLACED SHEAR PLATE PER EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100062Seat Track · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT FLOOR SEAT TRACK IN TWO PLACES BETWEEN FR 85 AND FR 86. MAINTENANCE REMOVED AND REPLACED UPPER SHEET ON SEAT TRACK PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100061Flange · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON WASTE WATER DUMP VALVE AROUND FLANGE SUPPORT. MAINTENANCE REMOVED AND REPLACED FLANGES (P/N'S 170-86657-003, AND 170-86656-003) PER EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100055Shear Plate · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND THREE SHEAR PLATES ON FR 87. MAINTENANCE REMOVED AND REPLACED ALL THREE SHEAR PLATES, (P/N'S 170-65927-001, 170-65928-001, AND 170-81919-001) PER THE EMB SRM. AC STILL OUT OF SERVICE FOR THE COMPSDR R61A20100057Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT SEAT TRACK BEAM GUSSET AT FR.89. MAINTENANCE REMOVED AND REPLACED GUSSET PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100053Shear Plate · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON SHEAR PLATE AT FR 87, BETWEEN R2 DOOR AND RT SEAT TRACK BEAM. MAINTENANCE REMOVED AND REPLACED SHEAR PLATE PER THE EMB SRM. AC STILL OUT OF SERVICE FOR COMPLETION OF HEAVY CHECK.SDR R61A20100051Door · bindsCREW REPORTED L-1 DOOR WAS HARD TO CLOSE. MAINTENANCE WAS DISPATCHED TO THE A/C TO TROUBLESHOOT. MAINTENANCE OPENED AND CLOSED THE L-1 CABIN DOOR MANY TIMES, AND NO DEFECTS WERE NOTED IAW EMB AMM 52-11-00.SDR R61A20100064Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON GUSSET AT FR 90, AT LAV TANK FORWARD ATTACH ROD FITTING. MAINTENANCE REMOVED AND REPLACED GUSSET PER EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100063Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT FLOOR SEAT TRACK GUSSET AT FR 90. MAINTENANCE REMOVED AND REPLACED GUSSET PER EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100060Seat Track · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT FLOOR SEAT TRACK BETWEEN FR 88 AND FR 89. MAINTENANCE REMOVED AND REPLACED BEAM PER EMB SRM. AC STILL OUT OF SERVICE FOR COMPLETION OF HEAVY CHECK.SDR R61A20100059Doubler · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON WATER SERVICE PANEL ATTACH FLANGE. MAINTENANCE REMOVED AND REPLACED DOUBLER FLANGES ( P/N'S 170-86655-003, AND 170-86654-003) PER EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100058Seat Track · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT FLOOR SEAT TRACK FROM FR 85 TO FR 86. MAINTENANCE REMOVED AND REPLACED UPPER SHEETS PER EMB SRM. AC STILL OUT OF SERVICE FOR COMPLETION OF HEAVY CHECK.SDR R61A20100056Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT SEAT TRACK FLOORBEAM GUSSET AT FR 85 TO FR 86. MAINTENANCE REMOVED AND REPLACED GUSSET PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100054Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT SEAT TRACK FLOORBEAM GUSSET AT FR 85 TO FR 86. MAINTENANCE REMOVED AND REPLACED GUSSET PER EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100050Floorbeam · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT SEAT TRACK FLOORBEAM AT FR 86 TO FR 89. MAINTENANCE REMOVED AND REPLACED FLOORBEAM PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK.SDR R61A20100049Floorbeam · corrodedWHILE AC WAS IN HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT SEAT TRACK FLOORBEAM AT FR 86 TO FR 89. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM PER EMB SRM, AC STILL OUT OF SERVICE FOR HEAVY CHECK.SDR R61A20100048Seat Track · corrodedWHILE AC WAS IN HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT SEAT TRACK EXTENSION AT FR 19. MAINTENANCE REQUESTED EMBRAER ENGINEERING SUPPORT AND RECEIVED ETD 2010/170-00708 FOR REPAIR. MAINTENANCE REPAIRED AC PER ETD AND IS STILL OUT OF SERVICE DUE TO TSDR R61A201000047Floorbeam · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT FLOORBEAM BETWEEN FR 86 AND FR 87. MAINTENANCE REMOVED AND REPLACED FLOORBEAM PER EMB SRM. AC WAS RELEASED AFTER THE COMPLETION OF THE HEAVY CHECK.SDR R61A20100045Plunger · corrodedWHILE AC WAS IN HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON L1 DOOR OPEN STOP SPRING PLUNGER ON FWD FUSELAGE FRAME. MAINTENANCE REMOVED AND REPLACED DAMPNER PER EMB AMM, AND RIGGED AS REQUIRED. AC WAS RELEASED AFTER COMPLETION OF THE HEAVY CHECK.SDR R61A20100044Solenoid · corrodedWHILE AC WAS IN HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT REFUEL CONTROL SOLENOID. MAINTENANCE REMOVED AND REPLACED SOLENOID PER EMB AMM. AC RELEASED AFTER COMPLETION OF THE HEAVY CHECK.SDR R61A210100043Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON GUSSET PLATE AT FR 90 AT LT FLOOR TRACK INTERSECTION. MAINTENANCE REMOVED AND REPLACED GUSSET PER THE EMB SRM. AC RETURNED TO SERVICE AFTER THE COMPLETION OF HEAVY CHECK.SDR R61A20100042Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND AT GUSSET PLATE RT FLOOR TRACK AT FR 90. MAINTENANCE REMOVED AND REPLACED GUSSET PER EMB SRM. AC RELEASED AFTER COMPLETION OF THE HEAVY CHECK.SDR R61A20100041Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON GUSSET PLATE AT FR 90, JUST FORWARD OF AVIONICS RACK. MAINTENANCE REMOVED AND REPLACED GUSSET PER EMB SRM. AC RELEASED TO SERVICE AFTER COMPLETION OF HEAVY CHECK.SDR R61A20100040Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND AT WASTE TANK FWD SUPPORT ROD ATTACH POINT AT FLOOR GUSSET. MAINTENANCE REMOVED AND REPLACED GUSSET PER EMB SRM. AC WAS RETURNED TO SERVICE AFTER COMPLETION OF HEAVY CHECK.SDR R61A20100039Sill · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT SILL FR 87 TO FR 90. MAINTENANCE REMOVED AND REPLACED SILL PER EMB SRM, AC RETURNED TO SERVICE AFTER COMPLETION OF HEAVY CHECK.SDR R61A20100038Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON GUSSET PLATE AT FR 89, RT FLOOR SEAT TRACK INTERSECTION. MAINTENANCE REMOVED AND REPLACED GUSSET PER EMB SRM, AC RELEASED TO SERVICE AFTER HEAVY CHECK COMPLETION.SDR R61A20100037Rod · disconnectedCREW REPORTED, HAD A SLAT FAIL DURING RETRACTION AFTER TAKEOFF FROM PHL, AND DECLARED AN EMERGENCY. THE CREW THEN RETURNED TO PHL AND LANDED WITHOUT INCIDENT. MAINTENANCE WAS DISPATCHED TO THE AIRCRAFT TO TROUBLESHOOT. MAINTENANCE DISCOVERED A DRIVE ROD DISSDR R61A20100036Shear Plate · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON CENTER SHEAR PLATE BETWEEN FR 87 AND FR 88. MAINTENANCE REMOVED AND REPLACED SHEAR PLATE IAW ETD 2009/170-00325 AND EMB SRM. AC RELEASED BACK TO SERVICE.SDR R61A20100035Seat Track · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT SEAT TRACK BEAM AT FR 87 AND FR 88. MAINTENANCE REMOVED AND REPLACED SEAT TRACK BEAM IAW SRM. AC RELEASED TO SERVICE.SDR R61A20100034Seat Track · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT SEAT TRACK BEAM BETWEEN FR 88 AND FR 89. MAINTENANCE REMOVED AND REPLACED BEAM IAW EMB SRM. AC RELEASED BACK TO SERVICE.SDR R61A20100033Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT SEAT TRACK BEAM GUSSET AT FR 90. MAINTENANCE REMOVED AND REPLACED GUSSET PER EMBRAER ETD 2009/170-00325 AND SRM. AC RELEASED TO SERVICE.SDR R61A20100032Shear 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 SHEAR PLATE IAW EMB SRM. AC RELEASED TO SERVICE.SDR R61A20100031Structure · corrodedWHILE AC WAS IN HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND AT WASTE PANEL CUTOUT, STR 26R ON INTERNAL SIDE. MAINTENANCE REPLACED WASTE DRAIN BOX ASSEMBLY PER EMB SRM. AC RELEASED AFTER CHECK WAS COMPLETE.SDR R61A20100030Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON GUSSET FOR RT SEAT TRACK AT FR 90. MAINTENANCE REQUESTED EMB ENGINEERING SUPPORT AND RECEIVED ETD 2009/170-00325 FOR REMANUFACTURE OF GUSSET. REPLACED AS REQUIRED PER SRM AND AC RELEASED AFTERSDR R61A20100029Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON GUSSET AT FR 90 FWD OF AVIONICS RACK. MAINTENANCE REQUESTED EMBRAER ENGINEERING SUPPORT, RECEIVED ETD 2009/170-00825 FOR REMANUFACTURE OF GUSSET. REPLACED AS REQUIRED AND AC RELEASED AFTER CHESDR R61A20100028Floorbeam · corrodedWHILE AC WAS IN HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON TOP FLOOR SUPPORT AT FR 87 AND FR 88. MAINTENANCE REMOVED AND REPLACED SHEAR PLATES AT FR 87 AND FR 88. ALSO, REPLACED RT SEAT TRACK FLOORBEAM FROM FR 86 TO FR 89, IAW EMBRAER SRM. AC STILL IN HESDR R61A20100024Gusset · corrodedWHILE AC WAS IN HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT CENTER FLOOR GUSSET AT FR 85. MAINTENANCE REPLACED GUSSET PER EMB 170 SRM, AND RELEASED AC BACK TO SERVICE.SDR R61A20100023Floorbeam · corrodedWHILE AC WAS IN HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT CENTER FLOORBEAM BETWEEN FRAMES 87 AND 88. MAINTENANCE REPLACED FLOORBEAM IAW EMB 170 SRM. AC RELEASED BACK TO SERVICE.SDR R61A20100022Gusset · corrodedWHILE AC WAS IN HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT MIDDLE SUPPORT GUSSET AT FR 90. MAINTENANCE REQUESTED EMBRAER ENGINEERING SUPPORT AND RECEIVED ETD 2009/170-00325. MAINTENANCE REPAIRED PER ETD AND RELEASED AC TO SERVICE.SDR R61A20100021Support · corrodedWHILE AC WAS IN HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT FR 90 MIDDLE GUSSET SUPPORT. MAINTENANCE REQUESTED EMBRAER ENGINEERING SUPPORT AND RECEIVED ETD 2009/170-00325. MAINTENANCE REPAIRED PER ETD AND RELEASED AC TO SERVICE.SDR R61A20100020Beam · corrodedWHILE AC WAS IN HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND AT FRAME 90, RT I BEAM. MAINTENANCE REQUESTED EMBRAER ENGINEERING SUPPORT AND RECEIVED ETD 2009/170-00325. MAINTENANCE REPAIRED PER ETD AND RELEASED AC TO SERVICE.SDR R61A20100019Gusset · corrodedWHILE AC WAS IN HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND AT FRAME 90, LT I BEAM GUSSET. MAINTENANCE REQUEST EMBRAER ENGINEERING AND RECEIVED ETD 2009/170-00325. MAINTENANCE REPAIRED PER EMBRAER ETD AND RELEASED BACK TO SERVICE.SDR R61A20100018AFloorbeam · corrodedWHILE A/C WAS IN HEAVY CHECK MAINTENANCE DISCOVERED LEVEL TWO CORROSION ON RT CENTER FLOORBEAM BETWEEN FRAMES 87-88. MAINTENANCE REMOVED CORROSION IAW EMB 170 SRM 51-12-01. MAINTENANCE FOUND BEAM TO BE OUT OF LIMITS, DRILLED NEW FLOORBEAM IAW EMB 170 SRM 51-SDR R61A20100027Glowstrip · unserviceableTHE EMERGENCY EXIT MARKING ON GLOW STRIPS ON RIGHT FRONT IS MISSING RED DOTS. MAINTENANCE CONTROL PLACED THIS ON DEFERRAL PER MEL 33-50-21-1 CAT C TICKET 28801.
Back to Embraer ERJ 170-100SU