Arlington, WA
Registered aircraft · 145
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 = 'ARLINGTON' 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 = 'ARLINGTON' 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.
N1102Sud SA315B LAMA · S/N 1918-19N115KVCessna 182P · S/N 18261214N123DECessna 310C · S/N 35926N125YXStout Michael F SONEX WAIEX · S/N 0125N1305YCessna 172C · S/N 17249005N13255Cessna 172M · S/N 17262615N141AWBradford Heinitz AW 95 · S/N 100-1N141BGBradford C Heinitz B8M · S/N 14001N144PStewart Scott D RV-14 · S/N 140325N159DWWilcoxon Duane E S1C PITTS · S/N PITTS 01 DWN160TWTerry Burch TAILWIND · S/N 011N1632CCessna 180 · S/N 30332N1692BLuscombe 11A · S/N 11-198N16DXRichardson John W LANCAIR LEGACY · S/N L2K-285N1704DCessna 170A · S/N 20147N187SPterodactyl ASCENDER II · S/N 7/82N189FGCirrus Design SR22 · S/N 4378N1915FFokker E-III · S/N 3-68N1923QCessna 177RG · S/N 177RG0323N19355Cessna 150L · S/N 15074360N1952APiper PA-22 · S/N 22-746N196AVCessna 182A · S/N 51326N1ADAviators Dream VANS ACFT RV-8A · S/N 81023N203JGGipson Justin W COSMOS PHASE II · S/N B21348N20487Cessna 172M · S/N 17261330N205WWBell 205A-1 · S/N 30329N210BGCessna P210N · S/N P21000025N21179Cessna 182P · S/N 18261468N219HHarmon-Stits PLAYBOY SA3A · S/N HS-1N2283ZNorton-Gary FLY BABY 1A · S/N 2322N2357BRobinson Helicopter R22 BETA · S/N 2273N2494WSchweizer SGS 2-33 · S/N 47N25125Socata TB-20 TRINIDAD · S/N 962N259RCMendenhall Robert RV-9A · S/N 90041N25TWWright Thomas R PITTS S-1 · S/N 391-HN2604YCessna 180E · S/N 18051104N2628FCessna 182J · S/N 18256728N2635PPiper PA-22-150 · S/N 22-2973N27249Porterfield LP-65 · S/N 738N27HBBeech A36 · S/N E-999N2849KCessna 180K · S/N 18053096N28KLWright Thomas R RV-7 · S/N 70025N2NTStella David L VANS RV-8 · S/N 80781N30033Cessna 177 · S/N 17701036N300NBHughes 269C · S/N 1100981N30139Cessna 177 · S/N 17701074N311RAS.O.C.A.T.A. RALLYE 150 ST · S/N 2995N3144ZPiper PA-22-150 · S/N 22-7089N315JCAerospatiale SA315B · S/N 2563N3329DCessna 180 · S/N 32127
Back to Arlington, WA