OpenAirDocs.org
Warsaw, IN

Registered aircraft · 39

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 = 'WARSAW'
  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.

N102FUDJI AGRAS T50 · S/N 1581F6BUB248T0012R38Zolman Farms IncN110ATTokle THORP T-18 · S/N 480Hoover Brian AN1282RBellanca 14-19-3 · S/N 4335Hoover Brian AN138DMBombardier CL-600-2B16 · S/N 5702Built 2007 · Mld 605 Leasing LLCN1398CCessna 177B · S/N 17702720Built 1977 · Bennett EricN1596ECessna 172N · S/N 17271060Team 172-03 LLCN2322BHead Balloons AX8-88B · S/N 352Baker David LN2358DCessna 170B · S/N 20510Stofer WilliamN2678NPowrachute PC 2000 · S/N A 255 POWMiller Timothy AN2838BBell 47J · S/N 1424Built 1957 · Blessed Beginnings Broadcasting IncN300PJCalloway SENIOR AERO SPORT · S/N HC2ABuilt 1975 · Legacy Of Speed LLCN31824Parker Johnny W D · S/N JP1Built 1993 · Clupper Martt CN355ZBBombardier BD-100-1A10 · S/N 21083Built 2025 · Zimmer Biomet Leasing LLCN362YDDJI AGRAS T50 · S/N 1581F6BUB246J001249WBluesky Applicators LLCN4207NCessna 320B · S/N 320B0047Built 1964 · Hoover Brian AN46322Cessna 172K · S/N 17257185Built 1968 · Asw Aviation LLCN484KBDJI AGRAS T50 · S/N 1581F6BUB24B9001RJ5EBluesky Applicators LLCN500YEBeech 95-B55 (T42A) · S/N TC-1399Built 1971 · Hill Clifford DN552JAPiper PA-32-300 · S/N 32-40147Built 1967 · Av8r Flying Club LLCN560MLCessna 560XL · S/N 560-5027Built 1999 · Mld Leasing LLCN564FFouga CM 170 MAGISTER · S/N 564Legacy Of Speed LLCN5935RCessna 172G · S/N 17253604Built 1965 · Stofer William BN614CCirrus Design SR22 · S/N 0411Built 2002 · Tailwinds LLCN614DDDJI AGRAS T100 · S/N 1581F8ZLC258N002S3Y9Air Strike Drone Services LLCN6655MUniversal Stinson 108-3 · S/N 108-4655Loos Richard LeeN736AAAntosh EAA BIPLANE · S/N FA1Hoover Brian AN7782KCessna 180J · S/N 18052730Built 1976 · Haughee JaredN7792TCessna 172A · S/N 47392Built 1960 · French Rodney AN8160APiper PA-32-300 · S/N 32-7940285Built 1980 · Kasw Aviation LLCN8643TCessna 182C · S/N 52543Stofer WilliamN8761FPiper PA-28-181 · S/N 28-7790265Cook William MN88282Piper J3C-65 · S/N 15900Team J3-01 LLCN92035Cessna 172M · S/N 17261540Built 1973 · Ford Daniel TN927SKLearjet 45 · S/N 051Built 1999 · Crosley Aviation LLCN93129Cessna T210L · S/N 21060274Klca IncN939FMRobinson Helicopter R44 · S/N 0321Built 1997 · Blessed Beginnings Broadcasting IncN947KACirrus Design SR20 · S/N 8904Built 2022 · Kensington Aviation LLCN97453Cessna 182Q · S/N 18267100Built 1979 · Stofer William BN9836YChampion 7EC · S/N 7EC-738Built 1960 · Haughee Jared
Back to Warsaw, IN