Victoria, TX
Registered aircraft · 62
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 = 'VICTORIA' 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 = 'VICTORIA' 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.
N10CHMooney M20F · S/N 690048N157RLDJI AGRAS T100 · S/N 1581F8ZLC2594002ZVJ4N158PCTextron G58 · S/N TH-2500N170AGCessna 170A · S/N 18975N212PKPilatus PC-12/45 · S/N 668N222FGCessna 414A · S/N 414A0823N22CTLearjet 45 · S/N 543N230ADJabiru Aircraft PTY J230-D · S/N 848N233KTMooney M20TN · S/N 31-0040N23723Beech V35B · S/N D-10100N247KAEmbraer Executive EMB-505 · S/N 50500619N255BPBell OH-58A · S/N 68-16722N2594WMooney M20E · S/N 945N260SMBombardier BD-100-1A10 · S/N 20776N2729LCessna 414A · S/N 414A0431N27325Aeronca 60-TF · S/N F1380TN2753TPiper J5A · S/N 5-1213N28138Bellanca 17-31ATC · S/N 78-31142N288MCCessna 182T · S/N 18281110N2967ZPiper PA-22-150 · S/N 22-6941N301PBeech 58 · S/N TH-890N3189SCessna 182G · S/N 18255689N3322TMaige Stanley F MAIGE ROTORWAY 162F · S/N 6511N3641YPiper AEROSTAR 601P · S/N 61P08218063430N366PCRaytheon G36 · S/N E-3685N4030CRobinson Helicopter R22 BETA · S/N 1544N4177MRobinson Helicopter R44 II · S/N 12516N428WJWatts W/Boddy G FALCO F-8L · S/N F8L100N439RLDJI AGRAS T40 · S/N 1581F574B239K0010025N440RLDJI AGRAS T40 · S/N 1581F574B235400100C0N446MPentz George B RV-10 · S/N 40270N4562RPiper PA-28-140 · S/N 28-21304N459VHHylio HYL-150 · S/N 17906110417N48XBPilatus PC-12/47E · S/N 1459N50XBMD Helicopters 369E · S/N 0624EN5543BCessna 182 · S/N 33543N58458Cessna 182P · S/N 18262076N5893WPiper PA-28-160 · S/N 28-2645N61175Air Tractor AT-502B · S/N 502B-0297N616EMPilatus PC-12/47E · S/N 2238N631VTDJI AGRAS T30 · S/N 527BK4F00100D4N6569TBeech B23 · S/N M-1144N68TSAerotek PITTS S2S · S/N 1013N696SCCessna 310R · S/N 310R0970N7283KPiper PA-18 · S/N 18-195N736HGCessna R172K · S/N R1722535N7594SCessna 182Q · S/N 18265243N77566Piper J3C-65 · S/N 22055N77VBBeech V35B · S/N D-9629N791KBAmerican Champion 8KCAB · S/N 1035-2007
Back to Victoria, TX