Everett, WA
Registered aircraft · 114
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 = 'WA' AND g.registrant_city = 'EVERETT' 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 = 'EVERETT' 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.
N1069LCessna 182 · S/N 33633N116JMMorgan James E MORGAN RV6 · S/N RV20260N119WBRotunda John VANS RV-9A · S/N 9155N123JMMayfield James Phillip III VARI EZE · S/N 003N1315NBoeing E75 · S/N 75-5453N148PCAmerican Champion 8KCAB · S/N 996-2005N152LTCessna 152 · S/N 15285262N15JBBerry Jim RV10 · S/N 40482N161SMPiper PA-28-161 · S/N 28-7916508N16292Piper PA-34-200 · S/N 34-7350125N163TPiper PA-18 · S/N 18-2277N171CDCirrus Design SR20 · S/N 1080N182KMCessna 182B · S/N 52124N185PJCessna A185F · S/N 18503676N186ACAmerican Champion 8GCBC · S/N 369-94N1999UCessna A185E · S/N 18501768N209AHBLR Aerospace TAH-1P · S/N 76-22605N218SCSix Chuter LEGEND XL · S/N 3108N2227AJohn Vanhorne RV-7A · S/N 71477N2374GCessna 182B · S/N 51674N244CXSchempp-Hirth DISCUS B · S/N 83N245AGPiper PA-23-250 · S/N 27-7305187N248SAStene John JSRV8 · S/N JS001N2636EWehrman Don C SKYRANGER · S/N 2000N2791JCessna A150M · S/N A1500603N27MZZyskowski Michael K VANS RV-7 · S/N 72952N280NCNanchang China CJ-6A · S/N 2951240N31CZHull Joseph A COZY-MK-4 · S/N 0991N32653Piper PA-28-180 · S/N 28-7505079N3387JCessna 150G · S/N 15066087N34281Cessna 177B · S/N 17701746N34555Cessna 177B · S/N 17701871N34612Cessna 177B · S/N 17701901N34XABeech A45 · S/N G-799N3538JCessna 150E · S/N 15061238N36MNBeech A36TC · S/N EA-79N3920NBeech 35 · S/N D-1175N409AKPiper PA-32R-301T · S/N 3257072N416RGYakovlev YAK 18 · S/N 5200208N4200FCessna 172 · S/N 46100N4262MPiper PA-12 · S/N 12-3175N427JCJennings James G MARQUART MA5 CHARGER · S/N 82N4284ZPiper PA-18-150 · S/N 18-8532N43DTThomas Daniel G RV-6 · S/N 20466N4404PPiper PA-28-235 · S/N 28-10160N4405CCessna 195B · S/N 7990N4528HPiper PA-15 · S/N 15-301N45586Cessna 150M · S/N 15076982N4579HPiper PA-15 · S/N 15-353N45803Luscombe 8A · S/N 2330
Back to Everett, WA