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 R61A2019102271114Fitting · crackedWHILE AC WAS IN FOR HVY CK FOUND CRACK ON RH WING INBD AFT FLAP FITTING. AAR MX REPLACED RH WING INBD AFT FLAP FITTING PN 170-39187-002 IAW AMM 20-10-01-910-801-A. FOR DETAILS OF WORK PERFORMED SEE AAR NRC 4500474-6000-0008.SDR R61A201910171107Shear Tie · corrodedDURING HEAVY CHECK, CORROSION WAS FOUND AT AFT CARGO COMPARTMENT SHEAR CLIP AT FR 82 BETWEEN STR 27 AND 28 RH. SHEAR CLIP WAS REPLACED IAW SRM 51-41-01 AND 51-41-02.SDR R61A201909080978Crossbeam · corroded*** WHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK *** LEVEL 2 CORROSION WAS FOUND ON CENTER FUSELAGE 3 CROSSBEAM UPPER FLANGE AT FR 87 AND RBL 12. CROSSBEAM WAS REPAIRED IAW ETD2019-170-124120. AIRCRAFT REMAINS OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A201909060986Seal Rest · cracked*** WHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK *** A CRACK WAS FOUND ON L1 DOOR SURROUND UPPER SEAL SEAT CORNER FR 16. SEAL SEAT WAS REPAIRED IAW ETD 2019-170-125326. AIRCRAFT RETURNED TO SERVICE.SDR R61A201909050977Angle · corroded*** WHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK *** LEVEL 2 CORROSION WAS FOUND ON CENTER FUSELAGE 3 UNDER FLOOR FRAME STABILIZER CLIP AT STR18L FR 84. CLIP WAS REPLACED IAW SRM 51-41-01 AND ETD 2019-170-123637. AIRCRAFT REMAINS OUT OF SERVICE FOR HEAVY SDR R61A201909040987Fitting · corroded*** WHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK *** LEVEL 2 CORROSION WAS FOUND ON L1 DOOR LOWER SILL BEAM @ FWD AND AFT GIRT BAR FITTING AREA. SILL BEAM WAS BLENDED AND FOUND WITHIN LIMITS PER SRM 53-10-11, GIRT BAR FITTINGS AREA REPAIRED IAW ETD 2019-1SDR R61A201909040983Shear Panel · corroded*** WHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK *** LEVEL 2 CORROSION WAS FOUND ON CENTER FUSELAGE SUPPORT SHEAR PANEL AT FR 88 AND BL 0. SHEAR PANEL WAS REPLACED IAW SRM 51-42-01. AIRCRAFT RETURNED TO SERVICE.SDR R61A201909040974Splice · corrodedWHILE AC WAS IN FOR HVY CK CORROSION FOUND ON CENTER FUSELAGE 3 FLOOR SUPPORT SPLICE AT L2 DOOR SURROUND FR 88. MX REPLACED CENTER FUSELAGE 3 FLOOR SUPPORT SPLICE PN 170-86107-001 AT L2 DOOR SURROUND FR 88 IAW SRM 51-43-03. AC REMAINS IN YQG FOR COMPLETION. SESDR R61A201909040976Angle · corroded*** WHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK *** LEVEL 2 CORROSION WAS FOUND ON CENTER FUSELAGE 3 UNDER FLOOR FRAME STABILIZER ANGLE AT SR 19R FR 85. ANGLE WAS REPLACED IAW SRM 51-43-03 AND ETD 2019-170-126371. AIRCRAFT REMAINS OUT OF SERVICE FOR HEASDR R61A201909040973Floor Support · corrodedWHILE AC WAS IN FOR HVY CK CORROSION FOUND ON CENTER FUSELAGE 3 LONGITUDINAL FLOORBEAM AT FR 88 RBL 9. MX REPLACED PN 170-65669-004 CENTER FUSELAGE 3 LONGITUDINAL FLOORBEAM CLIP IAW SRM 51-43-01. AC REMAINS IN YQG FOR COMPLETION. SEE NRC # 4500442-1000-0045 FOSDR R61A201909040975Gusset · corroded*** WHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK *** LEVEL 2 CORROSION WAS FOUND ON CENTER FUSELAGE 3 FLOOR SUPPORT GUSSET PLATE AT FR 89 AND LBL 9. PLATE WAS REPLACED IAW SRM 51-42-02. AIRCRAFT REMAINS OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A201909040972Panel Support · corrodedWHILE AC WAS IN FOR HVY CK FOUND CORROSION ON CENTER FUSELAGE 3 FLOOR STRUCTURE PANEL SUPPORT. MX REMOVED AND REPLACED PN 170-86181-005 CENTER FUSELAGE 3 FLOOR STRUCTURE PANEL SUPPORT IAW SRM 51-42-01. AC REMAINS IN YQG FOR COMPLETION. SEE NRC# 4500442-1000-00SDR R61A201909040971Shear Panel · corrodedWHILE AC WAS IN FOR HVY CK FOUND CORROSION ON CENTER FUSELAGE 3 FLOOR SUPPORT SHEAR PANEL AT FR 88 AND LBL 9. MX REMOVED AND REPLACED PN 170-91919-001CENTER FUSELAGE 3 FLOOR SUPPORT SHEAR PANEL AT FR 88 AND LBL 9 IAW SRM 51-42-01. AC REMAINS IN YQG FOR COMPLETSDR R61A201909040970Shear Panel · corrodedWHILE AC WAS IN FOR HVY CK FOUND CORROSION ON CENTER FUSELAGE 3 FLOOR SUPPORT SHEAR PANEL AT FR 88 AND LBL 9. MX REMOVED AND REPLACED CENTER FUSELAGE 3 FLOOR SUPPORT SHEAR PANEL PN 170-65927-007 AT FR 88 AND LBL 9 IAW SRM 51-42-01 AND ETD 2019-170-123840. AC RSDR R61A201909030985Skin · nickedWHILE AC WAS IN FOR HVY MX FOUND NICKS ON FUSELAGE EXT SKIN UNDER L2 DOOR SCUFF PLATE. MX REPAIRED SKIN PN 170-65121-005 IAW ETD2019-170-123338. FOR WORK PERFORMED SEE NRC # 4500442-2000-0031. AC RETURNED TO SERVICE.SDR R61A201909030984Fitting · crackedWHILE AC WAS IN FOR HVY CKS FOUND CRACK ON LT IB AFT FLAP FITTING. MX REMOVED AND REPLACED LT IB AFT FLAP FITTING PN 170-39187-001 IAW AMM 57-52-00-000-801-A. FOR DETAILS OF WORK PERFORMED SEE NRC# 4500442-5000-0003. AC WAS RETURNED TO SERVICE.SDR R61A201909030982Skin Panel · scratchedWHILE AC WAS IN FOR HVY CHECK FOUND FWD AVIONICS ACCESS HATCH EXTERNAL SKIN HAS MINOR SCRATCH DAMAGE. MX REPAIRED FWD AVIONICS ACCESS HATCH EXTERNAL SKIN PN 170-00665-407 IAW ETD 2019-170-123339. SEE NRC# 4500442-2000-0030 FOR WORK PERFORMED. AC RETURNED TO SESDR R61A2019083070881Power Supply · no testLH FWD EMERGENCY LIGHTS POWER UNIT FAILED FUNCTION CHECK. R&R LH FWD EMERGENCY LIGHTS POWER UNIT IAW AMM 35-50-01/400.SDR R61A201907170717Angle · crackedFWD FUSELAGE UNDER FLOOR STRUCTURE AS CROSS BEAM (FRAME 12) BL 0, ANGLE WAS CRACKED. REMOVED AND REPLACED ANGLE IAW SRM 51-41-01 (PSE 53-10-026)SDR R61A201907160720Support Bracket · cracked***WHILE A/C WAS OUT OF SERVICE FOR HEAVY CHECK*** AT COCKPIT FLOOR STRUCTURE CONNECTOR SUPPORT BRACKET BTWN FR 11-12 AT BL 0 CRACKED. AT COCKPIT FLOOR STRUCTURE CONNECTOR SUPPORT BRACKET BTWN FR 11-12 AT BL 0, CONNECTOR SUPPORT REPLACED IAW SRM 51-41-01.PSE 5SDR R61A201907130708Cable · detachedL2 DOOR SLIDE APPEARS TO BE ATTACHED AFTER BEING DISARMED. REATTACHED FWD LATCH ASSY CABLE ASSY ON L2 DOOR TO SLIDER RETENTION BUTTON IAW AMM 25-23-05. OPERATED DOOR IAW AMM 52-12-00. OPS CHECK GOOD.SDR R61A2019070120748Stringer Splice · cracked***AIRCRAFT IN HEAVY CHECK*** CRACK ON STR. 9L AT FR 74 AT ATTACHMENT TO WINDOW FRAME. STRINGER SPLICE REPLACED IAW SRM 51-43-04. ***AIRCRAFT REMAINS IN HEAVY CHECK***SDR R61A201907120747Stringer Splice · cracked***AIRCRAFT IN HEAVY CHECK*** CRACK ON STR. 10L AT FR 74 AT ATTACHMENT TO WINDOW FRAME. STRINGER SPLICE REPLACED IAW SRM 51-43-04. ***AIRCRAFT REMAINS IN HEAVY CHECK***SDR R61A201907120731Stringer Splice · cracked***AIRCRAFT IN HEAVY CHECK*** CRACK LOCATED AT FRAME 59 ON STRINGER 9L AT ATTACHMENT TO WINDOW FRAME. SPLICE REPLACED IAW SRM 51-43-04. ***AIRCRAFT REMAINS IN HEAVY CHECK***SDR R61A201907120730Stringer Splice · cracked***AIRCRAFT IN HEAVY CHECK*** CRACK LOCATED AT FRAME 59 ON STRINGER 10L AT ATTACHMENT TO WINDOW FRAME. SPLICE REPLACED IAW SRM 51-43-04. ***AIRCRAFT REMAINS IN HEAVY CHECK***SDR R61A201907120716Stringer Splice · cracked*** WHILE AIRCRAFT WAS IN FOR HEAVY CHECK *** MAINTENANCE REPORTED A CRACK AT FR59 ON STR 9R AT ATTACHMENT TO WINDOW FRAME. MAINTENANCE REMOVED AND REPLACED THE SPLICE AT FR59 ON STR 9R AT ATTACHMENT TO WINDOW FRAME IAW SRM 51-43-01 AND 51-43-04. AIRCRAFT IS CSDR R61A201907110719Switch · seized***WHILE A/C WAS OUT OF SERVICE FOR HEAVY CHECK*** LDG EMERGENCY EXTENSION SWITCH IN FLOOR PANEL 22CRF, SEIZED. LDG EMERGENCY EXTENSION SWITCH IN FLOOR PANEL 222CRF, REPLACED IAW AMM 32-35-01-400-801-A. A/C REMAINS OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A201907100714Shear Tie · corrodedAFTER CARGO COMPARTMENT, CORROSION FOUND ON SHEAR CLIP, REMOVED AND REPLACED SHEAR CLIP PER SRM 51-41-01.SDR R61A201907100711Structure · corroded***WHILE A/C WAS OUT OF SERVICE FOR HEAVY CHECK*** CENTER FUSELAGE III UNDER CABIN FLOOR, CORROSION FOUND ON WASTE BOX BTW FR 88-89 AND BTW STR 26R-28R. CENTER FUSELAGE III UNDER CABIN FLOOR BTW FR 88-89 AND BTW STR 26R-28R, WASTE BOX REPLACED IAW SRM 51-43-04SDR R61A201907100713A/C Pack · corroded*** WHILE AIRCRAFT WAS IN FOR HEAVY CHECK *** MAINTENANCE REPORTED LEVEL 2 CORROSION ON THE SHEAR CLIP AT FR74 AND BETWEEN STR 28R-29R. MAINTENANCE REMOVED AND REPLACED THE SHEAR CLIP AT FR74 AND BETWEEN STR 28R-29R IAW SRM 51-41-01. AIRCRAFT IS CURRENTLY STILSDR R61A201907100712Shear Tie · corroded*** WHILE AIRCRAFT WAS IN FOR HEAVY CHECK *** MAINTENANCE REPORTED LEVEL 2 CORROSION ON THE SHEAR CLIP AT FR84 AND BETWEEN STR 27R-28R. MAINTENANCE REMOVED AND REPLACED THE SHEAR CLIP AT FR84 AND BETWEEN STR 27R-28R IAW SRM 51-41-01 AND 51-41-02. AIRCRAFT IS CSDR R61A201907090710Cable · worn***WHILE A/C WAS OUT OF SERVICE FOR HEAVY CHECK*** MLG EMERGENCY EXTENTION CLOSED LOOP CABLES (MAIN & RETURN) WORN. MLG EMERGENCY EXTENTION CLOSED LOOP CABLES FWD MAIN & RETURN CABLES REPLACED IAW 32-34-09-4000-801-A (PN:170-71349-401 & 170-71348-401). ADJUSTMSDR R61A201907070749Door Sill · corroded***AIRCRAFT IN HEAVY CHECK***CORROSION FOUND ON FWD CARGO DOOR CUTOUT LOWER SILL BEAM AT FR 25 AND STR 26R. PERMANENTLY REPAIRED IAW ETD2019-170-097949. ***AIRCRAFT REMAINS IN HEAVY CHECK***SDR R61A201907050729Skin Panel · cracked***AIRCRAFT IN HEAVY CHECK*** LT SLAT TRACK NR 5 SKIN CUTOUT CRACKED. REPAIRED IAW ETD 2019-170-097755. ***AIRCRAFT REMAINS IN HEAVY CHECK***SDR R61A201907030678Sign · crackedEXIT SIGN ABOVE R2 DOOR CRACKED. R&R EXIT SIGN ABOVE R2 DOOR IAW AMM 33-50-17.SDR R61A20190629665Shear Tie · corrodedMAINTENANCE REPORTED LEVEL 2 CORROSION ON THE SHEAR CLIP AT FR 88, BETWEEN STRG 25R & 28R. MAINTENANCE REMOVED AND REPLACED THE SHEAR CLIP AT FR 88, BETWEEN STRG 25R & 28R IAW SRM 51-41-01 & 51-41-02.SDR R61A201906287655Shear Tie · corrodedMAINTENANCE REPORTED LEVEL 2 CORROSION ON THE SHEAR CLIP AT FR87 BETWEEN STRG 27R-28R. MAINTENANCE REMOVED AND REPLACED THE SHEAR CLIP AT FR87 BETWEEN STRG 27R-28R IAW EMB SRM 51-41-01 & 51-41-02. AIRCRAFT IS CURRENTLY STILL OUT OF SERVICE FOR HEAVY CHECK COMPSDR R61A2019062640649Support Bracket · corrodedWHILE AC WAS IN FOR HEAVY CHECK FOUND FWD CARGO DOOR LOWER SILLL BEAM FWD SUPPORT BRACKET CORRODED. MX REMOVED AND REPLACED FWD SUPPORT BRACKET IAW SRM 51-41-01.SDR R61A2019062930666Frame Splice · crackedMAINTENANCE REPORTED A CRACK ON THE SPLICE AT FRAME 59 AND STRINGER 9R. MAINTENANCE REMOVED AND REPLACED THE SPLICE AT FRAME 59 AND STRINGER 9R IAW EMB SRM 51-43-03 AND 51-43-04.SDR R61A2019062830613Frame Splice · crackedJUNCTION OF CENTER FUSELAGE 2 AND 3 PASSENGER CABIN CRACKED AT SPLICE STRINGER 9L AND 10L FR59. STRINGER REPLACED IAW ETD 2019-170-083637.SDR R61A201906280013Hinge · damagedCOCKPIT DOOR HINGE IN POOR CONDITION (COCKPIT DOOR DOES NOT OPEN IN EMERGENCY CONFIGURATION). COCKPIT DOOR HINGE REPLACED IAW AMM 52-51-01.SDR R61A2019062830657Floor Support · crackedMAINTENANCE REPORTED A CRACK ON THE FLOOR PANEL SUPPORT AT FR86 & RBL 24" AREA. MAINTENANCE REMOVED AND REPLACED THE FLOOR PANEL SUPPORT AT FR86 & RBL 24" AREA IAW EMB SRM 51-41-01. AIRCRAFT IS CURRENTLY STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A201906283656Floor Support · corrodedMAINTENANCE REPORTED LEVEL 2 CORROSION ON THE SUPPORT PANEL AT FR86 & LBL 24" AREA. MAINTENANCE REMOVED AND REPLACED THE SUPPORT PANEL AT FR86 & LBL 24" AREA IAW EMB SRM 51-41-01.SDR R61A201906280658Stringer · crackedJUNCTION OF CENTER FUSELAGE 2 AND 3 PASSENGER CABIN CRACK AT SPLICE STRINGER 10R FR 59 AREA. STRINGER WAS SPLICED IAW ETD 2019-170-083637. AIRCRAFT REMAINS OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR R61A2019062910667Angle · crackedFORWARD FUSELAGE E-BAY ACCESS HATCH SURROUNDING STRUCTURE FOUND 1 ANGLE CRACKED AT FR 05 STR 26R. REPLACED ANGLE IAW SRM 51-41-02 AND 51-43-0.SDR R61A2019060190568Angle · crackedWHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK, CLIP CRACKED BELOW COCKPIT FLOOR.SDR R61A2019060190569Seal Depressor · crackedWHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK, L1 DOOR UPPER SEAL DEPRESSOR CRACKED.SDR R61A2019060190567Angle · crackedWHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK, ANGLE CRACKED BELOW COCKPIT FLOOR.SDR R61A2019060170566Skin · crackedWHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK, L/H WING L/E SKIN AT SLAT TRACK #4 CUTOUT IS CRACKED. REMOVED CRACK IAW SRM 57-49-01 R06.SDR R61A2019060150571Floorbeam · crackedWHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK, FLOOR SUPPORT BRACKET FOUND CRACKED AT CENTER FUSELAGE III.
Back to Embraer ERJ 170-100SU