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 R61A201301300095Bearing Support · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT WING F6 TORQUE TUBE BEARING SUPPORT CORRODED. MAINTENANCE REMOVED AND REPLACED THE RIGHT WING F6 BEARING SUPPORT IAW EMB 170 AMM 27-51-03. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201301300094Torque Tube · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT WING F6 TORQUE TUBE SPLINE CORRODED. MAINTENANCE REMOVED AND REPLACED THE RIGHT WING F6 TORQUE TUBE IAW EMB 170 AMM 27-51-03. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201301300093Windshield · crackedEN ROUTE FROM PHL TO CYHZ, CREW REPORTED A LOUD BANG WAS HEARD. CAPTAIN NOTICED THAT HIS WINDSHIELD WAS SHATTERED AND RETURNED TO PHL WITHOUT INCIDENT. MAINTENANCE REMOVED AND REPLACED WINDSHIELD PER EMB AMM AND OPS CHECKED GOOD.SDR R61A201301290157Connector · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE FORWARD LAVATORY TOILET ELECTRICAL HARNESS CONNECTORS CORRODED. MAINTENANCE REMOVED AND REPLACED THE FORWARD TOILET ASSEMBLY IAW EMB 170 AMM 38-33-02. THE AIRCRAFT WAS RELEASED FROM HEAVY CHECK ON 2-15-SDR R61A201301290139Bracket · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE FORWARD HALF OF AFT GALLEY UNION CORRODED. MAINTENANCE REMOVED AND REPLACED THE SPLIT JOINT BRACKET IAW EMB 170 SRM 51-40-00. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201301280113Rib · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT WING RIB 10 EXTENSION CRACKED. MAINTENANCE REMOVED AND REPLACED THE RIGHT WING RIB 10 EXTENSION IAW EMB 170 SRM 51-40-02, 51-43-03, 51-43-04, 51-43-01, 51-43-02, AND 51-21-05. "MAJOR REPAIR" THESDR R61A20130128079Slide · damagedCREW REPORTED L1 DOOR BUSTLE WAS LOOSE. MX INSPECTED AND FOUND THE SLIDE FRAME TO BE BROKEN. MX REMOVED AND REPLACED SLIDE PER EMB AMM AND OPS CHECKED GOOD.SDR R61A20130118065Apu · malfunctionedCREW REPORTED WHILE SITTING AT THE GATE WITH THE APU RUNNING NOTICED A HOT ELECTRICAL SMELL THEN SMOKE FILLED THE CABIN. A RAMP AGENT ALERTED THE CREW THAT THE APU WAS ON FIRE AND THROWING SPARKS. THE CREW UTILIZED THE EMERGENCY STOP AND FIRE TRUCKS WERE ROLSDR R61A20130110051Flashlight · inoperativeCAPTAIN REPORTED FLASHLIGHT BATTERY OUT OF POWER. MX REMOVED AND REPLACED CAPTAIN'S FLASHLIGHT PER EMB AMM 33-51-01.SDR R61A20130108050Battery · faultyCREW REPORTED RECEIVING AN EMERGENCY LIGHT BATTERY FAULT AFTER ARRIVAL TO THE GATE. MX TROUBLESHOT TO FWD BATTERIES AND REMOVED AND REPLACED PER EMB AMM.SDR R61A201301070046Seat Track · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT FORWARD SEAT TRACK AT FRAME 13 CORRODED. MAINTNENACE REMOVED AND REPLACED THE LEFT FORWARD SEAT TRACK IAW EMB 170 SRM 51-41-01, 51-41-02, 51-43-01, AND 51-43-02. THE AIRCRAFT IS OUT OF SERVICE IN HSDR R61A201301070044Sill · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT FLOOR SILL AFT OF FRAME 19 CORRODED. MAINTENANCE REMOVED AND REPLACED THE LEFT FLOOR SILL PLATE AFT OF FRAME 19 IAW EMB 170 SRM 51-40-02, 51-41-02, AND 51-43-03. THE AIRCRAFT IS OUT OF SERVICE IN HSDR R61A201301070043Doubler · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND LEFT FLOOR DOUBLER AT FRAME 19 CORRODED. MAINTENANCE REMOVED AND REPLACED THE LEFT FLOOR DOUBLER AT FRAME 19 IAW EMB 170 SRM 51-41-02, 51-43-04, AND 51-41-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201301070042Sill · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND RIGHT SILL PANEL AT FRAME 14 CORRODED. MAINTENANCE REMOVED AND REPLACED THE RIGHT SILL PANEL AT FRAME 14 IAW EMB 170 SRM 51-40-02, 51-40-04, 51-41-01 AND 51-43-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHSDR R61A201301070032Seat Track · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND RIGHT FORWARD SEAT TRACK AT FRAME 17 CORRODED. MAINTENANCE REMOVED AND REPLACED THE RIGHT FORWARD SEAT TRACK IAW EMB 170 SRM 51-42-02.SDR R61A201301070029Seal Depressor · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE FORWARD LOWER SEAL DEPRESSOR AFT CARGO DOOR CORRODED. MAINTENANCE REMOVED AND REPLACED FORWARD LOWER SEAL DEPRESSOR AFT CARGO DOOR IAW EMB 170 SRM 51-40-02, 51-41-01, 51-21-02, AND AMM 20-10-01. THE AIRSDR R61A201301070031Depressor · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE AFT LOWER SEAL DEPRESSOR AFT CARGO DOOR CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFT LOWER SEAL DEPRESSOR AFT CARGO DOOR IAW EMB 170 SRM 51-40-02, 51-41-01, 51-21-02, AND AMM 20-10-01. THE AIRCRAFSDR R61A201301070030Depressor · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE CENTER LOWER SEAL DEPRESSOR AFT CARGO DOOR CORRODED. MAINTENANCE REMOVED AND REPLACED THE CENTER LOWER SEAL DEPRESSOR AFT CARGO DOOR IAW EMB 170 SRM 51-40-02, 51-41-01, 51-21-02, AND AMM 20-10-01. THE ASDR R61A20130106039Battery · faultyCREW REPORTED THAT WHILE SETTING AT THE GATE THEY KEPT GETTING A EMERGENCY LIGHT BATT FAULT THAT WOULD COME AND GO. MX TROUBLESHOT DOWN TO THE AFT BATTERIES, PER EMB AMM. REPLACED BOTH AFT BATTERIES, OPS CHECK GOOD.SDR R61A201301060036Bracket · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE FCS BACKUP BATTERY FORWARD MOUNT BRACKET CRACKED. MAINTENANCE REMOVED AND REPLACED BRACKET IAW EMB 170 SRM 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A20130104040Fitting · lack of lubeL1 DOOR HARD TO OPEN AND CLOSE PER GATE AGENT. MX LUBED L1 DOOR FITTING ON DOOR HANDLE PER EMB AMM 52-11-0, OPS CHECKED GOOD.SDR R61A20130104038I/O Module · faultedCREW REPORTED EMERGENCY BATT FAULT AFTER TURNING OFF EMERGENCY LIGHTS AND MAIN BATTERIES. DCA MX TROUBLESHOT PER EMB AMM TO GEN I/O IN MAU 1. MX REPLACING GEN I/O IN MAU 1 PER EMB AMM.SDR R61A201301030055Floor Support · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT FLOOR PANEL SUPPORT AFT OF R2 DOOR CORRODED. MAINTENANCE REMOVED AND REPLACED THE PANEL SUPPORT AFT OF R2 DOOR IAW EMB 170 SRM 51-42-01, AND 51-43-03. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECKSDR R61A201301030028Shear Tie · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE SHEAR TIE AT FRAME 88 STRINGERS 27R AND 28R CORRODED. MAINTENANCE REMOVED AND REPLACE SHEAR TIE IAW EMB 170 SRM 51-40-02, 51-41-02, AND 51-43-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201301030027Doubler · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LAVATORY SERVICE BOX FORWARD DOUBLER CORRODED. MAINTENANCE REMOVED AND REPLACED THE FORWARD DOUBLER LAVATORY SERVICE BOX IAW EMB 170 SRM 51-40-02 AND 51-43-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHSDR R61A201301030019Gusset · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT FLOOR GUSSET AT FRAME 90 CORRODED. MAINTENANCE REMOVED AND REPLACED THE RIGHT FLOOR GUSSET AT FRAME 90 IAW EMB 170 SRM 51-41-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201301020026Profile · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT PACK EMERGENCY VALVE PROFILE CRACKED. MAINTENANCE REMOVED AND REPLACED THE LEFT PACK EMERGENCY VALVE PROFILE IAW EMB 170 SRM 51-40-02, AND 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201301020025Support · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT EMERGENCY PACK VALVE SUPPORT CRACKED. MAINTENANCE REMOVED AND REPLACED THE LEFT EMERGENCY PACK VALVE SUPPORT IAW EMB 170 SRM 51-40-02, AND 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201301020004Panel · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE CENTER SHEAR PANEL BETWEEN FRAMES 87 AND 88 CORRODED. MAINTENANCE REMOVED AND REPLACED THE CENTER SHEAR PANEL FRAMES 87 AND 88 IAW EMB 170 SRM 51-42-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201301020003Control Rod · out of adjustL2 DOOR FAILED EMERGENCY SLIDE ASSIST BOTTLE FUNCTIONAL CHECK. MAINTENANCE ADJUSTED THE L2 DOOR EMERGENCY SLIDE HANDLE CONTROL ROD IAW EMB 170 AMM 52-12-52. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201301010045Bolt · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE L2 DOOR EMERGENCY SLIDE MOUNT BOLTS CORRODED. MAINTENANCE REMOVED AND REPLACED BOLTS IAW EMB 170 AMM 20-10-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A20130101041Unknown · malfunctionedCREW REPORTED ON TAXI IN RECEIVING AN EMERGENCY BRAKE FAULT AND UNABLE TO MOVE. MX PERFORMED AN OPS CHECK OF PARKING BRAKE SYSTEM IAW EMB AMM 32-44-00 AND OPS CHECKED GOOD.SDR R61A201301010035Rib · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND LEFT WING RIB 10 EXTENSION CRACKED. MAINTENANCE REMOVED AND REPLACED RIB 10 EXTENSION LEFT WING IAW EMB 170 SRM 51-43-01, AND 51-43-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK. MAJOR REPAIRSDR R61A201301010034Seal Seat · gougedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE L1 DOOR AFT SEAL REST GOUGED. MAINTENANCE REMOVED AND REPLACED L1 DOOR AFT SEAL REST. "MAJOR REPAIR" THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201301010033Seal Seat · gougedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND L1 DOOR FORWARD SEAL REST GOUGED. MAINTENANCE REMOVED AND REPLACED THE L1 DOOR FORWARD SEAL REST IAW EMB 170 SRM 51-40-02, 51-41-01, AND 51-43-01. "MAJOR REPAIR" THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECSDR R61A201301010024Bolt · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE L1 DOOR EMERGENCY SLIDE SUPPORT BOLTS CORRODED. MAINTENANCE REMOVED AND REPLACED THE L1 DOOR EMERGENCY SLIDE SUPPORT BOLTS IAW EMB 170 AMM 21-10-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201301010023Bolt · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE L2 DOOR EMERGENCY SLIDE AFT FITTING BOLTS CORRODED. MAINTENANCE REMOVED AND REPLACED BOLTS IAW EMB 170 AMM 53-23-25. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201301010022Screw · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE L2 DOOR EMERGENCY SLIDE ACTUATION CABLE SCREWS CORRODED. MAINTENANCE REMOVED AND REPLACED SCREWS IAW EMB 170 AMM 52-12-40. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201301010021Bolt · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE L2 DOOR EMERGENCY SLIDE BOLTS LOWER DOOR FRAME CORRODED. MAINTENANCE REMOVED AND REPLACED L2 BOLTS EMERGENCY SLIDE LOWER DOOR FRAME IAW EMB 170 AMM 20-10-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECSDR R61A201301010020Dampener · 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 R61A201301010018Panel · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND RIGHT SHEAR PANEL AT FRAMES 87 AND 88 CORRODED. MAINTENANCE REMOVED AND REPLACED THE RIGHT SHEAR PANEL AT FRAMES 87 AND 88 IAW EMB 170 SRM 51-42-01 AND 51-42-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECSDR R61A201301010017Bracket · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND A BROKEN BRACKET AFT WET AREA FRAME 86. MAINTENANCE REMOVED AND REPLACED BRACKET AFT WET AREA FRAME 86 IAW EMB 170 SRM 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201312310049Seal Seat · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE AFT LOWER FORWARD CARGO DOOR CUTOUT SEAL REST CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFT LOWER SEAL REST IAW EMB 170 SRM 51-40-02, 51-41-00, AND AMM 20-10-02. THE AIRCRAFT IS OUT OF SERVICE IN HSDR R61A201312310048Seal Seat · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE CENTER LOWER SEAL REST AT FORWARD CARGO DOOR CUTOUT CORRODED. MAINTENANCE REMOVED AND REPLACED THE CENTER LOWER SEAL REST IAW EMB 170 SRM 51-40-02, 51-41-00, AND AMM 20-10-02. THE AIRCRAFT IS OUT OF SERSDR R61A201312310047Seal Seat · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE FORWARD LOWER SEAL REST FWD CARGO DOOR CUTOUT CORRODED. MAINTENANCE REMOVED AND REPLACED THE FORWARD LOWER SEAL REST IAW EMB 170 SRM 51-40-02, 51-41-00, AND AMM 20-10-02. THE AIRCRAFT IS OUT OF SERVICE SDR R61A201212260498Rib · crackedDURING HEAVY CHECK, RT RIB NR 10 AT SPAR NR 2 IS CRACKED. R & R RT RIB IAW SRM 51-43-01, 51-43-02.SDR R61A20130104015Warning System · activatedCREW REPORTED AN EMERGENCY LIGHT BATTERY FAULT ON LANDING. AIRCRAFT WAS FERRIED FROM BDL TO DCA. MAINTENANCE FOLLOWED THE FIM, FOUND CORRELATED ACTIVE FAULTS PER EMB AMM AND OPS CHECKED GOOD.SDR R61A201212180755Spar · crackedWHILE AIRCRAFT WAS OUT OF SERVICE FOR MAINTENANCE WORKING SB 170-57-0053 MAINTENANCE FOUND THE A3 HOLE ON LEFT WING HAS CRACK LIKE INDICATIONS. MAINTENANCE REPAIRED LEFT WING A3 HOLE IAW SB 170-57-0053. THE AIRCRAFT IS STILL OUT OF SERVICE CMH.SDR R61A201212100726Doubler · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND CORROSION ON SHEAR PLATE/ DOUBLER UNDER OBSERVERS CONSOLE. MAINTENANCE REPAIRED DAMAGE IAW EMB ETD 2012-170-018104. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212100725Doubler · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND CORROSION ON SHEAR PLATE/ DOUBLER ON FLOOR STRUCTURE AFT OF THE PILOT SEAT. MAINTENANCE BLENDED DAMAGE TO SHEAR PLATE/ DOUBLER IAW EMB ETD 2012-170-018104. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.
Back to Embraer ERJ 170-100SU