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 R61A201408061015Seal · crackedDURING HEAVY CHECK WAS REPORTED THAT UPPER BIFURCATION SEAL ON CORNER IS CRACKED. MAINTENANCE R & R UPPER BIFURCATION SEAL IAW SRM 51-42-02 AND ESM 78-31-05, PN 14G0650-203, SEAL.SDR R61A201408061003Web · corrodedDURING HEAVY CHECK, FOUND SEVERAL AREAS OF CORROSION ON SUPPORT WEB AFT OF FRAME 19, INBD OF STR 17. REPAIRED IAW SRM 51-41-02.SDR R61A201408061002Support · corrodedDURING HEAVY CHECK, FOUND CORROSION ON WEB SUPPORT FWD OF FR14 BY R1 DOOR. R & R RT WEB SUPPORT IAW SRM 51-41-02, SRM 51-43-04.SDR R61A201408060993Seat Track · corrodedDURING HEAVY CHECK, LT CENTER SEAT TRACK AT FRAME 19 IS CORRODED. MX INSTALLED NEW SEAT TRACK IAW SRM 51-43-01.SDR R61A201408060986Support · crackedDURING HEAVY CHECK LT RAM AIR DUCT SUPPORT FWD OF ACM IS CRACKED. MX R & R LT RAM AIR DUCT SUPPORT FWD OF ACM IAW SRM 51-40-02, 51-41-01, PN 170-9288-401 SUPPORT ASSY.SDR R61A201408051019Mount · corrodedDURING HEAVY CHECK, FWD GALLEY BOTH AFT RT, MOUNT FITTINGS ARE CORRODED. MX R & R FWD GALLEY BOTH AFT RT, MOUNT FITTINGS LT MOUNT FITTING REMOVED LIGHT CORROSION. PN 170-42866-001, FITTING.SDR R61A201408051018Rib · crackedDURING HEAVY CHECK RT HORIZONTAL STABILIZER L/E, THE NR 1 RIB IS CRACKED. MX COMPLIED WITH RT L/E RIB REPAIR IAW SRM 51-41-01,51-41-02 AND ETD 2014-170-065680 FOR WORK DETAILS SEE N/R CONTINUATION CARDS VP-027603-2014/281 C1-C2.SDR R61A201408051009Spacer · corrodedDURING HEAVY CHECK, FOUND FWD GALLEY OG AFT FLOOR SPACER IS CORRODED. MX R & R CORRODED FLOOR SPACER IAW AMM 25-31-01, PN 170-87799-001.SDR R61A201408030985Bracket · crackedDURING HEAVY CHECK, FOUND NLG STEERING MANIFOLD BRACKET IS CRACKED. MX R & R NLG STEERING MANIFOLD BRACKET IAW SRM 51-41-02, 51-43-03, PN 170-10788-401, BRACKET.SDR R61A201408030951Flashlight · inoperativeMAINTENANCE REPORTED THAT THE CAPTAIN`S FLASHLIGHT WAS NOT WORKING. MAINTENANCE R & R CAPTAIN`S FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201407310947Seal Depressor · gougedDURING HEAVY CHECK, FWD PASSENGER DOOR METAL SEAL PROFILE HAS TWO GOUGES ON LOWER AFT SIDE. MX REMOVED AND REPLACED FWD PASSENGER DOOR METAL SEAL DEPRESSOR IAW EMB 170 SRM 51-40-02, 51-41-01, 51-43-03. MAJOR REPAIRSDR R61A201407290944Battery Pack · failedCREW REPORTED THAT THE CAPTAIN`S FLASHLIGHT WOULD NOT HOLD A CHARGE. MAINTENANCE R & R THE BATTERIES IAW AMM AND OPS CHECKED GOOD.SDR UHLA2014072600525Gusset · corrodedCORROSION ON RT CENTER GUSSET PLATE FRAME 90, R & R RT GUSSET PLATE.SDR UHLA2014072800524Structure · corrodedCORROSION ON BELLY FAIRING, SPLICE PLATE ON NR 2 FWD DRAIN MAST COVER. R & R DRAIN MAST COVER DOUBLER, PN 170-96414-001.SDR R61A201407280938Light · detachedCREW REPORTED THAT THE EMERGENCY LIGHT NEAR SEAT 1D DETACHED FROM THE FLOOR. MAINTENANCE SECURED EMERGENCY LIGHT IAW AMM AND OPS CHECKED GOOD.SDR UHLA2014072600551Floor Support · corrodedCORROSION FOUND ON RT FLOOR SUPPORT FRAMES 12-20. R & R FLOOR SUPPORT.SDR UHLA2014072600550Beam · corrodedCORROSION FOUND ON LT BEAM, Y-10.748, FRAMES 86-89. R & R BEAM.SDR UHLA2014072600549Beam · corrodedCORROSION FOUND ON RT BEAM Y+10.748, FRAMES 86-89. R & R BEAM.SDR UHLA2014072600548Floor Support · corrodedCORROSION FOUND ON RT FLOOR SUPPORT FRAMES 86-90. R & R FLOOR SUPPORT.SDR UHLA2014072600547Gusset · corrodedCORROSION FOUND ON RT GUSSET PLATE FRAME 90. R & R GUSSETT.SDR UHLA2014072600546Seat Track · corrodedCORROSION FOUND ON RT SEAT TRACK Y+10.748 AT FRAME 84. R & R RT SEAT TRACK.SDR UHLA2014072600545Crossbeam · corrodedCORROSION FOUND ON FRAME 84 CROSSBEAM. R & R CROSSBEAM.SDR UHLA2014072600544Floor Support · corrodedCORROSION FOUND ON RT FLOOR SUPPORT FR 84. R & R RT FLOOR SUPPORT.SDR UHLA2014072600531Floor Support · corrodedCORROSION FOUND ON RIGHT FWD FLOOR SUPPORT. R & R THE FLOOR SUPPORT.SDR UHLA2014072600530Seat Track · corrodedCORROSION FOUND ON LT SEAT TRACK FRAMES 12-20. R & R LT SEAT TRACK.SDR UHLA2014072600529Upper Sheet · corrodedCORROSION FOUND ON RT Y=+10.748 UPPER SHEET, FRAMES 85-86. R & R UPPER SHEET.SDR UHLA2014072600528Upper Sheet · corrodedCORROSION FOUND ON RT Y=-10.748, UPPER SHEET FRAMES 85-86. R & R UPPER SHEETSDR UHLA2014072600527Shear Plate · corrodedCORROSION FOUND ON CENTER SHEAR PLATE FRAMES 87-88. R & R CENTER SHEAR PLATE.SDR UHLA2014072600526Shear Plate · corrodedCORROSION FOUND ON SHEAR PLATE FRAMES 87-88. R & R LT SHEAR PLATE.SDR R61A201407250946Bolt · corrodedDURING HEAVY CHECK, LT MLG LOWER SIDE STAY ATTACH BOLT AND THROUGH BOLT ARE PITTED. MX R & R LT MLG LOWER SIDE STAY ATTACH BOLT AND THROUGH BOLT IAW AMM 32-11-05, PN 2801-0017, BOLT.SDR R61A201407250916Structure · damagedRT HORIZONTAL STAB LOWER SKIN T/E DOUBLER, ACCESS PANEL DOUBLER AND HINGE FITTING NR 2 ARE DAMAGED. MX R & R SKIN T/E DOUBLER AND SPLICE JOINT IAW SRM 51-41-01, 51-41-02,51-43-01 NO DAMAGE TO SURROUNDING STRUCTURE FOUND. MAJOR REPAIR.SDR R61A201407230928Mount Fitting · corrodedDURING HEAVY CHECK, FOUND BOTH AFT FLOOR FITTINGS ON FWD GALLEY ARE CORRODED. MAINTENANCE R & R BOTH AFT FLOOR FITTINGS ON FWD GALLEY IAW AMM 25-31-01. PN 170-42864-001, FLOOR FITTING.SDR R61A201407230914Structure · corrodedDURING HEAVY CHECK, LT HORIZONTAL STABILIZER HINGE BEARING BORE IS CORRODED. MX REPAIRED IAW ETD 2014-170-059928, REV TI-170-14-043, REV B.SDR R61A201407230912Bushing · corrodedDURING HEAVY CHECK, SPHERICAL BEARING HOUSING ON RT SIDE OF HORZONTAL STABILIZER IS CORRODED. MX REPAIRED IAW ETD 2014-170-059928, REV C AND TI -170-14-043, REV B.SDR R61A201407210898Flashlight · inoperativeMAINTENANCE REPORTED THAT THE LEFT AFT F/A FLASHLIGHT WAS INOPERATIVE. MAINTENANCE R & R LT AFT F/A FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201407190909Spigot · corrodedDURING HEAVY CHECK, AFT GALLEY WATER SPIGOT NOZZLE IS CORRODED. MX R & R AFT GALLEY WATER SPIGOT NOZZLE IAW AMM 25-34-01, PN 90043-407 SPIGOT.SDR R61A201407190886Line · corrodedDURING HEAVY CHECK, UNDER LT WING FUEL PANEL 521BB FUEL VENT TUBE SHOW SIGNS OF DEGRADATION AT CONNECTION POINTS. MAINTENANCE R & R LT WING FUEL PANEL 521BB FUEL VENT TUBE IAW AMM 28-10-13.SDR R61A201407190885Line · corrodedDURING HEAVY CHECK, UNDER LT WING PANEL 521AB FUEL VENT TUBE AT CONNECTION POINTS SHOW SIGNS OF DEGRADATION. MX R & R LT WING PANEL 521AB FUEL VENT TUBE IAW AMM 20-10-13,SDR R61A201407190884Line · corrodedDURING HEAVY CHECK, UNDER LT WING FUEL PANEL 521DB FUEL VENT TUBE AT CONNECTION POINTS SHOW SIGNS OF DEGRADATION. MAINTENANCE R & R LT WING FUEL PANEL 521DB FUEL VENT TUBE IAW AMM 20-10-13. PN 170-06023-401, TUBE ASSY.SDR R61A201407190882Light · missingCREW REPORTED THAT A PIECE OF EMERGENCY LIGHT IN FRONT OF SEAT 1D WAS MISSING. MAINTENANCE INSTALLED EMERGENCY LIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201407170927Bolt · corrodedDURING HEAVY CHECK, FOUND LT FLAP POSITION SENSOR MOUNT BOLTS ARE CORRODED. MAINTENANCE R & R LT FLAP POSITION SENSOR MOUNT BOLTS IAW AMM 27-53-04.SDR R61A201407170890Seal Rest · corrodedDURING HEAVY CHECK FWD CARGO DOOR LOWER BEAM, NUTPLATE STRAPS ARE CORRODED IN 5 PLACES. MAINTENANCE R & R FWD CARGO DOOR LOWER BEAM, NUTPLATE STRAPS IAW SRM 51-40-0251-40-01,51-41-02 MATCHED DRILLED INSTALLED SEAL REST IAW SRM 51-40-02, 51-41-01,51-41-02. MASDR R61A201407170883Retainer · crackedDURING HEAVY CHECK, FWD CARGO DOOR SEAL RETAINER AT LOWER AFT CORNER HAS 1" CRACK. MX R & R FWD CARGO DOOR SEAL RETAINER AT LOWER AFT CORNER IAW SRM 51-40-02,51-41-02 FILLET SEALED IAW SRM 51-21-02 RESTORED TOP COAT AND REPLACEMENT FASTENERS IAW SRM 51-23-06SDR R61A201407160949Seat Track · corrodedDURING HEAVY CHECK, RT SEAT TRACK EXTENSION BETWEEN FRAMES 90-90A INBD AND OTBD FLANGES ARE CORRODED. MX R & R SEAT TRACK IAW ETD 2014-170-060144 .SDR R61A201407160948Bolt · corrodedDURING HEAVY CHECK, APU ISOLATOR LEFT SIDE BOLT IS CORRODED. MX R & R THE BOLT IAW CMM 49-12-15.SDR R61A201407160929Bolt · corrodedDURING HEAVY CHECK, FOUND APU ISOLATOR RT SIDE BOLT CORRODED. MX R & R BOLT IAW CMM 49-12-15.SDR R61A201407160905Bracket · crackedDURING HEAVY CHECK, LT RAM AIR DUCT SUPPORT BRACKET IS CRACKED. MX R & R LT RAM AIR DUCT SUPPORT BRACKET IAW SRM 51-40-02, 51-41-01, & 51-23-05.SDR R61A201407160904Seat Track · corrodedDURING HEAVY CHECK, LT SEAT TRACK BEAM EXTENSION DOUBLER AT FRAME 89 IS CORRODED. MAINTENANCE R & R LT SEAT TRACK BEAM EXTENSION DOUBLER IAW SRM 51-43-01.SDR R61A201407160903Seat Track · corrodedDURING HEAVY CHECK, RT SEAT TRACK EXTENSION DOUBLER AT FRAME 90 IS CORRODED. MAINTENANCE R & R RT SEAT TRACK EXTENSION DOUBLER IAW SRM 51-41-02.SDR R61A201407160893Doubler · corrodedDURING HEAVY CHECK, SHEAR PLATE DOUBLER BETWEEN FRAMES 87-88 RT SIDE IS CORRODED. MAINTENANCE R & R SHEAR PLATE DOUBLER BETWEEN FRAMES 87-88, RT SIDE IAW SRM 51-42-02, PN 170-65664-001, SPLICE.
Back to Embraer ERJ 170-100SU