Lakeland, FL
Registered aircraft · 364
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 = 'LAKELAND' 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 = 'LAKELAND' 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.
N10001Waco ASO · S/N A28N1046MBoeing B75N1 · S/N 75-7204N105DEPiper PA-46-701TP · S/N 46020105N106BBeech G35 · S/N D-4394N106FWRockwell International 500-S · S/N 3305N107UADragoon Technology CORIOLIS · S/N 1774FREM101000003559N112SRSwett Scott E BLUE ANGELS · S/N 1LK582CN1153NBoeing A75N1(PT17) · S/N 75-675N1166YCessna 150B · S/N 15059566N117UADragoon Technology CORIOLIS · S/N 1774FREM101000003621N118FWBell 206B · S/N 4182N1216GCessna 414 · S/N 414-0653N1231DCessna 170A · S/N 19785N123KSCessna 172N · S/N 17268627N1255LRandy Larson RANS S-21 OUTBOUND · S/N 04210177N1265HPiper PA-34-200T · S/N 34-7770117N127SSBurkhart Grob Flugzeugbau G102 ASTIR CS · S/N 1170N12WKYoder Miller R. THORP T-18 · S/N 5811N1392WMooney M20C · S/N 2670Sale reportedN141EMDouglas TA-4K · S/N 157915N142EMDouglas A-4K · S/N 154904N144EMDouglas A-4K · S/N 154908N145EMDouglas A-4K · S/N 155052N146EMDouglas A-4K · S/N 155063N147EMDouglas A-4K · S/N 155069N149EMDouglas A-4K · S/N 14085N150EQCessna 150M · S/N 15076259N15538Piper PA-32-260 · S/N 32-7300009N160KSCessna 150M · S/N 15078474N161EMMcdonnell Douglas A4N · S/N 159805N162EMMcdonnell Douglas A4N · S/N 159542N163EMMcdonnell Douglas A4N · S/N 159815N164EMMcdonnell Douglas A4N · S/N 159078N166EMMcdonnell Douglas A4N · S/N 159545N167EMMcdonnell Douglas A4N · S/N 159530N169SSBurkhart Grob Flugzeugbau SPEED ASTIR II · S/N 5047SN170KSCessna 150M · S/N 15079154N1752EAeronca 7AC · S/N 7AC-5319N181CDCirrus Design SR20 · S/N 1083N181JMCessna 180 · S/N 30145N183SErnest R Sanborn SEAREY · S/N 1MK305CN19276Cessna 150L · S/N 15074295N19997Cessna 172M · S/N 17260920N199KFStone Robert A KITFOX MODEL 1 · S/N 199N1SEPiper PA-12 · S/N 12-2036N202NYCessna 172P · S/N 17274198N20357Cessna 172M · S/N 17261219N20397Rich Burris Y MONO-FLY · S/N R-101N2065MKube Robert C RANS S-12 XL AIRAILE · S/N 01970778N20719Commonwealth REARWIN 9000-L · S/N 617D
Back to Lakeland, FL