Registered aircraft · 20

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 = 'AK' AND g.registrant_city = 'TWO RIVERS' 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 = 'AK' AND g.registrant_city = 'TWO RIVERS'
  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 = 'TWO RIVERS'
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.

N153BCJeff Meierotto BOSS CUB · S/N BC-1Built 2011 · Meierotto Jeff T N1575CCessna 180 · S/N 30275Built 1953 · Meierotto Martin A N1907APiper PA-18AS-125 · S/N 18-1741Built 1952 · Knopke James M N219RMBeech 1900C · S/N UC-13Built 1988 · Moro Aircraft Leasing Inc N2387MPiper PA-12 · S/N 12-1630Built 1946 · Olson Catherine R N2521HAir Creation CLIPPER · S/N AIRC10815Built 1998 · Marquiss Steven A N2561AKillian Leslie S CLIPPER · S/N E10151EBuilt 1997 · Marquiss Steven A N31932Piper PA-31-350 · S/N 31-7405144Built 1973 · Air Cargo Solutions Inc N4080HPiper PA-12 · S/N 12-3508Built 1947 · Earle Brian S N410WPAndrew J Hamlin P-18+ · S/N 001VBuilt 2022 · Hamlin Andrew J N4140ZPiper PA-18-150 · S/N 18-8213Built 1965 · Meierotto Jeff T N4509YPiper PA-18-150 · S/N 18-8930Built 1971 · Wolfrum John A N4668CCessna 170B · S/N 25612Built 1953 · Meierotto Jeffrey T N719AKEurocopter AS 350 B2 · S/N 2884Built 1995 · Moro Aircraft Leasing Inc N7540FChampion 7GCBC · S/N 211-70Built 1969 · Meierotto Noah J N7883DPiper PA-18A 150 · S/N 18-6043Built 1957 · Meierotto Marty N80GVPiper PA-31-350 · S/N 31-7552003Built 1975 · Moro Aircraft Leasing Inc N83278Piper PA-18-150 · S/N 18-7709047Built 1976 · Hamlin Andrew J N9524BCessna 180A · S/N 32821Built 1957 · Meierotto Jeff T N975BSBellanca 8GCBC · S/N 302-79Built 1979 · Saurdiff Benjerman D

Back to Two Rivers, AK