Registered aircraft · 18

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 = 'EAST LANSING' 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 = 'EAST LANSING'
  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 = 'EAST LANSING'
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.

N1091CMooney M20A · S/N 1362Built 1959 · Reif James D N16403Cessna C-34 · S/N 322Jacob Jennifer B N164XAeromot AMT-200S · S/N 200164First renewal noticeBuilt 2005 · Stetson Jeffry W N1829VCessna 120 · S/N 14047Built 1947 · Jacob Mark K N191WEBeech E-55 · S/N TE-1059Built 1975 · Fs Mickey LLC N2304LBeech 23 · S/N M-125Built 1963 · Johnson Diversified LLC N2933FCessna 182J · S/N 18257033Built 1966 · Levinsohn Reuben D N393FPDJI MINI 4 PRO · S/N 1581F6Z9A24A1ML3P543Padgett Justin J N40189Beech RC-45J · S/N 51218Built 1943 · Jacob Mark K N4296TPiper PA-32-301T · S/N 32-8324009Built 1983 · D'Haem Christopher M N57090Mooney M20K · S/N 25-0786Built 1983 · Foley William J N7045HPiper J3C-65 · S/N 20296Built 1946 · Yurkon John E N712LFCirrus Design SR22T · S/N 2344Built 2021 · Mcplane LLC N7367ACessna 172 · S/N 29467Built 1956 · Matlock Dianne J N9161SBeech B19 · S/N MB-785Built 1975 · Carr Jack Willson N93WBCirrus Design SR22 · S/N 2772Built 2007 · Blue 182 LLC N945EBCessna 182S · S/N 18280137Built 1998 · Flying Z LLC N9TJBombardier BD-700-1A10 · S/N 9659Built 2014 · Execjet II LLC

Back to East Lansing, MI