Nacogdoches, TX
Registered aircraft · 79
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 = 'NACOGDOCHES' 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 = 'NACOGDOCHES' 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.
N1069VCessna R172K · S/N R1722100N10846Cessna 150L · S/N 15075083N129PSDJI MAVIC AIR · S/N 1596A34A940F40FN1510HHelton LARK 95 · S/N 9510N151JGGale Haskins T-51 · S/N M08HV6SOHK0134N1634BLuscombe 11A · S/N 11-140N1771NCessna 120 · S/N 12015N17VBCessna 525 · S/N 525-0206N1974FCessna 172N · S/N 17273062N21675Piper J3C-65 · S/N 2462-RN22879Cessna 150H · S/N 15068584N2339ADJI AGRAS T40 · S/N 64TBK8R0010037N233DFBeech F33A · S/N CE1171N254CKOlmsted Charles W RV-7 · S/N 72935N25HVCostruzioni Aeronautiche Tecna P2002 SIERRA · S/N 394N2788RRobert V Daffin III PEGAWOLF 2000 · S/N RR001N287TACostruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 087/USN29623Piper PA-32RT-300T · S/N 32R-7987123N2972JCessna 150G · S/N 15065772N30397Piper PA46-500TP · S/N 4697167N3114YBeech A36 · S/N E-2441N3222VBeech 35 · S/N D-800N34766Cessna 177B · S/N 17701991N368JEBeech 58 · S/N TH-1145N3742SCessna 172E · S/N 17250942N409JSAeronca 7AC · S/N 7AC-3369N411BGPiper PA-42-1000 · S/N 42-5527004N424RBBernhardt Ralph K KIS KIT 018 · S/N 018N433FJCostruzioni Aeronautiche Tecna P2002 SIERRA MKII · S/N 581N435FJCostruzioni Aeronautiche Tecna P2002 SIERRA MKII · S/N 582N437FJCostruzioni Aeronautiche Tecna P2002 SIERRA MKII · S/N 583N439FJCostruzioni Aeronautiche Tecna P2002 SIERRA MKII · S/N 584N444MJPiper PA-32R-300 · S/N 32R-7780083N44AYPiper PA-28R-200 · S/N 28R-7535012N462RHHylio HYL-150 · S/N 17906110415Sale reported, pending cancellationN475VPPowrachute AIRWOLF 912ULS · S/N A175ULSN48FGPiper PA-46-600TP · S/N 4698148N5162XChampion 7ECA · S/N 691N521FJCostruzioni Aeronautiche Tecna P-MENTOR · S/N 1057/USN521KMCessna 210N · S/N 21064868N522FJCostruzioni Aeronautiche Tecna P-MENTOR · S/N 1058/USN524FJCostruzioni Aeronautiche Tecna P-MENTOR · S/N 1059/USN525FJCostruzioni Aeronautiche Tecna P-MENTOR · S/N 1098/USN526FJCostruzioni Aeronautiche Tecna P-MENTOR · S/N 1099/USN527FJCostruzioni Aeronautiche Tecna P-MENTOR · S/N 1100/USN528FJCostruzioni Aeronautiche Tecna P-MENTOR · S/N 1139/USN533FJCostruzioni Aeronautiche Tecna P-MENTOR · S/N 1134/USN534FJCostruzioni Aeronautiche Tecna P-MENTOR · S/N 1135/USN559AKCessna 182K · S/N 18258213N584RBeech 58 · S/N TH-1464
Back to Nacogdoches, TX