# Cancelled registrations: Ferndale, WA

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

Cancelled aircraft registrations in Ferndale, WA.

- [N2274G](https://openairdocs.org/deregistered/N2274G-2023-05-10.md): Cessna 414 · S/N 414-0268 · Cancelled May 10, 2023 · Exported to Mexico · Hernandez Martin
- [N9461G](https://openairdocs.org/deregistered/N9461G-2022-09-03.md): Cessna U206F · S/N U20603211 · Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 1976 · Million Air Co
- [N741MR](https://openairdocs.org/deregistered/N741MR-2019-11-04.md): DJI INSPIRE 1 · S/N W13DCE05030894 · Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Oconnor Richard A
- [N361MC](https://openairdocs.org/deregistered/N361MC-2019-01-17.md): DJI PHANTOM 2 · S/N 636052919 · Cancelled Jan 17, 2019 · Registration expired, pending cancellation · Imco General Construction Inc
- [N73NW](https://openairdocs.org/deregistered/N73NW-2018-03-07.md): Northwing NAVAJO · S/N 78201 · Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 2006 · Robison Ron C
- [N4232L](https://openairdocs.org/deregistered/N4232L-2014-12-02.md): Baxter-Wilson C W CHAMP-3 · S/N 81-759 · Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1983 · Hunt John F
- [N420JS](https://openairdocs.org/deregistered/N420JS-2014-11-24.md): Siai-Marchetti SM 1019 · S/N 055 · Cancelled Nov 24, 2014 · Exported to Canada · Built 1978 · Starline Installations Inc
- [N4653C](https://openairdocs.org/deregistered/N4653C-2013-09-16.md): Cessna 170B · S/N 25597 · Cancelled Sep 16, 2013 · Exported to Canada · Built 1953 · Manly Robert E
- [N4506J](https://openairdocs.org/deregistered/N4506J-2013-07-19.md): Piper PA-28R-180 · S/N 28R-30361 · Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1968 · Ayres Robert F
- [N8404L](https://openairdocs.org/deregistered/N8404L-2013-05-14.md): Cessna 172I · S/N 17256604 · Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1968 · Gerber Everett G
- [N6008V](https://openairdocs.org/deregistered/N6008V-2013-04-25.md): Consolidated Aeronautics LAKE LA-4-200 · S/N 763 · Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1976 · Roberts Doris E
- [N93LH](https://openairdocs.org/deregistered/N93LH-2013-03-25.md): Herrick Analyn FISHER 404 EXP · S/N 4137 · Cancelled Mar 25, 2013 · Sale reported, canceled
- [N3962L](https://openairdocs.org/deregistered/N3962L-2013-01-18.md): Lunde Duane J QUICKSILVER MXII · S/N 1184 · Cancelled Jan 18, 2013 · Exported to Mexico · Built 1984 · Soderblom Edward J
- [N1099Z](https://openairdocs.org/deregistered/N1099Z-2006-06-22.md): Roberts William TUKAN · S/N WR803 · Cancelled Jun 22, 2006 · Roberts William R
- [N5107U](https://openairdocs.org/deregistered/N5107U-2004-09-24.md): Balloon Works FIREFLY 7 · S/N 11095 · Cancelled Sep 24, 2004 · Triennial form not returned · Built 1981 · Nichols Beverly E
- [N48PC](https://openairdocs.org/deregistered/N48PC-2003-01-07.md): Cullman Paul T LANCAIR 235 · S/N 121 · Cancelled Jan 7, 2003 · Triennial form not returned · Cullman Paul T
- [N9554H](https://openairdocs.org/deregistered/N9554H-1993-10-01.md): Cessna 172M · S/N 17266225 · Cancelled Oct 1, 1993 · Triennial form not returned · Hodges James A
- [N97642](https://openairdocs.org/deregistered/N97642-1980-04-16.md): Cessna 182Q · S/N 182-67155 · Cancelled Apr 16, 1980 · Exported to Chile · Loofbourow John C
- [N4596C](https://openairdocs.org/deregistered/N4596C-1977-06-15.md): Cessna 170B · S/N 25540 · Cancelled Jun 15, 1977 · Exported to Canada · Built 1953 · Harper Gerald E
- [N7911Z](https://openairdocs.org/deregistered/N7911Z-1973-07-23.md): Cessna 150C · S/N 15060011 · Cancelled Jul 23, 1973 · Exported to Canada · Russ Zimmerman
- [N12746](https://openairdocs.org/deregistered/N12746-1934-08-31.md): MT Baker Glider Club PRIMARY GLIDER · S/N 32 · Cancelled Aug 31, 1934 · Built 1932 · Mt Baker Glider Club

## 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 = 'FERNDALE'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-place/WA/Ferndale/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.
