Edmond, OK
Registered aircraft · 233
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 = 'EDMOND' 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 = 'EDMOND' 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.
N107FGNorth American AT-6D · S/N 44-80858N1102ACessna M337B · S/N M3370377N110JFBoeing E75N1 · S/N 758062N1118MThorp T-18 · S/N 390N1127LHelicopteres Guimbal CABRI G2 · S/N 1127N113JVCirrus Design SR22T · S/N 0283N113RRSky Eye Innovations SKY EYE PRIME · S/N PC-1002N1187ADJI AGRAS T50 · S/N 7TNBMFN0030BG2N1187BDJI AGRAS T100 · S/N 1581F8ZLC259L00246BJN11GNPiper PA-28-180 · S/N 28-7305330N125VCirrus Design SR20 · S/N 9198N127RRGulfstream Aerospace GIV-X (G450) · S/N 4063N1288QCessna 150L · S/N 15072588N128VCirrus Design SR20 · S/N 9974N1293Daugherty Fly Baby A-1 · S/N 68-9N12RMCessna 510 · S/N 510-0226N13266Cessna 172M · S/N 17262624N132VCirrus Design SR20 · S/N 10625N1399Braden Gale RV-9A · S/N 91104N1405UCessna 172M · S/N 17267075N143GBCessna T206H · S/N T20609047N1482GBeech 35-B33 · S/N CD-474N151VBellanca 8KCAB · S/N 550-79N1548RGrumman American Avn. AA-5B · S/N AA5B-0048N15762Piper PA-28-180 · S/N 28-7305140N1604CColumbia Aircraft Mfg LC41-550FG · S/N 41697N170PYCessna 170A · S/N 19949N177KFCessna 177B · S/N 17701563N17GPBeech 58P · S/N TJ-210N1808QBeech A36TC · S/N EA-236N1918QBuchanan Sam C BUCHANAN FOKKER DVII · S/N 031915N1936LBeech C23 · S/N M-1846N1939EAeronca 7AC · S/N 7AC-5506N20WJPiper PA-34-220T · S/N 3448027N210PRCessna 210 · S/N 64883N212XXBritish Aerospace HS 125-700A · S/N 257093N21DABeech 58 · S/N TH-980N22245Cessna 150H · S/N 15068164N222SDBeech A36 · S/N E-473N224EMCessna 182T · S/N 18281350N225JSCessna 172P · S/N 17274385N22RTCirrus Design SR22T · S/N 2098N2317GCessna T210L · S/N 21061485N232TSPiper PA-32R-301T · S/N 32R-8229041N234BPMooney M20J · S/N 24-3283N234KWBeech B200 · S/N BB-1065N2447Air Fly Balloons Ltda AF-SS-102 · S/N LP2026-02N2473WPiper PA-28-181 · S/N 28-8590073N249RAAmerican Champion 7GCBC · S/N 1371-2004N24CYTextron 182T · S/N 18283165
Back to Edmond, OK