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.

N8445QCessna TU206F · S/N U20603303Cancelled Mar 27, 1980 · Exported to Canada · Bush A FN46009Cessna 152 · S/N 15282983Cancelled Mar 20, 1980 · Exported to United Kingdom · Built 1978 · Christiansen Aviation IncN46073Cessna 152 · S/N 15282994Cancelled Mar 20, 1980 · Exported to United Kingdom · Built 1978 · Christiansen Aviation Inc DBA Lease A PlaneN47125Cessna 152 · S/N 152-83175Cancelled Mar 20, 1980 · Exported to France · Christiansen Aviation Inc DBA Lease A PlaneN75KABeech 200 · S/N BB100Cancelled Feb 26, 1980 · Exported to Mexico · Frank Lowry Prop-Jet IncN4683UCessna U206G · S/N U20605053Cancelled Feb 21, 1980 · Exported to Nigeria · Pennant Aviation IncN69439Cessna 340 · S/N 3400259Cancelled Jan 17, 1980 · Exported to Canada · Great Planes Sales IncN5306UCessna U206G · S/N U20605187Cancelled Aug 30, 1979 · Exported to Australia · Christiansen Aviation Inc DBA/Lease A PlaneN89686Cessna 152 · S/N 15282826Cancelled Aug 16, 1979 · Exported to Australia · Built 1978 · Christiansen Aviation Inc DBA/Lease-A-PlaneN46463Cessna 152 · S/N 15283054Cancelled Aug 10, 1979 · Exported to Australia · Built 1978 · Christensen Aviation IncN68153Cessna 152 · S/N 15282151Cancelled Aug 9, 1979 · Exported to Australia · Christiansen Aviation IncN4085CCessna T310R · S/N 310R1366Cancelled Jul 11, 1979 · Exported to Mexico · Built 1978 · Pennant Aviation IncN8028UDouglas DC-8-21 · S/N 45297Cancelled Jul 9, 1979 · United Air Carriers IncN5NWMitsubishi MU-2B-35 · S/N 597Cancelled Jul 3, 1979 · Built 1973 · Wmd IncN68187Cessna 152 · S/N 152-82172Cancelled Jun 22, 1979 · Exported to United Kingdom · Christiansen Aviation IncN75854Cessna 172N · S/N 17268002Cancelled Jun 22, 1979 · Exported to United Kingdom · Christiansen Aviation IncN97022Cessna 182Q · S/N 18266939Cancelled Jun 22, 1979 · Exported to Australia · Christiansen Aviation Inc DBA Lease A PlaneN68169Cessna 152 · S/N 15282161Cancelled Jun 15, 1979 · Exported to United Kingdom · Christiansen Aviation IncN9890ECessna 172N · S/N 17272284Cancelled May 16, 1979 · Exported to Australia · Christiansen Aviation IncN8566QCessna TU206F · S/N U20603422Cancelled Apr 11, 1979 · Exported to Mexico · Built 1976 · Rawson Dean/DBA Rawson LtdN6512NCessna 210N · S/N 21063077Cancelled Mar 29, 1979 · Exported to Australia · Christiansen AviationN733EFCessna U206G · S/N U20604760Cancelled Jan 23, 1979 · Exported to Australia · Pennant Aviation IncN8547GCessna 310R · S/N 310R0935Cancelled Jan 2, 1979 · Exported to Australia · Pennant Aviation IncN153AFDouglas DC-8-54 · S/N 45682Cancelled Dec 20, 1978 · Exported to Italy · Built 1965 · Mcdonnell Douglas CorpN25040Cessna 152 · S/N 15280512Cancelled Oct 25, 1978 · Exported to Australia · Christiansen Aviation Inc DBA Lease A PlaneN95629Cessna 182Q · S/N 18266583Cancelled Oct 2, 1978 · Exported to Australia · Pennant Aviation IncN2694CCessna R182 · S/N R18200217Cancelled Sep 28, 1978 · Exported to Australia · Pennant Aviation IncN94412Cessna 182Q · S/N 18266425Cancelled Sep 19, 1978 · Exported to Australia · Built 1978 · Pennant Aviation IncN8949FPiper PA-28-151 · S/N 28-7715296Cancelled Sep 15, 1978 · Exported to United Kingdom · Christiansen Aviation Inc DBA Tulsa Lease A PlaneN9837CCessna R182 · S/N R18200457Cancelled Sep 5, 1978 · Exported to Australia · Built 1978 · Christiansen Aviation Inc DBA Lease-A-PlaneN1795XCessna 210L · S/N 21060815Cancelled Aug 23, 1978 · Exported to Canada · Paloma Air IncN761WECessna 210M · S/N 21062570Cancelled Aug 11, 1978 · Exported to Australia · Pennant Avaition IncN739MUCessna 172N · S/N 17270657Cancelled Jul 24, 1978 · Exported to Australia · Christiansen Aviation IncN67529Cessna 152 · S/N 15281894Cancelled Jul 17, 1978 · Exported to United Kingdom · Christiansen Aviation Inc DBA Lease A PlaneN67538Cessna 152 · S/N 15281900Cancelled Jul 17, 1978 · Exported to United Kingdom · Christiansen Avaition Inc DBA Lease A PlaneN67742Cessna 152 · S/N 15281989Cancelled Jul 17, 1978 · Exported to United Kingdom · Christiansen Aviation IncN739EMCessna 172N · S/N 17270485Cancelled Jul 6, 1978 · Exported to Australia · Christiansen Aviation IncN759SHCessna 182Q · S/N 18266219Cancelled Jun 22, 1978 · Exported to Australia · Pennant Aviation IncN94550Cessna 182Q · S/N 18266444Cancelled Jun 22, 1978 · Exported to Australia · Pennant Aviation IncN73821Cessna 172N · S/N 172-6770Cancelled Jun 21, 1978 · Exported to Iceland · Pennant Aviation IncN756LGCessna U206G · S/N U20604171Cancelled Jun 21, 1978 · Exported to Australia · Pennant Aviation IncN80143Cessna 172M · S/N 17266399Cancelled Jun 21, 1978 · Exported to Canada · Pennant Aviation IncN732HYCessna 210L · S/N 21061537Cancelled Jun 7, 1978 · Scott Martin WilliamN759SFCessna 182Q · S/N 18266217Cancelled May 31, 1978 · Exported to Australia · Pennant Aviation IncN80558Cessna 172M · S/N 66652Cancelled May 31, 1978 · Exported to Canada · Pennant Aviation IncN88680Cessna 404 · S/N 404-0219Cancelled May 31, 1978 · Exported to Australia · Pennant Aviation IncN756TGCessna U206G · S/N U20604339Cancelled May 30, 1978 · Exported to Australia · Pennant Aviation IncN756RJCessna U206G · S/N U20604293Cancelled May 17, 1978 · Exported to Australia · Pennant Aviation IncN1185QCessna A185F · S/N 18503468Cancelled May 9, 1978 · Exported to Canada · Pennant Aviation IncN5376RCessna 172M · S/N 17263528Cancelled May 2, 1978 · Exported to Canada · Lliff Aircraft Repair & Service Co Inc
Back to Tulsa, OK