Auburndale, FL
Registered aircraft · 45
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 = 'AUBURNDALE' 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 = 'AUBURNDALE' 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.
N13084Cessna 177B · S/N 17702397N1426TPiper PA-32-260 · S/N 32-7200038N143AADiamond Aircraft Ind DA20-A1 · S/N 10183N1910MCessna 182P · S/N 18264475N192SPRandy K Nageotte AIRCAM · S/N AC128N2027UBeech 58 · S/N TH-964N20443Cessna 172M · S/N 17261291N2066NBeech V35B · S/N D-10215N210RBCessna T210N · S/N 21064716N212GKVans RV-12 · S/N 120617N2654LCessna 172H · S/N 17255854N28SKPiper PA-28-140 · S/N 28-24940N2985NCessna 120 · S/N 13243N30511Piper PA32-301XTC · S/N 3255005N321TBBeech A36 · S/N E-1998N32566Maule MXT-7-180 · S/N 14137CN32700Piper PA-28-140 · S/N 28-7525099N33296Cessna 177RG · S/N 177RG0946N3465DCessna 170B · S/N 27008N3543KPiper J3C-65 · S/N 22234N441EDAlister N Crighton MUSTANG II · S/N 327N4791HMooney M20J · S/N 24-0881N4867DCessna 172N · S/N 17272378N517KBCorkins W J/Corkins K A GLASAIR III · S/N 3300N55349Cessna 172P · S/N 17275163N5552KBellanca 7ECA · S/N 1257-78N55711Piper PA-28R-200 · S/N 28R-7335276N6031DPiper PA-22-150 · S/N 22-4684N6154GCessna 150K · S/N 15071654N627TBeech K35 · S/N D-5747N6950ACessna 172 · S/N 29050N7163RPiper PA-28-140 · S/N 28-21872N732WNCessna T210M · S/N 21061834N7362WPiper PA-28-180 · S/N 28-1242N7517VCessna 177RG · S/N 177RG0814N777WDBeech M35 · S/N D-6491N78464Cessna 172K · S/N 17257627N801SRProgressive Aerodyne SEAREY · S/N 1MK283First renewal noticeN806NDPiper PA-28R-201 · S/N 2837009N8132LGroover Larry EAGLE · S/N 5764N8555HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1405N86KWKellett Kenneth W SUPERCUBY · S/N 1N8862CBen-Itzhak R/David D/Karny E SUPER DRIFTER · S/N LA1066N92488Piper J3C-65 · S/N 16963N9717BCessna 172RG · S/N 172RG0987
Back to Auburndale, FL