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 R61A201212100710Spar · crackedWHILE AIRCRAFT WAS OUT OF SERVICE FOR WING SPAR SERVICE BULLETIN SB 170-57-0053 REV 1 MAINTENANCE FOUND CRACK LIKE INDICATIONS ON LEFT WING A2 HOLE. MAINTENANCE REPAIRED A2 HOLE LEFT WING PER SB 170-57-0053 REV 1. THE AIRCRAFT IS STILL OUT OF SERVICE CMH WITSDR R61A201212090736Bolt · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE R2 DOOR CLEVIS BRACKET BOLTS CORRODED. MAINTENANCE REMOVED AND REPLACED THE R2 DOOR CLEVIS BRACKET BOLTS IAW EMB AMM 52-42-41-04. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212090734Clevis Bolt · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTNENACE FOUND THE L1 DOOR CLEVIS BRACKET BOLTS CORRODED. MAINTENANCE REMOVED AND REPLACED THE L1 DOOR CLEVIS BOLTS IAW EMB 170 AMM 52-11-40. THE AIRCRAFT IS OUF OF SERVICE IN HEAVY CHECK.SDR R61A201212090728Bearing Support · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT WING BEARING SUPPORT FOR FLAP TORQUE TUBES 5 AND 6 CORRODED. MAINTENANCE REMOVED AND REPLACED THE RIGHT WING BEARING SUPPORT IAW EMB 170 AMM 27-51-04. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECKSDR R61A201212090715Unknown · malfunctionedCREW REPORTED THE CABIN WOULD NOT HOLD PRESSURE, DECLARED AN EMERGENCY AND RETURNED TO FIELD. AIRCRAFT WAS FERRIED FROM ALB TO CMH FOR FURTHER TROUBLESHOOTING. CMH MX TROUBLESHOT PER EMB AMM AND FOUND NO FAULTS.SDR R61A201212080751Profile · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT RAM AIR VALVE PROFILE CRACKED. MAINTENANCE REMOVED AND REPLACED THE LEFT RAM AIR VALVE PROFILE IAW EMB 170 SRM 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212080750Support · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT RAM AIR VALVE SUPPORT CRACKED. MAINTENANCE REMOVED AND REPLACED THE LEFT RAM AIR VALVE SUPPORT IAW EMB 170 SRM 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212080749Support · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT RAM AIR VALVE SUPPORT CRACKED. MAINTENANCE REMOVED AND REPLACED THE LEFT RAM AIR VALVE SUPPORT IAW EMB 175 SRM 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212080735Bolt · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE R1 DOOR SLIDE LOWER BOLTS CORRODED. MAINTENANCE REMOVED AND REPLACED THE R1 DOOR SLIDE LOWER BOLTS IAW EMB 170 AMM 20-10-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212080733Bolt · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE L1 DOOR SLIDE LOWER BOLTS CORRODED. MAINTENANCE REMOVED AND REPLACED L1 DOOR SLIDE LOWER BOLTS IAW EMB 170 AMM 25-65-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212080732Bolt · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE L2 GIRT BAR BOLTS CORRODED. MAINTENANCE REMOVED AND REPLACED THE BOLTS ON THE L2 GIRT BAR IAW EMB 170 AMM 25-61-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212080731Bolt · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTNENACE FOUND THE L1 DOOR GIRT BAR BOLTS CORRODED. MAINTENANCE REMOVED AND REPLACED THE L1 DOOR GIRT BAR BOLTS IAW EMB 170 AMM 52-11-41. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212080727Torque Tube · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND CORROSION ON RIGHT FLAP TORQUE TUBE NUMBER 5. MAINTENANCE REMOVED AND REPLACED RIGHT FLAP TORQUE TUBE NUMBER 5 IAW EMB 170 AMM 27-51-03. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212070752Support · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE FORWARD CARGO DOOR CUTOUT LOWER SILL NUT PLATE SUPPORT CRACKED. MAINTENANCE REMOVED AND REPLACED THE FORWARD CARGO DOOR CUTOUT LOWER SILL NUT PLATE SUPPORT IAW EMB 170 SRM 51-41-01. THE AIRCRAFT IS OUT SDR R61A201212070743Seal Depressor · damagedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE L1 DOOR SEAL PROFILE DAMAGED. "MAJOR REPAIR" MAINTENANCE REMOVED AND REPLACED THE FORWARD SEAL DEPRESSOR IAW EMB 170 SRM 51-41-01 AND 51-43-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212070742Seat Track · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT FUSELAGE FORWARD SEAT TRACK CORRODED. MAINTENANCE REMOVED AND REPLACED THE RIGHT FUSELAGE FORWARD SEAT TRACK IAW EMB SRM 51-40-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212070730Seat Track · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT SEAT TRACK BETWEEN FRAMES 85 AND 86 CORRODED. MAINTENANCE REMOVED AND REPLACED THE RIGHT SEAT TRACK BETWEEN FRAMES 85 AND 86 IAW EMB 170 SRM 51-43-03, 51-40-02, 51-43-02, 51-43-01, AND 51-23-06. TSDR R61A201212070729Crossbeam · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND CROSSBEAM AT FRAME 84 CORRODED. MAINTENANCE REPAIRED CROSSBEAM AT FRAME 84 IAW EMB ETD 2012-170-017900-A, REV A. THIS WAS A "MAJOR REPAIR", THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212040711Spar · crackedWHILE AIRCRAFT WAS OUT OF SERVICE FOR WING SPAR SB 170-57-0053 REV1 MAINTENANCE FOUND CRACK LIKE INDICATIONS RIGHT WING SPAR A2 HOLE. MAINTENANCE PERFORMED "MAJOR REPAIR" ON RIGHT WING SPAR 2 IAW EMB ETD 2012-170-017651. THE AIRCRAFT IS OUT OF SERVICE FOR FOSDR R61A201211260697Frame · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT PYLON AFT FAIRING FRAME 3 CRACKED. MAINTENANCE REMOVED AND REPLACED THE FRAME 3 ON RIGHT PYLON IAW EMB 170 SRM 51-43-02, AND 51-41-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201211210695Seat Track · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE CENTER FUSELAGE LEFT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 84 AND 85. MAINTENANCE REMOVED AND REPLACED THE CENTER FUSELAGE LEFT INBOARD SEAT TRACK IAW EMB 170 SRM 51-41-01, 51-43-01, AND 51-43-02. SDR R61A201211250692Rib · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND CRACKS ON RIGHT WING RIB 10 UPPER FASTENER. MAINTENANCE REMOVED AND REPLACED RIGHT WING RIB 10 IAW EMB 170 SRM 51-40-02, 51-43-02, 51-43-03, AND 51-21-03. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201211250691Rib · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND CRACKS ON RIGHT WING RIB 10 UPPER FASTENER. MAINTENANCE REMOVED AND REPLACED RIGHT WING RIB 10 IAW EMB SRM 51-40-02, 51-43-02, 51-43-03, AND 51-21-03. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201211240686Spar · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND CRACK LIKE INDICATIONS A3 HOLE LEFT WING SPAR 2. MAINTENANCE REAMED A3 HOLE LEFT WING SPAR 2 IAW EMB SB 170-57-0053 REV 1. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201211220696Bolt · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE UPPER BOLT CORRODED ON THE FORWARD LATCH PIN FITTING AFT CARGO DOOR. MAINTENANCE REMOVED AND REPLACED THE BOLT ON FORWARD LATCH PIN FITTING AFT CARGO DOOR IAW EMB 170 AMM 20-10-01. THE AIRCRAFT IS OUT OSDR R61A201211220687Panel · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE WASTE SERVICE DOOR CORRODED. MAINTENANCE REMOVED AND REPLACED THE WASTE SERVICE DOOR PANEL IAW EMB AMM 53-03-60. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201211220684Bearing Support · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE BEARING SUPPORT BETWEEN RIGHT FLAP TORQUE TUBES 5 AND 6 CORRODED. MAINTENANCE REMOVED AND REPLACED THE RIGHT FLAP TORQUE TUBE BEARING SUPPORT BETWEEN TUBES 5 AND 6 IAW EMB 170 AMM 27-51-04. THE AIRCRAFTSDR R61A201211220683Torque Tube · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT FLAP TORQUE TUBE NUMBER 6 CORRODED. MAINTENANCE REMOVED AND REPLACED THE RIGHT FLAP TORQUE TUBE NUMBER 6 IAW EMB 170 AMM 27-51-03. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201211220682Torque Tube · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND RIGHT FLAP TORQUE TUBE 5 CORRODED. MAINTENANCE REMOVED AND REPLACED THE RIGHT FLAP TORQUE TUBE 5 IAW EMB 170 AMM 27-51-03. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201211220659Floorbeam · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT FLOORBEAM CORRODED AT FRAMES 84 AND 89. MAINTENANCE REMOVED AND REPLACED THE RIGHT FLOORBEAM AT FRAMES 84 TO 89 IAW EMB 170 SRM 51-42-01 AND 51-43-03. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECKSDR R61A201211210694Seat Track · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE CENTER FUSELAGE RIGHT INBOARD SEAT TRACK BETWEEN FRAMES 84 AND 85 CORRODED. MAINTENANCE REMOVED AND REPLACED THE CENTER FUSELAGE RIGHT INBOARD SEAT TRACK IAW EMB SRM 51-43-01, AND 51-43-02. THE AIRCRAFTSDR R61A201211210693Seat Track · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT FUSELAGE FORWARD NUMBER 1 SEAT TRACK CORRODED FRAMES 16 AND 19. MAINTENANCE REMOVED AND REPLACED THE LEFT FORWARD NUMBER 1 SEAT TRACK IAW EMB 170 SRM 51-40-02, 51-41-01, 51-43-01, AND 51-43-02. THESDR R61A201211210685Torque Tube · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT FLAP TORQUE TUBE NUMBER 5 CORRODED. MAINTENANCE REMOVED AND REPLACED THE LEFT NUMBER 5 FLAP TORQUE TUBE IAW EMB 170 AMM 27-51-03. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201211210681Splice · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE CENTER SPLICE AT FRAME 90 CORRODED. MAINTENANCE REMOVED AND REPLACED THE CENTER SPLICE AT FRAME 90 IAW EMB 170 SRM 51-40-02, 51-43-01, 51-41-02, 51-23-05, AND 51-23-06. THE AIRCRAFT IS OUT OF SERVICE INSDR R61A201211210680Plate · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND RIGHT INBOARD GUSSET PLATE AT FRAME 90 CORRODED. MAINTENANCE REMOVED AND REPLACED THE RIGHT INBOARD GUSSET PLATE AT FRAME 90 IAW EMB 170 SRM 51-40-02, 51-43-01, 51-41-02, 51-23-05 AND 51-23-06. THE AIRCRAFTSDR R61A201211210661Panel · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE CENTER SHEAR PANEL AT FRAMES 87 TO 88 CORRODED. MAINTENANCE REMOVED AND REPLACED THE CENTER SHEAR PANEL AT FRAMES 87 TO 88 IAW EMB 170 SRM 51-42-01 AND 51-42-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY SDR R61A201211210660Shear Plate · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT SHEAR PLATE AT FRAMES 87 TO 88 CORRODED. MAINTENANCE REMOVED AND REPLACED THE LEFT SHEAR PLATE AT FRAMES 87 TO 88 IAW EMB 170 SRM 51-42-01 AND 51-42-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECSDR R61A201211210658Support · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT RAM AIR DUCT SUPPORT CRACKED. MAINTENANCE REMOVED AND REPLACED THE LEFT RAM AIR DUCT SUPPORT IAW EMB 170 SRM 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201211210657Support · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT RAM AIR DUCT SUPPORT CRACKED. MAINTENANCE REMOVED AND REPLACED THE LEFT RAM AIR DUCT SUPPORT IAW EMB 170 SRM 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201211210656Bolt · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE AFT SERVICE DOOR R2 LOWER EVACUATION SLIDE MOUNTING HARDWARE CORRODED. MAINTENANCE REMOVED AND REPLACED THE HARDWARE AFT SERVICE DOOR R2 LOWER EVACUATION SLIDE MOUNT. THE AIRCRAFT IS OUT OF SERVICE IN HSDR R61A201211210655Bolt · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE AFT PASSENGER DOOR LOWER EVACUATION SLIDE MOUNTING HARDWARE CORRODED. MAINTENANCE REMOVED AND REPLACED HARDWARE AFT PASSENGER LOWER EVACUATION SLIDE MOUNT. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201211210654Bolt · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND FORWARD PASSENGER DOOR LOWER EVACUATION SLIDE MOUNTING HARDWARE CORRODED. MAINTENANCE REMOVED AND REPLACED HARDWARE FORWARD PASSENGER LOWER EVACUATION SLIDE MOUNT. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHSDR R61A201211010635Spar · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND RIGHT WING SPAR 2 AT RIB 10 CRACKED AT A3 AND A4 HOLES. MAJOR REPAIR, MAINTENANCE REPAIRED RIGHT WING SPAR 2, AT RIB 10, A3, AND A4 HOLES IAW EMB ETD 2012-170-015618-D REVISION D. THE AIRCRAFT IS OUT OF SERSDR R61A201210300631Support · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE POTABLE WATER BRACKET AFT OF GPU RECEPTICAL BROKEN. MAINTENANCE REMOVED AND REPLACED POTABLE WATER HOSE SUPPORT IAW EMB 170 SRM 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201210290646Spar · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND CRACK LIKE INDICATIONS LEFT WING SPAR 2 A 3 HOLE. MAINTENANCE REAMED LEFT WING SPAR 2 A3 HOLE TO .590 IAW S/B 170-57-0053. THE AIRCRAFT IS SCHEDULED FOR CHECK FLIGHT 11-18-2012.SDR R61A201210290645Spar · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT WING SPAR 2 A2 HOLE HAS CRACK LIKE INDICATIONS. REAMED RIGHT WING SPAR 2 A2 HOLE TO .590 IAW S/B170-57-0053. THE AIRCRAFT IS SCHEDULED FOR CHECK FLIGHT 11-19-2012.SDR R61A201210280632Support · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE STEERING MANIFOLD SUPPORT CRACKED. MAINTENANCE REMOVED AND REPLACED THE STEERING MANIFOLD BRACKET IAW EMB 170 SRM 51-43-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201210280629Floor Support · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT FLOOR SUPPORT BEAM CORRODED AT FRAMES 88 TO 89. MAINTENANCE REMOVED AND REPLACED THE LEFT FLOORBEAM AT FRAMES 88 TO 89 IAW EMB 170 SRM 51-43-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201210270630Damper · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE L1 DOOR DAMPER CORRODED. MAINTENANCE REMOVED AND REPLACED THE L1 DOOR DAMPER IAW EMB 170 AMM 52-11-27. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201210270619Support · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK CORROSION WAS FOUND ON OXYGEN BOTTLE SUPPORT. SUPPORT WAS REMOVED AND REPLACED PER EMB 170 SRM WHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK.
Back to Embraer ERJ 170-100SU