OpenAirDocs.org
Staten Island, NY

Registered aircraft · 37

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 = 'NY' AND g.registrant_city = 'STATEN ISLAND'
  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.

N129DWMitsubishi MU-2B-35 · S/N 653Built 1974 · Delta Whiskey LtdN1318TPiper PA-28-180 · S/N 28-7205280Aire-Drifter LLCN143ABMooney M20R · S/N 29-0400Misch KeithN150AYP Z L Koliber 150A · S/N 04940073Built 1995 · Legacy Aviation Foundation IncN2046UCessna 150M · S/N 150-76961Built 1975 · Legacy Aviation Foundation IncN2424VPiper PA-28-140 · S/N 28-7225586Built 1972 · Luvsflying Flight Training LLCN33WJPiper PA-32R-300 · S/N 32R-7780443Built 1977 · Kite Air LLCN3520SCessna 172E · S/N 17250720Built 1963 · Brosnan James MN382WMMiller Wayne LANCAIR 320 · S/N 382Built 2006 · Misch KeithN422BCCessna 560XLS · S/N 560-5723Built 2007 · Medd III Aircraft LLCN44SGBell 47G-3B-1 · S/N 2945Built 1965 · Staten Island Helicopters IncN506DJDassault FALCON 2000 · S/N 158Built 2001 · Jrw Falcon LLCN5202WPiper PA-28 · S/N 28-237Built 1961 · Krishna Ashwin GN533FLPiper PA-28-140 · S/N 28-7125363Luvsflying Flight Training LLCN5341EBeech K35 · S/N D-5795Built 1959 · Katz-Braunschweig Daniel AN5885PPiper PA-24 · S/N 24-970Built 1959 · Costanzo Christopher PN5914VPiper PA-28-161 · S/N 28-7716214Built 1977 · Luvsflying Flight Training LLCN5934VPiper PA-28-161 · S/N 28-7816603Built 1978 · Luvsflying Flight Training LLCN6172ECessna 172 · S/N 46272Built 1958 · Katz Braunschweig Daniel AN68509Bellanca 7ECA · S/N 866-72Luvsflying Flight Training LLCN716TMCanadair CL-600-2B16 · S/N 5344Built 1997 · Titan Strong LLCN731JNVans RV-12 · S/N 120055Monderine Joseph JN734RJCessna 172N · S/N 17269052Built 1977 · Sica JerryN736EEBombardier CL-600-2B16 · S/N 5428Built 1999 · Ailes Dargent I LLCN73852Cessna 172N · S/N 17267721Built 1976 · Carrion JesusN84604Cessna 172K · S/N 17258546Built 1969 · Sky Aviation CorpN89MRGrumman American Avn. AA-5B · S/N AA5B0730Built 1978 · Krute Robert DN9058VMooney M20F · S/N 690006Built 1968 · Pellikan Jake EN9252TPhillips Dusty D SKY RANGER · S/N 3104Rudiger Edward JN9400KPiper PA-28-140 · S/N 28-7625179Built 1976 · Syvanen Janne MN9429SBeech 35-C33 · S/N CD-1000Misch KeithN9547UMooney M20K · S/N 25-0490Built 1980 · Wheels & Wings IncN9737WPiper PA-28-140 · S/N 28-23219Built 1967 · Azzurra City Tours LLCN97689Stinson 108 · S/N 108-689Built 1946 · Gerardi Joseph FN98055Piper PA-28-140 · S/N 28-26016Shkvarok RomanN997JTPiper PA-32R-300 · S/N 32R-7680149Built 1976 · Raskin JamieN9991GCessna 172N · S/N 17273639Sale reported, canceledBuilt 1979
Back to Staten Island, NY