Registered aircraft · 22

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'TONEY' ORDER BY g.n_number

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

N126PMGraves Larry DAVIS DA-2B · S/N 262Mcgill Phil N130WHHill G W/Woodard R E SHA GLASAIR · S/N 130Built 1990 · Woodard Russell E N180MSCessna 180J · S/N 18052551Built 1975 · Velociraptor Aviation LLC N18ZThorp T-18 · S/N 394Built 1971 · Mays Paul R N2162JHead Balloons AX8-105 · S/N 343Maddox Jeffrey A N2302ZBeech 23 · S/N M-5Built 1962 · Johnson Melvin L N3228BPiper PA-22-135 · S/N 22-2057Scites Robert N3357MPiper PA-12 · S/N 12-2049Built 1947 · Smith James R N34189Schweizer SGS 1-35 · S/N 39Built 1975 · Mays Paul R N3983JCessna 150G · S/N 15065283Built 1966 · Voizin Thomas J N4511KCameron Balloons US Z-105 · S/N 6324Built 2002 · Maddox Jeffrey A N456WMMustaikis S/Wright A WRIGHT MUSTAIKISRV6A · S/N 001Built 2001 · Wright Alfred M N477PSSilver Patrick F RV-9A · S/N 91796Built 2016 · Silver Patrick F N50004Cessna 150H · S/N 15069001Built 1968 · Nichols Jonathon L N54523Guy-Fox GREAT LAKES 2T-1 · S/N 6704E-329Built 1978 · Smith James R N641BZWilkes Brett DRIFTER · S/N LL1041Built 2010 · Barber Christopher A N699DMAmerican Champion 7GCAA · S/N 56Built 1966 · Barber Christopher A N7114GBalloon Works FIREFLY 7 · S/N F7-413Parrish Johnathon G N7700PPiper PA-24-250 · S/N 24-2911Built 1961 · Barber Chris N8503CPiper PA-22-135 · S/N 22-1215Built 1953 · Scites Robert W N8809Bellanca 7ECA · S/N 929-73Built 1973 · Velociraptor Aviation LLC N95080Piper PA-28-140 · S/N 28-25800Built 1969 · Johnson Patrick W

Back to Toney, AL