Clearwater, FL
Registered aircraft · 145
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 = 'CLEARWATER' 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 = 'CLEARWATER' 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.
N100VQLearjet 24 · S/N 140N1040DTextron 208B · S/N 208B5628N10BNPiper PA-34-200T · S/N 34-7570050N110CXCessna 750 · S/N 750-0077N111XLBeech A60 · S/N P-197N11590Cessna 150L · S/N 15075546N116MRMichael Dibuono BAKENG DEUCE · S/N 0700N1200VCessna 172S · S/N 172S10394N1239PPiper PA-28-236 · S/N 28-7911207N123FKMooney M20C · S/N 3003N13053Cessna 172M · S/N 17262460N1317PPiper PA-23 · S/N 23-357N140KMCessna 414A · S/N 414A-0674N1424XPiper PA-28-151 · S/N 28-7515318N1476UCessna 172M · S/N 17267143N14806Airbus Helicopters AS350B3 · S/N 9341N150NDSocata TB 9 TAMPICO · S/N 1186N161DDavid Fulper FULPER GLASTAR · S/N 5745N169LATextron G58 · S/N TH-2494N16NLCessna 501 · S/N 501-0043N174MRRegen Michael L REGEN RV7A · S/N 71956N1762HPiper PA-28-181 · S/N 28-7790340N1789MCessna 208B · S/N 208B2245N191WSHonda HA-420 · S/N 42000155N1SDAirbus Helicopters AS350B2 · S/N 8024N2044FFirefly Balloons FIREFLY 7-15 · S/N F7-2058N2047WBeech V35 · S/N D-7986N20ETSocata TB 10 · S/N 621N21786Mooney M20R · S/N 29-0194N224RXFrieder Kemmann VELOCITY STD-FG · S/N SFG014N234RCCessna R182 · S/N R18202012N237RVAlan J Cook RV7A · S/N 72620N2382RCessna 172R · S/N 17280700N240JKLearjet 60 · S/N 137N248LGCessna 510 · S/N 510-0311N249VAVans RV-12 · S/N 12022N2554KCessna 180K · S/N 18052985N257PCBell 47G-5A · S/N 25077N289AWLearjet 35A · S/N 628N2967ECessna 172N · S/N 17271391N2SDEurocopter AS 350 B2 · S/N 4099N3003QPiper PA-28-181 · S/N 28-7790430N30919Piper PA-32-300 · S/N 32-7840125N31724Piper PA-32RT-300 · S/N 32R-7885126N33068Piper PA-28-235 · S/N 28-7510037N330FTPiper PA-28-161 · S/N 28-8216209N3332BRaytheon A36 · S/N E-3140N333MLEpic E1000 · S/N K039N3363APiper PA-22-135 · S/N 22-1665N34826Rearwin 8135 · S/N 883
Back to Clearwater, FL