Registered aircraft · 31

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'GRANDVIEW' ORDER BY g.n_number

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

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 = 'GRANDVIEW'
ORDER BY g.n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N1413BBellanca 14-13-3 · S/N 1640Built 1949 · Simpson Bradley C N175DHCessna 175 · S/N 56280Built 1959 · Segerstrom Ricky G Trustee N17EMRobinson Helicopter R44 · S/N 1580Built 2006 · Segerstrom Ricky G Trustee N19MUCessna 177RG · S/N 177RG0099Garrett Jack H N201SBMooney M20J · S/N 24-1388Built 1983 · Patterson James L N222CXSchempp-Hirth VENTUS-2C · S/N 109Kalinsky Omri N26677Taylorcraft BL-65 · S/N 2019Built 1940 · Meinen Max W N300QLDJI AGRAS T40 · S/N 1581F574B238A00102Y9G2 Ag Services LLC N309YJim Wolcott GREAT LAKES 2T1 · S/N 003Wolcott Jim N31886Aeronca 65-CA · S/N C-11711Built 1944 · Wolcott James N N3837WBeech 58 · S/N TH-395Built 1973 · Wardlay Farms And Ranches Inc N410SMCirrus Design SR22T · S/N 1077Built 2015 · Martin Aviation LLC N417BKPowrachute AIRWOLF 912ULS · S/N A133ULSBuilt 2010 · Martin Stan N4284LBoeing PT-13D · S/N 42-17766Built 1942 · Morrison James J II N43730Taylorcraft BC12-D · S/N 7389Built 1946 · Wolcott Jim N N48136Cessna 170 · S/N 20120Morrison James J II N59170Aeronca 65-CA · S/N CA14451Built 1941 · Wolcott Jim N N610PBSimpson Bradley Collins AVID CATALINA · S/N 143ABBuilt 2006 · Simpson Bradley Collins N64388Dalton FLY BABY · S/N 001Built 1973 · Phillips H L N6720ECessna 175 · S/N 56220Segerstrom Ricky G N7027KPiper PA-20 · S/N 20-133Built 1950 · Morrison James II N7049RCessna TR182 · S/N R18200644Built 1978 · Segerstrom Ricky G Trustee N7943MBeech 35-C33 · S/N CD-1044Built 1966 · J&W Aircraft Inc N8261ZCessna 210-5(205) · S/N 2050261Built 1963 · Wardlay Farms And Ranches N835NFairchild KR-34C · S/N 430Built 1939 · Apogee Investments LLC N83838Aeronca 7AC · S/N 7AC-2519Built 1946 · Morrison James J II N8457DPiper PA-22-160 · S/N 22-5713Built 1957 · Morrison James N86729Bellanca 14-13-2 · S/N 1090Built 1946 · Wolcott Jim N86916Bellanca 14-13 · S/N 1278Built 1946 · Apogee Investments LLC N9241Scheibe L SPATZ III · S/N 824Apogee Investments LLC N9509DPiper PA-22-160 · S/N 22-6424Built 1958 · Morrison Jim

Back to Grandview, TX