Las Vegas, NV
Registered aircraft · 1,133
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 = 'LAS VEGAS' 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 = 'LAS VEGAS' 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.
N100APDehavilland DHC-6 TWIN OTTER · S/N 22N101BHGallagher XLT-RG · S/N 01N101CLAerospatiale SA341G GAZELLE · S/N 1061N101PJAero Vodochody L39C · S/N 931341N101RHHoppe Richard A SKYBOLT · S/N RH-1N101WEBeech V35B · S/N D-9231N102PMArcher Michael S-18T · S/N 001N105WPWilhelm F Percival VELOCITY XL-5 · S/N 3RX144N1066WGulfstream Aerospace G-IV (G400) · S/N 1530N1079KMooney M20J · S/N 24-3159N107ZAAero Vodochody L-39ZA · S/N 734107N108MSBoeing 737-7BC · S/N 33102N109CHGulfstream Aerospace GVI (G650ER) · S/N 6462N109ZAAero Vodochody L-39ZA · S/N 734109N10XJBeech E-90 · S/N LW-117N111PJCessna 340A · S/N 340A1234N1124HAeronca 15AC · S/N 15AC-139N1124LCirrus Design SR22T · S/N 0711N112EMIsrael Aircraft Industries 1125 WESTWIND ASTRA · S/N 023Registration pendingN1137UCessna 172M · S/N 17266866N114LAS N I A S SE 3130 ALOUETTE II · S/N 1623N1160NMooney M20J · S/N 24-1274N1178VBeech D17S · S/N 6917N117WRGulfstream Aerospace GIV-X (G350) · S/N 4015N11FFBeech D55 · S/N TE-736N120DGPiper PA-32R-301T · S/N 32R-8129077N120NMCameron Balloons US A-120 · S/N 6609N1210LCessna 650 · S/N 650-7078N1212TEmbraer S A EMB-545 · S/N 55010051N121BLBeech 58P · S/N TJ-413N121HJHonda HA-420 · S/N 42000261N121TECostruzioni Aeronautiche Tecna P92 EAGLET · S/N 1157N122PFVans RV-12 · S/N 12032N123AZBeech B36TC · S/N EA-498N124LAerofab LAKE LA-250 · S/N 40N126NSRobinson Helicopter R22 BETA · S/N 1153N1274GCessna 310R · S/N 310R0001N127MFFiedler Mark R PA-18 REPLICA · S/N JA1906132N129GCIar Sa Brasov IAR 823 · S/N 55N12NHEngineering & Research/Horn ERCOUPE 415-CD · S/N 3423N1346WMooney M20C · S/N 2627N1352ECessna 172N · S/N 17270966N1397WMooney M20C · S/N 2675N139TDAero Vodochody L-39 · S/N 734156N13EXExtra Flugzeugbau EA 300/L · S/N 087N14047Waco YKC · S/N 3966N141MHSikorsky S-76B · S/N 760465N1421MCessna 421C · S/N 421C0106N143AMHolmes Gary Don RUTAN LONG-EZ · S/N 1081N143SADehavilland DHC-6-300 · S/N 591
Back to Las Vegas, NV