Lutz, FL
Registered aircraft · 75
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 = 'LUTZ' 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 = 'LUTZ' 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.
N103DCCessna 150L · S/N 15075419N104LBoeing A75L300 · S/N 75-2541N10980Cessna 150L · S/N 15075184N15593Piper PA-28-140 · S/N 28-7325110N1615ECessna 172N · S/N 17271067N17TCessna 337D · S/N 337-0990N20571Cessna 172M · S/N 17261404N208PBeech 58 · S/N TH-1626N2266XCessna 337 · S/N 337-0166N25032Piper J3F-65 · S/N 3611N2620JCessna 150G · S/N 15065620N262AKMooney M20K · S/N 25-0593N265CBEurocopter EC120B · S/N 1458N2872KCessna 180K · S/N 18053108N29699Glasflugel MOSQUITO · S/N 37N308MWWayne AL18 · S/N AL402N308NGAviat A-1C-180 · S/N 3220N309RAvia Stroitel AC-5M · S/N 009N3173XCessna 150G · S/N 15064573Registration pendingN331BEBeech C23 · S/N M-2300N336JBCessna 336 · S/N 336-0071N337CCessna 337C · S/N 337-0905N3665Cassutt IIIM · S/N 45N367TJCessna 182P · S/N 18263721N369KCClarence Keith Carver VANS R-V6 · S/N 60264N44CZCo-Z Development COZY MARK IV · S/N 1N46211Cessna 172I · S/N 17257112N463JWJeffrey W Wright AR-1 · S/N 0028N4719MPiper PA-11 · S/N 11-227N4781NCessna 182Q · S/N 18267364N4783LPiper PA-28-180 · S/N 28-4118N497TZCirrus Design SR22 · S/N 8773N4FQGobin Henry E GN-1 AIRCMPR-PTNPOL · S/N FQ1N500BPBolkow PHOEBUS C-1 · S/N 795N54KHCessna 172N · S/N 17272726N551BGCessna 182P · S/N 18262018N55780Piper PA-28-140 · S/N 28-7325483N5616TGlobe GC-1A · S/N 68N56671Piper PA-28-235 · S/N 28-7410021N566EDDJI PHANTOM 3 PROFESSION · S/N P76DCG18011594N568WAPiper PA-28-140 · S/N 28-7325162N573DLEmbraer-Empresa Brasileira De EMB-505 · S/N 50500088N5890VPiper PA-28-181 · S/N 28-7790508N6031YLindstrand Balloons 77A · S/N 5131N61ERCady Clifford L E RACER · S/N 9N62715Piper PA-28-140 · S/N 28-23382N6278ECessna 172 · S/N 46378N6356GCessna 150K · S/N 15071856N63727Nanchang China CJ-6A · S/N 1832035N649RSDonaghy Bob RENEGADE SPIRIT · S/N 649
Back to Lutz, FL