OpenAirDocs.org
Auburn, IN

Registered aircraft · 26

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 = 'IN' AND g.registrant_city = 'AUBURN'
  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.

N10865Stinson JR. S · S/N 8049Built 1931 · Auburn Cord Duesenberg MuseumN13GERobinson Helicopter R44 II · S/N 10018Built 2002 · Paratus Air IncN18FHRobinson Helicopter R44 ASTRO · S/N 0651Built 1999 · Paratus Air IncN3015GRobinson Helicopter R44 II · S/N 11542Built 2007 · Paratus Air IncN39592Piper PA-34-200T · S/N 34-7870395Built 1978 · Paratus Air IncN41279Robinson Helicopter R44 · S/N 1909Built 2008 · Paratus Air DBAN4485TPiper PA-28-140 · S/N 28-7225161Built 1972 · Kreigh Kevin MN466XBXag P150 · S/N 186324P182235089RP97Bell Bruce W IIN4773SCessna R182 · S/N R18201423Built 1979 · Sonrex LLCN501RTCessna 500 · S/N 500-0001Built 1971 · Paratus Jets LLCN5055WPiper PA-28 · S/N 28-64Built 1961 · Sell Noel LN5152JIai GULFSTREAM G280 · S/N 2165Built 2018 · James Aviation LLCN52PLBell Helicopter Textron 206L-1 · S/N 45744Paratus Air DBAN6433QMooney M20F · S/N 670512Built 1967 · Paratus Air IncN64TFCessna 550 · S/N 550-0064Paratus Jets LLCN657MPiper PA-11 · S/N 16878Built 1946 · Robison Geoff LN69721Stinson AT-19 · S/N 77-152Built 1943 · Auburn Cord Duesenberg MuseumN7240GCessna 172K · S/N 17258940Built 1970 · Kendallville Flying Club IncN7623TCessna 172A · S/N 47223Built 1960 · Mooney Micheal EN76BMMark Mcdevitt HUMMELBIRD · S/N 001Mcdevitt Mark AN8113LCessna 172H · S/N 17256313Built 1967 · N8113l LLCN8287LCessna 172H · S/N 17256487Built 1967 · Shirk MatthewN8561VRobinson Helicopter R22 ALPHA · S/N 0484Built 1985 · Paratus Air IncN92FZPiper PA 46-350P · S/N 4636645Built 2014 · Strawman Aviation LLCN982NACessna 550 · S/N 550-0345Built 1982 · Paratus Jets LLCN99DABeech 58 · S/N TH-619Built 1975 · Auburn Aero Holdings LLC
Back to Auburn, IN