# Registered aircraft: Birchwood, WI

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

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

- [N216DC](https://openairdocs.org/aircraft/N216DC.md): Cessna 182S · S/N 18280898 · Built 2000 · Dornink Steven R
- [N3267H](https://openairdocs.org/aircraft/N3267H.md): Engineering & Research ERCOUPE 415-C · S/N 3892 · Built 1946 · Zemaitis Richard A
- [N35431](https://openairdocs.org/aircraft/N35431.md): Piper J3C-85 · S/N 6337 · Built 1941 · Jankowski Philip J
- [N38464](https://openairdocs.org/aircraft/N38464.md): Piper J3C-65 · S/N 7036 · Built 1941 · Ovans Ronald J
- [N3HC](https://openairdocs.org/aircraft/N3HC.md): Christianson JODEL F 12 3 · S/N F8031 · Built 1979 · Ovans Ronald J
- [N4704J](https://openairdocs.org/aircraft/N4704J.md): Bradley J Jilek CHALLENGER II · S/N CH2-1005-2688 · Built 2006 · Jilek Bradley J
- [N47322](https://openairdocs.org/aircraft/N47322.md): Taylorcraft DCO-65 · S/N 4264 · Built 1942 · Bergstrom Donald E
- [N5191M](https://openairdocs.org/aircraft/N5191M.md): Taylorcraft BC12-D1 · S/N 10491 · Built 1954 · Kittinger Russell P
- [N6770A](https://openairdocs.org/aircraft/N6770A.md): Cessna 172 · S/N 28870 · Built 1956 · Hele David A
- [N6897](https://openairdocs.org/aircraft/N6897.md): Cessna 305A · S/N 22728 · Built 1955 · Bergstrom Donald E
- [N7081B](https://openairdocs.org/aircraft/N7081B.md): Schrock Ronald R RV4 · S/N 2858 · Built 1993 · Ovans Ronald J
- [N7370](https://openairdocs.org/aircraft/N7370.md): Billie D Carter STOL CH 750 · S/N DB-003 · Built 2012 · Kittinger Russell P
- [N8088S](https://openairdocs.org/aircraft/N8088S.md): Cessna 150F · S/N 15061688 · Built 1965 · Rutherford Thom J
- [N813RP](https://openairdocs.org/aircraft/N813RP.md): Ryan R Peters JUST ACFT HIGHLANDER · S/N JA311-08-13 · First renewal notice · Peters Ryan R
- [N98LH](https://openairdocs.org/aircraft/N98LH.md): Hefel Lyle L RV-8 · S/N 82054 · Built 2007 · Ovans Ronald J
- [N998KT](https://openairdocs.org/aircraft/N998KT.md): Trontvet Kent A RANS S-12 AIRAILE · S/N 0493402 · Built 1994 · Dakins Bruce

## 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 = 'BIRCHWOOD'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/WI/Birchwood/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.
