Derby, KS

Cancelled registrations · 81

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 = 'KS' AND d.registrant_city = 'DERBY'
  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.

N1463SCessna 182P · S/N 18265010Cancelled Aug 17, 1977 · Exported to Australia · Cook Airfield IncN714NPCessna 150M · S/N 15079306Cancelled Aug 17, 1977 · Exported to Australia · Cook Airfield IncN735HACessna 182Q · S/N 182-65426Cancelled Jun 13, 1977 · Exported to Australia · Cook Airfield IncN5238HCessna 172M · S/N 17265381Cancelled Jun 27, 1975 · Exported to Canada · Cook Airfield IncN1546UCessna U206F · S/N U20602253Cancelled May 8, 1975 · Exported to Guatemala · Built 1973 · Cook Airfield IncN52845Cessna 182P · S/N 18262892Cancelled Aug 19, 1974 · Exported to Guatemala · Cook Airfield IncN7496QCessna TU206F · S/N U20602225Cancelled Aug 6, 1974 · Exported to Guatemala · Cook Airfield IncN13598Cessna 172M · S/N 17262870Cancelled Jun 4, 1974 · Exported to Guatemala · Cock Airfield IncN59272Cessna T210L · S/N 21060187Cancelled May 23, 1974 · Exported to Guatemala · Built 1974 · Cook Airfield IncN1939UCessna TU206F · S/N U20602296Cancelled May 21, 1974 · Exported to Guatemala · Built 1974 · Cook Airfield IncN52750Cessna 182P · S/N 18262818Cancelled May 21, 1974 · Exported to Guatemala · Cook Airfield IncN52789Cessna 182 · S/N 18262845Cancelled May 21, 1974 · Exported to Guatemala · Cook Airfield IncN52807Cessna 182P · S/N 18262861Cancelled May 21, 1974 · Exported to Guatemala · Cook Airfield IncN58941Cessna 182P · S/N 18262412Cancelled May 20, 1974 · Exported to Guatemala · Cook Airfield IncN70841Cessna U206F · S/N U20602104Cancelled Apr 5, 1974 · Exported to Guatemala · Cook Airfield IncN1388MCessna 210L · S/N 21059988Cancelled Dec 7, 1973 · Exported to Guatemala · Cook Airfield IncN4421QCessna 172M · S/N 17261702Cancelled Dec 7, 1973 · Exported to Guatemala · Cook Airfield IncN58929Cessna 182P · S/N 18262400Cancelled Dec 7, 1973 · Exported to Guatemala · Cook Airfield IncN20607Cessna 172M · S/N 17261437Cancelled Oct 29, 1973 · Exported to Guatemala · Cook Airfield IncN5215QCessna 172M · S/N 17261772Cancelled Oct 19, 1973 · Exported to Guatemala · Cook Airfield IncN58471Cessna 182P · S/N 18262085Cancelled Oct 19, 1973 · Exported to Guatemala · Cook Airfield IncN58730Cessna 182P · S/N 18262262Cancelled Oct 19, 1973 · Exported to El Salvador · Cook Airfield IncN4661QCessna 172M · S/N 172-61740Cancelled Oct 18, 1973 · Exported to Guatemala · Cook Airfield IncN20572Cessna 172M · S/N 17261405Cancelled May 31, 1973 · Exported to Guatemala · Cook Airfield IncN919CStinson 108-3 · S/N 108-3919Cancelled Nov 30, 1970 · Merle L WalterN5945ACessna 172 · S/N 28545Cancelled Sep 24, 1970 · Broderius Robert KN2704NCessna 140 · S/N 12962Cancelled Aug 27, 1970 · Exported to Canada · Built 1947 · Cook Aircraft IncN2326VCessna 140 · S/N 14562Cancelled Jun 29, 1970 · Built 1948 · Cook Airfield IncN80287Culver V · S/N V-206Cancelled Sep 5, 1958 · Daniel E LamasterN87045Erco 415-C · S/N 218Cancelled Apr 2, 1957 · Exported to Germany · Green HaroldN94795Ercoupe 415-E · S/N 4908Cancelled Apr 27, 1951 · Built 1949 · Ellis Delman W
Back to Derby, KS