Tioga, ND
Registered aircraft · 67
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 = 'TIOGA' 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 = 'TIOGA' 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.
N1020UCessna 170A · S/N 18783N1111APiper PA-18-125 · S/N 18-703N12EKBoeing A75 · S/N 75-199N139HAHiller UH-12E · S/N HA3039N1637SSnow 600-S2C · S/N 600-1186CN1683SSnow 600-S2C · S/N 600-1266CN1836GChampion 7ECA · S/N 595N1924KLuscombe 8E · S/N 4651N20484Cessna 172M · S/N 17261327N2166APiper PA-20-135 · S/N 20-892N233NCCirrus Design SR22 · S/N 3905N2415QCessna 182J · S/N 18257615N2763UCessna 172D · S/N 17250363N28801Hiller UH-12D · S/N 1218N3209NPiper J3C-65 · S/N 22401N3385NPiper J3C-65 · S/N 22585N3528LCessna 150F · S/N 15062328N3570CCessna 170B · S/N 26614N3857ZPiper PA-18-150 · S/N 18-7622N4142BAero Commander 520 · S/N 520-47N4300VPiper PA-28-236 · S/N 28-8311016N4479YPiper PA-25-235 · S/N 25-4108N47077Hiller UH-12D · S/N 947N4772YPiper PA-25-235 · S/N 25-4535N4897YPiper PA-25-235 · S/N 25-4704N50850Cessna 150J · S/N 15069596N51156Cessna 150J · S/N 15069801N5173UCessna 206 · S/N 206-0173N5199MTaylorcraft BC12-D · S/N 10499N5309ZPiper PA-22-108 · S/N 22-9012N5411TCessna 172E · S/N 17251311N5572HPiper PA-11 · S/N 11-964N59495Bell 206B · S/N 1373N5997RCessna 172G · S/N 17253666N6141ZPiper PA-25 · S/N 25-165N6151ZPiper PA-25 · S/N 25-177N6203ZPiper PA-25 · S/N 25-241N6268ZPiper PA-25 · S/N 25-333N63418Cessna 150M · S/N 15077299N6507ZPiper PA-25-235 · S/N 25-2032N6618ZPiper PA-25-235 · S/N 25-2187N6671JPiper PA-28-140 · S/N 28-24357N6749ZPiper PA-25-235 · S/N 25-2368N6794ZPiper PA-25-235 · S/N 25-2439N6813WPiper PA-28-140 · S/N 28-20949N6972JPiper PA-28-181 · S/N 28-7690445N7036ZPiper PA-25-235 · S/N 25-2798N7089XBeech T-34B · S/N 140883N7114XCessna 150A · S/N 15059214N7307ZPiper PA-25 · S/N 25-2755
Back to Tioga, ND