Registered aircraft · 23

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

N1024NSolomon Jeremy VELOCITY XL FG · S/N 3 FX026Built 2012 · Solomon Jeremy M N1319SSager Alvin W CYGNET SF-2A · S/N 263Built 1991 · Sager Alvin W N24JPPierce John L BREEZY · S/N 101Built 1980 · Southside Breezy Club N3471RPiper PA-28-180 · S/N 28-5697Built 1970 · Kilpatrick Kerry N586EFCirrus Design SR20 · S/N 11381Built 2026 · Mauli Enterprises LLC N6513TBeech 19A · S/N MB-355Built 1968 · Reilly Michael G N7913UCessna 150M · S/N 15077859Built 1976 · Kashmir Air Inc N8365GCessna 150F · S/N 15062465Built 1965 · Mendez Carlos L N836BMDJI PHANTOM 3 STANDARD · S/N P5AUDG2701012NJoseph Kirk B N836PWWaterwood REPTILE 500 MWC X V3 · S/N XK6WSM8Joseph Kirk B N840KADJI PHANTOM 3 STANDARD · S/N P5AUEA1401044NJoseph Kirk B N843NJVolantex RANGER EX 737 · S/N XK6WSM8Joseph Kirk B N8493LCessna 172I · S/N 17256693Built 1968 · Briss David S Dmd N8798JHusban H501SS X4 PRO · S/N R5M501SXJoseph Kirk B N880KJTarot X8 · S/N R5MVHL10X100Joseph Kirk B N880WKHusban H501SS X4 PRO · S/N R5MV501SSWJoseph Kirk B N884AMEclipse EA500 · S/N 000164Built 2008 · N884am Holdings Inc N8948YPiper PA-39 · S/N 39-109Built 1971 · Kilpatrick Kerry N900RVMortellito Ronald VANS RV-9A · S/N 92309Built 2022 · Mortellito Ronald N947SKDJI AIR 2S · S/N 3YTBJ3Q0030NRJJoseph Kirk B N947UJDJI PHANTOM 4 PRO V2.0 · S/N 11UCFA90A50297Joseph Kirk B N952ZKDJI PHANTOM 4 · S/N 07DDD5QOB11441Joseph Kirk B N961JFGulfstream Aerospace GV-SP (G550) · S/N 5349Aha Aviation LLC

Back to Somerset, NJ