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

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

N318MCClegg Marvin MXL II SPORT · S/N 280Built 1992 · Trail William H N3801KGlobe GC-1B · S/N 1494Built 1946 · Lanier John M N4134EAeronca 11CC · S/N 11CC-42Built 1947 · Pierce David R N4312KRyan NAVION · S/N NAV-4-1312Built 1948 · Jorsey Allen Jr N4353ESanders George W JR JB-1 · S/N GS 002Built 1992 · Brinson Dara H N486HVans RV-12 · S/N 120006Built 2011 · Scarborough Robert J N51040Cessna 150J · S/N 15069721Built 1968 · Pruitt Benny G N54441Piper PA-32-260 · S/N 32-7400019Built 1973 · Lynn David Leander Jr N55517Piper PA-28-235 · S/N 28-7310146Built 1973 · Loye Mark C N5915DPiper PA-22-150 · S/N 22-4577Built 1956 · Mason Jack A N6030NCessna 162 · S/N 16200057Built 2011 · Thomas Scott C N7068NBeech D55 · S/N TE-480Washburn Donald Kevin N75YBell 206B · S/N 4304Built 1994 · Linville Manor LLC N82724Aeronca 7AC · S/N 7AC-1371Built 1948 · Trail William H N8429XPiper PA-32R-301 · S/N 32R-8113105Built 1981 · Linville Manor LLC N85088Aeronca 7AC · S/N 7AC-3817Built 1946 · Knowles Greg N852BBottegal Richard CORBEN JUNIOR ACE · S/N BB912Built 2010 · Robinson Alexander C N8555SCessna 182H · S/N 18256655Built 1965 · Bray Harvey G N926SGGriggs Sam SPORT TRAINER · S/N 1Built 2001 · Thomas Scott C N9650XCessna 210B · S/N 21057950Built 1962 · Jorsey Elizabeth A

Back to Reidsville, NC