Vans Aircraft Inc
Registered aircraft · 35
Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.
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_name = 'VANS AIRCRAFT INC' OR list_contains(g.other_registrant_names, 'VANS AIRCRAFT INC') 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_name = 'VANS AIRCRAFT INC' OR list_contains(g.other_registrant_names, 'VANS AIRCRAFT INC') 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.
N11KHVans RV-12IS · S/N 12237N124BCVans RV-12IS · S/N 12227N129RVVans RV-9A · S/N 2N137RVVans RV-7 · S/N 1N143VVans RV-12IS · S/N 12232N144VAVans RV-14 · S/N 140055N158RVVans Acft RV-8 · S/N 81541N179RVVans Acft RV-9 · S/N 1N17ERVans RV-12IS · S/N 12097N214VAVans RV-14A · S/N 140001N220RVN419cm VANS RV10 · S/N 40210N245RAVans RV-12IS · S/N 12238N247RMVans RV-12IS · S/N 12098N264DVVans RV-12IS · S/N 12223N29PTVans RV-12IS · S/N 12247N307ATVans RV-12IS · S/N 12239N315DVVans RV-12IS · S/N 12236N365RJVans RV-12IS · S/N 12244N410RVN419cm VANS RV10 · S/N 1N413DSVans RV-12IS · S/N 12240N415XVVans RV-X · S/N 015000N477RVVans VANS RV-7 · S/N 71702N503RVVans RV-12IS · S/N 12224N599RVVans RV-12IS · S/N 12241N608KWVans RV-12IS · S/N 12242N666RVVangrunsven R E/Vangrunsven D RV 6A · S/N 1First renewal noticeN703LLVans RV-12IS · S/N 12234N7357Vans RV-8X · S/N 081005N812KMVans RV-12IS · S/N 12096N840FAVans RV-12IS · S/N 12231N867DHVans RV-12IS · S/N 12245N892AAVans RV-12IS · S/N 12246N912VAVans RV-12 · S/N 12003N914VAVans RV-14A · S/N 140002First renewal noticeN924EDVans RV-12IS · S/N 12235
Back to Vans Aircraft Inc