Beavercreek, OH
Registered aircraft · 54
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 = 'OH' AND g.registrant_city = 'BEAVERCREEK' 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 = 'BEAVERCREEK' 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.
N104TDGanster Thomas A RV-10 · S/N 40778N111EPPuschmann Eric R VANS RV-7A · S/N 71707N116CBCameron Balloons O-65 · S/N 239N1566GBeech F33A · S/N CE-1346N157WPFike Glen P FOKKER E V · S/N 001N1725ZCessna 336 · S/N 336-0025N2070HErcoupe 415-D · S/N 2693N226RVRonald M Voss TAILWIND W10 · S/N 12-1471N23WRBeech A36 · S/N E-1827N264HCBoeing A75N1(PT17) · S/N 75-2773N28GGSchleicher ASW-28 · S/N 28056N2928UCessna 172D · S/N 17250528N299ANCameron Balloons N-77 · S/N 410N3333VBeech 35 · S/N D-795N34ESPiper PA-34-200 · S/N 34-7450078N3569XPiper PA-32R-301 · S/N 32R-8013030N366HGGibbs Jay F SONEX · S/N 1230N3969WPiper PA-32-260 · S/N 32-909N3991BBoeing B75 · S/N 75-5964N4318SPiper PA-28-236 · S/N 28-8411002N4458HCameron Balloons U S N-133 · S/N 6208N4638ECessna A185F · S/N 18503822N49717Boeing A75N1(PT17) · S/N 75-4256N501NDassault FALCON 2000EX · S/N 103N5257JCessna M337B · S/N 337M0116N527ANCessna 172F · S/N 17252779N52937Boeing B75 · S/N 75-7097N5303NBoeing E75 · S/N 75-5974N55393Boeing A75 · S/N 75-4467N577SHGlass Steven T VANS RV-7A · S/N 71250N582AFHuff Joseph A AVID FLYER ACROBAT · S/N 1118DN58TLEmo Lorenz WM PIETENPOL AIRCAMPER · S/N 0022002N5947PPiper PA-24-250 · S/N 24-1037N6038ACameron Balloons US N-65 · S/N 5977N638SBeech 35-C33A · S/N CE-170N6397PPiper PA-24-250 · S/N 24-1507N65632Cameron Balloons US ZL-70 · S/N 6725N677LYri William D LANCAIR 235 · S/N 67N69764Boeing A75N1(PT17) · S/N 75-1628N701UBKissell Robert R CH701SP · S/N 7-5848N706AVCameron Balloons US ZL-70 · S/N 6709N714HUCessna 150M · S/N 15079196N75227Boeing B75N1 · S/N 75-7049N75257Boeing A75N1(PT17) · S/N 75-3683N7553ADestiny Powered Parachutes 2000 · S/N 3C0517N7940LBeech A23A · S/N M-992N79DKCub Crafters CC11-100 · S/N CC11-00021N8264LCessna 172H · S/N 17256464N83239Aeronca 7AC · S/N 7AC-1904N8345UCessna 172F · S/N 17252245
Back to Beavercreek, OH