Registered aircraft · 28

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

N1306QCessna 150L · S/N 15072606Compton Kenneth Dale N156KMCubcrafters CC11-160 · S/N CC11-00171Fox Gary Allen N180TLCessna 182Q · S/N 18266584Built 1978 · Doebler H Andrew N184CGGallenbach Craig RV8A · S/N 82280Built 2008 · Gallenbach Craig M N235TMRaymond Thwaites T51 · S/N M08SV6S0HK0133Built 2009 · Fox Gary A N23777Cessna R172E · S/N R1720096Erb Ralph J N307DBLanny Dean Brister RV-7A · S/N 72312Built 2022 · Sepko Joseph M III N3092QYoung John FLYBABY · S/N 1161JYMeeks James M N3152EBeech A36 · S/N E-2880Built 1994 · Regional Medical Consulting Pllc N336DWJonathan E Bryant VANS RV-10 · S/N 40822Built 2014 · Bryant Jonathan E N336LLBryant Jonathan E PITTS MODEL 12 · S/N 142Built 2023 · Bryant Jonathan E N358VABadia Alejandro R RV-6A · S/N 25218Built 2013 · Chapman James H N44LZPearsall Donald G LONG-EZ · S/N 864Dyer Stuart T N4599BCessna 180 · S/N 614Built 1954 · Agua Viva Ministries N49078Cessna 152 · S/N 15281137Radar Aviation LLC N5468WPiper PA-28-160 · S/N 28-549Built 1962 · Sitton David F N565RWWaddell James C RV-9A · S/N 91969Built 2020 · Waddell James C Trustee N6095ECessna A185F · S/N 18503996Built 1980 · Smith Douglas Derek N6458PPiper PA-24-250 · S/N 24-1573Built 1959 · Hutchison Joseph C N6689NBeech A36 · S/N E-1622Built 1979 · Moore Christopher J N71BNCubcrafters CC11-160 · S/N CC11-00107Built 2009 · Swanson Robert B N721WBColumbia Aircraft Mfg LC41-550FG · S/N 41107Built 2005 · Fox Gary A N731DMMcmanness David M VANS RV7A · S/N 001Built 2006 · Dyer Tim N819VABadia Alejandro R RV-10 · S/N 41173Built 2025 · Badia Alejandro R N821BDCirrus Design SF50 · S/N 0031Built 2018 · Working Fire Aviation LLC N848PPolk J G SHA-GLASAIR · S/N 485RWagoner Teddy J N8717VBellanca 7KCAB · S/N 523-75Built 1975 · Sepko Joseph M III N888REMooney M20R · S/N 29-0291Built 2003 · Dill Harry H Trustee

Back to Mebane, NC