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

N109DArmstrong Ray Carl GLASAIR II S FT · S/N 2057Armstrong Ray C N14JDCessna 340 · S/N 340-0340Built 1974 · C340-340 LLC N174HSSavage Russell S VANS RV-7A · S/N 71983Built 2007 · Hartman Vaughn E N2094NCessna 140 · S/N 12330Built 1947 · O'Neill Mark B N37286Interstate S-1A · S/N 129Built 1941 · Brothers Mark R N4220NCessna 140 · S/N 13691Oneill Mark B N5125SPiper PA-28R-200 · S/N 28R-7135157Built 1971 · Slade Clark K N5222GCessna T182T · S/N T18208164Built 2002 · Hanger C16 LLC N5481CCessna 170A · S/N 19515Built 1950 · Oneill Mark B N555PBeech 95-C55 · S/N TE-164Built 1966 · Manson Howard William N62819Beech C24R · S/N MC-772Built 1982 · Flying Monkey LLC N699GTLindstrand Balloons 77A · S/N 5462Koppmann Gavin J N70GPAurand Paul F OSPREY GP4 · S/N 632Built 2021 · Aurand Paul F N7131ACessna 172 · S/N 29231Built 1956 · Oneill Mark B N7302NCessna 182P · S/N 18263088Built 1974 · Clark Frank C N9199LBellanca 7ACA · S/N 34-72O Neill Mark B N92NACessna 207 · S/N 207-00093Oneill Laurie A N9561LGrumman American Avn. AA-5 · S/N AA5-0661Built 1974 · Walter Terrance A N9590ACessna 170A · S/N 19151Built 1949 · Oneill Mark B N97466Stinson 108-2 · S/N 108-466Built 1946 · Alfonso Francisco J

Back to Pinckney, MI