Edmond, OK
Registered aircraft · 231
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.
N253BCCirrus Design SR22T · S/N 9143N255TJPiper PA-44-180 · S/N 4496394N26728Gulfstream American AA-5A · S/N AA5A0680N26WACirrus Design SR22T · S/N 11378N2760VCessna 177RG · S/N 177RG0686N2792SKubicek Factory S R O BB42Z · S/N 2392N282JLBeech 95-C55 · S/N TE-355N2848DPiper PA-28-236 · S/N 28-7911205N2977BBeech F35 · S/N D-4152N298RAgusta A109E · S/N 11618N29959Beech A36 · S/N E-2340N302CCCubcrafters CC11-160 · S/N CC11-00358N303STCessna 172S · S/N 172S11242N3102SArbc Inc DBA Lindstrand 90A · S/N 5750N315CDCirrus Design SR22 · S/N 0947N317BLTextron 172S · S/N 172S12466First renewal noticeN31CWTextron 172S · S/N 172S12956N324GREavision EA-J150 · S/N JMZKJ150UAV602595053N3283LCessna 172H · S/N 17256183N33WABeech C23 · S/N M-1619N340RGCessna 340 · S/N 340-0239N3454TCessna 177 · S/N 17700754N345CECirrus Design SR20 · S/N 1352N347CDCirrus Design SR22 · S/N 1360N349YBeech 95-A55 · S/N TC-389N3588FCessna 182J · S/N 18257588N360SStover John Raymond LANCAIR 360 · S/N 227N3734ZBeech C24R · S/N MC-739N373RPFunk P Funk B Kornelson R SH-3R GLASAIR III · S/N 3212N380SUCirrus Design SR20 · S/N 2782N38MLHankins Harold D 1600 · S/N HDH-0013N390SUCirrus Design SR20 · S/N 2783N39633Piper PA-28-161 · S/N 28-7916001N4009TBeech B23 · S/N M-1116N400SUCirrus Design SR20 · S/N 2787N405GZall Jihlavan Airplanes S R O JA-600 SKYLEADER 600 · S/N 6323351AN410SUCirrus Design SR20 · S/N 2771N411ABCessna 414A · S/N 414A0524N411SJBrotherton Erik D EXEC 90 · S/N 5189N4124NPiper PA-28-181 · S/N 2843146N414BGCessna 414A · S/N 414A0094N4151UCessna 150D · S/N 15060151N420SUCirrus Design SR20 · S/N 8667N421JWCessna 421C · S/N 421C0665N421PTThomas Fitzgerald P VANS AIRCRAFT RV-6A · S/N 22487N422LMCirrus Design SR22 · S/N 0118N4291PReims Aviation S A CESSNA F172H · S/N 0432N430SUCirrus Design SR20 · S/N 8668N43257Piper PA-28-180 · S/N 28-7405183N4365QCessna 172L · S/N 17260265
Back to Edmond, OK