Killeen, TX
Registered aircraft · 72
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 = 'KILLEEN' 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 = 'KILLEEN' 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.
N101BBBeech K35 · S/N D-6076N10508Aeronca 7DC · S/N 7DC-502N113CTVulcanair S P A VULCANAIR V1.0 · S/N 1036N1237VCessna/Air Repair 305F · S/N AR-2N140BCPiper PA-28-140 · S/N 28-7125313N148AJOscar A Vega QUICKSILVER SPORT 2S · S/N 0257N157CTVulcanair S P A VULCANAIR V1.0 · S/N 1037N177LJCessna 177B · S/N 17702565N17YLBeech B300 · S/N FL-1N213SFRobinson Helicopter R44 · S/N 1534N216CTVulcanair S P A VULCANAIR V1.0 · S/N 1038N225MLRobinson Helicopter R44 · S/N 1810N235CRPiper PA-28-235 · S/N 28-7310099Registration pendingN252MDFrederick Mark L FREDERICK RV-4 · S/N 4001N25ADPiper PA-34-220T · S/N 348333001N27DRWoodham Donald H RV6 · S/N 24703N2867TPiper PA-28-140 · S/N 28-7225259N316NFBeech 23 · S/N M-473N31KSCessna 421B · S/N 421B-0662N31SMMooney M20E · S/N 635N3312WPiper PA-32-260 · S/N 32-150N3478WPiper PA-32-260 · S/N 32-354N36SSBeech A36 · S/N E-195N3720KGlobe GC-1B · S/N 1413N400TMCessna 421B · S/N 421B0885N4078Mooney M-18C · S/N 264N409AWBombardier CL-600-2B19 · S/N 7447N415AWBombardier CL-600-2B19 · S/N 7593N416AWBombardier CL-600-2B19 · S/N 7603N420AWBombardier CL-600-2B19 · S/N 7640N425AWBombardier CL-600-2B19 · S/N 7663N435AWBombardier CL-600-2B19 · S/N 7724N438AWBombardier CL-600-2B19 · S/N 7748N439AWBombardier CL-600-2B19 · S/N 7753N44889Piper PA-28R-201T · S/N 28R-7703336N455AWBombardier CL-600-2B19 · S/N 7848N460AWBombardier CL-600-2B19 · S/N 7867N464AWBombardier CL-600-2B19 · S/N 7890N470ZWBombardier CL-600-2B19 · S/N 7927N471ZWBombardier CL-600-2B19 · S/N 7457N48333Cessna 152 · S/N 15283324N4869LCessna 152 · S/N 15284237N4LRGlobe GC-1B · S/N 2002N502AWTextron B200GT · S/N BY-374N504AWTextron B200CGT · S/N BZ-7N509AWTextron B200GT · S/N BY-412N532AWBeech 300 · S/N FA-218N534AWBeech 300 · S/N FA154N5405RCessna 172F · S/N 17252943N5527DBeech H35 · S/N D-5063
Back to Killeen, TX