OpenAirDocs.org
Tulsa, OK

Cancelled registrations · 1,071

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

N6078PPiper PA-24-250 · S/N 24-1174Cancelled May 4, 2019 · Revoked, pending cancellation · Built 1959 · Aircraft Company Of AmericaN5895GDJI PHANTOM 3 PROFESSION · S/N P76DCE18010230Cancelled Apr 19, 2019 · Registration expired, pending cancellation · Press Pause Films LLCN8733WPiper PA-28-235 · S/N 28-10273Cancelled Apr 5, 2019 · Exported to Mexico · Dan Howard Aircraft Sales LLCN6618BCessna T210M · S/N 21062799Cancelled Mar 19, 2019 · Exported to Mexico · Built 1978 · Cottonwood Aviation LLCN617YQDJI PHANTOM 2 VISION + · S/N PH645374569Cancelled Mar 12, 2019 · Registration expired, pending cancellation · Professional Aerial Services LLCN7853XCessna 172B · S/N 17248353Cancelled Feb 19, 2019 · Revoked, canceled · Built 1961 · Executive Flight IncN75503Consolidated Vultee BT-13B (SNV-2) · S/N 791110Cancelled Feb 9, 2019 · Revoked, canceled · Built 1944 · Smedley Bobby RN46973Fairchild M-62A · S/N 10404AECancelled Dec 28, 2018 · Revoked, canceled · Built 1943 · Miller Lloyd AN5093NFairchild M-62A · S/N 433372Cancelled Dec 15, 2018 · Revoked, canceled · Adams Walter DN390TLelmco ANSEL 1 · S/N 64008091Cancelled Dec 7, 2018 · Revoked, canceled · Built 1965 · Le Leon Mfg Co IncN128GGibson Mong Sport MS-2 · S/N W0G-1Cancelled Dec 6, 2018 · Revoked, pending cancellation · Built 1962 · Lotero RobertN35027Avcat AV-2 · S/N 6857Cancelled Dec 4, 2018 · Registration expired, pending cancellation · Built 2006 · Daywalt Clark LN269DKS C Aerostar S A YAK-52TW · S/N 0112231Cancelled Oct 29, 2018 · Exported to Australia · Built 2001 · I Fly Planes LLCN2281BLuscombe 8A · S/N 6708Cancelled Oct 27, 2018 · Revoked, pending cancellation · Built 1949 · Fitzgerald E JN61RHNorth American NA-265-40 · S/N 282-27Cancelled Oct 1, 2018 · Sale reported, canceled · Built 1965N3516QCessna 188 · S/N 188-0466Cancelled Jul 19, 2018 · Revoked, canceled · Built 1968 · Trans Continent Aviation IncN664MFlight Design CTSW · S/N 06-03-04Cancelled Jul 16, 2018 · Exported to Canada · Built 2006 · Airtime Aviation IncN2356FCessna 210E · S/N 21058556Cancelled Jul 11, 2018 · Exported to Paraguay · Built 1964 · Dan Howard Aircraft Sales LLCN29741Taylorcraft BC12-65 · S/N 2587Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1941N218TTBoeing 727-214 · S/N 19684Cancelled Jun 19, 2018 · Tulsa Technology Center School District No 18N6870NMooney M20C · S/N 680148Cancelled Jun 19, 2018 · First renewal notice · Built 1968 · Robert W Brinkley Do Inc PcN63845Bell UH-1H · S/N 65-09580Cancelled May 31, 2018 · Sale reported, canceledN770MBBryden Matthew B GLASAIR SH-2F · S/N 770Cancelled May 31, 2018 · Sale reported, canceledN2172SCessna T210L · S/N 21061133Cancelled May 30, 2018 · Sale reported, canceled · Built 1975N3781SHappy Valley Flight TUKAN · S/N 014Cancelled May 30, 2018 · Sale reported, canceled · Built 1995N6114ACessna T210N · S/N 21063499Cancelled May 3, 2018 · Exported to Mexico · Built 1979 · Dan Howard Aircraft Sales LLCN7522QCessna 310Q · S/N 310Q0022Cancelled Apr 11, 2018 · Built 1970 · Momquist Christopher DN8169DBeech G35 · S/N D-4864Cancelled Apr 6, 2018 · Revoked, canceled · Built 1956 · Reaves & Harris EnterprisesN44375Taylorcraft BF · S/N 10175Cancelled Apr 5, 2018 · Revoked, canceled · Built 1946 · Hodge TeddyN64748Consolidated Vultee BT-13A · S/N 6595Cancelled Apr 5, 2018 · Revoked, canceled · Built 1942 · Payne L IN81032Grumman American Avn. AA-5B · S/N AA5B0397Cancelled Mar 30, 2018 · Registration expired, pending cancellation · Built 1976 · Steeper Thomas PN856JTMitsubishi MU-2B-25 · S/N 306Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 1974 · Anasazi Winds LLCN71EGCessna 210C · S/N 21058104Cancelled Mar 19, 2018 · Registration expired, pending cancellation · Built 1962 · Bryan VincentN3511UHarris Roy/Private Acft Works LOW RIDER ST · S/N 077779Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 1997 · Harris Roy GN3342PPiper PA-23-160 · S/N 23-1295Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Spartan Education LLCN949EBBritish Aerospace HS 125-700A · S/N 257028Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Spartan Education LLCN87781Piper J3C-65 · S/N 15439Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1946 · Jarrett Timothy LewisN549FLPiper PA-28-140 · S/N 28-7125386Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1971 · Spartan Education LLCN6220RCessna 172RG · S/N 172RG0120Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1979 · Spartan Education LLCN6308VCessna 172RG · S/N 172RG0616Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1980 · Spartan Education LLCN4924HCessna 152 · S/N 15284023Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Built 1979 · Spartan Education LLCN5243UCessna 172RG · S/N 172RG0296Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Built 1980 · Spartan Education LLCN2837ZPiper PA-22-150 · S/N 22-6832Cancelled Mar 2, 2018 · Registration expired, pending cancellation · E-Commerce Education FoundationN68725Cessna 152 · S/N 15282338Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Built 1978 · Spartan Education LLCN68792Cessna 152 · S/N 15285338Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Built 1981 · Spartan Education LLCN69199Cessna 152 · S/N 15285348Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Built 1981 · Spartan Education LLCN711GGPiper PA-23-160 · S/N 23-1243Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Built 1957 · Spartan Education LLCN2536FPiper PA-38-112 · S/N 38-79A0483Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 1979 · Spartan Education LLCN202RMMcconnell Roger RMC/S6-ES · S/N 0694645Cancelled Feb 27, 2018 · Registration expired, pending cancellation · Rothrock William C JrN806DJPiper PA-28R-200 · S/N 28R-35217Cancelled Feb 26, 2018 · Registration expired, pending cancellation · Built 1969 · Bobby Miller Trucking LLC
Back to Tulsa, OK