OpenAirDocs.org
Olathe, CO

Registered aircraft · 17

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 = 'CO' AND g.registrant_city = 'OLATHE'
  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.

N1529WAir Tractor AT-401 · S/N 401-0848Built 1992 · Olathe Spray Service IncN170SSBell 47G-3B-1 · S/N 2827Built 1963 · Olathe Spray Service IncN1876APiper PA-18A · S/N 18-1712Built 1952 · Kalarney Kerry TN2624QCessna 182K · S/N 18257824Built 1966 · Kalarney Kerry TN310SSBell 47G-2A · S/N 3000Built 1964 · Olathe Spray Service IncN32776Piper PA-34-200T · S/N 34-7570052Built 1975 · Hutchison Ross CN3815YCessna 210D · S/N 21058315Built 1964 · Borean Anthony JN4707BCessna 180 · S/N 31605Built 1955 · Olathe Spray Service IncN5008LAir Tractor AT-402B · S/N 402B-1018Built 1996 · Olathe Spray Service IncN5500VNorth American SNJ-6 · S/N 112023Built 1943 · Felix Leonard D JrN555BGCessna 525 · S/N 525-0113N & E Aviation LLCN6053CCessna T182T · S/N T18208544Built 2006 · Taylor Travis EN6447UMooney M20C · S/N 2252Built 1962 · Olathe Spray Ser IncN7049ZPiper PA-25-235 · S/N 25-2816Built 1964 · Olathe Spray Service IncN7227KPiper PA-18-105 SPECIAL · S/N 18-121Built 1950 · Olathe Spray Service IncN745CSSpencer Charles Edgar SR RV-4 · S/N 1709Felix L DevinN85729Aeronca 7AC · S/N 7AC-4476Albright William C Jr
Back to Olathe, CO