OpenAirDocs.org
Concord, NH

Cancelled registrations · 54

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 = '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.

N6146NBeech A24 · S/N MA-367Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 1970 · Super III LLCN468CRRaymond A Fournier JDT 1400 · S/N 001Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Fournier Raymond AN40591Balloon Works FIREFLY 7 · S/N 7968Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1979 · Bailey Glen RN646TMMclam Theodore JR KIS TR-1 · S/N 74Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Mclam Theodore JrN2436UCessna 172D · S/N 17250036Cancelled Feb 6, 2017 · Built 1963 · Werren Carroll EN6878VMooney M20F · S/N 22-1271Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 1975 · Kerrville Co IncN8164MMonterio Bruce SPERROW HAWKE · S/N 62545Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 1998 · Monterio Bruce BN7164HBell 47G · S/N 1529Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Outfitters LimitedN39783Burkhart Grob Flugzeugbau G103 TWIN ASTIR · S/N 3805Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1983 · Franconia Soaring Assoc IncN5011NBell 206B · S/N 2590Cancelled Aug 29, 2013 · First renewal notice · Built 1979 · Piper East IncN7160TCessna 172A · S/N 46760Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1960 · Dorvillier William CN8480SCessna 182H · S/N 18256580Cancelled Mar 7, 2013 · Sale reported, canceled · Built 1965N4433CCessna 195A · S/N 16018Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1952 · Krizek OttoN45238Cessna 150M · S/N 15076798Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1975 · Robichaud Arthur DN27530Piper PA-31-350 · S/N 31-7852047Cancelled Sep 21, 2012 · Registration expired, pending cancellation · Built 1977 · Nichols Aviation IncN24841Daley B-8M · S/N D001Cancelled Sep 10, 2012 · Registration expired, pending cancellation · Built 1972 · Nemetz David WN3048FCessna 182J · S/N 18257148Cancelled Sep 5, 2012 · Sale reported, canceled · Built 1966N55118Piper PA-32-300 · S/N 32-7340101Cancelled Aug 23, 2012 · Revoked, canceled · Built 1973 · Jackson Jackie CN1012LLake LA-4 · S/N 255Cancelled Jul 19, 2012 · Registration expired, pending cancellation · Built 1960 · Als Air Service IncN9336UCessna 150M · S/N 15078285Cancelled Aug 5, 2011 · Exported to Canada · Built 1976 · Flying Squirrel Galactic LlN23983Beech C23 · S/N M-1925Cancelled Jun 27, 2011 · Registration pending, canceled · Built 1977N5293EAerostar International RX 8 · S/N RX8-3345Cancelled Nov 2, 2009 · Exported to Canada · Built 2001 · Jones Richard LN20049Piper J-2 · S/N 1849Cancelled Aug 7, 2009 · Registration revoked · Built 1937 · Leonard Ralph EN59415Bell 47G3B2A · S/N 6871Cancelled Jul 28, 2006 · Expired dealer · Built 1973 · Piper East IncN6377FAerostar International RAVEN S49A · S/N S49A-3114Cancelled Jul 27, 2006 · Exported to Canada · Built 1992 · Jones Richard LN230RHawker Siddeley HS.125 SERIES 700A · S/N NA0342Cancelled Oct 6, 2004 · Exported to South Africa · D & A Aircraft LLCN761XAAmerican AA-1 · S/N AA1-0306Cancelled Oct 17, 2001 · Built 1969 · Schlossnagle Gary LN628JFMooney M20M · S/N 27-0214Cancelled Jun 6, 2000 · Exported to Australia · Freese Matthew JN826EWCessna 550 · S/N 5500622Cancelled Dec 30, 1991 · Exported to Switzerland · Micron Leasing CorpN60132Beech 76 · S/N ME-109Cancelled Oct 8, 1985 · Mckerley Forrest DN6378APiper PA-38-112 · S/N 38-78A0402Cancelled Nov 17, 1981 · Exported to Canada · Piper East IncN7943JBell 47G-3B-2 · S/N 6805Cancelled Aug 20, 1980 · Sale reported · Built 1969N1815HPiper PA-28-140 · S/N 28-7725161Cancelled Oct 30, 1979 · Exported to Canada · Built 1977 · Wiggins Airways IncN1238HPiper PA-28-140 · S/N 28-7725138Cancelled Oct 19, 1979 · Exported to Canada · Built 1977 · Wiggins Airways IncN565TBeech D50E · S/N DH-315Cancelled Jan 6, 1975 · Ferns Flying Service IncN6749GCessna 150L · S/N 15072249Cancelled Mar 17, 1972 · Ferns Flying Service IncN7501KPiper PA-18 · S/N 18-215Cancelled Feb 25, 1971 · Built 1950 · Universal Packaging CorpN5778ACessna 172 · S/N 28378Cancelled Mar 19, 1959 · Exported to Canada · Ferns Flying Service IncN85431Aeronca 7AC · S/N 7AC-4171Cancelled Feb 23, 1956 · Hinz MelvinN39477Stinson 10A · S/N 8177Cancelled Oct 10, 1955 · Built 1941 · Martin William E - William E Martin Flying ServiceN6010KRepublic RC-3 · S/N 180Cancelled Jun 4, 1954 · Exported to Canada · M L Irving & Sons IncN1830NCessna 120 · S/N 12074Cancelled Oct 19, 1953 · Exported to Canada · Ferns Flying ServiceN1464EAeronca 7AC · S/N 7AC-5027Cancelled Oct 5, 1953 · Exported to Canada · Built 1946 · Fern Flying ServiceN2750NCessna 120 · S/N 13008Cancelled Oct 2, 1953 · Exported to Canada · Rodd Harry MN89441Cessna 140 · S/N 8473Cancelled May 22, 1952 · Fine Bryd SaylorN90169Cessna 120 · S/N 9234Cancelled May 15, 1952 · Ferns Flying ServiceN69485Cessna T-50 · S/N 1634Cancelled Dec 11, 1950 · Ferns Flying ServiceN889WMarston & Oroway SPORT · S/N 1Cancelled Feb 15, 1937 · Marston Cj Ordway Pw & Gibson FiN1148Waco ASO · S/N 818Cancelled Apr 16, 1932 · New Hampshire Aviation CorpN4142Fairchild KR-31 · S/N 132Cancelled Apr 16, 1932 · Built 1928 · Tremblay Leo L
Back to Concord, NH