OpenAirDocs.org
Franklin, NC

Registered aircraft · 24

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL
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 = 'FRANKLIN'
  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.

N1281FCirrus Design SR22 · S/N 9379Built 2023 · Pantheon Aviation LLCN1429FCessna 172H · S/N 17254924Built 1966 · Lathrop MarkN147SDJ David Moore VANS RV-14A · S/N 140470Built 2018 · Stanton Danny LN23346Piper J3C-65 · S/N 3091Built 1939 · Atlanta Airmotive IncN262RNCirrus Design SR22 · S/N 0034Built 2001 · Pro Southern Aviation LLCN2650JCessna 150G · S/N 15065650Built 1966 · Noll Cheryl AN316RBCessna T182T · S/N T18208813Built 2008 · Rbp Management LLCN32HCCirrus Design SR22T · S/N 2420Built 2021 · Drake Sr22 LLCN3651MPiper PA-12 · S/N 12-2601Built 1947 · Atlanta Airmotive IncN44328Piper PA-32-300 · S/N 32-7440150Built 1974 · Riddle Bruce CN500SWCirrus Design SF50 · S/N 0337Built 2022 · Drake Sr22 LLCN511ABCessna 550 · S/N 550-0299Built 1981 · Sl Jet LLCN511JKKnollenberg John D VANS RV-6A · S/N 60293Parcel StephenN641RTRobinson Helicopter R44 II · S/N 11384Built 2006 · Stanton Danny LN7242UBell 206A-1 · S/N 44038Built 1972 · Sl Jet H LLCN735BPCessna 182Q · S/N 18265297Built 1976 · Macon Air LLCN779PTCessna 172M · S/N 17266667Built 1976 · Macon Air LLCN8243ECessna 172N · S/N 17272155Built 1979 · Macon Air LLCN8569BCessna 172 · S/N 36269Spraches Edward JN870DFErcoupe 415-C · S/N 870Built 1946 · Hall William RN90130Cessna 140 · S/N 9191Built 1946 · Duncan John HN928PKOneill Paul N S12 S AIRAILE · S/N 07000925Built 2000 · Tolbert Richard RN9501DPiper PA-22-160 · S/N 22-6416Built 1958 · Belof JoshuaN954RCPeabody Raymond B RV-9A · S/N 90821Built 2011 · Kingsley Duke LLC
Back to Franklin, NC