Enid, OK
Registered aircraft · 127
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 = 'ENID' 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 = 'ENID' 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.
N109CLCessna 208B · S/N 208B0060N10JACessna 208B · S/N 208B0961N1108EBellanca 7GCBC · S/N 984-77N11151Piper PA-24-250 · S/N 24-1631N1116GCessna 208B · S/N 208B0402N112RPCessna 170A · S/N 19422N115CLCessna 208B · S/N 208B0011N120JButler John R SX 300 · S/N 60N131CLCessna 208B · S/N 208B0019N136CLCessna 208B · S/N 208B0037N140ASCessna 208B · S/N 208B0633N1416GBeech P35 · S/N D-6896N14470Liberti Frank R TAILWIND W-8 · S/N 558N151CLCessna 208B · S/N 208B0083N15498Piper PA-32-300 · S/N 32-7340010N155CLCessna 208B · S/N 208B0127N16371Piper PA-28-235 · S/N 28-7310091N1720PPorterfield Finley D STOL CH 750 · S/N 75-11096N1815MCessna 337F · S/N 33701415N1816YCessna 172C · S/N 17249416N187PTDJI AGRAS T40 · S/N 64TBK7H00100P3N188SDDavid G Deray RV-6 · S/N DD01N191SWHammond R M/Hamm Air SIDEWINDER · S/N 237N195WVMckillop William D LANCAIR 320 · S/N 285-320-47N200HGAviat A-1 · S/N 1200N2010PCostruzioni Aeronautiche Tecna P2010 · S/N 112/USN20191Verdone Frank ZENITH CH150 · S/N 15-578N208KTCessna 208B · S/N 208B0258N208YYCessna 208B · S/N 208B0453N20962Cessna 182P · S/N 18261324N2331SCessna T337B · S/N 337-0631N2387EAeronca 7AC · S/N 7AC-5966N23KCTrevor Rafferty JAVELIN · S/N RA301N245SDClark John T STARDUSTER TOO · S/N JC-574-RN247TSCirrus Design SR22 · S/N 4280N2497ECessna 172N · S/N 17271303N260ADBeechcraft G36 · S/N E-4017N26BZCirrus Design SR22 · S/N 4033N277BCCalivas C/Calivas B E RV-6 · S/N 20077N2949BBeech D35 · S/N D-3590N307TKTeam Aviation LLC/Badoud Wa BD4K · S/N BD4K00-101N3087UCessna 172E · S/N 17250687N3157TCessna 177 · S/N 17700457N319JMPilatus PC-12/47E · S/N 2214N324KHHollrah Kenneth R KITFOX IV · S/N 1511N325GPDJI AGRAS T40 · S/N 64TBL9C002008HN34759Cessna 177B · S/N 17701985N3515RBeech A23 · S/N M-671N35662Cessna 172I · S/N 17256890N357TSBeech C35 · S/N D-2785
Back to Enid, OK