Registered aircraft · 20

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 = 'OH' AND g.registrant_city = 'KENT' 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 = 'OH' AND g.registrant_city = 'KENT'
  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 = 'OH' AND g.registrant_city = 'KENT'
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.

N10UPRobinson Helicopter R44 II · S/N 14330Built 2019 · Leonards Dream LLC N11442Cessna 150L · S/N 15075424Burkholder Donald R N119RGrumman American Avn. AA-1C · S/N AA1C0132Built 1978 · Compton Danny M N11FYYoder Forest R FOKKER DVII · S/N 005Built 2009 · Scherer Luis R N1290JRockwell International 112A · S/N 290Built 1975 · Krister Robert A N2203RGrumman American Avn. AA-5B · S/N AA5B-0071Built 1975 · Hubin Scott E N226FJHylio AG-216 · S/N 17906090220Davey Resource Group Inc N226HHHylio AG-216 · S/N 17906090221Davey Resource Group Inc N273DSDiamond Aircraft Ind DA 40 · S/N 40.954Built 2008 · Hubin Wilbert N N381KDBalony Kubicek Spol Sro BB30Z · S/N 691Davis Chester M N4104VCessna 170 · S/N 18436Built 1948 · Davis Lawrence R N44475Cessna P210N · S/N P21000408Jerryair Ltd N4555ZPiper PA-22 · S/N 22-8060Built 1961 · Scottini Ryan M N495RFBellanca 17-30A · S/N 73-30613Built 1973 · Stewart Delbert G N6155VCameron Balloons US A-140 · S/N 6014Built 1996 · Davis Chet N6510ECessna 175 · S/N 56010Built 1959 · Scherer Luis R N6803RCessna T210G · S/N T210-0203Built 1966 · N6803r LLC N70050National Ballooning 858 · S/N 129Built 1997 · Clark David R N8386SCessna 182H · S/N 18256486Davis Lawrence R N924WTWeber David A SONEX · S/N 318Built 2009 · Johnson Douglas

Back to Kent, OH