Cherry Hill, NJ
Registered aircraft · 31
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 = 'CHERRY HILL' 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 = 'CHERRY HILL' 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.
N122GCS C Aerostar S A YAK-52 · S/N 9611911N123MKPiper PA-24-400 · S/N 26-141N13ENBeaird Ben E RV-6A · S/N 22426N14297Cessna 182T · S/N 18281715N1816TPiper PA-28-140 · S/N 28-7125173N1903VCessna 140 · S/N 14094N20420Cessna 172M · S/N 17261275N24500Piper J3L-65S · S/N 3233N2545RCessna 182K · S/N 18258245N3463NMooney M20F · S/N 680061First renewal noticeN3467ZPiper PA-22-150 · S/N 22-7391N353RGBeech D35 · S/N D-3551N3575KPiper PA-32R-301 · S/N 32R-8013037N3925KPiper PA-28-140 · S/N 28-23797N43813Piper PA-28-161 · S/N 28-8516017N44813Piper PA-32-300 · S/N 32-7540006N4954FPiper PA-28-151 · S/N 28-7715086N495TGerlach Quentin RV8 · S/N 81805N5118ACessna 172 · S/N 28118N5296TPiper PA-34-200 · S/N 34-7250244N5471RCessna 172F · S/N 17253031N555TWPiper PA-28-180 · S/N 28-7305578N5589UPiper PA-28-140 · S/N 28-26320N56904Mooney M20J · S/N 24-1407N5811CMooney M20J · S/N 24-1546N5839SBeech S35 · S/N D-7736N5889VPiper PA-28-181 · S/N 28-7790507Registration pendingN7549XCessna 172B · S/N 17248049N8632YPiper PA-30 · S/N 30-1773N9378VMooney M20F · S/N 700016N98968Mooney M20K · S/N 25-0542
Back to Cherry Hill, NJ