OpenAirDocs.org
Oxford, NC

Registered aircraft · 29

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

N16223Cessna 150L · S/N 15073555Flyhnz LLCN170PRCessna 170B · S/N 25686Built 1953 · Hicks Arch AN177TGCessna 177RG · S/N 177RG0999Built 1976 · Serenity Aviation LLCN19878Cessna 172M · S/N 17260827Built 1972 · Oxford Flying Club LLCN2115Globe GC-1B · S/N 1152Welsh Christopher MN2975ZPiper PA-22-150 · S/N 22-6949Built 1959 · Hesse Paul WilliamN300RFJordan Bruce C JR PITTS SPECIAL S1S · S/N BJ-2Built 1983 · Rivers Robert AN3503BBeech E35 · S/N D-3721Built 1954 · Welsh Steven MN4346RCessna 172M · S/N 17263097Built 1974 · Flyhnz LLCN4395PPiper PA-23-160 · S/N 23-1904Built 1960 · Hesse Paul WN445PRaytheon A36 · S/N E-3415Built 2001 · Welsh Steven MN45520Cessna 150M · S/N 15076958Built 1975 · Frazier John CN4758WRockwell International 114 · S/N 14088Built 1976 · Blevins Larry Standley JrN5144LCessna 152 · S/N 15284270Built 1980 · Empire AviationN58659Cessna 182P · S/N 18262213Built 1973 · Friis KarstenN614USRonald S Jarrell VANS RV-14A · S/N 140671Built 2021 · Welsh Steven MN6537HCessna 172M · S/N 17265480Built 1975 · Rivers Robert AN68608Cessna 152 · S/N 15282317Built 1978 · Oxford Aircraft Leasing LLCN70652Piper J3C-65 · S/N 17670Built 1946 · Riggan Charles HN721BHWilliam Hammond PREDATOR · S/N 072148Built 2015 · Kerns Rodney LN7561FChampion 7KCAB · S/N 267-70Built 1969 · Rivers Robert AN7628EBellanca 14-19-3 · S/N 4130Built 1959 · Welsh ChristopherN7698WPiper PA-28-180 · S/N 28-1690Flyhnz LLCN8428BPiper PA-28-181 · S/N 28-8190304Built 1981 · Higgins JamesN8432CPiper PA-28-140 · S/N 28-7625117Built 1976 · Empire AviationN8432UCessna 172F · S/N 17252332Built 1964 · Hesse Paul WN8644SCessna 150F · S/N 15061944Built 1965 · Riggan Charles HN952JCCarver Jack E CARVER GLASTAR GS-1 · S/N 5282Built 2004 · Carver Jonathan EN9971DPiper PA-22-160 · S/N 22-6762Ahern Daniel Patrick
Back to Oxford, NC