OpenAirDocs.org
Clayton, NC

Registered aircraft · 37

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 = 'NC' AND g.registrant_city = 'CLAYTON'
  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.

N11353Cessna 150L · S/N 15075345Denmark Brooks MclaughlinN15VPPitts Vernon D RV-4 · S/N 1793Hardwick Alan RN168DDDavenport David Hollon DAVENPORT RV-6 · S/N 23811Built 2003 · Indian Beach Aviation LLCN17700Waco VKS-7 · S/N 4620Built 1937 · Hardwick Alan RN1933WBeech B19 · S/N MB-597Hanson Garrick DN217JKCirrus Design SR22T · S/N 1901Built 2019 · Ramp Air LLCN30005Piper PA-32RT-300 · S/N 32R-7885079Built 1978 · Hein Tanner TN3358JCessna 150G · S/N 15066058Built 1967 · Blue Chip Enterprises IncN4184SNanchang China CJ-6A · S/N 2532044Built 1968 · Denmark Brooks MN41977Piper PA-28-151 · S/N 28-7415375Built 1974 · Augusti Group Enterprises IncN44QPhillips BUSHBY MUSTANG II · S/N 446Built 1974 · Graf ErwinN465TCessna 182N · S/N 18260715Byrds Wholesale IncN5181RCessna 172M · S/N 17263398Built 1974 · Edelen Daniel RN527JPPerritt John O JR RV-6 · S/N JP-5Built 2003 · Perritt John Olin IIIN5781GCessna 150K · S/N 15071281Built 1969 · Williams Lynwood AN5BMorton Roscoe D GLASTAR · S/N 5061Built 2003 · Hixon Carl JN611AAMorse George JR F85P-1 · S/N 85001Built 1985 · Hughes Ernest CN611CCessna 170B · S/N 26895Built 1955 · Kovalesky JamesN6715VBeech 77 · S/N WA-70Byrds Wholesale IncN7287TCessna 172A · S/N 46887Built 1959 · Rfk Aerospace LLCN734USCessna 172N · S/N 17269130Built 1977 · Lowery Dwight WN735ARCessna 182Q · S/N 18265275Built 1976 · Haller Michael JN7377ACessna 172 · S/N 29477Rfk Aerospace LLCN7649EDowner 14-19-3 · S/N 4151Built 1959 · Huvard Todd Hunter TrusteeN7693PPiper PA-24-250 · S/N 24-2903Built 1961 · Crane James MN777DGGB Aerial Applications LANCAIR IV-P · S/N LIV-452Built 2010 · Blue Chip Enterprises IncN793GJDJI PHANTOM 3 ADVANCED · S/N P76DCF29013430Jimenez Juan CN80834Piper PA-28-236 · S/N 28-7911312Built 1979 · Odom Kirkland R JrN812JXDJI INSPIRE 2 · S/N 09YDDCML042475Tarkington Jeff FN8352JCessna 150G · S/N 15066252Byrds Wholesale IncN8465FPiper PA-28-161 · S/N 28-7716005Evans Danny JN84827Cessna 172K · S/N 17258631Built 1969 · Williams Albert JN8823HCessna T210K · S/N 21059314Built 1970 · Bowers Phillip PN8977PPiper PA-24-260 · S/N 24-4435Built 1966 · Warrior Up LLCN9099EMaule M-5-235C · S/N 7097CBuilt 1977 · Hanson Garrick DN926XRoss Charles J WOODY PUSHER · S/N 001Built 2006 · Hardwick Alan RN9287SBeech B19 · S/N MB-758Dale Michael W
Back to Clayton, NC