OpenAirDocs.org
Richmond, TX

Registered aircraft · 799

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

N101HYHylio HYL-150 · S/N 17906150377Hylio IncN1025MCessna 182P · S/N 18264211Built 1975 · Supina Robert PN103HHylio HYL-300 · S/N 17906130279Hylio IncN104MEStewart John VANS RV-10 · S/N 40108Built 2005 · Mathis Mark DN105HYHylio HYL-150 · S/N 17906150356Hylio IncN107HYHylio HYL-150 · S/N 17906110667Hylio IncN108HYHylio HYL-150 · S/N 17906110633Hylio IncN108NAHylio HYL-150 · S/N 17906150313Hylio IncN10JHHayden STARDUSTER II · S/N 001Built 1973 · Hayden Charles J JrN110DAHylio AG 230 · S/N 17906100378Sale reportedN110HYHylio HYL-150 · S/N 17906110669Hylio IncN11234Cessna 150L · S/N 15075269Built 1973 · Universal Airways IncN118DAHylio AG 230 · S/N 17906100384Sale reportedN123GRHylio HYL-300 · S/N 17906130244Hylio IncN123HYHylio HYL-150 · S/N 17906110622Hylio IncN127CMMoore Charles H RV-7 · S/N 70293Built 2006 · Moore Charles HN128HAHylio AG 230 · S/N 17906100220Hylio IncN1307AHylio AG 230 · S/N 17906100221Hylio IncN1396DCessna 170A · S/N 19972Built 1951 · Flying Dutchman Aviation LLCN13XMMandley W James CHRISTEN EAGLE II · S/N 0001Built 1980 · Mathis Mark DN142HYHylio HYL-150 · S/N 17906150390Hylio IncN1449HHylio AG-272 · S/N 17906070254Hylio IncN145PHHylio AG 230 · S/N 17906100224Hylio IncN1468HHylio AG 230 · S/N 17906100218Hylio IncN14791Hylio AG-130 · S/N 050003Hylio IncN147BHHylio AG 230 · S/N 17906100225Hylio IncN147WDBeech 58TC · S/N TK-102Built 1979 · Darroh Harold WN155HYHylio HYL-150 · S/N 17906150358Hylio IncN159PBLindstrand Balloons 90A · S/N 5333Built 2006 · Bryant Philip MN160MTJones Darwin L MUSTANG II · S/N 10160MRegistration pendingBuilt 2007N161HHylio HYL-300 · S/N 17906130284Hylio IncN167HYHylio HYL-300 · S/N 17906130237Hylio IncN17516Beech V35B · S/N D-9978Built 1977 · Gillis AlanN17702Beech F33A · S/N CE-701Built 1977 · Bosley Blake RN185GHCessna A185F · S/N 18504353Built 1981 · Halverson Gary MN1942HHylio AG 230 · S/N 17906100002Hylio IncN1944HHylio AG-216 · S/N 17906090001Hylio IncN195DFCessna 195 · S/N 7511Built 1950 · Dickey Eldon DewayneN196BHHylio AG-216 · S/N 17906090002Hylio IncN200SMMacinnis Stephen C VANS RV-6 · S/N 24557Built 2001 · Macinnis Stephen CN202LPPalmer Lester KR-2 · S/N 2Built 1994 · Osborn Ralph ON218FBBell OH-58A · S/N 71-20727Fort Bend County Sheriffs OfficeN219HYHylio HYL-150 · S/N 17906110621Hylio IncN221HYHylio HYL-150 · S/N 17906110678Hylio IncN223HYHylio HYL-150 · S/N 17906110618Hylio IncN224HYHylio HYL-150 · S/N 17906110665Hylio IncN2267YCessna 177 · S/N 17700067Built 1967 · Cole Gary LN226HCCostruzioni Aeronautiche Tecna P2008 · S/N 120Built 2016 · Safeway Aviation LLCN232HYHylio HYL-150 · S/N 17906110589Hylio IncN235HYHylio HYL-150 · S/N 17906110570Hylio Inc
Back to Richmond, TX