Duluth, MN
Registered aircraft · 585
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 = 'DULUTH' 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 = 'DULUTH' 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.
N101HBMarino M/Ettestad S HATZ BANTAM · S/N 001N105GCCirrus Design SR22T · S/N 11013N1072VCessna R172K · S/N R1722103N108PJCirrus Design SF50 · S/N 0808N10940Cessna 150L · S/N 15075152N109MPCirrus Design SR22 · S/N 11905N110WKCirrus Design SR20 · S/N 2115N1119DCessna 140A · S/N 15683N114ADavis John Ray RV-8 · S/N 83655N114CACirrus Design SR20 · S/N 11535N11532Cirrus Design SR22T · S/N 11532N116KGCirrus Design SR22T · S/N 11718N11770Cirrus Design SR20 · S/N 11770N11JMCirrus Design SR22T · S/N 11780N1210BCosta H/Costa C/Pike D RV8 · S/N 80208N122WPCirrus Design SR22T · S/N 11795N123BGCirrus Design SR22T · S/N 11744N125TGCirrus Design SR22T · S/N 11747N126CDCirrus Design SR20 · S/N 10672N127CPiper PA 46-350P · S/N 4636604N129CDCirrus Design SR22T · S/N 11408N12NDCirrus Design SR22T · S/N 11652N135JTCirrus Design SR22T · S/N 11496N136HHCirrus Design SR22 · S/N 4865N138LACirrus Design SR22T · S/N 11499N139CDCirrus Design SR22 · S/N 0820N13AUCirrus Design SR22 · S/N 11745N140CDCirrus Design SR20 · S/N 1023N141AEHawker Siddeley HS.125 SERIES 700A · S/N NA0306N141ALHawker Beechcraft HAWKER 900XP · S/N HA0055N141DBCirrus Design SF50 · S/N 0852N142AKCirrus Design SR22 · S/N 11885N143CDCirrus Design SR20 · S/N 11353N143SGCirrus Design SR22T · S/N 11514N146CDFK Leichtflugzeuge B&F FK-14B POLARIS · S/N 014-068N147PGCirrus Design SR20 · S/N 1918N14MSCirrus Design SR20 · S/N 11592N1517FCessna 185D · S/N 185-0854N1573FCessna 185D · S/N 185-0949N1573ZDavid J Smith BAKENG DEUCE · S/N 001N157JGCirrus Design SF50 · S/N 0855N159JPCirrus Design SR22T · S/N 11818N159PGCirrus Design SR20 · S/N 1943N15EUCirrus Design SR22T · S/N 11379N15GHCirrus Design SR22 · S/N 11388N15RTCirrus Design SRT · S/N 0001N15VSCirrus Design SR22T · S/N 11458N16298Cirrus Design SF50 · S/N 0837N1644MCessna A185E · S/N 18501847N167WPCirrus Design SR20 · S/N 11541
Back to Duluth, MN