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 R61A201405030660Nut · corrodedDURING HEAVY CHECK, FORWARD SERVICE DOOR AFT GUIDE RAMP ADJUSTMENT HARD WARE IS CORRODED. MX R & R FORWARD SERVICE DOOR AFT GUIDE RAMP ADJUSTMENT HARDWARE IAW AMM 53-10-25.SDR R61A201405030659Nut · corrodedDURING HEAVY CHECK, FORWARD SERVICE DOOR, FORWARD GUIDE RAMP ADJUSTMENT HARDWARE IS CORRODED. MX R & R FORWARD SERVICE DOOR, FORWARD GUIDE RAMP ADJUSTMENT HARDWARE IAW AMM 53-10-25.SDR R61A201405030658Bolt · corrodedDURING HEAVY CHECK, FORWARD SERVICE DOOR EVACUATION SLIDE MOUNTING HARDWARE IS CORRODED. MX R & R FORWARD SERVICE DOOR EVACUATION SLIDE MOUNTING HARDWARE IAW AMM 52-41-40, PN NAS6604D12, BOLTS.SDR R61A201405020673Support Bracket · crackedDURING HEAVY CHECK, LEFT PACK DUCT SUPPORT BRACKET FWD OF LT PACK ASSY BRACKET IS CRACKED. MAINTENANCE R & R LT PACK DUCT SUPPORT BRACKET FWD OF LT PACK ASSY BRACKET IAW SRM 51-40-02,51-41-01.SDR R61A201405020632Shear Tie · corrodedSHEAR CLIPS ALONG FRAME 16 AT STRINGERS 27-28R CORRODED. MX REMOVED AND FABRICATED NEW. INSTALLED SHEAR TIE IAW SRM 170/175 51-41-01, 51-41-02, 51-23-04, 51-23-03, 51-23-06.SDR UHLA2014043000344Stiffener · corrodedFRAME 86 BETWEEN STRINGERS 27 AND 28R CORRODED, STIFFENERS FOR WATER TANK DRAIN. FABRICATED AND R & R STIFFENERS.SDR R61A201404300619Skin · dentedDENT ON ACFT SKIN FRAMES 25-26 BETWEEN STRINGERS 24-25L. MX CUTOUT DAMAGE AND REPAIRED IAW ETD 2014-170-036380.SDR R61A201404300618Skin · dentedDENT ON ACFT SKIN BETWEEN FRAMES 25-26 JUST BELOW STRINGER 25L. MX CUTOUT DAMAGE AND REPAIRED IAW ETD 2014-170-036380.SDR UHLA2014041700379Spar · unknownSPAR LOWER FLANGE REINFORCEMENTS. COMPLIED WITH EO 170EO-57-10-0003. MAJOR REPAIRSDR UHLA2014042900378Crossbeam · corrodedCORROSION FOUND ON A SMALL AREA ON CROSSBEAM, FRAME 84 BETWEEN CENTER SEAT TRACK. REMOVED CORROSION, INSTALLED RIVET.SDR UHLA2014042900377Threshold · corrodedCORROSION FOUND ON R2 DOOR THRESHOLD AROUND GIRT BAR FITTING. REMOVED CORROSION AND FOUND WITHIN LIMITS.SDR UHLA2014042900376Threshold · corrodedCORROSION FOUND ON L2 DOOR THRESHOLD AROUND GIRT BAR FITTING. REMOVED CORROSION FOUND WITHIN LIMITS.SDR UHLA2014042900375Doubler · corrodedCORROSION FOUND ON DOUBLER FOR WATER TANK FRAMES 87-88, S27-28R. R & R DOUBLER.SDR UHLA2014042900374Splice · corrodedCORROSION FOUND ON CENTER SPLICE FRAME 90. R & R SPLICE.SDR UHLA2014042900373Floor Support · corrodedCORROSION FOUND ON RT FWD FLOOR SUPPORT FRAMES 12-14. R & R RT FWD FLOOR SUPPORT.SDR UHLA2014042900372Upper Sheet · corrodedCORROSION ON UPPER SHEET BETWEEN FRAMES 85-86. R & R UPPER SHEET .SDR UHLA2014042900371Shear Plate · corrodedCORROSION FOUND ON RT SHEAR PLATE FRAMES 87-88. R & R SHEAR PLATE.SDR UHLA2014042900370Shear Plate · corrodedCORROSION FOUND ON CENTER SHEAR PLATE FRAMES 87-88. R & R SHEAR PLATE.SDR UHLA2014042900369Support · corrodedCORROSION FOUND ON RT PANEL SUPPORT FRAMES 86-90. R & R SUPPORT.SDR UHLA2014042900368Gusset · corrodedCORROSION FOUND ON RT GUSSET PLATE FRAME 90. R & R GUSSET.SDR UHLA2014042900367Support · corrodedCORROSION FOUND ON LEFT PANEL SUPPORT FRAMES 88-90. R & R SUPPORT.SDR UHLA2014042900366Intercostal · corrodedCORROSION FOUND ON INTERCOSTAL BETWEEN FRAMES 90-91, Y=+10.748. R & R INTERCOSTAL.SDR UHLA2014042900365Gusset · corrodedCORROSION FOUND ON GUSSET RT FRAME 91. R & R GUSSET.SDR UHLA2014042900364Shear Tie · corrodedCORROSION FOUND ON SHEAR TIE AT FRAME 89 BETWEEN S26-27R. R & R SHEAR TIE.SDR UHLA2014042900345Floor Support · corrodedRT FLOOR SUPPORT FRAME 84. R & R RT FLOOR SUPPORT.SDR R61A201404240584Light · looseCREW REPORTED THAT THE PHOTOLUMINESCENT STRIP AT ROW 13 WAS DAMAGED. MAINTENANCE FOUND THE PHOTOLUMINESCENT STRIP LOOSE, READJUSTED IAW AMM AND OPS CHECKED GOOD.SDR UHLA2014042200343Shear Tie · corrodedCORROSION FOUND ON FRAME 86 SHEAR TIE BETWEEN STRINGERS 28-87R. R & R SHEAR TIE. MAJOR REPAIR.SDR R61A201404220580Shutoff Valve · defectiveAFTER SELECTING GEAR DOWN, CREW RECEIVED A RT BRAKE FAIL AND LT BRAKE FAIL MESSAGES. RAN QRH AND AS A PRECAUTION DECLARED AN EMERGENCY. LANDED AND TAXIED TO GATE WITHOUT INCIDENT. MAINTENANCE INSPECTED AND FOUND BRAKE SHUTOFF VALVE HAD FAILED. MAINTENANCE R SDR UHLA2014042100342Shear Tie · corrodedCORROSION FOUND ON SHEAR TIE AT FRAME 88, S28-29R. R & R SHEAR TIE.SDR UHLA2014042100341Stiffener · corrodedCORROSION FOUND ON LAVATORY PAN UPPER STIFFENER. R & R STIFFENER.SDR UHLA2014042100340Closeout Panel · corrodedCORROSION FOUND ON FWD CARGO CLOSEOUT PANEL IN MULTIPLE AREAS. R & R CLOSEOUT PANEL.SDR R61A201404200555Door · out of rigCREW REPORTED THAT THE DEICE CREW ALERTED THEM THAT THE L2 DOOR HANDLE WAS NOT FLUSH WITH THE SKIN OF THE ACFT. CREW RETURNED TO GATE WHERE MAINTENANCE INSPECTED AND FOUND DOOR OUT OF RIG. ACFT WAS FLOWN VIA MAINTENANCE FERRY, WHERE DOOR WAS RIGGED IAW AMM ASDR R61A201404180553Light · looseCREW REPORTED THAT THE EMEGENCY LIGHT AT ROW 10 WAS LOOSE. MAINTENANCE SECURED THE LIGHT STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201404140546Seal · malfunctionedCREW REPORTED THAT THE L2 DOOR WAS VIBRATING AND SHAKING. AN EMERGENCY WAS NOT DECLARED AND LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED AND DEACTIVATED THE L2 DOOR SEAL AND PLACED ON CDL IAW AMM. ACFT IS GOOD FOR SERVICE.SDR UHLA2014041300328Skin · damagedBIRDSTRIKE DAMAGE TO LT FWD FUSELAGE SKIN AT FRAMES 1-4, BETWEEN STGR 22L-25L. INSTALLED SERVICEABLE FWD FUSELAGE SKIN FCBS 53-10-00-004.SDR UHLA2014041300322Shear Tie · corrodedCORROSION FOUND ON SHEAR TIE AT FRAME 3 BETWEEN S24 - 25L. R & R DAMAGED SHEAR TIE.SDR R61A2014041200627Skin · damagedDURING HEAVY CHECK, BIRD STRIKE DAMAGE TO FWD FUSELAGE SKIN PANEL AND UNDERLYING STRUCTURE. MX REPAIRED BIRD STRIKE DAMAGE TO FWD FUSELAGE SKIN PANEL AND UNDERLYING STRUCTURE REF ATTACHED IRM 12, SRM 51-41-01, 51-41-02, 51-43-04, 51-43-03.SDR R61A201404090513Shear Tie · damagedDURING HEAVY CHECK, DAMAGE ON SHEAR CLIP FRAME 88 BETWEEN STRINGERS 26-27R. MX R & R SHEAR CLIP IAW SRM 51-40-02, 51-41-01.SDR R61A201404090503Shear Tie · damagedDURING HEAVY CHECK, DAMAGE FOUND ON SHEAR TIE FRAME 88 BETWEEN STRINGERS 26-27R. MX R & R SHEAR TIE IAW SRM 51-40-02, 51-41-01. MAJOR REPAIRSDR R61A201404070523Angle · corrodedDURING HEAVY CHECK, FLOORBEAM AT FRAME 17 RT SIDE CORRODED. MX R & R FLOORBEAM FRAME 17 IAW SRM 51-41-01.SDR R61A201404070520Shear Web · corrodedDURING HEAVY CHECK, CORROSION WAS FOUND ON THE SHEAR WEB AT FRAME 19, LT SIDE. MAINTENANCE R & R THE SHEAR WEB IAW SRM 51-43-02 & 51-41-02.SDR R61A201404060508Bolt · corrodedDURING HEAVY CHECK, FWD CARGO LT & RT CENTER DOOR FITTING HARDWARE CORRODED. MAINTENANCE R & R FWD CARGO LT, RT CENTER DOOR FITTINGS HARDWARE IAW AMM 53-21-29, PN PE21094-06016A, BOLT.SDR R61A201404050519Rivet · corrodedDURING HEAVY CHECK, CORROSION WAS FOUND ON RIVETS OF THE WASTE BOX DOUBLER FORWARD SIDE. MAINTENANCE R & R RIVETS IAW ETD 2014-170-028885 AND SRM 51-41-02.SDR R61A201404010510Rib · crackedDURING HEAVY CHECK, RT HORIZONTAL STAB AFT OF FWD SPAR, RIB 11 FWD LOWER FLANGE IS CRACKED. MX TRIMMED DAMAGE OUT ON RT HORIZONTAL STAB AFT OF FWD SPAR RIB FWD LOWER FLANGE FABRICATED REPAIR ANGLES IAW ETD 2014-170-028468. MAJOR REPAIRSDR R61A201404030518Shear Tie · crackedDURING HEAVY CHECK, MAINTENANCE REPORTED A CRACK ON THE VERTICAL STAB T/E SHEAR TIE LOCATED BETWEEN RIBS 9 & 10 ON THE RT SIDE AT FORWAD FLANGE AFT END AND AFT FLANGE FORWORD END. MAINTENANCE PERFORMED REPAIR WITH FABRICATED REPAIR SHEAR TIE IAW ETD 2014-170-SDR R61A201404030507Seal Depressor · damagedDURING HEAVY CHECK, L1 DOOR FWD CUT OUT SEAL DEPRESSOR AREA OF THICKNESS REDUCTION DAMAGE. MAINTENANCE R & R L1 DOOR FWD CUT OUT SEAL DEPRESSOR SRM 51-40-02, 51-41-01, 51-43-03. MAJOR REPAIR.SDR R61A201404030497Seal Depressor · damagedDURING HEAVY CHECK, L1 DOOR CUTOUT FWD SEAL DEPRESSOR ONE AREA OF THICKNESS REDUCTION DAMAGE. MX MEASURED DAMAGE AND DETERMINED THAT IT IS UNSERVICABLE IAW SRM 53-10-21. R & R L1 DOOR CUT OUT FWD SEAL DEPRESSOR IAW SRM 51-40-02, 51-41-01, 51-43-03 ALSO REMOVSDR R61A201404030494Door Sill · corrodedDURING HEAVY CHECK, FWD CARGO LOWER DOOR SILL HAS 5 NUTPLATES STAND OFF BRACKETS CORRODED WITH 1 CRACKED, 1 DENTED. MAINTENANCE R & R FWD CARGO LOWER SILL HAS 5 NUTPLATES STAND OFF BRACKETS CORRODED WITH 1 CRACKED, 1 DENTED IAW EMB 170 51-40-02, PN 170-67176-SDR R61A201404020522Firewall · crackedRT APU FIRWALL IS CRACKED. MX REMOVED CRACKED AREAS AT THE UPPER AND LOWER INBD RADIUS IAW ETD 2014-170-030302.SDR R61A201404020516Door · corrodedDURING HEAVY CHECK, LAVATORY WASTE DUMP DOOR BY HINGE IS CORRODED. MX R & R LAV WASTE DUMP DOOR IAW AMM 21-10-01, SRM 51-40-00, PN 170-86668-403 SERVICE PANEL.
Back to Embraer ERJ 170-100SU