Registered aircraft · 22

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

N104FPColumbia Aircraft Mfg LC42-550FG · S/N 42513Built 2006 · Autowashlbt LLC N2193QCessna 177RG · S/N 177RG0593Built 1974 · Gerber John T N2756TSadler Terry A ZENITH 701 · S/N 5529Built 2004 · Carter Terry M N308HBBell OH-58A · S/N 71-20764Robeson County Sheriffs Office N3919FCessna 172 · S/N 36819Built 1958 · Konkol Roger E N403AFRozier Ricky PHANTOM · S/N 622Built 1996 · Rozier Ricky N4231QPaxton Richard W AVID FLYER SPEEDWING · S/N 919Built 1990 · Rozier Ricky N50274Cessna 150H · S/N 15069186Built 1968 · Currie William O N5370TPiper PA-28R-200 · S/N 28R-7235228Built 1972 · K.M. Biggs Inc N5554JPiper PA-32-260 · S/N 32-1017Built 1968 · C M Lindsay And Sons Inc N5653PPiper PA-24 · S/N 24-724Built 1959 · Beasley Charles R N576DGCirrus Design SR22 · S/N 1617Built 2005 · Edge David Lee N62MCDiamond Aircraft Industries GM DA 62 · S/N 62.062Built 2017 · Rust Aviation LLC N6573UMooney M20C · S/N 2355Built 1962 · Alvis Michael E N7431WPiper PA-28-180 · S/N 28-3758Built 1966 · Konkoi Roger E N788PCessna 182M · S/N 18259337Built 1968 · William Earl Dixon LLC N80DWCessna 310C · S/N 35782Sale reported, pending cancellationBuilt 1958 N86766Bellanca 14-13-2 · S/N 1127Built 1946 · Best Charles K N89MTTurner Mark R EXPRESS FT · S/N 34Built 1996 · Turner Mark R N9431JPiper PA-28-180 · S/N 28-3542Built 1966 · Currie Kenneth Edward N9481WPiper PA-28-235 · S/N 28-11216Built 1968 · Mcintyre Stephen C N9648BMichael A Mcgrew HARTZ CLASSIC · S/N 838Built 2012 · Barker David C

Back to Lumberton, NC