Sparks, NV
Registered aircraft · 117
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 = 'NV' AND g.registrant_city = 'SPARKS' 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 = 'NV' AND g.registrant_city = 'SPARKS' 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.
N100DTAntares USA MA-32R-912S · S/N 0303N103JRNielsen Fredrick Q-2 · S/N 2840N105MNKubicek Factory S R O BB30M · S/N 2307N109BBByrd Bobby Dean KITFOX IV · S/N 1719N111DFMooney M20J · S/N 24-0155N125PZPilatus PC-12/45 · S/N 209N1356HAeronca 15AC · S/N 15AC-403N135CDCirrus Design SR22T · S/N 11250N135NCCessna A185F · S/N 18503992N18CSShapler Charles E FISHER CELEBRITY · S/N AV1055N1977SCessna 172N · S/N 172-67687N20885Piper PA-32RT-300 · S/N 32R-7885247N208SNCessna 208B · S/N 208B2112N23TDBeech C23 · S/N M-1785N2423DCessna 170B · S/N 20575N246JKKing Jack F AEROCOMP CM-4 180 · S/N 99197N2511APiper PA-18 · S/N 18-1971N25DDCirrus Design SR22 · S/N 0894N2717GCessna 182B · S/N 52017N2719BSmith James RV 8A · S/N 001N292EDCessna 172S · S/N 172S9105N29USEmbraer-Empresa Brasileira De EMB-314B · S/N 31400082N3160SCessna 182G · S/N 18255660N320AKKolak Andrew A WAG AERO SPORT TRNR · S/N 3841N3393RPiper PA-28-180 · S/N 28-5672N343PCPhilip Cloutier WAGAERO SUPER SPORT · S/N 1655N345JCCooper Jerold R RV6A · S/N 23957N3567FCessna 182J · S/N 18257567N356ERBeech 300 · S/N FA-55N3592CAerostar International S-60A · S/N S60A-3098N3692SCessna 172E · S/N 17250892N3747YCessna 210D · S/N 21058247N3821GCessna TU206B · S/N U206-0821N4083BThorp T-18 · S/N 24N4177QCessna 310N · S/N 310N-0077N428CTPiper PA-28-236 · S/N 28-7911155N4408YPettijohn E T P J 18 1/2 · S/N 1N440THBurkhart Grob Flugzeugbau SPEED ASTIR II · S/N 4022N444TKMooney M20K · S/N 25-0576N4588BCarlson Sparrow CARLSON SPARROW 2 · S/N 05101945MABN45928Cessna 152 · S/N 15282945N461GTGulfstream Aerospace GIV-X (G450) · S/N 4022N4658FCessna P206A · S/N P206-0258N475SNDehavilland DHC-8-202 · S/N 475N489DLVans RV-12IS · S/N 12113N524WPAutel Robotics X-STAR PREMIUM · S/N UXS610311245N52JPHunter James J THORP T-18 · S/N 1235N5365CCessna 140A · S/N 15575N541AVBombardier DHC-8-201 · S/N 541N54PFBeech A36 · S/N E-2941
Back to Sparks, NV