Registered aircraft · 18

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

N1518RGrumman American Avn. AA-1B · S/N AA1B0658Built 1976 · Long Kevin R N2324EAeronca 7CCM · S/N 7AC5901Built 1946 · Brown Craig D N2586GChampion 7GCBC · S/N 7Jeppesen Thomas L N31601Piela John D PHANTOM X1 · S/N 001Perry James R N407XADJI AGRAS T50 · S/N 1581F6BUB23AG0014S99Aerial Ag Solutions LLC N5532CDJI AGRAS T100 · S/N 1581F82LC258K002L264Crooks Farms Inc N5687RCessna 172F · S/N 17253330Built 1965 · Esch Randall L N57DHHallada David M CORBEN BABY ACE · S/N 957Hallada David M N6826FCessna 150F · S/N 15063426Built 1966 · Jeppesen Thomas L N69731DJI AGRAS T100 · S/N 1581F8ZLC25B50022NFJCrooks Farms Inc N74682Grumman American Avn. AA-5B · S/N AA5B-0341Built 1976 · Tiger Garb LLC N797REngvall Ricky A MURPHY AC MFG-REBEL · S/N 468RBuilt 1999 · Hallada David M N83358Piper PA-18-150 · S/N 18-7609098Built 1976 · Minikey Jack DBA N836JFDJI AGRAS T100 · S/N 1581F8ZLC258L00267YRK&H Waldron Farms LLC N8672PPiper PA-24-260 · S/N 24-4120Built 1965 · Perry James R N9800DPiper PA-11 · S/N 11-261Built 1947 · Hallada David A N988MLMark Long VANS RV-7 · S/N 74961Long Mark Allen N988MSMaule MX-7-180 · S/N 11058CBuilt 1988 · Long Mark A

Back to Stanton, MI