Registered aircraft · 19

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

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_state = 'CO' AND g.registrant_city = 'SUPERIOR' 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_state = 'CO' AND g.registrant_city = 'SUPERIOR'
  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 = 'CO' AND g.registrant_city = 'SUPERIOR'
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.

N124AMBell Textron Canada 429 · S/N 57450Built 2022 · Keybank Na N248JSCirrus Design SR20 · S/N 2640Built 2020 · Bergeson Aviation Enterprises LLC N2560XCessna P206 · S/N P206-0060Built 1965 · Cd Hillcroft Aviation LLC N2643VCessna 177RG · S/N 177RG0641Built 1974 · Gorman Sean P N283DBeech 58TC · S/N TK-112Built 1979 · Frohbieter Alan N309CCCub Crafters CC18-180 · S/N CC18-0074Built 2015 · Taylor David L N32DJBell Textron Canada 407 · S/N 56325Built 2022 · Keybank Na Its Division Key Equipment Finance N39HVDg-Flugzeugbau DG-808 C · S/N 8-436 B335 X95Built 2016 · Gillespie Charles N427BBBeech A36 · S/N E-2984Bolder Travel LLC N497JSSherry James RV-8 · S/N 81191Built 2007 · Lindsey Steven W N53DJBell Textron Canada 407 · S/N 56327Built 2022 · Keybank Na N68RPSteele Jerry CHALLENGER 2 PLACE · S/N CH2 1191 0759Built 1992 · Maier Dan P N721RRyan Aeronautical ST3KR · S/N 1840Built 1942 · Cp Air LLC N776LFAgustawestland Philadelphia AW119MKII · S/N 14846Built 2016 · Keybank Na N786LFAgustawestland Philadelphia AW119MKII · S/N 14847Built 2016 · Keybank Na N862NCBell Helicopter Textron Canada 429 · S/N 57242Built 2014 · Keybank National Association N88AWNorth American T-28B · S/N 138117Built 1954 · Gorman Sean N9036RCessna TR182 · S/N R18200658Built 1978 · Baltz David M N963CGJonker Sailplanes JS1-C · S/N 1C-074Built 2014 · Gillespie Charles P

Back to Superior, CO