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 R61A20100287Sill · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT OUTBOARD FLOOR SUPPORT SILL BETWEEN FR 88 AND FR 90. MAINTENANCE REMOVED AND REPLACED THE RT SILL PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100286Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT GUSSET AT FR 90. MAINTENANCE REMOVED AND REPLACED GUSSET PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100285Fitting · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON SHEAR CLIP AT FR 88, BETWEEN STR 28R AND 27R. MAINTENANCE REMOVED AND REPLACED THE SHEAR CLIP PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100282Support · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT SEAT TRACK CENTER FLOORBEAM FROM FR 85 TO FR 89. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK SUPPORT PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100281Fitting · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON SHEAR CLIP AROUND FASTENERS AT FR 87, BY STR 28R. MAINTENANCE REMOVED AND REPLACED THE SHEAR CLIP PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100280Fitting · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON SHEAR CLIP AROUND FASTENERS AT FR 85, BY STR 28R. MAINTENANCE REMOVED AND REPLACED SHEAR CLIP PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100279Splice Plate · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT AND RT SPLICE FLOOR PLATES AT FR 88. MAINTENANCE REMOVED AND REPLACED LT AND RT FLOOR SPLICE PLATES PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100278Panel · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON CENTER SHEAR PANEL AROUND FASTENERS AT FR 88. MAINTENANCE REMOVED AND REPLACED CENTER SHEAR PANEL PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100277Structure · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND AT WASTE SERVICE BOX. MAINTENANCE REMOVED AND REPLACED THE WASTE SERVICE BOX PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R612010F00000Panel · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LEFT SHEAR PANEL AROUND FASTENERS AT FR 88. MAINTENANCE REMOVED AND REPLACED THE SHEAR PANEL PER THE EMB SRM. AC STILL OUT SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100283Bracket · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON BRACKETS, ON INTERNAL SIDE OF WASTE SERVICE STRUCTURE. MAINTENANCE REMOVED AND REPLACED THE BRACKETS PER THE EMB SRM (P/N'S 170-86657-003 AND 170-86656-003). AC STILL OUT OF SERVICE FOR HEAVY SDR R61A20100273Stiffener · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND UNDER RT NUMBER THREE PYLON ENGINE HEAT SHIELD ON THE INTERNAL STIFFENERS. MAINTENANCE REMOVED AND REPLACED THE CORRODED INTERNAL STIFFENERS (P/N 170-39583-001 AND 170-39583-002) PER THE EMB SRM. SDR R61A20100272Seat Track · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT SEAT TRACK BEAM FROM FR 85 TO FR 89. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK BEAM PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100271Heat Shield · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT ENGINE NUMBER FOUR HEAT SHIELD AND INTERNAL STIFFENERS ON BOTTOM. MAINTENANCE REMOVED AND REPLACED THE HEAT SHIELD (P/N 170-39554-001) AND INTERNAL STIFFENERS (P/N 170-34584-001) PER THE EMBSDR R61A20100270Shear Web · corroded*** GENERATED WHILE A/C IN HEAVY CHECK *** LT SIDE OF FR 87-88 JUST AFT OF L-2 CORRODED. MAINTENANCE REMOVED AND REPLACED SHEAR WEB AT STA 87-88, FABRICATED NEW SHEAR WEB PER SRM 51-40-02 AND SRM 51-42-00.SDR R61A20100269Shear Web · corroded*** GENERATED WHILE A/C WAS IN HEAVY CHECK *** FWD EDGE OF FRAME 87 HAD SURFACE CORROSION ENTIRE SPAN. MAINTENANCE REMOVED AND REPLACED SHEAR WEB AT FR 87-88, LOCATED AND DRILLED AND INSTALLED IAW SRM 51-40-02 AND SRM 51-42-00.SDR R61A20100268Doubler · corroded*** GENERATED WHILE A/C IN HEAVY CHECK *** POTABLE WATER SERVICE SUPPORT AND SURROUNDING AREA CORRODED. MAINTENANCE REMOVED AND REPLACED CORRODED DOUBLERS SURROUNDED POTABLE WATER SUPPORT IAW EMB SRM 51-43-02.SDR R61A20100267Support · corroded*** GENERATED WHILE A/C IN HEAVY CHECK *** WASTE DRAIN SUPPORT CORRODED UNDER CABIN FLOOR. MAINTENANCE REMOVED AND REPLACED BOX ASSY AND DOUBLERS PER EMB 170 SRM 51-43-02.SDR R61A20100266Support · corroded*** GENERATED WHILE A/C IN HEAVY CHECK *** LT SEAT TRACK UPPER SUPPORT CORRODED (P/N 170-86101-001). MAINTENANCE REMOVED AND REPLACED LT SEAT TRACK UPPER SUPPORT PER EMB SRM 51-43-03.SDR R61A20100265Splice Plate · corroded*** GENERATED WHILE A/C IN HEAVY CHECK *** FR 90 CORRODED JUST ABOVE APU FUEL LINE. MAINTENANCE REMOVED AND REPLACED SPLICE PLATE AT FR 90 PER EMB SRM 51-40-00 AND 51-43-03.SDR R61A20100264Gusset · corroded*** GENERATED WHILE A/C IN HEAVY CHECK *** GUSSET CORRODED AT FR91 AND RT SEAT TRACK SUPPORT BEAM. MAINTENANCE REPLACED GUSSET IAW EMB 170 SRM 51-40-02.SDR R61A20100263Gusset · corroded*** GENERATED WHILE A/C WAS IN HEAVY CHECK *** GUSSET ON FR 90 AT AVIONICS RACK SUPPORT CORRODED. MAINTENANCE INSTALLED SERVICEABLE GUSSET PLATE PER EMB SRM 51-41-02.SDR R61A20100262Gusset · corroded***GENERATED WHILE A/C WAS IN HEAVY CHECK*** GUSSET ON FR90 AT RT SEAT TRACK SUPPORT BEAM WAS CORRODED. MAINTENANCE REMOVED AND REPLACED GUSSET PER EMB SRM 51-41-02.SDR R61A20100261Gusset · corroded***GENERATED WHILE A/C WAS IN HEAVY CHECK*** GUSSET ON FR90 AT LT SEAT TRACK SUPPORT BEAM WAS CORRODED. MAINTENANCE REMOVED AND REPLACED GUSSET P/N 170-60257-001 PER EMB SRM 51-41-01.SDR R61A20100260Gusset · corroded***GENERATED WHILE A/C WAS IN HEAVY CHECK*** GUSSET ON FR90 AT WASTE TANK FWD SUPPORT CORRODED. MAINTENANCE INSTALLED SERVICEABLE GUSSET PLATE PER EMB SRM 51-41-02. A/C CURRENTLY OUT OF SERVICE FOR HEAVY CHECK.SDR R61A20100259Support Beam · corroded***GENERATED WHILE A/C WAS IN HEAVY CHECK*** RT SEAT TRACK SUPPORT BEAM HAS CORROSION FROM FR 85 TO FR 91. MAINTENANCE REMOVED AND REPLACED RT SEAT TRACK SUPPORT AT FR 85 TO FR 91 IAW EMB SRM 51-43-03. A/C IS CURRENTLY STILL OUT OF SERVICE FOR HEAVY CHECK.SDR R61A20100256Support Beam · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT SEAT TRACK SUPPORT BEAM FROM FR 85 TO FR 91. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK BEAM PER THE EMB SRM. AC STILL OUT OF SERVICE FOR CHECK COMPLETION.SDR R61A20100258Roller · dirtyCREW REPORTED L-1 DOOR HARD TO OPEN AND CLOSE. MAINTENANCE CLEANED AND LUBED MAIN CABIN DOOR ROLLERS AND PERFORMED PASSENGER DOOR LOCK TEST PER EMB AMM. A/C WAS THEN RETURNED TO SERVICE.SDR R61A20100255Ramp · out of adjustCREW REPORTED L-1 DOOR HARD TO OPEN AND CLOSE. MAINTENANCE ADJUSTED THE DOOR CONTACT RAMPS PER EMB AMM. A/C WAS THEN RETURNED TO SERVICE.SDR R61A20100233Roller · dirtyCREW REPORTED MAIN CABIN DOOR STICKS WHEN OPENING. MAINTENANCE CLEANED AND LUBED L-1 DOOR ROLLERS & TRACKS PER EMB AMM, AND PERFORMED OPS CHECKS OF L-1 DOOR.SDR R61A20100231Battery Pack · dischargedCREW REPORTED EMERGENCY BATTERY LIGHT CB TRIP. MAINTENANCE REMOVED AND REPLACED NR 3 BATTERY PACK PER EMB AMM, AIRCRAFT WAS THEN RETURNED TO SERVICE.SDR R61A20100245Beam · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT CENTER I BEAM NEXT TO SEAT TRACK AT FR 84. MAINTENANCE REMOVED AND REPLACED THE UPPER SHEET PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100244Beam · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT CENTER I BEAM BETWEEN FR 85 AND FR 86. MAINTENANCE REMOVED AND REPLACED THE UPPER SHEET ON THE LT CENTER I BEAM PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100243Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON GUSSET AT RT SILL AND INTERCOSTAL BETWEEN FRAMES 86 AND 87. MAINTENANCE REMOVED AND REPLACED THE GUSSET PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100242Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON GUSSET AT LT SILL AND INTERCOSTAL BETWEEN FRAMES 86 AND 87. MAINTENANCE REMOVED AND REPLACED GUSSET PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100241Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT FLOOR GUSSET AT FR 90. MAINTENANCE REMOVED AND REPLACED THE GUSSET PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100240Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT CENTER FLOOR GUSSET AT FR 90. MAINTENANCE REMOVED AND REPLACED THE GUSSET PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100239Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT CENTER FLOOR GUSSET AT FR 90. MAINTENANCE REMOVED AND REPLACED THE GUSSET PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100238Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT FLOOR GUSSET AT FR 90. MAINTENANCE REMOVED AND REPLACED THE GUSSET PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100237Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON GUSSET AT RT CENTER FLOORBEAM AT FR 90. MAINTENANCE REMOVED AND REPLACED THE GUSSET PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100236Intercostal · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT INTERCOSTAL BETWEEN FR 87 AND FR 88. MAINTENANCE REMOVED AND REPLACED THE INTERCOSTAL PER EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100235Intercostal · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON CENTER INTERCOSTAL BETWEEN FR 87 AND FR 88. MAINTENANCE REMOVED AND REPLACED INTERCOSTAL PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100234Intercostal · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON LT INTERCOSTAL AT FR 87. MAINTENANCE REMOVED AND REPLACED THE INTERCOSTAL PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100232Slide · deployedL-1 DOOR SLIDE DEPLOYED. MAINTENANCE REMOVED AND REPLACED L-1 EMERGENCY EVACUATION SLIDE PER EMB AMM.SDR R61A20100230Power Unit · faultyCREW RETURNED TO FIELD AT PHL DUE TO LANDING GEAR NOT RETRACTING AFTER TAKEOFF. MAINTENANCE REMOVED AND REPLACED THE LANDING GEAR SELECTOR VALVE AND SPDA DC POWER MODULE PER EMB AMM, AIRCRAFT WAS THEN RETURNED TO SERVICE.SDR R61A20100229Control Handle · malfunctionedCREW REPORTED LANDING GEAR WOULDN'T RETRACT AFTER TAKEOFF FROM PHL, DECLARED EMERGENCY AND RETURNED TO PHL WITHOUT INCIDENT. MAINTENANCE REMOVED AND REPLACED THE LANDING GEAR HANDLE AND CYCLED THE GEAR PER EMB AMM, A/C WAS THEN RETURNED TO SERVICE.SDR R61A20100228Unknown · malfunctionedCREW REPORTED AVNX MAU 3A FAIL MSG IN FLIGHT ALONG WITH OTHER EICAS MSGS. CREW DECLARED AN EMERGENCY AND LANDED WITHOUT INCIDENT INTO MCI. ON CALL MAINTENANCE RESET NIC/PROC 5, PERFORMED RTS TEST, OPS CHECKED RIGHT TR, SPOILERS, BRAKES, A/P, AND A/T SYSTEM PSDR R61A20100227Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON GUSSET BETWEEN LT AND RT I BEAMS AT FR 90. MAINTENANCE REMOVED AND REPLACED THE GUSSET PER THE EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A20100226Gusset · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON GUSSET FOR MIDDLE I BEAM AT FR 90. MAINTENANCE REMOVED AND REPLACED THE GUSSET PER THE EMB SRM. AC STILL OUT OF SERVICE FOR COMPLETION OF HEAVY CHECK.SDR R61A20100224Sill · corroded*** GENERATED WHILE A/C WAS IN HEAVY CHECK *** MAINTENANCE REPORTED SEVERAL AREAS OF CORROSION ON RT SILL BETWEEN FR 88-90. MAINTENANCE REMOVED AND REPLACED SILL IAW EMB 170 SRM 51-43-03.
Back to Embraer ERJ 170-100SU