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 UHLA2014060200411Threshold · corrodedCORROSION FOUND AROUND RIVET HEADS ON L2 DOOR THRESHOLD. R & R THRESHOLD. MAJOR REPAIR.SDR UHLA2014060200410Crossbeam · corrodedCORROSION FOUND ON CROSSBEAM AT FRAME 84. INSTALLED ANGLE REPAIR ON CENTER SECTION OF CROSSFRAME. MAJOR REPAIR.SDR UHLA2014060200409Crossbeam · corrodedCORROSION FOUND ON CROSSBEAM AT FRAME 84. INSTALLED ANGLE REPAIR ON CENTER SECTION OF CROSSBEAM. MAJOR REPAIR.SDR UHLA2014060200408Shear Plate · corrodedCORROSION FOUND ON RT SHEAR PLATE SPLICE FRAMES 87-88. R & R SHEAR PLATE SPLICE.SDR UHLA2014060200407Shear Plate · corrodedCORROSION FOUND ON LT SHEAR PLATE FRAMES 87-88. R & R SHEAR PLATE.SDR UHLA2014060200406Upper Sheet · corrodedCORROSION FOUND ON RT UPPER SHEET FRAMES 85-86. R & R UPPER SHEET.SDR UHLA2014060200405Shear Plate · corrodedCORROSION FOUND ON LT SHEAR PLATE FRAMES 87-88. R & R SHEAR PLATE.SDR UHLA2014060200404Seat Track · corrodedCORROSION FOUND ON LEFT SEAT TRACK AT FRAME 84. REPAIRED SEAT TRACK IAW ETD2014-170-042950, MAJOR REPAIR.SDR R61A201405290731Stiffener · crackedDURING HEAVY CHECK, RT PYLON STIFFENER ON OTBD SIDE CRACKED, MX R & R STIFFENER IAW SRM 51-43-02, 51-41-02.SDR UHLA2014052900396Handle · dirtyL2 DOOR INDICATOR FOR ESCAPE SLIDE ARM-DISARM IS NOT STAYING IN VIEWING WINDOW FOR ARMED INDICATION. GVI OF L2 DOOR, FOUND DIRT. CLEANED AND CYCLED DOOR ARM/DISARMED HANDLE IAW AMM 52-12-00. OPS CHECK GOOD.SDR R61A201405280736Structure · corrodedDURING HEAVY CHECK, AREA BETWEEN FWD AND AFT SECTION OF GALLEY HAS CORROSION. MX R & R ALL CORRODED PIECES ON AFT GALLEY WHERE 2 HALVES MEET IAW AMM 25-00-23, 25-00-05, P/N 170-59522-001, TRIM.SDR R61A201405270732Door Frame · gougedDURING HEAVY CHECK, FWD SERVICE DOOR AFT OF FRAME 17 AFT DOOR FRAME GOUGED. MAINTENANCE R & R IAW SRM 51-41-02.SDR R61A201405270725Leaf Spring · corrodedDURING HEAVY CHECK LEAF SPRING AND NUT R1 DOOR NR 4 FWD STOP FITTING AND NUT NR 3 FWD STOP FITTING ARE CORRODED. MX R & R LEAF SPRING AND NUT R1 DOOR NR 4 FWD STOP FITTING AND NUT NR 3 FWD STOP FITTING IAW AMM 52-41-23.SDR R61A201405270724Nut · corrodedDURING HEAVY CHECK, L1 DOOR STOP SCREW NUT ON DOOR STOP FITTINGS NR 3, & 4 SHOW SIGNS OF CORROSION. MX R & R L1 DOOR STOP SCREW NUT ON DOOR STOP FITTING IAW AMM 20-10-02.SDR R61A201405270710Clamp · corrodedDURING HEAVY CHECK, FOUND BETWEEN RIBS 1 AND 2 LT AND RT HORIZONAL STAB THERE ARE SEVERAL HARNESS ADEL CLAMPS AND HARDWARE CORRODED. MX R & R ADEL CLAMPS AND HARDWARE BETWEEN RIBS 1 AND 2 LT AND RT HORIZONAL STABILIZER IAW AMM 20-10-01.SDR R61A201405270708Spring · corrodedDURING HEAVY CHECK, FOUND LEAF SPRING AND NUT AT NR 3 AND 4 FWD STOP FITTING ON R1 DOOR CORRODED. MX R & R LEAF SPRINGS IAW AMM 52-11-23.SDR R61A201405270707Stop · corrodedDURING HEAVY CHECK, FOUND THE LOWEST TWO DOOR STOPS ON FWD SERVICE DOOR FWD EDGE CORRODED. MAINTENANCE R & R DOOR STOPS HARDWARE IAW AMM 52-41-23.SDR R61A201405270706Clamp · corrodedDURING HEAVY CHECK, FOUND CORROSION BETWEEN HORZIONAL STAB LT AND RT RIBS 1 & 2 THERE ARE SEVERAL HYDRAULIC LINE CLAMPS AND HARDWARE CORRODED. MAINTENANCE R & R ADEL CLAMPS AND HARDWARE IAW AMM 20-10-01, PN PE2701RE6E.SDR R61A201405270696Proximity Sensor · out of adjustPASSING THRU FL 200, CREW RECEIVED A FWD PASSENGER DOOR OPEN MESSAGE. RAN QRH AND PRESSURIZATION REMAINED NORMAL. AN EMERGENCY WAS NOT DECLARED AND LANDED WITHOUT INCIDENT. MAINTENANCE ADJUSTED L1 DOOR LATCH PROX SENSOR IAW AMM AND OPS CHECKED GOOD. ACFT SDR R61A201405260734Panel · crackedDURING HEAVY CHECK, PANEL 351BZ CORNERS ARE CRACKED. MAINTENANCE TRIMED OUT DAMAGE WITH NO REINENFORCEMENT INSTALLATION ON PANEL 351BZ, HFEC NO CRACKS NOTED IAW SRM 53-31-21.SDR R61A201405260733Support · corrodedDURING HEAVY CHECK, LT WING NR 3 MIDDLE FLAP TRACK SUPPORT FWD ATTACHMENT TO WING HARDWARE IS CORRODED. MX R & R LT WING 3 MIDDLE FLAP TRACK SUPPORT FWD ATTACHMENT TO WING HARDWARE IAW AMM 57-57-31.SDR R61A201405260731Bolt · corrodedDURING HEAVY CHECK, RT WING SPOILER ACTUATORS NR 4, & 5 INBD AND OTBD HARDWARE IS CORRODED. MX R & R HARDWARE IAW AMM 27-65-01.SDR R61A201405260730Bolt · corrodedDURING HEAVY CHECK, LT WING SPOILER ACTUATORS NR 4, & 5 INBD-OTBD HARWARE IS CORRODED. MX R & R LT WING SPOILER ACTUATOR HARWARE IAW AMM 27-65-01. PN NAS6121-31D, BOLT.SDR R61A201405260727Door · corrodedDURING HEAVY CHECK, WASTE WATER DOOR INSIDE HAS CORROSION. MX R & R WASTE WATER DOOR IAW AMM 53-03-60. PN 170-86668-403 PANEL.SDR R61A201405260709Washer · corrodedDURING HEAVY CHECK FOUND RT WING NR 3 MIDDLE, FLAP TRACK SUPPORT FWD ATTACHMENT TO WING HARDWARE CORRODED. MX R & R RT WING NR 3, MIDDLE, FLAP TRACK SUPPORT FWD ATTACHMENT TO WING HARDWARE, PN 170-18284-001, MS24665-319, MS14145L8 IAW AMM 57-57-31.SDR R61A201405250737Rib · crackedDURING HEAVY CHECK, RT HORIZONTAL STAB L/E HAS RIB ON INBD SIDE CRACKED. MX CUT OUT DAMAGE INSTALLED FILLER AND DOUBLER IAW ETD 2014-170-045417.SDR R61A201405250729Rib · crackedDURING HEAVY CHECK, INBD RIB OF LT L/E OF HORIZONTAL STAB IS CRACKED. MAINTENANCE REMOVED DAMAGED SECTION OF RIB FABRICATED AND INSTALLED.SDR R61A201405250728Bracket · crackedDURING HEAVY CHECK BRACKET ON FUSELAGE PANEL 195ER IS CRACKED. MX R & R BRACKET ON FUSELAGE PANEL 195ER IAW SRM 51-41-01, PN 170-15840-003 PROFILE.SDR R61A201405250726Bracket · corrodedDURING HEAVY CHECK, AFT LAV TOILET BOWL MOUNTING BRACKET AND HARDWARE IS CORRODED. MX R & R AFT LAV TOILET BOWL MOUNTING BRACKET AND HARDWARE IAW CMM 25-42-03, PN 170-43685-001 DOUBLER.SDR R61A201405230716Stiffener · crackedDURING HEAVY CHECK, LT ENGINE AFT PYLON INBD STIFFENER IS CRACKED. MX R & R STIFFENER IAW SRM 51-42-01.SDR R61A201405230684Screw · corrodedDURING HEAVY CHECK, RT WING ABOVE AFT ENGINE PYLON FIRE EXTINGUISHING LINE ADEL CLAMP HARDWARE IS CORRODED. MX R & R RT WING ABOVE AFT ENGINE PYLON FIRE EXTINGUISHING LINE ADEL CLAMP HARDWARE IAW AMM 20-10-3, PN NAS1801-08-8 SCREW.SDR R61A201405220685Nut · corrodedDURING HEAVY CHECK, LT WING TRACK SUPPORT NR 4 FORWARD ATTACHMENT TO WING FLAP FAIRING HARDWARE IS CORODED. MX R & R LT WING TRACK SUPPORT NR 4 FORWARD ATTACHMENT TO WING FLAP FAIRING HARDWARE IAW AMM 170 57-57-31, PN MS14145L8, NUT.SDR R61A201405220683Firewall · crackedDURING HEAVY CHECK, APU FIRE WALL PANEL 351BZ FOUND CRACKED. MAINTENANCE REMOVED DAMAGE AREA IAW SRM 53-31-21.SDR UHLA2014060600454Crossbeam · corrodedCORROSION FOUND ON CROSSBEAM A FRAME 14 AND Y=+10.748. REMOVED CORROSION, REPAIRED CROSSBEAM IAW ETD2014-170-042963. MAJOR REPAIRSDR UHLA2014060600453Crossbeam · corrodedCORROSION FOUND ON CROSSBEAM FRAME 17 Y=+10.748. REMOVED CORROSION, REPAIRED CROSSBEAM IAW ETD2014-170-042963. MAJOR REPAIRSDR UHLA2014052000403Support · corrodedCORROSION FOUND ON BOTTOM FLANGE OF 191 TO 192 FAIRING. R & R CENTER RIB SUPPORTS, MAJOR REPAIR.SDR UHLA2014052000402Floor Support · corrodedCORROSION FOUND ON RT FWD FLOOR SUPPORT FRAMES 12-14. R & R FLOOR SUPPORT.SDR UHLA2014052000401Floor Support · corrodedCORROSION FOUND ON RT FLOOR SUPPORT FRAMES 12-20. R & R RT FLOOR SUPPORT.SDR UHLA2014052000400Floor Support · corrodedCORROSION FOUND ON FLOOR SUPPORT RT AT FRAME 86. R & R FLOOR SUPPORT.SDR UHLA2014052000399Gusset · corrodedCORROSION ON RT GUSSET PLATE FRAME 90. R & R GUSSETT.SDR R61A201405190674Flashlight · weakCREW REPORTED THAT THE AFT F/A FLASHLIGHT WAS DIM.SDR R61A201405130647Flashlight · weakCREW REPORTED THAT THE F/O FLASHLIGHT WAS VERY DIM. MAINTENANCE R & R FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201405110672Bolt · corrodedDURING HEAVY CHECK, LEFT WING INBD CANOE FAIRING 523BB BOLT BETWEEN UPPER AND LOWER PIVOT LINK IS PITTED. MX R & R LT WING INBD CANOE FAIRING 523BB BOLT BETWEEN UPPER AND LOWER PIVOT LINK IAW AMM 57-58-23, PN NAS6305-62D, BOLT.SDR R61A201405100635Bushing · damagedAT FL 260 CREW RECEIVED L1 DOOR OPEN MESSAGE, CREW RAN QRH AND MESSAGE WENT AWAY DURING DESCENT. AN EMERGENCY WAS NOT DECLARED AND LANDED WITHOUT INCIDENT. MAINTENANCE R & R GUIDE RAMP BUSHINGS IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR R61A201405080671Gland Nut · corrodedDURING HEAVY CHECK, LT MLG GLAND NUT IS CORRODED. MAINTENANCE R & R LT GEAR GLAND NUT IAW AMM 32-11-04.SDR R61A201405040661Intercostal · corrodedDURING HEAVY CHECK, FORWARD CARGO DOOR FRAME AT INTERCOASTAL BELOW O2 SERVICE PORT IS CORRODED. MX R & R FORWARD CARGO DOOR FRAME AT INTERCOASTAL, BELOW O2 SERVICE PORT IAW ETD 2014-170-039126 AND SRM 170/175 51-41-01, 53-31-00, REF CONTINUATION CARDS C1-C2 SDR R61A201405040640Rib · crackedDURING HEAVY CHECK, FOUND LT HORIZONTAL STAB RIB 12 FWD CENTER SPAR UPPER SURFACE AT 2 RIVETS 1 IS 4 BACK OFF OF FWD SPAR OTHER IS 5 BACK OFF FWD SPAR. MX REMOVED CRACKED FLANGES ON RIB 12A AND INSTALLED SHEAR CLIPS IAW ETD 2014-170-037309 FOR ALL WORK PERFOSDR R61A201405040631Support Bracket · damagedDURING HEAVY CHECK, AIR DUCT SUPPORT AT FRAME 17 STRINGER 22L-28R HAS DAMAGED AREAS MULTIPLE BENDS. MX R & R AIR DUCT SUPPORT AT FRAME 17, STRINGER 22L-28R IAW SRM 51-41-01, PN 170-97773-001 SUPPORT SMOKE PROTECTION.SDR R61A201405040630Hinge Pin · corrodedDURING HEAVY CHECK, RT & LT HORIZONTAL STAB HINGE PINS ARE CORRODED. MX R & R HINGE PINS IAW AMM 27-41-03.SDR R61A201405040629Door Sill · corrodedDURING HEAVY CHECK, FWD GALLEY DOOR SILL BETWEEN FRAMES 13-14 IS CORRODED. MX R & R SILL IAW SRM 51-41-02, 51-43-02.
Back to Embraer ERJ 170-100SU