OpenAirDocs.org
Lodi, WI

Registered aircraft · 21

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 = 'WI' AND g.registrant_city = 'LODI'
  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.

N1683YCessna 172C · S/N 17249383Built 1962 · Knutson Daniel TN1805EAeronca 7AC · S/N 7AC-5372Neander Steven AN1925EAeronca 7AC · S/N 7AC-5492Built 1946 · Knutson Daniel TN209FUEa Vision EA J100 · S/N 85738Registration pendingN30758Piper J3C-65 · S/N 5092Built 1940 · Knutson Daniel TN3232ACessna 170B · S/N 25876Built 1953 · Knutson Daniel TN32808Piper PA-28-151 · S/N 28-7515247Strander Chad AN4155AEa Vision EA J100 · S/N 85391Registration pendingN4320APiper PA-22-150 · S/N 22-3672Knutson Daniel TN438HDEa Vision EA J100 · S/N 85553Registration pendingN4602HHylio HYL-150 · S/N 17906110403Registration pendingN462BHHylio HYL-150 · S/N 17906110404Registration pendingN462WLHylio HYL-150 · S/N 17906110405Registration pendingN4694AEa Vision EA J100 · S/N 85609Air Crop LLCN51454Piper J3C-65 · S/N G196Built 1943 · Knutson Daniel TN6646CThistle Roger L RAVEN · S/N 1206Built 1997 · Thistle Roger LN71073Piper J3C-65 · S/N 18103Built 1946 · Knutson Daniel TN7153PPiper PA-24-250 · S/N 24-2318Built 1960 · Knutson Daniel TN73899Cessna 172N · S/N 17267736Built 1976 · Hill Randall SN7520DPiper PA-22-150 · S/N 22-5248Perron John JN7595HPiper PA-12 · S/N 12-469Built 1946 · Knutson Daniel T
Back to Lodi, WI