Registered aircraft · 22

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 = 'MORRISON' 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 = 'MORRISON'
  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 = 'MORRISON'
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.

N12JGCessna P210N · S/N P21000365Built 1979 · Vosworx Aviation LLC N16CBCarl Boecher RV-7A · S/N 72745Built 2018 · Boecher Carl A N189MHPiper PA 46-350P · S/N 4636159Built 1998 · Spirit Life Inc N199SWJarvis N Siegel RV 7 · S/N 70888Mcdonald Troy L N20DBCessna T182T · S/N T18208331Built 2004 · Lsn Air LLC N238BCRainbow Skyreach BUSHCAT · S/N CH285CBuilt 2025 · Black Kenneth D N26088Piper J3C-65 · S/N 4019Built 1939 · Price Laurence A N281TBeech V35 · S/N D-8508Built 1967 · Malerba David N2914KCessna 180K · S/N 18053127Wildness Aviation Limited N35TMJewett Thomas E LONG-EZ · S/N 1233Built 1986 · Jewett Thomas E N3601ECessna 172N · S/N 17271603Built 1978 · Lsn Air LLC N3715GNorth American AT-6G · S/N 49-2898510t6 LLC N376NELloyd Ernest W III SONEX · S/N 0910Built 2011 · Lloyd Ernest W III N4356TJewett Thomas E JEWETT LONG EZ · S/N 103114Built 2021 · Jewett Thomas E N4717HMooney M20J · S/N 24-0819Built 1979 · Linder Marlin D N5151QCessna T210L · S/N 21059651Built 1972 · Notsa LLC N5163HCessna 172S · S/N 172S8933Built 2001 · Lsn Air LLC N711AABeech B-60 · S/N P-417Built 1977 · Pro-Star Aeronautical Inc N9147GCessna 182N · S/N 18260687Built 1971 · Snyder Barry L N92151Cessna 182N · S/N 18260065Built 1969 · Adiabatic Adventures LLC N99568Ercoupe 415-C · S/N 2191Built 1946 · Lloyd Ernest W III N9963XCirrus Design SF50 · S/N 0649Built 2025 · Cloudclear LLC

Back to Morrison, CO