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 R61A201806040650Panel · corrodedMAINTENANCE FOUND LEVEL 2 CORROSION ON WASTE SERVICE PANEL AT FRAMES 86 TO 89. WASTE SERVICE PANEL WAS REMOVED AND REPLACED IAW AMM 53-03-60, 51-10-03, AND 51-75-16.SDR R61A20180426513Battery Pack · inoperativeEMERGENCY LIGHT IN CENTER OF CABIN INOPERATIVE. R & R THE BATTERY PACK IAW AMM 33-50-01. OPS CHECKED GOOD.SDR R61A2018050180550Support · crackedMAINTENANCE FOUND A CRACKED SUPPORT IN THE FWD CARGO AT FRAME 17. THE SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-41-01.SDR R61A2018050160543Doubler · corrodedMAINTENANCE FOUND CORROSION ON THE AFT GALLEY FWD MIDDLE FLOOR FITTING DOUBLER. THE DOUBLER WAS REMOVED AND REPLACED IAW SRM 51-23-04.SDR R61A2018050100545Floor Support · corrodedMAINTENANCE FOUND CORROSION ON THE FLOOR SUPPORT AT FRAME 84, LBL 45. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-41-01.SDR R61A2018050130541Shear Tie · corrodedMAINTENANCE FOUND CORROSION ON THE SHEAR AT FRAME 83, BETWEEN STRINGERS 27R AND 28R. THE SHEAR TIE WAS REMOVED AND REPLACED IAW SRM 51-41-01.SDR R61A2018050120551Rib · crackedRIGHT ELEVATOR OTBD RIB END CAP SUPPORT CRACKED. MAINTENANCE REMOVED AND REPLACED THE RIB IAW SRM 51-42-01, 51-40-02, AND AMM 20-10-01.SDR R61A2018050120552Rib · crackedMAINTENANCE FOUND A CRACKED RIB IN THE LT ELEVATOR. THE RIB WAS REMOVED AND REPLACED IAW SRM 51-43-04.SDR R61A2018050110546Plate · corrodedMAINTENANCE FOUND CORROSION ON THE AFT CARGO DOOR CUTOUT CLOSING PLATE. THE PLATE WAS REMOVED AND REPLACED IAW SRM 51-41-01.SDR R61A2018050110544Attach Fitting · corrodedMAINTENANCE FOUND CORROSION ON THE FWD WET AREA LT WIND SCREEN FLOOR ATTACH FITTING, FRAME 19 INBD OF L1 DOOR. THE ATTACH FITTING WAS REMOVED AND REPLACED IAW SRM 51-43-03.SDR R61A201805010542Floor Support · corrodedMAINTENANCE FOUND CORROSION ON THE FWD WET AREA LT FLOOR SUPPORT FRAMES 12 - 16. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-41-02.SDR R61A201805010540Shear Tie · corrodedMAINTENANCE FOUND CORROSION ON THE SHEAR TIE AT FRAME 84 BETWEEN STRINGERS 27R AND 28R. THE SHEAR TIE WAS REMOVED AND REPLACED IAW SRM 51-41-01.SDR R61A2018043010539Shear Tie · corrodedMAINTENANCE FOUND CORROSION ON THE SHEAR TIE, AT FRAME 82 BETWEEN STRINGERS 28R AND 27R. THE SHEAR TIE WAS REMOVED AND REPLACED IAW SRM 51-41-01.SDR R61A2018043000519Shear Panel · corrodedMAINTENANCE FOUND CORROSION ON THE LEFT SHEAR PANEL. FRAME 87. THE SHEAR PANEL WAS REMOVED AND REPLACED IAW SRM 51-42-01.SDR R61A2018043010520Shear Tie · corrodedMAINTENANCE FOUND CORROSION ON THE SHEAR TIE. FRAME 81, STRINGER 27R - 28R. THE SHEAR TIE WAS REMOVED AND REPLACED IAW SRM 51-41-01.SDR R61A2018043010517Shear Tie · corrodedMAINTENANCE FOUND CORROSION ON THE SHEAR TIE, FRAME 82. THE SHEAR TIE WAS REMOVED AND REPLACED IAW SRM 51-41-01.SDR R61A2018043010516Shear Tie · corrodedMAINTENANCE FOUND CORROSION ON THE SHEAR TIE AT FRAME 83 BETWEEN STRINGER 28R AND 29R. THE SHEAR TIE WAS REMOVED AND REPLACED IAW SRM 51-41-01.SDR R61A2018043010518Door Sill · corrodedMAINTENANCE FOUND CORROSION IN THE FWD WET AREA, ON THE LT DOOR SILL. FRAMES 19 TO 21 THE DOOR SILL WAS REMOVED AND REPLACED IAW SRM 51-41-02.SDR R61A2018043010521Doubler · corrodedMAINTENANCE FOUND CORROSION IN THE FWD WET AREA, LT FLOOR WEB DOUBLER. FRAMES 19 TO 20. THE DOUBLER WAS REMOVED AND REPLACED IAW SRM 51-41-02.SDR R61A201804301522Attach Fitting · corrodedMAINTENANCE FOUND CORROSION IN THE FWD WET AREA, LAVATORY ATTACH FITTING. FRAME 16. THE FITTING WAS REMOVED AND REPLACED IAW IAW SRM 51-43-01.SDR R61A2018042910523Floor Support · corrodedMAINTENANCE FOUND CORROSION IN THE FWD WET AREA, ON THE RT FLOOR SUPPORT AFT OF THE R1 DOOR, BETWEEN FRAMES 17 - 18. THE FLOOR SUPPORTL WAS REMOVED AND REPLACED IAW SRM 51-41-02.SDR R61A2018042910524Seat Track · corrodedMAINTENANCE FOUND CORROSION IN THE FWD WET AREA, ON THE LT INBD SEAT TRACK BETWEEN BETWEEN FRAMES 16 - 20. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-43-03.SDR R61A2018042900525Seat Track · corrodedMAINTENANCE FOUND CORROSION, FWD WET AREA, RT INBD SEAT TRACK BETWEEN FRAMES 12 - 18. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-43-03.SDR R61A2018050100548Door · corrodedMAINTENANCE FOUND CORROSION ON WASTE SERVICE DOOR. THE DOOR WAS REMOVED AND REPLACED IAW SRM 53-03-60.SDR R61A2018050110547Gusset · corrodedMAINTENANCE FOUND CORROSION ON THE FLOOR GUSSET AT FRAME 91, LBL 10. THE GUSSET WAS REMOVED AND REPLACED IAW SRM 51-41-01.SDR R61A2018050100549Gusset · corrodedMAINTENANCE FOUND CORROSION ON THE FLOOR SUPPORT GUSSET AT FRAME 90, RBL 10. THE GUSSET WAS REMOVED AND REPLACED IAW SRM 51-41-02.SDR R61A2018043010519Floor Support · corrodedMAINTENANCE FOUND CORROSION ON THE FLOOR SUPPORT AT FRAME 86. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-43-01.SDR R61A2018043000538Shear Panel · corrodedMAINTENANCE FOUND CORROSION ON THE RIGHT SHEAR PANEL. FRAME 87. THE SHEAR PANEL WAS REMOVED AND REPLACED IAW SRM 51-42-01.SDR R61A201804100530Shear Panel · corrodedMAINTENANCE FOUND CORROSION ON THE LEFT SHEAR PANEL. FRAME 87. THE SHEAR PANEL WAS REMOVED AND REPLACED IAW SRM 51-42-01.SDR R61A2018043000529Shear Panel · corrodedMAINTENANCE FOUND CORROSION ON THE LEFT SHEAR PANEL ATTACHED GUSSET. FRAME 87 TO 88. THE SHEAR PANEL WAS REMOVED AND REPLACED IAW SRM 51-42-02.SDR R61A2018042910528Floor Support · corrodedMAINTENANCE FOUND CORROSION ON THE FLOOR SUPPORT AT FRAME 84, RBL 45. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-41-01.SDR R61A2018042910527Floorbeam · corrodedMAINTENANCE FOUND CORROSION ON THE FLOORBEAM ANGLE AT FRAME 84, RBL 26. THE FLOORBEAM ANGLE WAS REMOVED AND REPLACED IAW SRM 51-43-03.SDR R61A2018042910526Floor Support · corrodedMAINTENANCE FOUND CORROSION ON THE FLOOR SUPPORT AT FRAME 84, RBL 13. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-43-03.SDR R61A2018042910532Floor Support · corrodedMAINTENANCE FOUND CORROSION ON THE FLOOR SUPPORT BETWEEN FRAMES 90 - 91, RBL 10. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-41-01.SDR R61A201802910534Floor Support · corrodedMAINTENANCE FOUND CORROSION ON THE FLOOR SUPPORT AT FRAME 90, RBL 23. REMOVED AND REPLACED IAW SRM 51-42-01.SDR R61A2018042910535Floor Support · corrodedMAINTENANCE FOUND CORROSION ON THE FLOOR SUPPORT AT FRAME 90, LBL 10. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-41-01.SDR R61A2018042910536Floor Support · corrodedMAINTENANCE FOUND CORROSION ON THE FLOOR SUPPORT AT FRAME 90, LBL 3. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-43-01.SDR R61A2018042910537Floor Support · corrodedMAINTENANCE FOUND CORROSION ON THE FLOOR SUPPORT BETWEEN FRAMES 89 - 90, RBL 10. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-43-03.SDR R61A2018042710533Floor Support · corrodedMAINTENANCE FOUND CORROSION ON THE RIGHT FLOOR SUPPORT BETWEEN FRAMES 88 - 90, LBL 37. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-10-03.SDR R61A2018042910531Floor Support · corrodedMAINTENANCE FOUND CORROSION ON THE LEFT FLOOR SUPPORT BETWEEN FRAMES 88 - 90, LBL 37. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-42-01.SDR R61A201803200378Structure · crackedWHILE AC WAS OUT OF SERVICE FOR MAINTENANCE, TECHNICIANS DISCOVERED CRACKS IN THE FWD ELECTRONIC BAY SUPPORT RACK, LT AND RT LEGS. MAINTENANCE REMOVED AND REPLACED THE LEGS IAW JOB CARD EO-53-12-0000, SRM 51-31-00, AND 51-41-01. ACFT RETURNED TO SERVICE.SDR R61A201803110306Beam · corrodedWHILE IN HEAVY CHECK FOUND CORROSION AT FR 89 LT. SIDE OF THE LONGITUDINAL BEAM. REMOVE AND REPLACE BEAM WITH NEW REF SRM 51-23-04 AND 51-41-01.SDR R61A201803010288Power Supply · inoperativeTWO EMERGENCY LIGHTS INOPERATIVE. R & R THE BATTERY PACK AND POWER SUPPLY IAW AMM 33-50-01.SDR R61A201706210423Connector · disconnectedFLIGHT DECK LIGHT INOPERATIVE. CONNECTED COCKPIT EMERGENCY LIGHT IAW AMM 33-50-13.SDR R61A201705080345Cover · detachedLIGHT COVER IN EXIT SIGN ON AIRCRAFT RIGHT FELL OFF. SECURED THE COVER IAW AMM 33-50-10. OPS CHECK GOOD.SDR R61A201705010339Lever · out of adjustMAIN CABIN DOOR ARMING LEVERS ARE DIFFICULT TO PUSH DOWN. ADJUSTED 4 DOOR ARMING LEVERS IAW AMM 52-12-52.SDR R61A201704200328Warning Message · false activationBRAKE LT AND RT FAULT IN FLIGHT. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. PERFORMED FIM 32-41-00-810-825A, TEST PASSED.SDR R61A201703280256Panel · unsecureTHE L1 DOOR GUST LATCH NOT ENGAGING. SECURED THE L1 DOOR PANEL IAW AMM 25-23-04. OPS CHECK GOOD.SDR R61A201703280255Seal · looseR2 DOOR SEAL MAKING FLAPPING NOISE IN FLIGHT. CLEANED AND LUBED DOOR SEAL IAW 52-00-21. PERFORMED CABIN PRESSURIZATION INSPECTION, CANNOT DUPLICATE NOISE IAW 21-31-00.SDR R61A201703210230Liner · detachedL1 DOOR INTERIOR PANEL DETACHED. REINSTALLED L1 DOOR LINING IAW AMM 25-23-04.
Back to Embraer ERJ 170-100SU