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 R61A201504040228Light · detachedCREW REPORTED THAT THE PHOTO LUMINESCENT STRIP WAS DETACHED AT ROW 16. MAINTENANCE RESECURED PHOTO LUMINESCENT STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201503300224Rib · corrodedDURING HEAVY CHECK, FIXED T/E RIB 10 LT WING REQUIRES ALTERNATE MEANS OF REPAIR. MX FIXED T/E RIB 10 LT WING REQUIRES ALTERNATE MEANS OF REPAIR, IAW SB 170-57-0047, ALSO ETD 2015-170-028796, REV H. CONTINUATION CARD C1-C3 FOR DETAILS OF WORK. ACFT REMAINS USDR R61A201503260190Sensor · failedCREW RECEIVED A FLAP FAIL MESSAGE. CREW RAN QRH WITH NO SUCCESS. CREW DECLARED AN EMERGENCY, DIVERTED AND WITH VEHICLES ROLLING, LANDED AND TAXIED TO GATE WITHOUT INCIDENT. MAINTENANCE TROUBLESHOT AND FOUND FLAP SKEW SENSOR VOLTAGE OUT OF LIMITS. MAINTENANCESDR R61A201503250226Rib · crackedDURING HEAVY CHECK, LT WING, RIB 10 CRACKED CHORD WISE JOINT, SPLICE GOING FWD, CRACK LIKE INDICATIONS IN FASTENER HOLE JUST OTBD OF SKIN SPLICES IAW ETD 2013-170-000186. MAINTENANCE REPAIRED HOLE IAW ETD 2015-170-028597. FINAL HOLE SIZE .503 INSTALLED BUSHISDR R61A201503250225Rib · crackedDURING HEAVY CHECK, RT WING AFT RIB 10 HOLE IN INBD LOWER FLANGE JUST FWD OF SPAR 2 IS CRACKED CRACKS RADIATING INBD AND OTBD FROM HOLE. MAINTENANCE REPAIRED HOLE IAW ETD 2015-170-028597 FINAL HOLE REAMED TO 504 INSTALLED BUSHING. C1-C2 FOR WORK DETAILS. ACSDR R61A201503240199Fitting · crackedDURING HEAVY CHECK, LT WING STUBB FITTING AT SPAR 3 , RIVET REPLACEMENT HOLE HAS CRACK LIKE INDICATION. MAINTENANCE UP SIZED HOLE SIZED PLUGS, INSTALLED IAW ETD 2015-170-028607, REV A, SEE CONTINUATION CARDS C1-C4 FOR WORK DETAILS. ACFT REMAINS UNTIL HEAY CHSDR R61A201503240198Fitting · crackedDURING HEAVY CHECK, RT WING STUB FITTING AT SPAR 3 RIVET REPLACEMENT HOLE HAS CRACKED. MAINTENANCE UP SIZED HOLE TO 560, IAW SB-170-57-0038. AND OVER SIZED PLUGS ARE INSTALLED IAW ETD2015-170, CONTINUATION CARDS C1-C6 FOR DETAILS. AIRCRAFT REMAINS UNTIL HSDR R61A201503240189Light · inoperativeCREW REPORTED THAT THE PHOTO LUMINESCENT STRIP AT SEATS 1D & 2D WOULD NOT ILLUMINATE. MAINTENANCE R & R PHOTO LUMINESCENT STRIPS IAW AMM AND OPS CHECKED GOOD.SDR R61A201503230223Bushing · corrodedDURING HEAVY CHECK, NR 5 HINGE MOUNT INBD BUSHING, LT ELEVATOR IS CORRODED. MAINTENANCE R & R NR 5 HINGE MOUNT INBD BUSHING LT ELEVATOR IAW AMM 20-10-08. PN PE64046H5-016-060C, BUSHING. ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201503230222Bushing · corrodedWHILE IN HEAVY CHECK WAS REPORTED THAT NR 1 HINGE FITTING INBD BUSHING ON LT ELEVATOR IS CORRODED. MAINTENANCE R & R NR 1 HINGE FITTING INBD BUSHING ON LT ELEVATOR IAW AMM 20-10-08.SDR R61A201503230221Nipple · corrodedDURING HEAVY CHECK AFT MOST REAR FUSELAGE DRAIN TUBE NIPPLE AND NUT ARE CORRODED. MAINTENANCE R & R AFT MOST REAR FUSELAGE DRAIN TUBE NIPPLE AND NUT IAW AMM 53-05-73.SDR R61A201503220213Bolt · corrodedDURING HEAVY CHECK, HYDRAULIC SYSTEM NR 2 DUMP VALVE BOLT CORRODED. MX R & R HYDRAULIC SYSTM NR 2 DUMP VALVE BOLT IAW AMM 29-11-26.SDR R61A201503220205Seat Track · corrodedDURING HEAVY CHECK, FWD FUSELAGE FLOOR STRUCTURE AT FRAME 19 IS CORRODED. MAINTENANCE R & R LT INBD FF SEAT TRACK EXTENSION IAW SRM 51-40-02, 51-43-01, 51-43-02 RESTORED TOPCOAT AND CIC IAW 51-25-00. PN 170-03264-001 TRACK. AIRCRAFT REMAINS UNTIL HEAVY CHECK SDR R61A201503220188Guide · damagedCREW REPORTED THAT THE L2 DOOR WOULD NOT CLOSE. MAINTEANCE WAS ABLE TO GET THE DOOR CLOSED. MAINTENANCE FOUND DAMAGE TO AFT LOWER ROLLER GUIDE AND DOOR STOPS ARE BINDING. MAINTENANCE REPLACED DOOR PROXIMITY SENSOR, REINSTALLED ROLL PIN AND PERFORMED RIG IAW SDR R61A201503210212Dampener · corrodedDURING HEAVY CHECK FWD SERVICE DOOR DAMPENER HAS CORROSSION. MX R & R FWD SERVICE DOOR DAMPENER IAW AMM 52-41-27.SDR R61A201503210211Bolt · corrodedDURING HEAVY CHECK, L1 DOOR FWD SIDE BOLTS ON DOORS LOCKING AND ACTUATING MECHANISM HANDLE ARE CORRODED. MAINTENANCE R & R L1 DOOR FWD SIDE BOLTS ON DOORS LOCKING AND ACTUATING MECHANISM HANDLE IAW AMM 52-11-20.SDR R61A201503210210Bolt · corrodedDURING HEAVY CHECK, LT WING NR 3 SPOILER HARDWARE IS CORRODED. MAINTENANCE R & R LT WING NR 3 SPOILER HARDWARE IAW AMM 27-65-0-1, PN NAS6212-31D, BOLT. ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201503210209Bolt · corrodedDURING HEAVY CHECK, LT WING SPOILER, NR 4 ACTUATOR HARDWARE IS CORRODED. MAINTENANCE R & R LT WING SPOILER NR 4 ACTUATOR HARDWARE IAW AMM 27-05-01.SDR R61A201503210208Bolt · corrodedDURING HEAVY CHECK, RT WING NR 2 GROUND SPOILER HARDWARE AT ACTUATOR IS CORRODED. MX R & R RT WING NR 2 GROUND SPOILER HARDWARE AT ACTUATOR IAW AMM 27-61-01.SDR R61A201503210207Spigot · corrodedDURING HEAVY CHECK, AFT GALLEY SPIGOT IS CORRODED. MAINTENANCE R & R AFT GALLEY SPIGOT IAW CMM 25-33-55. ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201503220206Seat · crackedDURING HEAVY CHECK, SEAT PAN CRACKED. MAINTENANCE R & R THE SEAT PAN.SDR R61A201503200182Flashlight · inoperativeCREW REPORTED THAT THE FORWARD F/A FLASHLIGHT IS INOPERATIVE. MAINTENANCE PLACED ON MEL AND LATER R & R FORWARD F/A FLASHLIGHT BATTERIES IAW AMM AND OPS CHECKED GOOD.SDR R61A201503200179Battery Pack · inoperativeMAINTENANCE REPORTED THAT THE EXIT SIGN ABOVE THE L2 DOOR DID NOT ILLUMINATE DURING TEST. MAINTENANCE R & R EMERGENCY BATTERY IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR R61A201503130215Attach Fitting · corrodedDURING HEAVY CHECK, AFT BELLY PANEL 195NL FWD ATTACH CENTER ATTACH STRIP IS CORRODED. MX R & R AFT BELLY PANEL, 195NL FWD ATTACH CENTER ATTACH STRIP IAW AMM 53-04-50.SDR R61A201503120219Upper Sheet · corrodedDURING HEAVY CHECK, LT UPPER SHEET AT FRAME 85-86 IS CORRODED. MAINTENANCE R & R LT UPPER SHEET AT FRAME 85-86 IAW SRM 51-43-07, 51-41-01.SDR R61A201503120218Floor Support · corrodedDURING HEAVY CHECK, LT PANEL SUPPORT FRAME 88-90 IS CORRODED. MAINTENANCE R & R LT PANEL SUPPORT FRAME 88-90 IAW SRM 51-41-01, 51-42-01, 51-43-03.SDR R61A201503120217Gusset · corrodedDURING HEAVY CHECK, CENTER GUSSET AT FRAME 90 IS CORRODED. MAINTENANCE R & R CENTER GUSSET AT FRAME 90 IAW SRM 51-43-90.SDR R61A201503120216Gusset · corrodedDURING HEAVY CHECK, RT FRAME 91, Y10.78 GUSSET IS CORRODED. MAINTENANCE R & R RT FRAME 91, Y10.78 GUSSET IAW SRM 51-41-02.SDR R61A201503120197Splice Plate · corrodedDURING HEAVY CHECK, SPLICE PLATE RT SHEAR PLATE AT FRAMES 87-88. MAINTENANCE R & R SPLICE PLATE RT SHEAR PLATE AT FR 88/87 IAW SRM 51-21-02, 51-40-02, PN 170-65644-001, SPLICE PLATE. ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201503120195Gusset · corrodedDURING HEAVY CHECK LT GUSSET AT FRAME 91 IS CORRODED. MAINTENANCE R & R LT GUSSET AT FRAME 91 IAW SRM 51-41-02. ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201503120194Upper Sheet · corrodedDURING HEAVY CHECK, RT UPPER SHEET AT FRAME 85-86 IS CORRODED. MAINTENANCE R & R RT UPPER SHEET AT FRAME 85-86 IAW 51-43-03, 51-41-01. AIRCRAFT REMAINS UNTIL HEAVY CHECK IS COMPLETEDSDR R61A201503110231Stringer · corrodedDURING HEAVY CHECK, STRINGER 27R AT FRAME 88 IS CORRODED. MX R & R STRINGER 27R AT FRAME 88 IAW ETD 2015--170--027169, REV A. ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201503110204Closeout Panel · corrodedWHILE IN HEAVY CHECK WAS REPORTED THAT AFT CARGO DOOR THRESHOLD CLOSE OUT PANEL IS CORRODED. MAINTENANCE R & R AFT CARGO DOOR THRESHOLD CLOSE OUT PANEL IAW SRM 51-21-01, PN 170-27618-001. ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201503110203Seat Track · corrodedDURING HEAVY CHECK, LT FWD SEAT TRACK FRAME 12/20 AT FRAME 17 HAS CORROSSION. MAINTENANCE R & R LT SEAT TRACK FRAME 12/20 AT FRAME 17 IAW SRM 51-40-01, 51-41-03, 51-43-03, 51-43-02,51-23-06. PN 170-03264-001, SEAT TRACK ACFT REMAINS UNTIL HEAVY CHECK IS COMPSDR R61A201503110202Bracket · corrodedDURING HEAVY CHECK, WING TO FUSELAGE FAIRING ATTACH BRACKET AIR FRAME SIDE WHERE FAIRING 191FL IS CORRODED. MAINTENANCE R & R 4 EACH ATTACH FAIRING BRACKETS IAW SRM 51-41-02, 51-42-02. AIRCRAFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201503110196Gusset · corrodedDURING HEAVY CHECK, CENTER STRESS PANEL AT GALLEY MOUNTHOLE BETWEEN FRAME 87-88 IS CORRODED. MAINTENANCE R & R SHEAR PANEL, PN 170-65928-001, GUSSET. AIRCRAFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201503090159Acm · failedAROUND 10000 FT CREW HEARD A BANG AND THEN SMELLED AND SAW SMOKE. CREW DECLARED AND EMERGENCY AND ELECTED TO RETURN TO DEPARTURE WHERE THEY LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED AND FOUND PACK 1 ACM LOCKED UP. MAINTENANCE PLACED PACK 1 ON MEL IAW AMSDR R61A201503040134Light · inoperativeCREW REPORTED THAT THE PHOTO LUMINESCENT STRIP AT ROWS 6 & 7 WAS INOPERATIVE. MAINTENANCE R & R PHOTO LUMINESCENT STRIP AT ROWS 6 & 7 IAW AMM AND OPS CHECKED GOOD.SDR R61A201502230116Light · looseCREW REPORTED THAT THE PHOTO LUMINESCENT STRIP NEXT TO SEAT 13D WAS MISSING. MAINTENANCE FOUND PHOTO LUMINESCENT STRIP HAD SLID UNDER ADJACENT STRIP. MAINTENANCE RESECURED PHOTO LUMINESCENT STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201502230115Battery · inoperativeMAINTENANCE REPORTED THAT THE AFT RT EMERGENCY BATTERY WAS INOPERATIVE. MAINTENANCE R & R EMERGENCY BATTERY IAW AMM AND OPS CHECKED GOOD.SDR R61A201502130128Closeout Panel · corrodedWHILE IN HEAVY CHECK WAS REPORTED THAT CLOSE OUT PANEL IN FWD CARGO IS CORRODED. MX R & R CLOSE OUT PANEL IN FWD CARGO IAW AMM 20-16-07. PN 170-27615-4003, CLOSE OUT PANEL. ACFT REMAINS UNTIL HEAVY CHECK COMPLETED.SDR R61A201501130107Support · corrodedDURING HEAVY CHECK, RT PANEL SUPPORT LOCATED BETWEEN FRAMES 83-84 IS CORRODED. MX R & R RT PANEL SUPPORT LOCATED BETWEEN FRAMES 83-84 IAW 51-41-01.SDR R61A201502120125Shear Tie · corrodedDURING HEAVY CHECK, SHEAR CLIP AT FRAME 88 IS CORRODED. MAINTENANCE R & R FRAME 88, STR 28, RT IAW 51-41-02, 51-41-01, PN 170-66531-001, SHEAR CLIP. ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETE.SDR R61A201502120124Shear Tie · corrodedDURING HEAVY CHECK WAS REPORTED THAT SHEAR CLIP ON FRAME 86, STRINGER 27 AROUND FASTENERS IS CORRODED. MAINTENANCE R & R SHEAR CLIP ON FRAME 86, STRINGER 27 IAW SRM 51-41-02, 51-41-01, PN 170-66033-001 SHEAR CLIP. ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR UHLA2015021200071Light · inoperativeEMERGENCY LIGHTS INOPERATIVE AT SEATS 2A, 11CD. R & R EMERGENCY LIGHTS AT SEATS 2A AND 11CD IAW CR170-33-50-500-0001.SDR R61A201502120098Flashlight · inoperativeMAINTENANCE REPORTED THAT THE FORWARD F/A FLASHLIGHT WAS INOPERATIVE. MAINTENANCE R & R FORWARD F/A FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201502110147Gusset · corrodedDURING HEAVY CHECK, R/H CENTER GUSSET PLATE AT FRAME 90 HAS CORROSION. MAINTENANCE R & R RT CENTER GUSSET PLATE AT FRAME 90 IAW SRM 51-40-02, 51-21-01. PN 170-60257-001 GUSSET. ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201502110131Shear Plate · corrodedDURING HEAVY CHECK LT SHEAR PLATE FRAME 87-88 IS CORRODED. MAINTENANCE R & R LT SHEAR PLATE FRAME 87-88 IAW SRM 51-42-01. PN 170-65927-003, SHEAR PLATE. ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201502110130Support Frame · corrodedDURING HEAVY CHECK LT SUPPORT FRAME 88/90 IS CORRODED. MX R & R LT SUPPORT FRAME 88/90 IAW 51-41-1,51-42-02. PN 170-86139-005, SUPPORT. AIRCRAFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201502110129Shear Plate · corrodedDURING HEAVY CHECK RT SHEAR PLATE AT FRAME 87-88 IS CORRODED. MAINTENANCE R & R RT SHEAR PLATE AT FRAME 87-88 IAW 51-42-01, 51-42-02. PN 170-66409-001, SHEAR PLATE. ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.
Back to Embraer ERJ 170-100SU