OpenAirDocs.org
Providence, RI

Registered aircraft · 30

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

N1085ZMooney M20M · S/N 27-0040Built 1990 · Beehive Communications IncN11913Cessna 150L · S/N 15075706Built 1974 · Sharkey Peter TN181JAgustawestland Philadelphia AW139 · S/N 41544Built 2018 · Powderbird LLCN1820WBeech 77 · S/N WA-289Built 1981 · Boos Lynette JN200VABeech 200 · S/N BB-246Built 1977 · Vargus Group IncN201ACGulfstream Aerospace GVI (G650ER) · S/N 6551Built 2023 · Wilmington Trust Co TrusteeN226ECBombardier CL-600-2B16 · S/N 5090Built 1991 · Bcp Fa Ap LLCN227YZMaule M-7-235C · S/N 25078CBuilt 2002 · Turtle Partners II LLCN238LMLearjet 45 · S/N 039Built 1999 · Bcp Fa Ap LLCN268PCIai GULFSTREAM G280 · S/N 2205Banc Of America Leasing & Capital LLCN27YZAmerican Legend AL3 · S/N AL-1167Built 2012 · Turtle Partners II LLCN318LEGulfstream Aerospace GVII-G600 · S/N 73052Built 2021 · Banc Of America Leasing & Capital LLCN31XAmerican Champion 8KCAB · S/N 671-92Built 1992 · Everson Dustin JN411BTBoeing PT-17 · S/N 752455Built 1941 · Everson Dustin JN412GAPilatus PC-12/47E · S/N 2390Built 2024 · Wilmington Trust Co TrusteeN4379DPiper PA-28-161 · S/N 28-8516029Built 1985 · Rustambekov ElzotbekN507TSCessna 750 · S/N 750-0507Built 2014 · Textron IncN509CXCessna 750 · S/N 750-0509Built 2014 · Textron IncN612GAPilatus PC-12/47E · S/N 2396Built 2024 · Wilmington Trust Co TrusteeN641SPCessna 172S · S/N 172S8049Rhode Island Air LLCN6641PPiper PA-24-250 · S/N 24-1763Built 1960 · Martinous Shawn AN6730PPiper PA-24-250 · S/N 24-1857Built 1960 · Shea Kelly PN703CXTextron 700 · S/N 700-0003Built 2017 · Textron IncN703MAPiper PA-32R-301 · S/N 3246202Built 2001 · Everson Dustin JN733NQCessna 172N · S/N 17268423Built 1976 · Perlman Elliot MN75TXCessna 750 · S/N 750-0132Built 2000 · Textron IncN780RWGulfstream Aerospace GVI (G650ER) · S/N 6442Built 2020 · Banc Of America Leasing & Capital LLCN7898Schempp-Hirth STANDARD CIRRUS · S/N 45Built 1970 · Everson JohnN812GAPilatus PC-12/47E · S/N 2447Built 2025 · Wilmington Trust Co TrusteeN816KYRaytheon HAWKER 800XP · S/N 258680Built 2004 · Bcp Fa Ap LLC
Back to Providence, RI