# Cancelled registrations: Forks, WA

A list on [Forks, WA](https://openairdocs.org/faa-place/WA/Forks.md).

Cancelled aircraft registrations in Forks, WA.

- [N31808](https://openairdocs.org/deregistered/N31808-2018-03-16.md): Roberts BENSEN B-8M · S/N 2001 · Cancelled Mar 16, 2018 · Revoked, canceled · Built 1972 · Roberts Robert E
- [N1096L](https://openairdocs.org/deregistered/N1096L-2014-11-19.md): Hughes Helicopters HUGHES 369D · S/N 800789D · Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1980 · Fairlane Helicopters Inc
- [N778ES](https://openairdocs.org/deregistered/N778ES-2013-10-28.md): Springer Ernest R KITFOX MKIV-1200 · S/N 1815 · Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Springer Ernest R
- [N54591](https://openairdocs.org/deregistered/N54591-2013-04-18.md): Sud SA 318C ALOUETTE AST · S/N 2194 · Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1972 · Aero Jet Helicopters Inc
- [N5234Y](https://openairdocs.org/deregistered/N5234Y-2012-10-29.md): Hughes Helicopters 369E · S/N 0167E · Cancelled Oct 29, 2012 · Third renewal notice · Fairlane Helicopters Inc
- [N5687F](https://openairdocs.org/deregistered/N5687F-2012-05-22.md): Alon A2 · S/N A-187 · Cancelled May 22, 2012 · Built 1966 · Robinson David E
- [N10966](https://openairdocs.org/deregistered/N10966-2003-07-29.md): Hughes Helicopters HUGHES 369D · S/N 1000818D · Cancelled Jul 29, 2003 · Second triennial mailing, no response · Built 1980 · Olympic Air Inc
- [N9203F](https://openairdocs.org/deregistered/N9203F-2001-03-29.md): Hughes 369HS · S/N 440584S · Cancelled Mar 29, 2001 · Exported to Canada · Heli-Logistics Inc
- [N9163F](https://openairdocs.org/deregistered/N9163F-1998-03-14.md): Hughes Helicopters HUGHES 369D · S/N 690540D · Cancelled Mar 14, 1998 · Triennial form not returned · Eagle Air Helicopters Inc
- [N59362](https://openairdocs.org/deregistered/N59362-1980-09-25.md): S N I A S SA 318C ALOUETTE AST · S/N 2222 · Cancelled Sep 25, 1980 · Exported to Canada · Aero Jet Helicopters Inc
- [N670D](https://openairdocs.org/deregistered/N670D-1977-07-14.md): Beech A35 · S/N D-15001 · Cancelled Jul 14, 1977 · Northwest Oil Co
- [N84388](https://openairdocs.org/deregistered/N84388-1974-07-11.md): Cessna 172K · S/N 17258455 · Cancelled Jul 11, 1974 · Exported to Canada · Gunter Shake Inc
- [N773D](https://openairdocs.org/deregistered/N773D-1970-06-17.md): Beech C35 · S/N D-3043 · Cancelled Jun 17, 1970 · Ulins Inc
- [N1450B](https://openairdocs.org/deregistered/N1450B-1965-04-02.md): Luscombe 8F · S/N 6077 · Cancelled Apr 2, 1965 · Exported to Canada · Built 1948 · Spoelstra Brothers Inc
- [N9479K](https://openairdocs.org/deregistered/N9479K-1956-10-11.md): Piper PA-32R-300 · S/N 108-2479 · Cancelled Oct 11, 1956 · Exported to Canada · Spoelstra Bros
- [N7444K](https://openairdocs.org/deregistered/N7444K-1956-02-15.md): Piper PA-20 · S/N 20-355 · Cancelled Feb 15, 1956 · Ulin Wilmer W

## The whole list in SQL

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

```sql
SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
WHERE d.registrant_state = 'WA' AND d.registrant_city = 'FORKS'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-place/WA/Forks/earlier

---
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.
