Shawnee, OK
Registered aircraft · 43
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 = 'OK' AND g.registrant_city = 'SHAWNEE' 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 = 'OK' AND g.registrant_city = 'SHAWNEE' 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.
N106BBFlight Star II SC · S/N 64322N110ESHughes 269A · S/N 58-0860N114PHCessna 208B · S/N 208B2021N115PHCessna 208B · S/N 208B2048N144TVBell Helicopter Textron 206L-1 · S/N 45602N151KCSchweizer 269C · S/N S1752N16917Cessna T182T · S/N T18208803N185RRCessna A185F · S/N 18503516N21MWBell 206B · S/N 3585N2846VBeech 35 · S/N D-251Registration pendingN287MBumbaugh Alan R RV-7A · S/N 73672N295ABBarry L Fogerty VANS RV6A · S/N 23322N29KRChampion 7ECA · S/N 274N3248LBeech 58 · S/N TH-1748N3302WPiper PA-32-260 · S/N 32-137N340JJCessna 340 · S/N 340-0040N35TVBeech C90 · S/N LJ-572N3770QBeech V35 · S/N D-8403N38BWBeech H-18 · S/N BA-725N409BMIsrael Aircraft Industries GULFSTREAM 200 · S/N 059N41787Piper PA-28-235 · S/N 28-7410068N5000BBell 206L-3 · S/N 51044N5304KNavion NAVION B · S/N 2204BN53CMBeech D35 · S/N D-3448N5412Grumman G-164A · S/N 1025N55608Piper PA-28-180 · S/N 28-7305423N567DBCessna 210E · S/N 21058689N580BXRaytheon 58 · S/N TH-2124N6144VSchweizer 269C-1 · S/N 0037N619Bell Helicopter Textron 206L-1 · S/N 45393N65951Wsk-Pzl Warzawa-Okecie PZL-104 WILGA 80 · S/N CF20900901N6717ECessna 172N · S/N 17272055N7125NTextron 208B · S/N 208B5235N725VScott D Lee XLRG5 · S/N 125N764MTextron T206H · S/N T20609630N800FTDenesha Thomas C LONG-EZ · S/N 723N82CCCessna 182P · S/N 18264066N866TXDJI AGRAS T40 · S/N 1581F574B227400102F0N8834XCessna 182D · S/N 18253234Registration pendingN8GXLucas Garry LUCAS EXPEREMENTAL-8 · S/N 80431N9166UCessna 150M · S/N 15078117N93VMFlight Design CTLS · S/N F-08-06-12N950QHCessna 208B · S/N 5234
Back to Shawnee, OK