Farmington, NM
Registered aircraft · 84
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 = 'FARMINGTON' 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 = 'FARMINGTON' 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.
N10PRCessna 310F · S/N 310-0032N1171PMooney M20J · S/N 24-1331N1211ZPowrachute AIRWOLF 912ULS · S/N A330VIKN15GLWaco Classic 2T-1A-2 · S/N 1209N19KECirrus Design SR22T · S/N 2194N2137HCessna T206H · S/N T20608721N224UMHawker Beechcraft B200GT · S/N BY-37N2342KLuscombe 8A · S/N 5069N2359LRaytheon A36 · S/N E-3159N2417APiper PA-22 · S/N 22-781N252MRMooney M20K · S/N 25-1034N2615TCosmos PHASE II · S/N BJPOM04N277WYAviat A-1C-180 · S/N 3277N2847LCessna 172H · S/N 17256047N2897RCessna 182K · S/N 18258497N3042VRaytheon B36TC · S/N EA-622N319UPiper PA 46-350P · S/N 4636653N320LSStanley Larry M LANCAIR 320 · S/N 901-320-742N337CRCessna T182T · S/N T18208259N340UMCessna 340A · S/N 340A0698N345SLHawkins Larry L RV-4 · S/N 3455N34991Cessna 177B · S/N 17702142N3597XAerostar International RAVEN S-55A · S/N S55A-3048N36155Taylorcraft BF-65 · S/N 3134N3748UCessna 182G · S/N 18255148N387RCrossley James A RV-8A · S/N EGC-01N38910Monocoupe 90AF · S/N AP833N39707Piper PA-32RT-300T · S/N 32R-7887118N41439Piper PA-28R-200 · S/N 28R-7435183N414UMCessna 414A · S/N 414A0858N41BGCessna 340A · S/N 340A0305N426TWTextron G36 · S/N E-4077N43901Taylorcraft BC12-D · S/N 7560N440WWHawker Beechcraft B200GT · S/N BY-5N444ZAMaule M-7-260C · S/N 30051CN475TTTextron G36 · S/N E-4150N505TFLarry Hawkins RV-3A · S/N 11456N5189DCessna T182T · S/N T18208142N5218MTaylorcraft BC12-D · S/N 10518N5254NMooney M20J · S/N 24-1663N532MTalovich Michael RV-8 · S/N 80532N5399LPiper PA-28-180 · S/N 28-4708N5473EAlon A2 · S/N A-7N5910MCessna 340 · S/N 340-0067N60468Jones James P S-12 XL AIRAILE · S/N 09960742N611RFEric Underwood LANCAIR 360 · S/N 470-320-216N6181MStinson 108-3 · S/N 108-4181N6331QAerostar International RX 8 · S/N RX8-3096N635MMCessna TR182 · S/N R18200700N7104NBeech V35A · S/N D-8666
Back to Farmington, NM