Mankato, MN
Registered aircraft · 107
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 = 'MANKATO' 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 = 'MANKATO' 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.
N100MDCessna 340A · S/N 340A0535N105MMExtra Flugzeugbau EA 300/L · S/N 071N111LNAerospatiale AS350BA · S/N 1602N1148BMooney M20J · S/N 24-1204N116PCAmerican Champion 7GCBC · S/N 1320-2001N11RYMooney M20C · S/N 3173N138VTacheny James G JA30 SUPERSTOL · S/N JA346-01-14N147ACEavision EA-J150 · S/N JMZKJ150UAV602596296N1923HPiper PA-28-140 · S/N 28-7725168N2124JPiper PA-28-161 · S/N 28-7916201N2182QPiper PA-28-181 · S/N 28-7990297N2331NCessna 140 · S/N 12571N236TSDiamond Aircraft Ind DA 42 · S/N 42.AC022N2568TZaugg Larry VANS RV-6A · S/N 23779N258DHAntares US MA-33MR912 · S/N 8411N270CDDJI AGRAS T20P · S/N 1581F574B237W00100H3N2979VBeech 35 · S/N D-376N3141ACessna 170B · S/N 25785N3226NFessenden Alfred EXPERMENTAL RV-4 · S/N 243N32887Piper J5A · S/N 5-393N335MKPiper PA-28-181 · S/N 2881090N336BHCessna 336 · S/N 3360125N336MKPiper PA-28-181 · S/N 2881087N338MKPiper PA-28-181 · S/N 2881096N339MKPiper PA-28-181 · S/N 2881097N342MKPiper PA-28-181 · S/N 2881260N343MKPiper PA-28-181 · S/N 2881261N345MKPiper PA-28-181 · S/N 2881262N346MKPiper PA-28-181 · S/N 2881416N347MKPiper PA-28-181 · S/N 2881417N3480CCessna 170B · S/N 26523N348MKPiper PA-28-181 · S/N 2881418N349MKPiper PA-28-181 · S/N 2881419N35005Piper J4A · S/N 4-1382N350MKPiper PA-28-181 · S/N 2881439N350RZDJI AGRAS T30 · S/N 3U5BJ6R001002QN351MKPiper PA-28-181 · S/N 2881440N352MKPiper PA-28-181 · S/N 2881441N353MKPiper PA-28-181 · S/N 2881442N35458Piper J3F-65 · S/N 6363N354MKPiper PA-28-181 · S/N 2881501N355MKPiper PA-28-181 · S/N 2881502N356MKPiper PA-28-181 · S/N 2881503N357MKPiper PA-28-181 · S/N 2881523N358MKPiper PA-28-181 · S/N 2881524N361MKPiper PA-28-181 · S/N 2881588N362MKPiper PA-28-181 · S/N 2881589N363MKPiper PA-28-181 · S/N 2881653N364MKPiper PA-28-181 · S/N 2881654N365MKPiper PA-28-181 · S/N 2881688
Back to Mankato, MN