Cook Airfield Inc

Earlier aircraft under this name · 46

Cancelled registrations that named this owner when they ended, newest first.

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_name = 'COOK AIRFIELD INC' OR list_contains(d.other_registrant_names, 'COOK AIRFIELD INC')
  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.

N5179BCessna 152 · S/N 15283795Cancelled Mar 21, 1983 · Built 1979 · Derby, KSN9609GCessna U206G · S/N U20603818Cancelled Feb 3, 1982 · Exported to Bolivia · Derby, KSN758VYCessna R172K · S/N R1723406Cancelled Mar 26, 1981 · Exported to Bolivia · Derby, KSN4779NCessna 182Q · S/N 18267362Cancelled Sep 26, 1980 · Exported to Bolivia · Built 1979 · Derby, KSN5283CCessna T210N · S/N 21063727Cancelled Sep 26, 1980 · Exported to Bolivia · Derby, KSN758HWCessna R172K · S/N R1723118Cancelled Sep 9, 1980 · Exported to Bolivia · Derby, KSN758URCessna R172K · S/N R1723375Cancelled Aug 22, 1980 · Exported to Bolivia · Derby, KSN6110XCessna U206G · S/N U20605819Cancelled Aug 21, 1980 · Exported to Germany · Derby, KSN733QKCessna U206G · S/N 20604787Cancelled Aug 31, 1979 · Exported to Bolivia · Derby, KSN6424NCessna 210N · S/N 21063000Cancelled Aug 29, 1979 · Exported to Bolivia · Derby, KSN6663NCessna 210N · S/N 210-63138Cancelled Aug 29, 1979 · Exported to Bolivia · Derby, KSN732ZPCessna U206G · S/N U20604746Cancelled Aug 29, 1979 · Exported to Bolivia · Derby, KSN733NYCessna U206G · S/N U20604784Cancelled Aug 29, 1979 · Exported to Bolivia · Derby, KSN732NKCessna U206G · S/N U20604702Cancelled Jun 26, 1979 · Exported to Bolivia · Derby, KSN733XCCessna U206G · S/N U20604804Cancelled Jun 26, 1979 · Exported to Bolivia · Derby, KSN733BQCessna U206G · S/N U20604751Cancelled Jun 19, 1979 · Exported to Bolivia · Derby, KSN64959Cessna 152 · S/N 15281500Cancelled Jan 10, 1979 · Exported to Switzerland · Derby, KSN9888MCessna U206G · S/N U20604579Cancelled Nov 1, 1978 · Exported to Bolivia · Derby, KSN756XSCessna U206G · S/N U20604444Cancelled Sep 15, 1978 · Exported to Bolivia · Derby, KSN756PJCessna U206G · S/N U20604245Cancelled Apr 7, 1978 · Exported to Bolivia · Derby, KSN756MBCessna U206G · S/N U20604190Cancelled Apr 6, 1978 · Exported to Bolivia · Derby, KSN761APCessna 210M · S/N 21062104Cancelled Nov 8, 1977 · Exported to Bolivia · Derby, KSN1463SCessna 182P · S/N 18265010Cancelled Aug 17, 1977 · Exported to Australia · Derby, KSN714NPCessna 150M · S/N 15079306Cancelled Aug 17, 1977 · Exported to Australia · Derby, KSN735HACessna 182Q · S/N 182-65426Cancelled Jun 13, 1977 · Exported to Australia · Derby, KSN5238HCessna 172M · S/N 17265381Cancelled Jun 27, 1975 · Exported to Canada · Derby, KSN1546UCessna U206F · S/N U20602253Cancelled May 8, 1975 · Exported to Guatemala · Built 1973 · Derby, KSN52845Cessna 182P · S/N 18262892Cancelled Aug 19, 1974 · Exported to Guatemala · Derby, KSN7496QCessna TU206F · S/N U20602225Cancelled Aug 6, 1974 · Exported to Guatemala · Derby, KSN59272Cessna T210L · S/N 21060187Cancelled May 23, 1974 · Exported to Guatemala · Built 1974 · Derby, KSN1939UCessna TU206F · S/N U20602296Cancelled May 21, 1974 · Exported to Guatemala · Built 1974 · Derby, KSN52750Cessna 182P · S/N 18262818Cancelled May 21, 1974 · Exported to Guatemala · Derby, KSN52789Cessna 182 · S/N 18262845Cancelled May 21, 1974 · Exported to Guatemala · Derby, KSN52807Cessna 182P · S/N 18262861Cancelled May 21, 1974 · Exported to Guatemala · Derby, KSN58941Cessna 182P · S/N 18262412Cancelled May 20, 1974 · Exported to Guatemala · Derby, KSN70841Cessna U206F · S/N U20602104Cancelled Apr 5, 1974 · Exported to Guatemala · Derby, KSN1388MCessna 210L · S/N 21059988Cancelled Dec 7, 1973 · Exported to Guatemala · Derby, KSN4421QCessna 172M · S/N 17261702Cancelled Dec 7, 1973 · Exported to Guatemala · Derby, KSN58929Cessna 182P · S/N 18262400Cancelled Dec 7, 1973 · Exported to Guatemala · Derby, KSN20607Cessna 172M · S/N 17261437Cancelled Oct 29, 1973 · Exported to Guatemala · Derby, KSN5215QCessna 172M · S/N 17261772Cancelled Oct 19, 1973 · Exported to Guatemala · Derby, KSN58471Cessna 182P · S/N 18262085Cancelled Oct 19, 1973 · Exported to Guatemala · Derby, KSN58730Cessna 182P · S/N 18262262Cancelled Oct 19, 1973 · Exported to El Salvador · Derby, KSN4661QCessna 172M · S/N 172-61740Cancelled Oct 18, 1973 · Exported to Guatemala · Derby, KSN20572Cessna 172M · S/N 17261405Cancelled May 31, 1973 · Exported to Guatemala · Derby, KSN2326VCessna 140 · S/N 14562Cancelled Jun 29, 1970 · Built 1948 · Derby, KS
Back to Cook Airfield Inc