OpenAirDocs.org
Carlsbad, NM

Registered aircraft · 35

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 = 'CARLSBAD'
  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.

N1087QMooney M20M · S/N 27-0049Built 1990 · Fairway Auto Clinic LLCN124GGMooney International M20V · S/N 33-0013Built 2019 · Gama Transport LLCN12926Cessna 172M · S/N 17262378Built 1973 · Norton Boe LN136CMBeech B36TC · S/N EA-437Triple C IncN1424UCessna 172M · S/N 17267091Built 1976 · Cavern City Flight School LLCN156SCSix Chuter LEGEND XL · S/N 3095Whitley RandyN17167Hughes 369A · S/N 491127Built 1969 · Slade Aviation LLCN236BHPiper PA-28-236 · S/N 28-7911023Built 1978 · Eagle Aero L L PN271DJPilatus PC-24 · S/N 162Built 2020 · D&Tc LLCN356KJAirbus Helicopters AS 350B3 · S/N 8833Built 2020 · B&R Trucking IncN369BGTextron T206H · S/N T20609636Built 2021 · Brantley GeorgeN37343Cessna 340A · S/N 340A0358Built 1977 · Bearings & Belts LLCN403BLDiamond Aircraft Ind DA 40 NG · S/N 40.NC054Built 2019 · Jb Flight Services LLCN425SRCessna 425 · S/N 425-0133Twin Wells Fuel LLCN441LPPardue Lawrence G RV-6 · S/N 60087Built 1999 · Pardue Lawrence GN446CCGulfstream Aerospace GVI (G650) · S/N 6238Built 2016 · D&Tc LLCN44HZSchempp-Hirth VENTUS-B · S/N 112Mcdowell Samuel AN550HCCessna S550 · S/N S550-0116Built 1986 · Vasquez JimmyN5857KBeech 95-B55 (T42A) · S/N TC-806N5857k LLCN657WMCessna 421C · S/N 421C0474Registration pendingN6754FCessna 150F · S/N 15063354Built 1966 · Currie Jeffrey LN69HTRobinson Helicopter R44 II · S/N 13894Triple Tango LLCN7077QRobinson Helicopter R66 · S/N 0652Built 2015 · Th Services LLCN721DDSchempp-Hirth Flugzeugbau DUO DISCUS · S/N 177Mcdowell SamuelN726AKAirbus Helicopters AS350B3 · S/N 8776Built 2019 · Triple Tango LLCN7647TCessna 172A · S/N 47247Holmen Roger AN79270Cessna 172K · S/N 17258013Built 1969 · Jb Flight Services LLCN826CERobinson Helicopter R66 · S/N 0668Built 2015 · Bmb Equipment Holding LLCN826CLRobinson Helicopter R44 II · S/N 13307Built 2012 · C S Flying Service LLCN8709UCessna 172F · S/N 17252613Built 1965 · Wilkinson James RichardN8767PPiper PA-24-260 · S/N 24-4217Built 1965 · Gen-One Aviation LLCN88HLCessna T182T · S/N T18208377Liberty Aero LLCN893DSDiamond Aircraft Ind DA 40 · S/N 40.743Built 2006 · Norton Boe L TrusteeN9288XCessna T206H · S/N T20609014Built 2011 · Ks&G Management IncN960RKCompagnie Daher TBM 700 · S/N 1549Built 2024 · Westall Garel
Back to Carlsbad, NM