Registered aircraft · 23

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'AR' AND g.registrant_city = 'COTTER' ORDER BY g.n_number

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 = 'AR' AND g.registrant_city = 'COTTER'
  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.

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 = 'AR' AND g.registrant_city = 'COTTER'
ORDER BY g.n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N100ZUKitplanes For Africa SAFARI LSA · S/N 016-11-12-SAFBuilt 2016 · Fusi Randal R N112PKKrotje Peter R CH701 · S/N 5339Built 2008 · Stange Karl P N1167FCessna 172G · S/N 17254762Registration pendingBuilt 1966 N189LJRoss Karla WAG-AERO SUPER SPORT · S/N 4685Orlowski Leo V N1909BLuscombe 8E · S/N 6336Puls Darrel E N218VGreen Gary E THORP T-18 · S/N 45Built 2006 · Green Gary E N232TMSpicer Henry A SONEX · S/N 032Built 2000 · Barrett George W Jr N28WLLional Ray Ward MODEL IV · S/N C95010095Built 2024 · Brown Mark R N3754YCessna 210D · S/N 21058254Built 1963 · Sullivan Eugene M N3793LCessna 172G · S/N 17253962Built 1965 · Warner Gary Dean Trustee N436JRDarwin R ESH RANS S-19 · S/N 060900075Built 2012 · Houghton Paul J N4646EChampion AERONCA 7DC · S/N 7AC-2452Built 1946 · Meffert Lloyd A N500MBBrown Mark R VANS RV-6A · S/N 24992Built 2011 · Brown Mark R N5716RCessna 172F · S/N 17253378Built 1965 · Udenburg Scott M N622LSRonnie Skaggs KITFOX MDL IV SPEEDS · S/N BCS103Built 2017 · Skaggs Ronnie L N637SXJaster Marvin L SONEX A-MODEL · S/N 1637Built 2023 · Jaster Marvin L N69220Green Gary E GA-11 · S/N 001Built 2013 · Green Gary E N714NRCessna 150M · S/N 15079308Built 1977 · Udenberg Scott M N8251BSmith David B RANS S7 COURIER · S/N 1194142Built 1994 · Schroeder Dale R N853CEEubanks Charles F MURPHY REBEL · S/N 802RBuilt 2012 · Wilford Boone N85708Aeronca 7AC · S/N 7AC-4454Built 1946 · Oltmans Michael J N8783WWarner Gary D SONEX · S/N 26Built 2020 · Warner Gary D N879PCTollefson Timothy J RANS S-20 · S/N 03140009Built 2018 · Hoetger Ralph C III

Back to Cotter, AR