OpenAirDocs.org
Frederick, OK

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 = 'OK' AND d.registrant_city = 'FREDERICK'
  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.

N2163UBrantly B-2B · S/N 324Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 1963 · Proffesional Pilot Service IncN9069HBrantly B-2B · S/N 1Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1953 · Brantly Hynes Helicopter IncN8513LRaven S55A · S/N S55A-218Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1974 · Maxwell Robert NN8957DPiper PA-22-160 · S/N 22-6120Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1958 · Ripley Jimmy CN5937XBrantly B-2 · S/N 75Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1961 · Brantly Hynes Helicopter IncN501BHBrantly B-2B · S/N 501Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1975 · Brantly Hynes Helicopter IncN4986CBrantly B-2A · S/N 21Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1957 · Brantly Hynes Helicopter IncN6139PPiper PA-24-250 · S/N 24-1240Cancelled Aug 5, 2013 · Revoked, canceled · Built 1959 · Stovall Clifford LN2197UBrantly B-2B · S/N 408Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1964 · Professional Pilot Service IncN5921XBrantly B-2 · S/N 57Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Hynes Helicopter IncN62193Timberlake B-8MV · S/N 1Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1974 · Timberlake Bill RN5903XBrantly B-2 · S/N 38Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1960 · Brantly Hynes Helicopter IncN511RBrantly B-2 · S/N 14Cancelled Sep 10, 2012 · Sale reported, pending cancellation · Built 1961N215NAmerican Eagle A101 · S/N 724Cancelled Aug 10, 2012 · Sale reported, canceled · Built 1931N2220UBrantly 305 · S/N 1033Cancelled Aug 10, 2012 · Sale reported, canceled · Built 1966N2118UBrantly B-2 · S/N 166Cancelled Aug 9, 2012 · Sale reported, canceled · Built 1962N2177UBrantly B-2B · S/N 339Cancelled May 11, 2012 · Sale reported, pending cancellation · Built 1963N5978XBrantly B-2 · S/N 121Cancelled Mar 10, 2011 · Expired dealer · Built 1961 · Brantly Helicopter CorpN3277Deboer B-8M · S/N 007Cancelled May 27, 1981 · Built 1969 · Koppler Doit LN5970XBrantly B-2 · S/N 112Cancelled Apr 12, 1978 · Exported to Greece · Brantley Hynes HelicopterN44830Naval Aircraft Factory N3N-3 · S/N 2642Cancelled Mar 29, 1974 · Stone Eual E Et AlN45005Naval Aircraft Factory N3N-3 · S/N 2908Cancelled Mar 29, 1974 · Stone Eual E Et AlN5122NTaylorcraft DC-65 · S/N 6128Cancelled Oct 7, 1970 · Built 1942 · David BenN2202UBrantly 305 · S/N 1002Cancelled Jan 26, 1970 · Brantly Helicopter CorpN4985CSnow S2A · S/N 1028Cancelled May 20, 1965 · Oxford SheltonN2126UBrantly B-2 · S/N 174Cancelled May 19, 1965 · Brantly Helicopter CorpN2185UBrantly B-2B · S/N 347Cancelled Mar 16, 1964 · Exported to Venezuela · Brantly Helicopter CorpN2184UBrantly B-2B · S/N 346Cancelled Feb 17, 1964 · Exported to Germany · Brantly Helicopter CorpN2168UBrantly B-2B · S/N 330Cancelled Sep 16, 1963 · Brantly Helicoper CorpN2199UBrantly B-2B · S/N 319Cancelled Sep 11, 1963 · Exported to United Kingdom · Brantly Helicopter CorpN2145UBrantly B-2 · S/N 196Cancelled Feb 27, 1963 · Exported to Germany · Brantly Helicopter CorpN6792DBrantly B-2 · S/N 13Cancelled Dec 14, 1962 · Great Southwest Helicopter CorpN5993XBrantly B-2 · S/N 137Cancelled Jun 20, 1962 · Brantley Helicopter CorpN2107UBrantly B-2 · S/N 153Cancelled May 16, 1962 · Exported to Finland · Built 1961 · Brantley HelicopterN2117UBrantly B-2 · S/N 165Cancelled May 16, 1962 · Exported to United Kingdom · Built 1962 · Brantly Helicopter CorpN2122UBrantly B-2 · S/N 170Cancelled May 16, 1962 · Exported to United Kingdom · Built 1962 · Brantly Helicopter CorpN2123UBrantly B-2A · S/N 171Cancelled May 16, 1962 · Exported to United Kingdom · Built 1962 · Brantly Helicopter CorpN2116UBrantly B-2 · S/N 164Cancelled Mar 27, 1962 · Exported to Germany · Built 1962 · Brantley Helicopter CorpN5927XBrantly B-2 · S/N 65Cancelled Mar 31, 1961 · Exported to Argentina · Brantley Helicopter CorpN5910XBrantly B-2 · S/N 46Cancelled Oct 4, 1960 · Brantly Helicopter CorpN59692Consolidated Vultee BT-13A · S/N 7448Cancelled Mar 8, 1956 · Edwin ColeyN4606NConsolidated Vultee BT-13B (SNV-2) · S/N 79-384Cancelled Nov 15, 1955 · Mitchell L EN8464KStinson 108-1 · S/N 108-1464Cancelled Sep 10, 1953 · Fry J GlennN75706Cessna T-50 · S/N 2902Cancelled Mar 18, 1952 · Exported to Mexico · Frederick Flying ServiceN54479Ryan Aeronautical ST3KR · S/N 2044Cancelled Apr 17, 1951 · Built 1942 · Walker Jimmy GN4601NBoeing N2S-3 · S/N 75-7074Cancelled Oct 17, 1950 · Akin Hugh LN4605NBoeing N2S-4 · S/N 75-3255Cancelled Dec 29, 1949 · Jones Melton A And Jones Julius CN54497Fairchild M-62A · S/N T41-1024Cancelled Nov 15, 1949 · Built 1941 · Walker Jimmy G DBAN75740Cessna AT-17E · S/N 2091Cancelled May 13, 1949 · Frederick Flying ServiceN616VParks P-1 · S/N 19912Cancelled Jul 17, 1941 · Perkins Bud
Back to Frederick, OK