Hillsborough, NJ
Registered aircraft · 37
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 = 'HILLSBOROUGH' 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 = 'HILLSBOROUGH' 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.
N12968Cessna 172M · S/N 17262413N12DXCaliendo Thomas J RANS S-12S AIRAILE · S/N 01030958N1424VCessna 172M · S/N 17263569N1959HPiper PA-28-181 · S/N 28-7790361N19777Cessna 172L · S/N 17260744N19880Cessna 177B · S/N 17702610N20811Cessna 172M · S/N 17263843N212VBSchempp-Hirth DISCUS-2B · S/N 75N2191LPiper PA-28RT-201 · S/N 28R-7918031N266LCPiper PA-30 · S/N 30-1157N325RRobert M Gaspar S-16 SHEKARI · S/N 0699020N3459RCessna 182L · S/N 18258759N35069Cessna 177B · S/N 17702187N355CWCessna T206H · S/N T20608817N35623Cessna 172I · S/N 17256869N363SRCirrus Design SR22 · S/N 2226N3728RCessna 172H · S/N 17255528N37397Interstate S-1A · S/N 311N41903Piper PA-28R-200 · S/N 28R-7435224N420SECirrus Design SR22 · S/N 2293N4222LCessna 172G · S/N 17254291N5440LGrumman American Avn. AA-5 · S/N AA5-0340N563DFPiper PA-28-181 · S/N 2881563N65716Cessna 172P · S/N 17275831N702PXPiper PA-46-701TP · S/N 46020002N7039MCessna 175 · S/N 55339N717LRCessna 421C · S/N 421C1109N7319GCessna 172K · S/N 17259019N771HEBeech A36 · S/N E-2325N78WAPiper PA-28R-201 · S/N 28R-7837077N79920Cessna 172K · S/N 17258248N811DGSchempp-Hirth VENTUS CM · S/N 45N81669Piper PA-28-161 · S/N 28-8016215N90CDCirrus Design SR22 · S/N 0939N9157MMooney M20R · S/N 29-0009N94348Ercoupe 415-C · S/N 1571N9MGGaciala Michael LANCAIR 320 · S/N 271-320-34
Back to Hillsborough, NJ