Marshall, MN
Registered aircraft · 39
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 = 'MN' AND g.registrant_city = 'MARSHALL' 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 = 'MN' AND g.registrant_city = 'MARSHALL' 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.
N100QTBeech C90 · S/N LJ689N114KDGulfstream Aerospace GV-SP (G550) · S/N 5139N139SCBeech C90 · S/N LJ868N145SZEurocopter Deutschland MBB-BK 117 C-2 · S/N 9637N185MVBeech B200 · S/N BB-1034N2767MPiper PA-28-181 · S/N 28-7890266N284RLXag P150 MAX · S/N 1863F251822954835X4FN292AGDJI AGRAS T100 · S/N 1581F8ZLC258G002F6Z2N293AGDJI AGRAS T100 · S/N 1581F8ZLC258L002047TN294XDassault FALCON 7X · S/N 294N358VGulfstream Aerospace GVI (G650ER) · S/N 6161N362CRLeonardo AW109SP · S/N 22434N381CWCessna 650 · S/N 650-0111N411CEBell Helicopter Textron Canada 429 · S/N 57370N413CEBell Helicopter Textron Canada 429 · S/N 57376N431HCLeonardo AW109SP · S/N 22404N470MMRaytheon 1900D · S/N UE-394N483MAAirbus Helicopters Deutschland MBB-BK117 D-3 · S/N 21202N483WCAirbus Helicopters Deutschland MBB-BK117 D-3 · S/N 21132N483WMAirbus Helicopters Deutschland MBB-BK117 D-3 · S/N 21206N5003PPiper PA-24 · S/N 24-6N535XJBombardier BD-100-1A10 · S/N 20137N550CFCessna 550 · S/N 550-0669N550TYCessna 550 · S/N 5500344N557SPLearjet 45 · S/N 531N558SPLearjet 45 · S/N 551N6194JPiper PA-28-181 · S/N 28-7690368N620WEBeech C90 · S/N LJ-743N650PJCessna 650 · S/N 650-7059N6894GPiper AEROSTAR 600 · S/N 6009058161256N750TEBombardier BD-700-2A12 · S/N 70224N808RBBoeing PT-13D · S/N 75-5055N8347HEmigh TROJAN A-2 · S/N 50N850XSocata TBM 700 · S/N 629N912MTBombardier BD-700-1A11 · S/N 9699N92999Commonwealth 185 · S/N 1733N929PHSikorsky S-92A · S/N 920151N951PHSikorsky S-92A · S/N 920293N9904HCessna 182R · S/N 18268101
Back to Marshall, MN