Registered aircraft · 22

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

N101TXGlaser-Dirks Flugzeugbau DG-100G · S/N E168G 134Built 1984 · Mapes Steven J N116BAIcon A5 · S/N 00059Built 2018 · Diamantina Blue LLC N11YVGlasflugel MOSQUITO · S/N 55Built 1977 · Mahony John P N122ZDoktor Fiberglas H101 SALTO · S/N 63Mahony John P N1609YCessna 172C · S/N 17249309Built 1962 · Mapes Steven J N18UAUrban Air Sro UFM-13 LAMBADA · S/N 116/13Built 2009 · Dobler Eric P N190MWEdwin Zwolinski ZODIAC CH 650 · S/N 65-10691Built 2020 · Zwolinski Edwin N1983FCessna 172P · S/N 17276134Built 1984 · Sports Flyers Association Inc N19FTSchempp-Hirth MINI-NIMBUS HS7 · S/N 34Mahony John P N2112XPipistrel D.O.O. Ajdovscina SINUS SW · S/N 773 SWN 100Built 2015 · Wiederkehr George A N2643UCessna 172D · S/N 17250243Built 1963 · Garing Gerald R N301JGlasflugel H 301 B LIBELLE · S/N 75Built 1968 · Mahony John P N412LKLithuanian Factory Of LAK-12 · S/N 6216Built 1994 · Mahony John N46WMMallia Jeff COZY JM MK III · S/N 31Built 1997 · Mallia Karen W N584WBeech 58 · S/N TH-1699Built 1993 · King Air Ny LLC N63UCIsrael Aircraft Industries ASTRA SPX · S/N 136Built 2001 · Jamrock Leasing LLC N6507MUniversal Stinson 108-3 · S/N 1084507Built 1948 · Felice Thomas L N7914HPiper PA-12 · S/N 12-818Built 1946 · Jamrock Leasing LLC N799AJCessna 510 · S/N 510-0171Built 2009 · Jamrock Leasing LLC N80263Cessna 172M · S/N 17266484Built 1975 · Breton Yacht Co LLC N82519Aeronca 7AC · S/N 7AC-1156Built 1946 · Ross Elizabeth K N92699Piper J3C-65 · S/N 17096Built 1946 · Grimm Dylan R

Back to Schenectady, NY