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.
N385DECirrus Design SR20 · S/N 9991N386DECirrus Design SR22 · S/N 9904N388DECirrus Design SR22 · S/N 10136N38SUCessna 152 · S/N 15285144N3966HErcoupe 415-CD · S/N 4667N399JDIam Piaggio S P A P-180 · S/N 1007N39PVHawker Beechcraft G36 · S/N E-3985N39RGNorth American NA-265-40 · S/N 28282N3AFCirrus Design SR22T · S/N 10568N400CPCessna 560XL · S/N 560-5716N401SWCessna 182T · S/N 18282301N403JBVans RV-12 · S/N 120403N404GMMcnalley Gary RV-4 · S/N 826N406JACessna 172S · S/N 172S10628N406NDCirrus Design SR20 · S/N 1597N407ATBell Textron Canada 407 · S/N 56410N407GRBell Textron Canada 407 · S/N 54979N407JJBell Textron Canada 407 · S/N 54998N40GEStephen Dennis RV-4 · S/N 1545N4145KRyan NAVION · S/N NAV-4-1145N417JMCessna 182S · S/N 18280837N42180Piper J3C-65 · S/N 14422N422HCessna 182R · S/N 18268053N4233LCessna 172G · S/N 17254302N423AXBoeing 767-324 · S/N 27569N423MDBeech S35 · S/N D-7454N424RCCessna A185F · S/N 18504071N42723Piper J3C-65 · S/N 15021N4293YPiper PA-28-181 · S/N 28-8390040N4330QCessna 172L · S/N 17260230N4346GGanfield Roger A KR-2 · S/N 1941N4372MPiper PA-12 · S/N 12-3308Registration pendingN4394PPiper PA-23-160 · S/N 23-1906N43HCSikorsky UH-60A · S/N 81-23574N44256Rans Employee Flying Club RANS S-6ES COYOTE II · S/N 06041580N4438ZPiper PA-18-150 · S/N 18-8781N443ASRobinson Helicopter R44 II · S/N 11681N444LBeech E-90 · S/N LW-344N4459CCessna 190 · S/N 16044N44RKPiper PA-34-200T · S/N 34-7770296N45259Naval Aircraft Factory N3N-3 · S/N 2607N4545FDaniel Honkomp STARDUSTER TOO · S/N 794N4546JGrumman American Avn. AA-5B · S/N AA5B1283N4546YInhofe James M / Davis Jim VANS RV-8 · S/N 81168N4557DGulfstream American AA-5B · S/N AA5B1228N4559LGulfstream American AA-5B · S/N AA5B1247N45NMLearjet 45 · S/N 253N4612YPiper PA-18-150 · S/N 18-8933N461DKPiper PA-46-310P · S/N 46-8508102N4641PCessna 152 · S/N 15284790
Back to Tulsa, OK