Mesquite, NV
Registered aircraft · 34
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 = 'MESQUITE' 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 = 'MESQUITE' 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.
N123VRCessna T210L · S/N 210-59891N148SEPowrachute SKY RASCAL · S/N 010N1960FCessna 172N · S/N 17273050N2350BTemco GC-1B · S/N 3650N23816Cessna 182S · S/N 18280470N28448Grumman American Avn. AA-5B · S/N AA5B0615First renewal noticeN30836Bell 222 · S/N 47036N30854Aero Commander 690A · S/N 11229N3221SCessna 182G · S/N 18255721N360TERotorsport UK MTOSPORT · S/N RSUK-M01967N3996DCessna 182A · S/N 34696N4321EBeech V35A · S/N D-8868N44KBIrace William R RV-6A · S/N 24019N4675ECessna 182R · S/N 18268259N47713Bell 47G-3B-1 · S/N 2954N47EDBell 47G · S/N 1227N480VEnstrom Helicopter 480B · S/N 5057N4842TPiper PA-28-140 · S/N 28-7225222N5679KBeech 35-B33 · S/N CD-804N607RVGlick Richard A VANS RV-7A · S/N 71916N616DTPowrachute AIRWOLF 912ULS · S/N A394ULSN694MKBalony Kubicek Spol Sro BB26D · S/N 2071N7328CSinger John RV-6A · S/N 60582N735SHAmerican Eurocopter AS350B2 · S/N 7315N736EQCessna R172K · S/N R1722472N738LGCessna 172N · S/N 17270057N74700Mooney M20B · S/N 1800N79867Mooney M20E · S/N 530First renewal noticeN808FSCessna T210M · S/N 21061586N8336ZRobinson Helicopter R44 · S/N 0262N8356NBeech V35A · S/N D-8744N8629WPiper PA-28-235 · S/N 28-10144N9066TCessna 182C · S/N 52966N99YRScheffel Frederick PREDATOR 912 · S/N PC04079W301
Back to Mesquite, NV