Seatac, WA
Registered aircraft · 117
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 = 'SEATAC' 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 = 'SEATAC' 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.
N205HAAirbus A321-271N · S/N 8092N212HAAirbus A321-271N · S/N 8129N214AKBoeing 737-900ER · S/N 60579N251AKBoeing 737-990ER · S/N 62470N264AKBoeing 737-990ER · S/N 36360N265AKBoeing 737-900ER · S/N 62682N266AKBoeing 737-900ER · S/N 62683N273AKBoeing 737-900ER · S/N 61554N275AKBoeing 737-900ER · S/N 61556N277AKBoeing 737-900ER · S/N 62472N278AKBoeing 737-900ER · S/N 44113N281AKBoeing 737-900ER · S/N 62679N285AKBoeing 737-900ER · S/N 60577N287AKBoeing 737-900ER · S/N 36359N288AKBoeing 737-900ER · S/N 60575N292AKBoeing 737-900ER · S/N 64301N293AKBoeing 737-900ER · S/N 64302N294AKBoeing 737-900ER · S/N 64303N3415FCessna 182J · S/N 18257415N370DIai GULFSTREAM G280 · S/N 2320N386HAAirbus A330-243 · S/N 1302N393HAAirbus A330-243 · S/N 1422N402ASBoeing 737-990ER · S/N 41189N407ASBoeing 737-990ER · S/N 41731N453ASBoeing 737-990ER · S/N 36354N457ASBoeing 737-990ER · S/N 36355N459ASBoeing 737-990ER · S/N 36352N45ABBurdo BUSHBY MUSTANG II · S/N 493N464ASBoeing 737-990ER · S/N 40714N467ASBoeing 737-990ER · S/N 36362N486ASBoeing 737-990ER · S/N 44107N487ASBoeing 737-990ER · S/N 44108N492ASBoeing 737-990ER · S/N 44110N517ASBoeing 737-890 · S/N 35197N519ASBoeing 737-890 · S/N 36482N524ASBoeing 737-890 · S/N 35195N525ASBoeing 737-890 · S/N 35692N526ASBoeing 737-890 · S/N 35196N527ASBoeing 737-890 · S/N 35694N529ASBoeing 737-890 · S/N 35198N532ASBoeing 737-890 · S/N 36346N533ASBoeing 737-890 · S/N 35201N534ASBoeing 737-890 · S/N 35202N537ASBoeing 737-890 · S/N 35204N5550MAero Commander 100 · S/N 088N560ASBoeing 737-890 · S/N 35179N563ASBoeing 737-890 · S/N 35180N569ASBoeing 737-890 · S/N 35184N585ASBoeing 737-890 · S/N 35683N586ASBoeing 737-890 · S/N 35189
Back to Seatac, WA