Kent, WA
Registered aircraft · 155
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 = 'KENT' 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 = 'KENT' 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.
N102JPPoschwatta Jeffrey R VANS RV-4 · S/N 130N102YYakovlev YAK-3M · S/N 0470107N10312Cessna 150L · S/N 15074837N115LWCessna 172S · S/N 172S9868N1178MCessna 172K · S/N 17258678N117THCaldwell PITTS SPECIAL S-1C · S/N 1N11832Curtiss Wright JR CW1 · S/N 1206N1188LCessna 172S · S/N 172S10370N1218TYak 18T · S/N 10-31N1273KLuscombe 8E · S/N 4000N13PTBoeing E75N1 · S/N 75-5499N140FCessna 140 · S/N 9179N14BFFay Robert L JR STEEN SKYBOLT · S/N FAY-1N164TMMacdowell John E RV-6 · S/N 23524N1729FCessna 180 · S/N 30619N180NCessna 180 · S/N 30889N180RBBower Roderick BOWER RV 4 · S/N 1839N1879HCessna 310C · S/N 35979N18YSNanchang YK-18 · S/N 1432025N1912VCessna 140 · S/N 14105N19193Cessna 150L · S/N 15074224N195NCessna 195B · S/N 16075N2087RCessna 182G · S/N 18255287N209DHDouglas Happe RV-7 · S/N 71253N21988Buck Robin F BUCKSTON B2+2 · S/N 1N2203HEngineering & Research 415-C · S/N 2826N2239HErcoupe 415-C · S/N 2862N227DTNason David F FALCO F8L · S/N 1227N230SLMark Owens GLASAIR SUPER FT S · S/N 2298N2492EAeronca 7AC · S/N 7AC-6074N25192Bellanca 14-9 · S/N 1013N25193Bellanca 14-9 · S/N 1014N2525Piper PA-28-181 · S/N 28-7790180N25305Bellanca 14-9 · S/N 1027N25314Bellanca 14-9L · S/N 1036N25407Rearwin 9000-KR · S/N 649DN25431Rearwin 9000-KR · S/N 652DN25432Rearwin 9000-KR · S/N 653N25841Borchers SCORPION TOO · S/N 1926N2679LCessna 172H · S/N 17255879N2748MPiper PA-12 · S/N 12-1235N2836XCessna 177 · S/N 17700236N28806Grumman American Avn. AA-5B · S/N AA5B0825N28971Bellanca 14-9 · S/N 1041N28980Bellanca 14-9 · S/N 1050N28984Bellanca 14-12F-3 · S/N 1054N28994Bellanca 14-14 · S/N 2001N297MPederson Michael Charles TITAN TORNADO S · S/N S04XXXS0HK0476N318CCCessna 182J · S/N 18257289N3193ACessna 170B · S/N 25837
Back to Kent, WA