Manchester, NH
Cancelled registrations · 80
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'NH' AND d.registrant_city = 'MANCHESTER' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'NH' AND d.registrant_city = 'MANCHESTER' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
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.
N194WABeech 99 · S/N U64N195WABeech 99 · S/N U-38N193WABeech 99 · S/N U-17N68GMGeorge F May BD6 · S/N BD6101N972DSAirborne Windsports PTY EDGE XT-912-L · S/N XT-912-0364N1815SBeech 77 · S/N WA-284N5595CCessna 170B · S/N 19649N9157DPiper PA-22-160 · S/N 22-6209N24ANEmbraer EMB-110P2 · S/N 110318N85190Aeronca 7AC · S/N 7AC-3922N8137WPiper PA-28-180 · S/N 28-2250N7223HPiper J-3C · S/N 20492N198WABeech 99A · S/N U142N19735Cessna 172L · S/N 17260709N804BABeech 99A · S/N U-83N6788Grumman Aircraft ENG C-1A · S/N 136788N9388CCessna 180 · S/N 31786N519FLPiper PA-28-140 · S/N 28-7125470N625RBeech C-50 · S/N CH-166N2729BAero Commander 560 · S/N 229N504GHNorth American T-28B · S/N 138140N199WABeech B-99 · S/N U-154N148PMFokker F.27MK 100 · S/N 10.108N8964SCessna 150F · S/N 15062264N7DKCessna 207 · S/N 20700371N2739SCessna 150G · S/N 15066639N4323GPiper PA-46-310P · S/N 46-8408020N54MSMcculloch G James MONERAI-S · S/N 0006N9487CPiper PA-28R-201 · S/N 28R-7837201N7344ACessna A150M · S/N A1500723N6710YBeech C23 · S/N M-2249N8987SCessna 150F · S/N 15062287N95123Taylorcraft BC12-D · S/N 9523N8908JPiper PA-28-180 · S/N 28-2887N1306HPiper PA-28-161 · S/N 28-7716014N4767ECessna 172N · S/N 17271632N5158KRyan NAVION · S/N NAV-4-2058BN41FJArnold Finn A GLASAIR SH-2 · S/N 269N27201Piper PA-31-350 · S/N 31-7752081N63955Cessna T-50 · S/N 3707N28086Bellanca 17-30A · S/N 79-30929N1180Cirrus Design SR20 · S/N 1576N9101Beech J35 · S/N D-5498N656WADehavilland DHC-6 TWIN OTTER · S/N 47N8707EPiper PA-28-151 · S/N 28-7615150N2239XLee John R TEENIE TWO · S/N 15-2505N8182APiper PA-28-161 · S/N 28-8016296N86BWSmith AEROSTAR 601P · S/N 61P0468185N6937ECessna 175A · S/N 56437N36033Balloon Works FIREFLY 7-B · S/N F7B053
Back to Manchester, NH