Registered aircraft · 16

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

N1529Robert J. Goodyear SONEX · S/N 1227Built 2012 · Goodyear Robert J N2801XCessna 177 · S/N 17700201Built 1967 · Jones Daniel L N3780TPiper PA-28R-180 · S/N 28R-30092Built 1967 · Bowley Leonard N3977NMooney M20F · S/N 680151Built 1968 · Kelley Daniel P N43234Piper PA-28-151 · S/N 28-7415451Built 1974 · Level Up Aviation LLC N4597TPiper PA-28R-200 · S/N 28R-7235104Built 1972 · Arsenault Ronald L Jr N5352WPiper PA-28 · S/N 28-413Registration pendingBuilt 1962 N555XGoodyear Robert J HUMMEL BIRD · S/N HB-3460Built 2005 · Goodyear Robert J N55701Piper PA-28-140 · S/N 28-7325460Built 1973 · Level Up Aviation LLC N596PHPiper PA-28-140 · S/N 28-24782Built 1968 · Ott Juston E N63WSCessna 210D · S/N 21058333Built 1964 · Cooks Saw Manufacturing LLC N6899FPiper PA-28-140 · S/N 28-7725081Built 1976 · Level Up Aviation LLC N76ATThompson STARDUSTER TOO SA300 · S/N 1081Built 1977 · Carney Raymond L N7945YPiper PA-30 · S/N 30-1039Built 1966 · Level Up Aviation LLC N8410CPiper PA-28-151 · S/N 28-7615105Built 1976 · Level Up Aviation LLC N903THHonda HA-420 · S/N 42000224Built 2021 · Light Moon LLC

Back to Newton, AL