OpenAirDocs.org
Warwick, RI

Registered aircraft · 36

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 = 'RI' AND g.registrant_city = 'WARWICK'
  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.

N1276VCessna T303 · S/N T30300262Built 1984 · New Horizon Aviation IncN1283QCessna 150L · S/N 15072583Built 1971 · Macaruso Matthew HN129WSCessna 172S · S/N 172S10012Built 2005 · New Horizon Aviation IncN139DZAero Vodochody L39C · S/N 035118Built 1990 · Pitts M12 LLCN15006Piper PA-28R-200 · S/N 28R-7235315Built 1972 · Corio Salvatore J JrN1608SCessna 172S · S/N 172S9907Built 2005 · New Horizon Aviation IncN19482Beech D17S · S/N 254Built 1938 · Pitts M12 LLCN20125Beech 76 · S/N ME-94Built 1978 · New Horizon Aviation IncN2092XPiper PA-28-161 · S/N 28-7916342Built 1979 · Airx LLCN21966Cessna 150L · S/N 15074574Built 1973 · Barrette Richard Arthur IIIN2248UPiper PA-28-161 · S/N 28-7916316Built 1979 · North Central Flight Center LLCN2459YCessna 172R · S/N 17280909Built 2000 · New Horizon Aviation IncN2744MPiper PA-28R-201T · S/N 28R-7803142Built 1977 · Cas Aviation LLCN327DZFagen Evan PITTS MODEL 12 · S/N 004Built 2010 · Pitts M12 LLCN327XAmerican Champion 8KCAB · S/N 1058-2007Built 2008 · New Horizon Aviation IncN33659Piper PA-28-151 · S/N 28-7515351Built 1975 · North Central Flight Center LLCN429TXBell Helicopter Textron Canada 429 · S/N 57018Textron IncN44421Piper PA-28-151 · S/N 28-7415636Built 1974 · Rojas AlissaN470UCessna 172R · S/N 17280415Built 1998 · New Horizon Aviation IncN4900HCessna 152 · S/N 15284009Built 1980 · New Horizon Aviation IncN49185Cessna 152 · S/N 15283435New Horizon Aviation IncN503SPCessna 172S · S/N 172S8040Built 1998 · New Horizon Aviation IncN5099VCessna 172RG · S/N 172RG0449Built 1980 · New Horizon Aviation IncN53569Cessna 172S · S/N 172S9395Built 2003 · New Horizon Aviation IncN53577Cessna 172S · S/N 172S9399Built 2003 · New Horizon Aviation IncN59BJMooney M20C · S/N 2968Built 1965 · Walser Air LLCN67995Cessna 152 · S/N 15282128Built 1978 · New Horizon Aviation IncN70WRRussel W F SR FALCO F.8L · S/N 1256Valtz Victoria KN7329JPiper PA-28-140 · S/N 28-24683Built 1968 · Walser Air LLCN7471SNorth American AT-6C · S/N 8814167Built 1943 · Lonestar 6 LLCN757TDCessna 152 · S/N 15279984Built 1977 · New Horizon Aviation IncN7793CPiper PA-28-181 · S/N 28-7690082Built 1975 · Paolucci James HN8417HPiper PA-34-220T · S/N 34-8133178Built 1981 · Walser Air LLCN8525JCessna 150G · S/N 15066425Bicknell Hilary EN9375NPiper PA-28R-200 · S/N 28R-35084Built 1969 · Proffitt Albert E IIIN9905FCessna 172R · S/N 17280184Built 1997 · New Horizon Aviation Inc
Back to Warwick, RI