Registered aircraft · 26

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 = 'MN' AND g.registrant_city = 'AUSTIN' 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 = 'MN' AND g.registrant_city = 'AUSTIN'
  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 = 'MN' AND g.registrant_city = 'AUSTIN'
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.

N120LSCostruzioni Aeronautiche Tecna P92 ECHO SUPER · S/N 985Built 2006 · Korfhage Jason M N1489UCessna 172M · S/N 17267156Built 1976 · Austin Aeroflight Inc N1615FCessna 172H · S/N 17255010Built 1966 · Wells Edmund B N16XSJones Craig M XENOS · S/N X0011Built 2006 · Jones Craig M N198HFIai GULFSTREAM G280 · S/N 2176Built 2019 · Hormel Foods Corporate Services LLC N199HFIai GULFSTREAM G280 · S/N 2051Built 2014 · Hormel Foods Corporate Services LLC N2433APiper PA-20-135 · S/N 20-929Ryther John W N3214UCessna 182F · S/N 18254614Built 1963 · Bibus Michael A N3527KMckay Jason B EAGLE · S/N 001Finke Jerome L N4052DBell OH-58C · S/N 69-16178Built 2001 · Grotz Clayton N40720Piper J5B · S/N 5-1152Built 1941 · Luthe Carl E N453SMDJI MINI 4 PRO · S/N 1581F6Z9A246RML39CT4Nguyen Huy S N5403LLeining Lyndon R 750 CRUZER · S/N LRL-03Leining Lyndon R N546FNDJI MINI 5 PRO · S/N 1581F9DEC25AR029NXUMNguyen Huy Si N554QAEavision EA-J150 · S/N JMZKJ150UAV602595195Stickle Agronomy LLC N66312Boeing E75 · S/N 75-5356Built 1944 · Ryther John William N68TKWoolley Robert H GLASAIR 1.FT · S/N 489Built 2010 · Grotz Clayton W N741MBWoolery Robert William RV7A · S/N 70041Built 2006 · Nelson Aircraft Sales LLC N750JJabiru USA Sport J230-SP · S/N 803Built 2012 · Carstens Michael A N7581SCessna 182Q · S/N 18265230Built 1976 · Foxaire LLC N7676BBellanca 14-19-2 · S/N 4027Built 1957 · Budahn Christopher W N8526ZPiper PA-20 · S/N 20-900Built 1952 · Ryther John W N8710PPiper PA-24-260 · S/N 24-4157Built 1965 · Nelson Aircraft Sales LLC N9093SPiper PA-28-181 · S/N 28-8690033Built 1985 · Ellis Derek J N94712Engineering & Research ERCOUPE 415-CD · S/N 4823Built 1947 · Schamberger Kenneth E N95866Taylorcraft BC12-D · S/N 8166Built 1946 · Yates Thomas O

Back to Austin, MN