Lake Mary, FL
Registered aircraft · 47
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 = 'LAKE MARY' 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 = 'LAKE MARY' 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.
N104WHPiper PA32-301FT · S/N 3232046N1422AN1422a AIRCAM · S/N AC-255N1422KN1422k SLING HW TD · S/N 066IQN156REDassault-Breguet FALCON 50 · S/N 156N157FBeech E35 · S/N D-3934N16760Bell 206L · S/N 45081N169TSSimmons Tom J LONG-EZ · S/N 1694N16KXKestrelx RISEN SV · S/N 48N19807Cessna 172M · S/N 17260770N19KXKestrelx RISEN SV · S/N 54N22KXDon Moseley KX-1 · S/N JSX0051N248DDIsham Dannie E RV-6 · S/N 24647N265PSDiamond Aircraft Ind DA 42 NG · S/N 42.N605N2741YBeech 95 · S/N TD-94N28CVNorth American/Bellek T-28C · S/N 146249N311GJCirrus Design SR22T · S/N 9498N3176LBell Helicopter Textron 206L-1 · S/N 45648N409YKBoeing 737-436 · S/N 25859N43KXKestrelx RISEN SV · S/N 55N440KHBoeing 737-490 · S/N 28889N442KHBoeing 737-490 · S/N 28888N44BCBell 206B · S/N 1904N481MRDiamond Aircraft Ind DA 42 NG · S/N 42.N152N486EAPerformance TURBINE LEGEND · S/N 115N503CDCirrus Design SR22 · S/N 0909N514CTCostruzioni Aeronautiche Tecna P2010 · S/N 114/USSale reportedN514GCCessna 182 · S/N 33356N55KXKestrelx JSX-2 · S/N JSX0055N56864Piper PA-28R-200 · S/N 28R-7435052N59KXKestrelx RISEN SV · S/N 59N60KXKestrelx RISEN SV · S/N 60N6189YPiper PA-23-250 · S/N 27-3415N61KXKestrelx RISEN SV · S/N 61N62KXKestrelx RISEN SV · S/N 62N65344Boeing E75 · S/N 75-6537N66KXKestrelx JSX-2 · S/N JSX0027N66RRBell Helicopter Textron 206L-1 · S/N 45278N735UPCessna 182Q · S/N 18265697N74KKAerotek PITTS S-2 · S/N 2075N75349Condor Powered Parachutes RAPTOR · S/N RA C-6841N756PADiamond Aircraft Ind DA 40 NG · S/N 40.NC246N77KXKestrelx RISEN SV · S/N 45N786KMDiamond Aircraft Ind DA 40 NG · S/N 40.NC153N812LPEmbraer Executive EMB-505 · S/N 50500747N81KXKestrelx RISEN SV · S/N 56N9290NPiper PA-28-181 · S/N 2843108N92KXKestrelx RISEN SV · S/N 57
Back to Lake Mary, FL