Registered aircraft · 21

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

N130AWAircraft Mfg & Development CH601XL SLSA · S/N 601-045SBuilt 2007 · Mitchell Brent U N1985SHead Balloons AX8-88 · S/N 111Built 1985 · Johnson Allen H N2307APiper PA-22-135 · S/N 22-696Built 1952 · Ferry Donald A N2QPCessna T337G · S/N P3370291Built 1977 · Noess Michael A N3586MPiper PA-12 · S/N 12-2509Built 1947 · Koskovich Thomas D N36153Taylorcraft BC-65 · S/N 3132Built 1941 · Regnier Donald P N3770FCessna 172H · S/N 17255265Built 1966 · Schoenberger Lance N381WHHylio HYL-150 · S/N 17906110225O'Loughlin Timothy R N382LHHylio HYL-150 · S/N 17906110224Oloughlin Timothy R N407VF Cubed RV-7A · S/N 70406Built 2005 · F Cubed LLC N4266HBurt Walter Ackerman BURT DESIGNING · S/N 1939Ackerman Burt Walter N4280FPiper PA-28-181 · S/N 28-7790009Built 1976 · Rt Flyers LLC N50569Taylorcraft DCO-65 · S/N 4546Built 1942 · Rodberg Craig N507HCCondor CONDOR S SPORT · S/N A181Pokorny Daniel B N560MNMinnesota Valley Balloons MVB-56 · S/N 001Built 2002 · Sinnen Stephen J N66231Cessna 150M · S/N 15075937Built 1974 · Taylor Daniel L N68421Boeing A75N1(PT17) · S/N 75-7441Built 1943 · Ferry Donald A N698PInfinity Power Parachute INFINITY 2002 · S/N IPP2-035Built 2007 · Jopp Mike J N733CStinson 108-3 · S/N 108-3733Built 1947 · Marshall Merle F N7929HPiper PA-12 · S/N 12-826Burt W Ackerman N9691HBoeing B75N1 · S/N 75-1100Built 1941 · Ferry Donald A

Back to Shakopee, MN