OpenAirDocs.org
Jasper, IN

Registered aircraft · 22

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

N106RMCessna TR182 · S/N R18201932Built 1983 · Advanced Aviation Solutions LLCN1223Piper PA-24-250 · S/N 24-2906Built 1961 · Munning Joseph H MdN158PMCessna 172L · S/N 17260064Built 1971 · Lowrey Jonathan SN277JEBeechcraft B300 · S/N FL-986Built 2015 · Air LLCN280SHEnstrom 280FX · S/N 2095Built 2003 · Rottor Aviation LLCN335TRXag P100 PRO · S/N 1863FPEG8219425L0R58Ck Helicopters LLCN377JERaytheon B200 · S/N BB-1843Acr Advertising LLCN3834RPiper PA-28-180 · S/N 28-5828Built 1970 · K J Aviation LLCN4877LPiper PA-28-180 · S/N 28-4243Txp Designs LLCN488BWCirrus Design SR22T · S/N 2251Built 2021 · Benchmark Air LLCN541DRDonald B Reinholm ONEX-D1 · S/N ONX0060Built 2013 · Kennedy RyanN57EFBell 206B · S/N 660Built 1971 · Ck Helicopters LLCN700DAMitsubishi MU-2B-20 · S/N 140Built 1969 · Lowrey Jonathan SN72MSchmitt Michael J V 173 ELT RG/MJS-SB · S/N DM0287MTABuilt 2003 · Magical Thing Air LLCN74595Grumman American Avn. AA-5B · S/N AA5B-0263Built 1976 · Ehrhard Robert AN7875YPiper PA-30 · S/N 30-959Built 1965 · Dodson Carl FN8303QPiper PA-28-236 · S/N 28-8311006Built 1982 · Ducota 6 LLCN850GMSocata TBM 700 · S/N 535Built 2010 · Mannup LLCN9534YBeech 35-B33 · S/N CD-556Built 1962 · Hulsair LLCN95FDAgusta F.260D · S/N 785Built 1990 · Lowrey Jonathan SN974WBBell 206B · S/N 1425Built 1974 · Ck Helicopters LLCN9966DPiper PA-22-150 · S/N 22-6757Built 1959 · Ziemann Shaun
Back to Jasper, IN