OpenAirDocs.org
Rio Grande, NJ

Registered aircraft · 343

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 = 'NJ' AND g.registrant_city = 'RIO GRANDE'
  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.

N145WBGrumman TBM-3E · S/N 85460Built 1945 · Few Tbms LLCN1897NCessna 120 · S/N 12141Built 1947 · Nasw FoundationN302PTDehavilland CARIBOU DHC-4A · S/N 302Pen Turbo Aviation IncN3295MPiper PA-12 · S/N 12-2143Built 1947 · Paramount Air ServiceN3411AVerge X7 · S/N P8DRTDZMJPCape May Aerial Advertising LLCN3416BVerge X7 · S/N P8DRF4RJLTCape May Aerial Advertising LLCN3417VVerge X7 · S/N P8DR8KF3UNCape May Aerial Advertising LLCN3418DVerge X7 · S/N P8DRMFA5DNCape May Aerial Advertising LLCN3419DVerge X7 · S/N P8DR7W5QGSCape May Aerial Advertising LLCN341UAVerge X7 · S/N P8DR7FPJ7TCape May Aerial Advertising LLCN341VCVerge X7 · S/N P8DRVH58EQCape May Aerial Advertising LLCN341WVVerge X7 · S/N P8DR8RUV80Cape May Aerial Advertising LLCN341YCVerge X7 · S/N P8DRPILMBECape May Aerial Advertising LLCN341ZVVerge X7 · S/N P8DR7K0EUUCape May Aerial Advertising LLCN3423CVerge X7 · S/N P8DRRVSKO7Cape May Aerial Advertising LLCN3425VVerge X7 · S/N P8DRACH2RNCape May Aerial Advertising LLCN3426CVerge X7 · S/N P8DRT8D7EQCape May Aerial Advertising LLCN3429WVerge X7 · S/N P8DRT6WM8LCape May Aerial Advertising LLCN342BVVerge X7 · S/N P8DR8R2SUPCape May Aerial Advertising LLCN342CEVerge X7 · S/N P8DRZDSGLSCape May Aerial Advertising LLCN342HAVerge X7 · S/N P8DRNM0N5ACape May Aerial Advertising LLCN342JVVerge X7 · S/N P8DR8Z18MQCape May Aerial Advertising LLCN342LFVerge X7 · S/N P8DRGCMP2RCape May Aerial Advertising LLCN342NCVerge X7 · S/N P8DRP5DUFWCape May Aerial Advertising LLCN342PGVerge X7 · S/N P8DRY4HJA2Cape May Aerial Advertising LLCN342QVVerge X7 · S/N P8DR9O5EK1Cape May Aerial Advertising LLCN342SJVerge X7 · S/N P8DRP8GIFKCape May Aerial Advertising LLCN342TCVerge X7 · S/N P8DRPWZUPBCape May Aerial Advertising LLCN342UCVerge X7 · S/N P8DRQOY7SFCape May Aerial Advertising LLCN342VHVerge X7 · S/N P8DR8721R5Cape May Aerial Advertising LLCN342WVVerge X7 · S/N P8DR9ZNMVICape Amay Aerial Advertising LLCN342XCVerge X7 · S/N P8DRQS6BWNCape May Aerial Advertising LLCN342YLVerge X7 · S/N P8DRR9RKV7Cape May Aerial Advertising LLCN342ZCVerge X7 · S/N P8DRQSAI7VCape May Aerial Advertising LLCN3430MVerge X7 · S/N P8DRKTLCL0Cape May Aerial Advertising LLCN3431VVerge X7 · S/N P8DRB4LU9SCape May Aerial Advertising LLCN3434GVerge X7 · S/N P8DRZGOH32Cape May Aerial Advertising LLCN3436NVerge X7 · S/N P8DRHC4U5OCape May Aerial Advertising LLCN3437VVerge X7 · S/N P8DRCF6EL7Cape May Aerial Advertising LLCN3438TVerge X7 · S/N P8DRAWH02TCape May Aerial Advertising LLCN3439PVerge X7 · S/N P8DR12BB5DCape May Aerial Advertising LLCN343BCVerge X7 · S/N P8DRTDG6YRCape May Aerial Advertising LLCN343CVVerge X7 · S/N P8DRAX3DPPCape May Aerial Advertising LLCN343DLVerge X7 · S/N P8DRWBQ61MCape May Aerial Advertising LLCN343EHVerge X7 · S/N P8DRWH5SNUCape May Aerial Advertising LLCN343GJVerge X7 · S/N P8DRBHXE5LCape May Aerial Advertising LLCN343HCVerge X7 · S/N P8DRU7H373Cape May Aerial Advertising LLCN343JPVerge X7 · S/N P8DRWLL469Cape May Aerial Advertising LLCN343LKVerge X7 · S/N P8DR3NXRRBCape May Aerial Advertising LLCN343NCVerge X7 · S/N P8DRW4TRM0Cape May Aerial Advertising LLC
Back to Rio Grande, NJ