# Registered aircraft: Jefferson, WI

A list on [Jefferson, WI](https://openairdocs.org/faa-place/WI/Jefferson.md).

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

- [N129JB](https://openairdocs.org/aircraft/N129JB.md): Bumgarner Johnny G ZODIAC 601XL · S/N 6-4584 · Built 2009 · Kuykendall Robert J
- [N144BH](https://openairdocs.org/aircraft/N144BH.md): Bell 206B · S/N 1600 · Built 1975 · Abc Helicopters Inc
- [N18BH](https://openairdocs.org/aircraft/N18BH.md): Bell 407 · S/N 53217 · Built 1997 · Abc Helicopters Inc
- [N19BH](https://openairdocs.org/aircraft/N19BH.md): Bell Helicopter Textron Canada 206L-4 · S/N 52370 · Built 2008 · Abc Helicopters Inc
- [N20BH](https://openairdocs.org/aircraft/N20BH.md): Bell 407 · S/N 53242 · Built 1998 · Chemair Helicopters Inc
- [N21BH](https://openairdocs.org/aircraft/N21BH.md): Bell 407 · S/N 53262 · Built 1998 · Chemair Helicopters Inc
- [N221GP](https://openairdocs.org/aircraft/N221GP.md): Bell 206B · S/N 4309 · Built 1994 · Chemair Helicopters Inc
- [N2359V](https://openairdocs.org/aircraft/N2359V.md): Cessna 140 · S/N 14595 · Built 1948 · Degolier-Schulze Stephanie L
- [N23WK](https://openairdocs.org/aircraft/N23WK.md): Bell 206B · S/N 3237 · Built 1981 · Chemair Helicopters Inc
- [N2756P](https://openairdocs.org/aircraft/N2756P.md): Bell 206B · S/N 2655 · Chemair Helicopters Inc
- [N292BH](https://openairdocs.org/aircraft/N292BH.md): Bell 206B · S/N 4255 · Built 1992 · Abc Helicopters Inc
- [N299TB](https://openairdocs.org/aircraft/N299TB.md): Bell 206B · S/N 3174 · Built 1980 · Chemair Helicopters Inc
- [N345RR](https://openairdocs.org/aircraft/N345RR.md): Bell 206B · S/N 2107 · Built 1977 · Chemair Helicopters Inc
- [N38HH](https://openairdocs.org/aircraft/N38HH.md): Bell 206B · S/N 2016 · Built 1976 · Chemair Helicopters Inc
- [N4269X](https://openairdocs.org/aircraft/N4269X.md): North American Medore T-6G · S/N 53-4610-1 · Lorenz Peter
- [N45211](https://openairdocs.org/aircraft/N45211.md): Gulfstream American AA-5B · S/N AA5B1077 · Built 1979 · Beloit Aviators LLC
- [N505TV](https://openairdocs.org/aircraft/N505TV.md): Bell 206B · S/N 3096 · Built 1980 · Chemair Helicopters Inc
- [N5450M](https://openairdocs.org/aircraft/N5450M.md): Boeing A75N1 · S/N 75-1026 · Degolier Schulze Stephanie L
- [N804FJ](https://openairdocs.org/aircraft/N804FJ.md): Ekornaas Fred R SPORT PARASOL · S/N FRE 01 · Built 2000 · Lorenz Peter
- [N9QD](https://openairdocs.org/aircraft/N9QD.md): Bell 206B · S/N 4306 · Built 1994 · Chemair Helicopters Inc

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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 = 'WI' AND g.registrant_city = 'JEFFERSON'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/WI/Jefferson/aircraft

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.