Registered aircraft · 21

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

N2611AHerring Bill CHALLENGER II · S/N CH2-0501-CW-2092Built 2002 · Burke Raymond J Jr N283CStinson 108-2 · S/N 108-3283Built 1947 · Farwell Jesse R N40140Stinson 108 · S/N 108-70Farwell Jesse R N41005Beech UC-45J · S/N 51236Built 1943 · Farwell Jesse R N4393Downey Everett G PIETENPOL AIR CAMPER · S/N EGD-1Built 1993 · Downey Everett G N5185ZPiper PA-22-108 · S/N 22-8852Troy Michael J N5749ZPiper PA-22-108 · S/N 22-9588Built 1963 · Troy Michael J N626JTTower John A RV-6A · S/N 25633Built 2018 · Tower John A N6286ATroy Michael J PIETENPOL · S/N MJT-01Built 1996 · Troy Michael J N6ZHGuglielmi Paul OSPREY GP4 · S/N PMG002Built 2000 · Petranek Diana C N734NRCessna 172N · S/N 17268988Built 1977 · Vintage Aircraft Group N795DBeech C35 · S/N D-3064Built 1952 · Dudley Hugh G N82027Champion 7AC · S/N 7AC-653Built 1946 · Stirk Michael T N83862Champion 7DC · S/N 7AC2543Depatie Jean-Francois N843TBBeech D18S · S/N A217Farwell Jesse R N86125Aeronca 11AC · S/N 11AC-538Built 1946 · Denniston John A N8953KStinson 108-1 · S/N 108-1953Built 1947 · Farwell Jesse R N899AWWilliams Arnold L PIETENPOL AIRCAMPER · S/N 32139996Built 1989 · Farwell Richard D Jr N96387Taylorcraft BC12-D · S/N 8687Built 1946 · Downey Everett G N97415Stinson 108 · S/N 108-415Built 1946 · Farwell Richard D Jr N99630Engineering & Research ERCOUPE 415-C · S/N 2253Built 1946 · Denniston John A

Back to Albion, NY