Larimore, ND
Registered aircraft · 40
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 = 'ND' AND g.registrant_city = 'LARIMORE' 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 = 'ND' AND g.registrant_city = 'LARIMORE' 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.
N1362XBell 47G-3B-1 · S/N 6573N179NSBell OH-58C · S/N 70-15079N1851DGarlick Helicopters OH-58C · S/N 72-21080N1851WGarlick Helicopters OH-58C · S/N 71-20544N1857YCessna 172C · S/N 17249457N185HACessna A185F · S/N 185-03536N2148QCessna 177RG · S/N 177RG0548N30562Air Tractor AT-602 · S/N 602-1235N3358FBell 47G-2 · S/N 2497N3663XAero Commander S2R · S/N 1891RN4002QAyres S-2R · S/N 2477RN4340JRockwell International S-2R · S/N 5052RN4340KRockwell International S-2R · S/N 5080RN4384QCessna 172L · S/N 17260284N46524Cessna 180J · S/N 18052424N5023XRockwell International S-2R · S/N 5055RN502MCArro Falcon Exporters OH-58A · S/N 70-15618N58115Bell 47G-5A · S/N 25117N63155Cessna 150M · S/N 15077143N6593HPiper J3C-65 · S/N 19785N6689QGrumman Acft ENG Cor-Schweizer G-164B · S/N 205BN6750DBell 47G-2 · S/N 2241N6847DCessna 170B · S/N 25196N70178Grumman American Avn. G-164 · S/N 232BN7151KCessna R172K · S/N R1722048N7220QAyres S-2R · S/N 1630RN7234VIntermountain CALLAIR A-9 · S/N 1271N7502ASchweizer G-164B · S/N 797BN7888BBell 47G-2 · S/N 2024N8272HCallair A-9 · S/N 1145N844NSBell OH-58A · S/N 71-20844N8583VBellanca 8GCBC · S/N 145-75N858EMPiper J-3 · S/N 213CN8949RChampion 7GC · S/N 7GC-165N9116UBell OH-58 · S/N 71-20500N9157TBenson James E CH II · S/N CH2-0301-2058N92701Cessna A188B · S/N 18802070TN92HVHolthus James CHALLENGER II CLP WG · S/N CH21291CW0774N95426Piper PA-28-140 · S/N 28-25944N965MCBell OH-58A · S/N 71-20782
Back to Larimore, ND