Deming, NM
Registered aircraft · 30
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 = 'NM' AND g.registrant_city = 'DEMING' 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 = 'NM' AND g.registrant_city = 'DEMING' 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.
N1066QPiper PA-20-135 · S/N 20-1055N1698QCessna 150L · S/N 15072998N1701APiper PA-18 · S/N 18-1288N236JCCirri Joseph F STOL CH 701 · S/N 7-6567N2454XCessna 182H · S/N 18256354N2693HSchweizer SGS 1-26E · S/N 673N2833ACessna 180 · S/N 30033N329ALArion LIGHTNING LS-1 · S/N 100N3440JCessna 150G · S/N 15066140N36622Aeronca 65-TAC · S/N C1091TAN3875ASchweizer SGS 1-26C · S/N 37N4014AAyres S2R-R3S · S/N R3S-003N4014DAyres S2R-R3S · S/N R3S-005N46DFCoonrod Donald DAPHNE SD-1A · S/N 46N48524Grumman Acft ENG Cor-Schweizer G-164A · S/N 1661N51631Maule M-5-210C · S/N 6043CN5297PPiper PA-24-250 · S/N 24-338N536DWWinston David R 160.1 · S/N 112809N5526XAero Commander S2R · S/N 1726RN5818GCessna 150K · S/N 15071318N6097BCessna 182A · S/N 34097N6442TCessna 150 · S/N 17842N772ZZCessna 150F · S/N 15064240N77QQBeech V35B · S/N D10251N7803PPiper PA-24-250 · S/N 24-3064N7805DPiper PA-22-150 · S/N 22-5450N8472VRockwell International S-2R · S/N 2232RN88058Piper J3C-65 · S/N 15674N8815QAero Commander S2R · S/N 1515RN8828QAero Commander S2R · S/N 1528R
Back to Deming, NM