Albany, OH
Registered aircraft · 28
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 = 'OH' AND g.registrant_city = 'ALBANY' 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 = 'OH' AND g.registrant_city = 'ALBANY' 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.
N128WZBartunek Robert D CHRISTEN EAGLE II · S/N BARTUNEK-0001N193BBRans S-19LS · S/N 05080005LSN200UBeech C90A · S/N LJ1389N270UCessna 172S · S/N 172S9520N27DQBeech 58 · S/N TH-228N290UCessna 172S · S/N 172S8551N345ARCessna 172P · S/N 17274364N445DHPiper PA-28-161 · S/N 2842233N570UPiper PA-28R-201 · S/N 2844054N590UPiper PA-28R-201 · S/N 2844061N6718HPiper J3C-65 · S/N 19929N720UPiper PA-28-161 · S/N 2842223N7251ACessna 172 · S/N 29351N730UNew Piper PA-28-161 · S/N 2842224N740UPiper PA-28-161 · S/N 2842225N750UPiper PA-28-161 · S/N 2842226N760UNew Piper PA-28-161 · S/N 2842231N7610UCirrus Design SR20 · S/N 10549N7620UCirrus Design SR20 · S/N 10550N7630UCirrus Design SR20 · S/N 10552N7640UCirrus Design SR20 · S/N 10561N7650UCirrus Design SR20 · S/N 10566N7660UCirrus Design SR20 · S/N 10567N780UNew Piper PA-28-161 · S/N 2842232N7APDouglas DC3C · S/N 13896N800UBeech 95-B55 (T42A) · S/N TC-2276N870URaytheon 58 · S/N TH-2036N9137WAero Vodochody L29 · S/N 892820
Back to Albany, OH