N117HQ

Service difficulty reports · 97

Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.

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 n_number = 'N117HQ' AND registry_match = 'registration'
  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.

SDR R61A201510020752Hinge · corrodedDURING HEAVY CHECK WAS REPORTED THAT WASTE SERVICE DOOR HINGE WHERE BONDING WIRE ATTACHES IS CORRODED. MAINTENANCE R & R WASTE SERVICE DOOR IAW SRM 51-23-06, PN 170-86668-403 DOOR.Oct 2, 2015 · N117HQ · Emb ERJ170200LR · Fuselage, Door HingeSDR R61A201510020751Hinge · corrodedDURING HEAVY CHECK, POTABLE WATER SERVICE DOOR HINGE NEXT TO BONDING WIRE IS CORRODED. MAINTENANCE R & R POTABLE WATER SERVICE DOOR HINGE IAW SRM 51-42-02, PN 170-85099-001, HINGE.Oct 2, 2015 · N117HQ · Emb ERJ170200LR · Fuselage, Door HingeSDR R61A201510020750Fastener · corrodedDURING HEAVY CHECK, WIRE HARNESS MOUNTING BRACKET AT SPAR 3 AFT PYLON FAIRING T/E FASTENERS ARE CORRODED. MAINTENANCE R & R WIRE HARNESS MOUNTING BRACKET AT SPAR 3 AFT PYLON FAIRING T/E FASTENERS IAW AMM 20-10-07, PN NAS1801-08-8, SCREW.Oct 2, 2015 · N117HQ · Emb ERJ170200LR · Nacelle/Pylon, Main FrameSDR R61A201412191250Fork · out of adjustF/A REPORTED THAT THE L2 DOOR ARMING LEVER RAISED UP AND THE ARMED INDICATOR ROTATED OUT OF VIEW. AN EMERGENCY WAS NOT DECLARED AND LANDED WITHOUT INCIDENT. MAINTENANCE TROUBLESHOT AND FOUND UPPER FORK OF ARMING CABLE OUT OF ADJUSTMENT. MAINTENANCE REMOVED,Dec 19, 2014 · N117HQ · Emb ERJ170200LR · Emergency EquipmentSDR R61A2014062300793Megaphone · intermittentAFT MEGAPHONE OPERATED INTERMITTENTLY. R & R AFT MEGAPHONE IAW EMERGENCY EQUIPMENT MANUAL.Jun 30, 2014 · N117HQ · Emb ERJ170100SU · Emergency EquipmentSDR R61A201403250440Light · detachedCREW REPORTED EMERGENCY LIGHT WAS DETACHED IN FRONT OF SEAT 1D. MAINTENANCE ATTACHED EMERGENCY LIGHT IAW AMM AND OPS CHECKED GOOD. ACFT GOOD FOR SERVICE.Mar 25, 2014 · N117HQ · Emb ERJ170200LR · Emergency LightingSDR R61A201403060337Flashlight · dimCREW REPORTED THAT THE AFT F/A FLASHLIGHT WAS VERY DIM. MAINTENANCE R & R FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.Mar 6, 2014 · N117HQ · Emb ERJ170200LR · Emergency EquipmentSDR R61A201310241056Target · out of adjustCREW RECEIVED A L1 DOOR OPEN INDICATION. AN EMERGENCY WAS NOT DECLARED AND CREW LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED AND PLACED ON MEL IAW AMM. MAINTENANCE LATER ADJUSTED THE L1 DOOR SWITCH TARGET IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SEOct 24, 2013 · N117HQ · Emb ERJ170200LR · Door Warning SystemSDR R61A201310231055Sensor · malfunctionedCREW RECEIVED AN L1 DOOR OPEN INDICATION IN FLIGHT. CREW DID NOT DECLARE AN EMERGENCY AND LANDED WITHOUT INCIDENT. R & R THE DOOR WARNING SENSOR IAW AMM AND OPS CHECKED GOOD.Oct 23, 2013 · N117HQ · Emb ERJ170200LR · Door Warning SystemSDR R61A201310040978Link · corrodedDURING HEAVY CHECK, LT ELEVATORS PCU HAS PITTING ON THE INBD TOGGLE LINK. MX R & R LT ELEVATOR INBD TOGGLE LINK IAW AMM 27-32-01.Oct 4, 2013 · N117HQ · Emb ERJ170200LR · Elevator StructureSDR R61A201310030991Screw · corrodedDURING HEAVY CHECK, FWD PASSENGER DOOR FLEX BALL HARDWARE CORRODED. MX R & R SLIDE ARM HANDLE LOWER HARDWARE IAW AMM 20-10-01, 20-10-02.Oct 3, 2013 · N117HQ · Emb ERJ170200LR · Escape SlideSDR R61A201310030990Bolt · corrodedDURING HEAVY CHECK, L1 DOOR LOWER EVACUATION SLIDE HARDWARE CORRODED. R & R SLIDE HARDWARE IAW AMM 20-10-01, 20-10-02.Oct 3, 2013 · N117HQ · Emb ERJ170200LR · Escape SlideSDR R61A201310030989Rib · crackedDURING HEAVY CHECK, LT WING RIB 10 EXTENSION IS CRACKED ORIGINATING AFT SIDE OF FASTENER HOLE THAT IS THE THIRD HI LOC FROM AFT SIDE OF THE RIB TOP SIDE OF RIB. MAINTENANCE INSTALLED SERVICABLE RIB 10 EXTENSION IAW SRM 51-40-00, 51-21-00.Oct 3, 2013 · N117HQ · Emb ERJ170200LR · Wing, Rib/BulkheadSDR R61A201310030987Rib · crackedDURING HEAVY CHECK WAS REPORTED LT HORIZONTAL STAB L/E RIB 4 IS CRACKED. MX REPAIRED RIB IAW ETD 2013-170-045806.Oct 3, 2013 · N117HQ · Emb ERJ170200LR · Horizontal Stabilizer, Spar/RibSDR R61A201310030980Support Bracket · crackedDURING HEAVY CHECK, LT PACK DUCT SUPPORT BRACKET IS CRACKED. MX R & R BRACKETS IAW SRM 51-41-01, 51-43-01.Oct 3, 2013 · N117HQ · Emb ERJ170200SU · Fuselage Main, Attach FittingsSDR R61A201310030979Rib · crackedDURING HEAVY CHECK, RT HORIZONTAL STAB L/E RIB 4 IS CRACKED ON LOWER SIDE. MX REPAIRED RIB IAW ETD 2013-170-045806.Oct 3, 2013 · N117HQ · Emb ERJ170200LR · Horizontal Stabilizer, Spar/RibSDR R61A201310030972Spar · damagedDURING HEAVY CHECK, RT WING HYD SYS 1 PRESSURE LINE AT SPAR 3 HAS LOOSE JAM NUT AND SPAR DAMAGE. MX INSTALLED REPAIRED IAW ETD 2013-170-046098.Oct 3, 2013 · N117HQ · Emb ERJ170200LR · Wing SparSDR R61A201310030971Spar · damagedDURING HEAVY CHECK, LEFT WING HYD SYSTEM NR 1 PUMP PRESSURE LINE AT SPAR 3 HAS ALOOSE JAM NUT WITH SPAR DAMAGE. MX INSTALLED PERMANENT REPAIR IAW ETD 2013-170-046098.Oct 3, 2013 · N117HQ · Emb ERJ170200LR · Wing SparSDR R61A201310020993Bolt · corrodedDURING HEAVY CHECK, L-1 DOOR SLIDE ARMING HANDLE LOWER BOLT BOTH BOTTOM SLIDE HOOK ATTACH BOLTS FOUND TO HAVE CORROSION. MX R & R SLIDE ARMING HANDLE LOWER BOLT BOTH BOTTOM SLIDE HOOK ATTACH BOLTS IAW AMM 20-10-01, 20-10-02. PN NAS660-4D11, BOLT. ACFT REMAIOct 2, 2013 · N117HQ · Emb ERJ170200LR · Escape SlideSDR R61A201310020992Bracket · corrodedDURING HEAVY CHECK, NUMEROUS NUTPLATE BRACKETS AND ATTACHING HARDWARE CORRODED ON FWD CARGO SILL AREA. MX R & R NUTPLATES AND BRACKETS IAW 51-41-01.Oct 2, 2013 · N117HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A201310020986Screw · corrodedDURING HEAVY CHECK, L2 DOOR SLIDE TELFLEX CABLE FWD BELL CRANK ATTACH HARDWARE CORRODED. MX R & R L-2 DOOR SLIDE TELFLEX CABLE FWD BELL CRANK HARDWARE. PN NAS1154-100, SCREW. ACFT REMAINS UNTIL COMPLETION OF HEAVY CHECK.Oct 2, 2013 · N117HQ · Emb ERJ170200LR · Escape SlideSDR R61A201310020985Clevis Bolt · corrodedDURING HEAVY CHECK WAS REPORTED BOTH CLEVIS BRACKET BOLTS ON L2 DOOR CORRODED. MX R & R BOTH CLEVIS BRACKET BOLTS IAW AMM 20-10-01.Oct 2, 2013 · N117HQ · Emb ERJ170200LR · Passenger/Crew DoorsSDR R61A201310020984Stop Fitting · corrodedDURING HEAVY CHECK, L1 DOOR AFT NR 2, & NR 4, BOTTOM AND FORWARD BOTTOM STOP SHOWING SIGNS OF CORROSION. MX R & R STOPS IAW AMM 52-11-23. PERFORMED ADJUSTMENT CHECK ON L-1 DOOR IAW AMM 53-23-29.Oct 2, 2013 · N117HQ · Emb ERJ170200LR · Passenger/Crew DoorsSDR R61A201310020973Beam · corrodedDURING HEAVY CHECK, FWD CARGO DOOR CUT OUT LOWER SILL IS CORRODED. MX R & R LOWER FWD CARGO DOOR BEAM, AFT, CENTER, AND FORWARD DOOR SEAL REST, SIX LOWER NUT PLATE SUPPORT BRACKETS IAW SRM 51-40-02, AMM 20-10-07.Oct 2, 2013 · N117HQ · Emb ERJ170200LR · Cargo/Baggage DoorsSDR R61A201310020957Sill · corrodedDURING HEAVY CHECK, AFT CARGO DOOR CUT OUT LOWER SILL CORRODED. MX REMOVED AND REPLACED DOOR SILL IAW SRM 51-40-02, 51-41-01, 51-41-02, 51-23-06.Oct 2, 2013 · N117HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A201310010995Joint · corrodedDURING HEAVY CHECK, FOUND SPLIT JOINTS ON AFT RT GALLEY ARE CORRODED. MX R & R SPLIT JOINTS ON AFT RT GALLEY IAW AMM 25-00-23, 20-10-01. PN 170-59521-001 SPLIT JOINT. ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.Oct 1, 2013 · N117HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A201310010974Floor Panel · crackedDURING HEAVY CHECK, AFT LAVATORY FLOORING CRACKED. MX REPAIRED MULTIPLE AREAS OF COMPOSITE AND PAINT DAMAGE ON THE AFT LAV SUB FLOOR PANEL IAW AMM 25-00-08, 25-00-10, AND 25-00-21.Oct 1, 2013 · N117HQ · Emb ERJ170200LR · Fuselage Floor PanelSDR R61A201309290977Tray · crackedDURING HEAVY CHECK, TRAY TABLE UPPER LOCK BRACKET CRACKED AT SEAT 7A. MX R & R TRAY TABLE UPPER LOCK BRACKET AT SEAT 7A IAW CMM 25-23-46-210-001-A01.Sep 29, 2013 · N117HQ · Emb ERJ170200LR · Passenger Compartment EquipmentSDR R61A201309290976Tray · crackedDURING HEAVY CHECK, TRAY TABLES ON BACK OF SEATS 4F, 5D, 8D, 10F, ARE CRACKED. MX R & R TRAY TABLES.Sep 29, 2013 · N117HQ · Emb ERJ170200LR · Passenger Compartment EquipmentSDR R61A201309290975Pan · crackedDURING HEAVY CHECK, SEAT 12F SEAT PAN CRACKED. MX R & R 12F SEAT PAN IAW CMM 25-23-46.Sep 29, 2013 · N117HQ · Emb ERJ170200LR · Passenger Compartment EquipmentSDR R61A201307130603Girt Bar · out of adjustCREW REPORTED THE L1 DOOR GIRT BAR NOT IN PLACE WITH DOOR CLOSED. MX ADJUSTED GIRT BAR IAW AMM AND OPS CHECKED GOOD.Jul 13, 2013 · N117HQ · Emb ERJ170200LR · Emergency EquipmentSDR R61A201303230303Unknown · malfunctionedDURING APPROACH INTO ORD, CREW RECEIVED A STEER FAIL MESSAGE UPON GEAR EXTENSION. ATC DECLARED AN EMERGENCY AND EMERGENCY EQUIPMENT WAS ROLLED. AIRCRAFT LANDED WITHOUT INCIDENT WAS ABLE TO TAXI TO THE GATE USING DIFFERENTIAL BRAKING AND THRUST. MAINTENANCE Mar 23, 2013 · N117HQ · Emb ERJ170200LR · Landing Gear Steering SystemSDR R61A201205160289Windshield · crackedCREW REPORTED CAPTAIN'S WINDSHIELD START TO CRACK EN ROUTE TO CLT. CREW DECLARED AN EMERGENCY AND DIVERTED TO MGM, THE AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE REMOVED AND REPLACED THE CAPTAIN WINDSHIELD PER THE EMB AMM.May 16, 2012 · N117HQ · Emb ERJ170200LR · Flight Compartment WindowsSDR R61A20110439Rod End · defectiveCREW REPORTED L-1 DOOR WAS DIFFICULT TO OPERATE. MAINTENANCE REMOVED AND REPLACED ROD END AND PIN IAW CMM 52-11-22, OPS CHECK GOOD.Dec 18, 2011 · N117HQ · Emb ERJ170200LR · Passenger/Crew DoorsSDR R61A20110425Doubler · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND CORROSION ON WASTE BOX DOUBLERS AT FR88 RT. MX REMOVED AND REPLACED DOUBLERS PN 170-86654-003 AND 175-86655-003 IAW EMB 170 SRM 51-43-02. A/C REMAINS IN CMH FOR HEAVY CHECK COMPLETION.Dec 8, 2011 · N117HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A20110421Shear Web · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND CORROSION ON THE RT SHEAR WEB AT FR 87-88. MX REMOVED AND REPLACED THE SHEAR PNL P/N 170-91919-001 IAW EMB 175 SRM 51-40-02, 51-42-01, 51-42-02, 51-43-01. A/C REMAINS IN CMH FOR COMPLETION OF HEAVY CHECK.Dec 8, 2011 · N117HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A20110424Intercostal · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND CORROSION ON RT INTERCOSTAL AT FR 89 TO FR 90. MX REMOVED AND REPLACED RT INTERCOSTAL AT FR 89 TO FR 90 IAW EMB 175 SRM 51-43-03. P/N 170-65177-003. A/C REMAINS IN CMH FOR HEAVY CHECK COMPLETION.Dec 7, 2011 · N117HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A20110423Beam · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND CORROSION ON THE RT BEAM AT FR 86-89. MX REMOVED AND REPLACED RT BEAM AT FR 86-89 IAW EMB 170/175 SRM 51-41-01, 51-43-03. P/N 170-65669-004. A/C REMAINS IN CMH FOR HEAVY CHECK COMPLETION.Dec 7, 2011 · N117HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A20110422Strap · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND CORROSION ON RT STRAP/UPPER SHEET AT FR 85-86. MX REMOVED AND REPLACED RT UPPER SHEET AT FR 85-86 IAW EMB 170/175 SRM 51-41-01, 51-43-03. P/N 170-86101-001. A/C REMAINS IN CMH FOR HEAVY CHECK COMPLETION.Dec 7, 2011 · N117HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A20110420Gusset · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE LT OUTBOARD GUSSET AT FRAME 90. MAINTENANCE REMOVED AND REPLACED THE LT OUTBOARD GUSSET AT FRAME 90 IAW EMB 175 SRM 51-41-02. AIRCRAFT IS CURRENTLY STILL OUT OF SERVICE FOR HEAVY CHECKDec 6, 2011 · N117HQ · Emb ERJ170200SU · Fuselage Miscellaneous StructureSDR R61A20110419Gusset · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE RT OUTBOARD GUSSET AT FRAME 90. MAINTENANCE REMOVED AND REPLACED THE RT OUTBOARD GUSSET AT FRAME 90 IAW EMB 175 SRM 51-41-02. AIRCRAFT IS CURRENTLY STILL OUT OF SERVICE FOR HEAVY CHECKDec 6, 2011 · N117HQ · Emb ERJ170200SU · Fuselage Miscellaneous StructureSDR R61A20110418Gusset · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE RT CENTER GUSSET AT FRAME 90. MAINTENANCE REMOVED AND REPLACED THE RT CENTER GUSSET AT FRAME 90 IAW EMB 175 SRM 51-41-02. AIRCRAFT IS CURRENTLY STILL OUT OF SERVICE FOR HEAVY CHECK COMDec 6, 2011 · N117HQ · Emb ERJ170200SU · Fuselage Miscellaneous StructureSDR R61A20110357Light · looseCREW REPORTED ESCAPE PATH LIGHTING STRIP NEAR FIRST CLASS CAME LOOSE. MAINTENANCE RE-SECURED EMERGENCY LIGHT STRIP PER EMB AMM, NO DEFECTS NOTED.Nov 7, 2011 · N117HQ · Emb ERJ170200LR · Emergency LightingSDR R61A20110344Power Unit · inoperativeCREW REPORTED FLIGHT DECK EMERGENCY LIGHT INOP. MAINTENANCE REMOVED AND REPLACED ELPU NR 1 PER EMB AMM, OPS CHECK GOOD.Oct 28, 2011 · N117HQ · Emb ERJ170200LR · Emergency LightingSDR R61A20110332Light · inoperativeCREW REPORTED COCKPIT EMERGENCY LIGHTS WERE INOP. MAINTENANCE REMOVED AND RE-INSTALLED THE LIGHT ASSY PER EMB AMM, OPS CHECK GOOD.Oct 21, 2011 · N117HQ · Emb ERJ170200LR · Emergency LightingSDR R61A20110191Fan Blade · bentCREW REPORTED BIRD STRIKE TO E-2 DURING CLIMBOUT OF CLT. CREW DECLARED AN EMERGENCY AND RETURNED TO FIELD AT CLT. A/C LANDED WITHOUT INCIDENT. MAINTENANCE COMPLETED BIRD STRIKE INPECTION AND REPLACED E-2 B, 1, 13, 14, 15, AND 27 FAN BLADES PER EMB AMM.Jul 25, 2011 · N117HQ · Emb ERJ170200LR · Turbine Engine Compressor SectionSDR R61A20110105Connector · looseCREW REPORTED EMERGENCY LIGHT OVER ROW 8 INOPERATIVE. MAINTENANCE RE-SECURED CONNECTOR AND PERFORMED OPS CHECK PER EMB AMM, OPS CHECK GOOD.May 10, 2011 · N117HQ · Emb ERJ170200LR · Light System Wiring
Back to N117HQ