Uvalde, 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 = 'UVALDE' 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 = 'UVALDE' 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.
N111KTRobinson Helicopter R22 BETA · S/N 3273N1152LMooney M20K · S/N 25-0627N124RALet Z-37-A · S/N 20-21N1356MCessna 182P · S/N 18264294N135WZStol-It SUPER STOL · S/N JA368-04-14Registration pendingN138AChiavetta Andy LANCAIR LEGACY · S/N L2K-138N144SGRobinson Helicopter R44 II · S/N 11880N15TZCessna 750 · S/N 750-0127N165HPBeech A36 · S/N E-1856N189TWRobinson Helicopter R44 II · S/N 11025N2006QCessna 177RG · S/N 177RG0406N207DRCessna 207A · S/N 20700372N207RSCessna 425 · S/N 4250195N22166Mooney M20R · S/N 29-0225N234LHRobinson Helicopter R44 II · S/N 10097N244CCRobinson Helicopter R44 · S/N 0860N245TXLearjet 45 · S/N 023N278SHRobinson Helicopter R22 BETA · S/N 4224N2841RPiper PA-28R-200 · S/N 28R-35305N2847JPiper PA-32R-301T · S/N 3257288N288EADJI AGRAS T40 · S/N 64TBL6C00200CEN28QACessna 525 · S/N 5250215N3052JBeech A36 · S/N E-2346N322SBCessna 525C · S/N 525C0053N326KFCessna 510 · S/N 510-0326N3387ADJI AGRAS T50 · S/N 1581F6BUB2457001WVS3N34TCCessna 525 · S/N 5250083N3652EPiper PA-36-375 · S/N 36-7902043N373HSEurocopter EC120B · S/N 1490N37TMCirrus Design SR22 · S/N 4289N3817QCessna 172L · S/N 17259917N40TEBeech F33A · S/N CE577N4123Mooney M-18C · S/N 291N4141MMiller James W MILLER SPECIAL JM-2 · S/N M104N42VUCirrus Design SR20 · S/N 2440N442RDRobinson Helicopter R44 II · S/N 10237N465WBWayne Baker S-20 · S/N 03180079N46696Cessna 172L · S/N 17259722N46KKTextron 525 · S/N 525-1013N4703VBellanca 17-30 · S/N 30054N484ABRobinson Helicopter R44 II · S/N 11390N4VHCessna 421C · S/N 421C0435N505HSRobinson Helicopter R44 II · S/N 13581N5115TChampion 7GCAA · S/N 137N535DKRans Designs S-21LS OUTBOUND · S/N 10200139N540CRLundgren Andrew A EDGE-540 · S/N 0011N540RCZivko Aeronautics EDGE 540-T · S/N 2014N550SCCessna 550 · S/N 5500691N568TKrok Peter C VANS RV-7A · S/N 70906N580LMako N580l NLA-450 · S/N NLA-450-1001
Back to Uvalde, TX