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 R61A201306220552Oxygen Mask · dislodgedCREW REPORTED THAT THE OXYGEN MASKS ABOVE SEATS 5A AND 5C FELL. MX SECURED OXYGEN MASKS IAW AMM AND OPS CHECKED GOOD.SDR R61A201306210632Skin · puncturedFOUND SKIN DAMAGE BETWEEN FRAMES 94-95 AND STRINGERS 11R-12R. REAR FUSELAGE SKIN REPLACED IAW ETD2013-170-016058 AND TI-170-13-054, REV "B" .SDR R61A201306170544Handle · dirtyCREW REPORTED THE L1 DOOR WAS DIFFICULT TO OPEN FROM THE OUTSIDE. MX REMOVED DEBRIS FROM L1 DOOR OUTSIDE DOOR HANDLE MECHANISM IAW AMM AND OPS CHECKED GOOD.SDR UHLA2013061600251Slide · partial deployL2 DOOR ARMED AND JAMMED, WILL NOT DISARM. FOUND L2 DOOR EMERGENCY EVAC SLIDE PARTIALLY BLOWN. R & R L2 DOOR EMERGENCY EVAC SLIDE IAW AMM 25-65-01, OPS CHECK GOOD.SDR R61A201306160543Glowstrip · looseCREW REPORTED THAT THE PHOTO LUMINESCENT STRIP IN FRONT OF SEAT 10A UNSECURE. MX SECURED GLOWSTRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201306160542Linkage · dirtyCREW REPORTED L1 DOOR ARM/DISARM SIGN DOES NOT LINE UP WHEN DOOR IS SHUT. MX REMOVED DEBRIS FROM THE L1 DOOR ARM/DISARM INDICATOR LINKAGE IAW AMM AND OPS CHECKED GOOD.SDR R61A201306100524Control Rod · dirtyCREW REPORTED THAT THE L1 DOOR INDICATION WAS NOT SHOWING IN THE WINDOW. MX CLEANED AND LUBED THE INDICATION CONTROL ROD IAW AMM AND OPS CHECKED GOOD.SDR R61A201306090523Indicator · lack of lubeF/A REPORTED THAT THE GREEN LATCHED INDICATOR ON THE R1 DOOR IS MISALIGNED. MX LUBED GREEN LATCHED DOOR INDICATOR IAW AMM AND OPS CHECKED GOOD.SDR R61A201306090518Mechanism · dirtyCREW REPORTED THAT THE MAIN CABIN DOOR WILL NOT LOCK OPEN. MX CLEANED MAIN DOOR TRIGGER MECHANISM IAW AMM AND OPS CHECKED GOOD.SDR R61A201306010508Door · lack of lubeCREW REPORTED MAIN CABIN DOOR HARD TO CLOSE. MX LUBED L1 DOOR IAW AMM 12-10-00.SDR R61A201305270499Door · out of sequenceCREW REPORTED THAT THE L1 DOOR WILL NOT SHUT. MX INSPECTED AND FOUND THE DOOR OUT OF SEQUENCE. MX PUT DOOR BACK INTO SEQUENCE IAW AMM AND OPS CHECKED GOOD.SDR R61A201305260493Blade · damagedDURING CLIMB, CREW REPORTED A BIRD INGESTION INTO ENGINE NR 1. CREW DID NOT DECLARE AN EMERGENCY BUT DIVERTED TO PIT DUE TO HIGH LP VIBES. ACFT LANDED WITHOUT INCIDENT. MX FOUND 2 FAN BLADES DAMAGED, BUT CHANGED 4 TO KEEP ENGINE IN BALANCE IAW AMM. OPS CHECSDR R61A201305250495Mask · brokenCREW REPORTED THAT THE AFT F/A 02 DEMO MASK WAS BROKEN. MX R & R AFT F/A DEMO MASK IAW AMM AND OPS CHECKED GOOD.SDR R61A201305250490Rib · crackedWHILE ACFT WAS IN FOR HEAVY CHECK, MX FOUND THE RIB ASSEMBLY, PN 170-26230-403 CRACKED AT THE UPPER RT CORNER, 0.5" LONG. MX STOP DRILLED AND INSTALLED FABRICATED DOUBLER FROM 7475-T761, 0.050 MATERIAL. REF PO 024102-2011 IAW ETD2013-170-010548. ACFT IS CURSDR R61A201305220491Rib · crackedWHILE ACFT WAS IN FOR HEAVY CHECK, MX REPORTED THE RT RIB 14 ON THE HORIZONTAL STABILIZER HAS A .5" CRACK ON THE UPPER FLANGE AFT END. MX PERFORMED A MAJOR REPAIR. R & R RIB 14 IAW SRM 51-40-2, 51-41-02 & 51-42-00. ACFT IS CURRENTLY STILL OUT OF SERVICE FORSDR R61A201305220489Bracket · corrodedWHILE ACFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE FWD DRAIN MAST CLIP. BETWEEN FR 86-87 AND STR 27R TO 28R. MX R & R THE FWD DRAIN MAST, FORWARD INTERCOSTAL (CLIP) BRACKET. PART FABRICATED FROM 7475-T761, 0.050 MATERIAL, REF PO 024102-2SDR R61A201305220483Slide · defectiveCREW REPORTED THAT THE R2 DOOR WILL NOT ARM. MX FOUND THAT THE SLIDE WILL HAVE TO BE CHANGED. DURING SLIDE CHANGE, MX FOUND CABLE TO R2 DOOR GIRT BAR DAMAGED AND WILL HAVE TO BE CHANGED. MX R & R SLIDE AND FLEXBALL KIT IAW AMM AND OPS CHECKED GOOD.SDR R61A201305210488Bracket · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON A SHEAR CLIP AND A INTERCOSTAL BRACKET AT FR 86-87 BETWEEN STR 27R & 28R. MX R & R SHEAR CLIP AND INTERCOSTAL BRACKET, SHEAR CLIP, PN 170-66041-002 AND INTERCOSTAL BRACKET, PN 170-87562-001SDR R61A201305210487Fitting · corrodedWHILE ACFT WAS IN FOR HEAVY CHECK. LEVEL 2 CORROSION WAS FOUND ON A SHEAR CLIP AND A INTERCOSTAL BRACKET AT FR 87 BETWEEN STR 27R & 28R. MX R & R SHEAR CLIP AND INTERCOSTAL BRACKET, SHEAR CLIP, PN 170-66041-002 AND INTERCOSTAL BRACKET, PN 170-87562-001 WITH SDR UHLA2013051800145Sign · inoperativeL2 EMERGENCY EXIT LIGHT SIGN INOP. R & R L2 EMERGENCY EXIT LIGHT SIGN IAW AMM 33-50-19. OPS CHECK GOOD.SDR R61A201305180481Splice · corrodedWHILE ACFT WAS IN HEAVY CHECK, MX FOUND SPLICE BETWEEN FRAME 87 AND 88 CORRODED. MX R & R THE SPLICE IAW SRM 51-43-01. THE ACFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201305180469Gusset · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE GUSSET PLATE LEFT CENTER OF FRAME 90 CORRODED. MAINTENANCE REMOVED AND REPLACED THE GUSSET PLATE IAW EMB 170 SRM 51-41-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR UHLA2013051700180Doubler · corrodedCORROSION ON COCKPIT FLOOR DOUBLER, AFT OF COPILOTS INBD AND OTBD SEAT TRACKS. FABRICATED AND INSTALLED TWO DOUBLERS IAW ETD 2013-170-010233.SDR UHLA2013051700194Doubler · corrodedCOCKPIT FLOOR DOUBLER LT HAS CORROSION BETWEEN FR 8 - 9 ADJACENT TO CONTROL COLUMN SUPPORT. REMOVED CORROSION, FABRICATED DOUBLER IAW ETD2013-170-010321. MAJOR REPAIR.SDR UHLA2013051700179Panel · corrodedCORROSION, FWD CARGO DOOR FRAME CLOSE OUT PANEL. R & R FORWARD CARGO DOOR FRAME CLOSE OUT PANEL.SDR UHLA2013051700177Support · corrodedCORROSION, FORWARD CARGO DOOR LOWER FRAME PANEL SUPPORT. R & R SUPPORT.SDR UHLA2013051600182Floor Support · corrodedLEVEL 2 CORROSION, RT FLOOR SUPPORT FR85 AROUND SCREW HOLE. R & R FLOOR SUPPORT.SDR UHLA2013051600181Floor Support · corrodedCORROSION - RT FLOOR SUPPORT FR85 AROUND SCREW HOLE. R & R FLOOR SUPPORT AT RT FR85.SDR UHLA2013051600178Doubler · corrodedCORROSION - COCKPIT FLOOR DOUBLER BETWEEN FR8 AND FR9 ADJACENT TO CONTROL COLUMN SUPPORT. REMOVED CORROSION, FABRICATED DOUBLER IAW ETD 2013-170-010321.SDR UHLA2013051600176Seat Track · corrodedCORROSION, RT SEAT TRACK FR84. R & R SEAT TRACK SPLICE.SDR UHLA2013051600175Retainer · corrodedCORROSION, LAV PAN RETAINER. R & R LAV PAN RETAINER.SDR UHLA2013051600174Gusset · corrodedCORROSION, LT SPLICE GUSSET AT FR91. R & R GUSSET.SDR UHLA2013051600173Intercostal · corrodedCORROSION, RT INTERCOSTAL AT SCREW HOLES. R & R INTERCOSTAL.SDR UHLA2013051600172Panel · corrodedCORROSION ON CENTER SHELF PANEL AT FR87. R & R NEW CENTER SHEAR WEB IAW SRM 53-23-10.SDR UHLA2013051600171Beam · corrodedCORROSION, ON BEAM RT BETWEEN FR85 AND FR86 AROUND SCREW HOLE. R & R PLATE DOUBLER.SDR UHLA2013051600170Panel · corrodedCORROSION FOUND ON LEFT SHEAR INSPECTION PANEL. REPLACED LT SHEAR PANEL.SDR UHLA2013051600169Structure · corrodedCORROSION AT BEAM LT BETWEEN FR 85 AND FR86 AROUND SCREW HOLE. R & R DOUBLER.SDR UHLA2013051600168Plate · corrodedCORROSION SPLICE PLATE AT LT SHEAR PLATE TO FUSELAGE FR87. R & R SHEAR PLATE.SDR UHLA2013051600167Splice · unknownSPLICE PLATE ON RT SHEAR PLATE TO FR 87. R & R SPLICE PLATE.SDR UHLA2013051600166Gusset · corrodedCORROSION ONE FR 90 RT SPLICE GUSSET. R & R RT SPLICE GUSSET AT FRAME 90.SDR UHLA2013051600165Floor Support · unknownRT FLOOR SUPPORT FR 87-90 AROUND SCREW HOLES. R & R FLOOR SUPPORT.SDR UHLA2013051600164Floor Panel · unknownRIGHT FLOOR PANEL AT FRAME 87. R & R FLOOR PANEL.SDR R61A201305160500Support · crackedWHILE ACFT WAS IN FOR HEAVY CHECK. MX REPORTED A 0.5" CRACK ON THE RT HORIZONTAL RIB SPAR SUPPORT, INBD OF THE RT OTBD PCU. MX R & R THE CRACKED RIB (WEB RIB 7) SUPPORT IAW SRM 51-40-02, 51-41-01 & 51-41-02. ACFT IS CURRENTLY STILL OUT OF SERVICE FOR HEAVY CSDR R61A201305160480Rib · crackedWHILE ACFT WAS IN HEAVY CHECK, MX FOUND THE RT HORIZONTAL STABILIZER RIB 10A CRACKED. MX REPAIRED RT HORIZONTAL STABILIZER RIB 10A IAW ETD 2013-170-009905. "MAJOR REPAIR". THE ACFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201305160477Shear Tie · corrodedWHILE ACFT WAS IN HEAVY CHECK, MAINTENANCE FOUND THE SHEAR TIE FORWARD OF THE WASTE BOX AT FRAME 88 CORRODED. MAINTENANCE R & R THE SHEAR TIE IAW SRM 51-41-00. ACFT OUT OF SERVICE.SDR R61A201305150465Mask · missingCREW REPORTED THAT THE FLIGHT ATTENDANT DEMO MASK WAS MISSING. MAINTENANCE INSTALLED NEW DEMO MASK PER EMB AMM AND OPS CHECKED GOOD.SDR R61A201305140486Nut · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE R-2 DOOR STOPS AND HARDWARE. MX R & R THE DOOR STOPS AND HARDWARE IAW AMM 52-42-23, STOP SCREW, PN 170-68172-001 AND NUT, PN NAS509-7. ACFT IS CURRENTLY STILL OUT OF SERVICE FOR HEAVY SDR R61A201305140485Stop Fitting · corrodedWHILE ACFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE R-2 DOOR STOPS AND HARDWARE. MX R & R THE DOOR STOPS AND HARDWARE IAW AMM 52-42-23. STOP SCREW, PN 170-68172-001 AND NUT, PN NAS509-7. ACFT IS CURRENTLY STILL OUT OF SERVICE FOR HEAVY CHESDR R61A201305140471Transformer · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT WING NAV LIGHT TRANSFORMER TERMINAL COVER CORRODED. MAINTENANCE REMOVED AND REPLACED RIGHT WING NAV LIGHT TRANSFORMER IAW EMB 170 AMM 33-43-05. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201305130473Torque Tube · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT WING FLAP TORQUE TUBE SPLINE CORRODED. MAINTENANCE REMOVED AND REPLACED THE LEFT WING FLAP TORQUE TUBE IAW EMB 170 AMM 27-51-03. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.
Back to Embraer ERJ 170-100SU