OpenAirDocs.org
Marfa, 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 = 'MARFA'
  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.

N113JTBeech A36 · S/N E-1729Built 1980 · Aerotransplant IncN119APAlexander Schleicher ASH 31 MI · S/N 31031Built 2011 · Parker Stephen HN170MBeech V35 · S/N D-8317Built 1966 · Williams John R JrN1715Schleicher AS-K13 · S/N 13026Built 1967 · Burt Compton Enterprises IncN185PWCessna A185F · S/N 18504239Built 1981 · Sky Bear LLCN1940MScheibe BERGFALKE II-55 · S/N 240Built 1957 · Burt Compton Enterprises IncN2087GCessna 182A · S/N 51387Built 1958 · Tate Frederic H S DBAN246AFMadden Maurice AVID FLYER · S/N 246Built 1988 · Dotter David DN253JBArlington SISU 1A · S/N 110Built 1965 · Parker Stephen HN2645KCessna 180K · S/N 18053024Built 1978 · Fowlkes John M TrusteeN2659QCessna 182K · S/N 18257859Built 1966 · Morrison Mark CN32KAAviat A-1B · S/N 2193Built 2002 · Fowlkes Preston LN411KWCessna T206H · S/N T20609034Built 2011 · Escondido Aviation LLCN4173CSchempp-Hirth CIRRUS · S/N 33Built 1968 · Compton Francis BN4223MPiper PA-12 · S/N 12-3119Built 1947 · Mccrory John DN42LMTripe Michael D GLASCAT I · S/N 001Built 2011 · Morrison Mark CN432APAviat A-1C-200 · S/N 3432Built 2024 · Sky Bear LLCN4529XRobinson Helicopter R44 II · S/N 12753Ryan Flatt Cattle CoN4650XCessna 150G · S/N 15064700Built 1966 · Burt Compton Enterprises IncN4881DCessna 182A · S/N 34981Built 1958 · Burt Compton Enterprises IncN5234Bradford Max L XENOS · S/N X0024Built 2007 · Cone John MN5600ECessna 150 · S/N 17100Built 1958 · Compton Francis B JrN59181Cessna 182B · S/N 52085Built 1959 · Meader Luke CN595LHWyck Livingston MTOSPORT · S/N M02050Wycks LLCN6614GCessna 150L · S/N 15072114Donaldson Charles RN7172KPiper PA-18 · S/N 18-396Built 1950 · Meader Derek SN75SGPiper PA-32R-301T · S/N 3257175Built 2000 · W E Love RanchN8124SPiper PA-28-236 · S/N 28-8011040Built 1979 · Bauso KennethN9135RCessna Ector 305A · S/N 22-398Built 1951 · Sky Bear LLCN9404ACessna 140A · S/N 15225Built 1949 · Morrison Mark C
Back to Marfa, TX