Lowell, MI
Registered aircraft · 26
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 = 'LOWELL' 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 = 'LOWELL' 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.
N103DGSchulke Tom AVID MAGNUM · S/N 6MN1319QCessna 150L · S/N 15072619N142GVan Strien Greg RV6 · S/N 22278N161WBeech S35 · S/N D-7914N207ENWhitman Bruce R (M-1) MIDGET MUSTANG · S/N 06N23CSSmith STOLP SA-300 · S/N S-1N2727HErcoupe 415-CD · S/N 3352N2736EAeronca 7DC · S/N 7AC-6317N3565CCessna 170B · S/N 26609N443FPDJI AGRAS T100 · S/N 1581F8ZLC25AU0024J90N5027BBeech F35 · S/N D-4292N5159WPiper PA-28 · S/N 28-190N5193ACessna 172 · S/N 28193N61642Cessna 172M · S/N 17264696N616BBPiper PA-34-200T · S/N 34-7870288N66PMBellanca 8KCAB · S/N 500-79N6728MStinson 108-3 · S/N 108-4728N6780PPiper PA-24-250 · S/N 24-1911N6917ECessna 175A · S/N 56417Registration pendingN7259QCessna 172L · S/N 17260559N7884ECessna 150 · S/N 17684N79921Cessna 172K · S/N 17258249N809BLBeech A36 · S/N E-1890N81613Aeronca 7AC · S/N 7AC-234N937LRVan Strien Greg RANS S12XL · S/N 04000918N9901WPiper PA-28-140 · S/N 28-23421
Back to Lowell, MI