# Registered aircraft: Clarksdale, MS

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

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

- [N1061F](https://openairdocs.org/aircraft/N1061F.md): Beech 58 · S/N TH-1761 · Foxtrot Flight LLC
- [N14VL](https://openairdocs.org/aircraft/N14VL.md): Mitsubishi MU-2B-60 · S/N 1514SA · Built 1981 · Jpw Aviation LLC
- [N2142S](https://openairdocs.org/aircraft/N2142S.md): Cessna T182T · S/N T18208224 · Built 2003 · Dbm Farms Inc
- [N2170T](https://openairdocs.org/aircraft/N2170T.md): Piper PA-28-180 · S/N 28-7205020 · Built 1971 · Clarksdale-Coahoma County Airport
- [N248](https://openairdocs.org/aircraft/N248.md): Raytheon B36TC · S/N EA-678 · Built 2001 · G E Flight Services LLC
- [N2873X](https://openairdocs.org/aircraft/N2873X.md): Piper PA-32-300 · S/N 32-7940172 · Jag III Aviation LLC
- [N3030L](https://openairdocs.org/aircraft/N3030L.md): Air Tractor AT-802A · S/N 802A-0602 · Built 2015 · Shannon Agricultural Flying Inc
- [N3068B](https://openairdocs.org/aircraft/N3068B.md): Air Tractor AT-602 · S/N 602-1248 · Built 2014 · Mccreary Flying Service LLC
- [N419FF](https://openairdocs.org/aircraft/N419FF.md): Air Tractor AT-802A · S/N 802A-0191 · Mccreary Flying Service LLC
- [N45461](https://openairdocs.org/aircraft/N45461.md): Air Tractor AT-502 · S/N 502-0124 · Built 1990 · Shannon Agricultural Flying Inc
- [N473FS](https://openairdocs.org/aircraft/N473FS.md): Air Tractor AT-802A · S/N 802A-0473 · Built 2012 · Shannon Agricultural Flying Inc
- [N4961S](https://openairdocs.org/aircraft/N4961S.md): Hylio AG 230 · S/N 17906100353 · Meredith Scotty Alan II
- [N5313U](https://openairdocs.org/aircraft/N5313U.md): Cessna T210N · S/N 21064862 · Built 1984 · Sky Quest 210 LLC
- [N55290](https://openairdocs.org/aircraft/N55290.md): Boeing A75N1(PT17) · S/N 75-4345 · Shannon Frances W
- [N5816Q](https://openairdocs.org/aircraft/N5816Q.md): Mooney M20C · S/N 3117 · Built 1965 · High Flying Vision LLC
- [N602PF](https://openairdocs.org/aircraft/N602PF.md): Air Tractor AT-602 · S/N 602-1191 · Built 2010 · Shannon Agricultural Flying Inc
- [N74GZ](https://openairdocs.org/aircraft/N74GZ.md): Cessna S550 · S/N S550-0074 · Built 1985 · 921be LLC
- [N8536W](https://openairdocs.org/aircraft/N8536W.md): Piper PA-28-235 · S/N 28-10037 · Built 1963 · Feather Inc
- [N93135](https://openairdocs.org/aircraft/N93135.md): Cessna 210L · S/N 21060278 · Built 1974 · Shannon Frances W
- [N9870R](https://openairdocs.org/aircraft/N9870R.md): Beech M35 · S/N D-6424 · Built 1960 · Howard Flying Service 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 = 'MS' AND g.registrant_city = 'CLARKSDALE'
ORDER BY g.n_number
```

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