OpenAirDocs.org
Van Alstyne, 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 = 'VAN ALSTYNE'
  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.

N109SCPiper L-18C · S/N 51-15307Built 1951 · Cobb Lee CN12719Beech UC-45J · S/N 51125Built 1944 · Tilghman Charles R JrN133DRPiper PA32-301XTC · S/N 3255027Built 2005 · 814ma IncN153PSPatrick E Smith CAVALON · S/N V00261Built 2016 · Smith Patrick EN1590KLuscombe 8A · S/N 4317Built 1946 · Antique Aircraft And Automobile LLCN170SLCessna 170 · S/N 18138Built 1948 · Simmons Kenton LN20VTaylorcraft BC12-D · S/N 7891Built 1946 · Hale Leland Wayne JrN23171Piper J4B · S/N 4-544Haass Amy BN2624YCessna 180E · S/N 18051124Built 1962 · Warner James RN26AWCessna 180 · S/N 32544Antique Aircraft And Automobile LLCN2894VCessna 150M · S/N 15076316Built 1974 · Cuthbertson Steven MN3496DCessna 170B · S/N 27039Built 1955 · Bengtson David MN34977Cessna 177B · S/N 17702129Built 1974 · Holtzman Gary EN3831NBeech 35 · S/N D-1068Built 1947 · Tilghman Charles R JrN444TRCessna 150H · S/N 15067661Built 1967 · 444 Tr IncN4725UCessna 180G · S/N 18051425Built 1964 · Antique Aircraft And Automobile LLCN48042Cessna 152 · S/N 15283273Built 1979 · Simmons Kenton LN5870MCessna 340 · S/N 3400058Built 1972 · Mcdonald Brian LN6019EBeech K35 · S/N D-5980Built 1959 · Cobb Lee CN60JSShewmaker CASSUTT III M · S/N JS-2Built 1970 · Tilghman Charles R JrN61765Cessna 172M · S/N 17264785Built 1975 · Dean Mark TN68QFellows PITTS S-1C · S/N OHB-1970Built 1971 · Cobb Lee CN711DRCessna 170A · S/N 19171Built 1949 · Antique Aircraft And Automobile LLCN8128XPiper PA-28-161 · S/N 28-8016153Built 1979 · Simmons Kenton LN9017QBeech V35B · S/N D-9171Built 1970 · Long Lynn IN9026DPiper PA-22-160 · S/N 22-6163Built 1958 · Cuthbertson Steven MN9071EMaule M-5-235C · S/N 7068CBuilt 1977 · Antique Aircraft And Automobile LLCN907AGPiper PA-22-150 · S/N 22-7218Antique Aircraft And Automobile LLCN9356LAmerican AA-1A · S/N AA1A-0170Callaway Jonathan LN9916YChampion 7FC · S/N 7FC-443Built 1961 · Bennett S Leon
Back to Van Alstyne, TX