Registered aircraft · 20

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

N15215Piper PA-34-200 · S/N 34-7350036Built 1972 · Curtis David W N152HRCessna 152 · S/N 15284697Built 1980 · Warner James A N19267Cessna 150L · S/N 15074288Built 1973 · Take Angels Aviation LLC N25RHBeech F33A · S/N CE-1009Built 1982 · Poseidon Transport Inc N273EBCessna 172N · S/N 17271018Built 1978 · North Country Aircraft Holdings LLC N32557Piper J5C · S/N 5-335Built 1940 · Experimental Aircraft Association N331VAVans RV-12IS · S/N 12189Built 2025 · Chan Chui N349VRVashon RANGER R7 · S/N 10202Built 2022 · Graham Damien N350HLPiper PA 46-350P · S/N 4636759Built 2019 · Saratoga Aviation LLC N4554FCessna A185E · S/N 185-1057Fejes Jacob J N513VMCessna T182T · S/N T18208310Built 2004 · Mccabes Supply Inc N5460RCessna 172F · S/N 17253017Built 1965 · Take Angels Aviation LLC N658TACirrus Design SR22 · S/N 11037Built 2025 · Jse Aviation Operations LLC N684ACAmerican Champion 7GCBC · S/N 1459-2011Built 2011 · Mccabe Gurney G N74587Mooney M20B · S/N 1898Built 1961 · Curtis David W N7950ZDale Morse SAFARI 400 · S/N 62199Built 2022 · Dale Morse N81CCWilcox Lewis W CORBY STARLET CJ1 · S/N 537Built 1996 · Curtis David W N86GRChan Chui S RV-10 · S/N 40008Chan Chui S N903KFStrange Carl KITFOX S-7 SUPER SPT · S/N KA16099329Built 2021 · Chan Chui N997NCPiper PA-28-140 · S/N 28-20817Built 1965 · Vega Gustavo E

Back to Watertown, NY