# Registered aircraft: Spirit Lake, ID

A list on [Spirit Lake, ID](https://openairdocs.org/faa-place/ID/Spirit%20Lake.md).

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

- [N180DK](https://openairdocs.org/aircraft/N180DK.md): Cessna 180J · S/N 18052456 · Built 1974 · Griffin Vaughn
- [N18ZZ](https://openairdocs.org/aircraft/N18ZZ.md): Piper PA-18A-135 · S/N 18-3380 · Built 1959 · Gardom Brandon D
- [N200MP](https://openairdocs.org/aircraft/N200MP.md): Pipistrel D O O Ajdovscina TAURUS · S/N 046 T 503 · Built 2009 · Smith Bruce Martin Trustee
- [N22KR](https://openairdocs.org/aircraft/N22KR.md): Rogers Kenneth R ROGERS SEA EAGLE · S/N R006 · Rogers Kenneth R
- [N245X](https://openairdocs.org/aircraft/N245X.md): Borden Charles R BUSHBY MDGT MUSTANG · S/N 1245 · Built 1998 · Yancey Patrick D
- [N2909C](https://openairdocs.org/aircraft/N2909C.md): Cessna 180 · S/N 30809 · Built 1954 · Hall Michael A
- [N366RZ](https://openairdocs.org/aircraft/N366RZ.md): Fly Baby 1-A · S/N 63-35 · First renewal notice · Built 1967 · Owens Duane C
- [N401CD](https://openairdocs.org/aircraft/N401CD.md): Dowrick Charles LIGHT SPORT · S/N 1 · Built 2006 · Mccartney Terry A
- [N4215X](https://openairdocs.org/aircraft/N4215X.md): Kenneth R Rogers KEN TECH KT2 · S/N 1089 · Rogers Kenneth R
- [N4518C](https://openairdocs.org/aircraft/N4518C.md): Cessna 170B · S/N 25462 · Built 1954 · Longden Earl W
- [N45DC](https://openairdocs.org/aircraft/N45DC.md): Clinchy David G KITFOX S7 SUPERSPORT · S/N KA24180630 · Built 2025 · Clinchy David
- [N490B](https://openairdocs.org/aircraft/N490B.md): Bayer Oscar STARDUSTER SA300 · S/N 1994 · Yancey Patrick D
- [N508CD](https://openairdocs.org/aircraft/N508CD.md): David Clinchy BADLANDS TRAVELER · S/N BLAKT016 · Clinchy David G
- [N5664A](https://openairdocs.org/aircraft/N5664A.md): Cessna 172 · S/N 28264 · Sale reported · Built 1956
- [N574DG](https://openairdocs.org/aircraft/N574DG.md): Garis P R/Garis J D GLACIER CUB · S/N 777 · Built 2003 · Smith Bruce Martin Trustee
- [N5VE](https://openairdocs.org/aircraft/N5VE.md): Cessna 182P · S/N 18264950 · Built 1976 · Murphee Koby T
- [N7355A](https://openairdocs.org/aircraft/N7355A.md): Cessna 172 · S/N 29455 · Built 1956 · Owens Duane Curtis
- [N735SR](https://openairdocs.org/aircraft/N735SR.md): Cessna 182Q · S/N 18265652 · Built 1977 · Moen Ronald C
- [N7829H](https://openairdocs.org/aircraft/N7829H.md): Piper PA-12 · S/N 12-729 · Built 1946 · Gardom Brandon D
- [N8880U](https://openairdocs.org/aircraft/N8880U.md): Cessna 150M · S/N 15078012 · Built 1976 · Jackson Todd

## 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 = 'ID' AND g.registrant_city = 'SPIRIT LAKE'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/ID/Spirit%20Lake/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.