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

N13402Cessna 172M · S/N 17262731Built 1973 · Cartwright Edward N N1977KLuscombe 8E · S/N 4704Built 1947 · Cartwright Edward N N241DMVans RV-12 · S/N 120345Built 2013 · Millsap Dennis W N2450CPiper PA-38-112 · S/N 38-79A0191Built 1978 · Cartwright Edward N N26284Stinson 10 · S/N 7570Rupke Curtis N30ZYBaker Letitia D SAFARI · S/N 78109Built 2024 · Lewis Charles A N35KBCub Crafters CC11-100 · S/N CC11-00034Built 2007 · Lewis Charles A N498FUDJI AGRAS T100 · S/N 1581F8ZLC25B5002VJK4Aero X Precision Ag LLC N499FUDJI AGRAS T100 · S/N 1581F8ZLC25B60027Q5TAero X Precision Ag LLC N5168TChampion 7KCAB · S/N 12Built 1967 · Vrooman Lawrence M N5220PPiper PA-24 · S/N 24-247Built 1958 · Stancil Thomas E III N6151PPiper PA-24-250 · S/N 24-1252Built 1959 · Roberson Michael B N7046ZPiper PA-25-235 · S/N 25-2812Built 1964 · Vrooman Lawrence M N7060UHunter James J HUNTER TR-1 · S/N 106Built 2005 · Cressman Gary M N70910Cunningham Bob KITFOX II · S/N 246Built 2001 · Mozingo John C N77PLPiper PA-20 · S/N 225793Built 1957 · Vrooman Lawrence M N8FMRaytheon A36 · S/N E-3068Built 1997 · Sky Dawg LLC

Back to Winterville, NC