Lakeville, MN
Registered aircraft · 99
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 = 'LAKEVILLE' 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 = 'LAKEVILLE' 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.
N1026MCessna 172L · S/N 17259406N10359American Legend AL3 · S/N AL-359N104LSFlight Design CTLS · S/N 08-04-17N1099HAeronca 15AC · S/N 15AC-119N111KBeech N35 · S/N D6786N1179LPipistrel D O O ALPHA TRAINER · S/N 1179 AT 912 LSAN123KDCessna 501 · S/N 501-0195N13093Cessna 172M · S/N 17262488N1386SCessna 182P · S/N 18264947N146CTFlight Design CTSW · S/N 06-12-09N153AMCessna 177B · S/N 17702222N1583WBeech V35B · S/N D-9353N180ECCessna 180 · S/N 32268N180FJCessna 180K · S/N 18052900N195CKCessna 195A · S/N 7515N201ADMooney M20J · S/N 24-0359N203DPiper PA-28-181 · S/N 2881425N2215PPiper PA-23-150 · S/N 23-824N2219CCessna 180 · S/N 30519N2279TPiper PA-28R-200 · S/N 28R-7135181Registration pendingN230PADiamond Aircraft Ind DA 42 NG · S/N 42.N516N23DBCessna 172M · S/N 17264474N24DJRise Donald J JR LONG EZ · S/N 10000N24XTCirrus Design SR20 · S/N 1039N25333Luscombe 8A · S/N 1209N25JNS C Aerostar S A YAK-52 · S/N 833315N25XTCirrus Design SR20 · S/N 2779N271BColonial C-2 · S/N 129N28092Piper J3C-65 · S/N 4572N2992VBeech 35 · S/N D-390N30231Cessna 177 · S/N 17701136N3045VCessna 150M · S/N 15076367N30749Piper PA-28-181 · S/N 28-7990101N310JDCessna 310J · S/N 310J0177N3137CCessna 180 · S/N 30936N3293VGray David M COZY · S/N 80N340QBeech J35 · S/N D-5486N363CTCirrus Design SR22 · S/N 4232N40203Quicksilver GT-400 · S/N 1212N4020HQuicksilver MXL II · S/N 1115N40LCColtharp S L VARIEZE · S/N 1020N42184Cessna 182L · S/N 18258890N42632Textron 182T · S/N 18283184N427LPCessna 140A · S/N 15584N43929Glaser-Dirks Flugzeugbau DG-100 · S/N 81N4394QCessna 172L · S/N 17260294N440GCNorlander Robert M RV 6 · S/N 22805N450DJBoeing E75N1 · S/N 75-8665N461CDCirrus Design SR22 · S/N 1189N4669JPiper PA-28R-180 · S/N 28R-30569
Back to Lakeville, MN