Registered aircraft · 19

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

N1004YCameron Balloons US O-84 · S/N 6384Built 2006 · Nakamura Judith N102WLDubois S C/Dubois K M WHITE LIGHTNING · S/N 59Built 1987 · Boyd Stanley E N1991GCameron Balloons US V-77 · S/N 5272Eakin Sean T N218CBArbc Inc DBA Lindstrand 105A · S/N 5337Built 2006 · Watson Barney L N279TAArmstrong Terry PULSAR · S/N 279Built 1997 · Armstrong Terry W N3084NBeech F33A · S/N CE-1246Built 1988 · Laprelle James L N328CMMooney M20F · S/N 670100Simunaci Jeffrey N3677UBeech 95-B55 (T42A) · S/N TC-2337Built 1980 · Ninomiya James T N4168VCessna 170 · S/N 18501Built 1948 · Lehr F Mark N426JBRodney L Davis RANS S-7S · S/N 0713593Built 2015 · Johnson Stanley D N4684CSmith Cameron T RV4 · S/N 68Built 2008 · Smith Cameron T N5461EAndrew Philip Richardson DBA A55S · S/N 205Built 2016 · Randall Thomas D N563LLRichardson Andrew P RICHARDSON-FISHBOWL · S/N 008Built 2014 · Eakin Sean T N614LBArbc Inc DBA Lindstrand 77A · S/N 5580Built 2015 · Eakin Sean T N75JAAnderson John F VANS ACFT RV-6A · S/N 22946Built 1997 · Domenick James V N817VGDJI MAVIC PRO · S/N 08QDE1501202HEFirst renewal noticeGingrich James L N841CBSchempp-Hirth K G VENTUS A · S/N 12Built 1980 · Work Stephen A N9012UArbc Inc DBA Lindstrand 100E · S/N 5826Built 2025 · Randall Thomas N9520TCameron Balloons US V-77 · S/N 5604Built 1989 · Nakamura Judith K

Back to Placitas, NM