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 UHLA2013110500585Gusset · corrodedCORROSION FOUND ON RT CENTER GUSSET PLATE FRAME 89. R & R GUSSET.SDR UHLA2013110500584Shear Plate · corrodedCORROSION FOUND ON CENTER SHEAR PANEL FRAMES 87-88. R & R SHEAR PANEL.SDR UHLA2013110500583Floor Support · corrodedCORROSION FOUND ON RT FLOOR SUPPORT, FRAMES 87-90. R & R FLOOR SUPPORT.SDR UHLA2013110500582Gusset · corrodedCORROSION FOUND ON GUSSET PLATE RT CENTER FRAME 90. R & R GUSSET.SDR UHLA2013110500581Splice · corrodedCORROSION FOUND ON RT SHEAR PANEL SPLICE FRAME 87-88. R & R SPLICE.SDR UHLA2013110500580Shear Plate · corrodedCORROSION FOUND ON RT SHEAR PANEL, FRAMES 87-88. R & R SHEAR PANEL.SDR UHLA2013110500579Upper Sheet · corrodedCORROSION FOUND ON UPPER SHEET RT FRAMES 85-86. R & R UPPER SHEET.SDR UHLA2013110400575Diaphragm · damagedL1 EMERGENCY OPENING PNEUMATIC ASSY BOTTLE PRESSURE IS AT 0 PSI. REPLACED L1 DOOR BOTTLE DIAPHRAGM IAW AMM 52-11-53, SERVICED IAW AMM 52-11-51.SDR UHLA2013110300578Seat Track · corrodedCORROSION FOUND ON SEAT TRACK AT Y=-10.748 LT FRAMES 17 AND 19. R & R SEAT TRACK.SDR UHLA2013110300577Doubler · corrodedCORROSION FOUND ON LT FWD DOUBLER, FRAMES 13-16. R & R DOUBLER.SDR R61A201311031111Linkage · out of adjustCREW REPORTED THAT THE L2 DOOR INDICATION WAS NOT SHOWING GREEN. MAINTENANCE ADJUSTED VISUAL INDICATOR LINKAGE IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR R61A201311011109Detector · brokenCREW REPORTED THAT THE L1 DOOR LATCH INDICATOR FLAG IS BROKEN. MAINTENANCE INSPECTED AND PLACED ON MEL IAW AMM. MAINTENANCE LATER R & R THE SHAFT ROLLER DETECTOR IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR R61A201310311083Deflector · unknownCREW REPORTED THAT THE R2 DOOR WAS VIBRATING THROUGHOUT ENTIRE FLIGHT. AN EMERGENCY WAS NOT DECLARED AND CREW LANDED WITHOUT INCIDENT. MAINTENANCE R & R THE R2 DOOR DEFLECTOR IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR R61A201310301080Indicator · dirtyCREW REPORTED THAT THE L1 DOOR LATCH INDICATOR SHOWS LOCKED WHEN THE DOOR IS OPEN. MAINTENANCE INSPECTED AND CLEANED DEBRIS FROM THE L1 DOOR LATCH INDICATOR IAW AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR R61A201310291081Battery · inoperativeCREW REPORTED THAT THE FORWARD F/A FLASHLIGHT WAS INOPERATIVE. MAINTENANCE SWAPPED FORWARD FLASHLIGHT WITH F/O FLASHLIGHT AND PROBLEM FOLLOWED. R & R THE FLASHLIGHT BATTERY IAW AMM AND OPS CHECKED GOOD.SDR UHLA2013102500556Slide · dislodgedL1 DOOR SLIDE FELL OUT OF HOLDER. R & R L1 DOOR EVAC SLIDE IAW AMM 25-65-01.SDR UHLA2013102500537Engine · smokeLAVATORY SMOKE EICAS INDICATION DURING CLIMB THOUGH 1,000 FEET. CABIN FILLED WITH SMOKE. R & R NR 2 ENGINE IAW 72-10-400-0001. OPS CHECKED GOOD.SDR R61A201310251062Unknown · unknownCREW REPORTED THAT THE L2 DOOR WAS MAKING A LOUD SQUEALING NOISE IN FLIGHT. AN EMERGENCY WAS NOT DECLARED AND CREW LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED DOOR AND SEAL AND FOUND NO DEFECTS. ACFT IS GOOD FOR SERVICE.SDR R61A201310221042Warning Message · multiple failRECEIVED AN "AVNX MAU 3B FAIL", "SPOILER FAULT" AND "CMF 1" FAIL MESSAGES. CONSULTED MAINTENANCE AND CONTINUED ON TO DESTINATION AND DECLARED AN EMERGENCY. ON SELECTING FLAPS 1, RECEIVED A "FLAP FAIL" MESSAGE THAT WENT OUT A FEW SECONDS LATER. PERFORMED A SDR R61A201310201038Battery · faultedCREW RECEIVED AN EMERGENCY LIGHT BATTERY FAULT MESSAGE. MAINTENANCE R & R EMERGENCY BATTERY IAW AMM AND OPS CHECKED GOOD.SDR R61A201310161014Battery Pack · dischargedCREW REPORTED AN EMERGENCY LIGHT BATTERY FAULT. MAINTENANCE RESET ACFT POWER AND CIRCUIT BREAKERS, CHARGED BATTERIES IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR R61A201310020968Torque Tube · corrodedDURING HEAVY CHECK, RT WING FLAP TORQUE TUBE F6 MALE END HAS PITTING ON SPLINES. MX R & R F6 TORQUE TUBE IAW AMM 27-51-03.SDR R61A201310020967Torque Tube · corrodedDURING HEAVY CHECK, RT WING FLAP TORQUE TUBE F5 MALE END HAS PITTING ON SPLINES. MX R & R RT TORQUE TUBE 5 IAW AMM 27-51-03. PN 5912942-2 TORQUE TUBE. ACFT REMAINS UNTIL COMPLETION OF HEAVY CHECK.SDR R61A201309300947Firewall · crackedDURING HEAVY CHECK, RT APU FIRE WALL HAS SMALL CRACK AT FLANGE END. CUT OUT DAMAGE AREA AND REPAIRED IAW ETD2013-170-044556.SDR UHLA2013092800460Rib · crackedMAJOR REPAIR - RT WING RIB 10 CRACKED. PERFORMED TEMP REPAIR IAW ETD2013-170-043955 REV A ON RT RIB EXTENSION.SDR UHLA2013092800452Spar · crackedLEFT WING SPAR II RIB 10 CRACKED. PERFORMED TEMP REPAIR IAW ETD2013-170-043955 REV A ON LT RIB EXTENSION. MAJOR REPAIRSDR R61A201309260947Rib · crackedDURING HEAVY CHECK, RT HORIZONTAL STABILIZER INTERNAL RIB 11A CRACKED .125 ON UPPER FORWARD FLANGE AT AFT HOLE. MX REPAIRED RIB IAW ETD 2013-170-041849, REV B.SDR R61A201309240925Door Frame · dirtyF/A STATED THAT THE L1 DOOR IS HISSING IN FLIGHT. AN EMERGENCY WAS NOT DECLARED AND LANDED WITHOUT INCIDENT. CLEANED DEBRIS FROM DOOR FRAME AND PERFORMED PRESSURIZATION CHECK OF THE L1 DOOR IAW AMM. OPS CHECKED GOOD AND ACFT IS GOOD FOR SERVICE.SDR R61A201309240914Mechanism · lack of lubeCREW REPORTED THAT THE L1 DOOR WAS HARD TO OPEN. MX LUBED THE L1 DOOR LOCKING MECHANISM IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR R61A201309230910Seal · dirtyCREW REPORTED THAT THE R2 DOOR WAS VERY NOISY IN FLIGHT. ALL INDICATIONS NORMAL, AN EMERGENCY WAS NOT DECLARED AND LANDED WITHOUT INCIDENT. MX CLEANED AND LUBED THE R2 DOOR SEAL IAW AMM AND DEFECTS WERE NOTED. ACFT IS GOOD FOR SERVICE.SDR R61A201309230908Smoke Detector · defectiveCREW RECEIVED A SMOKE MESSAGE IN FLIGHT. AN EMERGENCY WAS NOT DECLARED AND LANDED WITHOUT INCIDENT. MX FOUND THREE HITS ON THE CMC FOR THE SMOKE DETECTOR DURING FLIGHT. MX R & R SMOKE DETECTOR IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR R61A201309220966Shear Web · corrodedDURING HEAVY CHECK, LT SHEAR WEB BETWEEN FRAME 13 & 14 HAS SURFACE CORROSION. MX R & R DOUBLER IAW SRM 51-41-02.SDR R61A201309220951Tube · corrodedWHILE IN HEAVY CHECK WAS REPORTED NLG AXLE HAS CORROSION ON RT SIDE OF AXLE STRUT. MX R & R NLG SLIDING TUBE IAW AMM 32-21-04, SEE CONTINUATION CARD VP-030907-2013/583 FOR WORK PERFORMED.SDR R61A201309220946Seat Track · corrodedDURING HEAVY CHECK, FWD LEFT SEAT TRACK HAS CORROSION. R & R SEAT TRACK IAW SRM 51-41-01, 51-41-02.SDR R61A201309220941Floorbeam · corrodedDURING HEAVY CHECK WAS REPORTED KNIFE EDGE CROSSBEAM 17 BETWEEN R-1 DOOR AND RT SEAT TRACK. MX REPAIRED FRAME 17 FLOOR CROSSBEAM IAW ETD 2013-170-042101 ISSUED DMI 406659/1 FOR PERMANENT REPAIR AND INSPECTION TASK 53-10-027-0001, INTERNAL GVI, INTERVAL OF 200SDR R61A201309220935Tube · corrodedDURING HEAVY CHECK, FOUND NLG AXLE HAS CORROSION ON RT OF AXLE AT STRUT JOINT. MX R & R NLG SLIDING TUBE WITH NEW REF AMM 32-21-04. SEE CONTINUATION CARD FOR WORK PERFORMED VP-030907-2013-583 C1. PN 17070430-401. ACFT REMAINS AT CMH UNTIL COMPLETION OF HEAVYSDR R61A201309220933Crossbeam · damagedDURING HEAVY CHECK, KNIFE EDGE ON RT CROSSBEAM BETWEEN R1 DOOR AND RT SEAT TRACK. MX REPAIRED FRAME 14 FLOOR CROSSBEAM IAW ETD 2013 -170-042101 FABERICATED DOUBLER FROM AL 7075-T6511 PO 003973-2013 SEE CONTINUATION CARD C-1,2 FOR ALL MX. PERFORMED, PERMANENSDR R61A201309260956Rib · crackedDURING HEAVY CHECK, RT HORIZONTAL STAB INTERNAL RIB 11A CRACKED .125 ON UPPER FORWARD FLANGE AT AFT HOLE. MX REPAIRED RIB IAW ETD 2013-170-041849, REV B.SDR R61A201309200955Rib · crackedDURING HEAVY CHECK, RT HORIZONTAL RIB 10A HAS LOWER FLANGE, FWD STIFFENER IS CRACKED. MX REPAIRED RIB IAW ETD 2013-170-041849, REV B.SDR R61A201309200954Rib · crackedDURING HEAVY CHECK, RT HORIZONTAL RIB 12A EXTENSION LOWER FLANGE FWD OF STIFFENER CRACKED. MX REPAIRED RIB 12ASDR R61A201309190952Rib · crackedDURING HEAVY CHECK, RT L/E RIB CRACKED. MX CUT OUT DAMAGED AREA OF RIB AND FABRICATED REPAIR ANGLE IAW ETD 2013 170-041433, INSTALLED REPAIR ANGLE IAW ETD 2013-170-041433.SDR R61A201309190940Seat Track · corrodedWHILE IN HEAVY CHECK WAS REPORTED RT FWD SEAT TRACK HAS SURFACE CORROSION. MX R & R RT FWD SEAT TRACK IAW SRM 51-41-01, 51-41-02, SEE CONTINUATION SHEET C1, C2, FOR WORK ACCOMPLISHED. PN 170-02363-001, RT TRACK. ACFT REMAINS AT MX UNTIL HEAVY CHECK IS COMPLESDR R61A201309190939Dampener · corrodedDURING HEAVY CHECK, L2 DOOR DAMPENER CORRODED. MX R & R L2 DOOR DAMPENER IAW AMM 52-12-27-04.SDR R61A201309190903Doubler · corrodedDURING HEAVY CHECK, FWD LEFT CORNER AROUND WASTE SERVICE BOX CORRODED. INSPECTED AREA FOUND CORROSION TO BE LIMITED TO LAV SERVICE BOX FORWARD DOUBLER, REMOVED AND DISCARDED.SDR R61A201309190902Seat Track · corrodedDURING HEAVY CHECK, LEFT INBD SEAT TRACK EXTENSION CORRODED FRAMES 85-88. R & R SEAT TRACK IAW SRM 51-41-01, 51-43-01.SDR R61A201309190897Sill · corrodedDURING HEAVY CHECK, RT SILL PLATE BETWEEN FRAMES 17-20 HAS SURFACE CORROSION. MX R & R SILL PLATE IAW SRM 51-41-02.SDR R61A201309180965Bracket · corrodedDURING HEAVY CHECK, AFT LAV FWD FLOOR SPLIT JOINT OTBD FITTING CORRODED. MX R & R AFT LAV FORWARD FLOOR SPLIT JOINT OTBD FITTING IAW CMM 25-41-04, PN CDSP2200-3, BRACKET. AIRCRAFT REMAINS FOR COMPLETION OF HEAVY CHECK. SHOULD BE R61A201309180965 SHOULD NOT BSDR R61A201309180964Bracket · corrodedDURING HEAVY CHECK, AFT LAV FWD FLOOR SPLIT JOINT OTBD FITTING CORRODED. MX R & R AFT LAV FWD FLOOR SPLIT JOINT OTBD FITTING IAW CMM 25-41-04, PN CDSP2200-3 BRACKET. ACFT REMAINS FOR COMPLETION OF HEAVY CHECK.SDR R61A201309180942Spar · damagedDURING HEAVY CHECK, HYD LINE FEED THRU ON RT SPAR 3 ELONGATED HOLE FROM LOOSE LINE. MX REPAIRED WITH BUSHING FABRICATED FROM AL 7075-T6, PO 008382-2012, HYD PASS THRU WAS UP SIZED TO 35MM IAW ETD 2013-170-042524, SEE CONTINUATION CARDS C1, C2, C3, FOR ALL MX SDR R61A201309190900Solenoid · corrodedDURING HEAVY CHECK WAS REPORTED RT REFUELING PANEL CONTROL SOLENIOD EXTREMELY CORRODED. MX R & R SOLENOID RT REFUEL PANEL IAW AMM 28-23-05. PN 2990059-102 SOLENOID. AIRCRAFT, REMAINS TILL COMPLETION OF HEAVY CHECK.
Back to Embraer ERJ 170-100SU