Owensboro, KY
Registered aircraft · 63
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 = 'KY' AND g.registrant_city = 'OWENSBORO' 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 = 'KY' AND g.registrant_city = 'OWENSBORO' 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.
N1213EAeronca 7AC · S/N 4771N1605LLockheed Aircraft Intl 402-2 · S/N 1021N1703QCessna 150L · S/N 15073003N201SLMooney M20J · S/N 24-0191N2091VPiper PA-28RT-201T · S/N 28R-7931108N2234PBellanca 7GCBC · S/N 761-74N2359HStarley G/Wolf C SEAREY · S/N 1DK135N244NADJI AGRAS T40 · S/N 1581F574B236300100K5N2488NCessna 140 · S/N 12741N2517ABoyd Michael S QUICKSILVER GT-400 · S/N GT2801408N270WLCirrus Design SR22 · S/N 9567N276JSPiper PA-30 · S/N 30-422N2822LCessna 172H · S/N 17256022N298QPDJI AGRAS T40 · S/N 1581F574B226M001015CSale reportedN3079MPiper PA-28-161 · S/N 28-7816336N3148VCessna 150M · S/N 15076402N339FLLowe David M 120A · S/N 001N362HECirrus Design SR20 · S/N 1263N385CGAero Commander 680FL P · S/N 1495-14N3925SCessna 172E · S/N 17251125N3981BPiper J3C-65 · S/N 12064N414CBEmbraer S A EMB-505 · S/N 50500374N425FLPiper PA-28-140 · S/N 28-7125208N4327NPiper PA-34-220T · S/N 34-8433026N452CJLearjet 45 · S/N 090N487RVDixon Richard L RV-7 · S/N 73551N495FFDJI AGRAS T50 · S/N 1581F6BU5236G0C1F063N4993WRockwell International 114 · S/N 14313N501METhurston TSC-1A · S/N 11N510SEEmbraer EMB-550 · S/N 55000040N5210FCessna 172N · S/N 17273128N536SLLing Samuel M BABY ACE MODEL D · S/N 001N53872Bellanca 7ECA · S/N 1134-76N6082FAir Tractor AT-402B · S/N 402B-0974N6171FCessna 210J · S/N 21059071N623CMChris H May JAVRON-MAY SC · S/N JA1608098N632PBDassault FALCON 2000 · S/N 17N6565KGrumman Acft ENG Cor-Schweizer G-164B · S/N 371BN6692KGrumman Acft ENG Cor-Schweizer G-164B · S/N 423BN6938GCessna 150L · S/N 15072438N70UUDJI AGRAS T40 · S/N 1581F574B226D00102JKN719WRCessna 550 · S/N 550-0897N7317GCessna 172K · S/N 17259017N736AECessna R172K · S/N R1722366N739FNCessna 172N · S/N 17270509N7929MBeech 35-C33 · S/N CD-1043N821DHCessna 182S · S/N 18280710N82599Aeronca 7AC · S/N 7AC-1236N836SPCessna 172S · S/N 172S8726N850PASocata TBM 700 · S/N 510
Back to Owensboro, KY