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 R61A201307300682Seal · dirtyCREW REPORTED THAT THE L2 DOOR WAS MAKING A VERY LOUD NOISE DURING FLIGHT. AN EMERGENCY WAS NOT DECLARED AND LANDED WITHOUT INCIDENT. MX INSPECTED L2 DOOR SEAL, VENT FLAP SEAL AND CLEANED DEBRIS FROM L2 DOOR SEAL IAW AMM. ACFT IS GOOD FOR SERVICE.SDR R61A201307290680Unknown · unknownCREW REPORTED A LOUD HUMMING NOISE COMING FROM ABOVE THE R1 DOOR SEAL AT HIGH SPEED. DID NOT DECLARE AN EMERGENCY AND LANDED WITHOUT INCIDENT. MX INSPECTED R1 DOOR SEAL IAW AMM, LUBRICATED AND FOUND NO DEFECTS. ACFT IS GOOD FOR SERVICE.SDR R61A201307250655Unknown · unknownL2 DOOR WAS MAKING NOISE IN CRUISE AND ON DESCENT. MX INSPECTED L2 DOOR SEAL AND DEFLECTOR IAW AMM AND NO DEFECTS NOTED. ACFT IS GOOD FOR SERVICE.SDR R61A201307230653Glowstrip · looseCREW REPORTED THAT THE PHOTO LUMINESCENT STRIP JUST AFT OF THE FRONT GALLEY IS LOOSE. MX REINSTALLED PHOTO LUMINESCENT STRIP IAW AMM AND OPS CHECKED GOOD.SDR UHLA2013072200367Unknown · odorSTRONG ODOR DURING TAKEOFF AND CLIMB. RAN ENGINE 1 AND 2 WITH CREW, OPS CHECKED GOOD IAW AMM 21-51-00. NO DEFECTS NOTED, NO ODOR NOTED.SDR R61A201307220652Indicator · out of adjustCREW REPORTED THAT THE R2 DISARM FLAG DOES NOT LINE UP IN THE WINDOW. MX ADJUSTED R2 DOOR ARM/DISARM INDICATOR IAW AMM AND OPS CHECKED GOOD.SDR R61A201307150634Stringer · damagedFOUND STRINGER 11R DAMAGED BETWEEN FRAMES 94-95. MX REPAIRED DAMAGE TO STRINGER IAW TI-170-13-054, REV "B".SDR R61A201307140631Bolt · corrodedDURING HEAVY CHECK, FOUND RT MLG SIDE STAY ATTACHMENT BOLT HAS CORROSION. MX COMPLIED WITH RT MLG SIDE STAY ATTACH BOLT MOD IAW R170EO-32-11-0001.SDR R61A201307100592Girt Bar · dirtyCREW REPORTED THAT THE R2 DOOR WAS HARD TO ARM AND THE GIRT BAR WAS NOT SHOWING ARMED. ACFT RETURNED TO GATE WHERE MX FOUND DEBRIS IN THE GIRT BAR. MX CLEANED GIRT BAR AND REMOVED DEBRIS IAW AMM AND OPS CHECKED GOOD.SDR R61A201307080587Glowstrip · looseCREW REPORTED THAT THE PHOTO LUMINESCENT STRIP AT ROW 1 IS PEELING UP. MX RESECURED PHOTO LUMINESCENT STRIP IAW AMM AND OPS CHECKED GOOD.SDR UHLA2013070700302Finger Doubler · corrodedCORROSION ON FWD CARGO BAY FWD FINGER DOUBLER IN NUMEROUS AREAS. R & R FWD CARGO FWD FINGER DOUBLER.SDR UHLA2013070600309Girt Bar · misinstalledL2 DOOR GIRT BAR INDICATION (LOWER LT CORNER) INTERMITTENT. CORRECTLY INSTALLED GIRT BAR FOR L2 DOOR IAW AMM 52-12-51. OPS CHECKED GOOD.SDR R61A201307060619Rib · crackedDURING HEAVY CHECK, FOUND LT RIB 11 FWD LOWER FLANGE CRACKED AT AFT FASTENER. MX REMOVED DAMAGED FLANGE AND INSTALLED FABRICATED RIB IAW ETD2013-170-014268, REV 1.SDR R61A201307060617Rib · crackedWHILE ACFT WAS IN FOR HEAVY CHECK FOUND LT HORIZONTAL STAB RIB 11A IS ALSO CRACKED AT FWD UPPER AND AFT UPPER FLANGES. MX REPAIRED RIB 11A BY CUTTING CRACKED FLANGES AND INSTALLING FABRICATED REPAIR FLANGES IAW ETD2013-170-014268, REV 1.SDR R61A201307060584Window · out of positionCREW REPORTED THAT THE R2 DOOR ARM/DISARM INDICATOR IS NOT SHOWING IN THE WINDOW. ACFT RETURNED TO GATE. MX REPOSITIONED ARM VIEWING WINDOW IAW AMM. ACFT OK FOR SERVICE.SDR R61A201307040581Structure · corrodedDURING HEAVY CHECK, FOUND CORROSION ON FWD CARGO CUT OUT LOWER HORIZONTAL BEAM FWD AND AFT CORNER SEAL REST NUT PLATES. MX R & R FWD AND AFT CORNER SEAL REST IAW SRM 51-40-02 AND INSTALLED ON R170-53-21-009-0002.SDR R61A201307030630Rod End · corrodedDURING HEAVY CHECK, FOUND SURFACE CORROSION ON HORIZONAL STAB RT LOWER ADJUSTMENT ROD END. MX REMOVED AND REPLACED THE ROD END IAW AMM 53-30-21. PN M81935/2-12KL.SDR R61A201307020569Glowstrip · looseCREW REPORTED THAT THE PHOTO LUMINESCENT STRIP NEAR THE FWD GALLEY CAME LOOSE. MX REINSTALLED PHOTO LUMINESCENT STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201307010628Access Panel · corrodedDURING HEAVY CHECK, FOUND FUSELAGE WASTE SERVICE ACCESS PANEL 152AR APPEARED TO HAVE CORROSION ON FWD LT SIDE. MX REPLACED ACCESS PANEL 152AR IAW AMM 53-03-60.SDR R61A201307010627Module · corrodedDURING HEAVY CHECK, TWO TRANSISTORS SHOW SIGNS OF CORROSION ON DC POWER MODULE SLOT 7 OF SPDA 1. MX R & R SPDA 1 DC POWER MODULE SLOT 7. OPS CHECKED GOOD. IAW AMM 24-61-13-400-801-A/400.SDR R61A201307050610Retainer · corrodedWHILE ACFT WAS IN FOR HEAVY CHECK, FOUND POTABLE WATER BOX RETAINERS CORRODED. MX COMPLIED WITH SB 170-53-0095. WATER BOX, PN 170-85093-403. ACFT REMAINS IN FOR COMPLETION.SDR R61A201307010595Structure · corrodedDURING HEAVY CHECK, FOUND WASTE BOX CORRODED AT WASTE HOSE CONNECTION. MX R & R WASTE BOX AND DOME FASTNERS IAW SRM 51-40-02, 51-21-05 AND SB 170-53-0095.SDR R61A201307010582Bolt · corrodedDURING HEAVY CHECK, FOUND CORRODED HARDWARE AT BOTTOM FWD SLIDE HOOK. MX R & R CORRODED HARDWARE ON BOTTOM FWD SIDE HOOK OF R2 DOOR IAW AMM 20-10-01,SDR R61A201307010580Bolt · corrodedDURING HEAVY CHECK, FOUND AFT PAX DOOR EVACUATION SLIDE LOWER ATTACH MOUNT HARDWARE CORRODED. MX R & R HARDWARE IAW AMM 20-10-01.SDR R61A201306300578Bracket · crackedDURING HEAVY CHECK, FOUND BRACKET FOR DUCT WORK TO INLET LT PACK ACM HAS A ONE INCH CRACK. MX R &R BRACKET FOR THE DUCT WORK TO INLET LT PACK IAW SRM 51-41-01.SDR UHLA2013006290303Finger Doubler · corrodedCORROSION ON FWD CARGO AFT FINGER DOUBLER. R & R FWD CARGO AFT FINGER DOUBLER.SDR R61A201306290629Spar · damagedDURING HEAVY CHECK, FOUND LOOSE HYD LINE FITTING HAS CAUSED DAMAGE TO THE FWD SIDE OF AFT SPAR 3 ON RT WING INSIDE PANEL 622DB. MX REAMED HOLE TO 35 MM, FABRICATED REPAIR BUSHING IAW ETD 170-014321, REV B.SDR R61A201306290621Spar · damagedDURING HEAVY CHECK, FOUND HYD SYSTEM 1 PRESSURE LINE ON LT WING IS LOOSE AND CAUSING DAMAGE TO SPAR 3 FWD FACE. MX REAMED AFFECTED HOLE, FABRICATED AND INSTALLED REPAIR BUSHING IAW ETD 2013-170-014321, REV A AND B DATED 7-12-13SDR R61A201306290626Nut · corrodedDURING HEAVY CHECK, FOUND L1 DOOR LOWER AFT DOOR STOP JAM NUT RUSTED. MX R & R JAM NUT IAW AMM 52-11-23.SDR R61A201306290624Nut · corrodedDURING HEAVY CHECK, FOUND L1 DOOR SECOND FROM BOTTOM FWD DOOR STOP JAM NUT RUSTED. MX R & R JAM NUT IAW AMM 52-11-23.SDR R61A201306290620Rib · crackedDURING HEAVY CHECK, FOUND RT RIB 10 CRACKED FWD AND AFT FROM UPPER FASTNER THIRD FROM AFT END. MX R & R RIB 10 IAW SRM 51-40-02, 51-43-04, 51-43-03 AND SRM 51-21-05.SDR UHLA2013062900290Floorboard · corrodedCORROSION ON AFT CARGO CUTOUT FLOORBOARD. R & R AFT CARGO FLOORBOARD.SDR UHLA2013062800304Nut Plate · corrodedCORROSION ON TIE DOWN NUT PLATE FITTING UNDER LT SHEAR PLATE. BLENDED CORROSION, REPAIRED FITTING. MAJOR REPAIR.SDR UHLA2013062800302Upper Sheet · corrodedCORROSION ON UPPER SHEET RT FR85. R & R UPPER SHEET.SDR UHLA2013062800301Splice · corrodedCORROSION ON CENTER SPLICE PLATE FR90. R & R CENTER SPLICE PLATE.SDR UHLA2013062800300Gusset · corrodedCORROSION ON GUSSETT PLATE LT CENTER FR91. R & R LT GUSSET.SDR UHLA2013062800296Seat Track · corrodedCORROSION ON SEAT TRACK LT FR 84, R & R CORRODED SECTION OF SEAT TRACK.SDR UHLA2013062800295Upper Sheet · corrodedCORROSION ON UPPER SHEET LT BETWEEN FR85 AND 86. R & R UPPER SHEET.SDR UHLA2013062800294Seat Track · corrodedCORROSION ON SEAT TRACK FR 84. R & R SEAT TRACK FROM FR84 TO FR80.SDR UHLA2013062800293Beam · corrodedCORROSION ON BEAM LT FR87 AND 89 AROUND SCREW HOLES. R & T BEAM FROM FR87 TO 89.SDR UHLA2013062800292Plate · corrodedCORROSION ON CENTER SHEAR PLATE FR87/88. R & R CENTER SHEAR PLATE.SDR UHLA2013062800291Floor Support · corrodedCORROSION ON RT FLOOR SUPPORT AT FR84. R & R FLOOR SUPPORT.SDR UHLA2013062800288Splice · corrodedCORROSION ON RT CENTER SPLICE PLATE FR90. R & R RT CENTER SPLICE PLATE.SDR UHLA2013062800287Floorbeam · corrodedCORROSION AT FLOORBEAM RT FR 87. R & R FLOORBEAM.SDR UHLA2013062800286Floor Support · corrodedCORROSION ON RT FLOOR SUPPORT. R & R FLOOR SUPPORT.SDR UHLA2013062800285Floor Support · corrodedCORROSION ON LT FLOOR SUPPORT FRAMES 88-90. R & R SUPPORT.SDR UHLA201306/280028Shear Plate · corrodedCORROSION ON RT SHEAR PLATE TO INCLUDE SPLICE PLATE FR87/88. R & R RT SHEAR PLATE.SDR R61A201306270579Pan · crackedDURING HEAVY CHECK, FOUND SEAT PANS CRACKED AT SEATS 4A, 11CAF, 12FD, 14FD, AND 15D. MX R & R CRACKED SEAT PANS IAW SRM 51-42-02.SDR R61A201306250556I/O Module · inoperativeCREW REPORTED AN EMERGENCY LIGHT BATTERY FAULT. ACFT WAS FLOWN VIA MX FERRY FOR TROUBLESHOOTING. MX FOUND THE GENERIC I/O MODULE HAD FAILED, R & R IAW AMM. ACFT OPS CHECKED GOOD.SDR R61A201306220633Frame · damagedFRAME 95 DAMAGED BETWEEN STRINGERS 11R AND 12R. MX REPAIRED, FABRACATED AND INSTALLED REPAIR IAW TI-170-13-054 REV "B".
Back to Embraer ERJ 170-100SU