Spicewood, TX
Registered aircraft · 64
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 = 'SPICEWOOD' 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 = 'SPICEWOOD' 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.
N1071KSilvaire LUSCOMBE 8A · S/N 3798N111NZCessna 140 · S/N 12372N11HLColtin Brown HIGHLANDER · S/N JA300-05-13N121MKKiedrowski Mark A PANTHER TRI-GEAR · S/N 121N121PCCirrus Design SR22T · S/N 10932N1352WProgressive Aerodyne SEAREY LSA · S/N 1020Sale reportedN13RKBeech A36 · S/N E-1238N146YSCessna 170B · S/N 25713N147PWRaytheon A36 · S/N E-3420N1626Murland L Taylor PIETENPOL AIR CAMPER · S/N 3964N1814CBeech 95-B55 (T42A) · S/N TC-2365N182CQCessna 182P · S/N 18261701N200QAIsrael Aircraft Industries GULFSTREAM 200 · S/N 130N2013KFiora Robert SKY RAIDER · S/N RF1N201DRMooney M20J · S/N 24-0028N2056MPiper PA-28R-201T · S/N 28R-7803102N214TXCirrus Design SR22 · S/N 4066N2251QRaytheon B36TC · S/N EA-604N233SCBeech V35B · S/N D-9599N234NAmerican Eagle 201 · S/N 819N241GWWheeler Gregory R GLASAIR FT SUPER IIS · S/N 2248N2514ZBellanca 7GCBC · S/N 992-77N338JBStampe ET Renard SV-4C · S/N 629N3557ECessna 172R · S/N 17281057N35741Cessna 172I · S/N 17256945N36LMBeech A36TC · S/N EA-67N377VKMooney M20J · S/N 24-1495N37TVHexacrafter HXS-900 · S/N FC-0005N3950VCessna 170 · S/N 18269N414NEErickson Alan K ERICKSON-RV-8A · S/N 001N43ZZBrush Charles E RV4 · S/N 433N479HSocata TBM 700 · S/N 344N47SVNord STAMPE SV4C · S/N 423N4978LCessna 152 · S/N 15284247N4SVStinson 108-3 · S/N 108-4727N5131QCessna T210L · S/N 21059631N5179DCessna 182A · S/N 51279N530SEGates Learjet 35A · S/N 454N60ECCessna A185F · S/N 18503913N6459WPiper PA-28-140 · S/N 28-20532N64JPLearjet 60 · S/N 246N65996Boeing B75N1 · S/N 75-7080N6HHBeech P35 · S/N D-6928N700HLSocata TBM 700 · S/N 281N737DPCessna 172N · S/N 17269340N737VACessna 172N · S/N 17269698N74877Grumman American Avn. AA-5B · S/N AA5B-0272N7492WPiper PA-28-180 · S/N 28-1405N759DCCessna 182Q · S/N 18265902N791AMorse Norman R VANS RV-7A · S/N 70091
Back to Spicewood, TX