OpenAirDocs.org
Laconia, NH

Cancelled registrations · 31

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

N3873YBeech 77 · S/N WA-265Cancelled May 31, 2023 · Built 1981 · Gillett Drew AN57849Boeing A75 · S/N 75-035Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Built 1942 · Volpe ThomasN1013MBoeing A75N1(PT17) · S/N 75-5014Cancelled Jan 3, 2020 · Registration expired, pending cancellation · Built 1943 · Volpe ThomasN42383Piper J3C-65 · S/N 14640Cancelled May 6, 2019 · Registration expired, pending cancellation · Built 1945 · Volpe ThomasN2569PPiper PA-22-150 · S/N 22-2932Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 1955 · Volpe H ThomasN6106TCessna 150E · S/N 15060806Cancelled Mar 12, 2015 · Third renewal notice · Built 1964 · Lumpkins Warren RN96GLGaar J L/Gaar N E ROTORWAY EXEC · S/N 3233Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1988N7453PPiper PA-24-250 · S/N 24-2642Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1961 · Sayles RobertN580HEnstrom F-28C · S/N 375Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Copters Unlimited IncN6687LLake LA-4-200 · S/N 450Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1971N4385Aero Commander 560-F · S/N 560F-1213-47Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 1962 · Business Jets International IncN602PCPiper AEROSTAR 602P · S/N 62P08618165002Cancelled Sep 21, 2012 · Registration expired, pending cancellation · Built 1981 · Kovach Robert LN6146VConsolidated Aeronautics LAKE LA-4-210 · S/N 803Cancelled Jul 20, 2011 · Expired dealer · Built 1977 · Lake New England IncN1049LLake LA-4-200 · S/N 642Cancelled Jun 28, 2011 · Sale reported, canceled · Built 1974N8548WAerofab LAKE 250 · S/N 106Cancelled Apr 25, 2011 · Expired dealer · Built 1990 · Lake Aircraft North IncN550MKCessna A185F · S/N 18502171Cancelled Feb 16, 2005 · Exported to Canada · Built 1973 · Kleinheinz Michael RN14019Aerofab LAKE LA-250 · S/N 14Cancelled Jan 30, 2002 · Built 1984 · Lake Aircraft IncN7073UTyler George P FW2C80TR CAPELLAXSTR · S/N GT-2Cancelled Sep 27, 1999 · Triennial form not returned · Tyler George PN8551RAerofab LAKE 250 · S/N 128Cancelled Dec 30, 1993 · Exported to Peru · Lake Aircraft IncN8427PAerofab LAKE LA-250 · S/N 95Cancelled Oct 30, 1991 · Exported to Brazil · Lake Aircraft IncN85518Aerofab LAKE SEAWOLF · S/N SW104Cancelled Sep 19, 1991 · Lake Aircraft IncN8552AAerofab LAKE SEAWOLF · S/N SW105Cancelled Sep 19, 1991 · Lake Aircraft IncN8552HAerofab LAKE SEAWOLF · S/N SW106Cancelled Sep 19, 1991 · Lake Aircraft IncN28670Grumman American Avn. AA-5B · S/N AA5B-0743Cancelled Sep 5, 1980 · Exported to United Kingdom · Hangar One IncN6657LLake LA-4-200 · S/N 420Cancelled Jul 9, 1979 · Ferencz LaszloN1255LConsolidated Aeronautics LAKE LA-4-200 · S/N 753Cancelled Mar 27, 1979 · Exported to Canada · Lake New England IncN3430YCessna 180H · S/N 18051930Cancelled Apr 19, 1977 · Exported to Canada · Seaplane Services IncN666TBeech 95 · S/N TD-10Cancelled Jul 26, 1966 · Aviation Company Of New EnglandN18554Cessna C-37 · S/N 373Cancelled Feb 20, 1956 · Laconia Airways IncN1667EAeronca 7AC · S/N 7AC-5233Cancelled Nov 18, 1955 · Laconia Airways IncN93229Commonwealth 185 · S/N 1734Cancelled Jan 21, 1948 · Laconia Airways Inc
Back to Laconia, NH