Sedro Woolley, WA
Registered aircraft · 52
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 = 'SEDRO WOOLLEY' 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 = 'SEDRO WOOLLEY' 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.
N15SVCessna 340A · S/N 340A-0226N19982Cessna 172M · S/N 17260909N225MJCessna 172E · S/N 17250609N23600Air Tractor AT-301 · S/N 301-0398N2369EAeronca 7AC · S/N 7AC-5946N2495GCessna 182B · S/N 51795N28355Cessna 140A · S/N 15579N2908PPiper PA-22-150 · S/N 22-3176N2973CCessna 180 · S/N 30873N2991KCessna 180K · S/N 18053154N31618Dehavilland BEAVER U-6A · S/N 858N34175Schweizer SGS 1-35 · S/N 15N3440SCessna 182G · S/N 18255840N3491CCessna 170B · S/N 26534N4262FCessna 172 · S/N 46162N4456ZPiper PA-18-150 · S/N 18-8803N4494HPiper PA-15 · S/N 15-283First renewal noticeN4504NCessna A185F · S/N 18502550N4528BCessna 180 · S/N 31427N4604MPiper PA-11 · S/N 11-108N506HSRobinson Helicopter R44 II · S/N 13646N5238SAir Tractor AT-301 · S/N 301-0132N5317RCessna A185F · S/N 18503031N5543WPiper PA-28-160 · S/N 28-634N56HEBeechcraft G36 · S/N E-4043N5983DPiper PA-18-150 · S/N 18-5448N6125LAmerican AA-1 · S/N AA1-0325N62314Dehavilland BEAVER DHC-2 · S/N 56-366N6327SCessna 150G · S/N 15067127First renewal noticeN64384Dehavilland BEAVER DHC-2 MK.1 · S/N 622N6512GCessna 150L · S/N 15072012N6661SCessna 150H · S/N 15067461N6697QGrumman Acft ENG Cor-Schweizer G-164B · S/N 207BN70206Cessna A185E · S/N 18502057N7037HPiper J3C-65 · S/N 20282N7724SSchweizer SGS 1-26D · S/N 424N78741Piper PA-11 · S/N 11-1513N7938VCessna 180H · S/N 18051838N83283Piper PA-18-150 · S/N 18-7609065N83568Piper PA-18-150 · S/N 18-7709080N85442Aeronca 7AC · S/N 7AC-4182N8651HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1446N8886SAir Tractor AT-301 · S/N 301-0227N8889KStinson 108-1 · S/N 108-1889N89009Cessna 140 · S/N 8013N8982DPiper PA-18A 150 · S/N 18-6377N90758Dehavilland DHC-3 · S/N 455N9196GCessna 182N · S/N 18260736N9566LCessna 172P · S/N 17276578N9839YChampion AERONCA 7FC · S/N 7FC-451
Back to Sedro Woolley, WA