Land O Lakes, FL
Registered aircraft · 40
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 = 'LAND O LAKES' 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 = 'LAND O LAKES' 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.
N145LKBalony Kubicek Spol Sro BB30Z · S/N 1592N1478XPiper PA-28-140 · S/N 28-7525292N17PSPiper PA-31P · S/N 31P-7630008N18782Beech C24R · S/N MC-505N2478JCirrus Design SF50 · S/N 0182First renewal noticeN3152QCessna 182K · S/N 18258152N345RVJohnson Scott E VANS RV6A · S/N 23760N349CDCirrus Design SR20 · S/N 1509N3864YBeech C24R · S/N MC-756N393PAPhillip Alvarez DOMINATOR · S/N PA001N39987Cameron Balloons A-140 · S/N 2571N402EWUltramagic M-160 · S/N 160/58N410RBWall R L/Barney C W VANS RV 10A · S/N 40371N411FLPiper PA-28-140 · S/N 28-7125188N42041Cessna 182L · S/N 18258825N421MPCessna 525B · S/N 525B0328N476JDCessna 525A · S/N 525A0426N495TWBalony Kubicek Spol Sro BB42Z · S/N 1441N498TWBalony Kubicek Spol Sro BB26Z · S/N 1794N5091LAerostar International S-51A · S/N S51A-3024N517DTFlight Design General Avn CTLS · S/N F-18-09-05N517LBLindstrand Balloons 105A · S/N 5032N518TWBalony Kubicek Spol S R O BB-S/UNICORN · S/N 1679N525SLErcoupe 415-C · S/N 1374N5541MAero Commander 100 · S/N 127First renewal noticeN57RVHancock Seth E RV-6 · S/N 22199N582ALExcalibur AMPHIB · S/N 12404N65CDSmith Dennis VANS RV-6 · S/N 60065N670BAIcon A5 · S/N 00025N68882Helio HT-295 · S/N 1713N711XBeech S35 · S/N D-7732N75365Aeronca 7BCM · S/N 47-825N757RVJohnson Scott E RV-7A · S/N 75031N863JBCessna 560 · S/N 560-0260N86KDDorschner Klaus KADE AVENTURA II · S/N AA2A0106N899JCirrus Design SR22 · S/N 3790N90006Aerostar International RAVEN S49A · S/N S49A-3118N908TWHead Balloons AX7-77 · S/N 501N914TWHead Balloons AX9-118 · S/N 517N98472Piper J3C-65 · S/N 18672
Back to Land O Lakes, FL