# Registered aircraft: Crystal, MN

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

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

- [N100JG](https://openairdocs.org/aircraft/N100JG.md): Piper PA-32R-301 · S/N 3213019 · Built 1988 · Club Cherokee Inc
- [N1052T](https://openairdocs.org/aircraft/N1052T.md): Maule MX-7-180A · S/N 20054C · Sale reported · Built 1998
- [N1108T](https://openairdocs.org/aircraft/N1108T.md): Cirrus Design SR20 · S/N 2114 · Sale reported · Built 2011
- [N118T](https://openairdocs.org/aircraft/N118T.md): Costruzioni Aeronautiche Tecna P2010 · S/N 144/US · Sale reported · Built 2021
- [N144TM](https://openairdocs.org/aircraft/N144TM.md): Meeker Thomas O MUSTANG II · S/N M-II-1898 · Sale reported, pending cancellation · Built 2004
- [N150FJ](https://openairdocs.org/aircraft/N150FJ.md): Cessna 150J · S/N 15071001 · Sale reported · Built 1969
- [N2083D](https://openairdocs.org/aircraft/N2083D.md): Piper PA-44-180 · S/N 44-7995126 · Sale reported · Built 1978
- [N2252Y](https://openairdocs.org/aircraft/N2252Y.md): Cessna 177 · S/N 17700052 · Built 1967 · Meisch Robert L
- [N24363](https://openairdocs.org/aircraft/N24363.md): Cessna 152 · S/N 15280235 · Sale reported, canceled · Built 1977
- [N251LM](https://openairdocs.org/aircraft/N251LM.md): Lou Malinchak TITAN T-51D · S/N M07SV6S0HK0127 · Sale reported · Built 2015
- [N2904R](https://openairdocs.org/aircraft/N2904R.md): Piper PA-28-236 · S/N 28-7911237 · Club Cherokee Inc
- [N3151N](https://openairdocs.org/aircraft/N3151N.md): Cessna 120 · S/N 13409 · Built 1947 · Wayman Richard
- [N33739](https://openairdocs.org/aircraft/N33739.md): Piper PA-34-200T · S/N 34-7570154 · Sale reported · Built 1975
- [N3408X](https://openairdocs.org/aircraft/N3408X.md): Mooney M20E · S/N 1111 · Built 1966 · Heid Jason A
- [N354DM](https://openairdocs.org/aircraft/N354DM.md): Stevens Mark ZENITH CH 601XL · S/N 6092 · Sale reported, canceled · Built 2020
- [N367GH](https://openairdocs.org/aircraft/N367GH.md): Grays Harbor Chapter 367 EVANS VP-2 · S/N 1282 · Johnson Daniel D
- [N44KD](https://openairdocs.org/aircraft/N44KD.md): Piper PA-28R-200 · S/N 28R-7235106 · Sale reported, canceled · Built 1972
- [N4533X](https://openairdocs.org/aircraft/N4533X.md): Piper PA-28-181 · S/N 28-7690031 · Sale reported, pending cancellation · Built 1975
- [N4754](https://openairdocs.org/aircraft/N4754.md): Vans RV-12 · S/N 120531 · Sale reported, pending cancellation · Built 2017
- [N4784J](https://openairdocs.org/aircraft/N4784J.md): Beech A23-19 · S/N MB-220 · Sale reported · Built 1967
- [N485DA](https://openairdocs.org/aircraft/N485DA.md): Cirrus Design SR20 · S/N 1830 · Sale reported · Built 2007
- [N50457](https://openairdocs.org/aircraft/N50457.md): Cessna 177RG · S/N 177RG1133 · Built 1977 · Odyssey Entertainment Inc
- [N5080J](https://openairdocs.org/aircraft/N5080J.md): Cessna 310R · S/N 310R0200 · Sale reported, pending cancellation · Built 1975
- [N5746U](https://openairdocs.org/aircraft/N5746U.md): Piper PA-28-140 · S/N 28-26567 · Sale reported · Built 1969
- [N610CC](https://openairdocs.org/aircraft/N610CC.md): Piper PA-28-151 · S/N 28-7615140 · Built 1976 · Club Cherokee Inc
- [N641CC](https://openairdocs.org/aircraft/N641CC.md): Piper PA-28-181 · S/N 28-7890493 · Built 1978 · Club Cherokee Inc
- [N66146](https://openairdocs.org/aircraft/N66146.md): Buckeye BREEZE LX · S/N 16506 · Becht Richard
- [N6774E](https://openairdocs.org/aircraft/N6774E.md): Cessna 175A · S/N 56274 · Registration pending · Built 1959
- [N7068L](https://openairdocs.org/aircraft/N7068L.md): Cessna 310K · S/N 310K0168 · Sale reported, pending cancellation · Built 1966
- [N7250Q](https://openairdocs.org/aircraft/N7250Q.md): Cessna 172L · S/N 17260550 · Sale reported, pending cancellation · Built 1972
- [N7345R](https://openairdocs.org/aircraft/N7345R.md): Beech 95-B55 (T42A) · S/N TC-1707 · Sale reported · Built 1974
- [N833DW](https://openairdocs.org/aircraft/N833DW.md): Wittman D R/Wittman D M WITTMAN RV6 · S/N 23207 · Sale reported, canceled · Built 2003
- [N8376W](https://openairdocs.org/aircraft/N8376W.md): Piper PA-28-180 · S/N 28-2576 · Sale reported
- [N8385Q](https://openairdocs.org/aircraft/N8385Q.md): Piper PA-32-301 · S/N 32-8106064 · Built 1981 · Blue Sky Harbors LLC
- [N8440D](https://openairdocs.org/aircraft/N8440D.md): Piper PA-22-160 · S/N 22-5695 · Built 1957 · Akn Inc
- [N845D](https://openairdocs.org/aircraft/N845D.md): Piper PA-28-236 · S/N 28-8211029 · Built 1982 · Club Cherokee Inc
- [N8877D](https://openairdocs.org/aircraft/N8877D.md): Piper PA-22-160 · S/N 22-6051 · Sale reported · Built 1958
- [N888WV](https://openairdocs.org/aircraft/N888WV.md): North American T-6G · S/N 49-3401A · Sale reported, pending cancellation · Built 1951
- [N8927B](https://openairdocs.org/aircraft/N8927B.md): Cessna 172 · S/N 36627 · Sale reported
- [N8EV](https://openairdocs.org/aircraft/N8EV.md): Ruys Nicholas G RV-8 · S/N 80568 · Sale reported · Built 1999
- [N9031H](https://openairdocs.org/aircraft/N9031H.md): Gerding Lewis J SONERAI-II · S/N 531 · Johnson Daniel D
- [N9153Y](https://openairdocs.org/aircraft/N9153Y.md): Mooney M20M · S/N 27-0125 · Built 1991 · Akn Inc
- [N9157J](https://openairdocs.org/aircraft/N9157J.md): Mooney M20M · S/N 27-0131 · Built 1992 · Akn Inc
- [N93TJ](https://openairdocs.org/aircraft/N93TJ.md): Piper PA-28R-200 · S/N 28R-35026 · Sale reported · Built 1969
- [N94342](https://openairdocs.org/aircraft/N94342.md): Engineering & Research 415-C · S/N 1565 · Sale reported · Built 1946
- [N9461C](https://openairdocs.org/aircraft/N9461C.md): Piper PA-28-181 · S/N 28-7890412 · Built 1978 · Club Cherokee Inc
- [N97KM](https://openairdocs.org/aircraft/N97KM.md): Champion AERONCA 7FC · S/N 422 · Sale reported · Built 1960

## The whole list in SQL

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

```sql
SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_state = 'MN' AND g.registrant_city = 'CRYSTAL'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/MN/Crystal/aircraft

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