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 R61A201702240175Light · dimMAINTENANCE REPORTED THAT THE FORWARD RIGHT EMERGENCY LIGHT STRIP WAS DIM. MAINTENANCE REMOVED AND REPLACED THE LIGHT STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201702240174Light · looseMAINTENANCE REPORTED THAT TWO EMERGENCY STRIP HOLDERS WERE NOT SECURE. MAINTENANCE SECURED HOLDERS IAW AMM AND OPS CHECKED GOOD.SDR R61A201702130122Light · inoperativeMAINTENANCE REPORTED THAT THE EMERGENCY LIGHT STRIP WAS DULL AND DID NOT LIGHT UP. REMOVED AND REPLACED THE LIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201702080108Flashlight · inoperativeCREW REPORTED THAT THE FIRST OFFICERS FLASHLIGHT WOULD NOT CHARGE. MAINTENANCE REMOVED AND REPLACED FIRST OFFICERS FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201702080106Flashlight · inoperativeCREW REPORTED THAT THE FIRST OFFICERS FLASHLIGHT WOULD NOT CHARGE. MAINTENANCE REMOVED AND REPLACED FIRST OFFICERS FLASHLIGHT PER AMM AND OPS CHECKED GOOD.SDR R61A201702070101Flashlight · inoperativeCREW REPORTED THAT THE FIRST OFFICERS FLASHLIGHT WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED FIRST OFFICERS FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR UHLA201701050002Flap · out of adjustDOOR L2 ARMING LEVER VERY DIFFICULT TO MOVE. ADJUSTED L2 DOOR VENT FLAP IAW AMM 52-12-25. OPS CHECK GOOD.SDR UHLA201612230513Lock · out of adjustL1 DOOR AFT LOCK INDICATION DOES NOT SHOW GREEN WHEN CLOSED AND LOCKED. ADJUSTED THE L1 DOOR AFT LOCK INDICATION PER AMM 52-11-00. OPS GOOD.SDR UHLA201612190510Girt Bar · dirtyR2 DOOR FROZEN AND CAN'T DISARM. CLEANED THE R2 DOOR GIRT BAR FITTINGS, OPS CHECKED GOOD IAW AMM 52-42-22.SDR UHLA201611220495Sensor · out of adjustDOOR PAX FWD OPEN EICAS DURING CRUISE FLIGHT AT FL340. FA INSPECTED DOOR L1 AND FOUND EVERYTHING INDICATING NORMAL. ADJUSTED L1 DOOR FRAME SENSOR IAW AMM 52-72-20. OPS CHECK GOOD.SDR UHLA201611220494Glowstrip · missingROW 12 PHOTO LUMINESCENT LIGHT STRIP MISSING. R&R PHOTO LUMINESCENT LIGHT STRIP AT ROW 12 IAW AMM 33-50-21.SDR UHLA201611020481Warning Light · false activationUPON LOWERING LANDING GEAR, EMERGENCY PARKING BRAKE LIGHT FLICKERED ON AND OFF QUICKLY. WHEN GREEN LGA STEER FAIL EICAS MESSAGE APPEARED, EXECUTED A GO-AROUND TO RUN QRH. NO FIX. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. COMPLIED WITH FIM 21-31-00 AND AMM 3SDR UHLA201610210475Indicator · out of adjustR1 DOOR NOT SHOWING GREEN DISARMED. ADJUSTED R1 DOOR ARMED/DISCONNECT INDICATOR IAW CMM 52-41-22.SDR UHLA201609300452Skin · damagedLIGHTNING STRIKE DAMAGE FOUND AT FRAME 98 BETWEEN STRINGERS 28-29L. PERFORMED PERMANENT REPAIR TO LIGHTNING STRIKE DAMAGE TO THE FUSELAGE SKIN FCBS 53-30-00-002 AND FRAME 98 FCBS 53-30-00-003 IAW ETD2016-170-088965 REV B. MAJOR REPAIR.SDR UHLA201609300445Power Unit · inoperativeAFT GALLEY EMERGENCY EXIT SIGN WILL NOT ILLUMINATE WITH EMERGENCY LIGHTS TO ON. R&R AFT RT IB EMERGENCY POWER UNIT IAW AMM 33-50-01. ALL FAULTS CLEARED.SDR UHLA201609050434Arm · wornFORWARD PASSENGER DOOR SUPPORT ARM ASSY IS WORN AND DAMAGED, CAUSING LONGITUDINAL MOVEMENT OF DOOR, CREATING MISALIGNMENT AND DAMAGING AIRCRAFT. R & R THE SUPPORT ARM ASSY IAW AMM 52-11-30.SDR UHLA201608260422Chain · lack of lubeMAIN CABIN DOOR WON'T OPEN FULLY, WON'T LOCK IN PLACE, WON'T OPEN. LUBRICATED INTERNAL CHAIN MECHANISM OF L1 DOOR. L1 DOOR OPS CHECKED GOOD AT THIS TIME IAW CMM 52-11-22.SDR UHLA201608260421Power Supply · inoperativeEMERGENCY LIGHT OVER ROW 6 INOPERATIVE. R & R FWD NR 1 EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01. OPS CHECKED GOOD.SDR UHLA201606230333Cover · unsecureL2 DOOR NOT SHOWING GIRT BAR INDICATOR. RESECURED L2 DOOR BUSTLE COVER IAW MM 52-12-22.SDR UHLA201606090299Cover · crackedR & R EMERGENCY EXIT DOOR COVER CRACKED. R & R EMERGENCY EXIT COVER LENS IAW 33-50-17.SDR UHLA201606090298Cover · crackedR1 EMERGENCY EXIT DOOR COVER CRACKED. R & R EMERGENCY EXIT COVER LENS IAW 33-50-17.SDR UHLA201606090297Linkage · dirtyDOOR IN DISARM INDICATION IS ONLY PARTLY VISIBLE. CLEANED AND LUBRICATED INDICATION LINKAGE IAW AMM 12-22-01. DISARM INDICATION SHOWS CLEARLY IN VIEW WINDOW.SDR UHLA201605240322Gusset · chafedFWD SERVICE DOOR HAS CHAFE ON CENTER GUSSET. R & R CENTER GUSSET ON FWD SERVICE DOOR REF SRM 51-41-01 AND 51-42-03. PRIMED AND PAINTED FASTENERS REF SRM 51-23-05 AND 51-23-06.SDR UHLA201605230320Spar · crackedLEFT STUB WING SPAR 3 SHOWS CRACK INDICATIONS AT THE FASTENER REPLACEMENT HOLE. REPAIRED CRACK DAMAGE TO LT SPAR 3 BY REAM AND COUNTER BORE REF ETD2016-170-048910, REV B.SDR UHLA201605230314Splice · corrodedCORROSION ON SPLICE PLATE AT FRAME 90 AT Y-10.748. R & R SPLICE PLATE IAW SRM 51-40-02, 51-41-02.SDR UHLA201605220321Spar · crackedRIGHT STUB WING SPAR 3 SHOWS CRACK INDICATIONS AT THE FASTENER REPLACEMENT HOLE. REPAIRED CRACK DAMAGE TO RT SPAR 3 HOLE BY REAM AND COUNTER BORE REF ETD2016-170-048910, REV B.SDR UHLA201605150240Bellcrank · wornL2 DOOR FWD AND AFT GIRT BAR BELLCRANKS HAVE EXCESSIVE PLAY. R & R L2 DOOR FWD AND AFT GIRT BAR BELL CRANK BEARINGS IAW AMM 52-12-40 AND 20-10-08. OPS CHECK GOOD.SDR UHLA201605030202Light · unsecureEMERGENCY LIGHT STRIP IN FRONT OF FORWARD CLOSET IS LOOSE. SECURED THE EMERGENCY LIGHT STRIP IAW AMM 33-50.-21.SDR UHLA201605010291Windshield · crackedCAPTAIN'S WINDSHIELD CRACKED ON 1ST AND 2ND LAYER. DECLARED EMERGENCY, DIVERTED, LANDED WITHOUT INCIDENT. R & R CAPTAIN'S WINDSHIELD IAW 56-11-00. OPS, LEAK CHECK GOOD.SDR R61A201604180254Connector · unsecureCREW REPORTED THAT THE COCKPIT TO CABIN AND EMERGENCY RAINBOW LIGHTS WERE NOT TESTING. SECURED CONNECTOR P0551 IAW AMM AND OPS CHECKED GOOD.SDR R61A201604130242Light · missingMAINTENANCE REPORTED THAT THE EMERGENCY LIGHT STRIP WAS MISSING NEAR SEAT 2A. MAINTENANCE REPLACED MISSING EMERGENCY LIGHT STRIP IAW AMM AND OPS CHECKED GOOD.SDR UHLA201604120190Shear Tie · corrodedSHEAR TIE CORRODED FRAME 81 BETWEEN STRINGERS 27-28R. R & R THE SHEAR TIE.SDR UHLA201604110189Shear Tie · corrodedSHEAR TIE CORRODED FRAME 83, STR 27-28R. R & R SHEAR TIE.SDR UHLA201604070187Shear Tie · corrodedSHEAR TIE CORRODED AT FRAME 86, STR 27-28R. R & R SHEAR TIE.SDR UHLA201604070186Shear Tie · corrodedSHEAR TIE CORRODED AT FRAME 85 BETWEEN STR 27-28R. R & R SHEAR TIE.SDR R61A201603310230Light · inoperativeTHE CREW REPORTED THAT THE FLOOR LEVEL EMERGENCY LIGHTING FROM ROW 2D TO THE FORWARD WARDROBE WAS INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY FLOOR INDICATION STRIP. OPS CHECKS WERE GOOD WITH NO FURTHER DEFECTS NOTED.SDR R61A201603210206Light · inoperativeCREW REPORTED THAT THE EMERGENCY LIGHT STRIP AT SEAT 7D WAS INOPERATIVE. MAINTENANCE R & R THE LIGHT STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201603210205Light · inoperativeCREW REPORTED THAT THE EMERGENCY LIGHT STRIP LIGHT AT SEAT 2A WAS INOPERATIVE. MAINTENANCE R & R THE LIGHT STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201603190203Light · looseCREW REPORTED THAT A PIECE OF EMERGENCY LIGHT STRIP IN THE FWD CABIN CAME OFF THE FLOOR. MAINTENANCE SECURED THE LIGHT STRIP IAW AMM AND OPS CHECKED GOOD.SDR UHLA201603170125Power Supply · inoperativeTHE LT FWD EXIT IDENTIFIER EMERGENCY LIGHT IS INOPERATIVE. R & R FWD LT EMERGENCY BATTERY POWER UNIT IAW AMM 33-50-01.SDR UHLA201603150114Skin · damagedAPPROXIMATELY 43 LIGHTNING STRIKES BETWEEN FRAME 24 AND FRAME 27, STR 26L AND 27L. R & R DAMAGED AREA BETWEEN FRAME 24 AND FRAME 27, STR 26 AND 27 IAW ETD2016-170-025965.SDR R61A201603090179Windshield · failedCREW REPORTED THAT THE F/O WINDSHIELD SHATTERED. AN EMERGENCY WAS DECLARED AND CREW DIVERTED, WHERE THEY LANDED WITHOUT INCIDENT. MAINTENANCE R & R F/O`S WINDSHIELD IAW AMM AND OPS CHECKED GOOD.SDR R61A201602270153Light · inoperativeMAINTENANCE REPORTED THAT THE EMERGENCY LIGHTS AT ROW 8D & 8F WERE INOPERATIVE. MAINTENANCE R & R EMERGENCY LIGHTS IAW AMM AND OPS CHECKED GOOD.SDR R61A201602270152Light · inoperativeMAINTENANCE REPORTED THAT THE EMERGENCY LIGHTS AT ROW 5D & 5F WERE INOPERATIVE. MAINTENANCE R & R EMERGNECY LIGHTS AT 5D & 5F IAW AMM AND OPS CHECKED GOOD.SDR R61A201602270151Light · missingMAINTENANCE REPORTED THAT THE EMERGENCY LIGHT WAS MISSING. MAINTENANCE REPLACED THE EMERGENCY LIGHT IAW AMM AND OPS CHECKED GOOD.SDR CA160226001Windshield · failed(CAN) PILOTS WINDSHIELED SHATTERED DURING THE APPROACH. AIRCRAFT PROCEEDED TO LAND SAFELY. UPON REMOVAL OF THE SHATTERED WINDSHIELD THERE IS EVIDENCE OF ARCING. NEW WINDSHIELD INSTALLED AND AIRCRAFT RETURNED TO SERVICE.SDR R61A201602240150Warning Message · false activationCREW RECEIVED A WING ANTI-ICE MESSAGE. CREW RAN QRH AND MESSAGE CLEARED. MESSAGE LATER RETURNED, CREW RAN QRH AND MESSAGE DID NOT CLEAR. CREW DECLARED AN EMERGENCY AND DIVERTED, WHERE THEY LANDED WITHOUT INCIDENT. MAINTENANCE TROUBLESHOT IAW AMM AND FOUND TSDR R61A201602220121Roller · damagedCREW REPORTED THAT THE L1 DOOR DID NOT CLOSE PROPERLY. MAINTENANCE FOUND UPPER FLAP ROLLER DAMAGED. MAINTENANCE R & R DOOR LINER ASSEMBLY IAW AMM AND OPS CHECKED GOOD.SDR R61A201602200118Processor · inoperativeCREW RECEIVED AN AVNX MAU 3A FAIL MESSAGE. CREW DECLARED AN EMERGENCY AND DIVERTED, WHERE THEY LANDED WITHOUT INCIDENT. MAINTENANCE R & R NIC/PROC 5 AND POWER SUPPLY NR 1 IAW AMM AND OPS CHECKED GOOD.SDR R61A201602140090Megaphone · inoperativeCREW REPORTED THAT THE MEGAPHONE WAS INOPERATIVE, MAINTENANCE R & R MEGAPHONE IAW AMM AND OPS CHECKED GOOD.
Back to Embraer ERJ 170-100SU