N118HQ

Service difficulty reports · 134

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 = 'N118HQ' 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 R61A201708120614Mount Bracket · corrodedAFT CARGO AFT DRAIN MAST MOUNTING BRACKET AND RIVETS ARE CORRODED. REMOVED AND REPLACED THE DRAIN MAST MOUNTING BRACKET IAW SRM 51-41-01, SRM 51-41-02, ALODINED, PRIMED, AND TOPCOATED IAW SRM 51-23-04, 51-23-05, AND 51-23-06.Aug 12, 2017 · N118HQ · Emb ERJ170200LR · Fuselage Main, Attach FittingsSDR R61A201708120613Doubler · corrodedCORROSION FOUND ON THE SKIN DOUBLER AT WASTE BOX CUT OUT. REMOVED AND REPLACED WASTE BOX CUTOUT DOUBLER IAW SRM 51-43-03, AND 51-41-04.Aug 12, 2017 · N118HQ · Emb ERJ170200LR · Fuselage Main, Plate/SkinSDR R61A201708080586Shear Tie · corrodedSHEAR TIE AT FRAME 88 FROM STRINGERS 27R - 28R IS CORRODED. REMOVED AND REPLACED SHEAR TIE IAW SRM 51-41-01, AND 51-41-02.Jul 28, 2017 · N118HQ · Emb ERJ170200LR · Fuselage Internal Mounting StructureSDR R61A201708080588Seal Rest · corrodedAFT CARGO DOOR CUTOUT UNDER THE SCUFF PLATE HAS MINOR CORROSION ON THE FORWARD SEAL REST. REMOVED AND REPLACED AFT CARGO LOWER FORWARD SEAL REST. PN 170-85492-403 REF E175 AMM 20-10-07, SRM 51-21-02, 51-40-02, 51-40-04,51-23-04 AND SB 170-53-0104 ALODINED, PRJul 26, 2017 · N118HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A201708080587Seal Rest · corrodedAFT CARGO DOOR CUTOUT UNDER THE SCUFF PLATE HAS MINOR CORROSION ON THE CENTER SEAL REST. REMOVED AND REPLACED AFT CARGO LOWER CENTER SEAL REST. PN 170-85251-401 REF E175 SRM 51-41-01,51-23-06,51-23-04 AND SB 170-53-0104. ALODINED, PRIMED, AND TOPCOATED REF EMJul 26, 2017 · N118HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A201708080589Shear Tie · corrodedAFT CARGO SHEAR TIE AND RIVETS ARE CORRODED AT FRAME 87 BETWEEN STRINGERS 26R AND 27R. REMOVED AND REPLACED THE SHEAR IAW SRM 51-41-01, AND SRM 51-41-02. ALODINED, PRIMED, AND TOP COATED IAW SRM 51-23-04, 51-23-05, AND 51-23-06.Jul 25, 2017 · N118HQ · Emb ERJ170200LR · Fuselage Internal Mounting StructureSDR R61A201706230464Battery · dischargedEMERGENCY LIGHT IN COCKPIT WILL NOT COME ON. R & R EMERGENCY LIGHT BATTERY 1 IAW AMM 33-50-01. OPS CHECK IAW AMM 33-50-00. ALL OPS CHECKED GOOD.Jun 23, 2017 · N118HQ · Emb ERJ170200LR · Emergency LightingSDR R61A201704080271Wire Harness · damagedL1 DOOR INDICATION SHOWING YELLOW WITH BLACK X ON MFD STATUS PAGE WHEN DOOR IS CLOSED, ARMED, AND LOCKED. R & R THE FWD PASSENGER DOOR WARNING SENSOR HARNESS IAW AMM 52-72-20. OPS CHECK GOOD.Apr 8, 2017 · N118HQ · Emb ERJ170200LR · Door System WiringSDR R61A201611130652Warning Light · false activationDURING FLIGHT, CREW RECEIVED AN SPDA FAIL AND A FUEL FEED 1 FAULT ADVISORY MESSAGE. CREW RAN QRH AND NOTED THAT THE PACKS WERE OFF THE BLEED VALVE CLOSED. CABIN PRESSURE CONTINUED TO RISE, CREW DONNED OXYGEN MASKS AND PERFORMED EMERGENCY DESCENT. DIVERTED AND Nov 13, 2016 · N118HQ · Emb ERJ170200LR · Aircraft Fuel SystemSDR R61A201608050457Slide · deployedF/A CLOSED THE L1 DOOR AND THE DOOR ARMING AND VENT FLAP LEVERS WOULD NOT CLOSE. F/A OPENED THE L1 DOOR AND THE SLIDE DEPLOYED. MAINTENANCE R & R L1 DOOR SLIDE IAW AMM AND OPS CHECKED GOOD.Aug 5, 2016 · N118HQ · Emb ERJ170200LR · Escape SlideSDR R61A201511280882Torque Tube · failedAS CREW WAS RETRACTING THE FLAPS, RECEIVED A MASTER CAUTION FLAP FAIL MESSAGE. CREW RAN QRH, DECLARED AN EMERGENCY AND ELECTED TO RETURN TO DEPARTURE. LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED AND FOUND THE RT TORQUE TUBE HAD FALLEN OFF INBD SIDE OF THNov 28, 2015 · N118HQ · Emb ERJ170200LR · Trailing Edge Flap Control SystemSDR R61A201511200869Module · inoperativeFLYING, CREW RECEIVED PARKING BRAKE NOT RELEASED MESSAGE. CREW RAN QRH, DECLARED AN EMERGENCY AND DIVERTED. WITH EMERGENCY VEHICLES STANDING BY AND PASSENGERS BRACING, CREW LANDED WITHOUT INCIDENT. CREW TAXIED TO GATE WHERE PASSENGERS DEPLANNED NORMALLY. MANov 20, 2015 · N118HQ · Emb ERJ170200LR · TireSDR R61A201511190861Pressure Switch · malfunctionedDURING CHECK FLIGHT, CREW RECEIVED BRAKE DEFAULT MESSAGE FOLLOWED BY EMERGENCY BRAKE NOT RELEASED MESSAGE. CREW RAN QRH AND DECLARED AN EMERGENCY. ACFT LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED, R & R BRAKE CONTROL PRESSURE SWITCHES, AND TARGET LOADED Nov 19, 2015 · N118HQ · Emb ERJ170200LR · TireSDR R61A201511160844Connector · disconnectedWHILE IN HEAVY CHECK, MAINTENANCE REPORTED THAT THE PAX CABIN NR 3 CEILING EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCE PLUGGED IN PAX CABIN NR 3 CEILING EMERGENCY LIGHT IAW AMM AND OPS CHECKED GOOD.Nov 16, 2015 · N118HQ · Emb ERJ170200LR · Light System WiringSDR R61A201511090854Spar · corrodedDURING HEAVY CHECK, AFTER REAMING SPAR 3 HOLE, CF2 BULKHEAD DISCOVERED CRACKS IN BORE. MAINTENANCE RT WHEEL WELL SIDE FITTING OF SPAR 3 WING STUBS WAS REPAIRED IAW ETD 205-170-101371.Nov 9, 2015 · N118HQ · Emb ERJ170200LR · Wing SparSDR R61A201511070853Seal Rest · corrodedWHILE IN HEAVY CHECK WAS REPORTED THAT LWR FWD CARGO DOOR LOWER FWD SEAL REST IS CORRODED. MAINTENANCE R & R LWR FWD CARGO DOOR LOWER FWD SEAL REST IAW SRM 51-40-00, PN 170-66803-401, SEAL REST.Nov 7, 2015 · N118HQ · Emb ERJ170200LR · Cargo/Baggage DoorsSDR R61A201511070852Seal Rest · corrodedDURING HEAVY CHECK WAS REPORTED THAT FWD CARGO DOOR AFT LOWER SEAL REST IS CORRODED. MAINTENANCE R & R FWD CARGO DOOR AFT LOWER SEAL REST IAW SRM 51-40-00 SEAL REST, PN 170-66803-402.Nov 7, 2015 · N118HQ · Emb ERJ170200LR · Cargo/Baggage DoorsSDR R61A201511010855Spar · crackedDURING HEAVY CHECK, WAS REPORTED THAT AFTER REAMING HOLE ON LT SPAR 3, CF 2 BULKHEAD DISCOVERED CRACKS IN BORE. MAINTENANCE REPAIRED IAW ETD 205-170-101371.Nov 1, 2015 · N118HQ · Emb ERJ170200LR · Wing SparSDR R61A201511010851Support Bracket · crackedDURING HEAVY CHECK LT RAM AIR DUCT SUPPORT BRACKET IS CRACKED. MAINTENANCE R & R LT RAM AIR DUCT SUPPORT BRACKET IAW SRM 51-46-02, 51-41-01.Nov 1, 2015 · N118HQ · Emb ERJ170200LR · Air Distribution SystemSDR R61A201511010850Rib · crackedDURING HEAVY CHECK, WAS REPORTED THAT LT HORIZONTAL STABILIZER, RIB 12 FWD UPPER FLANG IS CRACKED. MAINTENCE PERFORMED PERMANENT REPAIR TO LT HORIZONTAL STABILIZER, RIB 12 FWD UPPER FLANGE IAW ETD 2015-170-102356.Nov 1, 2015 · N118HQ · Emb ERJ170200LR · Horizontal Stabilizer, Spar/RibSDR R61A201511010814Dampener · corrodedDURING HEAVY CHECK, L-2 DAMPENER IS CORRODED. MAINTENANCE R & R L-2 DAMPENER IAW AMM 51-12-27, PN SP-21619A, DAMPENER.Nov 1, 2015 · N118HQ · Emb ERJ170200LR · Passenger/Crew DoorsSDR R61A201511010804Rib · crackedDURING HEAVY CHECK, RT HORIZONTAL STABILIZER RIB 12 UPPER FLANGE IS CRACKED. MAINTENANCE PERFORMED A PERMANENT REPAIR IAW ETD 2015-170-101402.Nov 1, 2015 · N118HQ · Emb ERJ170200LR · Horizontal Stabilizer, Spar/RibSDR R61A201511010803Rib · crackedDURING HEAVY CHECK, LEFT HORIZONTAL STABILIZER, RIB 12 FWD UPPER FLANGE IS CRACKED. MAINTENANCE PERFORMED A PERMANENT REPAIR IAW ETD 2015-170-102356.Nov 1, 2015 · N118HQ · Emb ERJ170200LR · Horizontal Stabilizer, Spar/RibSDR R61A201510310849Nut · corrodedDURING HEAVY CHECK, L1 DOOR LOWER FWD DOOR STOP ON DOOR IS CORRODED. MAINTENANCE R & R L1 DOOR LOWER FWD DOOR STOP ON DOOR IAW AMM 52-11-23, PN NAS 509-7 L1 DOOR LOWER FWD DOOR STOP ON DOOR NUT.Oct 31, 2015 · N118HQ · Emb ERJ170200LR · Passenger/Crew DoorsSDR R61A201510310848Nut · corrodedHEAVY CHECK WAS REPORTED THAT FWD PASSENGER DOOR LOWER AFT DOOR STOP ON DOOR HARDWARE IS CORRODED. MAINTENANCE R & R FWD PASSENGER DOOR LOWER AFT DOOR STOP ON DOOR HARDWARE IAW AMM 52-11-23, PN NAS509-7, NUT.Oct 31, 2015 · N118HQ · Emb ERJ170200LR · Passenger/Crew DoorsSDR R61A201510310809Stop Fitting · corrodedDURING HEAVY CHECK, AFT PASSENGER DOOR, AFT LOWER DOOR STOP ON DOOR HARDWARE IS CORRODED. MAINTENANCE R & R AFT PASSENGER DOOR, AFT LOWER DOOR STOP ON DOOR HARDWARE IAW AMM 52-12-23, PN NAS509-7 NUT.Oct 31, 2015 · N118HQ · Emb ERJ170200LR · Passenger/Crew DoorsSDR R61A201510310808Stop Fitting · corrodedDURING HEAVY CHECK, AFT SERVICE DOOR FWD UPPER AND LOWER DOOR STOPS HARDWARE IS CORRODED. MAINTENANCE R & R AFT SERVICE DOOR FWD UPPER AND LOWER DOOR STOPS HARDWARE IAW AMM 52-42-00, PN NAS509-7, NUT.Oct 31, 2015 · N118HQ · Emb ERJ170200LR · Fuselage Main, StructureSDR R61A201510300813Shear Tie · corrodedDURING HEAVY CHECK, SHEAR CLIP AT WASTE BOX IS CORRODED. MAINTENANCE R & R SHEAR CLIP AT WASTE BOX IAW SRM 51-41-01.Oct 30, 2015 · N118HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A201510300812Structure · corrodedDURING HEAVY CHECK, WASTE SERVICE BOX IS CORRODED. MAINTENANCE R & R WASTE SERVICE BOX IAW SRM 51-43-02, PN 170-65078-405 WASTE BOX ASSY.Oct 30, 2015 · N118HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A201510300805Screw · corrodedDURING HEAVY CHECK, AFT PYLON FAIRING, AFT INBD SIDE HARDWARE IS CORRODED ON BONDING JUMPER. MAINTENANCE R & R AFT PYLON FAIRING, AFT INBD SIDE HARDWARE IAW AMM 20-13-21. PN NAS1861-3-9, SCREW.Oct 30, 2015 · N118HQ · Emb ERJ170200LR · Nacelle/Pylon, Main FrameSDR R61A201510290847Floorbeam · crackedDURING HEAVY CHECK, FLIGHT DECK FLOOR BRACKET AT FRAME 12 OTBD OF CAPTAIN`S LT SEAT TRACK IS CRACKED. MAINTENANCE R & R FLIGHT DECK FLOOR BRACKET AT FRAME 12 OTBD OF CAPTAIN`S LT SEAT TRACK IAW SRM 51-40-02, 51-41-01, PN 170-13238-001, BRACKET.Oct 29, 2015 · N118HQ · Emb ERJ170200LR · Fuselage Main, Floor BeamSDR R61A201510290846Floorbeam · crackedDURING HEAVY CHECK, FLIGHT DECK FLOOR SUPPORT BRACKET AT FRAME 12, AFT OF CONNECTOR PLUG IS CRACKED. MAINTENANCE R & R FLIGHT DECK FLOOR SUPPORT BRACKET AT FRAME 12 AFT OF CONNECTOR PLUG IAW SRM 51-40-02, 51-41-01, PN 170-16131-001, ANGLE.Oct 29, 2015 · N118HQ · Emb ERJ170200LR · Fuselage Main, Floor BeamSDR R61A201510290845Skin · corrodedDURING HEAVY CHECK, WASTE SERVICE DOOR ON INNER DOOR SKIN IS CORRODED. MAINTENANCE R & R WASTE SERVICE DOOR IAW AMM 28-10-01, PN 170-86668-403 DOOR.Oct 29, 2015 · N118HQ · Emb ERJ170200LR · Fluid Service DoorsSDR R61A201510290815Connector · crackedDURING HEAVY CHECK, FLIGHT DECK FLOOR SUPPORT BRACKET AT FRAME 12 AFT CONNECTOR PLUG IS CRACKED. MAINTENANCE R & R IAW SRM 51-40-02 AND 51-40-01. PN 170-16131-001 ANGLE.Oct 29, 2015 · N118HQ · Emb ERJ170200LR · Fuselage Main, Bulkhead Fuselage wiringSDR R61A201510290811O-Ring · damagedDURING HEAVY CHECK, EMERGENCY RAM AIR CHECK VALVE O-RING DAMAGED. MX R & R EMERGENCY RAM AIR CHECK VALVE O-RING IAW AMM 21-25-03, PN 24096-5001, O-RING.Oct 29, 2015 · N118HQ · Emb ERJ170200LR · Air Distribution SystemSDR R61A201510290810Firewall · crackedDURING HEAVY CHECK, 351BZ APU FIRE WALL HAS CRACK. MAINTENANCE REPAIRED BY TRIMMING OUT CRACK IAW SRM 53-31-21.Oct 29, 2015 · N118HQ · Emb ERJ170200LR · APU Cowling/ContainmentSDR R61A201510290806Tray · crackedDURING HEAVY CHECK, FLY BY WIRE BACK UP BATTERY TRAY FOUND CRACKED. MAINTENANCE R & R BATTERY TRAY IAW AMM 27-03-05 AND SM-1589-NE-06-0001.Oct 29, 2015 · N118HQ · Emb ERJ170200LR · Fuselage Main, StructureSDR R61A201510270807Stop Fitting · corrodedDURING HEAVY CHECK, AFT SERVICE DOOR STOP, BOTTOM FWD EDGE IS CORRODED. MAINTENANCE R & R AFT SERVICE DOOR STOP IAW AMM 52-42-00, PN NAS509-7, NUT.Oct 27, 2015 · N118HQ · Emb ERJ170200LR · Fuselage Main, StructureSDR R61A201506170374Lever · out of adjustCREW REPORTED THAT THE L2 DOOR WOULD NOT ARM. MAINTENANCE ADJUSTED THE L2 DOOR ARMING LEVER IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.Jun 17, 2015 · N118HQ · Emb ERJ170200LR · Emergency EquipmentSDR R61A201501020006Flashlight · inoperativeCREW REPORTED THAT THE F/O FLASHLIGHT WAS INOPERATIVE. R & R THE F/O FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.Jan 2, 2015 · N118HQ · Emb ERJ170200LR · Emergency EquipmentSDR R61A201412201253Flashlight · inoperativeCREW REPORTED THAT THE FORWARD F/A FLASHLIGHT WAS INOPERATIVE. R & R FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.Dec 20, 2014 · N118HQ · Emb ERJ170200LR · Emergency EquipmentSDR R61A201403110361Light · looseCREW REPORTED THAT THE EMERGENCY LIGHT IN THE FIRST CLASS SECTION WAS LIFTED UP. MAINTENANCE SECURED EMERGENCY LIGHT IAW AMM AND OPS CHECKED GOOD.Mar 11, 2014 · N118HQ · Emb ERJ170200LR · Emergency LightingSDR R61A201403080356Light · looseCREW REPORTED THAT THE EMERGENCY LIGHT WAS LOOSE. MAINTENANCE SECURED LIGHT IAW AMM AND OPS CHECKED GOOD.Mar 8, 2014 · N118HQ · Emb ERJ170200LR · Emergency LightingSDR R61A201401080035Indicator · out of adjustCREW REPORTED THAT THE L2 DOOR WOULD NOT ARM CORRECTLY. ADJUSTED INDICATOR FLAG ON DOOR IAW AMM AND OPS CHECKED GOOD. AIRCRAFT IS GOOD FOR SERVICE.Jan 8, 2014 · N118HQ · Emb ERJ170200LR · Emergency EquipmentSDR R61A201311251245Cable · brokenCREW REPORTED THAT THE L2 DOOR SLIDE WAS HANGING OUT OF DOOR. MAINTENANCE FOUND THE L2 SLIDE UNLACED WITH THE GIRT BAR STILL ENGAGED IN THE FLOOR AND THE FLEXBALL CABLE BROKEN. MAINTENANCE R & R THE FLEXBALL CABLE AND SLIDE ASSEMBLY IAW AMM. HOWEVER, WHEN THNov 25, 2013 · N118HQ · Emb ERJ170200LR · Escape SlideSDR R61A201311231233Cable · frozenR2 DOOR WILL NOT PROPERLY ARM. MX R & R R2 ARMING CABLE IAW AMM 52-12-40.Nov 23, 2013 · N118HQ · Emb ERJ170200LR · Emergency EquipmentSDR R61A201311171163Lever · dirtyCREW REPORTED THAT L1 DOOR INDICATION WAS NOT SHOWING CLOSED WITH HANDLES DOWN AND IN ADDITION, HAD A RED DOOR OPEN INDICATION IN THE COCKPIT. MAINTENANCE INSPECTED IAW AMM AND REMOVED DEBRIS FROM THE L1 DOOR FLAG LEVER AREA. L1 DOOR OPS CHECKS GOOD AND IS GONov 17, 2013 · N118HQ · Emb ERJ170200LR · Passenger/Crew DoorsSDR R61A2013110501115Door · bindingCREW REPORTED THAT THE L1 DOOR WAS HARD TO CLOSE. MAINTENANCE SECURED DOOR CLOSED IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.Nov 5, 2013 · N118HQ · Emb ERJ170200LR · Passenger/Crew DoorsSDR R61A201310281069Bolt · corrodedDURING HEAVY CHECK, LT PYLON 419DT HAS SEVERAL SCREWS ALONG TOP OF PANEL THAT ARE CORRODED. MX R & R CORRODED SCREWS ON LT PYLON PANEL 419DT IAW AMM 54-50-21.Oct 28, 2013 · N118HQ · Emb ERJ170200LR · Nacelle/Pylon, Main FrameSDR R61A201310201049Structure · corrodedDURING HEAVY CHECK, AFT GALLEY TRIM CORRODED ON BOTH MATTING SURFACES. MAINTENANCE R & R CORRODED AFT GALLEY TRIM ON BOTH MATTING SURFACES IAW AMM 25-0023 AND SRM 51-12-00.Oct 20, 2013 · N118HQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
Back to N118HQ