Skip to content

Aeroconver AEROVEE

Registered aircraft · 52

Aircraft with this engine in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE engine_model_code IN ('01401')
  ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE engine_model_code IN ('01401')
ORDER BY 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.

N113YXOneil Conn W · Ogallala, NEBuilt 2009 · S/N WO113 N1214MAnsinn Detlev D · Bridgman, MIBuilt 2012 · S/N 0422 N123HFAcampora Cappy P · Lincoln, CABuilt 2012 · S/N ONX0026 N131CCClemen Charles A · Delta, COBuilt 2012 · S/N 1223 N1517SCulver Robert J · Frankston, TXBuilt 2015 · S/N SNX1517 N153TDVilla Gregory Joseph · Vacaville, CABuilt 2017 · S/N ONX0153 N16XSJones Craig M · Austin, MNBuilt 2006 · S/N X0011 N1952LLatshaw Sonja · Vero Beach, FLBuilt 2013 · S/N W0188 N196YXStearns Tim L · Kenosha, WIBuilt 2009 · S/N W0052 N204VWGrassl Joseph R · Mosinee, WIBuilt 2010 · S/N 20 N207UJStauffer James A N · Baldwin, WIBuilt 2010 · S/N X0023 N209SWRudd William A Trustee · Merced, CABuilt 2013 · S/N W0128 N224KTMacht Keith A · Colchester, CTBuilt 2014 · S/N 554 N251RKEnd Edward G · Indianapolis, INBuilt 2011 · S/N 1071 N292SXRoberts Eric S · Ainsworth, IAS/N 1292 N296SXCooper Terry L · Burlington, WIBuilt 2016 · S/N 1508 N313RCSassaman Shawn · Sunbury, PAS/N 0313 N331EXVersteeg Matthew Jackson · Urbandale, IABuilt 2014 · S/N ONX0033 N344PTNelson Garrett T · Shoreview, MNBuilt 2016 · S/N 1634 N350NXSale Reported · Kelso, WASale reportedS/N ONX0035 N366HGWaldron Mark T · Beavercreek, OHBuilt 2009 · S/N 1230 N3677FStauffer Andrew K · Sacred Heart, MNBuilt 2008 · S/N 0498 N369URStartks Travis J · Buffalo, WYBuilt 2008 · S/N 0872 N374NKKolodji Dean M · Northome, MNBuilt 2009 · S/N 923 N391SXDykes Steve B · Omak, WABuilt 2011 · S/N 1391 N407SXSorgen Samuel E · Saint Augustine, FLBuilt 2007 · S/N 407 N419SKGates Tristan Blain · Woodbridge, VABuilt 2011 · S/N 972 N432SXIssitt Greg · Saint Louis, MOBuilt 2012 · S/N 1044 N447UEGooney Bird LLC · Chandler, AZBuilt 2013 · S/N 092310151 N485PBLomeli Nick T · Covina, CABuilt 2012 · S/N 1010 N495WTByrer Charles T · Thorndale, TXBuilt 2010 · S/N 0495 N50NXDickler Martin D · Chicago, ILBuilt 2012 · S/N 0373 N529TJFreeman Phillip D · Rutherfordton, NCBuilt 2012 · S/N 1170 N531SXEagle Sport LLC · Peoria, AZBuilt 2008 · S/N 0531 N5343EBlue Side Up Aviation Group · Novato, CAS/N 0074 N535TEBaker Michael D · Hartselle, ALBuilt 2010 · S/N JAESC0074 N551XHelm Thomas N · Neenah, WIBuilt 2021 · S/N ONX0137 N5599Sorenson Fred Chris · Las Vegas, NVBuilt 2006 · S/N 001 N561PHHoey Peter F · Doylestown, PABuilt 2022 · S/N SNB0021 N612PWMccoy Jessika · Tucson, AZBuilt 2011 · S/N 1155 N61NXHomic Michael J · Edmond, OKBuilt 2012 · S/N ONX0018 N622CVLuttio Rodger Alexander · Waterford, WIBuilt 2008 · S/N 0828 N663PSun N Fun Fly In Inc · Lakeland, FLBuilt 2019 · S/N ONX0205 N667LRegistration Pending · Langsville, OHRegistration pendingBuilt 2016 · S/N 1432 N676SXTroyer Robert E · Toledo, WABuilt 2023 · S/N 0676 N705SXForward Rolland L · Ingleside, TXBuilt 2007 · S/N 705 N717RMJohnson Chad R · Mcpherson, KSBuilt 2022 · S/N W0050 N752MRVrooman Myles E · Lovelock, NVBuilt 2014 · S/N ONX0038 N76ETHeino David Jacob · Bradenton, FLBuilt 2014 · S/N 1072 N890TJGehle Roger · South Lyon, MIBuilt 2020 · S/N 0044

Back to Aeroconver AEROVEE