Thompson, ND
Registered aircraft · 59
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 = 'THOMPSON' 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 = 'THOMPSON' 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.
N1482CPiper PA-22 · S/N 22-1205N1953NPiper PA-11 · S/N 11-820N2070CStinson 108-1 · S/N 108-1004N2235JCessna 150 · S/N 150-65435N22385Cessna 150H · S/N 15068248N2452RCessna 182G · S/N 182-55552N30384Cessna 150F · S/N 15064473N3053PPiper PA-11 · S/N 11-895N3132LBeech C24R · S/N MC563N3801PPiper PA-22-150 · S/N 22-3490N3976YCessna 210D · S/N 210-58476N40107Universal Stinson 108 · S/N 108-37N4046EAeronca 11BC · S/N 11BC135N4083XAero Commander 100-180 · S/N 5183N4175ZPiper PA-28-140 · S/N 28-22170N43832Ercoupe 415-C · S/N 178N44147Piper PA-25-150 · S/N 25-49N4538YPiper PA-25-235 · S/N 25-4184N4563ZPiper PA-22-108 · S/N 22-8070N46660Cessna 150G · S/N 15066075N4693YPiper PA-25-235 · S/N 25-4424N5161DCessna 182A · S/N 51261N5417BCessna 182 · S/N 33417N5680JCessna A188A · S/N 18800630N5692ACessna 172 · S/N 28292N5812ECessna 150 · S/N 17312N5912XBrantly B-2 · S/N 48N6095QPiper J3C-65 · S/N 19769N6239ECessna 172 · S/N 46339N6241WPiper PA-28-140 · S/N 28-20284N6264LAmerican AA-1B · S/N AA1B-0064N6421SCessna 150H · S/N 15067221N6504QAlon A2 · S/N A-104N6590ZPiper PA-25-235 · S/N 25-2144N6686ZPiper PA-18A 150 · S/N 18-6686N7221LPiper PA-25-235 · S/N 25-7405584N7238VIntermountain CALLAIR A-9 · S/N 1275N7259VAero Commander CALLAIR A-9B · S/N 1313N757YHCessna 152 · S/N 15280106N759LDCessna 182Q · S/N 18266071N7979XCessna 172B · S/N 17248479N8051CPiper PA-18-135 · S/N 183396N82067Piper PA-25-235 · S/N 25-2792N8560LPiper PA-25-235 · S/N 25-4981N8629LPiper PA-25-260 · S/N 25-5063N8768LPiper PA-25-235 · S/N 25-5463N88213Piper J3C-65 · S/N 15830N8856UCessna 172F · S/N 17252770N8864NPiper PA-28-140 · S/N 28-25725N9029WCessna 172B · S/N 17248036
Back to Thompson, ND