# Registered aircraft: Crystal River, FL

A list on [Crystal River, FL](https://openairdocs.org/faa-place/FL/Crystal%20River.md).

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

- [N125ZX](https://openairdocs.org/aircraft/N125ZX.md): Asap BEAVER RX550 · S/N RX051 · Oehmig Randy
- [N221PH](https://openairdocs.org/aircraft/N221PH.md): Cirrus Design SR22 · S/N 4872 · Built 2019 · Florida Flight Physical LLC
- [N340JC](https://openairdocs.org/aircraft/N340JC.md): Cessna 340A · S/N 340A0801 · Built 1979 · S O W Aviation LLC
- [N4604N](https://openairdocs.org/aircraft/N4604N.md): Cessna 340A · S/N 340A1016 · Built 1980 · S O W Aviation LLC
- [N483CZ](https://openairdocs.org/aircraft/N483CZ.md): Rawls Ricky E COZY MAR IV · S/N 0483 · Rawls Ricky E
- [N496JD](https://openairdocs.org/aircraft/N496JD.md): Piper PA-23-250 · S/N 27-2028 · Donnelly Jamy Christopher
- [N5102E](https://openairdocs.org/aircraft/N5102E.md): Cessna 172N · S/N 17271714 · Built 1978 · Cag Aircraft Holdings LLC
- [N527RT](https://openairdocs.org/aircraft/N527RT.md): Johnson Dale A ZNTH ZODIAC CH601HDS · S/N 6-3498 · Built 1998 · Hallman Steven V
- [N560LD](https://openairdocs.org/aircraft/N560LD.md): Cessna 560XL · S/N 560-5614 · Built 2006 · Cd Fl Management LLC
- [N587J](https://openairdocs.org/aircraft/N587J.md): Jabiru USA Sport J250-SP · S/N 390 · Built 2007 · Smoak T F
- [N58CM](https://openairdocs.org/aircraft/N58CM.md): Agusta A119 · S/N 14030 · Crystal Motorsports LLC
- [N6158G](https://openairdocs.org/aircraft/N6158G.md): Cessna 172N · S/N 17273573 · Built 1979 · Cag Aircraft Holdings LLC
- [N6182V](https://openairdocs.org/aircraft/N6182V.md): Caudill Larry/Caudill Charles RAF 2000 GTX SE · S/N H2-96-7-202 · Caudill Charles
- [N6426T](https://openairdocs.org/aircraft/N6426T.md): Cessna R182 · S/N R18202019 · S O W Aviation LLC
- [N65MM](https://openairdocs.org/aircraft/N65MM.md): Cessna 337B · S/N 337M0446 · Built 1969 · Shewbart Keith M
- [N731TS](https://openairdocs.org/aircraft/N731TS.md): Cessna A188B · S/N 18803148T · Built 1978 · Santana Hector Rafael
- [N737HW](https://openairdocs.org/aircraft/N737HW.md): Cessna 172N · S/N 17269439 · Built 1977 · Cag Aircraft Holdings LLC
- [N739AG](https://openairdocs.org/aircraft/N739AG.md): Cessna 172N · S/N 17270385 · S O W Aviation LLC
- [N739JB](https://openairdocs.org/aircraft/N739JB.md): Cessna 172N · S/N 17270570 · Built 1978 · S O W Aviation LLC
- [N739XT](https://openairdocs.org/aircraft/N739XT.md): Cessna 172N · S/N 17270895 · S O W Aviation LLC
- [N745X](https://openairdocs.org/aircraft/N745X.md): Cessna 182L · S/N 18258933 · Built 1968 · Colson Troy D
- [N786CM](https://openairdocs.org/aircraft/N786CM.md): Dassault/Sud FAN JET FALCON SER F · S/N 486 · Built 1986 · Crystal Motorsports LLC
- [N78KP](https://openairdocs.org/aircraft/N78KP.md): Grumman American Avn. AA-5B · S/N AA5B0758 · Built 1978 · Youngblood Dennis L
- [N868SA](https://openairdocs.org/aircraft/N868SA.md): Cessna 172M · S/N 17266439 · S O W Aviation LLC
- [N9034G](https://openairdocs.org/aircraft/N9034G.md): Cessna 182N · S/N 18260574 · Built 1971 · Danielle K Heckman
- [N90AV](https://openairdocs.org/aircraft/N90AV.md): Bellanca 7KCAB · S/N 462-74 · Built 1974 · Cag Aircraft Holdings LLC
- [N919KS](https://openairdocs.org/aircraft/N919KS.md): Thompson Mike J SONERAI 2-L · S/N 02 · Built 1997 · Smuz Steven P
- [N9608H](https://openairdocs.org/aircraft/N9608H.md): Cessna 172M · S/N 17266261 · Built 1975 · Cag Aircraft Holdings LLC
- [N9716D](https://openairdocs.org/aircraft/N9716D.md): Piper PA-22-160 · S/N 22-6628 · Built 1959 · Kappele Arthur J

## 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 = 'FL' AND g.registrant_city = 'CRYSTAL RIVER'
ORDER BY g.n_number
```

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