New Braunfels, TX
Registered aircraft · 118
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 = 'NEW BRAUNFELS' 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 = 'NEW BRAUNFELS' 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.
N1021JAero Commander 112 · S/N 21N102YMMooney M20J · S/N 24-3389N107APCessna T206H · S/N T20608202Registration pendingN10CAHawker Beechcraft G36 · S/N E-3814N11CECessna A185F · S/N 18502512N121ACCirrus Design SR22T · S/N 1812N121SDMonnett SONERAI-IIB · S/N 2-2BN1226LConsolidated Aeronautics LAKE LA-4-200 · S/N 727N1244XMooney M20E · S/N 117N12960Cessna 172M · S/N 17262405N13322Fairchild PT-26 · S/N 10539N14EWLarry New RV-10 · S/N 42080N1580HCessna 177RG · S/N 177RG0754N17629Beech V35B · S/N D-9991N1803YCessna 172C · S/N 17249403N181RMBeech N35 · S/N D-6666N182ZSCessna TR182 · S/N R18200977N18CKCirrus Design SR22T · S/N 1581N190FDBeech F90 · S/N LA-42N199VAHamm Donald S VELOCITY ELITE LW RG · S/N 3SUV101N1QMCessna 421C · S/N 421C0701N2051YCessna 172D · S/N 17249551N210SCCessna 210G · S/N 21058888N21387Cessna O-2A · S/N 67-21387N237DTCessna 172D · S/N 17249862N243ESSantiago Edmundo F RV 8 · S/N 81321N249YBeech E33A · S/N CE-282N253TMMooney M20M · S/N 27-0004N259RPAmerican Champion 7GCBC · S/N 1221-96N2635GCessna 182B · S/N 51935N28991Gulfstream American AA-5B · S/N AA5B0926N302SKCessna 310J · S/N 310J-0036N3063XCessna 150F · S/N 15064463N330DCirrus Design SR22T · S/N 9422N333MTMooney M20F · S/N 680142N342MDCunningham Thomas J RV-4 · S/N 2504N3777MBell 206L-3 · S/N 51485N38107Piper J3C-65 · S/N 6795N39REBombardier CL-600-2B16 · S/N 5850N4148WBeech 95-B55 (T42A) · S/N TC-1561N425BLCessna 425 · S/N 425-0198N428ACAmerican Champion 7GCBC · S/N 1288-2000N4300BAvcatairframes 2 W · S/N 00201N444GCessna 550 · S/N 550-0209N444TBPiper PA-46-600TP · S/N 4698143N4588XPiper PA-28-151 · S/N 28-7615036N460LMBellanca 8KCAB · S/N 321-77N4610LCessna 172G · S/N 17254605N4627QCessna T210L · S/N 21059527N4632VVarga 2150A · S/N VAC-88-77
Back to New Braunfels, TX