OpenAirDocs.org
Christiansted, VI

Registered aircraft · 16

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 = 'VI' AND g.registrant_city = 'CHRISTIANSTED'
  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.

N122NGDiamond Aircraft Ind DA 40 NG · S/N 40.NC108Built 2020 · Austin Fire Systems LLCN168GFNew Piper PA-46-350P · S/N 4636189C2c LLCN2410UCessna 172D · S/N 17250010Yellow Breast Aviation LLCN28DMCessna 525B · S/N 525B0142Built 2007 · Machavia IncN456DAPiper PA-31-325 · S/N 31-7912103Built 1979 · Liberty Air LLCN461TJCessna 172K · S/N 17259114Built 1970 · Sharmouj RaymoundN510KBCessna 510 · S/N 510-0155Built 2009 · Aviation Research And MaintenanceN6485YPiper PA-23-250 · S/N 27-3782Built 1967 · Meluskey MichaelN676MFCessna 402B · S/N 402B0106Built 1971 · Coastal Resource Associates IncN677MFCessna 404 · S/N 404-0421Coastal ResourceN684JKPiper PA-32-300 · S/N 32-40537Tta Logistics LLCN6ZGPiper PA-23-250 · S/N 27-3872Built 1968 · Tta Logistics LLCN7188YPiper PA-30 · S/N 30-212Registration pendingBuilt 1963N724BSBBS Aircraft Leasing LANCAIR EVOLUTION · S/N EVO-0049Built 2014 · Progressive Veterinary Transport LLCN87SABeech B200 · S/N BB-1089Built 1982 · Liberty Air LLCN95LBBeech E-90 · S/N LW-24Tate James D
Back to Christiansted, VI