Tulsa, OK
Registered aircraft · 550
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 = 'TULSA' 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 = 'TULSA' 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.
N232BWTextron 525 · S/N 525-1109N2336QBeech 23 · S/N M-401N234DACessna 421B · S/N 421B0122N23573Beech 95-B55 (T42A) · S/N TC-2107N23FCessna 210-5 · S/N 205-0073N243CStinson 108-2 · S/N 108-3243N24708Cessna 152 · S/N 15280332N2475QCessna 182K · S/N 18257675N24QTBell Textron Canada 429 · S/N 57512N251JGRed River SW-51 · S/N SW-51-029N25284Cessna 152 · S/N 15280572N253AJCirrus Design SR22T · S/N 10204N256FFiggins David B RV-7 · S/N 001N2583HEngineering & Research ERCOUPE 415-C · S/N 3208N2596BPiper PA-38-112 · S/N 38-79A0143N25CWCessna 172S · S/N 172S9875N25QTLearjet 45 · S/N 546N25TCAviat PITTS S-2B · S/N 5222N260DJCzech Aircraft Works Spol Sro SPORTCRUISER · S/N 08SC094N260RACessna 421C · S/N 421C1004N261JSCirrus Design SR20 · S/N 8755N265RMBoeing A75N1(PT17) · S/N 75-4524N267TAPiaggio P180 · S/N 1107N268DAPiper PA-44-180 · S/N 4496135N268TAPiaggio Aero Industries P180 · S/N 1146N2696PCessna 340A · S/N 340A0779N26QTBell Textron Canada 429 · S/N 57461N2706MPiper PA-12 · S/N 12-1209N2713UCessna 172D · S/N 17250313N271ABPiper PA-31T1 · S/N 31T-7904024N273CARobinson Helicopter R44 II · S/N 13403N273SCNanchang China CJ-6A · S/N 2751224N276AJCessna 162 · S/N 16200133N27AXLearjet 45 · S/N 147N27PLTextron 525B · S/N 525B0625N27SWWells Steve K RV-6A · S/N 21985N27XPEmbraer Executive EMB-500 · S/N 50000348N28078Bellanca 17-30A · S/N 79-30922N280RMIai GULFSTREAM G280 · S/N 2053N280WCIai GULFSTREAM G280 · S/N 2232N281WCIai GULFSTREAM G280 · S/N 2294N2822GPiper PA-28-236 · S/N 28-7911137N28700Spartan NP-1 · S/N 47N289PLAndrew Austin / Tom Hamilton RV-10 · S/N 40950N290KBeech E-90 · S/N LW-337N291PDDJI INSPIRE 1 PRO · S/N W21AC127011113N29292Cessna U206C · S/N U206-1212N2940Piper J3C-65 · S/N 14349N2944BBeech D35 · S/N D-3585N298ABFlight Design CTSW · S/N 05-09-10
Back to Tulsa, OK