OpenAirDocs.org
Trenton, NJ

Registered aircraft · 22

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

N101MFBell 47G-2 · S/N 1953Built 1957 · Usda Forest Service FeppN102DLBeech B36TC · S/N EA-567Built 1994 · P & G Trading Co IncN102NJBell 206B · S/N 1671Built 1975 · Usda Forest Service FeppN103NJBell 206A · S/N 361Built 1969 · Usda Forest Service FeppN105NJBell Helicopter UH-1H (205) · S/N 66-17071 (9265)Usda Forest Service FeppN106NJBell Helicopter UH-1H (205) · S/N 66-16030 (5724)Usda Forest Service FeppN107NJBell UH-1H · S/N 13682Usda Forest ServiceN110NJCessna U206G · S/N U20606938Built 1986 · State Of New JerseyN111NJCessna U206 · S/N U206-0278Built 1964 · New Jersey Forest Fire ServiceN115NJCessna 182J · S/N 18256954Built 1966 · Usda Forest Service FeppN116NJPiper PA-18-150 · S/N 18-8104Built 1964 · Usda Forest Service FeppN1NJAgusta Aerospace AW139 · S/N 41242Built 2011 · State Of New JerseyN200ELIsrael Aircraft Industries GULFSTREAM 200 · S/N 092Built 2004 · N200el LLCN22DMCirrus Design SR22 · S/N 2886First renewal noticeBuilt 2007 · M1 Aviation LLCN2728XCessna 180H · S/N 18051528Built 1965 · Usda Forest Service FeppN3NJAgustawestland Philadelphia AW139 · S/N 41293State Of New JerseyN5036WPiper PA-28 · S/N 28-38Built 1961 · Aeroglide Aviation Group LLCN615LHBell 206B · S/N 2263Irie Leasing LLCN7NJAgusta Aerospace AW139 · S/N 41264Built 2011 · State Of New JerseyN940ELCompagnie Daher TBM 700 · S/N 1333Red Tail Aviation LLCN956KBBell 206B-III · S/N 2717Built 1979 · Irie Leasing LLCN9NJAgusta Aerospace AW139 · S/N 41243State Of New Jersey
Back to Trenton, NJ