Registered aircraft · 16

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

N121LFFlight Design CTSW · S/N 07-06-22Built 2007 · Gibson James L N1840HDestiny Powered Parachute DESTINY 2000 · S/N 1B0065Sisson William H N198TBPiper PA-34-200T · S/N 348070032Built 1980 · Honore Breen Aviation LLC N222MJPiper PA-12 · S/N 12-1905Honore Breen Aviation LLC N325WVGrumman American Avn. AA-5 · S/N AA5-0393Built 1973 · Ephofen Jack O N34313Meyers OTW-145 · S/N 57Built 1941 · Heckman Theodore K N498MNNiemi Bruce J MURPHY RENEGADE SPIR · S/N 0389Built 2014 · Niemi Bruce J N5105ZPiper PA-22-108 · S/N 22-8741Built 1961 · Krumm Melvin L N523AAustin Donald T GP-4 · S/N 001Austin Donald T N5293JCessna 414A · S/N 414A0857Built 1982 · Westsand Aviation LLC N6815ACessna 172 · S/N 28915Built 1956 · N6815a LLC N7192URobinson Helicopter R44 · S/N 0875Built 2000 · Red Hawk Aviation LLC N8935KStinson 108-1 · S/N 108-1935Built 1947 · Heckman Amy Sue N89463Cessna 140 · S/N 8495Built 1946 · Honore Enterprise LLC N92777Cessna 172M · S/N 17261616Built 1973 · Macatawa Flyers Inc N9969CCessna R182 · S/N R18200494Built 1978 · Attitude Indicators LLC

Back to Allegan, MI