Registered aircraft · 18

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'BASEHOR' ORDER BY g.n_number

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

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 = 'BASEHOR'
ORDER BY g.n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N102TKKofoed Terry L CHALLENGER II · S/N CH 20392B0834Built 1992 · Howlett Randy N117AFMalzahn Victor AVID FLYER · S/N 117Built 1998 · Rowcliffe William A N1476EAeronca 7AC · S/N 7AC-5039Built 1946 · Lafave Alex T N1609NFunk B85C · S/N 394Built 1946 · Funk Aeroplane Company N1693TPiper PA-28-140 · S/N 28-7125010Moburg Kenneth N20096Piper J-2 · S/N 1896Built 1937 · Higley Rick N24168Funk B · S/N 194Built 1940 · Funk Aeroplane Co N24181Funk B75L · S/N 207Built 1940 · Funk Aeroplane Company N41741Funk B85C · S/N 223Built 1946 · Funk Aeroplane Company N47556Ryan Aeronautical ST3KR · S/N 1955Built 1941 · Aero Legacy Foundation N50188Cessna 150H · S/N 15069119Built 1968 · Ryburn Michael D N68235Boeing B75N1 · S/N 75-6860Moburg Kenneth Dean N77707Mcclish FUNK B85C · S/N 337Built 1946 · Funk Aeroplane Co N8034HHoelting A G/Adams C V HOELTING ADAMS HATZ · S/N 001Built 2004 · Adams Charles V N81157Funk B85C · S/N 287Built 1946 · Funk Aeroplane Co N81723Cruz Felix SKYBOLT · S/N 31047Aero Legacy Foundation N8265NPiper PA-28-140 · S/N 28-25478Built 1969 · Immanuel Baptist Church Of Kansas City Kansas N86841Bellanca 14-13 · S/N 1202Aero Legacy Foundation

Back to Basehor, KS