Kasilof, AK
Registered aircraft · 52
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 = 'AK' AND g.registrant_city = 'KASILOF' 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 = 'AK' AND g.registrant_city = 'KASILOF' 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.
N1304APiper PA-18-125 · S/N 18-1108N1759PPiper PA-18-150 · S/N 18-4079N185LJCessna A185F · S/N 18503110N1930APiper PA-18 · S/N 18-1768N195STCessna 195A · S/N 7527N206CGCessna P206 · S/N P206-0136N22131Cessna A185F · S/N 18503074N2390HPiper PA-18-150 · S/N 18-7909176N2464MPiper PA-12 · S/N 12-1548N2952MPiper PA-12 · S/N 12-1347N3049Universal Stinson 108-3 · S/N 1084442N3150DCessna 180 · S/N 31948N3203MPiper PA-12 · S/N 12-1873N3243MPiper PA-12 · S/N 12-1897N3426ACessna 172C · S/N 17248953N3774ZPiper PA-18-150 · S/N 18-7454N382TPTimothy Veenstra ATI CUB REV3 · S/N 001N39988Taylorcraft BC12-D · S/N 6647N4031FAngus Mcrae Warren TIGER CUB · S/N 4031F-2018N4039MPiper PA-12 · S/N 12-2922N405THPiper PA-18-150 · S/N 18-7509005N4130EAeronca 11CC · S/N 11CC-39N440MXAviat A-1B · S/N 2440N44YYPiper PA-18-150 · S/N 18-7909069N4570MMatthews Richard W ISLAND HOPPER · S/N 040750N4612TMaule M-4-210C · S/N 1001CN4743TMaule M-4-210 · S/N 1008N5069MTaylorcraft BC12-D · S/N 10369N5304DCessna 180A · S/N 50202N53977Bellanca 7GCBC · S/N 921-76N579CCCub Crafters CC11-100 · S/N CC11-00056N5985ZPiper PA-18-150 · S/N 18-8241N6058CAeronca 7CCM · S/N 7BCM-416N698DKLuscombe 8A · S/N 2225N716CStinson 108-3 · S/N 108-3716N737ZKCessna 172N · S/N 17269800N7427BChampion 7EC · S/N 7EC-465N7955HPiper PA-12 · S/N 12-858N8119DPiper PA-22-160 · S/N 22-5610N8216JCessna A185F · S/N 18502864First renewal noticeN83374Piper PA-18-150 · S/N 18-7609101N847KASteve W Bilben/Renae E Bilben TAIL DRAGER 1 · S/N 448N8523PPiper PA-18-150 · S/N 18-8298N8603BCessna 172 · S/N 36303N86271Aeronca 11AC · S/N 11AC-76N88266Bellanca 8GCBC · S/N 100-74N89244Cessna 140 · S/N 8264N8965CPiper PA-18-135 · S/N 18-2945N9056ACessna 170A · S/N 18815N9578PPiper PA-18-150 · S/N 18-7609156
Back to Kasilof, AK