OpenAirDocs.org
Atlantic, IA

Registered aircraft · 24

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

N13JPSchumacher Joe P VANS RV-7 · S/N 73284Built 2015 · Four Kicks Aviation LLCN195PJPiper PA-32-300 · S/N 32-7840092Built 1978 · Swif LLCN1989VCessna 120 · S/N 14200Hotchkin Derek JN221BKLuscombe 8E · S/N 5288Built 1947 · Thielen Andrew JN2540TNavion NAVION H · S/N NAV-4-2540Built 1970 · Henningsen Air LLCN32PPBeech S35 · S/N D-7702Built 1964 · Denison Aviation IncN3369SCessna 210J · S/N 21059169Built 1969 · C-210 LcN356TPNorth American AT-6D · S/N 58-17082Built 1958 · Henningsen Air LLCN390FPDJI T50 · S/N 63YBLB1002003BPrecision Aerial Solutions LLCN4005JThrush S2R-T660 · S/N T660-111Built 2004 · Pettis Aviation LLCN456DTVans RV-12 · S/N 120572Built 2013 · Thurman Delbert LN475RHDJI AGRAS T50 · S/N 1581F6BUB248T001K1RPHoegh JoelN4970QCessna A188B · S/N 18802704TBuilt 1976 · Pettis Ag Aviation LLCN5102TChampion 7GCBC · S/N 72Built 1966 · Pettis Aviation LLCN629DKPiper PA 46-350P · S/N 4636158Built 1998 · United Steel Erectors CorpN7053GCessna 172K · S/N 17258753Built 1969 · Spare Change Enterprises LLCN7509PPiper PA-24 · S/N 24-2710Built 1961 · Superbird Aviation LLCN75151Piper PA-28-181 · S/N 28-7690304Built 1976 · Olsen Aviation LLCN76113Cessna 120 · S/N 10510Built 1946 · Denison Aviation IncN8499GCessna 150F · S/N 15062599Built 1965 · Ryan Richard EN8851DJI AGRAS T100 · S/N 1581F8ZLC25AC002Y09CHoladay DanielN930EASocata TBM 700 · S/N 1175Built 2017 · Harlan Aviation LLCN989JHHylio AG-130 · S/N 050295Precision Aerial Solutions LLCN993VUHylio AG-130 · S/N 050263Precision Aerial Solutions LLC
Back to Atlantic, IA