Registered aircraft · 19

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

N2165VCessna 140 · S/N 14394Built 1948 · Vonlinsowe John E N2407HErcoupe 415-C · S/N 3032Built 1946 · Kirby Brent L N249PGougeon Jan C RV 4 · S/N 715Von Linsowe Justin J N2821GPiper PA-32-300 · S/N 32-7940137Built 1979 · H&M Air LLC N2944EAeronca 7AC · S/N 7AC-6533Built 1946 · Geyer Mary A N44690Piper PA-28-151 · S/N 28-7515006Built 1974 · H&M Air LLC N4568RPiper PA-28-140 · S/N 28-21326Built 1965 · Chuss Edward J N5160JCessna 340 · S/N 340-0550Zemnickas William V N5338FPiper PA-28R-200 · S/N 28R-7635452Built 1976 · Parker Gary L N555RGDehavilland BEAVER DHC-2 MK.1 · S/N 723Built 1954 · Drpg Aviation LLC N6268QCessna 310Q · S/N 310Q0526Chuss Edward J N68WACessna 421 · S/N 421-0137Built 1968 · Chuss Edward J N715ABKremers Gary RV-7A · S/N 70715Built 2005 · Von Linsowe John E N734KACessna 172N · S/N 17268903Built 1977 · H&M Air LLC N81104Grumman American Avn. AA-5B · S/N AA5B0431Barber Bradly N8383VPiper PA-28-161 · S/N 28-8116224Built 1981 · H&M Air LLC N8648YPiper PA-30 · S/N 30-1791Built 1969 · Chuss Edward N979PMGeyer Patrick H RV-7 · S/N 74657Built 2024 · Geyer Patrick H N9JVVonlinsome John E DRIFTER · S/N 0014DBuilt 1984 · Vonlinsowe John E

Back to Metamora, MI