Newton, MA
Registered aircraft · 17
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 = 'MA' AND g.registrant_city = 'NEWTON' 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 = 'MA' AND g.registrant_city = 'NEWTON' 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.
N116FEIsrael Aerospace Industriesltd G200 · S/N 197N1249VPiper PA-23-250 (6PCLM) · S/N 27-7654046N143MWBombardier BD-700-1A10 · S/N 9109N248PKDiamond Aircraft Ind DA 40 NG · S/N 40.NC139N3216ABeech A36 · S/N E-2900N407JCBeech A36 · S/N E-2033N4ATCessna 550 · S/N 550-0805N50NLDassault FALCON 7X · S/N 276N51NLLeonardo AW169 · S/N 69036N5409RCessna 172M · S/N 17263537N606CTCirrus Design SR22 · S/N 4852N641TAmir Yacoby SPORTSMAN GS-2 · S/N 0007506N7158CPiper PA-28-181 · S/N 28-7690057N8367GCessna 150F · S/N 15062467N83FLCirrus Design SR22 · S/N 11340N922MHCirrus Design SR22 · S/N 1281N92331Cessna 182N · S/N 18260157
Back to Newton, MA