Tuttle, OK
Registered aircraft · 31
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 = 'TUTTLE' 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 = 'TUTTLE' 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.
N111SFWilliams John J WILLIAMS CX4 · S/N 146-XN15010Piper PA-28-140 · S/N 28-7225550N16202Cessna 150L · S/N 15073543N18312Taylorcraft A · S/N 45N1886CQuad City CHALLENGER II · S/N CH2 0885 B 0170N20343Taylor-Young "A" · S/N 473N248LSDJI AGRAS T40 · S/N 64TBL21002020FN248NSDJI AGRAS T40 · S/N 64TBL2100201N7N249PMBaker Michael / Baker Jean COZY MARK IV · S/N 1551N2913JCessna 150G · S/N 15065713N29710Taylorcraft BC12-65 · S/N 2556N34LZAldous David J LAZAIR 2 · S/N B034N36290Taylorcraft BC12-D · S/N 3208N3825DCessna 182A · S/N 34525N446RVIngraham Steve RV-9A · S/N 90446N49765Schempp-Hirth STANDARD CIRRUS · S/N 353N5063ZPiper PA-22-108 · S/N 22-8688N55QQWilliams John ZODIAC XL · S/N 4807N6393FBoeing A75N1 · S/N 75-1108N66310Piper J3C-65 · S/N 8277-4N67YMFlight Design General Avn F2-LSA · S/N T-25-0104N7182YPiper PA-30 · S/N 30-206N7663ZPiper PA-25-235 · S/N 25-3807N79879Cessna 172K · S/N 17258214N8293ECessna 172N · S/N 17272179N83687Aeronca 7AC · S/N 7AC-2365N9020GCessna 182N · S/N 18260560N950BHXag V40 · S/N 8102230U018FN960AGBeech V35 · S/N D-8538N981CGSchleicher K 8 B · S/N 8162N988JHBoeing/Hayes N2S 2 · S/N 75-1421
Back to Tuttle, OK