Registered aircraft · 17

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 = 'NC' AND g.registrant_city = 'NORWOOD' 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 = 'NC' AND g.registrant_city = 'NORWOOD'
  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 = 'NC' AND g.registrant_city = 'NORWOOD'
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.

N147RPRandy Thomas Pinkston RV7 · S/N 70092Built 2017 · Pinkston Randy Thomas N18948Beech C23 · S/N M-1978Built 1977 · Page Don S N235HPCessna 182S · S/N 18280333Built 1998 · 235hp LLC N262CWPiper PA46R-350T · S/N 4692028Cirrusly Flying LLC N400PAPiper PA-24-400 · S/N 26-54Built 1964 · N6105s LLC N442TALancair LC41-550FG · S/N 41532N6105s LLC N4449AProsser Michael W PROSSER HUMMELBIRD · S/N 3059-PBuilt 2002 · Shuford Bobby M N46105Aeronca 65-TAC · S/N C4252-TABuilt 1942 · Nelson Kenneth D N6873CPiper PA-32RT-300 · S/N 32R-7885034Built 1978 · Mabry Roger Louis Jr N70886Piper J3C-65 · S/N 17906Simpson Robert W N7120QCessna 172L · S/N 17260420Built 1972 · Clodfelter Terry Lynn N7140WPiper PA-28-180 · S/N 28-944Built 1962 · Devers Malcolm W N750THBeech C24R · S/N MC-765Built 1981 · Miller Robert T N751LBPiper PA-32R-301 · S/N 3246228Built 2005 · N6105s LLC N775PRDJI AGRAS T50 · S/N 1581F6BUB243S00189SEMcswain Agri-Tech Llp N81006Piper PA-32R-301 · S/N 32R-8013010Built 1979 · Wicked Wings LLC N8566TCessna 182C · S/N 52466Built 1959 · Wiggins Jeffrey W

Back to Norwood, NC