Skip to content

Registered aircraft · 33

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 = 'IN' AND g.registrant_city = 'VINCENNES' 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 = 'IN' AND g.registrant_city = 'VINCENNES'
  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 = 'IN' AND g.registrant_city = 'VINCENNES'
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.

N12PRPersonal Rotorcraft MOSQUITO XE · S/N MXE 1015 E 06Built 2007 · Personal Rotorcraft LLC N18VUCessna 310R · S/N 310R0928Built 1977 · Vincennes University N205ACDJI AGRAS T50 · S/N 1581F6BUB24B5001FZZ3Pdg Farms LLC N24791Ceresair BB C31 · S/N 215785407028ED M E Anson Farms Inc N25VKVan Kalker John E RAF 2000 GTX SE · S/N 251Built 1999 · Illiana Aero LLC N295GSScott Stine THORP T-18 · S/N 763Built 2026 · Stine Scott N32VUPiper PA-44-180 · S/N 4496430Built 2018 · Vincennes University N33VUPiper PA-44-180 · S/N 4496431Built 2018 · Vincennes University N38468Piper PA-28R-201T · S/N 28R-7703225Built 1977 · Emmons Kevin D N41TSSchneider Thomas C SX300 · S/N 009Built 2001 · Illiana Aero LLC N434HHXag P100 PRO · S/N 1863FPEG8219348641MUHorrall Jacob R N45VUCirrus Design SR20 · S/N 2443Built 2018 · Vincennes University N46VUCirrus Design SR20 · S/N 2444Built 2018 · Vincennes University N473DMDJI AGRAS T50 · S/N 1581F6BUB235T0010030Pdg Farms LLC N474DMDJI AGRAS T50 · S/N 1581F6BUB23AG001496RPdg Farms LLC N479WTXag P150 · S/N 186324P18223502X9N76Hx3 Turkey Farms LLC N48VUCirrus Design SR20 · S/N 2446Built 2018 · Vincennes University N513CAAdams Carl R THORP T-18 · S/N 6670Adams Carl R N5261XChampion 7ECA · S/N 712Built 1969 · Petri Howard R N545WAPiper PA-28R-180 · S/N 28R-30577Built 1968 · Stine Scott A N5728ACessna 172 · S/N 28328Built 1956 · Mcgiffen Christine L N623NATalos Drones TALOS T60X · S/N 7QTWNFU00120E1D Farms Inc N65VUCirrus Design SR20 · S/N 10919Built 2025 · Vincennes University N66VUCirrus Design SR20 · S/N 10923Built 2025 · Vincennes University N67VUCirrus Design SR20 · S/N 11015Built 2025 · Vincennes University N68VUCirrus Design SR20 · S/N 11041Built 2025 · Vincennes University N69VUCirrus Design SR20 · S/N 11049Built 2025 · Vincennes University N70VUCirrus Design SR20 · S/N 11186Built 2026 · Vincennes University N71VUCirrus Design SR20 · S/N 11188Built 2026 · Vincennes University N72VUCirrus Design SR20 · S/N 11197Built 2026 · Vincennes University N73VUCirrus Design SR20 · S/N 11209Built 2026 · Vincennes University N7668FPiper PA-28-151 · S/N 28-7715232Built 1976 · Adams Carl N814ABTimothy W Bellury JA 30 SUPERSTOL · S/N JA361-03-14Registration pendingBuilt 2016

Back to Vincennes, IN