OpenAirDocs.org
Justin, TX

Registered aircraft · 74

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

N101NZNorth American AT-6D · S/N 41-34050Built 1944 · Swift StephenN108YKYakovlev YAK 52 · S/N 822114Built 1982 · Airhart Michael DN1212HFischer William R 1-FT · S/N 693Mcmeans Tommie DN124WRBeech 200 · S/N BB-664Built 1980 · H.A.I. Services IncN133HSGrover Ronald D RV8 · S/N 80133Built 2000 · Grover Ronald DN141MWBeech 35-C33 · S/N CD-1020Built 1966 · Simmons Robert JN152MFCessna 152 · S/N 15284867Built 1981 · Mja Flight LLCN15354Piper PA-28-180 · S/N 28-7305062Built 1972 · Stephen SwiftN1625YCessna 172C · S/N 17249325Built 1962 · Boyd Jeffrey JN16LRPure Flight S R O PHOENIX U15 · S/N 65/U15Built 2023 · Romero Martinez Del Sobral Luisa Del CarmenN1745DCessna 170A · S/N 20188Built 1951 · Stuczynski Jason SN180VAGrenier Raymond H VANS RV-4 · S/N 897Built 2002 · Smith Trevor AN1907BLuscombe 8A · S/N 6334Currie Mark HN1985RColin C Richardson JA35 SUPERSTOL STRET · S/N JA634-06-21Built 2024 · Richardson Colin CN211RPIndus T-211 THORPEDO · S/N 0902D0333Pattisapu RamN2652RCessna 182K · S/N 18258352Built 1967 · Devries Francis PN2666MPiper PA-12 · S/N 12-1109Built 1946 · Burt David R JrN27433Taylorcraft BL-65 · S/N 2075Built 1940 · Morgan Jeff PN2744Jeff P Morgan RV-4 · S/N 2883Built 2017 · Morgan Jeff PN275DHHoward Henry BEARHAWK · S/N 136B-265B/266B-1347Built 2019 · Howard HenryN2935KLuscombe 8A · S/N 5662Built 1947 · Mataro Craig HN300CDDawson S/Creed R SR-300 · S/N 001Built 1989 · Braymer Thomas LN31ELLuisa Del Carmen RM Del Sobral CCX-1865 · S/N CCX-1865-2023Built 2026 · Del Carmen Romero Martinez Del Sobral LuisaN32476Culver LCA · S/N 208Currie Mark HN3336SCessna 210J · S/N 21059136Built 1969 · Vancil ToddN36253Taylorcraft DC-65 · S/N 4025Built 1941 · Rooks Charles LeeN3625HEngineering & Research ERCOUPE 415-C · S/N 4250Currie Mark HN3744PPiper PA-22 · S/N 22-3464Built 1955 · Caplinger Jimmy CN37826Culver LCA · S/N 331Built 1941 · Currie Mark HN37955Piper J3C-65 · S/N 6729Built 1941 · Swift Stephen DN4076Mooney M-18C · S/N 263Morgan Jeff PN41710Culver LFA · S/N 423Currie Mark HN4228CCessna 414 · S/N 414-0528Built 1974 · Burhmann Joel DavidN4241DBeech G35 · S/N D-4461Built 1956 · Hilton Allen J A JrN4273QCessna 172L · S/N 17260173Built 1971 · Simmons Robert JN429RSSherwood Rhea SPORTSMAN GS-2 · S/N 7445Built 2016 · Sherwood RheaN43366Taylorcraft BC12-D · S/N 7025Morgan Jeff PN46550Cessna 172K · S/N 17257345Built 1968 · Taylor Timothy AN4659LCessna 172G · S/N 17254654Built 1966 · Talcorp IncN4708CNorth American AT-6F · S/N F48-1870Parcell Robert AN47371Aeronca 0-58B · S/N 058B9083Built 1943 · Currie Mark HN4784ACessna A152 · S/N A1520891Built 1979 · Fox Aviation International IncN5378WPiper PA-28-160 · S/N 28-443Built 1962 · Hargis Bookman LLCN53PHCessna A150L · S/N A1500352Haynes Jason AllenN5486VNorth American SNJ-5 · S/N 90620Amigos T6 LLCN5834CBeech C35 · S/N D-2786Built 1951 · Rainey Chris DN60085Boeing A75N1(PT17) · S/N 75-7481Built 1943 · Yellow Peril LLCN60309Boeing D75N1 · S/N 75-4006Built 1942 · Foster David StephenN60440Stinson L-5G · S/N 4010Built 1945 · Rooks Charles LeeN61ELCessna 182Q · S/N 18267058Built 1979 · Martinez Del Sobral Luisa Del Carmen Romero
Back to Justin, TX