Registered aircraft · 27

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

N10169Blair-Nesmith COUGAR I · S/N 101Mccroskey Danny D N104HTAke David E CHALLENGER II CLIP W · S/N CH2-1102-CW-2274May John D N1607EAeronca 7AC · S/N 7AC-5172Baldwin Jerry N181MMC Croskey Danny D RANS S-9 CHAOS · S/N 0392106Built 1992 · Mccroskey Danny D N199YYDJI AGRAS T20P · S/N 64UBK7M00100KQByrd William N23SWest-Fall BI-PLANE · S/N 1Built 1964 · Mccroskey Danny D N3115SCessna 182G · S/N 18255615Built 1964 · Hamric James H N3152HEngineering & Research 415-C · S/N 3777Built 1946 · May John D N3727SCessna 172E · S/N 17250927Built 1963 · Holloway Dwight W N38GSSullivan Glen AVID FLYER · S/N 56Built 1986 · Kubin Mark A N4036PPiper PA-23-160 · S/N 23-1512Built 1958 · Fiegel Donald H N44931Piper PA-28-161 · S/N 28-7816046Built 1977 · H&R Aircraft Co LLC N4572LCessna 421 · S/N 421-0172Built 1968 · Fiegel Donald H N5287WPiper PA-28-160 · S/N 28-336Built 1962 · Stump Kenneth H N6380TPatton Thomas W HURRICANE · S/N P101Built 1999 · Kubin Mark A N643HPHagerman PLAYMATE · S/N 643Built 2011 · Kubin Mark A N7RGJsbki SPAB · S/N 7-00Mccroskey Danny D N802TAAir Tractor AT-802A · S/N 802A-0741Built 2018 · 3m Ag LLC N829RSRan Kar X-AIR · S/N 809Built 2006 · Kubin Mark A N88128Eagle EAGLE DW-1 · S/N DW-1-0080-82Built 1982 · Moore John T N8845CQuad City Ultralight Acft CHALLENGER II · S/N CH2 1287 0279Kubin Mark A N9090LChampion 7ECA · S/N 227-70Bascue Brandon D N93006Newman John D CHALLENGER II · S/N CH2-0893-1012Built 1993 · Mc Croskey Danny D N940JCourtney Jimmy KITFOX III · S/N 940Built 1991 · Williams Kenneth N941HBTaylorcraft BL12-65 · S/N 2832Built 1941 · May John D N9545MMooney M20F · S/N 670122Built 1966 · Stull Ronald Wayne Jr N99023Engineering & Research ERCOUPE 415-C · S/N 1646May John D

Back to Ward, AR