OpenAirDocs.org
Artesia, NM

Registered aircraft · 41

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

Query with SQL
duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N1010LAir Tractor AT-401 · S/N 401-0708Built 1989 · Devil Dusters IncN2175APiper PA-32RT-300T · S/N 32R-7987012Built 1979 · Crawford Garrett RossN236RCCessna R182 · S/N R18201963Built 1983 · Carter Rodney DN24YPEmbraer EMB-550 · S/N 55000082Built 2019 · Yankee Papa Aircraft LLCN2730MCessna 414A · S/N 414A0437Built 1980 · Sua LLCN276BGLearjet 60 · S/N 276Built 2004 · Blue Star Air LLCN2930UCessna 172D · S/N 17250530Built 1963 · Weast Michael DN2961Piper PA-18-150 · S/N 188967Built 1972 · Wilbanks Kevin WN33JDPiper PA-32-300 · S/N 32-7940159Built 1979 · Riggs Alan VanceN35014Cessna T206H · S/N T20608303Built 2002 · Trionz LLCN3592YCessna 182F · S/N 18254492Built 1962 · Archer Donald BN3692CCessna 180 · S/N 31191Devil Dusters IncN371JMHawker Beechcraft G36 · S/N E-3843Built 2008 · Yates Industries LLCN4040HPiper PA-12 · S/N 12-3467Built 1947 · Devil Dusters IncN412TGPiper PA-32-300 · S/N 32-40916Built 1970 · Thompson Larry NN4555YAir Tractor AT-402 · S/N 402-0812Built 1991 · Devil Dusters IncN48880Boeing A75N1(PT17) · S/N 75765Revoked, canceledPecos Valley Flying Svc IncN5036CBeech B35 · S/N D-2298First renewal noticeBuilt 1950 · Pilot & Co Aviation LLCN55LSFlight Design CTSW · S/N 06-03-10Built 2006 · Moorhead Robert VN5601PPiper PA-24-250 · S/N 24-669Devil Dusters IncN562UBeech D55 · S/N TE-562Built 1968 · Sua LLCN6036WPiper PA-28-140 · S/N 28-20036Built 1964 · Edwards Darrell RN6167BCessna 182A · S/N 34167Built 1957 · Edwards Darrell RN63402Aerostar International RX 8 · S/N RX8-3120Built 1991 · Chavez David RN6350CAerostar International RAVEN S57-A · S/N S57A-3124Fear Darrell EN667CBAir Tractor AT-502B · S/N 502B-0667Built 2003 · Devil Dusters IncN68MYCessna 560XL · S/N 560-5666Built 2006 · Redeemed Holdings II LLCN7208ECessna 182B · S/N 52208Built 1959 · Crockett Donald RN7296ECessna 182B · S/N 52296Built 1959 · Champion Richard BN7308AAir Tractor AT-400 · S/N 400-0624Built 1985 · Devil Dusters IncN7860HPiper PA-12 · S/N 12-761Built 1946 · Crockett Donald RichardN7864HPiper PA-12 · S/N 12-767Devil Dusters IncN800KCAmerican Eurocopter AS350B3 · S/N 7519First renewal noticeBuilt 2013 · Flying Nut LLCN821DLAircraft Builders One AEROCOMP 7SL · S/N 037SLX904Built 2004 · Crockett Donald RichardN8466PPiper PA-24-400 · S/N 26-41Built 1964 · Brindeiro Stephen MN926LAAir Tractor AT-402 · S/N 402-0911Built 1993 · Devil Dusters IncN9276WPiper PA-28-235 · S/N 28-10950Built 1968 · Whitmire Matthew KN9441TCessna 210 · S/N 57241Built 1960 · Devil Dusters IncN9459VRaven Industries RALLY RX7 · S/N RX7-3185Fear Darrell EN96FMPiper PA46-500TP · S/N 4697094Built 2001 · Yates Industries LLCN999YCTextron 525B · S/N 525B0536Built 2018 · Yates Industries LLC
Back to Artesia, NM