Nikiski, AK
Registered aircraft · 32
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 = 'NIKISKI' 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 = 'NIKISKI' 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.
N1022BPiper PA-18-150 · S/N 18-4646N108JFound Acft Canada FBA-2C1 · S/N 39N117BBDehavilland DHC-2 · S/N 1511N181AWPiper PA-18A · S/N 18-1743N2120FCessna U206 · S/N U206-0320N2496PPiper PA-18A · S/N 18-4305N26CFCessna T207 · S/N 20700306N3855ZPiper PA-18-150 · S/N 18-7616N43617Taylorcraft BC12-D · S/N 7276N4387APiper PA-18S-150 · S/N 18-4795N44023Taylorcraft BC12-D · S/N 9823N4534BCessna 180 · S/N 31433N4910HPiper PA-11 · S/N 11-779N4963LPiper PA-28-180 · S/N 28-4334N5147GDehavilland BEAVER DHC-2 MK.1 · S/N 350N55786Piper PA-28R-200 · S/N 28R-7335288N6050JCessna 182P · S/N 18263619N6764BPiper PA-18A 150 · S/N 18-5039N67DJCessna U206F · S/N U20602326N74968Piper PA-18-150 · S/N 18-7709045N757VWCessna 152 · S/N 15280047N776AWPiper PA-18-150 · S/N 18-8139N82076Piper PA-18-150 · S/N 18-7909056N83299Piper PA-18-150 · S/N 18-7609070N8684DPiper PA-18-150 · S/N 18-6289N88302Piper J3C-65 · S/N 15919N9013KGregory S Miller GM CUB · S/N JA1209071N907RBRobinson Helicopter R44 II · S/N 13954N90945Piper PA-18-150 · S/N 18-8109050N9241CCessna 180 · S/N 31340N9740DPiper PA-22-160 · S/N 22-6653N97729Stinson 108 · S/N 108-729
Back to Nikiski, AK