# Service difficulty reports: N165HQ, cancelled Jun 1, 2016

A list on [N165HQ, cancelled Jun 1, 2016](https://openairdocs.org/deregistered/N165HQ-2016-06-01.md).

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

- [SDR R61A201509010636](https://openairdocs.org/sdr/R61A201509010636.md): Access Panel · corroded · Sep 1, 2015 · N165HQ · Emb ERJ190100IGW · Wing, Plate/Skin
  > DURING HEAVY CHECK, FOUND WING ACCESS PANEL NR 6511AB HARDWARE CORRODED. MAINTENANCE R & R WING ACCESS HARDWARE IAW AMM 20-10-05, PN SC8821.
- [SDR R61A2015083100608](https://openairdocs.org/sdr/R61A2015083100608.md): Floor Support · corroded · Aug 31, 2015 · N165HQ · Emb ERJ190100IGW · Fuselage Miscellaneous Structure
  > DURING HEAVY CHECK, FOUND AFT LAV FLOOR SUPPORT DOUBLER CORRODED. MAINTENANCE R & R FLOOR DOUBLER IAW AMM 20-10-01, PN 170-43464-01..
- [SDR R61A2015082800606](https://openairdocs.org/sdr/R61A2015082800606.md): Seat Track · corroded · Aug 28, 2015 · N165HQ · Emb ERJ190100IGW · Fuselage, Seat/Cargo Attach Fittings
  > DURING HEAVY CHECK, FOUND BETWEEN FRAMES 20-35, RT INBD SEAT TRACK CORRODED. MAINTENANCE R & RT INBD SEAT TRACK IAW SRM 51-43-03, 51-41-00, AND 51-40-06.
- [SDR R61A2015082600605](https://openairdocs.org/sdr/R61A2015082600605.md): Structure · corroded · Aug 26, 2015 · N165HQ · Emb ERJ190100IGW · Fuselage Main, Structure
  > DURING HEAVY CHECK, FOUND FR19, LT SIDE, Y-1206, SILL CORRODED AROUND CLIP NUT. MAINTENCE R & R LT SILL, PN 170-05662-001 IAW SRM 51-41-00, 51-21-01.
- [SDR R61A2015082400607](https://openairdocs.org/sdr/R61A2015082400607.md): Shear Plate · corroded · Aug 24, 2015 · N165HQ · Emb ERJ190100IGW · Fuselage Miscellaneous Structure
  > DURING HEAVY CHECK, FOUND RT CABIN FLOOR HORIZONTAL WEB CORRODED BETWEEN FRAME 87- 88 AT Y580.
- [SDR R61A2015081200604](https://openairdocs.org/sdr/R61A2015081200604.md): Seat Track · corroded · Aug 12, 2015 · N165HQ · Emb ERJ190100IGW · Fuselage, Seat/Cargo Attach Fittings
  > DURING HEAVY CHECK, FOUND FR19 LT INBD SEAT TRACK CORRODED. MAINTENANCE R & R THE SEAT TRACK IAW ETD2015-190-076149 DATED 8/19/15, PN 170-03264-001.
- [SDR R61A201508030524](https://openairdocs.org/sdr/R61A201508030524.md): Slide · no test · Aug 3, 2015 · N165HQ · Emb ERJ190100IGW · Escape Slide
  > DURING HEAVY CHECK, DURING OPS CHECK OF DEPLOYMENT OF EMERGENCY EXIT SLIDE ON JC R190-25-65-01-001. FOUND L2 DOOR SLIDE FAILED OPS CKS WHEN OPENED. PRESSURE RELEASE BARREL CONNECTOR FAILED TO SEPARATE CAUSING SLIDE TO NOT FULLY EXTEND OR DEPLOY. SLIDE, PN 10
- [SDR R61A201410221125](https://openairdocs.org/sdr/R61A201410221125.md): Battery Pack · inoperative · Oct 22, 2014 · N165HQ · Emb ERJ190100IGW · Emergency Lighting
  > CREW RECEIVED AN EMERGENCY LIGHT BATTERY FAULT MESSAGE. MAINTENANCE R & R MID CABIN RT EMERGENCY POWER PACK IAW AMM AND OPS CHECKED GOOD.
- [SDR R61A201402100262](https://openairdocs.org/sdr/R61A201402100262.md): Flashlight · missing · Feb 10, 2014 · N165HQ · Emb ERJ190100IGW · Emergency Equipment
  > CREW REPORTED THAT THE CAPTAIN`S FLASHLIGHT WAS MISSING. INSTALLED FLASHLIGHT IAW AMM.
- [SDR R61A201401070041](https://openairdocs.org/sdr/R61A201401070041.md): Line · corroded · Jan 7, 2014 · N165HQ · Emb ERJ190100IGW · Aircraft Fuel Distribution System
  > DURING HEAVY CHECK, CORROSION FOUND ON FUEL LINES LOCATED IN FUEL PANEL 621BB AREA. R & R FUEL LINES IAW 20-10-03, 20-10-13.
- [SDR R61A201401070040](https://openairdocs.org/sdr/R61A201401070040.md): Line · corroded · Jan 7, 2014 · N165HQ · Emb ERJ190100IGW · Aircraft Fuel Distribution System
  > DURING HEAVY CHECK, CORROSION FOUND ON FUEL LINE UNDER PANEL 621EB. R & R FUEL LINE IAW AMM 20-10-03, 20-10-13.
- [SDR R61A201401070034](https://openairdocs.org/sdr/R61A201401070034.md): Clamp · corroded · Jan 7, 2014 · N165HQ · Emb ERJ190100IGW · Fuel Storage
  > DURING HEAVY CHECK, CORROSION FOUND ON TWO CLAMPS, LT WING IN FUEL PANEL 521EB. R & R CLAMPS IAW AMM 20-10-13.
- [SDR R61A201401060029](https://openairdocs.org/sdr/R61A201401060029.md): Bulkhead · cracked · Jan 6, 2014 · N165HQ · Emb ERJ190100IGW · Fuselage Main, Bulkhead
  > DURING HEAVY CHECK, A CRACK WAS FOUND ON BULKHEAD JUST AFT OF MLG WHEEL WELL. REPAIRED BULKHEAD IAW SRM 53-04-02, REPAIR 51.
- [SDR R61A201401050043](https://openairdocs.org/sdr/R61A201401050043.md): Pan · cracked · Jan 5, 2014 · N165HQ · Emb ERJ190100IGW · Passenger Compartment Equipment
  > DURING HEAVY CHECK, FOUND SEAT PANS CRACKED. MX R & R SEAT PANS.
- [SDR R61A201401050031](https://openairdocs.org/sdr/R61A201401050031.md): Doubler · corroded · Jan 5, 2014 · N165HQ · Emb ERJ190100IGW · Fuselage Miscellaneous Structure
  > DURING HEAVY CHECK, WASTE BOX DOUBLER CORRODED. COMPLIED WITH SB 190-53-0056.
- [SDR R61A201401020042](https://openairdocs.org/sdr/R61A201401020042.md): Seat Track · corroded · Jan 2, 2014 · N165HQ · Emb ERJ190100IGW · Fuselage, Seat/Cargo Attach Fittings
  > DURING HEAVY CHECK, LEFT SEAT TRACK EXTENSION BETWEEN FRAMES 86-87 HAS SIGNS OF CORROSION. MAINTENANCE R & R SEAT TRACK IAW SRM 51-41-01, & 51-43-01.
- [SDR R61A201401020033](https://openairdocs.org/sdr/R61A201401020033.md): Nut · loose · Jan 2, 2014 · N165HQ · Emb ERJ190100IGW · Hydraulic System, Main
  > DURING HEAVY CHECK, RT WING HYDRAULIC LINE JAM NUT LOOSE ON SPAR 3 WITH POSSIBLE DAMAGE TO SPAR. MAINTENANCE REWORKED CHAFED AREA.025 MATERIAL LOSS AN ADDITIONAL WASHER WAS ADDED TO FWD SIDE OF SPAR.
- [SDR R61A201401020032](https://openairdocs.org/sdr/R61A201401020032.md): Floor Support · corroded · Jan 2, 2014 · N165HQ · Emb ERJ190100IGW · Fuselage Miscellaneous Structure
  > DURING HEAVY CHECK, FOUND RT FLOOR SUPPORT BETWEEN FRAMES 12-14 CORRODED. R & R FLOOR SUPPORT IAW SRM 51-40-02, 51-40-04, 51-41-02, 51-43-04.
- [SDR R61A201401020024](https://openairdocs.org/sdr/R61A201401020024.md): Shear Plate · corroded · Jan 2, 2014 · N165HQ · Emb ERJ190100IGW · Fuselage Miscellaneous Structure
  > DURING HEAVY CHECK, FOUND LT SHEAR PANEL BETWEEN FRAMES 87-88 CORRODED. MX R & R SHEAR PANEL IAW SRM 51-42-01, 51-42-02.
- [SDR R61A201401020023](https://openairdocs.org/sdr/R61A201401020023.md): Shear Plate · corroded · Jan 2, 2014 · N165HQ · Emb ERJ190100IGW · Fuselage Miscellaneous Structure
  > DURING HEAVY CHECK, FOUND CENTER FLOOR SHEAR PANEL BETWEEN FRAMES 87-88 CORRODED. MAINTENANCE R & R CENTER FLOOR SHEAR PANEL IAW SRM 51-42-01.
- [SDR R61A201401020022](https://openairdocs.org/sdr/R61A201401020022.md): Splice · corroded · Jan 2, 2014 · N165HQ · Emb ERJ190100IGW · Fuselage Miscellaneous Structure
  > DURING HEAVY CHECK, OTBD SPLICE PLATE RT SHEAR PANEL BETWEEN FRAMES 87-88 HAS SIGNS OF CORROSION. MX R & R OTBD SPLICE PLATE IAW SRM 51-40-02, 51-42-02.
- [SDR R61A201401020020](https://openairdocs.org/sdr/R61A201401020020.md): Shear Plate · corroded · Jan 2, 2014 · N165HQ · Emb ERJ190100IGW · Fuselage Miscellaneous Structure
  > DURING HEAVY CHECK, RT SHEAR PLATE BETWEEN FRAMES 87-88 HAS SIGNS OF CORROSION. R & R RT SHEAR PLATE BETWEEN FRAMES 87-88 IAW SRM 51-40-02, 51-42-01, 51-43-03.
- [SDR R61A201401020019](https://openairdocs.org/sdr/R61A201401020019.md): Doubler · corroded · Jan 2, 2014 · N165HQ · Emb ERJ190100IGW · Fuselage Miscellaneous Structure
  > DURING HEAVY CHECK, RT CENTER FLOOR DOUBLER ON FRAME 89 HAS SIGNS OF CORROSION. MAINTENANCE REMOVED AND INSTALLED DOUBLER IAW SRM 51-40-02, 51-43-01.
- [SDR R61A201401020018](https://openairdocs.org/sdr/R61A201401020018.md): Floor Support · corroded · Jan 2, 2014 · N165HQ · Emb ERJ190100IGW · Fuselage Miscellaneous Structure
  > DURING HEAVY CHECK, RT FLOOR SUPPORT AFT OF R2 DOOR HAS SIGNS OF CORROSION. MAINTENANCE R & R FLOOR SUPPORT IAW SRM 51-40-02, 51-43-01.
- [SDR R61A201401020017](https://openairdocs.org/sdr/R61A201401020017.md): Seat Track · corroded · Jan 2, 2014 · N165HQ · Emb ERJ190100IGW · Fuselage, Seat/Cargo Attach Fittings
  > DURING HEAVY CHECK, SEAT TRACK HAS SIGNS OF CORROSION FRAMES 85-86. MX R & R SEAT TRACK IAW SRM 51-41-01, 51-43-03.
- [SDR R61A201401020016](https://openairdocs.org/sdr/R61A201401020016.md): Doubler · corroded · Jan 2, 2014 · N165HQ · Emb ERJ190100IGW · Fuselage Main, Frame
  > DURING HEAVY CHECK, DOUBLER HAS SIGNS OF CORROSION ON FRAME 90. MAINTENANCE R & R DOUBLER IAW SRM 51-41-02.
- [SDR R61A201401020015](https://openairdocs.org/sdr/R61A201401020015.md): Sill · corroded · Jan 2, 2014 · N165HQ · Emb ERJ190100IGW · Fuselage Miscellaneous Structure
  > DURING HEAVY CHECK, LEFT SILL BETWEEN FRAMES 12-16 HAS SIGNS OF CORROSION. MX R & R LT SILL BETWEEN FRAMES 12-16 IAW SRM 51-40-02, 51-43-04, 51-41-02. PN 170-03275-005, SILL. AIRCRAFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.
- [SDR R61A201401020014](https://openairdocs.org/sdr/R61A201401020014.md): Floor Support · corroded · Jan 2, 2014 · N165HQ · Emb ERJ190100IGW · Fuselage Miscellaneous Structure
  > DURING HEAVY CHECK, RT FLOOR SUPPORT BETWEEN FRAMES 18 - 21, HAS SIGNS OF CORROSION. MX R & R RT FLOOR SUPPORT IAW SRM 51-40-02, 51-40-04, 51-41-02, 51-43-02.
- [SDR R61A201401020013](https://openairdocs.org/sdr/R61A201401020013.md): Seat Track · corroded · Jan 2, 2014 · N165HQ · Emb ERJ190100IGW · Fuselage, Seat/Cargo Attach Fittings
  > DURING HEAVY CHECK WAS REPORTED LEFT CENTER SEAT TRACK HAS SIGNS OF CORROSION FRAMES 13, 18. MAINTENANCE R & R LEFT CENTER SEAT TRACK IAW SRM 51-40-02, 51-40-01, 51-41-02, 51-43-03, 51-23-06 AND 20-67-00.
- [SDR R61A201401020012](https://openairdocs.org/sdr/R61A201401020012.md): Floor Support · corroded · Jan 2, 2014 · N165HQ · Emb ERJ190100IGW · Fuselage Miscellaneous Structure
  > DURING HEAVY CHECK, RT FLOOR REINFORCEMENT ON FRAME 84 HAS SIGNS OF CORROSION. MX REMOVED AND MATCH DRILLED INSTALLED RT FLOOR REINFORCEMENT ON FRAME 84 IAW SRM 51-40-02, 51-41-01. INSTALLED AND REMOVED IAW SWPM 20-67-00. PN 190652887-001 FLOOR SUPPORT. AC
- [SDR R61A201401020011](https://openairdocs.org/sdr/R61A201401020011.md): Seat Track · corroded · Jan 2, 2014 · N165HQ · Emb ERJ190100IGW · Fuselage, Seat/Cargo Attach Fittings
  > DURING HEAVY CHECK, RT CENTER SEAT TRACK HAS SIGNS OF CORROSION IN THE AREA OF FRAME 13. MAINTENANCE R & R RT CENTER SEAT TRACK IAW SRM 51-41-01, 51-41-02, 51-43-01, 51-43-02, 51-23-06
- [SDR R61A201312311353](https://openairdocs.org/sdr/R61A201312311353.md): Cover · cracked · Dec 31, 2013 · N165HQ · Emb ERJ190100IGW · Emergency Lighting
  > ALL EMERGENCY LIGHTS ARE DIRTY AND CRACKED. REPLACED CRACKED COVERS IAW AMM. OPS CHECKED GOOD.
- [SDR R61A201309150879](https://openairdocs.org/sdr/R61A201309150879.md): Light · damaged · Sep 15, 2013 · N165HQ · Emb ERJ190100IGW · Emergency Lighting
  > CREW REPORTED THAT THE EMERGENCY LIGHT STRIPS NEXT TO BOTH SEAT 1D AND IN FRONT OF THE FWD CLOSET APPEAR TO BE DAMAGED. MX INSTALLED SERVICEABLE EMERGENCY LIGHT STRIPS IAW AMM AND OPS CHECKED GOOD.
- [SDR R61A201306180548](https://openairdocs.org/sdr/R61A201306180548.md): Door Frame · dirty · Jun 18, 2013 · N165HQ · Emb ERJ190100IGW · Fuselage Main, Structure
  > CREW REPORTED LOUD WHISTLING NOISE COMING FROM THE LT EMERGENCY OVERWING EXIT DURING FLIGHT. AN EMERGENCY WAS NOT DECLARED AND PLANE LANDED WITHOUT INCIDENT. MX REMOVED LT OVERWING EXIT HATCH, INSPECTED SEAL AND NO DEFECTS FOUND. MX FOUND DEBRIS IN THE DOOR
- [SDR R61A201303220292](https://openairdocs.org/sdr/R61A201303220292.md): Battery · discharged · Mar 22, 2013 · N165HQ · Emb ERJ190100IGW · Emergency Equipment
  > CREW REPORTED THAT THE FIRST OFFICERS FLASHLIGHT WAS NOT CHARGING. MAINTENANCE REMOVED AND REPLACED FIRST OFFICERS FLASHLIGHT, WOULD NOT ACCEPT CHARGE. MAINTENANCE REPLACED BATTERY IN NEW FLASHLIGHT ASSEMBLY PER EMB AMM AND OPS CHECKED GOOD.
- [SDR R61A201210160586](https://openairdocs.org/sdr/R61A201210160586.md): Slide · partial deploy · Oct 16, 2012 · N165HQ · Emb ERJ190100IGW · Escape Slide
  > CREW REPORTED THAT THE F/A OPENED THE L1 DOOR WHILE IT WAS STILL ARMED AND PARTIALLY BLEW THE EMERGENCY SLIDE. MAINTENANCE REPLACED THE SLIDE ASSY PER EMB AMM.
- [SDR R61A201209150497](https://openairdocs.org/sdr/R61A201209150497.md): Flashlight · inoperative · Sep 15, 2012 · N165HQ · Emb ERJ190100IGW · Emergency Equipment
  > CREW REPORTED F/O'S FLASHLIGHT DOES NOT ILLUMINATE. MAINTENANCE REMOVED AND REPLACED FLASHLIGHT PER AMM 33-51-0.
- [SDR R61A201207040342](https://openairdocs.org/sdr/R61A201207040342.md): Slide · unwanted deploy · Jul 4, 2012 · N165HQ · Emb ERJ190100IGW · Escape Slide
  > L1 DOOR SLIDE PARTIALLY DEPLOYED WHEN OPS OPENED THE DOOR AT THE JETBRIDGE.
- [SDR R61A201205170290](https://openairdocs.org/sdr/R61A201205170290.md): Flap · out of adjust · May 17, 2012 · N165HQ · Emb ERJ190100LR · Service Doors
  > CREW REPORTED R1 VENT FLAP INOP. MAINTENANCE ADJUSTED AND RIGGED FLAPPER DOOR PER EMB AMM.
- [SDR R61A20120065](https://openairdocs.org/sdr/R61A20120065.md): Hydraulic Line · cracked · Jan 28, 2012 · N165HQ · Emb ERJ190100IGW · Hydraulic System, Main
  > CREW REPORTED THE NR 1 HYDRAULIC SYSTEM QUANTITY DROPPING FROM 18% TO 4% DURING FLIGHT. CREW DECLARED AN EMERGENCY AND DIVERTED. AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND A HYDRAULIC LINE CRACKED IN THE LEFT PYLON. MAINTENANCE REPLACED HYDRAULIC
- [SDR R61A20110299](https://openairdocs.org/sdr/R61A20110299.md): Slide · unwanted deploy · Oct 5, 2011 · N165HQ · Emb ERJ190100IGW · Escape Slide
  > GROUND CREW INADVERTENTLY DEPLOYED R2 DOOR ESCAPE SLIDE. SLIDE DEPLOYED NORMALLY. MAINTENANCE REMOVED AND REPLACED R2 DOOR ESCAPE SLIDE PER EMB AMM, OPS CHECK GOOD.
- [SDR R61A20110182](https://openairdocs.org/sdr/R61A20110182.md): Warning System · false activation · Jul 11, 2011 · N165HQ · Emb ERJ190100LR · Door Warning System
  > CREW REPORTED LT DOOR EMERGENCY OPEN EICAS MESSAGE AFTER TAKEOFF. AN EMERGENCY WASN'T DECLARED, AND THE A/C LANDED WITHOUT INCIDENT AT MCI. MAINTENANCE PERFORMED OPS CHECK OF LT EMERG EXIT DOOR PER EMB AMM, OPS CHECK GOOD.
- [SDR R61A20110125](https://openairdocs.org/sdr/R61A20110125.md): Oven · malfunctioned · May 23, 2011 · N165HQ · Emb ERJ190100LR · Buffet/Galleys
  > CREW REPORTED FWD OVEN WAS SMOKING WHEN USED IN FLIGHT, NO EMERGENCY WAS DECLARED AND THE AIRCRAFT LANDED WITHOUT INCIDENT AT DEN. MAINTENANCE PLACED ITEM ON NEF 25-92-008.
- [SDR R61A20100578](https://openairdocs.org/sdr/R61A20100578.md): Unknown · malfunctioned · Dec 27, 2010 · N165HQ · Emb ERJ190100LR · Emergency Lighting
  > CREW REPORTED TWICE AFTER POWER UP EMERGENCY LIGHTS CAME ON AND EMERGENCY LIGHT BATTERY FAULT ON EICAS. MX PERFORMED OPS CHECK OF ALL LIGHTS ON FA PANELS PER EMB AMM OPS CHECK NORMAL AC OK FOR SERVICE.
- [SDR R61A20100573](https://openairdocs.org/sdr/R61A20100573.md): Light · malfunctioned · Dec 23, 2010 · N165HQ · Emb ERJ190100LR · Emergency Lighting
  > CREW REPORTED EMERGENCY LIGHTS CAME ON IN FLIGHT. MX PERFORMED OPS CHECK OF LIGHT SWITCHES PER EMB AMM NO DEFECTS NOTED AC OK FOR SERVICE.
- [SDR R61A20100539](https://openairdocs.org/sdr/R61A20100539.md): Pin · unsecure · Nov 12, 2010 · N165HQ · Emb ERJ190100LR · Passenger/Crew Doors
  > CREW REPORTED L-1 DOOR WILL NOT OPEN. MX RE-SECURED PIN PER EMB AMM, OPS CHECK GOOD.
- [SDR R61A20100495](https://openairdocs.org/sdr/R61A20100495.md): Door · malfunctioned · Oct 20, 2010 · N165HQ · Emb ERJ190100LR · Emergency Exits
  > CREW REPORTED DOOR EMERGENCY RT OPEN OVERWING EXIT EICAS DURING FLIGHT. A/C LANDED AT DEN WITHOUT INCIDENT. MAINTENANCE REMOVED AND RE-INSTALLED RIGHT OVERWING EXIT DOOR NO DEFECTS NOTED, REF EMB 190 AMM 52-21-00.
- [SDR R61A20100247](https://openairdocs.org/sdr/R61A20100247.md): Sensor · malfunctioned · Jun 7, 2010 · N165HQ · Emb ERJ190100LR · Leading Edge Slat Position Indicating System
  > CREW RETURNED TO FIELD AT DEN DUE TO SLAT FAIL DURING CLIMB, NO EMERGENCY DECLARED. MAINTENANCE REMOVED AND REPLACED RIGHT O/B 3/4 SKEW SENSOR PER EMB AMM, AND A/C WAS RETURNED TO SERVICE.
- [SDR R61A20100160](https://openairdocs.org/sdr/R61A20100160.md): A/C Pack · faulty · Apr 15, 2010 · N165HQ · Emb ERJ190100IGW · Cabin Cooling System
  > CREW REPORTED ELECTRICAL SMELL AT THE REAR OF THE CABIN, DECLARED AN EMERGENCY AND RETURNED TO OMA WITHOUT INCIDENT. MAINTENANCE TROUBLESHOT PER EMB AMM AND DETERMINED PACK NR 2 WAS AT FAULT AND PLACED ON MEL. A/C WAS THEN RETURNED TO SERVICE.
- [SDR R61A20090094](https://openairdocs.org/sdr/R61A20090094.md): Door · out of position · Dec 14, 2009 · N165HQ · Emb ERJ190100IGW · Emergency Exits
  > CREW REPORTED AN OVERWING EXIT OPEN LIGHT ON EICAS, RETURNED TO FIELD AT DEN AND LANDED WITHOUT INCIDENT, EMERGENCY WASN'T DECLARED. MAINTENANCE WAS DISPATCHED TO THE AIRCRAFT TO TROUBLESHOOT. MAINTENANCE FOUND THAT ONE OF THE OVERWING EXIT DOOR WAS PARTIALL

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 = 'N165HQ' AND deregistration_id = 'N165HQ-2016-06-01'
ORDER BY difficulty_date DESC
```

This list as a web page: https://openairdocs.org/deregistered/N165HQ-2016-06-01/reports

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.