OpenAirDocs.org
Charlotte, MI

Registered aircraft · 26

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 = 'MI' AND g.registrant_city = 'CHARLOTTE'
  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.

N101MNNickless Michael L CUBY · S/N 514Nickless Michael LN138CSSuydam Charles MK IV · S/N 837Built 2006 · Eakin BrianN142PFBobcik John J KITFOX S7 SUPERSPORT · S/N KA12216239Built 2015 · Bobcik John JN153JCAircraft Sales And Parts CHINOOK PLUS 2/A · S/N 02223X3Built 2007 · Caughey Jack AN1835NChampion R K/Champion K R KITFOX IV · S/N 1835Built 1993 · Bracy Lynwood RN1885NBradley Ivan ZENITH 650 · S/N 65-10554Bradley IvanN1956QWend Roger W QUICKIE · S/N 0320Built 1989 · Wend Roger WN2332CCessna 180 · S/N 30632Built 1954 · Balgoyen James TN257RWWindeler Robert BREEZE · S/N 001Built 2013 · Crandell Kurt AN261Schleicher ASW-20 · S/N 20112Built 1977 · Larder Lee RN283GBeech B24R · S/N MC-241Built 1974 · Wend Roger WN323DTPiper PA-32-300 · S/N 32-7740024Built 1977 · Eaton Professionals IncN36230Taylorcraft BC12-65 · S/N 3187Built 1941 · Moore William GN369KFLarder Lee KITFOX IV · S/N 1720Built 1996 · Larder Lee RN377CWCameron Balloons US C-80 · S/N 6419Droscha Jeremy JN4062FCessna 172 · S/N 36962Built 1958 · Charlotte Air ServicesN4129WPiper PA-32-300 · S/N 32-40195H & L Air LLCN434BGDJI AGRAS T50 · S/N 1581F6BUB24890016854Wheaton Glen AN5160ZPiper PA-22-108 · S/N 22-8814Built 1961 · Wend Roger WN53865Bellanca 7GCBC · S/N 892-76Built 1975 · Larder Aviation LLCN5915Talos Drones T60X · S/N 2104F7EZW2567001ZXH2Cords Aerial Services LLCN66916Beech V35B · S/N D-10327Technet Aviation LLCN6WPCessna 305A · S/N 23325Built 1951 · Balgoyen James TN7683GCessna 172L · S/N 17259383Built 1970 · Balgoyen James TN786GMKaines Michael TIERRA II · S/N 13519Crandell Kurt AN8722UCessna 172F · S/N 172-52626Built 1965 · Brown Stephen L
Back to Charlotte, MI