OpenAirDocs.org
Mishawaka, IN

Registered aircraft · 27

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

N107GLDassault-Breguet MYSTERE FALCON 900 · S/N 199Built 2002 · Leep Enterprises LLCN1289XMooney M20E · S/N 162Built 1963 · Conner James BN13567Waco UIC · S/N 3823Built 1933 · Nace Jon JN1534JPiper PA-28-140 · S/N 28-23934Built 1967 · Chapman Melvin Newton IIN17721Waco UKS-7 · S/N 4632Built 1937 · Nace JonN206TMBeech A36 · S/N E-775Built 1975 · Pale Horse LLCN2107LBeech A36 · S/N E-879Built 1976 · N2107l LLCN214HWGlenn Ornat HATZ CB-1 · S/N ORNAT-HATZ 1-220Built 2023 · Hatz Flying Club LLCN22548Stinson HW75 · S/N 7131Built 1939 · V2 Aviation LLCN2488LBuckeye Industries DREAM MACHINE · S/N 3436Built 1996 · Gesto James WN26268Grumman American Avn. AA-5A · S/N AA5A0497David G Mcalpin TrusteeN270HBeech 35 · S/N D-681Built 1947 · Bemenderfer Todd MN291DSEvelyn Daniel R RV-4 · S/N 001Petko James GN32SEElhardt Scott T RV-8 · S/N 82960Built 2012 · V2 Aviation LLCN345JPBuckeye Industries SKYHAWK · S/N 2-25-90 RPBuilt 2001 · Patterson Jeffrey DN3596VCessna 140 · S/N 14864Built 1948 · Petko James GN364GLBeech 95-B55 (T42A) · S/N TC-1983Built 1976 · Leep Enterprises LLCN381MKDJI T40 · S/N 64TBK780010088Enterprise Outdoors LLCN4294EBuckeye Industries DREAM MACHINE · S/N 0003Built 1997 · Hershberger Roy AN50313Destiny 2000 · S/N 1B0105Manning Donald G JrN5199VNorth American SNJ-5 · S/N 43875Built 1960 · V2 Aviation LLCN5454QCessna 150L · S/N 15073354Petko JamesN554TEEavision EA-J150 · S/N JMZKJ150UAV602595273Enterprise Outdoors LLCN81QDRaytheon 400A · S/N RK-192Built 1998 · Quality Dining IncN83QDRaytheon C90GT · S/N LJ-1766Quality Dining IncN8822SCessna 150F · S/N 15062122Registration pending, canceledBuilt 1965N930MCRaytheon C90A · S/N LJ-1720Corporate Flights LLC
Back to Mishawaka, IN