Dothan, AL
Registered aircraft · 65
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 = 'DOTHAN' 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 = 'DOTHAN' 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.
N109LSCostruzioni Aeronautiche Tecna P2004 BRAVO · S/N 054N120EADJI AGRAS T40 · S/N 64TBKB80020072N123CHBeech F90 · S/N LA-32N137MCCessna 337 · S/N 337-0127N1457CCirrus Design SR22 · S/N 0547N1730ABellanca 17-30A · S/N 89-301004N17704Beech A36 · S/N E-1008N20LRSmith AEROSTAR 601P · S/N 61P-0192-013N21291Cessna 182P · S/N 18261542N217TXPiper PA-32R-301 · S/N 3246070N21WPBeech A36 · S/N E-336N2382TPiper PA-28-180 · S/N 28-7205031N252YPMooney M20K · S/N 25-1076N2553LDestiny 2000 · S/N 2C0354RWBN258ALPiper PA-28-151 · S/N 28-7615365N2932LMooney M20F · S/N 670326N2942UCessna 172D · S/N 17250542N303QQGlasflugel MOSQUITO B · S/N 177N32MPCessna 172RG · S/N 172RG1019N3337CDJI AGRAS T50 · S/N 63YBM5N00200CLN333MRAeronca 11AC · S/N 11AC-115N3385JCessna 150G · S/N 15066085N343BBeech 95 · S/N TD-2N3836WPiper PA-32-260 · S/N 32-771N3937WPiper PA-32-260 · S/N 32-886N410ECCessna 421B · S/N 421B0422N42781Piper J3C-65 · S/N 15092N43GGRaytheon 390 · S/N RB-160N46154Cessna 172I · S/N 17257075N4702SBell 47D1 · S/N B-101RN4791LPiper PA-28-180 · S/N 28-4127N4880GCessna 172N · S/N 17273427N5000WPiper PA-28 · S/N 28-1N5190CTalos Drones T60X · S/N 78KWN6C00A5BVZN526RVDeweese Alton R JR RV-7A · S/N 72518N5283WPiper PA-28 · S/N 28-332N52SACirrus Design SR22 · S/N 2139N5427ZPiper PA-22-108 · S/N 22-9201Registration pendingN5475RCessna 172F · S/N 17253037N55919Piper PA-28R-200 · S/N 28R-7335312N5745ECessna 150 · S/N 17245N5911MCessna 310P · S/N 310P0211N600WABeech F90 · S/N LA-71N6140HPiper PA-28R-201T · S/N 28R-7803089N621MJones Michael F G-200 · S/N G2001005N64453Cessna 172M · S/N 17265240N646QBeech K35 · S/N D-5841N65TNTownsend Ira P FLIGHTSTAR IISC · S/N 336N69VPPotts Vince RV7A · S/N 70127N701FDMassey Frankie D 701 · S/N 75040
Back to Dothan, AL