OpenAirDocs.org
Udall, KS

Registered aircraft · 42

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

N101CJSchneider Carl H CHINOOK PLUS 2 · S/N 02120Built 1999 · Main Patrick RN10358Schweizer SGU 2-22 · S/N 84Built 1960 · Maglaughlin Ronald DN12121Reed-Madsen Donald TAYLOR BIRD · S/N 09Main Patrick RN124DLLemons Richard L NIEUPORT II · S/N 232Built 1988 · Klingenberg Timothy CN14910Moore Glenn G RYAN ST-R · S/N 103Built 1998 · Weyland Hendrik JN2549RBradley Wesley D 70% TIGERMOTH · S/N 001Klingenberg Timothy CN29BXScannell Robert M SONERAI II L · S/N 01216Weyland Hendrik JN31422Aeronca 65-CA · S/N CA10750Built 1940 · Klingenberg Tim CN3169NDowns Earl KFL · S/N 001Klingenberg Timothy CN33548Piper J3C-65 · S/N 13986Built 1945 · Klingenberg Timothy CN337PLCessna 402A · S/N 402A0039Built 1969 · Maglaughlin Ronald DN3974APiper L-4B · S/N 9430Built 1942 · Klingenberg Timothy CN4359Wade THORPE · S/N 01Maglaughlin Ronald DN4483LCessna 172G · S/N 17254578Built 1966 · Rogers Ross EN455ZDGirard Richard KOLB MK.3 · S/N 043Built 2008 · Klingenberg Timothy CN50781Cessna 150J · S/N 15069549Built 1968 · Beard Michael EN5085HPiper PA-11 · S/N 11-985Built 1949 · Weyland Hendrik JN51909Boeing A75N1(PT17) · S/N 75-2526Built 1945 · Rogers Ross EN5248TPiper PA-28-140 · S/N 28-7225372Built 1972 · Dopfel Sierra MN524DJWaldron Dennis W IV-1200 · S/N 1748Built 2000 · Weyland Hendrik JN53JJSwarts O/Flannery J/Judy J KITFOX I · S/N 206Built 1995 · Seitz Charles JN561KEAero Commander 680 · S/N 680-322-16Maglaughlin Ronald DN5902TCessna 150 · S/N 15060602Maglaughlin Ronald DN601SLGirard Richard APACHE SPORT · S/N 1001Built 2006 · Girard Richard NN6085HPiper J3C-65 · S/N 19241Built 1946 · Klingenberg Tim CN61358Boeing A75N1(PT17) · S/N 75-456Built 1940 · Klingenberg Tim CN614AGGirard Richard CUMULUS · S/N 1004Built 2008 · Girard Richard NN6194BCessna 182A · S/N 34194Built 1957 · Maglaughlin Ronald DN6329ZSorhein P/Buga A FLIGHTSTAR · S/N 0743Duncan Christopher PN6802UMooney M20C · S/N 2517Built 1963 · Klingenberg Timothy CN685USchweizer SGU 2-22E · S/N 220Built 1965 · Maglaughlin Ronald DN7251SScott Edward P V-MAX · S/N MK621Duncan Christopher PN78754Piper PA-11 · S/N 111528Built 1955 · Klingenberg Timothy CN8044ZCessna 150K · S/N 15071255Lever Samuel CN8125FCessna 402 · S/N 402-0231Maglaughlin Ronald DN8679RSchweizer SGU 2-22E · S/N 162Built 1963 · Maglaughlin Ronald DN901DUniversal Stinson 108-2 · S/N 1082901Built 1947 · Maglaughlin Ronald DN9087KStinson 108-1 · S/N 108-2087Built 1947 · Rutschman Daniel PN9149HLeroy A Thomas 2/3 SCALE JENNY · S/N 21212Built 2001 · Mccormick Christy NN9211Electic 1 C · S/N 1Built 1967 · Klingenberg Timothy CN9403DPiper PA-22-160 · S/N 22-6376Built 1958 · Klingenberg Tim CN9795VCessna A150M · S/N A1500565Williams Bob L
Back to Udall, KS