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 R61A201302240201Rib · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTNENACE FOUND THE LEFT HORIZONTAL STABILIZER RIB 11A CRACKED. MAINTENANCE REPAIRED LEFT HORIZONTAL STABILIZER RIB 11A IAW ETD 2013-170-003662. "MAJOR REPAIR" THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302240189Support · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE FORWARD CARGO DOOR NUT PLATE SUPPORT FOR DOOR SURROUND CORRODED. MAINTENANCE REMOVED AND REPLACED NUT PLATE SUPPORT IAW EMB 170 SRM 51-40-02 AND 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302240185Beam · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND RIGHT BEAM BETWEEN FRAME 85 AND 90 CORRODED. MAINTENANCE REMOVED AND REPLACED BEAM IAW EMB 170 SRM 51-43-03, 51-41-01, AND 51-40-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302230256Torque Tube · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT F6 FLAP TORQUE TUBE CORRODED. MAINTENANCE REMOVED AND REPLACED THE RIGHT F6 FLAP TORQUE TUBE IAW EMB 170 AMM 27-51-03SDR R61A201302230255Torque Tube · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT F3 FLAP TORQUE TUBE CORRODED. MAINTENANCE REMOVED AND REPLACED THE RIGHT F3 FLAP TORQUE TUBE IAW EMB 170 AMM 27-51-03. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302230247Rib · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT HORIZONTAL STABILIZER RIB 11A CRACKED. MAINTENANCE REPAIRED THE LEFT HORIZONTAL STABILIZER RIB 11A IAW EMB ETD 2013-170-003597-B REV B. MAJOR REPAIR, THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302230236Rib · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT HORIZONTAL STABILIZER RIB 10A CRACKED. MAINTENANCE REPAIRED THE RIGHT HORIZONTAL STABILIZER RIB 10A IAW EMB ETD 2013-170-003597. MAJOR REPAIR, THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302230235Rib · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT HORIZONTAL STABILIZER RIB 11A CRACKED. MAINTENANCE REPAIRED THE RIGHT HORIZONTAL STABILIZER RIB 11A IAW EMB ETD 2013-170-003597. MAJOR REPAIR, THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302230234Rib · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT HORIZONTAL STABILIZER RIB 12A CRACKED. MAINTENANCE REPAIRED THE RIGHT HORIZONTAL STABILIZER RIB 12A IAW EMB ETD 2013-170-003597. MAJOR REPAIR, THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302230217Seat Track · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT SEAT TRACK AT FRAME 84 CORRODED. MAINTENANCE REMOVED AND REPLACED LEFT SEAT TRACK AT FRAME 84 IAW EMB 170 SRM 51-40-02, 51-41-01, AND 51-43-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302230202Panel Support · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT PANEL SUPPORT AT FRAME 84 CORRODED. MAINTENANCE REMOVED AND REPLACED THE RIGHT PANEL SUPPORT AT FRAME 84 IAW EMB 170 SRM 51-41-01, AND 51-41-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302220260Seal Depressor · gougedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE L1 FORWARD PASSENGER DOOR SEAL DEPRESSOR GOUGED. MAINTENANCE REMOVED AND REPLACED THE L1 FORWARD SEAL DEPRESSOR IAW EMB 170 SRM 51-41-01 AND 51-43-01. MAJOR REPAIR, THE AIRCRAFT IS OUT OF SERVICE IN HSDR R61A201302220259Trim Panel · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE AFT GALLEY HALVES CORRODED. MAINTENANCE REMOVED AND REPLACED AFT GALLEY TRIM IAW EMB 170 AMM 25-00-23 AND 20-10-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302220258Bracket · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE AFT GALLEY HALVES HAVE CORROSION. MAINTENANCE REMOVED AND REPLACED THE AFT GALLEY SPLIT JOINT BRACKET IAW EMB 170 AMM 25-00-23 AND 20-10-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302220257Trim Panel · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE AFT GALLEY HALF TRIM PANELS CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFT GALLEY TRIM IAW EMB 170 AMM 25-00-23 AND 20-10-01. THE AIRCRAFT IS OUT OF SERVICE IN HR\EAVY CHECK.SDR R61A201302150165Unknown · odorCREW REPORTED COCKPIT AIR SMELLS THICK - HAS AN ODOR AND THERE IS A GREASY FILM BEING FELT ON ALL, RESULTING IN COUGHS AND HEADACHES. MAINTENANCE RAN PACKS 1 & 2 WITH APU BLEED, ENGINE 1 BLEED THEN ENGINE 2 BLEED. SMELL COULD NOT BE DUPLICATED, A/C GOOD FOR SDR R61A201302140162Support Bracket · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND SUPPORT BRACKET AT FRAME 86 BROKEN. MAINTENANCE REMOVED AND REPLACED THE BRACKET AT FRAME 86 IAW EMB 170 SRM 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302130155Fairing · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT 195 UPPER FAIRING SKIRT CRACKED. MAINTENANCE REPAIRED THE RIGHT 195 UPPER FAIRING SKIRT IAW EMB ETD2013-170-002709. THE AIRCRAFT WAS RELEASED FROM HEAVY CHECK 2-15-13.SDR R61A201302130153Hose · brokenWHILE IN FLIGHT FROM DCA TO BDL CREW REPORTED WING ANTI-ICE FAIL WHILE IN ICING CONDITIONS. CREW RETURNED TO DCA AND LANDED WITHOUT INCIDENT. MAINTENANCE REMOVED AND REPLACED INTERCONNECTION HOSE PER EMB AMM AND OPS CHECKED GOOD.SDR R61A201302120161Beam · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND BEAM CRACKED FOR OUTBOARD TCAS MOUNTING BRACKET. MAINTENANCE REMOVED AND REPLACED BEAM IAW EMB 170 SRM 51-41-01, 51-40-02, AND 51-43-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302110143Oxygen Mask · deployedROW 14 D F OXYGEN MASKS DEPLOYED UPON LANDING. MAINTENANCE RE-SECURED O2 MASKS PER EMB AMM 25-22-0. OPS CHECKED GOOD.SDR R61A201302090129Windshield · crackedAFTER FLIGHT FROM PHL TO BNA, AIRCRAFT WAS TAXIING TO GATE NORMALLY WITH NO FAIL OR FAULT MESSAGES PRESENT. CREW REPORTED FLAMES STARTED COMING FROM THE FIRST OFFICERS WINDSHIELD AND COULD SEE THE WINDSHIELD CRACK AND START TO MELT. FIRE DEPARTMENT WAS CALLESDR R61A201302080148Crossbeam · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND CROSSBEAM AT FRAME 84 CORRODED IN THE CENTER. MAINTENANCE REPAIRED CROSS BEAM AT FRAME 84 IAW EMB ETD2013-170-002389-B REV B. "MAJOR REPAIR", THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302070163Support · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT PANEL SUPPORT AFT OF R2 DOOR CORRODED. MAINTENANCE REMOVED AND REPLACED THE PANEL SUPPORT AFT OF THE R2 DOOR IAW EMB 170 SRM 51-40-02, 51-42-01, AND 51-43-01. THE AIRCRAFT IS OUT OF SERVICE IN HEASDR R61A201302070160Rib · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT WING RIB 10 CRACKED. MAINTENANCE REMOVED AND REPLACED THE LEFT WING RIB 10 IAW EMB 170 SRM 51-40-02, 51-43-01, AND 51-43-02. "MAJOR REPAIR", THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302070159Clamp · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT ACM INLET DUCT SUPPORT CLAMP CRACKED. MAINTENANCE REMOVED AND REPLACED THE RIGHT ACM INLET DUCT CLAMP SUPPORT IASW EMB 170 SRM 51-41-01, AND 51-40-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECSDR R61A201302070158Structure · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE AFT WASTE BOX CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFT WASTE BOX IAW EMB 170 SB 170-53-0095. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302070151Shear Plate · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT SHEAR PLATE AT FRAMES 87 AND 88 CORRODED. MAINTENANCE REMOVED AND REPLACED THE LEFT SHEAR PLATE AT FRAMES 87 AND 88 IAW EMB 170 51-40-02, 51-42-01, AND 51-43-01. THE AIRCRAFT IS OUT OF SERVICE IN HSDR R61A201302070150Splice · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT SHEAR PLATE SPLICE AT FRAMES 87 AND 88 CORRODED. MAINTENANCE REMOVED AND REPLACED THE LEFT SHEAR PLATE SPLICE AT FRAMES 87 AND 88 IAW EMB 51-40-02, AND 51-42-02. THE AIRCRAFT IS OUT OF SERVICE IN HSDR R61A201302070149Gusset · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT GUSSET PLATE AT FRAME 90 CORRODED. MAINTENANCE REMOVED AND REPLACED RIGHT GUSSET PLATE AT FRAME 90 IAW EMB 170 SRM 51-40-02, AND 51-41-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302070140Spar · damagedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND 2 FASTENER HOLES LEFT WING PREVIOUS "MAJOR REPAIR " TO WING SPAR BORE TOLERANCES OUT OF LIMITS. MAINTENANCE REPAIRED 2 FASTENER HOLES IAW EMB ETD 2013-170-000185-B. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CSDR R61A201302070137Panel · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE CENTER SHEAR PANEL FRAMES 87 TO 88 CORRODED. MAINTENANCE REMOVED AND REPLACED THE CENTER SHEAR PANEL FRAMES 87 TO 88 IAW EMB 170 SRM 51-42-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302070136Shear Plate · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT SHEAR PLATE AT FRAMES 87 TO 88 CORRODED. MAINTENANCE REMOVED AND REPLACED THE RIGHT SHEAR PLATE AT FRAMES 87 TO 88 IAW EMB 170 SRM 51-42-02, 51-42-01, AND 51-43-03. THE AIRCRAFT IS OUT OF SERVICE SDR R61A201302070135Dampener · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE L2 DOOR DAMPNER CORRODED. MAINTENANCE REMOVED AND REPLACED THE L2 DOOR DAMPNER IAW EMB 170 AMM 52-12-27. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302070134Stop Fitting · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LOWER STOP ON L2 DOOR CUTOUT CORRODED. MAINTENANCE REMOVED AND REPLACED STOP IAW EMB 170 AMM 53--23-21. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302070133Seat Track · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND LEFT SEAT TRACK AT FRAME 88 CORRODED. MAINTENANCE REMOVED AND REPLACED THE LEFT SEAT TRACK AT FRAME 88 IAW EMB 170 SRM 51-40-02, 51-43-03, AND 51-42-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302040125Fitting · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND SHEAR CLIP AT FRAME 88 FORWARD OF LAVATORY WASTE BOX CORRODED. MAINTENANCE REMOVED AND REPLACED SHEAR CLIP IAW EMB 170 SRM 51-41-01 AND 51-41-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302040108Slide · unwanted deployCREW REPORTED THAT WHEN CATERING OPENED THE L2 DOOR, THE GIRT BAR DID NOT DISENGAGE AND THE SLIDE NOW NEEDS TO BE REPLACED. MAINTENANCE REMOVED AND REPLACED L2 DOOR CABLE PER EMB AMM AND OPS CHECKED GOOD.SDR R61A201302030126Doubler · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND DOUBLER UNDER LAVATORY BOX CORRODED. MAINTENANCE REMOVED AND REPLACED DOUBLER IAW EMB 170 SRM 51-41-01, 51-41-02, AND 51-43-04. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302030124Bracket · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND BRACKET CRACKED VERTICAL STABILIZER REAR SPAR ABOVE THIRD RUDDER ATTACH HINGE. MAINTENANCE REPAIRED BRACKET IAW EMB ETD02013-170-002161-C REV C. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201302010156Bracket · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE NLG STEERING MANIFOLD BRACKET CRACKED. MAINTENANCE REMOVED AND REPLACED THE NLG STEERING MANIFOLD BRACKET IAW EMB 170 SRM51-41-01, AND 51-43-01. THE AIRCRAFT WAS RETURNED TO SERVICE OUT OF HEAVY CHECK 2SDR R61A201302010132Seal Seat · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE FORWARD CARGO DOOR LOWER FORWARD SEAL REST CORRODED. MAINTENANCE REMOVED AND REPLACED THE FORWARD CARGO DOOR LOWER FORWARD SEAL REST IAW EMB 170 SRM 51-40-02, AND 51-41-01. THE AIRCRAFT IS OUT OF SERVICSDR R61A201302010131Seal Seat · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE FORWARD CARGO DOOR LOWER CENTER SEAL REST CORRODED. MAINTENANCE REMOVED AND REPLACED THE FORWARD CARGO DOOR LOWER CENTER SEAL REST IAW EMB SRM 51-40-02, AND 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HSDR R61A201302010112Shear Tie · corrodedDURING HEAVY CHECK, MAINTENANCE FOUND THE CF3 BELLY SHEAR TIE AT FRAME 83 CORRODED. MAINTENANCE REMOVED AND REPLACED SHEAR TIEIAW SRM 51-41-01 AND 51-41-02. MAJOR REPAIR.SDR R61A201301300144Damper · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE R1 DOOR DAMPER CORRODED. MAINTENANCE REMOVED AND REPLACED THE R1 DOOR DAMPER IAW EMB 170 AMM 52-41-27. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201301300138Service Panel · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE WASTE SERVICE BOX CORRODED. MAINTENANCE REMOVED AND REPLACED THE WASTE BOX IAW EMB 170 SRM 51-43-03, AND 51-43-04. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201301300111Support · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND LEFT RAM AIR DUCT SUPPORT ASSEMBLY CRACKED. MAINTENANCE REMOVED AND REPLACED THE SUPPORT ASSEMBLY IAW EMB 170 SRM 51-31-00 AND 51-41-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201301300110Support · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT RAM AIR DUCT SUPPORT CRACKED. MAINTENANCE REMOVED AND REPLACED SUPPORT IAW EMB 170 SRM 51-31-11 AND 51-41-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201301300109Profile · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT RAM AIR DUCT PROFILE CRACKED. MAINTENANCE REMOVED AND REPLACED PROFILE IAW EMB 170 SRM 51-31-00 AND 51-41-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201301300105Support · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT RAM AIR DUCT SUPPORT CRACKED. MAINTENANCE REMOVED AND REPLACED THE RIGHT RAM AIR DUCT SUPPORT IAW EMB 170 SRM 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.
Back to Embraer ERJ 170-100SU