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

N110RMLadue Russel Lee PITTS S-1 · S/N HL-11Built 1980 · Coleman Charles T N1884XCessna 182H · S/N 18255984Built 1965 · Kaines John L N24291Fowler Alan F RANS S-19 · S/N 100800039Built 2010 · Spencer Elmer C N2883WBeech A60 · S/N P-238Built 1973 · Austin Richard K N2920UCessna 172D · S/N 17250520Built 1963 · Otto Mark A N314YPitts SPECIAL · S/N 69Built 1975 · Olson Allen J N322FADJI AGRAS T50 · S/N 1581F6BUB235900101GUKnudsen Paul A N340PFCessna 340A · S/N 340A0225Built 1977 · Sharon Leasing Co N3941EAeronca 11BC · S/N 11BC-22Built 1947 · Sadler George C N42LEOstergren Leland LONG EZ · S/N 1024Built 1991 · Mason County Aero Club N49WXCessna 150H · S/N 15068744Built 1968 · Mason County Aero Club N51413Cessna 172S · S/N 172S9042Built 2002 · Mcpike William C N58884Cessna 182P · S/N 18262373Built 1973 · Snider Aaron A N596DKShoup Douglas RV4 · S/N 3651Built 2000 · Shoup Douglas L N642LEOstergren Leland J GLASAIR FT SUPER IIS · S/N 2285Built 2016 · Mason County Aero Club N665SWCessna P210N · S/N P21000588Built 1980 · American Classic Corp N6925NMooney M-20G · S/N 680144Built 1968 · Follrath Rick C N7195FCessna 150F · S/N 15063795Built 1966 · Austin Richard K N73383Cessna 172M · S/N 17267416Built 1976 · Ludington Rental LLC N74084Bell 47G-2 · S/N NH963Built 1962 · Boger Roger N7564ECessna 172N · S/N 17272110Tama Aviation LLC N8686SCessna 150F · S/N 15061986Built 1965 · Kaines John L N9824AGlenn Giordano REV X · S/N X1054Built 2025 · Giordano Glenn R N994CHHagerman Charles J TITAN TORNADO · S/N T93277SOHK0069Barbrick John L

Back to Ludington, MI