Concord, MA
Cancelled registrations · 50
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 = 'MA' AND d.registrant_city = 'CONCORD' 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 = 'MA' AND d.registrant_city = 'CONCORD' 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.
N117DLBell Helicopter Textron 212 · S/N 31165N770MSBombardier CL-600-2B16 · S/N 5491N930MVSocata TBM 700 · S/N 1136N164RXLearjet 45 · S/N 45-207N6PCGulfstream Aerospace G-IV · S/N 1247N630AOpus SUPER 2 · S/N J-017N682JBCirrus Design SR22 · S/N 2581N629WYPilatus PC-12/47E · S/N 1495N981TSBombardier BD-700-1A10 · S/N 9281N519PSStemme S10-VT · S/N 11-076N50EEGulfstream Aerospace G-IV (G400) · S/N 1500N956STEurocopter Deutschland MBB-BK 117 C-2 · S/N 9156N129TTBeech B200 · S/N BB-1078N549LRRaytheon Corporate Jets HAWKER 1000 · S/N 259049N402LMIsrael Aircraft Industries GULFSTREAM 200 · S/N 082N14GJRobinson Helicopter R44 · S/N 10305N575EHSikorsky S-76A · S/N 760366N375PAEurocopter Deutschland EC 135 P2+ · S/N 0479N360SHEurocopter AS 350 B2 · S/N 1230N621LATextron 680A · S/N 680A-0021N584NGPilatus PC-12/47E · S/N 1584N7016QPiper PA-44-180 · S/N 4496387N27GDRobinson Helicopter R44 · S/N 2058N38GDRobinson Helicopter R44 II · S/N 13592N7016ZPiper PA-44-180 · S/N 4496390N71592Textron 208B · S/N 208B5255N968AGTextron 680A · S/N 680A0018N55353Textron 172S · S/N 172S11627N5535XTextron 172S · S/N 172S11620N880TVEurocopter Deutschland EC 135 P2+ · S/N 0880N212BEBeechcraft B200GT · S/N BY-212N87GMRaytheon 58 · S/N TH1878N9941YCessna 210N · S/N 21064644N247WWPiper PA-42 · S/N 428001011N305JARaytheon HAWKER 800XP · S/N 258625N420GLDassault-Breguet FALCON 20 · S/N 391N77TZCessna 208 · S/N 20800148N257CGRaytheon B200 · S/N BB-1739N66SBBeech A36 · S/N E-921N4477CCessna 195 · S/N 16061N3176GBeech F33A · S/N CE1271N8736VBellanca 7GCBC · S/N 84775N64049Cessna 172M · S/N 17264987N6845JPiper PA-28-151 · S/N 28-7615374N2412TNavion NAVION G · S/N NAV4-2412N2799SPiper PA-23-250 · S/N 27-4568N2451NCessna 120 · S/N 12704N8427GCessna 150F · S/N 15062527N3755JCessna 150G · S/N 15065055N1700MBoeing A75N1 · S/N 758670
Back to Concord, MA