Lantana, FL
Registered aircraft · 41
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 = 'LANTANA' 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 = 'LANTANA' 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.
N1128MOrlican S R O M-8 EAGLE · S/N 2025020N1422ECessna 172N · S/N 17270991N1592XPiper PA-28-151 · S/N 28-7515427N162ASCessna 172N · S/N 17271785N166RCirrus Design SR20 · S/N 9995N189MKCessna 414A · S/N 414A0100N198GMPiper PA-32-300 · S/N 32-7440126N20JMPiper PA-28-180 · S/N 28-4393N211HPCessna 172P · S/N 17274152N223TTGrumman OV-1D · S/N 67-18899N3584VCessna 150M · S/N 15076553N408MOrlican S R O M-8 EAGLE · S/N 2025021N43034Piper PA-34-200 · S/N 34-7450175N4350EPiper PA-38-112 · S/N 38-78A0571N471ATRobinson Helicopter R22 BETA · S/N 0737N472ATRobinson Helicopter R22 BETA · S/N 0930N473ATRobinson Helicopter R22 BETA · S/N 2578N474ATRobinson Helicopter R22 BETA · S/N 2889N475ATRobinson Helicopter R22 BETA · S/N 2701N476ATRobinson Helicopter R22 BETA · S/N 3263N478ATRobinson Helicopter R44 · S/N 1006N4925FCessna 172N · S/N 17273103N5005NBell 206B · S/N 1931N51HPPiper PA-23-250 · S/N 27-7405412N54360Cessna 172P · S/N 17274963N5631ECessna 172N · S/N 17271906N64608Cessna 172P · S/N 17275592N66046Cessna 172S · S/N 172S9786N711DLPiper PA-34-200 · S/N 34-7350241N7273MCessna 172R · S/N 17280761N731WAPiper PA-34-200 · S/N 347350245N737SACessna 172N · S/N 17269629N772CBRobinson Helicopter R44 II · S/N 12357N785ASCessna 172M · S/N 17262954N80961Cessna 172M · S/N 17266820N825PBPiper PA-28-181 · S/N 28-7890442N82ZAAmerican General Acft AG5B · S/N 10082N88385Bellanca 7GCBC · S/N 775-75N907JWCessna 172S · S/N 172S10328N953GVCostruzioni Aeronautiche Tecna P2006T · S/N 222/USN9898MOrlican S R O M-8 EAGLE · S/N 2024016
Back to Lantana, FL