N104HQ

Service difficulty reports · 102

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 = 'N104HQ' 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 R61A201511240908Hinge · corrodedDURING HEAVY CHECK, WASTE ACCESS DOOR HINGE IS CORRODED. MAINTENANCE R & R WASTE ACCESS DOOR HINGE IAW AMM 20-10-01, PN 170-86665-403, HINGE.Nov 24, 2015 · N104HQ · Emb ERJ170200LR · Fuselage, Door HingeSDR R61A201511210892Insert · corrodedDURING HEAVY CHECK, AFT CABIN FLOOR PANEL PANEL 251HLF HAS 4 INSERTS FOR GIRT BAR ARE CORRODED. MAINTENANCE R & R AFT CABIN FLOOR PANEL PANEL 251HLF HAS 4 INSERTS FOR GIRT BAR IAW AMM 25-00-23, PN SL2334-3AE3, INSERT.Nov 21, 2015 · N104HQ · Emb ERJ170200LR · Fuselage Floor PanelSDR R61A201511210890Insert · corrodedDURING HEAVY CHECK, AFT CABIN FLOORBOARD 252DRF HAS 4 INSERTS CORRODED BY GIRT BAR COVER. MAINTENANCE R & R FLOORBOARD 252DRF HAS 4 INSERTS BY GIRT BAR IAW AMM 25-00-17, PN SL2234-3AE, INSERT.Nov 21, 2015 · N104HQ · Emb ERJ170200LR · Fuselage Floor PanelSDR R61A201511210889Nut · corrodedDURING HEAVY CHECK, NR 2 FLAP TRACK SUPPORT FWD ATTACHMENT TO WING MOUNTING BOLT IS CORRODED. MAINTENANCE R & R CORRODED HARDWARE NR 2 FLAP TRACK SUPPORT FWD ATTACHMENT TO WING MOUNTING BOLT IAW AMM 57-54-21, PN MS14145L8, NUT.Nov 21, 2015 · N104HQ · Emb ERJ170200LR · Trailing Edge FlapsSDR R61A201511200891Door · corrodedDURNG HEAVY CHECK, WASTE SERVICE DOOR IS CORRODED. MAINTENANCE R & R WASTE SERVICE DOOR IAW AMM 20-10-01, P/N 170-86665-403, DOOR ASSY.Nov 20, 2015 · N104HQ · Emb ERJ170200LR · Fluid Service DoorsSDR R61A201501240052Light · looseCREW REPORTED THAT THE EMERGENCY LIGHT BY SEAT 1D & 1F WAS LOOSE. MAINTENANCE SECURED THE LIGHT IAW AMM AND OPS CHECKED GOOD.Jan 24, 2015 · N104HQ · Emb ERJ170200LR · Emergency LightingSDR R61A201412161239Light · looseCREW REPORTED THAT THE EMERGENCY LIGHT STRIP IN THE FORWARD GALLEY WAS LOOSE. MAINTENANCE SECURED THE STRIP IAW AMM AND OPS CHECKED GOOD.Dec 16, 2014 · N104HQ · Emb ERJ170200LR · Emergency LightingSDR R61A201412071228Light · unsecureMAINTENANCE REPORTED THAT EMERGENCY LIGHT STRIP IN THE FIRST CLASS SECTION WAS LOOSE. MAINTENANCE SECURED THE LIGHT STRIP IAW AMM AND OPS CHECKED GOOD.Dec 7, 2014 · N104HQ · Emb ERJ170200LR · Emergency LightingSDR R61A201408291028Light · looseCREW REPORTED THAT THE EMERGENCY LIGHT WAS DETACHED FROM THE FLOOR IN THE FIRST CLASS CABIN. MAINTENANCE SECURED THE LIGHT IAW AMM AND OPS CHECKED GOOD.Aug 29, 2014 · N104HQ · Emb ERJ170200LR · Emergency LightingSDR R61A201405270697Light · looseCREW REPORTED THAT A SMALL SECTION OF THE EMERGENCY LIGHT AT SEAT 1 DF WAS DETACHED. MAINTENANCE REINSTALLED EMERGENCY LIGHT IAW AMM AND OPS CHECKED GOOD.May 27, 2014 · N104HQ · Emb ERJ170200LR · Emergency LightingSDR R61A201404280613Light · looseCREW REPORTED THAT THE EMERGENCY LIGHT AT ROW 1 WAS LOOSE. MAINTENANCE SECURED THE LIGHT STRIP IAW AMM AND OPS CHECKED GOOD.Apr 28, 2014 · N104HQ · Emb ERJ170200LR · Emergency LightingSDR R61A201404140547Light · detachedCREW REPORTED THAT THE EMERGENCY LIGHT IN FRONT OF ROW 1B HAD BROKEN OFF. MAINTENANCE SECURED THE LIGHT IAW AMM AND OPS CHECKED GOOD.Apr 14, 2014 · N104HQ · Emb ERJ170200LR · Emergency LightingSDR R61A201404060499Light · looseCREW REPORTED THAT EMERGENCY LIGHT WAS LOOSE. MAINTENANCE SECURED THE LIGHT IAW AMM AND OPS CHECKED GOOD.Apr 6, 2014 · N104HQ · Emb ERJ170200LR · Emergency LightingSDR R61A201309160882Detector · brokenCREW RECEIVED A FWD PASSENGER DOOR OPEN MESSAGE ON EICAS OUT OF FL 210 AND WENT OFF AT 10,000 FT. DOOR INDICATIONS WERE GREEN AND PRESSURE WAS STABLE, CREW DID NOT DECLARE AN EMERGENCY AND LANDED WITHOUT INCIDENT. MX INSPECTED DOOR AND FOUND ROLLER SHAFT DETESep 16, 2013 · N104HQ · Emb ERJ170200LR · Door Warning SystemSDR R61A201309150880Bracket · brokenCREW REPORTED THAT THE F/A MEGAPHONE BRACKET WAS BROKEN. MX READJUSTED MEGAPHONE CLAMP IAW AMM AND OPS CHECKED GOOD.Sep 15, 2013 · N104HQ · Emb ERJ170200LR · Fuselage Main, Attach FittingsSDR R61A201309060849Frame · corrodedWHILE IN HEAVY CHECK, FRAME 17 FLOORBEAM HAS A RAZOR BLADE CUTMARK IN METAL FROM RT SEAT TRACK TO RT SILL WITH CORROSION IN THE METAL. MX R & R FR 17 CROSSBEAM IAW SRM 51-43-01, 51-43-02. AFFECTED FCS 53-10-00-013, PN 170-21769-403. AIRCRAFT REMAINS FOR COMSep 6, 2013 · N104HQ · Emb ERJ170200LR · Fuselage Main, FrameSDR R61A201309050851Torque Tube · corrodedWHILE IN HEAVY CHECK WAS REPORTED RT FLAP TORQUE TUBES F6 AN F5, AND F6-F5 BEARING HAVE CORROSION. MX R & R TORQUE TUBES F5, F6 AND BEARING SUPPORTS IAW AMM 27-51-03, 27-51-04. PN 5912949-2. ACFT REMAINS FOR COMPLETION OF HEAVY CHECK.Sep 5, 2013 · N104HQ · Emb ERJ170200LR · Trailing Edge FlapsSDR R61A201309040855Dampener · corrodedWHILE IN HEAVY CHECK, R2 DOOR DAMPENER IS CORRODED. MX R & R R-2 DOOR DAMPENER IAW AMM 52-42-27.Sep 4, 2013 · N104HQ · Emb ERJ170200LR · Service DoorsSDR R61A201309040854Structure · corrodedWHILE IN HEAVY CHECK, AFT GALLEY TRIM IS CORRODED ON FWD AND AFT MOUNTING SURFACES. MX R & R DAMAGED TRIM IAW WITH AMM 25-0023, 25-00-05.Sep 4, 2013 · N104HQ · Emb ERJ170200LR · Buffet/GalleysSDR R61A201309040850Nut · corrodedWHILE IN HEAVY CHECK, DOOR STOP HARDWARE ON STOP PAD ON R-2 DOOR FWD SIDE SECOND FROM BOTTOM IS CORRODED. MX R & R LOWER FORWARD FRAME DOOR STOP IAW AMM 53-23-25. PN NAS509-3C. AIRCRAFT REMAINS FOR COMPLETION OF HEAVY CHECK.Sep 4, 2013 · N104HQ · Emb ERJ170200LR · Service DoorsSDR R61A201309030838Rod End · corrodedDURING HEAVY CHECK, REPORTED AFT FUSELAGE HORIZONTAL STABILIZER FRAME 9 ADJUSTABLE ROD END IS CORRODED. R & R ROD END IAW AMM 27-41-03.Sep 3, 2013 · N104HQ · Emb ERJ170200LR · Horizontal Stabilizer StructureSDR R61A201309020853Rib · crackedWHILE IN HEAVY CHECK, CRACK FWD LT WHEEL WELL PANEL. MX R & R LT RIB, PN 170-08669-005. ACFT REMAINS AT FOR COMPLETION OF HEAVY CHECK.Sep 2, 2013 · N104HQ · Emb ERJ170200LR · Wing Main, Frame StructureSDR R61A201309020852Bolt · corrodedWHILE IN HEAVY CHECK, R2 DOOR FWD SLIDE FITTING PIN CORRODED. MX R & R R-2 DOOR FWD FITTING IAW AMM 20-10-01, PN NAS6604D12. ACFT REMAINS FOR COMPLETION OF HEAVY CHECK.Sep 2, 2013 · N104HQ · Emb ERJ170200LR · Service DoorsSDR R61A201308310859Stop Fitting · corrodedWHILE IN HEAVY CHECK WAS REPORTED FWD SERVICE DOOR LOWER FWD DOOR STOP ON DOOR HARDWARE CORRODED. MX R & R R-1 LOWER FWD DOOR STOP HARD WARE IAW AMM 52-41-23. PN 170-68172-001 SCREW. ACFT REMAINS FOR COMPLETION OF HEAVY CHECK.Aug 31, 2013 · N104HQ · Emb ERJ170200LR · Service DoorsSDR R61A201308310856Bracket · crackedWHILE IN HEAVY CHECK, BRACKET FOR PACK 1 RAM AIR DUCT IS CRACKED. MX R & R SUPPORT BRACKETS IAW SRM 51-41-01. PN 170-92988-401, SUPPORT ASSY. ACFT REMAINS FOR COMPLETION OF HEAVY CHECK.Aug 31, 2013 · N104HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A201308310848Bolt · corrodedDURING HEAVY CHECK, LOWER EVACUATION SLIDE MOUNTING HARDWARE CORRODED ON FWD PAX DOOR. MX R & R BOLTS ON L-1 DOOR IAW AMM 20-10-0, PN NAS6604D12. ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.Aug 31, 2013 · N104HQ · Emb ERJ170200LR · Passenger/Crew DoorsSDR R61A201308310826Diaphragm · crackedWHILE IN HEAVY CHECK WAS REPORTED SEAT PAN CRACKED AND ENLOGATED HOLES ON 4F. MX R & R SEAT PAN AT 4F (DIAPHRAGM) IAW AMM 25-21-17, PN 41191032-8, DIAPHRAGM. ACFT WILL REMAIN FOR COMPLETION OF HEAVY CHECK.Aug 31, 2013 · N104HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A201305130461Mask · brokenCREW REPORTED THAT THE DEMO O2 MASK WAS BROKEN. MAINTENANCE REPLACED THE DEMO O2 MASK PER EMB AMM AND OPS CHECKED GOOD.May 13, 2013 · N104HQ · Emb ERJ170200LR · Emergency EquipmentSDR R61A201305030445Glowstrip · unsecureCREW REPORTED THAT THE PHOTO LUMINESCENT STRIP BY THE CLOSET ON LEFT SIDE OF FIRST CLASS CAME OFF. MAINTENANCE RE-SECURED PHOTO LUMINESCENT STRIP PER EMB AMM AND OPS CHECKED GOOD.May 3, 2013 · N104HQ · Emb ERJ170200LR · Emergency EquipmentSDR R61A201304080364Actuator · brokenAPPROXIMATELY 30 FEET ABOVE GROUND, CREW HEARD AND FELT TWO POPPING SOUNDS AND A VIBRATION. ONE SECOND LATER THEY RECEIVED A MASTER CAUTION ON EICAS OF ENGINE 1 FAIL. CREW LANDED AND TAXIED TO GATE WITHOUT INCIDENT. MAINTENANCE INSPECTED AND FOUND THE MASTEApr 8, 2013 · N104HQ · Emb ERJ170100SU · Compressor Bleed ControlSDR R61A201209190519Pin · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT MLG FORWARD TRUNNION PIN BOLT HOLE CORRODED. MAINTENANCE REMOVED AND REPLACED RIGHT MLG TRUNNION PIN IAW EMB 175 AMM 31-11-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.Sep 19, 2012 · N104HQ · Emb ERJ170200LR · Main Landing Gear Attach SectionSDR R61A201209190515Splice · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND LEFT SHEAR PLATE FRAME 87 TO 88 CORRODED. MAINTENANCE REMOVED AND REPLACED LEFT SHEAR WEB SPLICE FRAME 87 TO 88 IAW EMB 175 SRM 51-40-02 AND 51-42-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.Sep 19, 2012 · N104HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A201209180514Bracket · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE FLOOR BOARD 252DRF NUT PLATE BRACKET BROKEN. MAINTENANCE REMOVED AND REPLACED BRACKET IAW EMB 175 SRM 51-40-02, AND 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.Sep 18, 2012 · N104HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A201209180512Structure · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND UPPER SHEET 1 CORRODED AT FRAME 86. MAINTENANCE REMOVED AND REPLACED UPPER SHEET AT FRAME 86 IAW EMB 175 SRM 51-41-01, AND 51-43-03. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.Sep 18, 2012 · N104HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A201209180510Gusset · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND CORROSION ON GUSSET ADJACENT TO FRAME 90. MAINTNENACE REMOVED AND REPLACED GUSSET ADJACENT TO FRAME 90 IAW EMB 175 SRM 51-41-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.Sep 18, 2012 · N104HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A201209180509Gusset · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND CORROSION ON GUSSET ADJACENT TO FRAME 90. MAINTENANCE REMOVED AND REPLACED GUSSET ADJACENT TO FRAME 90 IAW EMB 175 SRM 51-41-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.Sep 18, 2012 · N104HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A201209180508Gusset · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND CORROSION ON GUSSET ADJACENT TO FRAME 90. MAINTNENACE REMOVED AND REPLACED GUSSET ADJACENT TO FRAME 90 IAW EMB 175 SRM 51-41-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.Sep 18, 2012 · N104HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A201209180507Gusset · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND CORROSION ON GUSSET ADJACENT TO FRAME 90. MAINTENACE REMOVED AND REPLACED GUSSET ADJACENT TO FRAME 90 IAW EMB 175 SRM 51-41-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.Sep 18, 2012 · N104HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A201209170518Structure · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND SEAL REST FORWARD CARGO DOOR CORRODED. MAINTENANCE REMOVED AND REPLACED THE LOWER CENTER SEAL REST FORWARD CARGO DOOR IAW EMB 175 SRM 51-41-01, AND 51-40-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.Sep 17, 2012 · N104HQ · Emb ERJ170200LR · Cargo/Baggage DoorsSDR R61A201209180513Structure · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND UPPER SHEET 2 FRAME 86 CORRODED. MAINTENANCE REMOVED AND REPLACED UPPER SHEET 2 FRAME 86 IAW EMB 175 SRM 51-41-01, AND 51-43-03. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.Sep 13, 2012 · N104HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A201202170103Sensor · failedCREW REPORTED SLAT FAIL MESSAGE DURING CLIMB, AND DECLARED AN EMERGENCY AND DIVERTED. ACFT LANDED WITHOUT INCIDENT. MAINTENANCE REMOVED AND REPLACED RT OTBD 3/4 SLAT SKEW SENSOR PER AMM, OPS CHECK GOOD.Feb 17, 2012 · N104HQ · Emb ERJ170200LR · Leading Edge Slat Position Indicating SystemSDR R61A201202170102Sensor · failedCREW REPORTED SLAT FAIL MESSAGE DURING CLIMB, AND DECLARED AN EMERGENCY AND DIVERTED. ACFT LANDED WITHOUT INCIDENT. MAINTENANCE REMOVED AND REPLACED RT OTBD 2/3 SLAT SKEW SENSOR PER AMM, OPS CHECK GOOD.Feb 17, 2012 · N104HQ · Emb ERJ170200LR · Leading Edge Slat Position Indicating SystemSDR R61A201202170101Sensor · failedCREW REPORTED SLAT FAIL MESSAGE DURING CLIMB, AND DECLARED AN EMERGENCY AND DIVERTED. ACFT LANDED WITHOUT INCIDENT. MAINTENANCE REMOVED AND REPLACED LT OTBD 3/4 SLAT SKEW SENSOR PER AMM, OPS CHECKED GOOD.Feb 17, 2012 · N104HQ · Emb ERJ170200LR · Leading Edge Slat Position Indicating SystemSDR R61A201202170100Sensor · failedCREW REPORTED SLAT FAIL MESSAGE DURING CLIMB, AND DECLARED AN EMERGENCY AND DIVERTED TO DCA. ACFT LANDED WITHOUT INCIDENT. MAINTENANCE REMOVED AND REPLACED LT OTBD 2/3 SLAT SKEW SENSOR PER AMM, OPS CHECKED GOOD.Feb 17, 2012 · N104HQ · Emb ERJ170200LR · Leading Edge Slat Position Indicating SystemSDR R61A20110271Sensor · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND RT WING SLAT NR 2 SLAT SKEW SENSOR WIRE HARNESS IS FRAYED AND CORROSION FOUND ON CONNECTORS P0888 & J0888. MX REMOVED AND REPLACED RT WING SLAT NR 2 SLAT SKEW SENSOR IAW EMB 175 AMM 27-83-07 P/N 171-13508-401 OPS CHECKEDSep 20, 2011 · N104HQ · Emb ERJ170200LR · Leading Edge Slat Position Indicating SystemSDR R61A20110269Rivet · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, MAINTENANCE FOUND CORROSION AROUND FASTENER HEADS ON SHEAR PLATES AT FRAME 87. MAINTENANCE REMOVED AND REPLACED FASTENERS IAW EMB 175 SRM 51-42-01. CORROSION WAS LIMITED TO FASTENER HEADS ONLY. THE AIRCRAFT REMAINS OUTSep 16, 2011 · N104HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A20110152Power Unit · inoperativeCREW REPORTED AFT GALLEY EMERGENCY LIGHT WOULDN'T POWER UP. MAINTENANCE REMOVED AND REPLACED ELPU NR 3 PER EMB AMM.Jun 19, 2011 · N104HQ · Emb ERJ170200LR · Emergency LightingSDR R61A20110030Wire Harness · defectiveCREW RECEIVED FIRE ENGINE NR 2 WARNING ON CLIMBOUT, ENGINE WAS SHUT DOWN AND FIRE BOTTLE B WAS USED. CREW THEN DECLARED EMERGENCY AND RTF. A/C LANDED UNEVENTFULLY, CABIN WAS NOT PREPARED. MX REPLACING HARNESSES 170-27633-401, 171-01016-401, AND 171-08605-4Feb 4, 2011 · N104HQ · Emb ERJ170200LR · Fire Protection System WiringSDR R61A20110021Connector · looseCREW REPORTED E-2 FIRE MSG ON EICAS DURING CLIMB, CREW DECLARED AN EMERGENCY AND DIVERTED TO PHL AND LANDED WITHOUT INCIDENT. MAINTENANCE TROUBLESHOT PER EMB AMM AND RE-SECURED CONNECTOR P2156 AND P2167, OPS CHECK GOOD.Feb 3, 2011 · N104HQ · Emb ERJ170200LR · Fire Protection System WiringSDR R61A20090080Battery · dischargedCREW REPORTS FWD CABIN EMERGENCY LIGHTS WILL NOT COME ON. MAINTENANCE REMOVED AND REPLACED THE NR 1 ELPU PER EMB AMM. A/C WAS THEN RETURNED TO SERVICE.Nov 16, 2009 · N104HQ · Emb ERJ170200LR · Emergency Lighting
Back to N104HQ