OpenAirDocs.org
Concord, MA

Registered aircraft · 20

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 = 'MA' AND g.registrant_city = 'CONCORD'
  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.

N142FSMoore Richard H FLIGHTSTAR II · S/N 001Built 1996 · Moore Richard HN1FGulfstream Aerospace GVI (G650) · S/N 6076Built 2014 · Tvpx Ars Inc TrusteeN21276Cessna 172S · S/N 172S9433Built 2003 · Schrager Daniel L TrusteeN248ASCirrus Design SR22 · S/N 4537Built 2017 · Llama Cirrus LLCN300NZBombardier BD-100-1A10 · S/N 20397Built 2013 · Tvpx Ars Inc TrusteeN301KBLearjet 45 · S/N 483Registration pendingBuilt 2014N302KBLearjet 45 · S/N 498Registration pendingBuilt 2014N311BTCessna 414A · S/N 414A0453Bob Air LLCN441UCCessna 441 · S/N 4410344Conquest Associates LLCN45EEBeech 58 · S/N TH-185Built 1971 · Vazarani SarahN526ABTextron 525 · S/N 525-1012Built 2018 · Amandair LLCN53WMMooney M20R · S/N 29-0191Built 1999 · Burns IvanN585TADJI INSPIRE 1 · S/N W13DBL15010183Thatch LLCN719DCCirrus Design SR22 · S/N 2069Built 2006 · Rosse Bradley EN756PYCessna U206G · S/N U20604259Built 1978 · Associated Pilots IncN8146JCirrus Design SR22 · S/N 0675Built 2003 · Fabios Construction IncN821LBRaytheon HAWKER 800XP · S/N 258650Tvpx Ars Inc TrusteeN85892Cessna 182P · S/N 18261901Built 1973 · Vincent MarkN858AFCirrus Design SF50 · S/N 0103Built 2019 · Sky One LLCN900GRAsta Technology SAGL-20 · S/N UAS00174647Colman John A
Back to Concord, MA