OpenAirDocs.org
Brewton, AL

Registered aircraft · 20

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 = 'BREWTON'
  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.

N1107VHughes 269C · S/N 1201015Built 1981 · Darkstar Drones LLCN1150ZBeech B19 · S/N MB-582Lundin RonnyN12474Cessna 172M · S/N 17262004Tail No N12474 LLCN133ADDJI AGRAS T40 · S/N 5X5BLAU002059MDarkstar Drones LLCN20019Cessna 172M · S/N 17260935Built 1972 · Mccall Freddie WN2123ECessna 182T · S/N 18281331Built 2004 · Dream Flights LLCN21872Firefly Balloons FIREFLY 7-15 · S/N F7-2042Mccall Freddie WN244XDDJI AGRAS T40 · S/N 64TBL7K00200AHDarkstar Drones LLCN3034WMaule MXT-7-180 · S/N 14040CMccall FreddieN363HCCessna 510 · S/N 510-0033Built 2007 · Milligans Hurri-Clean LLCN4381JPiper PA-28-140 · S/N 28-22768Built 1967 · Pugh Robert RandallN46NMTextron T206H · S/N T20609685Built 2022 · Hurri-Clean LLCN5305TCessna 172E · S/N 17251205Built 1964 · Mccall Freddie WN60429Cessna 150J · S/N 15070299Mccall FreddieN6067FCessna 182P · S/N 18264083Built 1975 · Pitts RyanN6802FCessna 150F · S/N 15063402Built 1966 · Mccall Freddie W JrN7334QCessna 182P · S/N 18260974Built 1972 · Hurri-Clean LLCN736UBCessna R172K · S/N R1722789Built 1977 · Mccall FreddieN738RNCessna 172N · S/N 17270179Mccall Freddie WN9550BCessna 172RG · S/N 172RG0872Built 1981 · Mccall Freddie W
Back to Brewton, AL