OpenAirDocs.org
Waterloo, IA

Registered aircraft · 40

Aircraft may not be kept in the town where they are registered. This site does not publish street address information.

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

N14009Piper PA-23-250 · S/N 27-4627Built 1971 · Livingston Aviation IncN177CCCessna 177 · S/N 17700654Built 1967 · Hoel Martin JN17ALRoss AL JABIRU SP · S/N 0294Built 2005 · Fox David RN1926CUding Michael E SPACEWALKER · S/N WR294S118Built 2017 · Loes Todd AN21847Firefly Balloons FIREFLY 7-15 · S/N F7-2051Built 2005 · Allbaugh Laurie BN227JDDubner Joe RV-8A · S/N 82194Built 2013 · Coordinate Productions LLCN2368APiper PA-18-135 · S/N 18-1921Built 1952 · Mondt Erik CN2539UCessna 172D · S/N 17250139Built 1963 · Loes Todd AN2980KLuscombe 8A · S/N 5707Built 1947 · Kubik Rodrick DN305WRBeech 95-B55 (T42A) · S/N TC-1591Built 1973 · Knudsvig TravisN33JTAeronca 7DC · S/N 6291Built 1946 · Tuchscherer James DN3489QCessna 320E · S/N 320E-0089Built 1967 · Plane Progress LLCN37661Olsen Henry CYGNET SF-2A · S/N 129Built 1981 · Loes Todd AN415CFPiper PA-28-180 · S/N 28-7505118Built 1975 · Alo Fliteline LcN458TADJI AGRAS T50 · S/N 1581F6BUB252C001BT88Aerial Ag Technologies LLCN458VADJI AGRAS T50 · S/N 1581F6BUB252A001Q56SAerial Ag Technologies LLCN45WFLearjet 45 · S/N 486Professional Office Services IncN487SRCirrus Design SR22 · S/N 2818Built 2007 · Armins Properties LLCN5342VPiper PA-32R-301 · S/N 3246205Built 2002 · S & L Real Estate LLCN56190Piper PA-28-180 · S/N 28-7305550Built 1973 · Bertch Gary MN61365Cessna 150J · S/N 15070990Built 1969 · Plane Progress LLCN618ATDavid E Harms ZENITH 601XL-B · S/N 6-6831Harms David EN618ZDavid E Harms RANS S-16 · S/N 199014Harms David EN626WMMike R Cizek VANS RV7-A · S/N 72452Built 2017 · Cizek Mike RN67483Cessna 152 · S/N 15281858Built 1978 · Livingston Aviation IncN7601DJI AGRAS T40 · S/N 64TBKBL002005WAirburst Agridrone LLCN7603DJI AGRAS T40 · S/N 64TBKAF002005LAirburst Agridrone LLCN787AECessna T210L · S/N 21059799Built 1972 · Coordinate Productions LLCN8030WPiper PA-28-180 · S/N 28-2096Built 1964 · Gosse Luke JN80499Cessna A185F · S/N 18503123Built 1976 · SrfN807WTCub Crafters CC19-180 · S/N CC19-0025Built 2017 · Windigo Transportation IncN8121GCessna 210K · S/N 21059421Built 1971 · Two One Golf LtdN818PCCessna P210N · S/N P21000803Built 1982 · Windigo Transportation IncN8407SCessna 182H · S/N 18256507Built 1965 · Rottinghaus Charles AN881JRWing John R ACRO-SPORT II · S/N 881Built 1996 · Finnegan Brian EN887DMorrow David L WITTMAN TALWND W-10 · S/N 887Built 1996 · Morrow David LN900NPSocata TBM 700 · S/N 1033Built 2014 · Northland Airmotive LLCN911NPKodiak KODIAK 100 · S/N 100-0344Built 2024 · Velocity Sport LLCN922CMPapenthien Michael R MIDGET MUSTANG MM-1 · S/N 001Built 2005 · Papenthien Michael RN991NPTextron 525B · S/N 525B0570Built 2018 · Kingfisher Aviation Lc
Back to Waterloo, IA