OpenAirDocs.org
New Century, KS

Registered aircraft · 19

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 = 'NEW CENTURY'
  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.

N100KUAvion Marcel Dassault Breguet FALCON 10 · S/N 183Built 1981 · Nion LLCN102PTMooney M20R · S/N 29-0511Built 2008 · Nion LLCN2049NBeech V35B · S/N D-10190Built 1978 · Advanced Aviation LLCN2107EPiper PA-28-161 · S/N 28-7916162Built 1978 · Fly Kilo Charlie LLCN222KCBeech A200 (C-12C) · S/N BC-68Built 1979 · U S Army - OwnerN26HGCessna 551 · S/N 551-0614Built 1989 · Nion LLCN281KCPiper PA-28-161 · S/N 28-8216130Fly Kilo Charlie LLCN285RBRaytheon B300 · S/N FL-264Built 1999 · Butler National IncN322RRDassault-Breguet MYSTERE FALCON 200 · S/N 514Built 1995 · Nion LLCN39FBBeech C90 · S/N LJ-1165Butler National IncN410RWBeech A36 · S/N E-2031Built 1982 · Butler National IncN53TJBeech C90A · S/N LJ-1209Built 1989 · Nion LLCN551NCCessna 551 · S/N 5510171Built 1950 · Nion LLCN61SGCessna 525 · S/N 5250155Built 1996 · Nion LLCN626VACirrus Design SR20 · S/N 9558Built 2023 · V1 Venture Aviation LpN650NVCessna 560 · S/N 560-0429Built 1997 · Nion LLCN663TWLearjet 35A · S/N 35A-662Built 1990 · Butler National IncN908KCCostruzioni Aeronautiche Tecna P-MENTOR · S/N 1062/USBuilt 2024 · Fly Kilo Charlie LLCN9151UCessna 150M · S/N 15078102Built 1976 · Advanced Aviation LLC
Back to New Century, KS