# Registered aircraft: Bloomer, WI

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

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

- [N10DZ](https://openairdocs.org/aircraft/N10DZ.md): Zank Don G CHALLENGER II · S/N 0403 · Built 1989 · Zank Don G
- [N1303Y](https://openairdocs.org/aircraft/N1303Y.md): Cessna 172C · S/N 17249003 · Day Patrick J
- [N1911A](https://openairdocs.org/aircraft/N1911A.md): Piper PA-18 · S/N 18-1745 · Built 1952 · Day Patrick J
- [N201DZ](https://openairdocs.org/aircraft/N201DZ.md): Zank Don TDLW · S/N 001 · Built 2001 · Zank Don
- [N2390U](https://openairdocs.org/aircraft/N2390U.md): Cessna 172D · S/N 17249990 · Built 1962 · Kuhn Jacob H
- [N25174](https://openairdocs.org/aircraft/N25174.md): Luscombe 8A · S/N 1098 · Built 1939 · Wighton Harold B
- [N375AJ](https://openairdocs.org/aircraft/N375AJ.md): Cirrus Design SR22T · S/N 0041 · Built 2010 · Golden Calf Company LLC
- [N38223](https://openairdocs.org/aircraft/N38223.md): Piper J3L-65 · S/N 6869 · Kuhn Brent
- [N39PW](https://openairdocs.org/aircraft/N39PW.md): Embraer Executive EMB-500 · S/N 50000430 · Built 2023 · Ruff Co 1 LLC
- [N463CD](https://openairdocs.org/aircraft/N463CD.md): DJI AGRAS T40 · S/N 1581F574B2387001004Y · Creekside Drone Services LLC
- [N631JB](https://openairdocs.org/aircraft/N631JB.md): Brockman Jerry CHALLENGER II · S/N 0631 · Zank Don
- [N653AA](https://openairdocs.org/aircraft/N653AA.md): DJI AGRAS T100 · S/N 1581F8ZLC258N002B1PT · Aerial Agritech LLC
- [N656AA](https://openairdocs.org/aircraft/N656AA.md): DJI AGRAS T100 · S/N 1581F8ZLC258N0023B16 · Aerial Agritech LLC
- [N7390J](https://openairdocs.org/aircraft/N7390J.md): Piper PA-28-140 · S/N 28-24752 · Built 1968 · Viets Richard C
- [N7565E](https://openairdocs.org/aircraft/N7565E.md): Champion 7FC · S/N 7FC-259 · Built 1958 · Southworth Grant J
- [N7685M](https://openairdocs.org/aircraft/N7685M.md): Cessna TR182 · S/N R18201583 · Built 1980 · Lazy Double Air LLC
- [N839RV](https://openairdocs.org/aircraft/N839RV.md): Edwards Edgar A RV-9A · S/N 90839 · Built 2010 · High Performance Aircraft Products LLC
- [N918AA](https://openairdocs.org/aircraft/N918AA.md): DJI AGRAS T40 · S/N 1581F574B23540010038 · Aerial Agritech LLC

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

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