Ocklawaha, FL
Registered aircraft · 27
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 = 'FL' AND g.registrant_city = 'OCKLAWAHA' 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 = 'FL' AND g.registrant_city = 'OCKLAWAHA' 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.
N1019NGrumman G-21A · S/N B-30N102ZXGunderson Steven G ACRO TRAINER · S/N 1101N1217ZBeech 35-A33 · S/N CD-304N1854JPiper PA-28-140 · S/N 28-24292N256SKCirrus Design SR22T · S/N 2428N293SAAmerican Champion 7EC · S/N 1007-2007N410EGGohr Eric T RV-10 · S/N 40271N422VHHenderson Robert C RANS S-6S · S/N 08081900N456SPCessna 172S · S/N 172S8320N48EBWilson Kyle J VANS RV-7A · S/N 70755N491BLBRM Aero S R O BRISTELL LSA · S/N 491/2020N50TBSocata TB 30 EPSILON · S/N 50N552RRRussell Reese JA30 SUPERSTOL · S/N JA444-03-15N6262QCessna 152 · S/N 15285213N7005LCessna 310K · S/N 310K0105N701SGCirrus Design SR22 · S/N 0963N704VYCessna 150M · S/N 15078919N7078HPiper J3C-65 · S/N 20325N710GGBRM Aero S R O BRISTELL LSA · S/N 364/2018N768ACAmerican Champion 7GCBC · S/N 1268-99N781ZBeech M35 · S/N D-6471N798VSJames R Schilling RANS S-7S COURIER · S/N 1015621N821LMSocata TB 30 EPSILON · S/N 01First renewal noticeN8344NBeech E33A · S/N CE-209N83919Aeronca 7CCM · S/N 7AC-2600N921PTextron T206H · S/N T20609814N9983UGrumman American Avn. AA-5A · S/N AA5A0383
Back to Ocklawaha, FL