Mukilteo, WA
Registered aircraft · 42
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 = 'MUKILTEO' 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 = 'MUKILTEO' 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.
N111TCBeech E-90 · S/N LW-305N1324WMooney M20C · S/N 2682N13668Cessna 172M · S/N 17262927N18109Cessna 150L · S/N 15073792N21TLTodd M Lesher RANS S-21 OUTBOUND · S/N 03240371N234CCBeech T-34C-1 · S/N 85N24JHDehavilland DHC-1B-2 · S/N 213-251N26BYAmerican Champion 8KCAB · S/N 963-2004N29262Piper J3C-65 · S/N 10553N29343Cessna 177 · S/N 17700826N31RZRenquist III-George BABY ACE D · S/N 111N329WGustafson Wilbur M LONG EZ · S/N 329N3629ABeech V35B · S/N D-9080N399SRSteve H Reiber RANS S21 · S/N SR-S21-01N4038FCessna 172 · S/N 36938N421CVCessna 172N · S/N 17272437N457LMadlung Craig GLASSAIR SPR II S FT · S/N 2352N470KCHeine August W RV-4 · S/N 1491N5140BCessna 152 · S/N 15283772N5528SCessna TR182 · S/N R18201596N5973ECessna 150 · S/N 17473N600AHPiper PA-24-260 · S/N 24-4863N65ETMeister James E EXEC 162-F · S/N 6897N67JBCessna 550 · S/N 550-0980N68TPPowers Thomas J RV8 · S/N 83300N7107LGrumman American Avn. AA-5 · S/N AA5-0637N734EWCessna 172N · S/N 17268806N737KJCessna 172N · S/N 17269474N7419SSmith AEROSTAR 601 · S/N 61-0004N7634JPiper PA-28R-180 · S/N 28R-31030N78797Cessna 172K · S/N 17257767N7979CNorth American AT-6D · S/N 84827N83233Champion 7AC · S/N 7AC-1897N8370DBeech J35 · S/N D-5463N8494MCessna 182P · S/N 18264630N8724DPiper PA-22-160 · S/N 22-5905N88209Piper J3C-65 · S/N 15826N88NSGrumman American Avn. AA-5B · S/N AA5B-0196N9007RCessna TR182 · S/N R18200656N922AGJames Hamilton APOLLO AG1 · S/N USA231214N976JWCirrus Design SR22 · S/N 1018N9900MKrauser Peter C VANS RV-10 · S/N 40020
Back to Mukilteo, WA