Saline, MI
Registered aircraft · 32
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
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 = 'SALINE' 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 = 'SALINE' 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.
N1622AKelly Steven L GLASTAR · S/N 5574N17149Stinson SR-9C · S/N 5110N17GEWestphal Gordon W VANS RV6A · S/N GW-101N201RTMooney M20J · S/N 24-1109N21105Stinson SR-10C · S/N 5839-3N2504FChampion 7GCAA · S/N 38N2610CCessna 310 · S/N 35010N297XCessna 177 · S/N 17700397N312CBCameron Balloons O-77 · S/N 620N3744MDehavilland TIGER MOTH DH 82A · S/N 4592N394EWSocata TBM 700 · S/N 1031N396LCCrene Michael/Titan Acft T51 MUSTANG · S/N 044N4092RPiper PA-32-300 · S/N 32-40413N4202DLein Paul Kelly POBER PIXIE · S/N 321N4260JPiper PA-28-140 · S/N 28-22658N426ESCessna 172R · S/N 17280263N49292Cessna 152 · S/N 15283446N50AVPatriot PA-18R · S/N 2020-0201N5501FPiper PA-28-140 · S/N 28-24839N55VGBeech 95-B55 (T42A) · S/N TC-2165N60UMPiper PA-28-235 · S/N 28-11347N6556CBuckeye Powered Parachutes DREAM MACHINE · S/N 4888N71064Piper J3C-65 · S/N 18088N7396NCessna 182P · S/N 18263179N7680CBuckeye BREEZE · S/N 16462N7863TCessna 172A · S/N 47463N7VNVan Noord Jan LONG EZ · S/N 633N83KStinson SR-9E · S/N 5405N89MWCameron Balloons O-77 · S/N 316N9029YPiper PA-18-150 · S/N 18-8905N92CBCameron Balloons V-56 · S/N 306N989XLCarl E Kohn VELOCITY XL RG · S/N 3RX114
Back to Saline, MI