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.

N7228YPiper PA-30 · S/N 30-252Cancelled Aug 12, 1965 · Bradford Motor WorksN5240ACessna 310 · S/N 35440Cancelled May 27, 1965 · Mcknight Charles MN7453Arrow Aircraft & Motors ARROW SPORT · S/N 298Cancelled May 22, 1965 · David A WarrenN50611Taylorcraft DCO-65 · S/N DCO-65Cancelled May 20, 1965 · Wright Max LN7309DPiper PA-22-150 · S/N 22-5097Cancelled May 20, 1965 · Ferguson J W JrN86742Bellanca 14-13 · S/N 1103Cancelled May 20, 1965 · Culver NesmithN67805Douglas A-26 · S/N 7228Cancelled Apr 16, 1965 · Pan American Petroleum CorpN4931BBeech C-50 · S/N CH-332Cancelled Feb 8, 1965 · Wheeler & WheelerN484MMooney M-18C · S/N 238Cancelled Dec 28, 1964 · James H DeatonN44632Beech D18S · S/N A-39Cancelled Sep 21, 1964 · Exported to Canada · American Petroleum CorpN4141BAero Commander 520 · S/N 520-45Cancelled Jul 2, 1964 · Exported to Canada · Built 1952 · Insulation Services IncN4178YCessna 185 · S/N 185-0378Cancelled May 11, 1964 · Exported to Paraguay · Williams Brothers CoN6971PPiper PA-24-250 · S/N 24-2113Cancelled May 8, 1964 · Exported to Canada · Kostich WalterN2435APiper PA-22-135 · S/N 22-788Cancelled Mar 17, 1964 · Exported to Canada · White James HN5670CCessna 140A · S/N 15670Cancelled Oct 29, 1963 · Aviation IncN6230PPiper PA-24-250 · S/N 24-1333Cancelled Jun 21, 1962 · Exported to Australia · Reaves Harris EnterprisesN7615MCessna 175 · S/N 55915Cancelled May 14, 1962 · Exported to Liechtenstein · Howard Carr & Harris AttorneysN5228VBoeing B-17G · S/N 4483859Cancelled Jan 11, 1962 · Exported to Peru · Loffland Brothers Company Of PeruN5672ECessna 150 · S/N 17172Cancelled Nov 24, 1961 · Spartan Aircraft CoN5773PPiper PA-24-250 · S/N 24-851Cancelled Jul 17, 1961 · Exported to Canada · Ross Aviation IncN9628DPiper PA-22-160 · S/N 22-6540Cancelled Nov 18, 1960 · Exported to United Kingdom · Built 1959 · Ross Aviation IncN34861Culver LFA · S/N 271Cancelled Jun 7, 1960N8622BCessna 172 · S/N 36322Cancelled Mar 4, 1959 · Lowery G JN9351ACessna 190 · S/N 7430Cancelled Oct 28, 1958 · Yingling Aircraft Of Oklahoma IncN2143PPiper PA-23 · S/N 23-743Cancelled Jul 11, 1958 · Exported to Canada · Dowell IncN94768Ercoupe 415-C · S/N 4879Cancelled Mar 7, 1958 · Built 1947 · White George WN5208KRyan NAVION · S/N NAV-4-2108Cancelled Feb 19, 1958 · Horton Harry SN307Dehavilland DHC-2 · S/N 946Cancelled Jan 17, 1958 · Pan American Petroleum CorporationN7398ACessna 172 · S/N 29498Cancelled Apr 4, 1957 · Joe A Boman Construction Co IncN1049PPiper PA-23 · S/N 23-57Cancelled Jan 24, 1957 · Exported to Canada · Ted DewittN4171Mooney M-18C 55 · S/N 366Cancelled Jul 30, 1956 · Built 1955 · K L Barnes Electric CoN80037Beech D18S · S/N A-98Cancelled Jul 30, 1956 · Sinclair Crude Oil CoN5077NCessna T-50 · S/N 6143Cancelled Jul 12, 1956 · Burch R LN4171Mooney M-18C 55 · S/N 336Cancelled Jun 14, 1956 · K L Barnes Electric CompanyN80921Globe GC-1B · S/N 1114Cancelled May 21, 1956 · M H TettertonN62103Cessna UC-78 · S/N 6493Cancelled Mar 26, 1956 · Yingling Aircraft Of Oklahoma IncN73763Consolidated Vultee BT-13A · S/N 11234Cancelled Mar 16, 1956 · Bigler HazelN65556Consolidated Vultee BT-13A · S/N 6808Cancelled Mar 14, 1956 · Built 1942 · Williams Brothers CompanyN59521Fairchild PT-19A · S/N T43-7232Cancelled Mar 8, 1956 · B J StoufferN85003Aeronca 7AC · S/N 7AC-3727Cancelled Feb 21, 1956 · Williams Billy JN829Cessna UC-78 · S/N 3771Cancelled Feb 17, 1956 · Sullenger Marvin LN8315KStinson 108-1 · S/N 108-1315Cancelled Feb 17, 1956 · W M CombsN53747Piper J5A · S/N 51292Cancelled Nov 30, 1955 · Harper Herman EN51487Consolidated Vultee BT-13B (SNV-2) · S/N 9-1254Cancelled Nov 29, 1955 · Lowe James CN51932Cessna T-50 · S/N 5282Cancelled Nov 29, 1955 · Sullenger Marvin LN969DStinson 108-2 · S/N 108-2969Cancelled Nov 18, 1955 · Triplett Robert LN2110NCessna 140 · S/N 12346Cancelled Nov 15, 1955 · Spartan Aircraft CoN73714North American 047B · S/N 51-1035Cancelled Oct 25, 1955 · Aero Exploration CompanyN48244Taylorcraft DCO-65 · S/N L-5333Cancelled Oct 24, 1955 · Built 1944 · Brown Arthur GN57569Consolidated Vultee BT-13A · S/N 1649Cancelled Oct 24, 1955 · Walsh Joseph F
Back to Tulsa, OK