OpenAirDocs.org
Mission, TX

Registered aircraft · 32

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

N101DBBowen Dudley H JR SKYBOLT A E · S/N 101DBGildardo F BravoN1234ZBeech N35 · S/N D-6695Built 1961 · Page Donald Lee Co TrusteeN153KDDehavilland DHC-6-200 · S/N 153Built 1968 · Mec International Trading LLCN190KMDehavilland DHC-6 TWIN OTTER · S/N 190Built 1968 · Mec International Trading LLCN215CPCirrus Design SR20 · S/N 1741Built 2006 · Mcallen Enterprises LLCN2191FCessna U206 · S/N U206-0391Built 1965 · Ohlinger Michael BN2371HCessna T206H · S/N T20608060Built 1999 · San Jose Aviation LLCN2416BPiper PA-38-112 · S/N 38-79A0052South Texas Air Force LLCN2468NPiper PA-38-112 · S/N 38-79A0858Built 1979 · South Texas Air Force LLCN247GNBeech 95-B55 (T42A) · S/N TC-1119Built 1968 · Tommy Hanka Farms LLCN25959Piper PA-38-112 · S/N 38-81A0087South Texas Air Force LLCN30195Cessna 177 · S/N 17701113Built 1968 · Palmer Peter LN39873Bellanca 17-31ATC · S/N 73-31054Built 1973 · Iverson Jason SN41471BRM Aero S R O BRISTELL LSA · S/N 872/2026Built 2026 · South Texas Air Force LLCN41991Air Tractor AT-502B · S/N 502B-2623Built 2008 · Bravo Gildardo FN420CPCirrus Design SR20 · S/N 1060Perez Jorge AN421CPCessna 421C · S/N 421C0810Bravo Gildardo FN449JSBeech F90 · S/N LA100Built 1980 · Thomas Hanka Aviation LLCN5585FPiper PA-28-140 · S/N 28-24918Built 1968 · South Texas Air Force LLCN605DKAir Tractor AT-502A · S/N 502A-2733Built 2011 · Bravo Gildardo FN6099UAir Tractor AT-401B · S/N 401B-0975Barajas SamuelN65616Cessna T206H · S/N T20608468B&M Aircraft LLCN7189FCessna 150F · S/N 15063789Built 1966 · Tello RicardoN7259ECessna 182B · S/N 52259Built 1959 · Wiley Jerry LynnN726GAGrumman American Avn. GA-7 · S/N GA7-0025Built 1978 · South Texas Air Force LLCN7471RPiper PA-28-140 · S/N 28-22019Built 1966 · Balderas Jose Aaron JrN7845GCessna 172L · S/N 17259545Built 1970 · Solorio IncN8061FCessna 150F · S/N 15064161Built 1966 · Morales JoseN8413RPiper PA-28-140 · S/N 28-22290Built 1966 · Zuniga Hector JavierN8658SCessna 150F · S/N 15061958Built 1965 · Bird Jared NN9159AAir Tractor AT-401 · S/N 401-0900Barajas SamuelN9241BCessna T182T · S/N T18209008Built 2010 · Border Warehouse Inc
Back to Mission, TX