Registered aircraft · 19

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

Query with SQL

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 = 'BAY SHORE' ORDER BY g.n_number

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 = 'BAY SHORE'
  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.

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 = 'BAY SHORE'
ORDER BY g.n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N1561HCessna 177RG · S/N 177RG0735Built 1975 · Torpey Richard T N2868FCessna 182J · S/N 18256968Built 1966 · Brown Isabelle R N3257FMooney M20E · S/N 670050Built 1967 · Brandon M Ten Hoopen N43158Piper PA-28-151 · S/N 28-7415435Built 1974 · N43158 LLC N4317TPiper PA-28-181 · S/N 28-8490002Built 1983 · Spanku LLC N4487CCessna 195B · S/N 16071Built 1953 · Baldeo Kessho I N5241ECessna 172N · S/N 17271792Built 1978 · Baldeo Kessho I N53292Boeing D75N1 · S/N 75-3856Built 1942 · Cifelli Michael N5390QCessna 150L · S/N 15073290Ignarro Jessie N5448UBeech 56TC · S/N TG-14Built 1967 · Mathews Roy N6605XBeech F33A · S/N CE-1016Built 1983 · Cifelli Michael A N661KBCessna 210L · S/N 21060292Built 1974 · Baldeo Kessho I N67286Cessna 152 · S/N 15281725Built 1978 · Mars Aerospace Inc N729SPCessna 172S · S/N 172S8666Built 2000 · Mars Aerospace Inc N76BSMularadelis TEEMIE TWO · S/N 5-10002Built 1977 · Mularadelis James B N8625QBeech 95-B55 (T42A) · S/N TC-779First renewal noticeCorona Robert Jr Dr N918PMCessna 172RG · S/N 172RG0602Built 1980 · Mathews Roy N9625QCessna 172M · S/N 17265709Built 1975 · Mars Aerospace Inc N99207Ercoupe 415-D · S/N 1830Built 1946 · Silvagnoli Miguel

Back to Bay Shore, NY