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 R61A201406250838Torque Tube · corrodedDURING HEAVY CHECK, LT WING FLAP TORQUE TUBE NR 5 SPLINES ARE CORRODED. MX R & R LT WING FLAP TORQUE TUBE NR 5 IAW AMM 27-51-03, PN 5912949-2 TORQUE TUBE.SDR R61A201406250837Beam · corrodedDURING HEAVY CHECK, BOTH AFT SERVICE DOOR EMERGENCY EVAC FITTINGS ARE CORRODED. MX R & R LOWER SILL BEAM AND REPLACED IAW SRM 51-40-04, 51-40-02, 51-41-01, 51-41-02, 51-43-03, 51-43-04. MAJOR REPAIRSDR R61A201406250828Support · corrodedDURING HEAVY CHECK, RT SUPPORT AT FRAME 14 IS CORRODED. MX R & R RT SUPPORT AT FRAME 14 IAW SRM 51-40-02.SDR R61A201406250821Shear Tie · corrodedDURING HEAVY CHECK, SHEAR TIE FWD SIDE OF FRAME 84, STRINGERS 27-28 IS CORRODED. MX R & R SHEAR IAW SRM 51-23-06, CPM 51-25-00, AMM
12-22-01.SDR R61A201406250813Gusset · corrodedDURING HEAVY CHECK, THREE GUSSETS LOCATED ON CROSSBEAM FRAME 90 ARE CORRODED. MX R & R GUSSETS IAW SRM 51-41-02.SDR R61A201406250812Bolt · corrodedDURING HEAVY CHECK, AFT PAX DOOR AFT EMERGENCY EVACUATION SLIDE FITTING ATTACHING HARDWARE CORRODED. MX R & R HARDWARE IAW AMM 53-23-25,SDR R61A201406240864Bolt · corrodedDURING HEAVY CHECK, LOWER EES MOUNT BOLTS AT R2 DOOR ARE CORRODED. MX R & R LOWER EES MOUNT BOLTS AT R2 DOOR IAW AMM 20-10-01SDR R61A201406240863Stop Fitting · corrodedDURING HEAVY CHECK, R2 DOOR ADJUSTABLE STOPS ON BELLCRANK ASSY ARE CORRODED. MAINTENANCE R & R R2 DOOR ADJUSTABLE STOPS IAW AMM 54-42-20.SDR UHLA2014062400477Gusset · corrodedCORROSION FOUND ON GUSSET FRAME 84. R & R GUSSET.SDR R61A201406240845Dampener · corrodedDURING HEAVY CHECK, R2 DOOR DAMPENER IS CORRODED. MX R & R R2 DOOR DAMPENER IAW AMM 52-42-27.SDR R61A201406240827Structure · corrodedDURING HEAVY CHECK, WASTE SERVICE BOX DOUBLER FWD INBD CORNER IS CORRODED. MX R & R WASTE SERVICE BOX IAW E0-53-10-0020 AND 51-43-04. APPLIED TOP COAT AND CIC PROTECTION IAW SRM 51-23-06 CPM 51-25-00.SDR R61A201406240826Nut · corrodedDURING HEAVY CHECK, WAS REPORTED THAT R2 DOOR STOP NUTS ON LOWER FWD 2 DOOR STOPS ARE CORRODED. MX R & R R2 DOOR STOP NUTS ON LOWER FWD 2 DOOR STOPS IAW AMM 52-42-23, PN NAS509-7, NUT.SDR R61A201406240823Bolt · corrodedDURING HEAVY C-CHECK, R2 DOOR CUT OUT, ALL DOOR STOP MOUNTING BOLTS RUSTY. MX R & R R2 DOOR DOOR STOP MOUNTING BOLTS IAW AMM2-23-25.SDR R61A201406240815Seal Depressor · corrodedDURING HEAVY CHECK, L1 DOOR FWD SEAL DEPRESSOR IS GOUGED. MX R & R SEAL DEPRESSOR IAW SRM SRM 51-41-01. MAJOR REPAIR.SDR R61A201406240811Floor Support · corrodedDURING HEAVY CHECK, RT FLOOR SUPPORT AFT OF R2 DOOR FRAMES 88-90 CORRODED. MX R & R FLOOR SUPPORT IAW SRM 51-40-02, & 51-41-01.SDR R61A201406240810Floor Support · corrodedDURING HEAVY CHECK, FLOOR SUPPORT AFT OF L2 DOOR AT FRAMES 88-90 IS CORRODED. MX R & R FLOOR SUPPORT IAW SRM 51-40-02, & 51-41-01, 51-43-01.SDR R61A201406240809Floorbeam · crackedDURING HEAVY CHECK, LT & RT FLOORBEAM ANGLES ARE CRACKED AT FRAME 86. MX R & R ANGLES IAW SRM 51-41-01.SDR R61A201406240808Shear Web · corrodedWHILE IN HEAVY CHECK WAS REPORTED THAT R/H SHEAR WEB AT FRAMES 87-88 IS CORRODED. MX REMOVED AND REPLACED RT SHEAR WEB IAW SRM 51-40-02,51-42-01.SDR R61A201406240807Shear Web · corrodedDURING HEAVY CHECK, CENTER SHEAR WEB AT FRAMES 87-88 CORRODED. MX R & R CENTER SHEAR WEB IAW SRM 51-40-02,51-42-01.SDR R61A201406240806Seal Depressor · gougedDURING HEAVY CHECK, L1 DOOR FWD SEAL DEPRESSOR IS GOUGED. MX R & R L1 DOOR FWD SEAL DEPRESSOR IAW SRM 51-41-01.SDR R61A201406240788Torque Tube · corrodedDURING HEAVY CHECK, RT WING FLAP TORQUE TUBE F5 MALE END IS CORRODED. MX R & R RT WING FLAP TORQUE TUBE F5 IAW AMM 27-51-03, PN 5912949-2.SDR R61A201406240787Torque Tube · corrodedDURING HEAVY CHECK, RT WING FLAP TORQUE TUBE, F6 MALE ROD END IS PITTED. MX R & R RT WING FLAP TORQUE TUBE F6 MALE ROD END IAW AMM 27-51-03, PN 5912949-3, F6 TORQUE TUBE.SDR R61A201406230857Spar · chafedDURING HEAVY CHECK, HYD PRESSURE LINE JAMNUT LOOSE & CHAFING ON SPAR 3 LT WING JUST OTBD OF RIB 4. MX LT SPAR 3, FCBS57-10-00-001, BETWEEN RIB 4A-6 WAS REPAIRED IAW ETD 2014-170-053811, REV B. FOR WORK DETAILS THIS REPAIR REQUIRES REINSPECT IAW ETD 2014-170-SDR UHLA2014062300474Doubler · corrodedCORROSION FOUND AROUND SCUFF PLATE DOME NUTPLATES IN LIP OF FWD CARGO DOOR THRESHOLD. R & R NUTPLATE DOUBLER ASSY.SDR R61A201406230848Dampener · corrodedDURING HEAVY CHECK, FWD SERVICE DOOR DAMPENER IS CORRODED. MAINTENANCE R & R FWD SERVICE DOOR DAMPENER IAW AMM 51-41-27.SDR R61A201406230824Screw · corrodedDURING HEAVY CHECK, RETAINING SCREWS ON INDICATOR SWITCH IN POTABLE WATER PANEL ARE CORRODED. MX R & R RETAINING SCREWS ON INDICATOR SWITCH IN POT WATER PANEL IAW AMM 20-10-01. PN NAS1801-08-10, SCREWS.SDR R61A201406230805Screw · corrodedDURING HEAVY CHECK, L2 DOOR SLIDE CABLE LOWER MOUNTING HARDWARE IS CORRODED. MX R & R L2 DOOR SLIDE CABLE LOWER MOUNTING HARDWARE IAW AMM 52-12-40. PN NAS1154-10D, SCREW.SDR R61A201406230804Trim Panel · corrodedDURING HEAVY CHECK, AFT GALLEY FWD AND AFT HALVES TRIM PIECES HAVE CORROSION. MX R & R AFT GALLEY FWD AND AFT HALVES TRIM PIECES IAW CMM 25-33-55. PN 170-59522-001, TRIM.SDR R61A201406230789Bracket · crackedDURING HEAVY CHECK, NLG STEERING MANIFOLD MOUNTING BRACKET IS CRACKED. MX R & R NLG STEERING MANIFOLD MOUNTING BRACKET IAW SRM 51-40-02, 51-43-03 RESTORED TOP COAT AND REPLACEMENT FASTENERS IAW SRM 51-23-06, PN 170-10788-401 SUPPORT.SDR R61A201406230786Seal Depressor · gougedDURING HEAVY CHECK, FWD PAX DOOR SEAL DEPRESSOR GOUGED IN SEVERAL AREAS BOTH FWD AND AFT SIDES OF DEPRESSOR. MX R & R AFT FWD PAX DOOR SEAL DEPRESSOR IAW SRM 51-43-03 ,51-41-01. MAJOR REPAIRSDR R61A201406230775Firewall · crackedDURING HEAVY CHECK, RT APU FIREWALL IS CRACKED. MX PERFORMED REPAIR INSTRUCTIONS IAW SRM 53-31-21.SDR UHLA2014062200483Crossbeam · corrodedCORROSION FOUND ON CROSSBEAM FRAME 84 LT. REPAIRED CROSSBEAM. MAJOR REPAIR.SDR UHLA2014062200482Crossbeam · corrodedCORROSION FOUND ON CROSSBEAM BETWEEN SEAT TRACKS FRAME 84. REPAIRED CROSSBEAM. MAJOR REPAIR.SDR UHLA2014062200481Crossbeam · corrodedCORROSION FOUND ON CROSSBEAM FRAME 84 RT. REPAIRED CROSSBEAM. MAJOR REPAIR.SDR UHLA2014062200480Threshold · corrodedCORROSION FOUND ON L2 DOOR THRESHOLD BEAM AFT FLOOR FITTING AREA. PERFORMED SPOTFACE TO REMOVED DAMAGE IAW ETD2014-170-052382. MAJOR REPAIR.SDR UHLA2014062200479Crossbeam · corrodedCORROSION FOUND ON CROSSBEAM, FRAME 17 BETWEEN SEAT TRACKS. CUT OUT DAMAGED AREA AND INSTALLED A ANGLE DOUBLER IAW ETD2014-170-053184. MAJOR REPAIR.SDR UHLA2014062200478Crossbeam · corrodedCORROSION FOUND ON CROSSBEAM FRAME 17 Y+10.748. CUT OUT DAMAGED AREA OF CROSSBEAM AND INSTALLED AN ANGLE DOUBLER IAW ETD2014-170-053184. MAJOR REPAIR.SDR UHLA2014062200476Seat Track · corrodedCORROSION FOUND ON LT SEAT TRACK Y-10.748, BETWEEN FRAMES 83-84. REPAIRED SEAT TRACK.SDR UHLA2014062200475Seat Track · corrodedCORROSION FOUND ON RT SEAT TRACK AT FRAMES 82-84. R & R RT SEAT TRACK.SDR R61A201406220825Bonding Strap · corrodedDURING HEAVY CHECK, RT ACCESS PANEL CUT OUT NUMEROUS BONDING STRAPS CORRODED. MX R & R 191FL RT ACCESS PANEL CUT OUT NUMEROUS BONDING STRAPS IAW SRM 51-73-00, AND REPLACED WORN AND CORRODED RECEPTACLE IAW SRM 51-42-04.SDR R61A201406220803Hinge · corrodedDURING HEAVY CHECK, WASTE ACCESS DOOR HINGE HAS CORROSION. MX R & R WASTE ACCESS DOOR HINGE IAW SRM 51-41-02.SDR R61A201406220802Bonding Strap · corrodedDURING HEAVY CHECK, FAIRING 191FL, RT NACA SCOOP BONDING STRAP IS CORRODED. MX R & R FAIRING 191FL R/H NACA SCOOP BONDING STRAP IAW EMB 170/175 SRM 51-42-04,53-04-20 SEE CONTINUATION CARD C1 FOR WORK ACCOMPLISHED. PN 170-01108-608, STRAP, ACFT REMAINS UNTIL HSDR R61A201406210770Light · dirtySECOND AND THIRD RT EMERGENCY LIGHTS DIRTY. REPLACED EMERGENCY LIGHTS IAW AMM 33-50-00.SDR R61A201406210769Power Supply · inoperativeLEFT FORWARD EMERGENCY LIGHT POWER UNIT INOPERATIVE. R & R EMERGENCY LIGHT POWER PACK ABOVE R1 DOOR. OP CHECK GOOD AT THIS TIME IAW AMM 33-45-01.SDR R61A201406190768Light · crackedSEVERAL EMERGENCY LIGHT STRIPS CRACKED.SDR UHLA2014061400429Warning Light · false activationINDICATION ON MFD, R2 DOOR SHOWS DOOR ARMED WHEN DOOR IS NOT ARMED. INDICATION ON DOOR SHOWS DISARMED. COMPLETED OPS CHECK OF R2 DOOR LOCKING INDICATION AND SLIDE ARM/DISARM INDICATION IAW AMM 52-42-00. NO DEFECTS NOTED.SDR R61A201406080740Wire Harness · defectiveCREW REPORTED THAT THE L2 DOOR PASSENGER DOOR SHOWED OPEN. AN EMERGENCY WAS NOT DECLARED AND LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED, R & R THE L2 DOOR WARNING SENSOR HARNESS IAW AMM AND OPS CHECKED GOOD.SDR R61A201406070739Actuator · failedCREW RECEIVED SLAT LOW RATE MESSAGE AT FL200. DETECTED AN ELECTRICAL SMOKE ODOR. NO SMOKE WAS VISIBLE AND ODOR STARTED TO DISSIPATE, DONNED OXYGEN MASKS, RETURNED TO DEPARTURE, DECLARED AN EMERGENCY AND RAN QRH. LANDED WITHOUT INCIDENT. MAINTENANCE INSPSDR R61A201406030717Light · looseCREW REPORTED THAT THE EMERGENCY LIGHT WAS LOOSE. MAINTENANCE SECURED THE LIGHT IAW AMM AND OPS CHECKED GOOD.SDR UHLA2014060200412Threshold · corrodedCORROSION FOUND AROUND RIVET HEADS ON R2 DOOR THRESHOLD. R & R THRESHOLD. MAJOR REPAIR.
Back to Embraer ERJ 170-100SU