OpenAirDocs.org
Ames, IA

Registered aircraft · 58

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

N1046XPiper PA-28-140 · S/N 28-7525266Built 1975 · Farnham Aviation Services LLCN112TLDJI AGRAS T16 · S/N 1PKDGBP0016Z3NIowa State UniversityN1261UCessna 172M · S/N 17266956Built 1976 · Vlftec IncN1442CCessna 177B · S/N 17702728Built 1977 · Makelbust Michael JN15SPMooney M20TN · S/N 31-0079Built 2008 · Cavu LLCN1858DEavision EA-J150 · S/N 602595720Iowa State UniversityN1957LBeech B24R · S/N MC-423Built 1976 · Smith Joseph MN202SGAmerican Champion 8KCAB · S/N 1015-2006Bassham Diane CN20609Wander Robert P WOODSTOCK · S/N 285Michael Matthew CN2094TPiper PA-28R-200 · S/N 28R-7135039Built 1970 · Suzuki YoshinoriN2286LBeech F33A · S/N CE-675Built 1976 · Baty John WN23782Cessna 182S · S/N 18280448Built 1999 · Zylstra Cycle Co IncN2404WSchweizer SGS 1-26B · S/N 349Built 1966 · Farrar Kelley JN244BRBrent A Haverkamp CCX-2000 · S/N CCX-2000-0088Built 2020 · Haverkamp Brent AN2528JCessna 150E · S/N 15061028Michael Matthew CN2795HEngineering & Research 415-C · S/N 3420Built 1946 · Scholten Dirk JN301UDDJI AGRAS T40 · S/N 1581F574B2387001006XNutri Drones LLCN327DGGates Richard D RV-8 · S/N 82766Sabino SeanN3407MPiper PA-12 · S/N 12-2253Built 1947 · Bausch Wayne AN34822Rearwin 8135 · S/N 879Built 1941 · Bausch Wayne AN348CDCirrus Design SR22 · S/N 2389Built 2007 · 348 Charlie Delta LLCN364AUBeechcraft G36 · S/N E-4031Built 2014 · 364au LLCN364WRDJI AGRAS T40 · S/N 1581F574B235W00100NVWhitetail Robotics LLCN37792Rearwin 8135T · S/N 901Bausch Wayne AN3812TPiper PA-28R-180 · S/N 28R-30127Built 1967 · Gtm Services LLCN4022EAeronca 11BC · S/N 11BC-110Built 1947 · Ghl Air LLCN4262HMooney M20J · S/N 24-0688Northern Iowa Anesthesia Services P L CN42776Cessna 421B · S/N 421B0394Built 1973 · Hap'S Air IncN4473HPiper PA-15 · S/N 15-261Built 1948 · Uhlenhopp Eldon KN495PGCirrus Design SR20 · S/N 1954Eurosource LLCN5068YBellanca 7ECA · S/N 1340-80Built 1979 · Farnham Aviation Services LLCN52440Cessna 172P · S/N 17274523Built 1981 · Hap'S Air IncN5274SCessna R182 · S/N R18201534Built 1980 · Hap'S Air IncN54LTPiaggio P180 · S/N 1050Hp Aviation LcN55350Cessna 172P · S/N 17275164Built 1982 · Haps Air IncN614CYCirrus Design SR22 · S/N 1050Built 2004 · 614 Charlie Yankee LcN623TSCessna 525B · S/N 525B-0144Built 2007 · T & S Aviation LLCN641SUCessna 560XL · S/N 560-5504Built 2004 · Iowa State University Of Science And TechnologyN66WBBausch Wayne A VANS RV-6 · S/N 23331Bausch Wayne AN747BSEckstein Brian RV-6A · S/N 24728Built 2001 · Brown Jake PN7521DPiper PA-22-150 · S/N 22-5249Built 1957 · Laabs Francis CN771ZBolkow PHOEBUS C · S/N 859Michael Matthew CN8025CPiper PA-22-135 · S/N 22-2212Built 1954 · Laabs Fran CN80280Porter Halbert H BJ-1B · S/N BJB-11Built 1981 · Michael MattN8045WPiper PA-28-180 · S/N 28-2919Built 1965 · Open Engineering LLCN8095FBeech A36 · S/N E-2695Built 1992 · Brown Dr JayN810SCessna 320B · S/N 320B0062Built 1964 · Lidman KirbyN821ESSchmitz Mark J RV-8 · S/N 81767Built 2019 · Schmitz Mark JN8423NBeech V35A · S/N D-8787Built 1968 · Farnham Dale EN84276Aeronca 7AC · S/N 7AC-2969Farnham Aviation Services LLC
Back to Ames, IA