OpenAirDocs.org
Rocky Mount, NC

Cancelled registrations · 47

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 = 'NC' AND d.registrant_city = 'ROCKY MOUNT'
  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.

N38744Piper J3F-65 · S/N 7221Cancelled Jan 24, 2020 · Revoked, canceled · Built 1941 · Rocky Mount Dust & Spray Co IncN22007Luscombe 8 · S/N 857Cancelled Oct 25, 2019 · Revoked, canceled · Built 1938 · Avalon Air SvcN87735Piper J3C-65 · S/N 15394Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Rocky Mount Air Svc IncN4143MPiper PA-12 · S/N 123042Cancelled Apr 5, 2018 · Revoked, canceled · Built 1947 · Broadfield Frances TN6043HPiper J3C-65 · S/N 19188Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Outlaw Virgil LeeN6506PPowrachute PC 2000 · S/N A219 POWCancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 2000 · Pickering Charles HN85296Aeronca 7AC · S/N 7AC4034Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Rocky Mount Air Svc IncN5027ZPiper PA-22-108 · S/N 22-8642Cancelled Mar 21, 2013 · Registration expired, pending cancellation · Built 1961 · Urquhart Lewis TN7931RBeech V35A · S/N D-8953Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1969N17941Schweizer SGS 2-33A · S/N 293Cancelled Aug 13, 2012 · Registration expired, pending cancellation · Built 1973 · Stahl Lawrence EN808GMCessna 182T · S/N 18282076Cancelled Nov 4, 2011 · Exported to Australia · Built 2008 · Air Care IncN2940MPiper PA-12 · S/N 12-1339Cancelled Jul 24, 2009 · Registration revoked · Built 1946 · Rocky Mount Air Service IncN2489WSchweizer SGS 2-33 · S/N 42Cancelled Jul 14, 2009 · Registration revoked · Built 1967 · Stahl Lawrence EN1251CCessna T182T · S/N T18208407Cancelled Jul 7, 2009 · Exported to Canada · Built 2005N7716VAero Commander CALLAIR A-9 · S/N 1468Cancelled Jan 15, 2004 · Triennial form undeliverable · Built 1969 · Rocky Mount Aerial Applicators IncN74LVBeech B200 · S/N BB1074Cancelled Feb 9, 1994 · Triennial form not returned · Franchise Enterprises IncN316MHCessna 421B · S/N 421B0327Cancelled Oct 27, 1992 · Triennial form not returned · Texfi Industries IncN44ACPiper PA-23-250 · S/N 27-2674Cancelled Nov 5, 1982 · Air Care IncN9310TPiper PA-38-112 · S/N 38-78A0020Cancelled Sep 23, 1982 · Administratively canceled · Air Care IncN9794PPiper PA-25-235 · S/N 25-7556107Cancelled Apr 4, 1980 · Exported to Canada · Air Care IncN9165TPiper PA-25-235 · S/N 25-7856017Cancelled Apr 12, 1979 · Exported to Turkey · Air Care IncN6687QSchweizer G-164B · S/N 204BCancelled May 1, 1978 · Exported to United Kingdom · Built 1977 · Air Care IncN70158Cessna A188B · S/N 18801852TCancelled Sep 16, 1977 · Exported to Australia · Air Care IncN54927Piper PA-25-235 · S/N 257656066Cancelled May 3, 1977 · Exported to United Kingdom · Air Care IncN54976Piper PA-18-150 · S/N 187709028Cancelled Mar 9, 1977 · Exported to United Kingdom · Air Care IncN54893Piper PA-25-235 · S/N 257656038Cancelled Feb 25, 1977 · Exported to United Kingdom · Air Care IncN82336Piper PA-25-235 · S/N 25-7656083Cancelled Dec 30, 1976 · Exported to United Kingdom · Built 1976 · Air Care IncN82341Piper PA-25-235 · S/N 25-7656088Cancelled Dec 30, 1976 · Exported to United Kingdom · Built 1976 · Air Care IncN54918Piper PA-25-235 · S/N 257656059Cancelled Nov 3, 1976 · Exported to United Kingdom · Air Care IncN54926Piper PA-25-235 · S/N 257656065Cancelled Nov 3, 1976 · Exported to United Kingdom · Air Care IncN21627Cessna A188B · S/N 18800918Cancelled May 17, 1976 · Air-Care IncN44092Piper PA-28-151 · S/N 28-7415579Cancelled May 11, 1976 · Exported to Canada · Built 1974 · Air Care IncN7472LPiper PA-18-150 · S/N 18-7509068Cancelled Jul 31, 1975 · Exported to Canada · Air Care IncN8409VAero Commander 560-A · S/N 1609Cancelled May 24, 1973 · Air Ag IncN9486KStinson 108-2 · S/N 108-2486Cancelled May 20, 1965 · Starling Leonard B JrN82676Aeronca 7AC · S/N 7AC-1319Cancelled Jun 24, 1964 · Broadfield Frances TN2150MPiper J3C-65 · S/N 20935Cancelled Feb 29, 1956 · Frank R HallN98199Piper J3C-65 · S/N 18359Cancelled Feb 27, 1956 · Rocky Mount Air ServiceN97308Stinson 108 · S/N 108-308Cancelled Aug 3, 1955 · Built 1946 · Rocky Mount Air ServiceN92240Piper J3C-65 · S/N 16685Cancelled Feb 7, 1955 · Broadfield Frances TN92190Piper J-3 · S/N 16630Cancelled Aug 16, 1954 · Breadfield Frances TN70774Piper J3C-65 · S/N 17795Cancelled Oct 3, 1952 · Rocky Mount Air ServiceN4016MPiper PA-12 · S/N 12-2894Cancelled Jun 7, 1950 · Rocky Mount Air ServiceN5219Ryan B1 · S/N 107Cancelled Mar 12, 1948 · Lee Robert EdwardN67YBrodgen Ralph G FLYING FLEA · S/N 1-BCancelled Jun 1, 1938 · Brodgen Ralph GN7480Standard J-1 · S/N 222Cancelled Aug 31, 1934 · Williams C GN1831American Eagle A-1 · S/N 59Cancelled Feb 3, 1933 · Built 1927 · Byrd John Franklin
Back to Rocky Mount, NC