Registered aircraft · 22

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 = 'MI' AND g.registrant_city = 'ROCHESTER' 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 = 'MI' AND g.registrant_city = 'ROCHESTER'
  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 = 'MI' AND g.registrant_city = 'ROCHESTER'
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.

N100PHPaul Heasman SLING TSI · S/N 257SKBuilt 2023 · Heasman Paul N143RHJostock Michael E ZODIAC CH 601 · S/N 51151Built 1999 · Jostock Michael E N14SVNord STAMPE SV4C · S/N 537Built 1947 · Baron Robert David N20777Cessna 182P · S/N 18261195Marthew Aviation LLC N2158ZPiper PA-28-181 · S/N 28-7990403Built 1979 · Tribute Aero LLC N2811AMooney M20R · S/N 29-0503Built 2008 · Adrien Aviation LLC N363WTCirrus Design SR22T · S/N 9290Built 2023 · J S Aviation LLC N3904BBrown Raymond AIR COMMAND · S/N 01Built 2009 · Smith Scott W N3970JJeason Martin W QUICKSILVER MX II · S/N 1364Built 1983 · Jeason Martin W N40768Piper PA-28R-200 · S/N 28R-7435122Built 1973 · Trescone Dennis M N4214MRobinson Helicopter R44 · S/N 2008Built 2009 · Lawler Helicopter Leasing LLC N44076Piper PA-28-151 · S/N 28-7415576Built 1974 · Robinson Richard N5372VCessna 172RG · S/N 172RG0516Built 1980 · Cooper'S Hawk Aviation LLC N551CGVans RV-12 · S/N 120020Built 2010 · Whp Holdings LLC N6055ZCessna 162 · S/N 16200202Built 2012 · Fackler Ken N698TCCessna 525A · S/N 525A0051Built 2001 · Ava Aviation LLC N772MBeech A36TC · S/N EA-14Built 1979 · Cayle Jonathan N774CGHolt Timothy C RV-10 · S/N 40635Built 2012 · Holt Timothy C N79UWRaven S55A · S/N S55A-519Built 1979 · Brittingham Carl H N8124VCessna R172K · S/N R1722316Built 1977 · Farhat Jamal M N8413TPiper PA-34-220T · S/N 34-8133170Built 1981 · Dmh Aviation LLC N9760CPiper PA-28-161 · S/N 28-7816526Built 1978 · Street Steven J

Back to Rochester, MI