OpenAirDocs.org
Kansas City, KS

Registered aircraft · 41

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 = 'KANSAS CITY'
  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.

N100WPCessna 560 · S/N 560-0073Built 1990 · Tads LLCN140DFCessna 140 · S/N 14439Bitikofer Brent EN1684GChampion 7KCAB · S/N 139Built 1968 · Mitchell Gary NN1696VCessna 120 · S/N 13868Built 1946 · Ronnau Thomas FN191ECessna 140A · S/N 15564Built 1950 · Bitikofer Brent EN20933Bentley John O SILHOUETTE I · S/N SA-233Meacham Bruce EN210MKBeech B-60 · S/N P-369Khosravi MuhsinN215MPCessna 421C · S/N 421C1231Persson Timothy JN2176QCessna 177RG · S/N 177RG0576Built 1974 · Hawkins George W IVN233LHBeech F33A · S/N CE-550Letts Jackson WN254MMMeacham Bruce E RV-4 · S/N 2208Built 2008 · Meacham Bruce EN26328Aeronca 65-LA · S/N L7940Built 1940 · Gilbert James DN27262Rearwin 8135 · S/N 839Built 1940 · Bitikofer Dawid KN279QQDJI AGRAS T40 · S/N 1581F574B239K0010013Yunghans AndrewN3232XCessna 150G · S/N 15064632Built 1966 · Bitikofer Brent EN412CBRaytheon B300 · S/N FL-440Gwvk LLCN413BBeech 35 · S/N D-1419Built 1948 · Kc Beech Front LtdN415SGLearjet 60 · S/N 283Built 2005 · Tom & Jerry IncN42536Cessna 180J · S/N 18052360Built 1973 · N B B S LLCN44FFWemple SCHREDER HP-18 · S/N 35Built 1978 · Meacham Bruce EN4561BP Z L -Warszawa-Cnpsl PZL-104 WILGA 35A · S/N 16820633Bitikofer Brent EN4622SSchempp-Hirth STANDARD AUSTRIA S · S/N 23Bitikofer Dawid KN49JRO'Rear EAA P2 · S/N JE1Built 1974 · Bitikofer Brent EN511RDSchempp-Hirth VENTUS-B · S/N 110Meacham BruceN527MTextron 525 · S/N 525-1107Built 2022 · Stevenson Leasing LLCN550MSTextron 525B · S/N 525B0550Built 2018 · Stevenson Leasing LLCN5627RCessna 172F · S/N 17253245Built 1965 · Bitikofer Brent EN6007HCommander 114-B · S/N 14593Built 1993 · Police Facility Design Group PaN65BAPiper PA-31T · S/N 31T-8020071Built 1980 · Tts Leasing IncN7625MMann Loren GLASTAR GS-1 · S/N 5816Built 2008 · Mccowan Kenneth LN81HCessna 140A · S/N 15602Built 1950 · Ronnau Thomas FN8381DBeech J35 · S/N D-5468Built 1958 · Bitikofer Magdalena BN8570JCessna 150G · S/N 15066470Bitikofer BrentN8595Schempp-Hirth STANDARD CIRRUS · S/N 33Built 1970 · Bitikofer Dawid KN8705RSchleicher KA 6 CR · S/N 6165Built 1963 · Bitikofer Dawid KN8887Beech B50 · S/N CH-84Ricciuti Martin RN8932LJackson Letts RANS S7S · S/N 0318630Built 2022 · Letts JacksonN921SSStory Marvin SS-D1 · S/N 001Built 1993 · Story Marvin LN945MSCompagnie Daher TBM 700 · S/N 1373Built 2021 · Stevenson Leasing LLCN9584WPiper PA-28-140 · S/N 28-23030Mitchell Gary NN9838ZBeech B90 · S/N LJ-435First renewal noticeBuilt 1969 · N B B S LLC
Back to Kansas City, KS