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

N22778Piper J4 · S/N 4-459Built 1939 · Binns Jeffrey E N231GSCostruzioni Aeronautiche Tecna P2010 · S/N 132/USBuilt 2021 · Barry Greg N2336KLuscombe 8E · S/N 5063Built 1947 · Ahlers Walter P Jr N2403WSchweizer SGS 1-26B · S/N 348Built 1966 · Carvino Anthony M N2908KLuscombe 8A · S/N 5635Binns Jeffrey E N49TPAmerican Champion 7GCBC · S/N 1333-2002Built 2002 · Anzalone Gary A N50772Cessna 172L · S/N 17259947Built 1971 · Donnelly Jennifer A N53TMCessna T210L · S/N 21060762Built 1975 · Smith Douglas M N5936ACeres Air C31 · S/N 21578540501DAAg Drones East LLC N6173DPiper PA-22-150 · S/N 22-4820Built 1957 · Ars Logistics LLC N6549JPiper PA-28-180 · S/N 28-4993Built 1968 · Huff Glenn N N701CLLifer Craig VANS RV-7A · S/N 70641Lifer Craig N738VTCessna TR182 · S/N R18200966Built 1979 · Strutin Millard Desmond N7425XCessna 172B · S/N 17247925Built 1960 · Lifer Craig N79147Cessna 172K · S/N 17257916Built 1969 · Donnelly Jennifer A N8218FCessna 150F · S/N 15064318Built 1966 · Del Rosario Jose N8488CAnderson Willard C SUPER ACRO SPORT · S/N 896-3-80Built 1981 · Binns Jeffrey N8564WPiper PA-28-235 · S/N 28-10076Built 1963 · Binns George E N87826Quinn-James VP-II · S/N 1Paffendorf George W N913BCVans RV-12 · S/N 120532Built 2013 · Connelly Brent J N9227JPiper PA-28-180 · S/N 28-3297Built 1966 · Binns George E N9530VMooney M10 · S/N 700020Built 1970 · Peter Giller Aer LLC N9868GCessna 172L · S/N 17259768Built 1971 · Hoff Brian A

Back to Hackettstown, NJ