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 UHLA201505310463Shear Tie · corrodedSHEAR TIE FRAME 17, STRINGERS 27 - 28L CORRODED. R & R THE SHEAR TIE IAW SRM 51-41-01 AND 51-41-02. MAJOR REPAIR.SDR UHLA201505290472Floor Support · corrodedRT FLOOR SUPPORT CORRODED FRAME 90, RBL 34. R & R THE FLOOR SUPPORT, IAW SRM 51-43-03.SDR UHLA201505290465Shear Tie · corrodedSHEAR TIE FRAME 16, STRINGERS 28L-28R CORRODED. R & R THE SHEAR TIE IAW SRM 51-41-01 AND SRM 51-41-02. MAJOR REPAIR.SDR R61A201505290340Pump · leakingTHE CREW REPORTED THAT THEY RECEIVED A HYDRAULIC SYSTEM 2 ENGINE DRIVEN PUMP FAILURE MESSAGE ON THE EICAS DURING FLIGHT. THE FLIGHT DIVERTED FROM ITS INTENDED COURSE AND LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED THE ENGINE DRIVEN HYDRAULIC PUMP NRSDR UHLA201505270479Shear Tie · corrodedLT SHEAR TIE, FRAME 87, LBL 42 CORRODED. R & R THE SHEAR TIE IAW SRM 51-42-02.SDR UHLA201505270471Seat Track · corrodedLT SEAT TRACK FRAME 84, LBL 12 CORRODED. FABRICATED EXTERNAL REPAIR DOUBLER FOR LT SEAT TRACK IAW ETD 2014-170-048485. R & R REPAIR DOUBLER IAW ETD 2015-170-048485. MAJOR REPAIR.SDR UHLA201505260470Shear Tie · corrodedSHEAR TIE FRAME 17, STRINGERS 26 - 27L CORRODED. R & R THE SHEAR TIE IAW SRM 51-41-01 AND 51-41-02. MAJOR REPAIR.SDR UHLA201505260464Shear Tie · corrodedSHEAR TIE FRAME 17, STRINGERS 28L-28R CORRODED. R & R THE SHEAR TIE IAW SRM 51-41-01 AND 51-41-02. MAJOR REPAIR.SDR UHLA201505260462Shear Tie · corrodedSHEAR TIE FRAME 17, STRINGERS 25 - 26L CORRODED. R & R THE SHEAR TIE IAW SRM 51-41-01 AND 51-41-02. MAJOR REPAIR.SDR UHLA201505240480Upper Sheet · corrodedLEFT UPPER SHEET AFT END FWD OF FRAME 86, LBL 10 CORRODED. R & R THE UPPER SHEET.SDR UHLA201505240477Upper Sheet · corrodedRT UPPER SHEET AFT END FWD OF FRAME 86, RBL 10 CORRODED. R & R THE UPPER SHEET IAW SRM 51-40-02, AND 51-41-01, 51-43-03.SDR UHLA201505240473Seat Track · corrodedSEAT TRACK, FRAME 16, LBL 12 CORRODED. REMOVED CORROSION, CUT OUT DAMAGE, FABRICATED AND INSTALLED REPAIR IAW SRM 53-10-10, 51-12-01.SDR UHLA201505230478Shear Plate · corrodedCENTER SHEAR PANEL AT FRAME 87-88 CORRODED AROUND MOUNT HOLES. R & R THE SHEAR PANEL .SDR UHLA201505230476Shear Plate · corrodedRT SHEAR PANEL AT FRAME 87-88, RBL 38 CORRODED. SHEAR PANEL R & R.SDR UHLA201505230475Shear Plate · corrodedRT SHEAR PANEL AT FRAME 87-88 CORRODED RBL 25. SHEAR PANEL R & R.SDR UHLA201505230474Shear Plate · corrodedRT SHEAR PANEL AT FRAMES 87-88, RBL 36 CORRODED. R & R THE SHEAR PANEL.SDR UHLA201505220469Shear Tie · corrodedSHEAR TIE FRAME 17, STRINGERS 25 - 26L CORRODED. R & R THE SHEAR TIE IAW SRM 51-41-01 AND 51-41-02. MAJOR REPAIR.SDR UHLA201505220468Shear Tie · corrodedSHEAR TIE FRAME 16, STRINGER 26 - 27L CORRODED. R & R THE SHEAR TIE IAW SRM 51-41-01 AND 51-41-02. MAJOR REPAIR.SDR UHLA201505220467Shear Tie · corrodedSHEAR TIE FRAME 16 STRINGERS 27 - 28R CORRODED. R & R THE SHEAR TIE IAW SRM 51-41-01 AND 51-41-02. MAJOR REPAIR.SDR UHLA201505220466Shear Tie · corrodedSHEAR TIE FRAME 16, STRINGERS 27 - 28L CORRODED. R & R THE SHEAR TIE IAW SRM 51-41-01 AND 51-41-02. MAJOR REPAIR.SDR UHLA201505220461Shear Tie · corrodedSHEAR TIE FRAME 17, STRINGERS 27 - 28R CORRODED. R & R THE SHEAR TIE IAW SRM 51-41-01 AND SRM 51-41-02. MAJOR REPAIR.SDR R61A201505190294Light · looseCREW REPORTED THAT THE PHOTOLUMINESCENT STRIP AT ROW 15 WAS UNATTACHED. MAINTENANCE RESECURED PHOTOLUMINESCENT STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201505170293Light · inoperativeMAINTENANCE REPORTED THAT THE EMERGENCY LIGHT STRIP AT ROW 2DF WAS NOT ILLUMINATING. MAINTENANCE R & R EMERGENCY LIGHT STRIP AT ROW 2DF IAW AMM AND OPS CHECKED GOOD.SDR R61A201505130307Shear Plate · corrodedWHILE IN HEAVY CHECK WAS REPORTED THAT TOP METAL PIECE ON FRAME 87-88 IN FRONT OF R-2 DOOR AROUND OF GALLEY MOUNTING NUT PLATES IS CORRODED. MAINTENANCE R & R TOP METAL PIECE ON FRAME 87-88 IN FRONT OF R-2 DOOR AROUND OF GALLEY MOUNTING NUT PLATES IAW SRM 51-SDR R61A201505130306Crossbeam · corrodedDURING HEAVY CHECK, RT CROSSBEAM JUST IN FRONT OF FRAME 86 IS CORRODED. MAINTENANCE R & R THE CROSSBEAM IAW SRM 51-40-02, 51-41-01, 51-43-01. .SDR R61A201505120287Autothrottle Sys · failedCREW REPORTED THAT THE AUTOPILOT AND AUTOTHROTTLES DISENGAGED AND CREW RECEIVED AN AVNX MAU1A FAIL MESSAGE. CREW RAN QRH AND DECLARED AN EMERGENCY. WITH PASSENGERS BRACING, CREW LANDED WITHOUT INCIDENT. AFTER BEING CHECKED OUT BY EMERGENCY VEHICLES, CREW ALLOSDR R61A201505100308Drain Valve · corrodedDURING HEAVY CHECK, FWD DRAIN VALVE CORRODED. MAINTENANCE R & R FWD DRAIN VALVE AMM 38-11-09.SDR R61A201505090310Insert · corrodedDURING HEAVY CHECK CABIN FLOOR PANEL 251 INSERT IS CORRODED. R & R THE FLOOR PANEL INSERT IAW AMM 25-00-17.SDR R61A201505090309Bolt · corrodedDURING HEAVY CHECK, GIRT BAR END CAP ATTACHING BOLT IS CORRODED. MAINTENANCE R & R GIRT BAR END CAP ATTACHING BOLT IAW AMM 52-41-41, PN NAS6604-14, BOLT. AIRCRAFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201504280267Rod · brokenCREW RECEIVED A LANDING GEAR NOSE DOOR OPEN MESSAGE. CREW RAN QRH, MESSAGE CLEARED AND LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED AND FOUND THE LT AFT NLG DOOR ROD BROKEN. MAINTENANCE R & R LT AFT NLG DOOR ROD IAW AMM AND OPS CHECKED GOOD.SDR R61A201504180250Bolt · corrodedWHILE IN HEAVY CHECK, THE L2 FWD ESCAPE SLIDE FASTENERS ARE CORRODED. MX R & R L2 FWD ESCAPE SLIDE FASTENERS IAW AMM 53-23-21, PN NAS6603-10 BOLT. AIRCRAFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201504150259Shear Tie · corrodedMAJOR REPAIR, DURING HEAVY CHECK WAS REPORTED THAT SHEAR CLIP AT FRAME 75 BETWEEN STRINGERS 28-29R ARE CORRODED. MAINTENANCE REMOVED AND FABRICATED SHEAR CLIP INSTALLED ON FRAME 75 BETWEEN STRINGERS 28-29R IAW SRM 51-31-00, 51-41-01 SEE VP-011295-2015/530, C1SDR R61A201504150252Bolt · corrodedWHILE IN HEAVY CHECK, THE L1 DOOR STOP CRANK STOP NUT AND BOLT ARE CORRODED. MX R & R L1 DOOR STOP CRANK STOP NUT AND BOLT IAW AMM 53-20-01. PN NAS4284A6, BOLT. ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201504150251Bolt · corrodedDURING HEAVY CHECK WAS REPORTED THAT R1 DOOR BELL CRANK STOP NUT AND BOLT IS CORRODED. MAINTENANCE R & R R1 DOOR BELL CRANK STOP NUT AND BOLT IAW AMM 52-41-20. PN NAS428-4A6, SCREW. ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201504150249Doubler · corrodedDURING HEAVY CHECK, LAVATORY WASTE BOX INTERNAL DOUBLER IS CORRODED. MX COMPLIED WITH SB R170EO-53-0-0020 FOR WASTE BOX R & R DOUBLERS SEE CONTINUATION CARDS VP-011295-2015/535 FOR WORK DETAILS C1. FCS 53-23-00-001 ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201504140275Bonding · corrodedDURING HEAVY CHECK RACK 1B FAIRING 191FL BOND PLATES UNDER PANEL 191EL ARE CORRODED. MX REMOVED RECEPTACLE TO PERFORM REPAIR. PREPPED SURFACE LAY UP IAW SRM 51-73-00, 51-45-00 REPAIRED CORRODED BONDING PLATES UNDER PANEL 191EL IAW SRM 51-73-00. AIRCRAFT REMASDR R61A201504140274Bonding · corrodedWHILE IN HEAVY CHECK WAS REPORTED THAT RACK 1B FAIRING 191FL BONDING PLATES UNDER PANEL 191AR ARE CORRODED. MAINTENANCE REMOVED RECEPTACLES TO PERFORM REPAIR, PREPPED SURFACE TO LAY UP REPAIR IAW SRM 51-45-00, REPAIRED CORRODED BONDING PLATES UNDER PANEL 191ASDR R61A201504140273Bonding · corrodedDURING HEAVY CHECK, RACK 1B FAIRING 195NL BOND PLATES UNDER PANEL 195CR ARE CORRODED. MAINTENANCE REMOVED RECEPTICLES, PERFORMED REPAIR, PREPPED SURFACE TO LAY SUPPLIES IAW SRM 51-45-00, 51-73-00. LAYED UP CURED REPAIR PLIES IAW SRM 51-73-00. AIRCRAFT REMAINSDR R61A201504140271Firewall · crackedDURING HEAVY CHECK WAS REPORTED THAT RT APU REMOVABLE FIRE WALL 351BZ TOP AND BOTTOM OF FLANGE IS CRACKED. MAINTENANCE REMOVED DAMAGE AND INSTALLED DOUBLER IAW ETD 2015-170-035645.SDR R61A201504140255Bolt · corrodedDURING HEAVY CHECK, L2 DOOR LOWER SLIDE ATTACHMENT BOLT ON DOOR IS CORRODED. MAINTENANCE R & R L2 DOOR LOWER SLIDE ATTACHMENT BOLT ON DOOR IAW AMM 52-12-20. PN NAS6604D12, BOLT ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201504140254Bolt · corrodedWHILE IN HEAVY CHECK, THE L2 DOOR BOTTOM BOLT FWD COMMAND RAMP IS CORRODED. MAINTENANCE R & R L2 DOOR BOTTOM BOLT FWD COMMAND RAMP IAW AMM 53-23-21, PN NAS6204-12 BOLT. ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201504130272Hinge · corrodedDURING HEAVY CHECK WAS REPORTED THAT WATER/WASTE ACCESS DOOR HINGE IS CORRODED. MAINTENANCE R & R WATER/WASTE ACCESS DOOR HINGE IAW SRM 51-40-02, 51-41-02.SDR R61A201504130270Beam · corrodedWHILE IN HEAVY CHECK WAS REPORTED THAT LT BEAM Y=10.748, FRAME 86-89 IS CORRODED. MX R & R LT BEAM IAW SRM 51-40-02, 51-43-02, & 51-43-03. AIRCRAFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201504150269Beam · corrodedDURING HEAVY CHECK, RT BEAM Y=10.748, FRAME 86-89 IS CORRODED. MAINTENANCE R & R RT BEAM Y=10.748, FRAME 86-89 IAW SRM 51-40-02, 51-23-06, 51-43-03 REFER TO IPM 12 FOR WORK DETAILS. PN 170-85669-002 BEAM. AIRCRAFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201504130263Gusset · corrodedDURING HEAVY CHECK WAS REPORTED THAT LT GUSSET AT FRAME 90 IS CORRODED. MX R & R LT GUSSET AT FRAME 90 IAW SRM 51-41-02, PN 170-60257-001, GUSSET. ACFT REMAINS UNTIL CHECK IS COMPLETED.SDR R61A201504130262Door Sill · corrodedHEAVY CHECK WAS REPORTED THAT RT FLOOR SILL FRAME 12-14 IS CORRODED. MX R & R RT FLOOR SILL FRAME 12-14 IAW SRM 51-40-02, 51-41-02, 51-43-02. PN 170-05663-003 SILL. AIRCRAFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201504130261Seat Track · corrodedDURING HEAVY CHECK, LT FLOOR TRACK AT FRAME 17-18 HAS CORROSION. MAINTENANCE R & R LT FLOOR TRACK AT FRAME 17-18, IAW SRM 51-41-01, 51-41-02, 51-43-03,51-43-04, PN 170-03264-001, TRACK. ACFT REMAINS AT UNTIL CHECK IS COMPLETED.SDR R61A201504130260Gusset · corrodedDURING HEAVY CHECK WAS REPORTED THAT LT CENTER GUSSET PLATE AT FRAME 91 IS CORRODED. MAINTENANCE R & R GUSSET PLATE AT FRAME 91 IAW SRM 51-21-01, 51-41-02. PN 170-60409-003 GUSSET. ACFT REMAINS UNTIL HEAVY CHECK IS FINISHED.SDR R61A201504130253Structure · corrodedDURING HEAVY CHECK, THE GALLEY MATTING SURFACES ARE CORRODED. MAINTENANCE R & R AFT GALLEY TRIM STRIPS IAW CMM 25-33-55. REF CONTINUATION CARDS VP-011295-2015/163 C1 FOR WORK ACCOMPLISHED. CDSP2200-11 TRIM. ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201504110236Ramp · out of adjustPASSING THRU 8500 FT CREW RECEIVED AN AFT DOOR OPEN INDICATION. CREW LEVELED OFF AT 10000 FT, RAN QRH AND NOTED THAT THE PRESSURIZATION WAS NOT OPERATING NORMALLY. CREW DID NOT DECLARE AN EMERGENCY AND ELECTED TO RETURN TO WHERE THEY LANDED WITHOUT INCIDENT.
Back to Embraer ERJ 170-100SU