Skip to content

State Of Arizona

Registered aircraft · 51

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

Query with SQL

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_name = 'STATE OF ARIZONA' OR list_contains(g.other_registrant_names, 'STATE OF ARIZONA') ORDER BY g.n_number

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_name = 'STATE OF ARIZONA' OR list_contains(g.other_registrant_names, 'STATE OF ARIZONA')
  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_name = 'STATE OF ARIZONA' OR list_contains(g.other_registrant_names, 'STATE OF ARIZONA')
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.

N290AZDJI MAVIC 2 PRO · S/N 163CGCRR0A1F6QPhoenix, AZ N291AZDJI MAVIC 2 PRO · S/N 163CGCTR0A27K8Phoenix, AZ N292AZDJI MAVIC 2 PRO · S/N 163CGCRROAIFJZPhoenix, AZ N293AZDJI MAVIC 2 PRO · S/N 163CGC4R0A68EXPhoenix, AZ N295AZDJI MAVIC 2 PRO · S/N 163CGCRR0AIFFHPhoenix, AZ N296AZDJI MAVIC 2 PRO · S/N 163CGCRR0A1FGOPhoenix, AZ N297AZDJI MAVIC 2 PRO · S/N 1633HA8001X071Phoenix, AZ N298AZDJI MAVIC 2 PRO · S/N 163CGCQR0A0X00Phoenix, AZ N299AZDJI MAVIC 2 PRO · S/N 163CGCUR0A2RK0Phoenix, AZ N3037QCessna 182K · S/N 18258037Built 1967 · Holbrook, AZ N460AZDJI MAVIC 2 PRO · S/N 163DFCD0014L68Phoenix, AZ N461AZDJI MAVIC 2 PRO · S/N 163DFCD00157JCPhoenix, AZ N462AZDJI MAVIC 2 PRO · S/N 163DFCD001203LPhoenix, AZ N463AZDJI MAVIC 2 PRO · S/N 163DFCD001P02CPhoenix, AZ N464AZDJI MAVIC 2 PRO · S/N 163DG1N001JJD6Phoenix, AZ N465AZDJI SPARK · S/N OASUFBH004028MPhoenix, AZ N466AZDJI MAVIC 2 PRO · S/N 163DG6F001KN29Phoenix, AZ N467AZDJI MAVIC 2 PRO · S/N 163DG6F001MR74Phoenix, AZ N469AZDJI MAVIC 2 ENTERP ZOOM · S/N 276DFB9001726QPhoenix, AZ N480AZAeryon Labs SKY RANGER · S/N SR2118576Phoenix, AZ N481AZDJI INSPIRE 1 · S/N W13DEB17060865Phoenix, AZ N482AZDJI MATRICE 100 · S/N ED262332546384Phoenix, AZ N483AZDJI MAVIC PRO · S/N 08QDDA4A12011SPhoenix, AZ N484AZDJI PHANTOM 4 PRO+ · S/N 0AXCE7V0B30635Phoenix, AZ N485AZDJI PHANTOM 4 PRO · S/N 11U3G7K002U234Phoenix, AZ N486AZDJI MAVIC 2 ZOOM · S/N 0M6DFA8001RSRNPhoenix, AZ N487AZDJI MAVIC 2 ZOOM · S/N 0M6DFA80019926Phoenix, AZ N488AZDJI MAVIC 2 ENTERP DUAL · S/N 298DFCS001P840Phoenix, AZ N489AZDJI MAVIC 2 PRO · S/N 163DFCD001H8FTPhoenix, AZ N540AZDJI MAVIC 2 PRO · S/N 163CGCJR0A6R4RPhoenix, AZ N541AZDJI MAVIC 2 PRO · S/N 163CGANR0A3Z8YPhoenix, AZ N542AZDJI MAVIC 2 PRO · S/N 163CGCJR0A6PE1Phoenix, AZ N543AZDJI MAVIC 2 PRO · S/N 163CG9UR0A2N5MPhoenix, AZ N544AZDJI MAVIC 2 PRO · S/N 163CH15R0A3KJYPhoenix, AZ N545AZDJI MAVIC 2 PRO · S/N 163CGCJR0A6QNTPhoenix, AZ N546AZDJI MAVIC 2 ZOOM · S/N 0M6CH19R0A676QPhoenix, AZ N547AZDJI MAVIC 2 PRO · S/N 163CGCUR0A2Q9YPhoenix, AZ N548AZDJI MAVIC 2 PRO · S/N 163CG9LR0A1XACPhoenix, AZ N549AZDJI MAVIC 2 PRO · S/N 163CG9TR0A2DLJPhoenix, AZ N58AZBell 407 · S/N 53736Built 2006 · Phoenix, AZ N602AZDJI M300 RTK · S/N 1ZNDH3L0010652Phoenix, AZ N630AZDJI MAVIC 2 PRO · S/N 163CGCRR0A1ENBPhoenix, AZ N631AZDJI MAVIC 2 PRO · S/N 163CGCTR0A27BPPhoenix, AZ N632AZDJI MATRICE 300 RTK · S/N 1ZNDH8S00B2Y69Phoenix, AZ N633AZDJI MAVIC 2 PRO · S/N 163CH16R0A450CPhoenix, AZ N634AZDJI MATRICE 300 RTK · S/N 1ZNDH9B00CD9M6Phoenix, AZ N635AZDJI MATRICE 300 RTK · S/N 1ZNDH9U00CB687Phoenix, AZ N650AZBrinc LEMUR · S/N 0033Phoenix, AZ N651AZBrinc LEMUR · S/N 0055Phoenix, AZ N761EZCessna T210M · S/N 21062210Built 1977 · Prescott, AZ

Back to State Of Arizona