Waller, TX
Registered aircraft · 120
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 = 'WALLER' 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 = 'WALLER' 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.
N10158Stits Playboy KS-1 · S/N K-1N108WSStinson 108-3 · S/N 108-4502N109KMSchempp-Hirth Flugzeugbau VENTUS 2C · S/N 130N124MMSchleicher ASW-24 · S/N 24030N1250QCessna 150L · S/N 15072550N12561Cessna 172M · S/N 17262074N12ETEsteb E/Tolchin S RUTAN LONG EZE · S/N 1333N132MBBarr Melville BARR PRECEPTOR PUP · S/N 1N133CRCanadair T33-MK3 · S/N 21098N137TDRobinson Helicopter R44 · S/N 2300N138SACessna 500 · S/N 500-0138N140TGCessna 140 · S/N 9433N1552HCessna 177RG · S/N 177RG0726N15KVVander Voort Hendrikus J AIR CAMPER · S/N 758N15TKJones Tyre K STARDUSTER II TK1 · S/N 1N187TPhillip Benson/Barney Fletcher AVID MARK IV · S/N 1426DN204JPBac Jet Provost P84 MK 4 · S/N XR701N208GMAC Cooperative AC 4 · S/N 008N212LSRobinson Helicopter R44 · S/N 1650N213SGDavid Miller RUTAN SOLITAIRE · S/N 117SN2175CCessna 195B · S/N 16160N21HZBeech E33A · S/N CE-260N220CXMorton Gene A CX4 · S/N 5982N22SHBell 47G · S/N 52-7953N2396XWilliams Donald E ACRO DUSTER TOO · S/N 191N23EJIglesias Hector E RV-6 · S/N 60014N23JHMichael S Toomey QUICKIE · S/N 003N23MTKennedy Martin F LONG EZ · S/N 955N2486WSchweizer SGS 2-33 · S/N 38N2652NCessna 140 · S/N 12910N26625Taylorcraft BF · S/N 1967N27157Gulfstream American AA-5A · S/N AA5A0881N2719XBoeing E75 · S/N 42-16993N2752WMooney M20E · S/N 1167N307SAlexander-Starduster Too SA-300 · S/N 471N3134XCessna 150G · S/N 15064534Registration expired, pending cancellationN318KMSchempp-Hirth Flugzeugbau VENTUS 3F · S/N 032 FSN321ADAlisport SILENT 2 ELECTRO · S/N 2077N33962Schweizer SGS 2-33A · S/N 362N34CRBeech A45 · S/N G-758N34JWBeech T-34B · S/N BG374N3536XMooney M20F · S/N 670073N353BALet L 33 SOLO · S/N 990502N35DKKretschman Dirk D VP-2 · S/N V2-11-78-DKN3613KPiper J3C-65S · S/N 22301N365DBBrown David S LONGEZ · S/N 1697N365TANorth American T-6G · S/N 49-3365AN3708EAeronca 7AC · S/N 7AC-7009N3799GBeech A45 · S/N G-709N3837YCessna 210D · S/N 21058337
Back to Waller, TX