Lewes, DE

Cancelled registrations · 294

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 = 'DE' AND d.registrant_city = 'LEWES'
  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.

N4030XAero Commander 100-180 · S/N 5130Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 1971 · Gab Aviation LLCN58JJJackson Jacob J GP-4 · S/N 002Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 1991 · Papa Gulf Aero LLCN116SVCessna 172S · S/N 172S9815Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 2005 · Trns Solutions LLCN4698SNorth American T-28B · S/N 137706Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Ascent LLCN4412SPiper PA-34-220T · S/N 3449487Cancelled Oct 11, 2022 · Exported to Brazil · Built 2013 · Airtrade Aviation CorpN15349Piper PA-32-260 · S/N 32-7300005Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Built 1972 · Trn Aviation LLCN750TBCessna 550 · S/N 550-0579Cancelled Sep 14, 2022 · Built 1988 · Worldwide Option LLCN146BBMatt Mcswain JA30 SUPERSTOL · S/N JA335-12-13Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 2016 · Acme Aero LLCN280BPRyan NAVION · S/N NAV-4-2027Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 1950 · Acme Aero LLCN921CCRockwell International NA-265-65 · S/N 465-67Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 1981 · Sabre 67 IncN479AGCessna 421C · S/N 421C0612Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 1978 · Trn Aviation LLCN735TNCessna 182Q · S/N 18265672Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Built 1977 · Trn Aviation LLCN996JTHonda HA-420 · S/N 42000229Cancelled Apr 15, 2022 · Exported to San MarinoN220DMRobinson Helicopter R22 MARINER · S/N 0928Cancelled Apr 8, 2022 · Registration expired, pending cancellation · Built 1988 · Vessel Photo Helicopter LLCN1401FCessna 172H · S/N 17254896Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Samoht LLCN857PFWsk-Mielec AN-2 · S/N 1G10857Cancelled Feb 15, 2022 · Registration pending, canceledN62478Piper PA-23-250 · S/N 27-7654006Cancelled Jan 3, 2022 · Sale reported, canceled · Built 1975N917LEIsrael Aircraft Industries 1124A · S/N 400Cancelled Dec 13, 2021 · Exported to San Marino · Built 1983 · Iai Aircraft Leasing LLCN269AGNanchang China CJ-6A · S/N 3532007Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1979 · Delane-Air LLCN756FDCessna R182 · S/N R18201060Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1979 · Roonaviation IncN9769NCessna U206A · S/N U2060494Cancelled Oct 4, 2021 · Exported to Canada · Built 1966 · Bravo Hotel LLCN703RTCessna 500 · S/N 500-0114Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Built 1973 · Neron II LLCN11874Cessna 150L · S/N 15075678Cancelled Sep 14, 2021 · Exported to Mexico · Built 1974 · Sky King Aeronautics IncN970RPCessna 500 · S/N 500-0270Cancelled Aug 3, 2021 · Registration expired, pending cancellation · Built 1975 · N970rp LLCN435RBBeech V35 · S/N D-8355Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1966 · Dah Aircraft LLCN121DLPiper PA-28-161 · S/N 28-8016115Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Built 1979 · Global Aero Aircraft LLCN1059UPiper PA-34-200 · S/N 34-7250043Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Built 1971 · Baas Holdings LLCN37971Gates Learjet 25D · S/N 358Cancelled Apr 17, 2021 · Non-citizen corporation, flight hours not reported · Built 1982 · Lincoln Investment Holdings IncN50VJMoravan ZLIN Z50 LS · S/N 0048Cancelled Apr 17, 2021 · Non-citizen corporation, flight hours not reported · Built 1978 · Lumilipad CorpN306SKCessna 404 · S/N 404-0131Cancelled Apr 9, 2021 · Exported to Turks and Caicos Islands · Built 1977 · Calypso Aircraft IncN18416Stinson SR-9C · S/N 5318Cancelled Mar 6, 2021 · Sale reported, canceled · Built 1937N4432BPiper PA-32RT-300T · S/N 32R-7887174Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Roonaviation IncN969JMCirrus Design SR22T · S/N 0714Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 2014 · Martin Aviation LLCN200DZBeech A200 · S/N BC-58Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Bradco IncN420JCGulfstream Aerospace G-1159A · S/N 326Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Built 1981 · N420jc IncN8108GCessna T310Q · S/N 310Q1047Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Built 1974 · Ebi Flight LLCN104CJWsk-Pzl Mielec MIG-15 UTI (LIM2) · S/N 1A01004Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 1952 · Warbird Airshow Flying Services IncN1958QCessna 177RG · S/N 177RG0358Cancelled Sep 21, 2020 · Built 1973 · 1310q LLCN62769Piper PA-23-250 · S/N 27-7754010Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Built 1976 · Kingdom Airways LLCN6556KCessna 172P · S/N 17274212Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Built 1980 · Global Aircraft Acquisitions LLCN897KCDiamond Aircraft Ind DA 40 · S/N 40.897Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Built 2008 · Aeroworld Aircraft IncN660WCCessna 210L · S/N 21061027Cancelled Aug 3, 2020 · Exported to Bolivia · Built 1975 · Fast Track Flight LLCN25328Fairchild 24W-40 · S/N W40-114Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1940 · Aeroworld Aircraft IncN2452ABeech V35A · S/N D-9047Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 1969 · Global Aircraft Acquisitions LLCN54793Piper PA-23-250 · S/N 27-7554095Cancelled May 23, 2020 · Sale reported, canceled · Built 1975N290VPCessna 550 · S/N 550-0090Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 1979 · N818rj LLCN2367RPiper PA-28-180 · S/N 28-5498Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Built 1969 · Baxnav Flight LLCN556JSReims CESSNA F172G · S/N 0197Cancelled Mar 3, 2020 · Exported to Russia · Itb Sokolowski LLCN911DSCessna P210N · S/N P21000787Cancelled Mar 3, 2020 · Exported to Russia · Built 1981 · Itb Sokolowski LLCN302TCPiper PA-31-325 · S/N 31-7912033Cancelled Jan 31, 2020 · Exported to Mexico · Built 1979 · Trn Aviation LLC
Back to Lewes, DE