Skip to content

Registered aircraft · 35

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 = 'WA' AND g.registrant_city = 'BURLINGTON' 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 = 'WA' AND g.registrant_city = 'BURLINGTON'
  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 = 'WA' AND g.registrant_city = 'BURLINGTON'
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.

N151AFNorth American/Aero Classics P-51D · S/N 45-11525Built 1945 · Heritage Flight Museum N1904ZCessna 150C · S/N 15059704Built 1962 · Norman John W N19671Cessna 172L · S/N 17260654Built 1972 · Cascade Aviation LLC N2025QCessna 177RG · S/N 177RG0425Built 1973 · Nelson Gerald E N211XXJohn Norman RYAN NYP · S/N 001Built 2018 · Jne Aircraft LLC N2199Bell 47G · S/N 604Built 1952 · Heritage Flight Museum N2273FPiper PA-28-140 · S/N 28-25431Built 1969 · Cascade Aviation LLC N22SUCessna-Macone 305A · S/N 2Built 1975 · Heritage Flight Museum N24369Taylorcraft BL-65 · S/N 1705Built 1940 · Norman John W N2467FCessna 180H · S/N 18051669Built 1966 · Therkelsen Robert D N2603KCessna 180K · S/N 18053013Built 1978 · Padilla Management Inc N3219KCessna O-2A · S/N 68-6892Built 1968 · Heritage Flight Museum N4278UCessna 150D · S/N 15060278Built 1964 · Lotze Stephen H N44UKRobinson Helicopter R44 II · S/N 10969Built 2005 · N44uk Partners LLC N4545John W Norman JW-CUB · S/N 001Norman John W N5226CBeech B35 · S/N D-2571Built 1950 · Shaner Toby D N52324Cessna 182P · S/N 18262528Built 1973 · Hailey Jeremy A N5589HPiper PA-20 · S/N 20-651Built 1951 · Adams Trevor J N5700PPiper PA-24 · S/N 24-773Built 1959 · Edmundson George N617KJDJI INSPIRE 1 · S/N W13DCG16040278S & J Photography LLC N6504SCessna R182 · S/N R18201687Built 1980 · Nurmi Forrest Cal N653SRCessna 177 · S/N 17701048Built 1968 · Vertex Aviation Services LLC N65695Boeing E75 · S/N 75-8584Built 1943 · Heritage Flight Museum N706FNorth American AT-6F · S/N 121-42615Perigee Investments LLC N71862Luscombe 8A · S/N 3289Built 1946 · Seward Douglas L N7412Consolidated Vultee L-13B · S/N 47-412Built 1949 · Heritage Flight Museum N74CVWalker Charles GLASTAR · S/N 5603Built 2000 · Clure Bradley H N8033WPiper PA-28-180 · S/N 28-2099Registration pendingBuilt 1965 N827CTCirrus Design SR22T · S/N 1115Built 2015 · N44uk Partners LLC N8444SPiper PA-28-181 · S/N 28-8290025Built 1982 · Vertex Aviation Services LLC N9307XRowe William D ZODIAC 601XL · S/N 6519Built 2007 · Skagit Airport Eaa Chapter 818 Washington N9504WPiper PA-28-140 · S/N 28-22926Built 1967 · S&J Aviation LLC N9543SChampion 7ECA · S/N 271Built 1965 · Therkelsen Robert D N965ADDouglas AD-4N(A) · S/N 126965Built 1952 · Heritage Flight Museum N977EDFairchild M-62A · S/N T42-1811Heritage Flight Museum

Back to Burlington, WA