# Registered aircraft: Bloomfield, IA

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

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

- [N1743M](https://openairdocs.org/aircraft/N1743M.md): Marshall Dias AF503 · S/N 0127964224 · Dias Marshall
- [N371ZG](https://openairdocs.org/aircraft/N371ZG.md): DJI AGRAS T20P · S/N 1581F574B23 · Greater Harvest Drones LLC
- [N401GG](https://openairdocs.org/aircraft/N401GG.md): DJI AGRAS T40 · S/N 64TBL6300200GG · Greater Harvest Drones LLC
- [N402GG](https://openairdocs.org/aircraft/N402GG.md): DJI AGRAS T40 · S/N 64TBL63002000G · Greater Harvest Drones LLC
- [N4318C](https://openairdocs.org/aircraft/N4318C.md): Champion 7EC · S/N 7EC-323 · Built 1955 · Eakins Clifford P
- [N536KF](https://openairdocs.org/aircraft/N536KF.md): Kopf Merle W KITFOX 4 · S/N 1536 · Sensenig Gary
- [N5408W](https://openairdocs.org/aircraft/N5408W.md): Piper PA-28 · S/N 28-477 · Triple M&W LLC
- [N5456Z](https://openairdocs.org/aircraft/N5456Z.md): Piper PA-22-108 · S/N 22-9234 · Built 1961 · Dias Marshall
- [N5487P](https://openairdocs.org/aircraft/N5487P.md): Piper PA-24-250 · S/N 24-548 · Built 1958 · Dotterer Kurt Samuel
- [N69YK](https://openairdocs.org/aircraft/N69YK.md): Cirrus Design SR22 · S/N 5110 · Built 2021 · Metal Wholesale LLC
- [N7059X](https://openairdocs.org/aircraft/N7059X.md): Powrachute PEGASUS · S/N A 441 PEG · Built 2007 · Mcclure Mike J
- [N865AG](https://openairdocs.org/aircraft/N865AG.md): Xag P150 · S/N 186324P18223508L0X47 · Agriguard LLC
- [N8686E](https://openairdocs.org/aircraft/N8686E.md): Corben Baby Ace C MODIFIED · S/N AL-1 · Dias Marshall D
- [N9319D](https://openairdocs.org/aircraft/N9319D.md): Piper PA-22-160 · S/N 22-6332 · Built 1958 · Cloud Buster LLC
- [N971TX](https://openairdocs.org/aircraft/N971TX.md): DJI AGRAS T50 · S/N 1581F6BUB24B60018H8X · Aerial Ag Innovations LLC
- [N972TX](https://openairdocs.org/aircraft/N972TX.md): DJI AGRAS T50 · S/N 1581F6BUB24B9001ME37 · Aerial Ag Innovations 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 = 'IA' AND g.registrant_city = 'BLOOMFIELD'
ORDER BY g.n_number
```

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