# Registered aircraft: Johnston, IA

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

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

- [N1052P](https://openairdocs.org/aircraft/N1052P.md): DJI AGRAS T40 · S/N 64TBL2100201MC · Pioneer Hi-Bred International Inc
- [N1540M](https://openairdocs.org/aircraft/N1540M.md): Cessna 182P · S/N 18264367 · Built 1975 · Clark Robert L Jr
- [N1749P](https://openairdocs.org/aircraft/N1749P.md): Hylio AG-272 · S/N 070250 · Pioneer Hi-Bred International Inc
- [N21926](https://openairdocs.org/aircraft/N21926.md): Firefly Balloons FIREFLY 7-15 · S/N F7-2035 · Built 2003 · Pedersen Tyler
- [N223TF](https://openairdocs.org/aircraft/N223TF.md): Cirrus Design SR22 · S/N 3814 · Built 2011 · Meadowlark Air LLC
- [N3115](https://openairdocs.org/aircraft/N3115.md): Eaa Biplane P · S/N 1967 · Built 1968 · Bravo Charlie LLC
- [N3219Y](https://openairdocs.org/aircraft/N3219Y.md): Balloon Works FIREFLY 7-15 · S/N F7-1056 · Built 1998 · Wiltse Bret A
- [N409WP](https://openairdocs.org/aircraft/N409WP.md): Arbc Inc DBA Lindstrand 77X · S/N 5691 · Built 2019 · Seymour Joseph W
- [N41QB](https://openairdocs.org/aircraft/N41QB.md): Piper PA-18-150 · S/N 18-7909067 · Built 1979 · Bravo Charlie LLC
- [N448RP](https://openairdocs.org/aircraft/N448RP.md): DJI AGRAS T50 · S/N 1581F6BUB249001W127 · Pioneer Hi-Bred International Inc
- [N448TP](https://openairdocs.org/aircraft/N448TP.md): DJI AGRAS T50 · S/N 1581F6BUB249T0018FE2 · Pioneer Hi-Bred International Inc
- [N491ET](https://openairdocs.org/aircraft/N491ET.md): Piper PA-28-140 · S/N 28-24880 · Built 1968 · Kennebeck Ronald C
- [N581CP](https://openairdocs.org/aircraft/N581CP.md): Cessna A185F · S/N 18504090 · Built 1980 · Rdc Leasing Lc
- [N61LE](https://openairdocs.org/aircraft/N61LE.md): Lorimor Jeffery RV-6 · S/N 20742 · Built 1999 · Ackerman Nile
- [N7133U](https://openairdocs.org/aircraft/N7133U.md): Aerostar International RX-7 · S/N RX7-3314 · Built 1995 · Riehle Jacob P
- [N719VA](https://openairdocs.org/aircraft/N719VA.md): Vans RV-12 · S/N 120719 · Built 2022 · Long Gregory D
- [N726KR](https://openairdocs.org/aircraft/N726KR.md): Cirrus Design SR22 · S/N 4592 · Built 2018 · E&E LLC
- [N74474](https://openairdocs.org/aircraft/N74474.md): Bellanca 14-13-2 · S/N 1587 · B & C Specialty Inc
- [N7635E](https://openairdocs.org/aircraft/N7635E.md): Downer BELLANCA 14-19-3 · S/N 4137 · Nu-Trans Inc
- [N7658K](https://openairdocs.org/aircraft/N7658K.md): Piper PA-20 · S/N 20-479 · Jensen Gregory
- [N8655W](https://openairdocs.org/aircraft/N8655W.md): Piper PA-28-235 · S/N 28-10176 · Built 1963 · Gtj LLC
- [N901PH](https://openairdocs.org/aircraft/N901PH.md): Eavision EA-J70 · S/N 1596A34F52D9359 · Pioneer Hi-Bred International Inc
- [N952DC](https://openairdocs.org/aircraft/N952DC.md): DJI AGRAS T40 · S/N 1581F574B239K0010026 · Pioneer Hi Bred International 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 = 'IA' AND g.registrant_city = 'JOHNSTON'
ORDER BY g.n_number
```

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