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 R61A201509020597Flashlight · brokenCREW REPORTED THAT THE FORWARD F/A FLASHLIGHT MOUNT WAS BROKEN. MAINTENANCE R & R FORWARD F/A FLASHLIGHT ASSY AND HOLDER IAW AMM. OPS CHECKED GOOD.SDR R61A201509010588Battery · inoperativeMAINTENANCE REPORTED THAT THE EMERGENCY LIGHTS WERE INOPERATIVE AT THE R1 AND L2 DOORS. MAINTENACE R & R EMERGENCY BATTERY IAW AMM AND OPS CHECKED GOOD.SDR R61A201508310566Light · missingCREW REPORTED THAT THE PHOTOLUMINESCENT STRIP AT ROW 13 WAS MISSING. MAINTENANCE REPLACED PHOTOLUMINESCENT STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201508300572Doubler · corrodedDRAIN MAST AFT INNER DOUBLER IS CORRODED. MAINTENANCE R & R DRAIN MAST AFT INNER DOUBLER IAW SRM 51-40-02, 51-41-02, PN 170-87558-001, DRAIN MAST DOUBLER.SDR R61A201508300571Shear Tie · corrodedSHEAR TIE AT FRAME 87 BETWEEN STRINGERS 27-28R FOUND CORRODED. R & R THE SHEAR TIE IAW SRM 51-40-01, AND 51-40-02.SDR R61A201508300570Intercostal · corrodedINTERCOSTAL BETWEEN FRAMES 85-86, STRINGERS 27-28R FOUND CORRODED. R & R THE INTERCOSTAL IAW SRM 51-41-01, AND 51-41-02.SDR R61A201508300569Intercostal · corrodedINTERCOSTAL BETWEEN FRAMES 86-87, STRINGERS 27-28R FOUND CORRODED. R & R THE INTERCOSTAL IAW SRM 51-40-01, AND 51-40-02.SDR R61A201508130568Shear Tie · corrodedREPORTED THAT SHEAR TIE AT FRAME 88 BETWEEN STRINGERS 27-28R FOUND CORRODED. R & R THE SHEAR TIE IAW SRM 51-40-01, 51-40-02.SDR R61A201508280565Flashlight · inoperativeCREW REPORTED THAT THE AFT F/A FLASHLIGHT WOULD NOT TURN ON. R & R THE AFT F/A FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR UHLA201508230700Closeout Panel · corrodedCORROSION FWD CARGO THRESHOLD CLOSE OUT PANEL. FABRICATED NEW CLOSE OUT PANEL ACCORDING TO ETD2015-170-077384B.SDR UHLA201508230681Door Sill · corrodedCORROSION AFT SERVICE DOOR THRESHOLD SILL. REPAIRED CORROSION ON AFT SERVICE DOOR THRESHOLD SILL BY SPOTFACING AND BLENDOUT REF ETD2015-170-073174.SDR UHLA201508230680Door Sill · corrodedCORROSION AFT PAX DOOR THRESHOLD SILL. REMOVED CORROSION IAW ETD 2015-170-073208-A.SDR UHLA201508190720Structure · corrodedCORROSION FOUND ON THE AFT SERVICE DOOR INTERIOR STRUCTURE AFT LOWER CORNER. REMOVED DAMAGE AND INSTALLED A DOUBLER IAW ETD2015-170-073576.SDR UHLA201508180702Seat Track · corrodedCORROSION RT SEAT TRACK Y +10.748" AT FRAME 84. CUTOUT OR REMOVED CORROSION BY BLENDING AND INSTALLED DOUBLER ACCORDING TO ETD2015-170-073587.SDR UHLA201508180701Seat Track · corrodedCORROSION LT SEAT TRACK, Y-10.748" AT FRAME 84. CUTOUT OR REMOVED CORROSION BY BLENDING AND INSTALLED DOUBLER ACCORDING TO ETD2015-170-073587.SDR UHLA201508180695Skin · crackedLEFT WING SPAR 2 OTBD OF RIB 10 UPPER SKIN CRACKED INBD HOLE TO T/E. REMOVED CRACK DAMAGE BY ROUTE AND INSTALLING DOUBLER AND FILLER REF ETD2015-170-074183.SDR UHLA201508170705Beam · corrodedCORROSION ON LT BEAM Y-10.748" FRAME 86-89. REMOVED CORROSION AND INSTALLED DOUBLER IAW ETD2015-170-074273.SDR UHLA201508170704Floor Support · corrodedCORROSION RT PANEL SUPPORT FR 86-90. R & R.SDR R61A201508170534Flashlight · inoperativeMAINTENANCE REPORTED THAT THE FWD F/A FLASHLIGHT WAS INOPERATIVE. MAINTENANCE R & R FWD F/A FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR UHLA201508160719Frame · corrodedCORROSION FOUND AT FRAME 84 BETWEEN SEAT TRACKS. REMOVED CORROSION.SDR UHLA201508160715Seat Track · corrodedCORROSION FOUND ON RT FLOOR TRACK FRAMES 12 - 20. R & R SEAT TRACK.SDR UHLA201508150623Cover · crackedFWD SERVICE DOOR EMERGENCY EXIT COVER CRACKED. R & R FWD SERVICE DOOR EMERGENCY EXIT COVER IAW AMM 33-50-14.SDR UHLA201508150622Light · inoperative1ST, 3RD, AND 4TH RT PHOTOLUMINESCENT STRIPS NEED REPLACED. R & R 1ST, 3RD, AND 4TH PHOTOLUMINESCENT STRIPS IAW AMM 33-50-21.SDR UHLA201508110713Floor Panel · corrodedCORROSION FOUND ON LT FLOOR DOUBLER FRAMES 13-16. R & R.SDR UHLA201508110710Floor Support · corrodedCORROSION ON LT LONGITUDINAL FLOOR SUPPORT Y=-10.748" BETWEEN FRAMES 90-91. REMOVED CORROSION AND INSTALLED L-ANGLE DOUBLE IAW ETD2015-170-073000.SDR R61A201508110521Wire · brokenCREW REPORTED THAT THE CAPTAIN`S FLASHLIGHT WOULD NOT CHARGE. MAINTENANCE FOUND BROKEN WIRE IN THE BASE OF THE CAPTAIN`S FLASHLIGHT AND R & R CAPTAINS FLASHLIGHT BASE IAW AMM AND OPS CHECKED GOOD.SDR R61A201508100516Girt Bar · lack of lubeCREW REPORTED THAT THEY COULD NOT GET THE R2 DOOR OPEN. MAINTENANCE CLEANED AND LUBED GIRT BAR IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR UHLA201508090718Seal Rest · corrodedCORROSION FOUND ON AFT SERVICE DOOR FUSELAGE CUTOUT LOWER CENTER SEAL REST. R & R.SDR UHLA201508090679Threshold · corrodedCORROSION ON PASSENGER DOOR THRESHOLD. REPAIRED IAW ETD 2015-170-072895.SDR UHLA201508080707Shear Plate · corrodedCORROSION FOUND ON RT SHEAR PLATE FRAMES 87-88. R & R.SDR UHLA201508070712Splice Plate · corrodedCORROSION FOUND ON LT OTBD SPLICE PLATE BETWEEN FRAMES 88-89. R & R SPLICE PLATE.SDR UHLA201508070711Gusset · corrodedCORROSION FOUND ON GUSSET AT FRAME 90 Y +10.748. R & R GUSSET.SDR UHLA201508070709Upper Sheet · corrodedCORROSION FOUND ON RT Y+10.748 UPPER SHEET FRAMES 85-86. R & R UPPER SHEET.SDR UHLA201508070708Upper Sheet · corrodedCORROSION FOUND ON LT Y-10.748" UPPER SHEET FRAMES 85-86. R & R UPPER SHEET.SDR UHLA201508070706Shear Plate · corrodedCORROSION ON CENTER SHEAR PLATE FRAMES 87-88. R & R.SDR UHLA201508060717Floor Support · corrodedCORROSION FOUND ON RT AFT FLOOR SUPPORT, FRAMES 17 - 20. R & R.SDR UHLA201508060716Floor Support · corrodedCORROSION FOUND ON RT FWD FLOOR SUPPORT, FRAMES 12-14. R & R.SDR UHLA201508060714Seat Track · corrodedCORROSION FOUND ON LT FLOOR TRACK, FRAMES 12-20. R & R TRACK LEFT.SDR UHLA201508060703Gusset · corrodedCORROSION RT GUSSET PLATE FR 90. R & R PN 170-60259-001.SDR R61A20150806513Flashlight · inoperativeCREW REPORTED THAT CAPTAIN`S FLASHLIGHT WAS NOT CHARGING.SDR R61A201508030496Rod · malfunctionedCREW REPORTED THAT THE L1 DOOR WOULD NOT OPEN PROPERLY. MAINTENANCE R & R COUNTER BALANCE RODS AND LUBED L1 DOOR BOX MECHANISM IAW AMM AND OPS CHECKED GOOD.SDR R61A201507230456Guide · out of adjustCREW REPORTED THAT THEY COULD NOT SHUT THE MAIN CABIN DOOR. MAINTENANCE TROUBLESHOT AND ADJUSTED THE DOOR GUIDES IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR R61A201507200453Flashlight · inoperativeMAINTENANCE REPORTED THAT THE FORWARD F/A FLASHLIGHT WAS INOPERATIVE. MAINTENANCE R & R FORWARD F/A FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201507160508Angle · corrodedDURING HEAVY CHECK, PANEL 143 DL NUT PLATES ANGLES ARE CORRODED. MAINTENANCE R & R PANEL 143 DL NUT PLATES ANGLES IAW SRM 51-40-02 AND 20-10-07.SDR R61A201507130426Girt Bar · detachedCREW REPORTED THAT THE L1 DOOR WOULD NOT ARM. MAINTENANCE REATTACHED THE GIRT BAR CLIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201507120512Floor Support · corrodedDURING HEAVY CHECK, RT FORWARD FLOOR SUPPORT BETWEEN FRAMES 12-14 IS CORRODED. MAINTENANCE R & R THE FLOOR SUPPORT IAW SRM 51-40-02, 51-23-04, 51-41-02, AND 51-43-04.SDR R61A201507120511Seat Track · corrodedDURING HEAVY CHECK, RT SEAT TRACK, FRAME 12-20 IS CORRODED. MAINTENANCE R & R THE SEAT TRACK IAW SRM 51-43-03, 51-43-04, AND 51-21-02.SDR R61A201507120510Shear Plate · corrodedDURING HEAVY CHECK, LT SHEAR PLATE FRAME 87-88 IS CORRODED. MAINTENANCE R & R LT SHEAR PLATE IAW SRM 51-42-01, 51-40-02, 51-42-02, 51-21-01, 51-23-04, AND 51-42-02.SDR R61A201507120509Shear Plate · corrodedDURING HEAVY CHECK, CENTER SHEAR PLATE AT FRAME 87-88 IS CORRODED. MAINTENANCE R & R CENTER SHEAR PLATE IAW SRM 51-21-01, 51-42-01, 51-23-01, 51-23-05.SDR R61A201507120450Frame · corrodedDURING HEAVY CHECK, FRAME 84 BETWEEN SEAT TRACKS IS CORRODED. REPAIRED IAW ETD-2015-170-100SU.
Back to Embraer ERJ 170-100SU