Registered aircraft · 20

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 = 'THREE RIVERS' 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 = 'THREE RIVERS'
  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 = 'THREE RIVERS'
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.

N10540Terry Lee Brokaw BERKUT · S/N 020Brokaw Terry L N1417HAeronca 15AC · S/N 15AC-475Built 1949 · Hoag Michael R N1430QCessna 150L · S/N 15072730Built 1971 · Gearhart Robert H N1917BLuscombe 8F · S/N 6344Craig Gearhart N209ACessna 140 · S/N 14662Built 1948 · Lawson Dustin M N2384QBeech 23 · S/N M-464Tailwind Ventures LLC N32711Piper PA-28-140 · S/N 28-7525102Built 1974 · Three Rivers Aero LLC N3700CDJI AGRAS T40 · S/N 1581F574B238900100Q4Carpenter Tyler A N37PABeech 95-B55 (T42A) · S/N TC-1267Three Rivers Aero LLC N3935EAeronca 11BC · S/N 11BC-17Built 1947 · Hoag Michael R N48853Aeronca 0-58B · S/N 0-58B1842Hoag Michael R N503WACessna 172M · S/N 17265025Built 1975 · Three Rivers Aero Inc N5114YAeronca 15AC · S/N 15AC-326Built 1950 · Hoag Michael R N5989ACessna 172 · S/N 28589Built 1956 · Brokaw Terry L N6533YDestiny Powered Parachutes DESTINY XLT · S/N 1B0158Built 2001 · Rouch Joel D N734XDCessna 172N · S/N 17269189Built 1977 · Byrne David N8168UCessna 150M · S/N 15077905Sale reportedBuilt 1976 N8394CPiper PA-28-181 · S/N 28-7690132Built 1976 · Three Rivers Aero LLC N8481UCessna 172F · S/N 17252381Built 1964 · Three Rivers Aero LLC N911GGGearhart J/Gearhart C GA-1 · S/N 01Built 2001 · Gearhart Joe L

Back to Three Rivers, MI