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 R61A201402230287Bolt · corrodedDURING HEAVY CHECK, RT MLG LOWER SIDE STAY BOLT IS CORRODED. MX R & R RT MLG LOWER SIDE STAY BOLT IAW AMM 32-11-05.SDR R61A201402220339Bearing · corrodedDURING HEAVY CHECK WAS REPORTED THAT LT HORIZONTAL STABILIZERS, NR 3 BEARING IN FITTING ASSY IS CORRODED. MX R & R BEARING IAW AMM 20-10-08.SDR R61A201402220327Bolt · corrodedDURING HEAVY CHECK, AFT PASSENGER DOOR STOPS ON DOOR HARDWARE CORRODED. MAINTENANCE R & R AFT PASSENGER DOOR STOPS ON DOOR HARDWARE IAW AMM 52-12-23. PN: PE 21094-04010A, BOLT.SDR R61A201402220326Rib · crackedDURING HEAVY CHECK, RT HORIZONTAL STAB, RIB 12 BETWEEN FRONT AND MID SPAR UPPER AND LOWER FLANGES IS CRACKED. MX PERFORMED A PERMANENT REPAIR OF DAMAGED RIB 12A FLANGES ON RT HORIZONTAL STAB IAW ETD 2014-170-015568. PERMENANT REPAIR REQUIRES INSPECTION TASKSDR R61A201402220325Rib · crackedDURING HEAVY CHECK, RT HORIZONTAL STABILIZER, RIB 11 BETWEEN FRONT AND MID SPAR ON UPPER AND LOWER FLANGES CRACKED. PERFORMED A PERMANENT REPAIR OF DAMAGED RIB 11A FLANGES ON RT HORIZONTAL STAB IAW ETD 2014-170-015568. PERMANENT REPAIR REQUIRES INSPECTION TSDR R61A201402220322Rib · crackedDURING HEAVY CHECK, RT HORIZONTAL STABILIZER RIB 10 BETWEEN FRONT AND MID SPAR LOWER FLANGE IS CRACKED. MAINTENANCE REPAIRED DAMAGED RIB IAW ETD 2014-170-015568. MAJOR REPAIR.SDR R61A201402220321Rod End · corrodedDURING HEAVY CHECK, BOTH ROD ENDS ON HORIZONTAL STABS ADJUSTABLE ROD ARE CORRODED. MAINTENANCE R & R HORIZONTAL STABILIZER ADJUSTABLE ROD IAW AMM 27-41-03. PN 170-60047-901, ROD END.SDR R61A201402220320Bracket · crackedDURING HEAVY CHECK, FOUND LT ELEVATOR LVDT MOUNTING BRACKET ON ELEVATOR IS CRACKED AT BUSHING. MX R & R BRACKET IAW SRM 51-43-03.SDR R61A201402220293Floor Support · corrodedDURING HEAVY CHECK, FLOOR SUPPORT BETWEEN FRAME 90-90A CORRODED. MX R & R FLOOR SUPPORT IAW 51-40-02,51-41-01,51-41-02.SDR R61A201402210330Bolt · corrodedDURING HEAVY CHECK, AFT SERVICE DOOR HARDWARE ON DOOR STOPS AND FRAME FOUND CORRODED. MX R & R AFT SERVICE DOOR HARDWARE ON DOOR STOPS AND FRAME IAW AMM 52-23-25.SDR R61A201402210329Dampener · corrodedDURING HEAVY CHECK, L2 DOOR DAMPENER FOUND CORRODED. MAINTENANCE R & R L2 DOOR DAMPENER IAW AMM 52-12-27.SDR R61A201402210328Seal Seat · corrodedDURING HEAVY CHECK, FWD CARGO DOOR CUT OUT AFT LOWER DOOR REST SEAL IS CORRODED. MAINTENANCE R & R FWD CARGO DOOR CUT OUT AFT LOWER DOOR REST SEAL IAW AMM 53-21-29, PN 170-66803-402, SEAL REST.SDR R61A201402200331Fairing · damagedDURING HEAVY CHECK, LT SIDE SKIRT FAIRING AT SPLICE FOR UPPER 195 FAIRING PANEL FWD EDGE FOUND TO HAVE CRACKED AND DAMAGED RIVETS. MX REPAIRED DAMAGE SKIRT FAIRING IAW ETD 2014-170-015453.SDR R61A201402200312Rib · crackedDURING HEAVY CHECK, LT HORIZONTAL STAB L/E INBD 2 RIBS ARE CRACKED. MX REMOVED DAMAGE AND INSTALLED FILLER DOUBLERS QTY 3 IAW ETD 2014-170-015448 CONTINUATION CARDS VP-005111-2014/342 C1,C2.SDR R61A201402200310Pin · corrodedDURING HEAVY CHECK, LT WING FLAP TRACK SUPPORT 2, 3, 4 HARDWARE IS CORRODED. MX R & R LT WING FLAP TRACK SUPPORT 2, 3, 4 HARDWARE IAW AMM 57-57-31, PN 170-14217-00, PIN.SDR R61A201402200300Pin · corrodedDURING HEAVY CHECK, RT FLAP TRACK SUPPORTS 2, 3, 4, HAVE CORRODED HARDWARE. MX R & R SUPPORT HARDWARE IAW AMM 57-54-21.SDR R61A201402200292Support Bracket · crackedDURING HEAVY CHECK LT PACK SUPPORT BRACKET FWD OF LT PACK ASSY IS CRACKED. MAINTENANCE R & R SUPPORT BRACKET IAW SRM 51-40-02, & 51-41-01.SDR R61A201402200288Support Bracket · crackedDURING HEAVY CHECK, STEERING MANIFOLD BRACKET IS CRACKED IN NOSE GEAR WHEEL WELL. MAINTENANCE R & R SUPPORT IAW SRM 51-43-01.SDR R61A201402270353Beam · corrodedDURING HEAVY CHECK FOUND A SPLIT BEAM ON BACK SIDE OF AFT GALLEY ALONG COUNTER HAS CORROSION. R & R ALL CORRODED TRIM PIECES ON BOTH SECTIONS OF AFT GALLEY WHERE THE 2 HALVES MEET IAW AMM 25-0023,20-10-01,25-00-05. PN CDSP2200-11 SPLIT JOINT.SDR R61A201402070224Cradle · looseCREW REPORTED THAT THE FORWARD F/A FLASHLIGHT IS LOOSE AND KEEPS LOOSING ITS CHARGE. MAINTEANCE R & R FLASHLIGHT HOLDER IAW AMM. OPS CHECKED GOOD.SDR R61A201402060206Door · lack of lubeCREW REPORTED THAT THE L2 DOOR WAS DIFFICULT TO ARM. MAINTENANCE LUBRICATED DOOR IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR R61A201402060205Door · lack of lubeCREW REPORTED THAT THE R1 DOOR WAS DIFFICULT TO OPEN. MAINTENANCE LUBRICATED DOOR IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR R61A201402020170Light · missingCREW REPORTED THAT THE EMERGENCY LIGHT AT ROW 4 WAS MISSING. MAINTENANCE INSTALLED IAW AMM AND OPS CHECKED GOOD.SDR R61A201401300155Connector · unsecureCREW RECEIVED STEERING FAIL MESSAGE. MAINTENANCE RESET CONNECTOR TO STEERING ACTUATOR IAW AMM AND OPS CHECKED GOOD. FOUND TO BE TRANSITORY CONDITION. ACFT IS GOOD FOR SERVICE.SDR R61A201401290156Flashlight · inoperativeCREW REPORTED THAT THE FORWARD F/A FLASHLIGHT WAS INOPERATIVE.SDR R61A201401280154Steering Sys · malfunctionedCREW RECEIVED A STEERING FAIL MESSAGE. MAINTENANCE RESET THE NWS SYSTEM IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR R61A201401270144Flashlight · inoperativeCREW REPORTED THAT THE CAPTAIN`S FLASHLIGHT WAS NOT CHARGING. MAINTENANCE R & R CAPTAINS FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201401270143Steering Sys · malfunctionedAFTER LANDING, CREW RECEIVED STEER FAIL MESSAGE WHEN THEY MOVED THE TILLER. ACFT HAD TO BE TOWED OFF THE TAXIWAY AND TO GATE. MAINTENANCE RESET STEERING AND PERFORMED GVI OF GEAR IAW AMM AND NO DEFECTS WERE NOTED. ACFT IS GOOD FOR SERVICE.SDR UHLA2014012500019Switch · dirtyFWD PASSENGER DOOR OPEN INDICATION IN FLIGHT. CLEANED L1 DOOR SWITCH AND OPS CHECKED GOOD IAW 52-70-20.SDR R61A201401190117Girt Bar · corrodedDURING HEAVY CHECK, R1 SERVICE DOOR GIRT BAR END FITTING HARDWARE CORRODED. MAINTENANCE R & R FWD SERVICE DOOR R1 DOOR GIRT BAR END FITTING HARDWARE IAW EMB 170 25-65-01. PN NAS6604-14, BOLT.SDR R61A201401150116Bolt · corrodedDURING HEAVY CHECK, RT MLG SIDE STAY ATTACH BOLT CORRODED AT BOLT HOLE. MAINTENANCE R & R BOLT IAW AMM 32-11-05.SDR R61A201401150115Seal Depressor · corrodedDURING HEAVY CHECK, AFT CARGO DOOR FWD AND AFT LOWER CORNER FRAMES SEAL REST CORRODED. MAINTENANCE R & R SEAL REST IAW R170-53-23-009-0002A, NO DEFECTS NOTED.SDR R61A201401150114Bolt · corrodedDURING HEAVY CHECK, LT MLG SIDE STAY ATTACH BOLT CORRODED. MAINTENANCE R & R ATTACH BOLT IAW AMM 32-11-05.SDR R61A201401150106Seal Bracket · corrodedDURING HEAVY CHECK, AFT CARGO DOOR FWD AND AFT LOWER CORNER FRAME SEAL REST CORRODED. R & R SEAL REST .SDR R61A201401130095Wire Harness · corrodedDURING HEAVY CHECK, CONNECTOR TO LOWER RED BEACON CORRODED. FULL LENGTH OF WIRE HARNESS STEEL BRAIDING CORRODED. R & R LOWER RED BEACON WIRE HARNESS IAW SWPM 20-51-00.SDR R61A201401110113Line · corrodedDURING HEAVY CHECK, RT WING FUEL LINE, CORRODED. MX R & R FUEL LINE IAW AMM 20-10-13.SDR R61A201401110101Line · corrodedDURING HEAVY CHECK, RT WING FUEL LINE AT FUEL PANEL 621EB HAS CORROSION. MX R & R RT WING FUEL LINE IAW AMM 20-10-03, 20-10-13.SDR R61A201401110100Line · corrodedDURING HEAVY CHECK, RT WING FUEL LINE AT PANEL 621EB HAS CORROSION. MAINTENANCE R & R RT WING FUEL LINE IAW AMM 20-10-13, 20-10-03.SDR R61A201401110099Line · corrodedDURING HEAVY CHECK, RT WING FUEL LINE AT ACCESS PANEL 621BB CORRODED. MAINTENANCE R & R RT WING FUEL LINE IAW AMM 20-10-13, 20-10-03.SDR R61A201401100105Seat Track · corrodedDURING HEAVY CHECK, LT FORWARD FUSELAGE INBD SEAT TRACK AT FRAMES 19-20 HAS SIGNS OF CORROSION. R & R SEAT TRACK IAW SRM 51-40-02, 51-43-01, 51-43-02, 51-41-01.SDR R61A201401100058Dampener · corrodedDURING HEAVY CHECK, FWD PASSENGER DOOR DAMPENER HAS CORROSION ON SURFACE. MX R & R FWD PASSENGER DOOR DAMPENER.SDR R61A201401100057Dampener · corrodedDURING HEAVY CHECK, FWD SERVICE DOOR DAMPENER HAS SURFACE CORROSION. MAINTENANCE R & R FWD SERVICE DOOR DAMPENER IAW AMM 52-41-27.SDR R61A201401100056Nut · corrodedDURING HEAVY CHECK, FWD CARGO DOOR CUTOUT NR 3 LATCH FITTING HAS CORROSION ON MOUNTING NUT. MAINTENANCE R & R LATCH FITTING NUT IAW AMM 53-21-29.SDR R61A201401100055Dampener · corrodedDURING HEAVY CHECK, R2 DOOR DAMPENER IS CORRODED. MAINTENANCE R & R R2 DOOR DAMPENER IAW AMM 52-42-27.SDR R61A201401100054Dampener · corrodedDURING HEAVY CHECK, L2 DOOR DAMPENER IS CORRODED. MAINTENANCE R & R L2 DOOR DAMPENER IAW AMM 52-12-27.SDR R61A201401100053Seat Track · corrodedDURING HEAVY CHECK, LT SEAT TRACK BETWEEN FRAMES 85-86 HAS SIGNS OF CORROSION. MX R & R LT SEAT TRACK IAW SRM 51-41-02, 51-43-01.SDR R61A201401100052Seat Track · corrodedDURING HEAVY CHECK, RT SEAT TRACK HAS SIGNS OF CORROSION BETWEEN FRAMES 85-86. MX R & R RT SEAT TRACK IAW SRM 51-41-01, 51-43-01.SDR R61A201401090118Line · corrodedDURING HEAVY CHECK, LT WING FUEL LINE CORRODED. MAINTENANCE R & R FUEL LINE IAW AMM 28-23-03.SDR R61A201401090103Structure · corrodedDURING HEAVY CHECK, WASTE WATER BOX FOUND DELAMINATDED. MX R & R WASTE WATER BOX IAW SRM 51-40-02.SDR R61A201401090102Line · corrodedDURING HEAVY CHECK, RT WING FUEL LINE HAS CORROSION. MX R & R RT WING FUEL LINE IAW AMM 20-10-03, 20-10-13.
Back to Embraer ERJ 170-100SU