# Registered aircraft: Artesia, NM

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

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

- [N1010L](https://openairdocs.org/aircraft/N1010L.md): Air Tractor AT-401 · S/N 401-0708 · Built 1989 · Devil Dusters Inc
- [N2175A](https://openairdocs.org/aircraft/N2175A.md): Piper PA-32RT-300T · S/N 32R-7987012 · Built 1979 · Crawford Garrett Ross
- [N236RC](https://openairdocs.org/aircraft/N236RC.md): Cessna R182 · S/N R18201963 · Built 1983 · Carter Rodney D
- [N24YP](https://openairdocs.org/aircraft/N24YP.md): Embraer EMB-550 · S/N 55000082 · Built 2019 · Yankee Papa Aircraft LLC
- [N2730M](https://openairdocs.org/aircraft/N2730M.md): Cessna 414A · S/N 414A0437 · Built 1980 · Sua LLC
- [N276BG](https://openairdocs.org/aircraft/N276BG.md): Learjet 60 · S/N 276 · Built 2004 · Blue Star Air LLC
- [N2930U](https://openairdocs.org/aircraft/N2930U.md): Cessna 172D · S/N 17250530 · Built 1963 · Weast Michael D
- [N2961](https://openairdocs.org/aircraft/N2961.md): Piper PA-18-150 · S/N 188967 · Built 1972 · Wilbanks Kevin W
- [N33JD](https://openairdocs.org/aircraft/N33JD.md): Piper PA-32-300 · S/N 32-7940159 · Built 1979 · Riggs Alan Vance
- [N35014](https://openairdocs.org/aircraft/N35014.md): Cessna T206H · S/N T20608303 · Built 2002 · Trionz LLC
- [N3592Y](https://openairdocs.org/aircraft/N3592Y.md): Cessna 182F · S/N 18254492 · Built 1962 · Archer Donald B
- [N3692C](https://openairdocs.org/aircraft/N3692C.md): Cessna 180 · S/N 31191 · Devil Dusters Inc
- [N371JM](https://openairdocs.org/aircraft/N371JM.md): Hawker Beechcraft G36 · S/N E-3843 · Built 2008 · Yates Industries LLC
- [N4040H](https://openairdocs.org/aircraft/N4040H.md): Piper PA-12 · S/N 12-3467 · Built 1947 · Devil Dusters Inc
- [N412TG](https://openairdocs.org/aircraft/N412TG.md): Piper PA-32-300 · S/N 32-40916 · Built 1970 · Thompson Larry N
- [N4555Y](https://openairdocs.org/aircraft/N4555Y.md): Air Tractor AT-402 · S/N 402-0812 · Built 1991 · Devil Dusters Inc
- [N48880](https://openairdocs.org/aircraft/N48880.md): Boeing A75N1(PT17) · S/N 75765 · Revoked, canceled · Pecos Valley Flying Svc Inc
- [N5036C](https://openairdocs.org/aircraft/N5036C.md): Beech B35 · S/N D-2298 · First renewal notice · Built 1950 · Pilot & Co Aviation LLC
- [N55LS](https://openairdocs.org/aircraft/N55LS.md): Flight Design CTSW · S/N 06-03-10 · Built 2006 · Moorhead Robert V
- [N5601P](https://openairdocs.org/aircraft/N5601P.md): Piper PA-24-250 · S/N 24-669 · Devil Dusters Inc
- [N562U](https://openairdocs.org/aircraft/N562U.md): Beech D55 · S/N TE-562 · Built 1968 · Sua LLC
- [N6036W](https://openairdocs.org/aircraft/N6036W.md): Piper PA-28-140 · S/N 28-20036 · Built 1964 · Edwards Darrell R
- [N6167B](https://openairdocs.org/aircraft/N6167B.md): Cessna 182A · S/N 34167 · Built 1957 · Edwards Darrell R
- [N63402](https://openairdocs.org/aircraft/N63402.md): Aerostar International RX 8 · S/N RX8-3120 · Built 1991 · Chavez David R
- [N6350C](https://openairdocs.org/aircraft/N6350C.md): Aerostar International RAVEN S57-A · S/N S57A-3124 · Fear Darrell E
- [N667CB](https://openairdocs.org/aircraft/N667CB.md): Air Tractor AT-502B · S/N 502B-0667 · Built 2003 · Devil Dusters Inc
- [N68MY](https://openairdocs.org/aircraft/N68MY.md): Cessna 560XL · S/N 560-5666 · Built 2006 · Redeemed Holdings II LLC
- [N7208E](https://openairdocs.org/aircraft/N7208E.md): Cessna 182B · S/N 52208 · Built 1959 · Crockett Donald R
- [N7296E](https://openairdocs.org/aircraft/N7296E.md): Cessna 182B · S/N 52296 · Built 1959 · Champion Richard B
- [N7308A](https://openairdocs.org/aircraft/N7308A.md): Air Tractor AT-400 · S/N 400-0624 · Built 1985 · Devil Dusters Inc
- [N7860H](https://openairdocs.org/aircraft/N7860H.md): Piper PA-12 · S/N 12-761 · Built 1946 · Crockett Donald Richard
- [N7864H](https://openairdocs.org/aircraft/N7864H.md): Piper PA-12 · S/N 12-767 · Devil Dusters Inc
- [N800KC](https://openairdocs.org/aircraft/N800KC.md): American Eurocopter AS350B3 · S/N 7519 · First renewal notice · Built 2013 · Flying Nut LLC
- [N821DL](https://openairdocs.org/aircraft/N821DL.md): Aircraft Builders One AEROCOMP 7SL · S/N 037SLX904 · Built 2004 · Crockett Donald Richard
- [N8466P](https://openairdocs.org/aircraft/N8466P.md): Piper PA-24-400 · S/N 26-41 · Built 1964 · Brindeiro Stephen M
- [N926LA](https://openairdocs.org/aircraft/N926LA.md): Air Tractor AT-402 · S/N 402-0911 · Built 1993 · Devil Dusters Inc
- [N9276W](https://openairdocs.org/aircraft/N9276W.md): Piper PA-28-235 · S/N 28-10950 · Built 1968 · Whitmire Matthew K
- [N9441T](https://openairdocs.org/aircraft/N9441T.md): Cessna 210 · S/N 57241 · Built 1960 · Devil Dusters Inc
- [N9459V](https://openairdocs.org/aircraft/N9459V.md): Raven Industries RALLY RX7 · S/N RX7-3185 · Fear Darrell E
- [N96FM](https://openairdocs.org/aircraft/N96FM.md): Piper PA46-500TP · S/N 4697094 · Built 2001 · Yates Industries LLC
- [N999YC](https://openairdocs.org/aircraft/N999YC.md): Textron 525B · S/N 525B0536 · Built 2018 · Yates Industries 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 = 'NM' AND g.registrant_city = 'ARTESIA'
ORDER BY g.n_number
```

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