Gainesville, FL
Registered aircraft · 156
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 = 'GAINESVILLE' 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 = 'GAINESVILLE' 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.
N100FGEmbraer S A EMB-505 · S/N 50500084N100PPiper PA-31-350 · S/N 31-8252019N101FGEmbraer EMB-500 · S/N 50000222N102LTCirrus Design SR22 · S/N 0288N103JSchempp-Hirth DISCUS-2B · S/N 115N1067MCessna 210K · S/N 21059367N106GXRemos Acft Gmbh Flugzeugbau REMOS GX · S/N 292N111THTaylorcraft 19 · S/N 10044N112EGBell OH-58A · S/N 68-16834N112FJDassault FALCON 2000 · S/N 112N116JLLisanke Joseph HORIZON · S/N 001N11WCirrus Design SR22 · S/N 0262N1273VPiper J3C-65 · S/N 13998N12LZLima Zoo LIMA ZOO LONG-EZ · S/N LZ001N1400MCessna 650 · S/N 650-0140N1410ECessna 172S · S/N 172S10667N1416WCessna 172S · S/N 172S10669N14631Goodknight BENSEN B-8M · S/N 01Registration revokedN15688Beech 58 · S/N TH-1542N163JMCessna 650 · S/N 650-0163N167ACBell OH-58A · S/N 70-15620N172WJCessna 172M · S/N 17260906N1746GBeech P35 · S/N D-6952N177CTGrumman American Avn. AA-1C · S/N AA1C-0016N1794XCessna 210L · S/N 21060814N17CXCirrus Design SF50 · S/N 0017N1808VCessna 140 · S/N 13993N182PSCessna 182D · S/N 18253524N1870TPiper PA-28-140 · S/N 28-7225019N18GTFrank Owens VANS RV7 · S/N RV7-72915N18NNBombardier BD-700-1A10 · S/N 9185N1910UGamache Robert A TANGO · S/N T-19N19APPipistrel D O O Ajdovscina APIS · S/N 063 AB F33N1EVBeech A36 · S/N E-1463N20457Cessna 172M · S/N 17261303N208LSCessna 208B · S/N 208B2256N20UFCirrus Design SR20 · S/N 8757N224NCDassault FALCON 2000 · S/N 42N2460WSchweizer SGS 1-26B · S/N 371N2479HPiper PA-18-150 · S/N 18-7909193N25142Luscombe 8A · S/N 1066N2653QCessna 182K · S/N 18257853N26HHCessna 550 · S/N 550-0316N26VJCirrus Design SF50 · S/N 0248N26WCirrus Design SR22 · S/N 4905N27451Taylorcraft BC-65 · S/N 2093N284ACBell OH-58A · S/N 73-21867N2874ZPiper PA-28-161 · S/N 28-7916497N299RMPiper PA-23-250 · S/N 27-8054024N2MACirrus Design SR22 · S/N 1177
Back to Gainesville, FL