OpenAirDocs.org
Santa Fe, TX

Registered aircraft · 30

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 = 'TX' AND g.registrant_city = 'SANTA FE'
  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.

N1103VHughes Helicopters HUGHES 369D · S/N 1000823DGulf Helicopters LLCN114WHBell Helicopter Textron Canada 407 · S/N 53501Built 2001 · Westwind Helicopters IncN125WHBell 407 · S/N 53411Built 2000 · Westwind Helicopters IncN131WMBell 206-L4 · S/N 52311Built 2005 · Westwind Helicopters IncN1460JRockwell International 112A · S/N 460Built 1976 · Moore Ronnie GN147TBBellanca 17-30A · S/N 85-30994Built 1985 · Sullivan David LN171WHBell 407 · S/N 53149Built 1997 · Westwind Helicopters IncN17396Cessna 305A · S/N 22135Built 1951 · Eckel Kenneth P JrN20WHBell 407 · S/N 53377Built 1999 · Gulf Helicopters LLCN2297EBell 206B · S/N 3656Built 1982 · Westwind Helicopters IncN2823BBell 47G-2 · S/N 1471Built 1956 · Gulf Helicopters LLCN31159Piper J3C-65 · S/N 5375Built 1940 · Eckel Kenneth P JrN34BMBell 407 · S/N 53310Built 1998 · Gulf Helicopters LLCN35LBell 407 · S/N 53402Built 2000 · Westwind Helicopters IncN478XSikorsky S-76C · S/N 760493Westwind Helicopters IncN49DDVans RV-12 · S/N 120566Built 2013 · Rose Kagen NN500TZHughes Helicopters HUGHES 369D · S/N 590507DBuilt 1979 · Gulf Helicopters LLCN511MSMooney M20J · S/N 24-3262Built 1992 · Barrow JustinN530RLMcdonnell Douglas Heli 369FF · S/N 0602FFGulf Helicopters LLCN64WHBell Helicopter Textron Canada 407 · S/N 53659Built 2005 · Westwind Helicopters IncN702SDCessna R182 · S/N R18200293Vaughn Gregory TN7266KSikorsky S-76A · S/N 760283Built 1985 · Gulf Helicopters LLCN738HHCessna 172N · S/N 17269986Built 1977 · Pitre David EN73SFBell Helicopter Textron Canada 407 · S/N 53839Built 2008 · Westwind Helicopters IncN757XDCessna TR182 · S/N R18201272Built 1979 · South Texas War Birds LLCN82MMBell Helicopter Textron Canada 407 · S/N 53058Built 1996 · Westwind Helicopters IncN8612FHughes Helicopters HUGHES 369D · S/N 570142DBuilt 1977 · Gulf Helicopters LLCN904CMBell 230 · S/N 23013Built 1993 · Republic Helicopters IncN91WHBell 407 · S/N 53300Built 1998 · Gulf Helicopters LLCN9619LGrumman American Avn. AA-1B · S/N AA1B-0119Built 1943 · Peace Robert L II
Back to Santa Fe, TX