Pahrump, NV
Registered aircraft · 64
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 = 'PAHRUMP' 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 = 'PAHRUMP' 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.
N1025EAeronca 7DC · S/N 7AC-4576N108DSSchaffer David AVID MARK IV · S/N 1233DN116RBGlasflugel H 301 B LIBELLE · S/N 95N152TJRobert C Copeland ZODIAC 601XLB · S/N 66779RCN1628GChampion 7ECA · S/N 626N166RRArbc Inc DBA Lindstrand 160A · S/N 5542N16SCPiper PA-31 · S/N 31-639N1946WRobert P Shallenberger PANTHER LS · S/N 068N22132Mckissick Maynard JR MCM-1 · S/N 0001N23620Beech A36 · S/N E-1165N2364JBeech 23 · S/N M-322N2429JKahle Jack E GLASTAR · S/N 5123N2764PPiper PA-22-150 · S/N 22-3075N2887SCessna 150G · S/N 15066787N3016BArbc Inc DBA Lindstrand 69A · S/N 5465N30430Lazaro Ralph B BUSHBY MUSTANG M-11 · S/N 1311N3083LCessna 310J · S/N 310J0083N3296PGlascott Eric LANCAIR SUPER ES · S/N ES-003N3512SAntares US ANTARES · S/N KL359AN374WFPiper PA 46-350P · S/N 4636527N3847BBeech F35 · S/N D-4117N3976SCessna 172E · S/N 17251176N40565Cameron Balloons US A-210 · S/N 6485N417AGNorth Wing Uum SPORT X2 · S/N LS7017N422PLAirplane Factory SLING LSA · S/N 295N42311Cessna 182L · S/N 18258959N427CBCameron Balloons US A-225 · S/N 6778N444LDDana G Linn 601XLA2 · S/N SBG002N490AAirborne Windsports PTY EDGE XT-912-L · S/N XT-912-0123N494KSRobertson Scott AVID MAGNUM · S/N M61N5277NNorton Milo LANCAIR 235 · S/N 044N5292PPiper PA-24-250 · S/N 24-332N533CHCessna 340 · S/N 340-0056N5391PPiper PA-24-250 · S/N 24-442N55PSSchweizer SGS 1-35C · S/N 64N5783UPiper PA-28-140 · S/N 28-26607N5790ECessna 150 · S/N 17290Sale reported, canceledN5947ECessna 150 · S/N 17447N619CStinson 108-3 · S/N 108-3619N6299FCessna 337A · S/N 337-0299N6787WPiper PA-28-140 · S/N 28-20917N705WSiren PIK 20E · S/N 702N711RGGrob Ronald LANCAIR ES · S/N ES-036N713TBSocata TB21 · S/N 2123N7152ECessna 182B · S/N 52152N7178PPiper PA-24-250 · S/N 24-2347N7196ECessna 182B · S/N 52196N719TBSocata TB-20 TRINIDAD · S/N 2126N750SJRobert P Shallenberger STOL CH750 · S/N 75-8976N752RGIves William/Nnse SH1 RG · S/N 752R
Back to Pahrump, NV