Gainesville, TX
Registered aircraft · 57
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 = 'TX' AND g.registrant_city = 'GAINESVILLE' 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 = 'TX' AND g.registrant_city = 'GAINESVILLE' 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.
N100SEMcnany STEPHENS AKRO · S/N RM-1N131FDAero Z BUECKER 131 · S/N 146N15785Davis D-1-W · S/N 801N162TTTimothy Terry CCX-2000 · S/N CCX-2000-0046N1663VCessna 140 · S/N 13835N170EECessna 170 · S/N 18063N1811EAeronca 7AC · S/N 7AC-5378N194TXCessna 0-1A · S/N 23139N2110SCessna 210L · S/N 21061074N22946Piper J3C-65 · S/N 2844N22RWCessna 172M · S/N 17267495N246KACessna 340A · S/N 340A1817N246TTTerry Timothy D RV-7 · S/N 70518N2478FCessna 180H · S/N 18051680N250DSSipp Richard L VANS RV-4 · S/N 250N333BDCessna 525A · S/N 525A0237N3355WPiper PA-32-260 · S/N 32-198N3660TAir Tractor AT-301 · S/N 301-0336N3878SCessna 172E · S/N 17251078N4045MPiper PA-12 · S/N 12-2928N410MJCessna 182M · S/N 18259784N4128EAeronca 11CC · S/N 11CC-37N4394JQuicksilver GT-400 · S/N GT 2801204N47UTMaule MT-7-235 · S/N 18102CN485PLICP SAVANNAH S · S/N 23-10-54-0981N515HECessna 210L · S/N 21061457N5184GCessna 182T · S/N 18281104N52TXSchad Thomas J CHARGER · S/N 001N558TXSchad Tom RV-8 · S/N 81353N5669VPiper PA-32R-300 · S/N 32R-7780356N57816Piper PA-36-300 · S/N 36-7660122N5967PPiper PA-24-250 · S/N 24-1060N6013FBeech 95-B55 (T42A) · S/N TC-888N63707Boeing B75N1 · S/N 75-6938N6413ECessna 172 · S/N 46513N7040RPiper PA-28-140 · S/N 28-21737N727CYMills Carey RV-7 · S/N 72701N7318SCessna 182P · S/N 18265110N7462JPiper PA-28R-180 · S/N 28R-30814N780NWWoods Phillip H RV-7A · S/N 73480N7822KCessna 180J · S/N 18052756N7929BCessna 172 · S/N 29729N809NHBeech A36 · S/N E-2818N8127LCessna 210L · S/N 21060614N825PJHorn John M KITFOX S7 SUPER SPOR · S/N KA16250335N8384MCessna A150K · S/N A1500084N8388RPiper PA-28-140 · S/N 28-22265N84798Aeronca 7AC · S/N 7AC-3508N89718Cessna 152 · S/N 15282839N91TCessna 140 · S/N 10244
Back to Gainesville, TX