OpenAirDocs.org
Lafayette, IN

Registered aircraft · 86

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

N107CCross Allan F GLASAIR 2 FTS 5 · S/N 2058Built 2003 · Kleinfelter Myles SN1234GMooney M20J · S/N 24-1614Built 1987 · Bs1 LLCN1320CPiper PA-22-135 · S/N 22-1116Toney Tasha FayN1341EChampion 7AC · S/N 7AC-4902Built 1946 · Antonian MarkN14RNVan Arsdale Guy E BABY GREAT LAKES · S/N 75-554BBuilt 1997 · Meyer Corben DN17AMCessna 414 · S/N 414-0524Built 1974 · Farmdog Aviation LLCN18EGCessna 414 · S/N 414-0394Built 1973 · Boanco IncN1941KKenneth Hunt CHRISTAVIA MKI · S/N 339Built 2017 · Balser JoeN1986BSilvaire LUSCOMBE 8A · S/N 6413Sale reportedN215BWClingan Wallace E TR-2 · S/N 54Built 2007 · Lumkes John HN2218AXag P150 · S/N 186324P1822350233E0XTopside Ag LLCN2390QBeech 23 · S/N M-471Latia Douglas CN247DJDJI AGRAS T50 · S/N 1581F6BUB24B20016XZLNxt Gen Ag LLCN2503DSocata TB-20 TRINIDAD · S/N 864Alnico Aviation LLCN2771NCessna 120 · S/N 13029Meyer Corben DN277DTSchweizer 269D · S/N 0028Built 2000 · Findlay Enterprises LtdN2862KHylio AG 230 · S/N 17906100241Freedom Uas CoN2863LHylio AG 230 · S/N 17906100242Freedom Uas CoN2913Thalman Joseph B MURPHY REBEL · S/N 200Built 2011 · Brown Engineering SolutionsN2986TXag P100 PRO · S/N 1863FPEG82193488T3J6Topside Ag LLCN299ETXag P100 PRO · S/N 1863FPEG82193482E37TTopside Ag LLCN326FADJI AGRAS T30 · S/N 1581F446LK2K30300U60Ivy Tech Community College - Lafayette CampusN32PBPiper PA-31-325 · S/N 31-8212006Built 1981 · Lease One LLCN340ABCessna 340A · S/N 340A0471Built 1978 · Bison Investment Advisors IncN347SMTodd Ray QD CTY CHALLENGER II · S/N CH2-0104-2435Built 2004 · Hartman Mark TN36DNavion NAVION B · S/N NAV-4-2217BBuilt 1950 · Summer Winds II LLCN3706EAeronca 11AC · S/N 11AC-1856Built 1951 · Evans Robert FN3775VCessna 140 · S/N 15068Built 1949 · Gevers David EN398ACessna 208B · S/N 208B0390Built 1994 · Str Holdings LLCN40BBCessna 182Q · S/N 18265944Built 1977 · Pawlak Jakub PiotrN411CGMooney International M20V · S/N 33-0002Built 2017 · Denovo Aviation LLCN411SBExtra Flugzeugbau EA300/200 · S/N 024Built 1998 · Meyer CorbenN41331Piper PA-28R-200 · S/N 28R-7435169Built 1974 · Heath AndrewN41EBDiamond Aircraft Ind DA 40 · S/N 40.445Built 2004 · Coakes Randall SN4316DBeech G35 · S/N D-4712Built 1956 · Paulsen JamesN4351KPiper PA-32R-301 · S/N 32R-8413012Built 1984 · Baumgartner Trucking IncN444PWExtra Flugzeugbau EA 230 · S/N 12Built 1987 · Meyer Renee BrilhanteN4580TXag P100 PRO · S/N 82193479F0R3Tng Farmer LLCN4613MBeech A36 · S/N E-1245Built 1978 · Mott John HN472AGCirrus Design SR22T · S/N 2408Built 2021 · Tzc LLCN47394Piper PA-28-181 · S/N 28-7890066Built 1977 · Odle RonN4943KNavion NAVION A · S/N NAV-4-1943Gevers Robert LN521SSDiamond Aircraft Ind DA20-A1 · S/N 1008155840 LLCN524RAMooney M20J · S/N 24-3088Miller SethN5250HPiper PA-16 · S/N 16-54Built 1949 · Philyaw Dale AN548PUCessna 150L · S/N 15074387Built 1973 · Berkey Aviation LLCN549PUCessna 150M · S/N 15078918Built 1976 · Berkey Aviation LLCN552DRHiller - World Helicopters UH-12C · S/N 562261Built 1956 · Mussche Roger HN57ZBell 206B · S/N 3016Built 1980 · T&T Transportation IncN581QADJI AGRAS T50 · S/N 1581F6BUB24A40011P5QNex Gen Ag LLC
Back to Lafayette, IN