OpenAirDocs.org
Augusta, KS

Registered aircraft · 53

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 = 'KS' AND g.registrant_city = 'AUGUSTA'
  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.

N12721Cessna 172M · S/N 17262204Built 1973 · Pray Aviation IncN1307GCessna 172G · S/N 17254120Built 1966 · Pray Aviation IncN141TAPiper PA-28-151 · S/N 28-7715201Built 1976 · Pray Aviation IncN151MVPilatus PC-12/47E · S/N 1828Built 2018 · Dkj Services LLCN2021CBeech 95 · S/N TD-212Built 1959 · Pray Aviation IncN2033CBeech 95 · S/N TD-203Built 1959 · Pray Aviation IncN2049CBeech 95 · S/N TD-234Built 1959 · Pray Matthew WN2092MPiper PA-28-161 · S/N 28-7816250Registration pendingN210SKBeech B95 · S/N TD-393Built 1960 · Pray Aviation IncN22360Cessna 150H · S/N 15068236Built 1968 · Levy Peter FN247CGBeech B50 · S/N CH65Parsons John CN250MBeech D95A · S/N TD-625Pray Aviation IncN2571XPiper PA-28-161 · S/N 28-8516037Registration pendingN2575EAeronca 7AC · S/N 7AC-6158Built 1946 · Alley Terry RN282CGGibson Charles M MIDGET MUSTANG · S/N 1Campbell TannerN284TAPiper PA-28-161 · S/N 28-7916075Registration pendingBuilt 1978N285TAPiper PA-28-161 · S/N 28-7716239Registration pendingBuilt 1977N2914TAero Commander 200D · S/N 320Built 1966 · Tp Aviation IncN2VCBeech 95 · S/N TD300Built 1959 · Pray Aviation IncN3111VBeech 35 · S/N D-533Built 1947 · Stewart Ladd EN32548Piper PA-28-151 · S/N 28-7515182Registration pendingBuilt 1974N330BHHaas Robert J ARION LIGHTNING · S/N 00071Built 2009 · Mcfarland Randall DN35707Cessna 172I · S/N 17256921Built 1968 · Pray Aviation IncN376DGPiper PA-31P · S/N 31P-7630015Built 1976 · Clark AnthonyN3977SCessna 172E · S/N 17251177Registration pendingBuilt 1964N3998LCessna 172G · S/N 17254167Built 1966 · Kansas Copters & Wings IncN42895Piper J3C-65 · S/N 15230Built 1945 · Terhune Robert W JrN432PSFouga CM 170 MAGISTER · S/N 432Parsons John CN4347KPiper PA-28-161 · S/N 28-8416064Registration pendingBuilt 1984N44355Piper PA-28-151 · S/N 28-7415625Registration pendingBuilt 1974N46109Cessna 172I · S/N 17257047Built 1968 · Pray Aviation IncN5177FPiper PA-28-151 · S/N 28-7715096Built 1976 · Pray Aviation IncN5697VPiper PA-28-161 · S/N 28-7716203Pray Aviation DrN68543Bellanca 7GCAA · S/N 247-72Built 1972 · Waltemath Troy AN6903UMooney M20C · S/N 2698Built 1964 · Pray Aviation IncN7365GCessna 172K · S/N 17259065Pray Aviation IncN7780TTanner Campbell TC-J3 · S/N 1Built 2022 · Campbell Tanner LN80368Piper PA-28-161 · S/N 28-8216085Registration pendingBuilt 1981N80425Cessna 172M · S/N 17266582Built 1976 · Fellows Roy HN80PECessna 182T · S/N 18281472Built 2004 · Lakepoint Aviation LLCN81202Piper PA-28-161 · S/N 28-8016144Registration pendingBuilt 1979N8120FPiper PA-28-161 · S/N 28-8016136Built 1979 · Pray Aviation IncN8188XPiper PA-34-200T · S/N 34-8070182Built 1980 · Clark AnthonyN8376LPiper PA-28-161 · S/N 28-8116205Built 1981 · Pray Aviation IncN848DFDieker Thomas W RV-8 · S/N 84043Built 2026 · Dieker Thomas WN8613MBeech D95A · S/N TD-546Built 1963 · Pray Aviation IncN9002FPiper PA-28-151 · S/N 28-7715297Registration pendingN9282CPiper PA-28-161 · S/N 28-7816455Registration pendingBuilt 1978N928TAPiper PA-28-161 · S/N 28-8116180Built 1981 · Pray Aviation IncN948TBeech D95A · S/N TD-600Built 1964 · Pray Aviation Inc
Back to Augusta, KS