San Marcos, TX
Registered aircraft · 89
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 = 'SAN MARCOS' 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 = 'SAN MARCOS' 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.
N102UDiamond Aircraft Ind DA20-C1 · S/N C0205N1083QCessna 310H · S/N 310H0083N10FTThompson Paul F MARQUART CHARGER MA5 · S/N 172N111DHHeusinkveld Daryl L LONG EZ · S/N 336N114VKCessna 172S · S/N 172S8695N1169HGrumman American Avn. AA-5B · S/N AA5B-0063N11724Mooney M20J · S/N 24-1327N12CDCirrus Design SR20 · S/N 1890N137TXAbbey Charles E RV-4 · S/N 3956N1522UFirefly Balloons FIREFLY 7-15 · S/N F7-2012N179AWRainbow Sky Reach BUSHCAT · S/N CH154BN180EXGavlick John R SR RV-6A · S/N 21407N1830WBeech V35B · S/N D-9428N2069VInterplane SKYBOY UL · S/N 0572002N21127Cessna 182P · S/N 18261432N228JBalony Kubicek Spol S R O BB78Z · S/N 1573N229SWEmbraer EMB-120ER · S/N 120.305N2332TGulfstream American AA-5B · S/N AA5B0934N233SWEmbraer EMB-120ER · S/N 120.307N235SWEmbraer EMB-120ER · S/N 120310N235TCThunder & Colt Airborne Amer COLT 105A · S/N 2065USAN2379XCessna 182H · S/N 18256279N2428RCessna 182G · S/N 18255528N24547Cessna 172R · S/N 17280796N2606TKolb TWINSTAR · S/N 1001N26355Cessna 310R · S/N 310R1645N26899Gulfstream American AA-5A · S/N AA5A0796N290SWEmbraer EMB-120ER · S/N 120317N297SWEmbraer EMB-120ER · S/N 120327N29EMMooney M20R · S/N 29-0494N30988Cessna 177B · S/N 17701584N31007Mooney M20R · S/N 29-0277N32MLAmerican AA-1A · S/N AA1A-0350N33JCPiper PA-28-181 · S/N 28-7890144N3590PPiper PA-18A · S/N 18-4545N3890ASchweizer SGU 2-22 · S/N 51N39789Lake LA-4-200 · S/N 553N4004FCessna 172 · S/N 36904N406AVDehavilland DHC-8-202 · S/N 460N40RJVans RV-12 · S/N 120089N4120CStinson 108-3 · S/N 108-5120N480AVDehavilland DHC-8-202 · S/N 484N492BADehavilland DHC-8-202 · S/N 492N4984ECessna 140 · S/N 10588N525MCCessna 525B · S/N 525B-0288N528SAndrew R Werback SKYBOLT · S/N 001N53SGCessna 210M · S/N 21062609N55723Stinson L-5 · S/N 76-193N5609DBeech E18S · S/N BA-315N561SWEmbraer EMB-120ER · S/N 120335
Back to San Marcos, TX