OpenAirDocs.org
Knox, IN

Registered aircraft · 23

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 = 'KNOX'
  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.

N134DLRobinson Helicopter R44 II · S/N 13014Built 2010 · Over And Under Flying Service Inc DBAN135DLBellanca 8KCAB · S/N 3372Over And Under Flying Service IncN2677CDJI T40 · S/N 1581F574B235K00100M2Cb High Flying Ag LLCN2678CTalos Drones TALOS T60X · S/N 2104F7EZW255P001UE3VCb High Flying Ag LLCN3337FCessna 182J · S/N 18257337Built 1966 · Aerolife Aviation LLCN343GRunkle Cliff C SONEX · S/N 0826Built 2009 · Runkle Cliff CN413AJHafen John M JR LANCAIR IV PRESSURIZ · S/N LIV-595Built 2008 · Smith LeighN424FSAir Tractor AT-602 · S/N 602-0424Built 1997 · Over And Under Flying Service IncN45113Air Tractor AT-502 · S/N 502-0094Built 1990 · Over And Under Flying Service Inc DBAN502WDAir Tractor AT-502B · S/N 502B0320Built 1995 · Over And Under Flying Service DBAN5144EBurnie B Blackmon TITAN TORNADO II · S/N 05161944Burnie B Blackmon LLCN538JCCooper James F SKY RANGER · S/N 0302297Built 2006 · Binkley Zachary DN5534KBellanca 7GCBC · S/N 1028-78Built 1978 · Aerolife Aviation LLCN619BBAir Tractor AT-401 · S/N 401-0916Over And Under Flying Service DBAN62VMPiper PA-46-310P · S/N 46-8608008Built 1986 · Aerolife Aviation LLCN69YAMark A Hornsby RV-7 · S/N 70767Built 2015 · Smith LeighN726HACessna 550 · S/N 550-0206Built 1980 · Aerojet USA LLCN805LLCirrus Design SR22 · S/N 0741Built 2003 · Aerojet USA LLCN861DMCirrus Design SR20 · S/N 1796Built 2007 · Aerolife Aviation LLCN87RKLake LA-4-200 · S/N 1091Built 1983 · Smith LeighN898DStinson 108-2 · S/N 108-2898Built 1947 · Singleton Harry WN96914Taylorcraft BC12-D · S/N 9214Built 1946 · Singleton Harry WN97937Stinson 108-1 · S/N 108-937Built 1946 · Wilson William James
Back to Knox, IN