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

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 = 'ANTHONY' ORDER BY g.n_number

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 = 'ANTHONY'
  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 = 'ANTHONY'
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.

N116UNavar MINIPLANE DSA-1 · S/N 1557866Robinson Michael E N123AMCessna 340 · S/N 340-0245Built 1973 · C W Myers Holdings LLC N2116ZPiper PA-28-236 · S/N 28-7911150Built 1979 · Bush Stanley D N2257RCessna R182 · S/N R18200582Built 1978 · Canales Jorge N28MVRobinson Michael E VANS RV9A · S/N 92262Built 2021 · Robinson Michael E N392AAdams Balloons A60-S · S/N 268Built 2020 · Word Donald G N40427Balloon Works FIREFLY 7 · S/N 7861Built 1979 · Word D Glen N42DYRoadcraft VANS ACFT INC RV-14 · S/N 140334Built 2017 · Anthony Properties LLC N44VMWiebe J/Wiebe M EMERAUDE 305 · S/N MJW4Simpson Delmer R N468JLLudwig Jeffrey R RV-8 · S/N 80286Built 1999 · Carothers Alexander F N4982VPiper J3C-65 · S/N 43-560Built 1943 · Mcnamee Michael P N5623UPiper PA-28-140 · S/N 28-26419Built 1969 · Mendoza Cesar N5890PPiper PA-24-250 · S/N 24-975Built 1959 · Daniels David R N5895SBeech S35 · S/N D-7773Built 1965 · Burson Lloyd R N6106VBeech S35 · S/N D-7796Built 1965 · Mendoza Cesar N6116VBeech S35 · S/N D-7782Built 1965 · Doyle George H III N72795Cessna T206H · S/N T20608092Built 1999 · Sides Enterprises LLC N7285ECessna 182B · S/N 52285Built 1959 · Atchley Mark N770BHMooney M20M · S/N 27-0342Built 2005 · Fernando Baeza N795JCBursey Brian E RV-4 · S/N 795Built 1994 · Jackson Eric M N8126BCessna 172 · S/N 29926Built 1957 · Robinson Michael E N8291JVarga 2150A · S/N VAC-137-79Built 1979 · Worth William A N8842TCessna 182C · S/N 52742Mcnamee Michael P N8905ABeech B35 · S/N D-2603Built 1950 · Galliart Herb N916HPPiper PA-28-180 · S/N 28-2658Neustaeter Pedro Thiessen N91VMMichael Robinson HUMMEL H5 · S/N 000319Built 2024 · Robinson Michael N922RBBeech 95-B55 (T42A) · S/N TC-1694Built 1974 · Cunningham John P N966DBBurson Lloyd R RV-6 · S/N 20132Burson Lloyd R N9810JCessna A150M · S/N A1500619Built 1976 · Bradley Eric Leon N9911ACessna 170A · S/N 19271Daniels Bayce D

Back to Anthony, NM