OpenAirDocs.org
Ulysses, KS

Registered aircraft · 71

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

N10367Schweizer SGU 2-22C · S/N 88Built 1960 · Neidert Melvin EN105PDCessna 172M · S/N 17261469Built 1973 · N105pd LLCN111PMBell 206B · S/N 1770Built 1975 · Tri Rotor Spray And ChemicalN1403ZAerofab LAKE LA-250 · S/N 34Built 1985 · Mid America Sprayers IncN1438PPiper PA-23 · S/N 23-496Tri Rotor Spray & ChemicalN15189Air Tractor AT-502 · S/N 502-0155Built 1991 · Tri Rotor Spray & ChemicalN158TRBell OH-58A · S/N 71-20791Built 2010 · Tri-Rotor Spray & ChemicalN162XMoyer Michael D EXEC 162-F · S/N 0001Moyer Cheryl JN176SJBell OH-58A · S/N 70-15556Built 1970 · Tri Rotor Spray & ChemicalN1835VCessna 120 · S/N 14074Built 1947 · Hauser Linda LN1944ZCessna 150C · S/N 15059744Built 1962 · Hauser Linda LN2239VAyres S2R-G6 · S/N G6-144North Star Aviation IncN2240XCessna 337 · S/N 337-0140Built 1965 · Tri-Rotor Spray & ChemicalN2367VCessna 140 · S/N 14603Built 1948 · Hauser Linda LN244FRCessna 172N · S/N 17270490Built 1978 · Smith LarryN253NACessna 172 · S/N 29216Neidert Melvin EN25HGPiper PA-28-181 · S/N 28-7890206Figgins Darrin WN2726FCessna 152 · S/N 15282841Built 1979 · Mid America Sprayers IncN31LLDeyoung John MUSTANG MII · S/N MII 1239Built 1993 · Neidert Melvin EN3298YAyres S2R-G10 · S/N G10-118Built 1995 · Neidert Melvin EN33679Piper PA-28-180 · S/N 28-7505167Built 1975 · North Star Aviation IncN34934Cessna 177B · S/N 17702100Built 1974 · Rider Nelson FN3572GCallair A-9 · S/N 1081Built 1964 · Hauser LindaN36FABell OH-58A · S/N 68-16765Built 1968 · Tri Rotor Spray & ChemicalN36HZBeech 36 · S/N E-158Built 1969 · Mid America Sprayers IncN38647Piper J5A · S/N 5-1032Built 1941 · Neidert Melvin EN3903ASchweizer SGS 1-26A · S/N 61Built 1958 · Neidert Melvin EN40358Thrush S2R-T34 · S/N T34-273Built 2005 · Tri-Rotor Spray & ChemicalN413TVBell Helicopter Textron 206L-1 · S/N 45636Built 1981 · Tri Rotor Spray & ChemicalN4182GAyres S2R-G6 · S/N G6-155Built 2000 · Neidert Melvin EdN4221SAir Tractor AT-802A · S/N 802A-0305Built 2008 · Tri Rotor Spray & ChemicalN4YVCessna 182Q · S/N 18266043Built 1977 · Donnie Young Farms IncN5028QAir Tractor AT-401B · S/N 401B-1028Built 1997 · Tri Rotor Spray & ChemicalN50669Air Tractor AT-602 · S/N 602-0447Built 1997 · Tri Rotor Spray And ChemicalN510NSThrush S2R-510 · S/N 510-521DCBuilt 2024 · North Star Aviation IncN5297FThrush S2R-T34 · S/N T34-307Built 2009 · Tri Rotor Spray & ChemicalN56CMCessna 310R · S/N 310R1422Family Practice Associates LLCN588MPBell OH-58A · S/N 72-21432Built 1972 · Tri Rotor Spray & Chemical IncN6100FCessna 210H · S/N 21059000Built 1968 · Tri Rotor Spray & ChemicalN6108EBeech A36 · S/N E-1939Built 1981 · Mid America Sprayers IncN6137XCessna 310R · S/N 310R1297Built 1978 · Moyer Aviation IncN6175SAir Tractor AT-402B · S/N 402B-0993Built 1995 · Tri-Rotor Spray And ChemicalN622JAAir Tractor AT-502B · S/N 502B-2622Built 2008 · Tri-Rotor Spray And Chemical IncN6437RPiper PA-28-140 · S/N 28-21618Built 1966 · Moyer Aviation IncN660TRAyres S2R-T660 · S/N T660-106Built 2000 · Tri-Rotor Spray & ChemicalN710NSThrush S2R-T660 · S/N T660-184Built 2024 · North Star Aviation IncN7239UBell OH-58A · S/N 68-16770Tri Rotor Spray & ChemicalN7603VAero Commander CALLAIR A-9B · S/N 1331Built 1967 · Hauser Linda LN76277Cessna 140 · S/N 10685Built 1946 · Hauser Linda LN7772VAero Commander CALLAIR A-9B · S/N 1515Built 1969 · Hauser Linda L
Back to Ulysses, KS