Farmington Hills, MI

Registered aircraft · 30

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

Query with SQL
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 = 'FARMINGTON HILLS'
  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.

N150BBBombardier CL-600-2B16 · S/N 5470Built 2000 · Ms Hawker LLCN2027PCessna 182T · S/N 18281724Built 2005 · Hake Equipment Leasing LLCN21459Piper PA-32RT-300T · S/N 32R-7887212Built 1978 · N21459 LLCN2390SCessna 210L · S/N 21061266Built 1976 · Powerhawk Flyers LLCN266NHHodges Russell R SKYPPER EVO · S/N 001Built 2024 · Hodges Russell RN2707Bombardier BD-700-1A11 · S/N 9489Built 2012 · Corporate Lift LLCN27299Piper PA-31-350 · S/N 31-7752128Built 1977 · C M B Aviation LLCN350VMBeech B300 · S/N FL-41Built 1991 · Hawk Aviation II LLCN3988WPiper PA-32-260 · S/N 32-960Built 1967 · Grant Robert M TrusteeN4120KPiper PA-28-181 · S/N 2843225Built 1999 · Jansar Aviation LLCN454EELarue Paul E SONEX · S/N 1509Built 2017 · Larue Paul EN5058Cub Crafters CC11-100 · S/N CC11-00073Built 2008 · Bsa 12 LLCN52820Cessna 172P · S/N 17274616Morrison Wanda LN5342JPiper PA-28-181 · S/N 2843493Moore DurkN5443PPiper PA-24-250 · S/N 24-497Built 1958 · Sbroglia Gregory AN57DZLuis Gabriel Diaz Zabaleta COZY MARK IV · S/N 001Diazzabaleta Luis GabrielN5801CMooney M20J · S/N 24-1534Built 1985 · Fly-A-Way Leasing CorpN610AWBombardier BD-700-1A10 · S/N 9143Built 2004 · Ms Hawker LLCN63146Piper PA-32-300 · S/N 32-7440117Built 1974 · C M B Aviation LLCN6355Bell 47G · S/N 1670Built 1956 · Stewart Robert DN65DLBritish Aerospace BAE 125 SERIES 800A · S/N 258224Built 1993 · Chestnut Northern Partners LLCN7263MCessna 175 · S/N 55563Built 1958 · Golan Shachar YaacovN73686Cessna 172N · S/N 17267612Falcon Aviation IncN767AWMooney M20E · S/N 413Built 1964 · Tooth & Go Flyers LLCN8073GCessna 177RG · S/N 177RG0073Built 1971 · Baker Brenten EN8149EPiper PA-28-236 · S/N 28-8011085Built 1979 · Nalrah LLCN9255PPiper PA-24-260 · S/N 24-4754Built 1968 · Salvia MichaelN97046Cessna 182Q · S/N 18266952Falcon Aviation IncN9969VCessna 172M · S/N 17264587Built 1974 · Costa WilliamN996SRBombardier CL-600-2B16 · S/N 5597Built 2004 · Rhp Express III LLC
Back to Farmington Hills, MI