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 R61A201412201249Warning Message · false activationAFTER SELECTING FLAPS FROM 2 TO 3 CREW RECEIVED A FLAPS FAIL MESSAGE. CREW RAN QRH AND DECLARED AN EMERGENCY. LANDED AND TAXIED TO GATE WITHOUT INCIDENT. MAINTENANCE FOLLOWED FIM 27-51-00-810-802-A AND CLEARED INHIBITS IAW AMM AND ACFT, OPS CHECKED GOOD.SDR R61A201412191252Light · out of positionCREW REPORTED THAT THE EMERGENCY LIGHT STRIP AT ROW 14AC WAS MISSING. REPOSITIONED EMERGENCY LIGHT STRIPS THAT WERE OVERLAPPING IAW AMM AND OPS CHECKED GOOD.SDR R61A201412181248Flashlight Assy · brokenMAINTENANCE REPORTED THAT THE FORWARD F/A FLASHLIGHT HOLDER WAS BROKEN. MAINTENANCE R & R CRADLE AND FLASHLIGHT ASSY IAW AMM AND OPS CHECKED GOOD.SDR R61A201412181244Light · damagedCREW REPORTED THAT THE EMERGENCY LIGHT STRIP NEXT TO SEAT 1D WAS MISSING A PIECE. MAINTENANCE FOUND THE MISSING PIECE AND SECURED THE STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201412181243A/C Pack · odorF/A REPORTED A BURNED COFFEE ODOR IN THE AFT. CAPTAIN TURNED OFF NR 2 A/C PACK AND ODOR WENT AWAY. DID NOT DECLARE AN EMERGENCY AND LANDED WITHOUT INCIDENT.SDR R61A201412161240Flashlight · inoperativeCREW REPORTED THAT THE CAPTAIN`S FLASHLIGHT WAS INOPERATIVE. MAINTENANCE R & R THE FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201412161237Flashlight · weakCREW REPORTED THAT THE CAPTAIN`S FLASHLIGHT WAS DIM. R & R THE FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201412101235Fitting · gougedDURING C-CHECK, LT MLG UPPER SIDE BRACE FITTING CROSS SUPPORT FOUND GOUGED. MAINTENANCE R & R THE SUPPORT IAW SRM 51-43-02. MAJOR REPAIR.SDR R61A201412101230Slide · damagedCREW REPORTED THAT THE L1 DOOR WAS SHOWING BEING PARTIALLY DISARMED. MAINTENANCE INSPECTED AND FOUND THE LACES ON THE SLIDE WERE PULLED. ACFT WAS FLOWN VIA MAINTENANCE FERRY WHERE THE L1 DOOR SLIDE WAS R & R IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERSDR R61A201412071229Light · unsecureMAINTENANCE REPORTED THAT PART OF THE EMERGENCY LIGHT STRIP AT SEAT 4C WAS LOOSE. MAINTENANCE SECURED THE LIGHT STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201412051225Battery Pack · inoperativeCREW REPORTED A EMERGENCY BATTERY FAULT WHILE SITTING AT THE GATE. MAINTENANCE TROUBLESHOT TO REAR OTBD RT BATTERY. MAINTENANCE R & R BATTERY IAW AMM AND OPS CHECKED GOOD.SDR R61A201412031219Flashlight · missingCREW REPORTED THAT THE FORWARD F/A FLASHLIGHT WAS MISSING. MAINTENANCE INSTALLED NEW FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201411291215Battery Pack · inoperativeCREW REPORTED THAT THE FORWARD F/A FLASHLIGHT WAS NOT CHARGING. MAINTENANCE R & R THE FORWARD F/A FLASHLIGHT BATTERY IAW AMM AND OPS CHECKED GOOD.SDR R61A201411281212Flashlight · inoperativeCREW REPORTED THAT THE F/O FLASHLIGHT WAS NOT CHARGING. MAINTENANCE R & R F/O`S FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201411281211Bearing · leakingCREW HEARD FORWARD LAVATORY FIRE DETECTOR GOING OFF AND A FEW SECONDS LATER RECEIVED A LAV SMOKE MESSAGE. F/A CALLED AND STATED THEY COULD SEE AND SMELL SMOKE IN THE CABIN. DECLARED AN EMERGENCY AND RETURNED TO DEPARTURE AND LANDED WITHOUT INCIDENT. MAINTESDR R61A201411271210Smoke Detector · false activationCREW RECEIVED A LAVATORY SMOKE ALARM MESSAGGE. F/A CONFIRMED NO FIRE, DECLARED AN EMERGENCY AND RETURNED. LANDED WITHOUT INCIDENT. FORWARD LAVATORY SMOKE DETECTOR WAS R & R IAW AMM. OPS CHECKED GOOD.SDR R61A201411211203Battery Pack · inoperativeCREW REPORTED THAT THE F/O FLASHLIGHT WAS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY IN F/O FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201411201197Battery Pack · inoperativeMAINTENANCE REPORTED THAT THE F/O FLASHLIGHT WAS INOPERATIVE. MAINTENANCE R & R THE BATTERIES IN THE F/O FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR UHLA2014111800794Lens · crackedEXIT MARKER LENS ABOVE R1 DOOR CRACKED. R & R EXIT MARKER LENS REF AMM 33-50-17.SDR R61A201411151181Light · looseCREW REPORTED THAT THE EMERGENCY LIGHT STRIP MOVED FORWARD ON THE TRACK. REPOSITIONED THE LIGHT TO IT`S PROPER POSITION IAW AMM AND OPS CHECKED GOOD.SDR R61A201411151179Acm · odorCREW RECEIVED A LAV SMOKE MESSAGE ON EICAS. F/A REPORTED SMOKE COMING FROM THE MIDDLE OF THE CABIN WITH AN ELECTRICAL ODOR. CREW DECLARED AN EMERGENCY, RAN QRH AND RETURNED TO DEPARTURE WHERE THEY LANDED WITHOUT INCIDENT. MAINTENANCE PERFORMED GVI OF CABIN,SDR UHLA2014111300775Light · inoperativeFIRST EMERGENCY LIGHT STRIP INOPERATIVE. R & R THE LIGHT IAW AMM 33-50-21. OPS GOOD.SDR R61A201411131173Unknown · smokeCREW RECEIVED A LAVATORY SMOKE INDICATION AND F/A REPORTED A HAZE IN THE FIRST CLASS CABIN. CREW RAN LAVATORY SMOKE QRH AND SMOKE DISSIPATED. CREW RETURNED TO DEPARTURE AND LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED ACFT IAW AMM AND FOUND NO DAMAGE OR DSDR R61A201411121172Light · inoperativeCREW REPORTED THAT THREE EMERGENCY LIGHTS IN THE FWD CABIN WERE NOT FULLY ILLUMINATING. MAINTENANCE R & R IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR R61A201411101174Bulkhead · crackedDURING HEAVY CHECK, RT APU BULKHEAD 351BZ, BOTH ENDS OF ANGLE ARE CRACKED. MX REPAIRED CRACKS AND PERFORMED HFEC WITH NO CRACK LIKE INDICATIONS IAW SRM 53-31-21, REPAIR IS TYPE 1. REPAIR REQUIRES A DVI INSPECTION OF REPAIRED AREA EVERY 10000 F/C AS OF 11-10-SDR R61A201411091177Seal Rest · gougedDURING HEAVY CHECK, AFT CARGO DOOR LOWER SEAL REST HAS SEVERAL GOUGES. MAINTENANCE AFT CARGO DOOR LOWER SEAL REST IAW AMM 20-10-01. APPLIED SEALANT TO BOTH LOWER CORNERS ON SEAL REST IAW SRM 51-21-00. PN 170-85492-403, SEAL REST.SDR R61A201411091167Fastener · corrodedDURING HEAVY CHECK, 9 FASTENERS ON OTBD SIDE OF STR 28R BETWEEN FRAMES 88-89 NEXT TO WASTE BOX ARE CORRODED. MX R & R 9 FASTENERS ON OTBD SIDE OF STR 28R BETWEEN FRAMES 88-89 NEXT TO WASTE BOX IAW SRM 51-41-02.SDR R61A201411091166Shear Tie · corrodedDURING HEAVY CHECK, FRAME 88 SHEAR TIE BETWEEN 28-27 RT LOWER INBD CORNER IS CORRODED. MX R & R FRAME 88 SHEAR CLIP BETWEEN 28-27. RT LOWER INBD SHEAR CLIP, PN 170-85110-005, SHEAR CLIP IAW SRM 51-40-02, 51-41-01, 51-41-02, FCBS 53-23-00-002.SDR R61A201411081165Doubler · corrodedDURING HEAVY CHECK, INTERNAL DOUBLER AT WATER SERVICE PANEL UNDER AFT LAV FLOOR IS CORRODED. MAINTENANCE COMPLIED WITH SB R170EO-53-10-00-0020, REMOVED AND DISCARDED POTABLE WATER PANEL INTERNAL DOUBLERS.SDR R61A201411071164Trunnion · corrodedDURING HEAVY CHECK, FWD UPPER AND LOWER TRUNNION FITTINGS WORN AND PITTED. MX COMPLIED WITH ETD 2014-170-094313.SDR R61A201411061200Rib · crackedDURING HEAVY CHECK, LT MLG FWD BULKHEAD OTBD OF ARTIFICAL FEEL UNIT IS CRACKED. MX R & R LT MLG FWD BULKHEAD OTBD OF ARTIFICAL FEEL UNIT, RIB 52 PANEL, IAW SRM 51-40-02. PN 170-08669-007, RIB 52, PROFILE.SDR R61A201411061186Bracket · corrodedDURING HEAVY CHECK, AFT LAV HARDWARE ON MIDDLE AND AFT FLOOR SPLIT BOLT COUPLERS ARE CORRODED. MX R & R AFT LAV HARDWARE ON MIDDLE AND AFT FLOOR SPLIT BOLT COUPLERS IAW CMM 25-42-03, PN CDSP2200-3 BRACKET.SDR R61A201411061168Skin · damagedDURING HEAVY CHECK, TAIL CONE HAS TWO CREASES ON LT SIDE. MAINTENANCE FABRICATED AND INSTALLED REPAIR DOUBLER IAW SRM 51-31-01 AND ETD 2014-170-093789. CUTOUT SIZES FWD 3.9" X 1", AFT 6" X .9 UNDER 17.6 DOUBLER REQUIRES DAMAGE TRACKER ISSUED 1 IAW GMM 5.1SDR R61A201411051184Door · corrodedDURING HEAVY CHECK, INTERNAL SIDE OF WASTE SERVICE DOOR HAS SEVERAL AREAS OF CORROSION. MX R & R WASTE SERVICE DOOR IAW SRM 51-40-02, 51-23-06, AMM 53-03-60 REF CONTINUATION CARD FOR WORK DETAILS VP-038973/55 C1, PN 170-86668-403 PANEL.SDR R61A201411051162Screw · corrodedDURING HEAVY CHECK, WASTE SERVICE DOOR BONDING BRACKET ON FUSELAGE SIDE IS CORRODED AROUND SCREWS. MAINTENANCE R & R SCREWS IAW NE 06-001.SDR R61A201411051161Stop Fitting · corrodedDURING HEAVY CHECK, R2 DOOR STOPS 1, 2, 3, STOP HARDWARE IS CORRODED. MX R & R R2 DOOR STOPS 1, 2, 3, STOP HARDWARE IAW AMM 52-42-23, PN PE21094403006A, BOLT.SDR R61A201411041150Flashlight · inoperativeCREW REPORTED THAT THE F/O FLASHLIGHT DID HOLD A CHARGE. MAINTENANCE R & R THE FLASHLIGHT IAW AMM.SDR R61A201411021163Trunnion · corrodedDURING HEAVY CHECK, LT MLG AFT TRUNNION FITTING HAS PITTING ON OTBD SIDE. MAINTENANCE COMPLIED WITH ETD 2014-170-094313.SDR R61A201410311145Light · dimCREW REPORTED THAT THE EMERGENCY LIGHT WAS NOT PROVIDING ENOUGH LIGHT. REPLACED IAW AMM AND OPS CHECKED GOOD.SDR UHLA2014103100744Light · damagedRIGHT FIRST EMERGENCY LIGHT STRIP DAMAGED. R & R THE LIGHT IAW AMM 33-50-21.SDR UHLA2014103000743Cable · out of adjustL2 DOOR IS HARD TO DISARM. ADJUSTED DOOR FLEXBALL CABLE.SDR R61A201410291142Light · looseCREW REPORTED THAT THE EMERGENCY LIGHT STRIP AT ROW 15 WAS MISSING. MAINTENANCE LOCATED AND REPOSITIONED THE STRIP TO CORRECT POSITION AT ROW 15 IAW AMM AND OPS CHECKED GOOD.SDR R61A201410181123Flashlight · inoperativeCREW REPORTED THAT THE CAPTAIN`S FLASHLIGHT WAS INOPERATIVE. R & R THE FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201410161120Light · missingMAINTENANCE REPORTED THAT THE EMERGENCY LIGHT BY SEAT 3A WAS MISSING. MAINTENANCE INSTALLED A NEW EMERGENCY LIGHT STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201410161116Flashlight · unknownCREW REPORTED THAT THE F/A FLASHLIGHT WAS INOPERATIVE. MAINTENANCE INSPECTED IAW AMM AND OPS CHECKED GOOD.SDR R61A201410141114Battery Pack · dischargedCREW REPORTED THAT THE CAPTAIN`S FLASHLIGHT WAS DIM. MAINTENANCE R & R THE FLASHLIGHT BATTERY IAW AMM AND OPS CHECKED GOOD.SDR R61A201410121107Light · missingCREW REPORTED THAT A SECTION OF EMERGENCY LIGHT STRIP WAS MISSING. MAINTENANCE LOCATED AND RESECURED EMERGENCY LIGHT STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201410101113Screw · corrodedDURING HEAVY CHECK, WATER SERVICE PANEL HARDWARE, AND SWITCH IS CORRODED. MAINTENANCE R & R WATER SERVICE PANEL HARDWARE, SWITCH IAW AMM 20-10-01.SDR R61A201410101112Hinge · corrodedDURING HEAVY CHECK, WASTE SERVICE PANEL ALONG HINGE IS CORRODED. MAINTENANCE R & R WASTE SERVICE DOOR IAW AMM 20-10-01.SDR R61A201410101111Stop Fitting · corrodedDURING HEAVY CHECK, HARDWARE ON WASTE SERVICE DOOR STOP IS CORRODED. MAINTENANCE R & R HARDWARE ON WASTE SERVICE DOOR STOP IAW AMM 20-10-01, PN 170-86663-003, STOP.
Back to Embraer ERJ 170-100SU