Sedona, AZ
Registered aircraft · 91
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 = 'AZ' AND g.registrant_city = 'SEDONA' 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 = 'AZ' AND g.registrant_city = 'SEDONA' 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.
N1063YAdams Balloon A55S · S/N 109N109FRCessna 172P · S/N 17275192N11TXFlug & Fahrzeugwerke FFA HBV-DIAMANT 16.5 · S/N 050N12350Monocoupe 110 · S/N 6W39N1279RBellanca 17-30A · S/N 30402N128MBPiper AEROSTAR 602P · S/N 62P08768165013N12952Cessna 172M · S/N 17262398N145DBeech 95-B55 (T42A) · S/N TC-2348N1516ZBeech N35 · S/N D-6836N1695NUltramagic N-300 · S/N 300/66N16LBArbc Inc DBA Lindstrand 90A · S/N 5505N170GPKubicek Factory S R O BB20GP · S/N 2012N2000TAvian Balloon MAGNUM IX · S/N 192N201SJMooney M20J · S/N 24-0069N2023BAvian Balloon MAGNUM IX · S/N 198N2033AAvian Balloon MAGNUM IX · S/N 201N2037UAvian Balloon MAGNUM IX · S/N 202N204BBeech G35 · S/N D-4548N20513Avian Balloon MAGNUM IX · S/N 204N2056ZAvian Balloon MAGNUM IX · S/N 205N206SFBell 206B · S/N 2392N20810Avian Balloon MAGNUM IX · S/N 209N2134RPiper PA-28-180 · S/N 28-5467N22DSBeech 35-B33 · S/N CD-446N231LVMooney M20K · S/N 25-0303N236LLRoberts Kevin J LANCAIR LEGACY · S/N L2K-158N241DCBinkley David P VANS ACFT RV6 · S/N 21587N250BEUltramagic S A N-250 · S/N 250/79N2510YColumbia Aircraft Mfg LC41-550FG · S/N 41572N255DWPiper PA46-500TP · S/N 4697020N26691Grumman American Avn. AA-5A · S/N AA5A0648N269MVQuest KODIAK 100 · S/N 100-0148First renewal noticeN2808WSocata TB-20 TRINIDAD · S/N 1083N2822MCessna 180 · S/N 30010N2925VCessna R172K · S/N R1722234N296SDSidney S Haynie VANS RV 7-A · S/N 74248N297ARRichard Gay SLING TSI · S/N 483SKN300MUUltramagic N-300 · S/N 300/107N3021NLindstrand Balloons 90A · S/N 5080N32UMUltramagic S A N-300 · S/N 300/127N337WWCessna T337G · S/N P3370106N341LVEmshwiller GLASAIR III · S/N 3079N3516APiper PA-31-350 · S/N 31-7952106N3520VCessna R172K · S/N R1722256N352JNLindstrand Balloons 31A · S/N 352N35389Cessna 172S · S/N 172S8938N3726CCessna R182 · S/N R18200321N3762QBeech V35 · S/N D-8398N4181SBeech A36 · S/N E-672N440TBeech F33A · S/N CE-681
Back to Sedona, AZ