Zephyrhills, FL
Registered aircraft · 103
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 = 'ZEPHYRHILLS' 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 = 'ZEPHYRHILLS' 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.
N1011NCessna 172L · S/N 17259525N101SKKolb FIRESTAR · S/N FS04851087N102ALLuther Arthur B RV-6A · S/N 20302N104AJAerojones Aviation USA AJ SPORT · S/N G-1015N105AJAerojones Aviation USA AJ SPORT · S/N G-1017N1202ZBurkhart Grob Flugzeugbau G103 TWIN ASTIR · S/N 3615N121MWSchleicher ASW-15 · S/N 15080Sale reported, pending cancellationN130REAbid Farooqui RECON · S/N 12202201N131SStiner DER JAGER D IX · S/N 131N135JRSchweizer SGS 1-35C · S/N 82N1363QCessna 150L · S/N 15072663N136AJAerojones Aviation USA AJ SPORT · S/N G-1014N143PWGreen Thomas J BABY LAKES · S/N 7114E-347BN15529Piper PA-34-200 · S/N 34-7350072N155SSBurkhart Grob Flugzeugbau G102 ASTIR CS · S/N 1722N185SECessna 152 · S/N 15282935N1927ZCessna 150C · S/N 15059727N192DDEvolution REVO · S/N 000624N199JTPiper PA-24 · S/N 24-2323N202EHDehavilland DHC-6 TWIN OTTER · S/N 48N204EHDehavilland DHC-6 TWIN OTTER · S/N 61N211SKPiper PA-34-200 · S/N 34-7250056N239DGBeech 95-B55 (T42A) · S/N TC-1187N243CGPiper PA-25-235 · S/N 25-5450N2764ZSchweizer SGU 2-22E · S/N 210N2890VCessna 150M · S/N 15076313N2904NCessna 120 · S/N 13165N29JHMolino PIK-20B · S/N 20061N304PBBreezer BREEZER · S/N 006 LSAN321EVEvolution REVOLT · S/N 001052N3486UCessna 182F · S/N 18254886N350TGEvolution REVOLT · S/N 001053N351EVEvolution REVOLT · S/N 001050N3605JCessna 150G · S/N 15064905N3617ESchweizer SGS 1-36 · S/N 16N3621BSchweizer SGS 1-36 · S/N 36N3659APiper PA-22-135 · S/N 22-1919N369XZEvolution REVOLT · S/N 001033N37PLSchleicher ASW-19 · S/N 19190N37WWBurkhart Grob Flugzeugbau G103 TWIN ASTIR · S/N 3092N383BALet L-23 SUPER BLANIK · S/N 008714N3854DCessna 182A · S/N 34554N385SECessna 152 · S/N 15282997N414SGCessna 310P · S/N 310P0067N4222WBurkhart Grob G 103 TWIN II · S/N 3804N42DWAir Creation GTE 582S · S/N T03016N42PMPiper PA-30 · S/N 30-1932N4428DCessna 182A · S/N 34727N465CBRolladen-Schneider LS-4 · S/N 4339N46RPBeech E-90 · S/N LW-193
Back to Zephyrhills, FL