OpenAirDocs.org
Aurora, CO

Registered aircraft · 116

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

N100DDRyan Aeronautical NAVION · S/N NAV41518Built 1948 · Cook Allen JN11440Waco QCF · S/N 3497Aerojet Services IncN1157AMooney M20J · S/N 24-1257Built 1982 · Mach Holdings LLCN1284North American T-6G · S/N 12463Built 1950 · Nelson Aero Service LLCN13046Waco PCF · S/N 3574Aerojet Services IncN13062Mihlebach Gustav F2 SPECIAL · S/N 002GMAerojet Services IncN1399CPiper PA-22-135 · S/N 22-1150Built 1953 · Shankster Thomas GN140AGNorth American T-28C · S/N 140511Built 1956 · N3645f LLCN143MYRobinson Helicopter R44 II · S/N 10478Built 2004 · Peaks Rental LLCN150PRBeech C-45G · S/N AF-382Aerojet Servivces IncN1794MCessna 182P · S/N 18264447Built 1975 · Skyriders Flying Club IncN180DBRolladen-Schneider LS 4A · S/N 4516Built 1985 · Barry John LN183RERandall Eaker RV-7A · S/N 72009Built 2017 · Eaker Randall NN184TSpaur Charles VANS RV-6 · S/N 3Built 2024 · Spaur Charles WN19370Cessna 172K · S/N 17257181Built 1968 · Clanton Ronald WN2016YBeech V35B · S/N D-10157Built 1978 · 2016y LLCN201CTMooney M20J · S/N 24-0046Built 1976 · Frye Lyndal DN202PCMooney M20J · S/N 24-1086Built 1981 · Lowell Bret IN20526Cessna 172M · S/N 17261363Built 1973 · Chester Steven GN2101APiper PA-22-135 · S/N 22-561York Harrison EN2127RPiper PA-28-180 · S/N 28-5465Built 1969 · Cohen Blanche FN215RHVans RV-12 · S/N 120375Built 2012 · Helfrich Robert JN22015AB Sportine Aviacija GENESIS 2 · S/N 2015Built 1999 · Stieber Chris DN2201LBeech V35B · S/N D-9938Built 1976 · Horizon Enterprises Vne LLCN2206CCessna 180 · S/N 30506Built 1953 · Patton Mark AN2267TCessna A185E · S/N 185-1427Aeropod IncN229BPBombardier BD-100-1A10 · S/N 20741Built 2018 · Whisky Echo Aviation LLCN231CBMooney M20K · S/N 25-0045Built 1979 · Kodiak Aviation Partners LLCN2360TNavion NAVION G · S/N NAV-4-2360Built 1961 · Aerojet Sevices IncN24465Taylorcraft BC-65 · S/N 1802Built 1940 · Bluhm J LawrenceN2538SCessna T210L · S/N 21061322Built 1976 · Barbo Walter AN253NShay VANS RV10 · S/N 41999Built 2020 · Shay Aviation LLCN25LNLindstrand Balloons 77A · S/N 5310Built 2005 · Cook KelliN2677KCessna 180K · S/N 18053034Aeropod IncN2782FCessna 182J · S/N 18256882Built 1965 · Mansoori Ali SN28770Grumman American Avn. AA-5B · S/N AA5B0704Built 1978 · Stieber Chris DN3141DCessna 180 · S/N 31939Built 1955 · Nelson Donald WN314SHHerrick Steve NORTH STAR · S/N 114Built 1999 · Grover Arlan KN319GCirrus Design SR22 · S/N 0319Built 2002 · Silver Star Holdings LLCN327DBeech S35 · S/N D-7801Built 1965 · Bonanza Flyers LLCN33655Piper PA-28-140 · S/N 28-7525220Built 1975 · Gordon William S IIIN3556HMooney M20K · S/N 25-0421Built 1980 · Rocket Joy LLCN3645FNorth American SNJ-5 · S/N 43779Built 1958 · N3645f LLCN3658NPiper PA-12 · S/N 12-1911Built 1947 · Univair Aircraft CorpN3678LGreat Lakes 2T-1A-2 · S/N 0822Built 1978 · Aerojet Services IncN375GMAviat A-1B · S/N 2355Built 2006 · Maitlen Gregory AN37PPCessna 150J · S/N 15069944Built 1968 · Parsons Paul MN397TACostruzioni Aeronautiche Tecna P2010 · S/N 097/USBuilt 2019 · Barry John LN39806Bellanca 17-30A · S/N 73-30510Williams Jeffrey ThomasN4020UArbc Inc DBA Lindstrand 77X · S/N 5786Built 2023 · Cook Kelli R
Back to Aurora, CO