Daytona Beach, FL
Registered aircraft · 398
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 = 'DAYTONA BEACH' 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 = 'DAYTONA BEACH' 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.
N1022SDehavilland DHC-6 TWIN OTTER · S/N 79N102ERPiper PA-28R-201 · S/N 2844081N104ERPiper PA-28R-201 · S/N 2844135N104LFPipistrel D O O VIRUS SW 128 · S/N VSW128F0104N105CHPiper PA-23-250 · S/N 27-7405419N105LELeading Edge Aerial Tech PV40X · S/N 11504N10624Cessna 172S · S/N 172S9825N1087CCessna 172S · S/N 172S10268N112PZCessna 172S · S/N 172S9833N1146CLeading Edge Aerial Tech PV40X · S/N 11446N115ERCostruzioni Aeronautiche Tecna P92 ECHO MKII · S/N 1756N116ERCostruzioni Aeronautiche Tecna P92 ECHO MKII · S/N 1757N117ERCostruzioni Aeronautiche Tecna P92 ECHO MKII · S/N 1758N119RTNorth American T-28B · S/N 138119N1228ABRM Aero Sro BRISTELL S-LSA · S/N 247/2017N1239TPiper PA-34-200 · S/N 34-7250270N127MBCessna 310R · S/N 310R0654N1289YCessna 172S · S/N 172S9851N1309GCessna 172S · S/N 172S10342N13980Piper PA-23-250 · S/N 27-4598N140SHPiper PA-28-140 · S/N 28-22668N1419DCessna 172S · S/N 172S10671N147HACessna 172S · S/N 172S10219N1501ZBeech N35 · S/N D-6824N152PFCessna 152 · S/N 15285380Non-citizen corporation, flight hours not reportedN1533EPiper PA-34-200 · S/N 34-7350050N155SKCessna 152 · S/N 15282657N15839Piper PA-34-200 · S/N 34-7350100N172GTCessna 172L · S/N 17259831N17304Cessna 172S · S/N 172S10643N173RVVans RV-12IS · S/N 12208N177RJCessna 550 · S/N 550-0550N178HLCollier Richard E KOLB MARK III · S/N M3-217N18MWPiper PA-23-250 · S/N 27-3691N1926RTextron 172S · S/N 172S13436N207RVVans RV-12IS · S/N 12213N2111GPiper PA-28-181 · S/N 28-7990416N211DSShinn Douglas LASER Z2300 · S/N S004N2140MPiper J3C-65 · S/N 20925N2151TLeading Edge Aerial Tech PV40X · S/N 11435N2159ALeading Edge Aerial Tech PV35X · S/N 11454N215WTLeading Edge Aerial Tech PV35X · S/N 11453N21692Cessna 172S · S/N 172S9651N217KMVans RV-12IS · S/N 12188N2217DPiper PA-44-180 · S/N 44-7995137N2221RCessna 172R · S/N 17280681N227BHCessna 172S · S/N 172S10662N22904Cessna 172S · S/N 172S9961N229BMCessna 550 · S/N 5500207N2335UCessna 172S · S/N 172S9997
Back to Daytona Beach, FL