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.

N2159DMooney M20J · S/N 24-0547Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 1978 · Tuttle & Associates IncN1291XMooney M20E · S/N 164Cancelled Feb 6, 2018 · Registration expired, pending cancellation · Built 1963 · Leggett Greg WN907BBell 47D1 · S/N 954Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1948 · Allied Helicopters Intntl IncN800HCBell TH-13T · S/N 3800Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1967 · Allied Helicopter Service IncN47NRRoach Neil GLASAIR SUPER IIS-FT · S/N 2282Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1998 · White Buffalo Environmental IncN681TSTechsphere Systems Intl SA-60-MA · S/N TS681Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Airship Leasing Co LLCN682TSTechsphere Systems Intl SA-60-MA · S/N TS682Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Airship Leasing Co LLCN41377Piper PA-28-151 · S/N 28-7415192Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1974 · Wynn Ralph HN8885FHughes 269A · S/N 0261Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1963 · Tundra Resources CorpN720LHGulfstream American G-1159 · S/N 233Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1978 · Foxfire Aviation LLCN2155BAero Commander 690 · S/N 11046Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1972 · Metair LLCN2647VCessna 170 · S/N 18157Cancelled Nov 22, 2017 · Revoked, canceled · Built 1948 · Lawson Owen LN5295PPiper PA-24-180 · S/N 24-336Cancelled Nov 20, 2017 · Revoked, canceled · Built 1958 · Aircraft Company Of AmericaN4720DCessna 182A · S/N 34820Cancelled Nov 18, 2017 · Revoked, canceled · Built 1957 · Aircraft Company Of AmericaN1746VCessna 140 · S/N 13931Cancelled Oct 28, 2017 · Revoked, canceled · Built 1947 · Air Lines IncN3152VBeech 35 · S/N D-582Cancelled Oct 28, 2017 · Revoked, pending cancellation · Built 1947 · Akin Brown J JrN908CTDiamond Aircraft Ind DA20-C1 · S/N C0108Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 2000 · Shagbark Aviation LLCN415JWsk-Pzl-Mielec TS-11 ISKRA · S/N 1H0415Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 1969 · Quiet Thunder Air Racing LLCN813VCBritish Aerospace HS 125-700A · S/N 257013Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Jet Capital LLCN54GTYakovlev YAK 52 · S/N 833805Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Built 1983 · N17171 LLC DBAN3841ASchweizer SGU 2-22C · S/N 62Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Brown Eric RN2292QPiper PA-28-161 · S/N 28-7716098Cancelled Aug 28, 2017 · Exported to Indonesia · Built 1977 · Dan Howard Aircraft Sales LLCN3959WBeech E-55 · S/N TE-959Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Rose Resources Oil & Gas IncN90304Balloon Works FIREFLY 7 · S/N F7-487Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Mccallie Carl DN22315Buckeye DREAM MACHINE · S/N 16488Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 2006 · Davis Windle CN167JSCessna 310L · S/N 310L-0129Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 1967 · Harvest Time International IncN2629CJ And J Tukan TRIKE · S/N 13571113Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Johnson Travis GN17MKBritish BAC 1-11 410/AQ · S/N BAC.054Cancelled Jun 14, 2017 · Registration expired, pending cancellation · Built 1965 · Go Jet IncN64676Bell TH-13T · S/N 67-17022Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Allied Helicopter Service IncN64694Bell H-13H · S/N 1887Cancelled May 24, 2017 · Registration expired, pending cancellation · Allied Helicopter Service IncN7562MCessna T210M · S/N 21062020Cancelled May 16, 2017 · Exported to Mexico · Built 1977 · Dan Howard Aircraft Sales LLCN815DDLearjet 35A · S/N 414Cancelled Apr 21, 2017 · Exported to Mexico · Built 1981 · Skyline Aviation LLCN339TMCirrus Design SR20 · S/N 2090Cancelled Apr 12, 2017 · Exported to France · Built 2011 · Bradford MichaelN918AXBoeing 777-222 · S/N 26935Cancelled Apr 5, 2017 · Registration expired · Built 1997 · T7 Aviation Leasing LLCN927AXBoeing 777-222 · S/N 26943Cancelled Mar 13, 2017 · First renewal notice · Built 1997 · T7 Aviation Leasing LLCN77844Avro CANBERRA TT18 · S/N HP/HI/161BCancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1953 · National Aviation Museum And Foundation Of OklaN34BDJackson Bill C SR VELOCITY RG · S/N 001Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Jackson Bill C SrN3009DCessna 310 · S/N 35209Cancelled Feb 14, 2017 · Revoked, canceled · Built 1955 · Aircraft Company Of AmericaN2961UCessna 172D · S/N 17250561Cancelled Feb 6, 2017 · Revoked, pending cancellation · Built 1963 · Skyway Flying Club IncN7250MCessna 175 · S/N 55550Cancelled Feb 4, 2017 · Revoked, canceled · Built 1958 · Aircraft Co Of AmericaN72597Cessna 140 · S/N 9769Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Lacey KevinN7487ECessna 210 · S/N 57187Cancelled Feb 4, 2017 · Revoked, canceled · Built 1960 · Riverside Aircraft Company IncN76851Cessna 140 · S/N 11285Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Roe SieN76BHHartig CAVALIER SA102.5 · S/N SA1025-7412LFCancelled Feb 4, 2017 · Revoked, canceled · Hartig Burr KN7838Carroll-Mcginnis-Mckim PAX-23 · S/N P-001-23Cancelled Feb 4, 2017 · Revoked, canceled · Built 1972 · Carroll Thomass NN79552Convair BT-13A · S/N 1520Cancelled Feb 4, 2017 · Revoked, canceled · Built 1941 · Underwood T AN88018Piper J3C-65 · S/N 15636Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Walker B AshleyN8427MCessna 210M · S/N 21062043Cancelled Jan 19, 2017 · Exported to Mexico · Built 1977 · Dan Howard Aircraft Sales LLCN93111Cessna 210L · S/N 21060266Cancelled Jan 19, 2017 · Exported to Mexico · Built 1974 · Dan Howard Aircraft Sales LLCN274CSCessna 210L · S/N 21060148Cancelled Dec 8, 2016 · Exported to Mexico · Built 1973 · Dan Howard Aircraft Sales LLC
Back to Tulsa, OK