OpenAirDocs.org
Crystal, MN

Registered aircraft · 47

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

Query with SQL
duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N100JGPiper PA-32R-301 · S/N 3213019Built 1988 · Club Cherokee IncN1052TMaule MX-7-180A · S/N 20054CSale reportedBuilt 1998N1108TCirrus Design SR20 · S/N 2114Sale reportedBuilt 2011N118TCostruzioni Aeronautiche Tecna P2010 · S/N 144/USSale reportedBuilt 2021N144TMMeeker Thomas O MUSTANG II · S/N M-II-1898Sale reported, pending cancellationBuilt 2004N150FJCessna 150J · S/N 15071001Sale reportedBuilt 1969N2083DPiper PA-44-180 · S/N 44-7995126Sale reportedBuilt 1978N2252YCessna 177 · S/N 17700052Built 1967 · Meisch Robert LN24363Cessna 152 · S/N 15280235Sale reported, canceledBuilt 1977N251LMLou Malinchak TITAN T-51D · S/N M07SV6S0HK0127Sale reportedBuilt 2015N2904RPiper PA-28-236 · S/N 28-7911237Club Cherokee IncN3151NCessna 120 · S/N 13409Built 1947 · Wayman RichardN33739Piper PA-34-200T · S/N 34-7570154Sale reportedBuilt 1975N3408XMooney M20E · S/N 1111Built 1966 · Heid Jason AN354DMStevens Mark ZENITH CH 601XL · S/N 6092Sale reported, canceledBuilt 2020N367GHGrays Harbor Chapter 367 EVANS VP-2 · S/N 1282Johnson Daniel DN44KDPiper PA-28R-200 · S/N 28R-7235106Sale reported, canceledBuilt 1972N4533XPiper PA-28-181 · S/N 28-7690031Sale reported, pending cancellationBuilt 1975N4754Vans RV-12 · S/N 120531Sale reported, pending cancellationBuilt 2017N4784JBeech A23-19 · S/N MB-220Sale reportedBuilt 1967N485DACirrus Design SR20 · S/N 1830Sale reportedBuilt 2007N50457Cessna 177RG · S/N 177RG1133Built 1977 · Odyssey Entertainment IncN5080JCessna 310R · S/N 310R0200Sale reported, pending cancellationBuilt 1975N5746UPiper PA-28-140 · S/N 28-26567Sale reportedBuilt 1969N610CCPiper PA-28-151 · S/N 28-7615140Built 1976 · Club Cherokee IncN641CCPiper PA-28-181 · S/N 28-7890493Built 1978 · Club Cherokee IncN66146Buckeye BREEZE LX · S/N 16506Becht RichardN6774ECessna 175A · S/N 56274Registration pendingBuilt 1959N7068LCessna 310K · S/N 310K0168Sale reported, pending cancellationBuilt 1966N7250QCessna 172L · S/N 17260550Sale reported, pending cancellationBuilt 1972N7345RBeech 95-B55 (T42A) · S/N TC-1707Sale reportedBuilt 1974N833DWWittman D R/Wittman D M WITTMAN RV6 · S/N 23207Sale reported, canceledBuilt 2003N8376WPiper PA-28-180 · S/N 28-2576Sale reportedN8385QPiper PA-32-301 · S/N 32-8106064Built 1981 · Blue Sky Harbors LLCN8440DPiper PA-22-160 · S/N 22-5695Built 1957 · Akn IncN845DPiper PA-28-236 · S/N 28-8211029Built 1982 · Club Cherokee IncN8877DPiper PA-22-160 · S/N 22-6051Sale reportedBuilt 1958N888WVNorth American T-6G · S/N 49-3401ASale reported, pending cancellationBuilt 1951N8927BCessna 172 · S/N 36627Sale reportedN8EVRuys Nicholas G RV-8 · S/N 80568Sale reportedBuilt 1999N9031HGerding Lewis J SONERAI-II · S/N 531Johnson Daniel DN9153YMooney M20M · S/N 27-0125Built 1991 · Akn IncN9157JMooney M20M · S/N 27-0131Built 1992 · Akn IncN93TJPiper PA-28R-200 · S/N 28R-35026Sale reportedBuilt 1969N94342Engineering & Research 415-C · S/N 1565Sale reportedBuilt 1946N9461CPiper PA-28-181 · S/N 28-7890412Built 1978 · Club Cherokee IncN97KMChampion AERONCA 7FC · S/N 422Sale reportedBuilt 1960
Back to Crystal, MN