Sanger, TX
Registered aircraft · 102
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 = 'SANGER' 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 = 'SANGER' 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.
N102WACubcrafters CC11-160 · S/N CC11-00115N125PJJohnson Philip S BEARHAWK · S/N 570N136DEWilcox SONERAI II LTS · S/N 52594449N15018Piper PA-34-200 · S/N 34-7250347N15258Aeronca C-3 · S/N A-577N1612MBoeing E75 · S/N 75-8593N1627VCessna 140 · S/N 13799N170SBeech D17S · S/N 4817N17791Beech F33A · S/N CE-708N1885GChampion 7KCAB · S/N 144N193YKYakovlev YAK-55M · S/N 870401N195SBCessna 195B · S/N 7911N2038KLuscombe 8E · S/N 4765N2113CCessna 195B · S/N 16098N2141QCessna 177RG · S/N 177RG0541N226HBSchneider-Brashear SORRELL SNS-7 · S/N 226N2299ZJohnny J E Thompson 162 F ROTORWAY · S/N 6791N23044Bucker-Jungmann E3B · S/N E3B-219N233RDRans Designs S-19LS · S/N 05090069LSN234RXHanson Gerald E HANSON BUCKER 131E · S/N 543N2453BGlobe GC-1B · S/N 3753N252BHMooney M20K · S/N 25-1137N25530Rearwin 8125 · S/N 817N2560CBoeing A75N1(PT17) · S/N 75-6515N2639Fairchild 24 K · S/N 3315N2736SWhite Thomas A RV-8 · S/N 81921N2781JCessna A185E · S/N 18501531N2850GChampion 7ECA · S/N 510N288DRAlisport SILENT 2 ELECTRO · S/N 2088N311MTTowey Martin J CASSUTT 111M · S/N 1N314JAviat A-1C-180 · S/N 3035N31674Waco VKS-7F · S/N 6115N3174Travel Air Mfg 2000 · S/N 248N3332APiper PA-22-135 · S/N 22-1606N3400FCessna 182J · S/N 18257400N349CSSpira John C BEARHAWK COMPANION · S/N MC16-30/31N3600SCessna 172E · S/N 17250800N360YYakovlev YAK 52 · S/N 899313N36407Taylorcraft DC-65 · S/N 4148N400VWAmerican Champion 8KCAB · S/N 681-92N420EBeech D17S · S/N 6671N42596Piper J3C-65 · S/N 14879N42670Piper J3C-65 · S/N 14964N4307APiper PA-22-150 · S/N 22-3658N43295Taylorcraft BC12-D · S/N 6954N43622Taylorcraft BC12-D · S/N 7281N43LCPiper PA-28-181 · S/N 28-7790203N44258Taylorcraft BC12-D1 · S/N 10058N45692Silvaire LUSCOMBE 8A · S/N 2219N45750Luscombe 8A · S/N 2277
Back to Sanger, TX