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 UHLA201512090914Floor Support · corrodedCORROSION, RT FLOOR SUPPORT FRAME 86/90. R & R THE FLOOR SUPPORT.SDR UHLA201512090913Gusset · corrodedCORROSION, RT GUSSET PLATE FRAME 90. R & R GUSSET.SDR UHLA201512090908Gusset · corrodedCORROSION ON LT GUSSET FRAME 90. R & R GUSSET.SDR UHLA201512090907Gusset · corrodedRT CENTER GUSSET PLATE, FRAME 90 CORRODED. R & R GUSSET.SDR UHLA201512090906Support · corrodedLT PANEL SUPPORT FRAME 88/90 CORRODED. R & R PANEL SUPPORT .SDR UHLA201511170819Light · missingEMERGENCY LIGHT STRIP MISSING AT ROW 2A. SECURED EMERGENCY LIGHT STRIP AT ROW 2A IAW AMM 33-50-21.SDR R61A201511170840Light · looseCREW REPORTED THAT THE PHOTOLUMINESCENT STRIP WAS LOOSE. MAINTENANCE REATTACHED IAW AMM AND OPS CHECKED GOOD.SDR R61A201511150839Unknown · odorCREW REPORTED A BURNING ODOR IN THE COCKPIT FROM THE AIR CONDITIONING PACK 1. INSPECTED THE HEAT EXCHANGER AND ACM, RAN PACK OFF APU AND ENGINE AT POWER IAW AMM WITH NO DEFECTS NOTED. ACFT IS GOOD FOR SERVICE.SDR UHLA201511090787Roller · out of adjustF/AS REPORT VERY LOUD SQUEAL IN FLIGHT COMING FROM L2 DOOR, NEAR THE FLOOR, CAN BE HEARD AS FAR FWD AS ROW 9. ADJUSTED LOWER ROLLERS ON L2 DOOR REF AMM 52-12-00. OPS AND LEAK CHECK GOOD.SDR R61A201511090793Handle · brokenCREW REPORTED THAT THE MEGAPHONE HANDLE WAS BROKEN. MAINTENANCE R & R MEGAPHONE IAW AMM AND OPS CHECKED GOOD.SDR R61A201511040781Connector · disconnectedCREW REPORTED THAT THE EMERGENCY LIGHT ABOVE ROW 2 WAS NOT LIGHTING UP. MAINTENANCE RECONNECTED ROW 2 CEILING PANEL C/P IAW AMM AND OPS CHECKED GOOD.SDR UHLA201510280817Splice · misinstalledDURING INSPECTION, THE SPLICES FOR 170EO-53-10-0008, SB 170-53-0056, WERE FOUND TO BE INCORRECTLY INSTALLED. MAINTENANCE REMOVED AND CORRECTLY RE-INSTALLED THE SPLICES IAW ETD2015-170-100228.SDR R61A201510250763Light · looseCREW REPORTED THAT THE EMERGENCY LIGHTS IN FRONT OF THE CLOSET IS NOT STAYING IN PLACE. MAINTENANCE SECURED THE END CAPS IAW AMM AND OPS CHECKED GOOD.SDR R61A201510210747Bracket · separatedCREW REPORTED THAT WHILE DISARMING THE L1 DOOR AND LT BRACKET FELL OUT. ACFT WAS FLOWN VIA MAINTENANCE FERRY, WHERE MAINTENANCE REATTACHED THE L1 DOOR LINER BRACKET IAW AMM AND OPS CHECKED GOOD.SDR R61A201510140711Battery Pack · weakCREW REPORTED THAT THE F/O FLASHLIGHT WAS DIM. MAINTENANCE R & R F/O FLASHLIGHT BATTERY IAW AMM AND OPS CHECKED GOOD.SDR UHLA201510120810Seat Track · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE RT INBD SEAT TRACK AT FRAMES 52-54. MAINTENANCE R & R THE SEAT TRACK IAW SRM 51-40-02, 51-42-03, 51-43-04.SDR UHLA201510120803Seat Track · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE RT INBD SEAT TRACK AT FRAME 82. MAINTENANCE R & R THE SEAT TRACK IAW SRM 53-23-10.SDR UHLA201510110805Intercostal · corrodedDURING INSPECTION, CORROSION WAS FOUND AT THE FORWARD INTERCOSTAL AT THE AFT HOT DRAIN. MAINTENANCE R & R THE FORWARD INTERCOSTAL AT THE AFT HOT DRAIN MAST IAW SRM 51-40-02, 51-21-02, 51-41-01, 51-41-02.SDR UHLA201510110793Intercostal · corrodedDURING INSPECTION, CORROSION WAS FOUND AT THE AFT INTERCOSTAL AT THE AFT HOT DRAIN. MAINTENANCE R & R THE AFTER INTERCOSTAL AT THE HOT DRAIN MAST IAW SRM 51-40-02, 51-21-02, 51-41-01, 51-41-02.SDR UHLA201510090792Seal Rest · corrodedDURING INSPECTION, CORROSION WAS FOUND AROUND THE FASTENER HOLES ON THE AFT CARGO FORWARD AND AFT LOWER CORNER SEAL REST. MAINTENANCE R & R THE FORWARD AND AFT LOWER CORNER SEAL REST IAW SRM 53-23-29.SDR UHLA201510080804Threshold · corrodedDURING INSPECTION, CORROSION WAS FOUND AT THE AFT PASSENGER DOOR THRESHOLD. MAINTENANCE R & R THE SUPPORT SEAL IAW SRM 51-41-01.SDR R61A201510080705Flashlight · inoperativeMAINTENANCE REPORTED THAT THE F/O FLASHLIGHT WAS INOPERATIVE. MAINTENANCE R & R THE FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR UHLA201510060814Door Sill · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE AFT SERVICE DOOR SILL. MAINTENANCE R & R THE THRESHOLD IAW SRM 51-41-01, 51-41-02, 51-41-03.SDR UHLA201510060813Door Sill · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE AFT PASSENGER DOOR SILL. MAINTENANCE R & R THE AFT PASSENGER DOOR SILL IAW SRM 51-43-01.SDR UHLA201510060811Seat Track · corrodedDURING INSPECTION, CORROSION WAS FOUND BETWEEN SEAT TRACKS AT FRAME 84. MAINTENANCE REPAIRED THE CORROSION IAW ETD2015-170-094057.SDR UHLA201510060809Shear Plate · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE RT SHEAR PLATE AT FRAMES 87-88. MAINTENANCE R & R THE SHEAR PLATE IAW SRM 51-23-00.SDR UHLA201510060808Shear Plate · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE CENTER SHEAR PLATE AT FRAMES 87-88. MAINTENANCE R & R THE SHEAR PLATE IAW SRM 51-42-02.SDR UHLA201510060807Gusset · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE RT CENTER GUSSET PLATE AT FRAME 90. MAINTENANCE R & R THE GUSSET PLATE IAW SRM 51-40-02.SDR UHLA201510060806Gusset · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE LT GUSSET AT FRAME 90. MAINTENANCE R & R THE GUESSET PLATE IAW SRM 51-41-02.SDR UHLA201510060802Splice · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE RIGHT CENTER SPLICE AT FRAME 89. MAINTENANCE R & R THE RT CENTER SPLICE AT FRAME 89 IAW SRM 51-40-02, 51-23-04, 51-21-02, 51-43-03.SDR UHLA201510060800Shear Plate · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE LEFT SHEAR PLATE AT FRAMES 87-88. MAINTENANCE R & R THE SHEAR PLATE IAW SRM 51-40-02.SDR UHLA201510060799Splice · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE CENTER SPLICE AT FRAME 90. MAINTENANCE R & R THE SPLICE IAW SRM 51-23-04, 51-23-05.SDR UHLA201510060798Seat Track · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE LT SEAT TRACK AT FRAME 84. MAINTENANCE REPAIRED THE DAMAGE IAW ETD2015-170-094033.SDR UHLA201510060797Threshold · corrodedDURING INSPECTION, CORROSION WAS FOUND AT THE L2 THRESHOLD TIE STRAP AFT OF FRAME 85. MAINTENANCE R & R THE THRESHOLD TIE STRAP IAW SRM 51-43-01.SDR UHLA201510060796Splice Plate · corrodedDURING INSPECTION, CORROSION WAS FOUND AT THE LEFT SPLICE PLATE AT FRAMES 87-88 AFT OF THE AFT PASSENGER DOOR. MAINTENANCE R & R THE SPLICE IAW SRM 51-42-02.SDR R61A201510060776Frame · corrodedDURING HEAVY CHECK, CROSSBEAM AT FRAME 90 NEAR RT CENTER GUSSET PLATE IS CORRODED. MAINTENANCE REMOVED CORROSION AND FABRICATED, DRILLED, INSTALLED NEW DOUBLER FOR CROSSBEAM AT FRAME 90 IAW ETD 2015-170-094025.SDR R61A201510060757Seat Track · corrodedDURING HEAVY CHECK, WAS REPORTED THAT RT SEAT TRACK AT FRAMES 12 - 20 IS CORRODED. MAINTENANCE R & R RT SEAT TRACK IAW SRM 51-41-01, 51-43-01, 51-43-02,SDR UHLA201510050816Crossbeam · corrodedDURING INSPECTION, A TOOL MARK WAS FOUND ON THE CENTER CROSS FRAME 17. MAINTENANCE REPAIRED THE BEAM IAW ETD2015-170-092901.SDR UHLA201510050815Crossbeam · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE RT CROSS FRAME 17. MAINTENANCE REPAIRED THE CORROSION IAW ETD2015-170-092901.SDR UHLA201510050801Upper Sheet · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE LEFT UPPER SHEET AT FRAMES 85-86. MAINTENANCE R & R THE UPPER SHEET AT FRAMES 85-86 IAW SRM 51-41-01, 51-43-01.SDR UHLA201510050795Floor Support · corrodedDURING INSPECTION, CORROSION WAS FOUND AT THE RT AFT FLOOR SILL AT FRAMES 17-20. MAINTENANCE R & R THE FLOOR SILL IAW SRM 51-41-02, 51-43-02.SDR UHLA201510050794Doubler · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE LEFT DOUBLER AT FRAMES 19-20. MAINTENANCE R & R THE LT DOUBLER IAW SRM 51-41-01.SDR UHLA201510040812Threshold · corrodedDURING INPSECTION, CORROSION WAS FOUND AT THE R2 THRESHOLD AROUND THE RIVET HEADS AT THE GRIT BAR FITTING. MAINTENANCE R & R THE THRESHOLD IAW SRM 51-40-02, 51-41-01, 51-41-02, 51-43-03, 51-43-02.SDR R61A201510010696Light · inoperativeCREW REPORTED THAT THE PHOTOLUMINESCENT STRIP BY ROW 1 WAS INOPERATIVE. MAINTENANCE R & R PHOTOLUMINESCENT STRIP BY ROW 1 IAW AMM AND OPS CHECKED GOOD.SDR R61A201509290690Flashlight · inoperativeCREW REPORTED THAT THE F/O FLASHLIGHT WAS INOPERATIVE. R & R F/O FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201509260656Module · inoperativeF/A REPORTED A ELECTRICAL ODOR IN THE CABIN. CREW DECLARED AN EMERGENCY AND RETURNED, WHERE THEY LANDED WITHOUT INCIDENT. MAINTENANCE TROUBLESHOOT, R & R SPDA DC POWER SUPPLY IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR R61A201509180643Feel Unit · malfunctionedCREW REPORTED INCREASING STIFFNESS IN YOKE ROLL CONTROL. CREW RAN QRH, DECLARED AN EMERGENCY AND RETURNED. CREW LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED, CLEANED AND REINSTALLED ARTIFICAL FEEL UNIT IAW AMM AND OPS, CHECKED GOOD. ACFT IS GOOD FOR SERVSDR UHLA201509090693Lever · fodL2 DOOR ARMING LEVER STIFF. REMOVED FOD AND DOOR ARM LEVER OPERATES NORMALLY IAW AMM 52-12-00 AND AMM 52-42-00.SDR R61A201509090623Light · inoperativeMAINTENANCE REPORTED THAT THE EMERGENCY LIGHT STRIP WAS INOPERATIVE. MAINTENANCE R & R THE LIGHT STRIP IAW AMM AND OPS CHECKED GOOD.SDR UHLA201509080694Processor · malfunctionedAVNX MAU 2B FAIL ON EICAS. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. TROUBLESHOT IAW FIM 45-45-00-810-942-A. R & R MAU 2 NIC 2 IAW AMM 31-41-04 WITH PRE-LOADED NIC PROCESSOR MODULE, MESSAGE NO LONGER PRESENT ON THE EICAS.
Back to Embraer ERJ 170-100SU