Genoa, NV
Registered aircraft · 23
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 = 'GENOA' 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 = 'GENOA' 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.
N111PWCessna T210F · S/N T210-0066N126USDiamond Aircraft Ind DA 40 · S/N 40.826N175DDSchempp-Hirth Flugzeugbau DUO DISCUS · S/N 175N233SJonker Sailplanes JS3 · S/N 03-138N26JLPhoenix Air Sro U-15 PHOENIX · S/N 16/U15N28UCBinder Motorenbau EB29R · S/N 57N31BRStoddard-Hamilton/Steuble R H GLASAIR III SH3R · S/N 3203N452TTCirrus Design SR22T · S/N 8751N522ABBrandt Andrew C RV-9A · S/N 91231N543MDDiamond Aircraft Industries HK 36 TTC · S/N 36.721N61221Cessna 150J · S/N 15070896N67478Howard DGA-15P · S/N 562N710WLSteve Tumlin OR71 · S/N OR71-5N717FSSportine Aviacija IR Ko LAK-17C FES · S/N 307N728VSCompagnie Daher TBM 700 · S/N 1526N732RFCessna P210N · S/N P21000591N789VSCirrus Design SR22T · S/N 2132N92460Cessna 182N · S/N 18260213N94333Ercoupe 415-C · S/N 1556N951DSteven M Sliwa SW-51 · S/N SW-51-030N951JSJonker Sailplanes JS1-C · S/N 1C-095N955MCirrus Design SF50 · S/N 0695N97BSCessna 172M · S/N 17262475
Back to Genoa, NV