Gulf Shores, AL
Registered aircraft · 36
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 = 'AL' AND g.registrant_city = 'GULF SHORES' 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 = 'AL' AND g.registrant_city = 'GULF SHORES' 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.
N1017PPiper PA-23 · S/N 2319N168HJHonda HA-420 · S/N 42000168N178NCTl-Ultralight S R O TL 2000 STING S4 · S/N 16 ST 446N2886WBeech V35B · S/N D-9512N34671Cessna 177B · S/N 17701932N405TBCessna T182T · S/N T18208608N4144UCessna 150D · S/N 15060144N417EVCirrus Design SR20 · S/N 11069N4468YPiper PA-25-235 · S/N 25-4120N4494YPiper PA-25-235 · S/N 25-4161N44FRCessna 550 · S/N 550-0334N4601GCessna 172N · S/N 17273270N4736MBeech A36 · S/N E-2243N5125WPiper PA-28-160 · S/N 28-151N5349XPitts Aerobatics S-2B · S/N 5110N5383FPiper PA-32R-300 · S/N 32R-7680521N5707KBeech S35 · S/N D-7505N5727ECessna 172N · S/N 17271928N5865UPiper PA-28-140 · S/N 28-26697N6464BCessna 172 · S/N 29664N66519Beech A36 · S/N E-2054N69938Cessna 310Q · S/N 310Q1029N757GXCessna 152 · S/N 15279739N76SGRobinson Helicopter R44 II · S/N 11293N795WRChristner W/Christner R RV-4 · S/N 2982N806GCGilbert E Cargill LANCAIR LEGACY · S/N L2K-224N8158ZPiper PA-28-161 · S/N 28-8016269N8173LCirrus Design SR20 · S/N 1380N8176DPiper PA-18 · S/N 18-6104N84158Aeronca 7AC · S/N 7AC-2845N8587TPiper PA-32-300 · S/N 32-7340022N8815TCessna 182C · S/N 52715N8927VCessna 172M · S/N 17264284N9199PPiper PA 46-350P · S/N 4622107N9348YBeech 35-A33 · S/N CD-256N97009Stinson 108 · S/N 108-1009
Back to Gulf Shores, AL