OpenAirDocs.org
Lyndon, KS

Registered aircraft · 35

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

N13819Cessna 177B · S/N 17702471Built 1976 · Avco Patrol LLCN177GSCessna 177B · S/N 17701845Built 1972 · Avco Patrol LLCN192TABell 206B · S/N 2836Built 1979 · Hawkeye Helicopter LLCN200KKRotorcraft Development OH-58A+ · S/N 73-21863Built 1973 · Hawkeye Helicopter LLCN20145Cessna 177B · S/N 17702636Avco Patrol LLCN21110Cessna 182P · S/N 18261420Built 1972 · Avco Patrol LLCN2366YCessna 182S · S/N 18280539Built 1999 · Avco Patrol LLCN314FRCessna 182S · S/N 18280260Built 1998 · Hawkeye Helicopter LLCN316HKHughes Helicopters HUGHES 369D · S/N 390479DBuilt 1979 · Hawkeye Holdings LLCN31BJCessna 177B · S/N 17702489Built 1976 · Avco Patrol LLCN3438SCessna 177B · S/N 17701784Built 1972 · Avco Patrol LLCN37GGCessna 182S · S/N 18280353Built 1999 · Avco Patrol LLCN380PDBell OH-58A · S/N 73-21879Hawkeye Helicopter LLCN38QBell Helicopter Textron 206L-1 · S/N 45364Built 1980 · Hawkeye Helicopter LLCN407HKBell 407 · S/N 53076Built 1996 · Hawkeye Helicopter LLCN415RCCessna 182S · S/N 18280302Built 1998 · Avco Patrol LLCN4167QCessna 310N · S/N 310N-0067Built 1968 · Hawkeye Helicopter LLCN42599Cessna 182L · S/N 18259098Built 1968 · Avco Patrol LLCN500RMMcdonnell Douglas Helicopter 369E · S/N 0119EHawkeye Helicopter LLCN511SHHughes Helicopters HUGHES 369D · S/N 290455DBuilt 1979 · Hawkeye Helicopter LLCN5126QCessna 172M · S/N 17261757Built 1973 · Avco Patrol LLCN527HKMcdonnell Douglas Helicopter 369E · S/N 0430EHawkeye Helicopter LLCN5NUBell 206B · S/N 722Built 1971 · Hawkeye Helicopter LLCN7194GCessna 172K · S/N 17258894Built 1969 · Avco Patrol LLCN724HKMD Helicopters 369E · S/N 0553EBuilt 2000 · Hawkeye Helicopter LLCN7332KDJI AGRAS T100 · S/N 1581F8ZLC25BT002WTYWKneisler Ag Services LLCN738AECessna R182 · S/N R18200903Avco Patrol LLCN7446QCessna 182P · S/N 18261086Built 1972 · Avco Patrol LLCN763TWSikorsky UH-60A · S/N 80-23459Built 1981 · Hawkeye Helicopter LLCN79302Cessna 172K · S/N 17258031Built 1969 · Avco Patrol LLCN828HKMcdonnell Douglas Helicopter 369E · S/N 0532EBuilt 1996 · Hawkeye Helicopter LLCN85RBBell 206B · S/N 831Built 1972 · Scott John DN91795Cessna 182M · S/N 18259912Built 1969 · Avco Patrol LLCN9661GCessna 182P · S/N 18263422Built 1974 · Avco Patrol LLCN989RACessna 182S · S/N 18280035Built 1997 · Avco Patrol LLC
Back to Lyndon, KS