Registered aircraft · 24

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

N1900ZMaule M-5-180C · S/N 8024CBuilt 1984 · Chavey Gary G N1988YMooney M20E · S/N 275Built 1964 · Reyst Derek C N2167CCessna 177B · S/N 17702743Built 1978 · Starkys Equipment Leasing LLC N292KMcree Cecil Allen RV 4 · S/N 1201Built 1988 · Rv4us LLC N29KKLancair LC-40-550FG · S/N 40071Built 2003 · 29kk LLC N3200WPiper PA-32-260 · S/N 32-04Built 1964 · Brickley Brian J N35UVPuckett Lewis A GLASAIR III · S/N 3146Ace-E LLC N401RRMorgan L Richard LANCAIR IV P · S/N LIV-486Built 2022 · Flying Ace LLC N4357NCessna 195 · S/N 7058Davis Charles H Jr N4410LCessna 172G · S/N 17254495Built 1966 · Lenhart James A N4453APiper PA-22-150 · S/N 22-3786Nau Evan D N4932KRyan NAVION · S/N NAV-4-1932Built 1949 · Davis Charles H Jr N51229Maule M-4-210C · S/N 1087CRossettie Thomas P N531LGCessna 172R · S/N 17280056Built 1997 · Mills Daniel L N56UTPdps Pzl-Bielsko SZD-56-1 DIANA · S/N 561197001Built 1998 · Wyman Jack S N60233Cessna 150J · S/N 15070161Built 1969 · C-150j LLC N6174LAmerican AA-1 · S/N AA1-0374Hanson Alan L N70419Piper J3C-65 · S/N 17412Built 1946 · N70419 LLC N7057North American AT-6G · S/N 49-3509Built 1951 · Mills Daniel L N767DNBoeing E75 · S/N 75-5533Registration pendingBuilt 1943 N81583Champion AERONCA 7AC · S/N 7AC-202Built 1945 · Harris Terry N829LSPiper PA-32R-301 · S/N 3213011Built 1988 · Starkys Equipment Leasing LLC N8497XCessna 172C · S/N 17248997Built 1961 · Connors James R N921WRRolladen-Schneider LS-1B · S/N L-26/69Built 1969 · Lorincz Steve G

Back to Manchester, MI