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 R61A201404020511Threshold · corrodedDURING HEAVY CHECK, R2 DOOR THRESHOLD BETWEEN FRAMES 85-87 AT GIRT BAR FITTING IS CORRODED. MAINTENANCE REMOVED CORROSION IAW ETD 2014-170-028504.SDR R61A201404020505Threshold · corrodedDURING HEAVY CHECK, L2 DOOR THRESHOLD BETWEEN FRAMES 85-87 AT GIRT BAR FITTINGS IS CORRODED. MAINTENANCE R & R L2 DOOR THRESHOLD BETWEEN FRAMES 85-87 AT GIRTBAR FITTINGS IAW SRM 51-40-02, 51-41-01, 51-43-01. MAJOR REPAIR.SDR R61A201404020504Girt Bar · corrodedDURING HEAVY CHECK, SPLICE BAR INBD OF FWD L2 DOOR GIRT BAR FITTING AFT OF FRAME 5 CORRODED. MX R & R SPLICE BAR IAW SRM 51-40-02, 51-43-03.SDR R61A201404020502Rib · gougedDURING HEAVY CHECK, TWO GOUGES ON TOP OF VERTICAL STAB RIB 14. MAINTENANCE R & R VERTICAL STAB RIB 14 IAW SRM 51-41-02, 51-42-01, 51-42-02. MAJOR REPAIRSDR R61A201404020496Attach Bracket · crackedDURING HEAVY CHECK, FLOORBOARD CLIP NUT ATTACH BRACKET BETWEEN LT CENTER FLOORBEAM AND L2 DOOR THRESHOLD AT FRAME 85 IS CRACKED. MAINTENANCE R & R FLOORBOARD CLIP NUT ATTACH BRACKET BETWEEN LT CENTER FLOORBEAM AND L2 DOOR THRESHOLD AT FRAME 85 IAW SRM 51-41-SDR R61A201404020495Bolt · corrodedDURING HEAVY CHECK, AFT SERVICE DOOR STOP FITTINGS MOUNT HARDWARE STOP FITTINGS ARE CORRODED. MAINTENANCE R & R AFT SERVICE DOOR STOP FITTINGS MOUNT HARDWARE IAW AMM 52-42-23.SDR R61A201404020493Stop Fitting · corrodedDURING HEAVY CHECK, AFT SERVICE DOOR STOP FITTING, DOOR STOP LOCKNUT ON 3 FITTINGS 1, 2, 4 IS CORRODED. MX R & R AFT SERVICE DOOR STOP FITTING DOOR STOP LOCKNUT ON 3 FITTINGS 1, 2, 4 IAW AMM 52-42-23, PN NAS509-7, JAM NUT.SDR R61A201404020476Nut Plate · looseDURING HEAVY CHECK, FWD CARGO DOOR SCUFF PLATE HAS NUMEROUS NUT PLATES THAT ARE LOOSE AND ONE NUTPLATE NEEDED TO BE REPLACED BOTTOM OF SCUFF PLATE BETWEEN FRAMES 24-25. MAINTENANCE R & R DAMAGED CENTER SEAL REST IAW SRM 51-41-01, 51-40-02. DETAILS FCBS 53-21SDR R61A201404010512Support · corrodedDURING HEAVY CHECK, LT WING FLAP TRACK SUPPORT 2, 3, 4 FWD ATTACH POINTS HARDWARE IS CORRODED. MX R & R LT WING FLAP TRACK SUPPORT 2, 3, 4 FWD ATTACH POINTS HARDWARE IAW AMM 57-54-21, PN MS14145L8 NUT.SDR R61A201404010509Rib · crackedDURING HEAVY CHECK, LT HORIZONTAL STAB AFT OF FWD SPAR RIB 11 CRACKED ON FWD UPPER FLANGE AT AFT END. MAINTENANCE REPAIRED LT HORIZONTAL STAB RIB 11 IAW ETD2014-170-0028468.SDR R61A201404010492Rib · crackedDURING HEAVY CHECK, RT HORIZONTAL STAB AFT OF FWD SPAR RIB 12 FWD UPPER FLANGE AFT END IS CRACKED. MX PERFORMED PERMANENT REPAIR RT HORIZONTAL STAB AFT OF FWD SPAR RIB 12 FWD UPPER FLANGE AFT END IAW ETD 2014-170-028468. SEE CONTINUATION NR 326 C1,C2 FOR WORSDR R61A201403310514Channel · crackedDURING HEAVY CHECK, VERTICLE STABILIZER L/E RT LOWER GANG CHANNEL IS CRACKED. MX R & R CHANNEL IAW SRM 51-41-02.SDR R61A201403310506Structure · corrodedDURING HEAVY CHECK, AFT GALLEY ON FRONT EDGE AROUND COFFEEMAKER IS CORRODED. MX R & R ALL CORRODED PIECES ON FRONT EDGE AROUND COFFEEMAKER IN AFT GALLEY IAW AMM 25-00-05, 25-00-23, 20-10-01, PN CDSP2200-11 SPLIT JOINT BRACKET.SDR R61A201403300515Support Bracket · crackedDURING HEAVY CHECK, RT RAM AIR DUCT SUPPORT BRACKET IS CRACKED. MX R & R RT RAM AIR DUCT SUPPORT BRACKET IAW SRM 51-40-00, PN 171-06435-401, SUPPORT BRACKET.SDR UHLA2014031300224Arming Lever · out of adjustL2 DOOR DOESN`T OPEN OR CLOSE PROPERLY. ADJUSTED AND OPS CHECKED L2 DOOR DISARMING MECHANISM IAW AMM 52-12-20.SDR R61A201403100358Battery Pack · inoperativeCREW REPORTED THAT THE CAPTAINS FLASHLIGHT DOES NOT WORK. MAINTENANCE R & R CAPTAINS FLASHLIGHT BATTERIES IAW AMM AND OPS CHECKED GOOD.SDR R61A201403100357Light · unsecureCREW REPORTED THAT THE EMERGENCY LIGHT WAS MISSING AT SEAT 6AC AND 4DF. MAINTENANCE FOUND LIGHT HAD SLID UNDER ITSELF, SECURED LIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201403020355Tube · corrodedDURING HEAVY CHECK, RT WING FUEL TUBE INSIDE PANEL 631EB IS CORRODED. MX R & R RT WING FUEL TUBE IAW AMM 20-10-03, PN 170-06041-403 TUBE.SDR R61A201403020351Tube · corrodedDURING HEAVY CHECK, RT WING FUEL PANEL 621AB HAS FUEL TUBE CORRODED. MX R & R FUEL TUBE IAW AMM 20-10-03.SDR R61A201403020350Tube · corrodedDURING HEAVY CHECK, RT WING FUEL TUBE INSIDE PANEL 621EB FOUND CORRODED. MX R & R RT WING FUEL TUBE INSIDE PANEL IAW AMM 20-10-03.SDR R61A201403020349Tube · corrodedDURING HEAVY CHECK, RT WING FUEL TUBE INSIDE PANEL 621BB IS CORRODED. MX R & R RT WING FUEL TUBE INSIDE PANEL 621BB IAW AMM 20-10-13.SDR R61A201403020348Tube · corrodedDURING HEAVY CHECK, RT WING, THREE FUEL TUBES INSIDE FUEL PANEL 631AB ARE CORRODED. MX R & R RT WING 3 EACH, FUEL TUBES INSIDE FUEL PANEL 631AB IAW AMM 20-10-13, 20-10-01.SDR R61A201403020347Clamp · corrodedDURING HEAVY CHECK, LT WING 3 FUEL TUBES CLAMPS INSIDE PANEL 521AB HAVE CORROSION. MX R & R LT WING 3 FUEL TUBES CLAMPS INSIDE PANEL 521AB IAW AMM 20-10-13, R & R CONNECTING FUEL TUBES, PN 170-08807-401, 170-08806-403, 170-06026-401 IAW AMM 20-10-03.SDR R61A201403020346Clamp · corrodedDURING HEAVY CHECK, LT WING 4 FUEL TUBES CLAMPS INSIDE PANEL 521BB HAVE CORROSION. MX R & R LT WING 4 FUEL TUBES CLAMPS INSIDE PANEL 521BB IAW AMM 20-10-13, R & R CONNECTING FUEL TUBES, PN 170-06027-401, 170-06024-401, 170-06025-401 IAW AMM 20-10-03. PN 170SDR R61A201403020345Clamp · corrodedDURING HEAVY CHECK, LT WING PANEL 521DB 5 FUEL TUBE CLAMPS HAVE CORROSION. MAINTENANCE R & R LT WING PANEL 521DB 5 FUEL TUBE CLAMPS IAW AMM 170 20-10-13. R & R CONNECTIONG FUEL TUBES.SDR R61A201403020344Tube · corrodedDURING HEAVY CHECK, LT WING FUEL TUBE AND CLAMP LOCATED FUEL PANEL 521EB HAVE CORROSION. MAINTENANCE R & R LT WING FUEL TUBE AND CLAMP IAW AMM 20-10-13. R & R CONNECTION FUEL TUBES, PN 170-06022-401 IAW AMM 20-10-03, PN 170-06022-401.SDR R61A201403020343Clamp · corrodedDURING HEAVY CHECK, LT WING FUEL PANEL 531AB, FUEL TUBE CLAMP HAVE CORROSION. MX R & R LT WING FUEL PANEL 531AB FUEL TUBE CLAMP IAW AMM 20-10-13. R & R CONNECTION FUEL TUBES, PN 170-06037-401 IAW AMM 20-10-03, PN 170-06037-401 TUBE.SDR R61A201403020342Clamp · corrodedDURING HEAVY CHECK, LEFT WING FUEL TUBE CLAMP UNDER WING PANEL 531BB IS CORRODED. MX R & R CLAMP IAW AMM 20-10-13.SDR R61A201403020341Clamp · corrodedDURING HEAVY CHECK, LT WING FUEL TUBE CLAMP UNDER PANEL 531EB IS CORRODED. MX R & R LT WING FUEL TUBE CLAMP UNDER PANEL 531EB IAW AMM 20-10-13. PN 14C16-24A, CLAMP.SDR R61A201403010340Rib · crackedDURING HEAVY CHECK, FWD FLANGE ON RT HORIZONTAL STABILIZER, RIB 11A IS CRACKED AT LAST RIVET. MX REPAIRED CRACKED RIB 11A FWD LOWER FLANGE IAW ETD 2014-170-017791, REV A DATED MARCH 7,2014 SEE CONTINUATION CARDS C1,C2 FOR ALL WORK PERFORMED ISSUED DMI 467748/SDR R61A201402280354Bolt · corrodedDURING HEAVY CHECK WAS REPORTED THAT L1 DOOR STOPS HARDWARE IS CORRODED. MX R & R L1 DOOR STOPS HARDWARE IAW AMM 52-11-23. PN PE20194-4010A, BOLT.SDR R61A201402280324Light · unsecureCREW REPORTED THAT THE EMERGENCY LIGHT NEAR ENTRANCE IS UNGLUED. MAINTENANCE SECURED LIGHT STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201402270352Rib · crackedDURING HEAVY CHECK, LT HORIZONTAL STAB L/E SECOND AND THIRD INBD RIBS HAVE CRACKS. MX REWORKED LT HORIZONTAL STAB L/E RIBS IAW ETD 2014-170-015280.SDR R61A201402270335Bracket · crackedDURING HEAVY CHECK, STEERING MANIFOLD BRACKET IN NLG WELL IS CRACKED. MX R & R STEERING MANIFOLD BRACKET IN NLG WELL IAW SRM 51-40-02,51-43-03,SDR R61A201402250313Strap · corrodedDURING HEAVY CHECK, WATER BOX STRAPS FOUND CORRODED. MX REMOVED STRAPS TO COMPLY WITH SB 170-53-0095 REFER TO NR VP-005111-2014/417 FOR WORK DETAILS.SDR R61A201402240315Bolt · corrodedDURING HEAVY CHECK, ATTACHING HARDWARE ON AFT SERVICE DOOR FITTINGS ARE CORRODED. MAINTENANCE R & R ATTACHING HARDWARE ON AFT SERVICE DOOR FITTINGS IAW AMM 54-42-23.SDR R61A201402240298Tube · corrodedDURING HEAVY CHECK RT WING INSIDE FUEL PANEL, 631AB, FUEL TUBE SHOWS SIGNS OF SURFACE DEGRADATION. R & R FUEL TUBE IAW AMM 20-10-13.SDR R61A201402240297Tube · corrodedHEAVY CHECK, RT WING INSIDE FUEL PANEL 631AB FUEL TUBE SHOWS SIGNS OF SURFACE DEGRADATION. MX R & R FUEL TUBE IAW AMM 20-10-13.SDR R61A201402240296Tube · corrodedDURING HEAVY CHECK, RT WING INSIDE FUEL PANEL 631AB FUEL TUBE SHOW SIGNS OF SURFACE DEGRADATION AT CONNECTION POINTS. MX R & R RT WING INSIDE FUEL PANEL FUEL TUBE IAW AMM 20-10-13,SDR R61A201402240295Tube · corrodedDURING HEAVY CHECK, INSIDE RT WING FUEL PANEL 621BB FUEL VENT TUBE SHOW SIGNS OF SURFACE DEGRADATION. MAINTENANCE R & R RT WING FUEL PANEL 621BB FUEL VENT TUBE IAW AMM 20-10-13.SDR R61A201402240294Tube · corrodedDURING HEAVY CHECK, RT FUEL PANEL 621AB FUEL VENT TUBE SHOW SIGNS OF SURFACE DEGRADATION AT CONNECTION POINTS. MX R & R RT FUEL PANEL 621AB FUEL VENT TUBE, PN 170-09947-401 IAW AMM 20-10-13.SDR R61A201402370336Tube · corrodedDURING HEAVY CHECK, LT WING INSIDE ACCESS PANEL 521AB FUEL VENT TUBE, SHOWS SIGNS OF DEGRADATION AT CONNECTION POINT. MX R & R LT WING FUEL VENT TUBE IAW AMM 20-10-13,20-10-03, 20-13-21.SDR R61A201402230319Clamp · corrodedDURING HEAVY CHECK, FOUND RT WING FUEL LINE HAS TWO CLAMPS UNDER FUEL PANEL 621DB TO HAVE CORROSION. MX R & RCLAMPS IAW AMM 20-10-13.SDR R61A201402230318Clamp · corrodedDURING HEAVY CHECK, FOUND RT WING FUEL LINE CLAMP UNDER FUEL PANEL 621EB HAS CORROSION. MX R & R CLAMP IAW AMM 20-10-13.SDR R61A201402230317Clamp · corrodedDURING HEAVY CHECK, FOUND RT WING FUEL LINE HAS FOUR CLAMPS UNDER FUEL PANEL 631AB TO HAVE CORROSION. MX R & R CLAMPS IAW AMM 20-10-13.SDR R61A201402230316Coupling · corrodedDURING HEAVY CHECK, FOUND RT WING FUEL LINE CLAMP HAS CORROSION UNDER FUEL PANEL 631BB. MX R & R CLAMP IAW AMM 20-10-13.SDR R61A201402230314Threshold · corrodedDURING HEAVY CHECK, FOUND R2 DOOR CUT OUT LOWER THRESHOLD AROUND GIRT BAR FITTING DRAIN CUP FASTENERS ARE CORRODED. MAINTENANCE COMPLETED ETD 2014-170-015964 ON R2 DOOR CUT OUT THRESHOLD FOR WORK ACCOMPLISHED CONTINUATION CARD VP-005111-2014/342 C1,C2.SDR R61A201402230311Beam · corrodedDURING HEAVY CHECK, L2 DOOR CUTOUT LOWER THRESHOLD AROUND GIRT BAR FITTING DRAIN CUP FASTENERS HAVE CORROSION. MX R & R L2 DOOR CUT OUT LOWER THRESHOLD IAW SRM 51-40-02 PAINTED AREA IAW SRM 51-23-055,51-23-06, CONTINUATION CARDS VP-005111-2014/341 C1,C2,C3 FOSDR R61A201402230299Clamp · corrodedDURING HEAVY CHECK, RT WING VENT LINE CLAMP UNDER RT FUEL PANEL 621AB HAS CORROSION. R & R CLAMP IAW AMM 20-10-13.SDR R61A201402230291Line · corrodedDURING HEAVY CHECK, RT WING FUEL LINE UNDER PANEL 621BB CLAMP HAS CORROSION. MX R & R RIGHT WING FUEL LINE IAW AMM 200-10-13.
Back to Embraer ERJ 170-100SU