Manchester, NH
Registered aircraft · 33
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 = 'NH' AND g.registrant_city = 'MANCHESTER' 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 = 'NH' AND g.registrant_city = 'MANCHESTER' 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.
N100ARCessna 560XL · S/N 560-5241N130AHEurocopter EC 130 B4 · S/N 3862N178DBPiper PA 46-350P · S/N 4636333N216DKCirrus Design SR20 · S/N 2150N22EUHoltaway Robert F VELOCITY V-TWIN · S/N VT005N280SMEnstrom 280FX · S/N 2083N289HRPiper PA-32-300 · S/N 32-7640044N2964TAero Commander 200D · S/N 337N2992HEnstrom 280FX · S/N 2104Sale reported, canceledN31SFCirrus Design SF50 · S/N 0177N32NNGrumman American Avn. AA-5B · S/N AA5B-0602N33371Piper PA-28-180 · S/N 28-7505137N4213TPiper PA-28-180 · S/N 28-7205100N50688Cessna 150J · S/N 15069485N529KGDassault FALCON 2000EX · S/N 292N56DKEnstrom Helicopter 480B · S/N 5127N603BSBell Textron Canada 407 · S/N 54961N603NETextron 680A · S/N 680A0103N63TGGallo Anthony F THATCHER CX4B · S/N 385N683UFBombardier CL-600-2B16(CL-604) · S/N 5734N688DWCessna 172R · S/N 17280949N6DKEmbraer Executive EMB-505 · S/N 50500711N72WMMurfit Wallace G CHRISTEN EAGLE II · S/N 6746N7338VBellanca 17-30 · S/N 30230N7777WPiper PA-28-180 · S/N 28-1781N78KNGulfstream Aerospace GVII-G500 · S/N 72072N8132BPiper PA-28-181 · S/N 28-8090164N844XLaminar Research LANCAIR EVOLUTION · S/N EVO-030N8788CPiper PA-28R-200 · S/N 28R-7635182N9117BCessna 172 · S/N 36617N94855Ercoupe E · S/N 4979N97UBBalloon Works FIREFLY 8B-15 · S/N F8B-534N9849QCessna 172M · S/N 17265793
Back to Manchester, NH