OpenAirDocs.org
Lake Elmo, MN

Registered aircraft · 57

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 = 'LAKE ELMO'
  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.

N110SPMonocoupe 110 · S/N 6W13Built 1931 · Holliday Mark EN129GRMarlon O Gunderson/Gary L Ried COZY MK316 · S/N GR01Built 2017 · Gunderson Marlon ON13658Cessna 172M · S/N 17262918Built 1974 · Lake Elmo Aero LLCN142PGPowrachute PEGASUS · S/N A142PEGBuilt 2003 · Larson Dennis KN1679HPiper PA-28-181 · S/N 28-7790331Lake Elmo Aero LLCN1945FCessna 172N · S/N 17273035Built 1979 · Lake Elmo Aero LLCN1975BLuscombe 8D · S/N 6402Built 1948 · Holliday Mark EN2016BLuscombe 8A · S/N 6443Holliday Mark EN20187Cessna 172M · S/N 17261080Dewitt Troy CN208RDDann R H/Jerritt A RV-9A · S/N 90178Built 2003 · Chase Donaven RayN2115DCessna 170B · S/N 26630Built 1979 · Raykowski Michael JN2224WPiper PA-28-236 · S/N 28-7911134Built 1979 · Tailwinds Flying ClubN2446BTemco GC-1B · S/N 3746Built 1950 · Holliday Mark EN2449BGlobe GC-1B · S/N 3749Built 1950 · Holliday Mark EN2506SCessna 210L · S/N 21061309Byers Roger GN274YDake Ewell H "Bud" P & W MULICOUPE · S/N JRY 03-2Built 1997 · Holliday Mark EN276YLuscombe 8A · S/N 2723Holliday Mark EN2899NPiper PA-32-300 · S/N 32-7940193Tailwinds Flying ClubN360GBeech 35-A33 · S/N CD-306Built 1961 · Bergmann Keith AN3658LCessna 172G · S/N 17253827Built 1965 · Graczyk Michael EN3692XBeech 76 · S/N ME-369Built 1981 · Lake Elmo Aero LLCN424MGGunderson Marion SKY RAIDER II · S/N 019Gunderson Marlon ON430KPPeterson Keith L RV-3 · S/N 10430Built 2004 · Chase Donaven RN44650Piper PA-28-235 · S/N 28-7410104Stoudt Daniel JN461DRTl-Ultralight S R O TL 2000 STING S4 · S/N 24 ST 510Built 2024 · Delta Romeo Aviation LLCN518PMCirrus Design SR22T · S/N 9517Built 2023 · Northtone LLCN5408HCessna 172M · S/N 17265427Built 1975 · Schmidt Kelly DN542FRoy A Farris THORP T-18 · S/N 542Built 2022 · Cooper NinaN5505HBellanca 7GCBC · S/N 1038-78Built 1978 · Kupferschmidt W Alan TrusteeN5540WPiper PA-28-160 · S/N 28-631Built 1962 · Air-Crete Constructions IncN5613CCessna 140A · S/N 15546Built 1950 · Holliday Mark EN5630ECessna 150 · S/N 17130Built 1959 · Holliday Mark EN58484Cessna 182P · S/N 18262094Built 1973 · Centurion Enterprises IncN597LPiper PA-30 · S/N 30-575Dewitt Troy CN610GBCirrus Design SR22T · S/N 0444Built 2013 · Sierra Zulu Aircraft Holdings LLCN61879Cessna 172M · S/N 17264864Built 1975 · Lake Elmo Aero LLCN643RPPurvis Ronald E RANS S-4 COYOTE · S/N 503317Built 2007 · Bolles Bruce JN6841MSedlock Jeffrey M VANS RV-9A · S/N 90274Built 2009 · Gwiazdon Edward PN68736Cessna 152 · S/N 15282346Lake Elmo Aero LLCN69066Cessna 152 · S/N 15282470Built 1978 · Lake Elmo Aero LLCN70413Cessna 172M · S/N 17267217Built 1976 · Lake Elmo Aero LLCN737MECessna 172N · S/N 17269516Lake Elmo Aero LLCN737YUCessna 172N · S/N 17269785Built 1977 · Lake Elmo Aero LLCN7429YPiper PA-30 · S/N 30-489Built 1964 · Dewitt Troy CN757LECessna 172M · S/N 17266022Lake Elmo Aero LLCN78069Globe GC-1B · S/N 2069Built 1946 · Holliday Mark EN78218Globe GC-1B · S/N 2218Built 1946 · Holliday Mark EN78225Globe GC-1B · S/N 2225Built 1946 · Holliday Mark EN78849Aircraft Manufacturing TEXAS BULLET 205 · S/N 103Built 1950 · Holliday Mark EN7DKnight Twister 125 · S/N D-1Built 1951 · Holliday Mark E
Back to Lake Elmo, MN