Durant, OK
Registered aircraft · 51
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 = 'DURANT' 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 = 'DURANT' 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.
N1010FAero Commander 500-B · S/N 1403-145N10CWBeech B200 · S/N BB-1211N113SSCessna 150M · S/N 15076645N115SSCessna 152 · S/N 15283679N117SSCessna 150M · S/N 15079025N118SSCessna 150M · S/N 15077132N120SSCessna 150M · S/N 15078900N143AGCostruzioni Aeronautiche Tecna P2002 SIERRA · S/N 312N1763TPiper PA-28-140 · S/N 28-7125082N2096TPiper PA-28R-200 · S/N 28R-7135041N321PDRobinson Helicopter R66 · S/N 0741N3294FMooney M20F · S/N 670387N35387Cessna 172R · S/N 17281100N407BJBell Helicopter Textron Canada 407 · S/N 53897N408SKBell Helicopter Textron Canada 407 · S/N 54362N42007Cessna 172R · S/N 17280744N462TJCirrus Design SR22T · S/N 1919N498TBeech 35-A33 · S/N CD-319N505CFCessna 501 · S/N 501-0130N5178UCessna 172R · S/N 17281098N5178YCessna 172R · S/N 17281099N51800Cessna 172R · S/N 17281101N5181ACessna 172R · S/N 17281102N5181BCessna 172R · S/N 17281103N526MPCessna 210E · S/N 21058630N551CNBeech C90A · S/N LJ-1347N554CNTextron 680A · S/N 680A0285N575MCCirrus Design SR22 · S/N 2764N672PBPilatus PC-12/45 · S/N 672N67761Bell 206B · S/N 5203N68JAPiper PA-28R-201 · S/N 2844057N704LACessna 150M · S/N 15078685N704XNCessna 150M · S/N 15078957N735EJCessna 182Q · S/N 18265363N759BTCessna 182Q · S/N 18265869N805LCCessna 550 · S/N 550-0581N81180Mcclish FUNK B85C · S/N 310N818AFBombardier CL-600-2B16 · S/N 5395N82008Piper PA-32R-301T · S/N 32R-8029089N8488WPiper PA-28-180 · S/N 28-2926N857SPCessna 172S · S/N 172S8115N86CCessna T337G · S/N P3370117N8760EPiper PA-32R-300 · S/N 32R-7680175N901SECirrus Design SR20 · S/N 2601N902SECirrus Design SR20 · S/N 2602N925TPBeech 58P · S/N TJ-35N9398NPiper PA-28R-200 · S/N 28R-35109N9855GCessna 172L · S/N 17259755N98SSCessna 150M · S/N 15079353N991SEPiper PA-44-180 · S/N 4496543
Back to Durant, OK