OpenAirDocs.org
Casey, IA

Registered aircraft · 16

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 = 'IA' AND g.registrant_city = 'CASEY'
  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.

N250HCurtiss Wright FLEDGLING · S/N B-31Registration pendingBuilt 1929N26196Piper J4A · S/N 4-872Built 1940 · Schildberg Gregory MN26489Meyers OTW · S/N 42Built 1941 · Schildberg Gregory MN32884Piper J4A · S/N 4-1324Built 1940 · Schildberg Gregory MN329YBarnes CHURCH MIDWING · S/N FMB18158Built 1963 · Schildberg Gregory MN4672TCorben Baby Ace C · S/N DO-1-64Built 1964 · Schildberg Gregory MN5494YPiper PA-23-250 · S/N 27-2587Built 1964 · Schildberg Gregory MN5680YPiper PA-18-150 · S/N 18-8292Built 1965 · Schildberg Gregory MN8290HIntermountain CALLAIR A-9 · S/N 1232Built 1965 · Schildberg GregoryN8814TCessna 182 · S/N 52714Built 1960 · Schildberg Gregory MN909KKXag P100 PRO · S/N 1863FPEG821934350P2JSteele ScottN910KKDJI AGRAS T20P · S/N 1581F574B237W00100T3Steele ScottN922KKXag P100 PRO · S/N 1863FPEG82193438KQ83Steele ScottN9481Fairchild 22 C7D · S/N 911Built 1933 · Schilaberg Gregory MN965HMoth 60-GM · S/N 65Built 1929 · Schildberg Gregory MN9GDDavis PITTS S-1 · S/N GD-1Built 1974 · Schildberg Gregory M
Back to Casey, IA