OpenAirDocs.org
Rosharon, TX

Registered aircraft · 42

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

N119MHHarris Michael O RV-8 · S/N 81990Built 2010 · Glass Justin AN124SRSmith Richard L RV-4 · S/N 865Built 1987 · Carr Wiley RN1293ECessna 208B · S/N 208B0537Built 1996 · Desert Sand Aircraft Leasing Co IncN1500FBeech V35 · S/N D-8552Gerhold JeremyN15133Caputo Alfred A RV-6A · S/N 21800Built 1977 · Brooks Cary HN169BADehavilland DHC-6-100 · S/N 103Built 1967 · Desert Sand Aircraft Leasing Co IncN228YKDehavilland DHC-6-200 · S/N 228Built 1969 · Desert Sand Aircraft Leasing Co IncN22BAGrumman American Avn. AA-5A · S/N AA5A0238Built 1976 · Kovalchuk Richard WN337MBDehavilland DHC-6-100 · S/N 37Desert Sand Aircraft Leasing Co IncN3972PPiper PA-18-150 · S/N 18-4763Built 1956 · Sc Super Cub LLCN420DZCessna 208B · S/N 208B0909Built 2001 · Desert Sand Aircraft Leasing Co IncN421CKCessna 421B · S/N 421B0470Built 1973 · Karow Robert JN42JFFisher Jerald R PITTS S-1 · S/N 1Glass JustinN4351QCessna 172L · S/N 17260251Built 1971 · Johnson James BenjaminN469TSDehavilland DHC-6-200 · S/N 149Built 1968 · Desert Sand Aircraft Leasing Co IncN4843BCessna 152 · S/N 15283668Built 1979 · Maddox Emily BrownN4873EChampion 7FC · S/N 7FC-313Built 1959 · Rice Johnny DN5026NBellanca 8KCAB · S/N 570-79Built 1979 · Wright Bruce MN5069XChampion 7KCAB · S/N 152Built 1968 · Wright Bruce MN510CBCameron Balloons Z-90 · S/N 6752Mcdonel Cleatus KN53029Cessna 177RG · S/N 177RG1328Built 1978 · N53029 Cardinal LLCN5702QMooney M20C · S/N 3053Built 1965 · Bailey Jacob KyleN60393Infinity Power Parachutes INFINITY 2000 · S/N IPP4-225Built 2003 · Harger Kenneth GN6077KCessna 150M · S/N 15077513Built 1975 · Rocha Adrian MN63AZNadig Richard E RV-4R · S/N 1026Built 2008 · Arnold Vincent CraigN682ACCessna 208B · S/N 208B1027Built 2003 · Desert Sand Aircraft Leasing Co IncN689EBunker Mark A GLASAIR SH-2R · S/N 354Nafsinger Nicholas AN690MFDehavilland DHC-6-200 · S/N 121Built 1968 · Desert Sand Aircraft Leasing Co IncN6950KPiper PA-20 · S/N 20-55Built 1950 · Gerhold Jeremy RN6DJJordan Don R VANS RV-6A · S/N 24330Built 2002 · Rice Johnny DN737BKCessna 172N · S/N 17269289Built 1977 · Desert Sand Aircraft Leasing Co IncN7513NBeech 36 · S/N E-47Built 1968 · Aspiras Dionisio O JrN7581FCessna 208B · S/N 208B0389Built 1994 · Desert Sand Aircraft Leasing Co IncN7587Schweizer SGS 1-26D · S/N 477Built 1970 · Rice Johnny DN777DPPerry Donald L STARDUSTER TOO · S/N RP 006Built 1981 · Arnold Vincent CraigN801FLCessna 208B · S/N 208B-0809Built 2000 · Desert Sand Aircraft Leasing Co IncN8177NPiper PA-28-140 · S/N 28-25373Built 1968 · Aspiras Dionisio O JrN821CBBeech B100 · S/N BE-35Built 1977 · Ez Transportation IncN8964ABeech C35 · S/N D-2718Built 1951 · Rice Johnny DN8HCPiper PA-28-235 · S/N 28-10760Built 1966 · Rocha Adrian MN9133LBellanca 7ACA · S/N 36-72Built 1971 · Thompson Clark JN927RJBruce M Wright RV8A · S/N 82360Built 2013 · Wright Bruce M
Back to Rosharon, TX