# Cancelled registrations: Anoka, MN

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

Cancelled aircraft registrations in Anoka, MN.

- [N5291K](https://openairdocs.org/deregistered/N5291K-2018-03-27.md): Ryan NAVION B · S/N NAV-4-2191-B · Cancelled Mar 27, 2018 · Registration expired, pending cancellation · Built 1950 · Navion Restoration Co LLC
- [N42056](https://openairdocs.org/deregistered/N42056-2018-03-08.md): Navion NAVION A · S/N 4-1771 · Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Navion Restoration Co LLC
- [N238AG](https://openairdocs.org/deregistered/N238AG-2018-02-15.md): Boeing 737-400 · S/N 23866 · Cancelled Feb 15, 2018 · Sale reported, canceled · Built 1988
- [N24256](https://openairdocs.org/deregistered/N24256-2017-11-22.md): Aeronca 65-LA · S/N L7239 · Cancelled Nov 22, 2017 · Revoked, canceled · Storvick Evans
- [N26388](https://openairdocs.org/deregistered/N26388-2017-10-28.md): Aeronca 60-TF · S/N 1080T · Cancelled Oct 28, 2017 · Revoked, canceled · Built 1940 · Sharp James M
- [N6311H](https://openairdocs.org/deregistered/N6311H-2014-11-12.md): Piper J3C-65 · S/N 19491 · Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1946 · Vadnais John G
- [N811C](https://openairdocs.org/deregistered/N811C-2013-05-13.md): Stinson 108-3 · S/N 108-3811 · Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1947 · Huyck Randall C
- [N5718E](https://openairdocs.org/deregistered/N5718E-2013-04-23.md): Raven Industries RALLY RX7 · S/N RX7-252 · Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1981 · Aircon Electric Corp
- [N3280A](https://openairdocs.org/deregistered/N3280A-2012-09-10.md): Cessna 170B · S/N 25924 · Cancelled Sep 10, 2012 · Sale reported, canceled · Built 1953
- [N2286T](https://openairdocs.org/deregistered/N2286T-2012-08-13.md): Petrik-Albert GYRACAR BG5 · S/N 1 · Cancelled Aug 13, 2012 · Sale reported, canceled
- [N1678D](https://openairdocs.org/deregistered/N1678D-2012-07-19.md): Cessna 170B · S/N 20320 · Cancelled Jul 19, 2012 · Sale reported, canceled · Built 1952
- [N2759](https://openairdocs.org/deregistered/N2759-2009-07-20.md): Regynski SCORPION · S/N 1001 · Cancelled Jul 20, 2009 · Registration revoked · Built 1972 · A 1 Machinery Erection Co
- [N95NL](https://openairdocs.org/deregistered/N95NL-2003-07-22.md): Aero Vodochody L-39 · S/N 031823 · Cancelled Jul 22, 2003 · Exported to South Africa · Built 1980 · Jet Aircraft Sales Inc
- [N5678D](https://openairdocs.org/deregistered/N5678D-2001-07-11.md): Raven S55A · S/N S55A-481 · Cancelled Jul 11, 2001 · Triennial form not returned · Cooley Charles J
- [N434RH](https://openairdocs.org/deregistered/N434RH-1996-10-15.md): Huyck Randall C TA-16 TROJAN · S/N 72 · Cancelled Oct 15, 1996 · Triennial form not returned · Huyck Randall C
- [N53056](https://openairdocs.org/deregistered/N53056-1984-12-27.md): Cessna 172P · S/N 17274675 · Cancelled Dec 27, 1984 · Snyder Clifford D
- [N60030](https://openairdocs.org/deregistered/N60030-1981-06-25.md): Cessna 150J · S/N 15070017 · Cancelled Jun 25, 1981 · Anoka Aero Inc
- [N60541](https://openairdocs.org/deregistered/N60541-1981-05-15.md): Cessna 150J · S/N 15070387 · Cancelled May 15, 1981 · Horbal Brice M
- [N95306](https://openairdocs.org/deregistered/N95306-1977-02-11.md): Piper PA-28-140 · S/N 28-25881 · Cancelled Feb 11, 1977 · Exported to Canada · Built 1969 · Yesteryears Inc
- [N47907](https://openairdocs.org/deregistered/N47907-1955-11-18.md): Fairchild M-62A · S/N T42-1542 · Cancelled Nov 18, 1955 · Stimson J L David P Ward Don L Stimson Adrian Ward
- [N47403](https://openairdocs.org/deregistered/N47403-1955-10-10.md): Fairchild M-62A · S/N T42-1976 · Cancelled Oct 10, 1955 · Blackburn Bernard P Dale F Zopfi
- [N32838](https://openairdocs.org/deregistered/N32838-1954-10-25.md): Piper J3C-65 · S/N 5648 · Cancelled Oct 25, 1954 · Francis R Richards
- [N6502K](https://openairdocs.org/deregistered/N6502K-1954-09-01.md): Republic RC-3 · S/N 768 · Cancelled Sep 1, 1954 · Ferlaak Elmo B
- [N21872](https://openairdocs.org/deregistered/N21872-1945-02-08.md): Piper J3C-50 · S/N 2650 · Cancelled Feb 8, 1945 · Built 1938 · Pierce George W
- [N7165](https://openairdocs.org/deregistered/N7165-1933-02-08.md): Standard J-1 · S/N 700 SUB · Cancelled Feb 8, 1933 · Kinney Kirk N

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

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