OpenAirDocs.org
Conroe, TX

Cancelled registrations · 182

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 = 'TX' AND d.registrant_city = 'CONROE'
  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.

N6197VConsolidated Aeronautics LAKE LA-4-200 · S/N 850Cancelled Sep 2, 1977 · Exported to Chile · Lake Amphibian Intl IncN6184VLake LA-4-200 · S/N 837Cancelled Jun 15, 1977 · Exported to Sweden · Lake Amphibian International IncN6172VLake LA-4-200 · S/N 825Cancelled May 13, 1977 · Exported to Paraguay · Lake 4 Sales CorpN6173VLake LA-4-200 · S/N 826Cancelled May 6, 1977 · Exported to Sweden · Lake Amphibian Intl IncN6168VLake LA-4-200 · S/N 821Cancelled Apr 15, 1977 · Exported to Canada · Lake Amphibian Intl IncN6162VConsolidated Aeronautics LAKE LA-4-200 · S/N 815Cancelled Apr 5, 1977 · Exported to Canada · Lake 4 Sales CorpN6019VLake LA-4-200 · S/N 773Cancelled Mar 17, 1977 · Exported to Australia · Lake Amphibian Intl IncN6086VLake LA-4-200 · S/N 795Cancelled Dec 27, 1976 · Lake 4 Sales CorpN1247LConsolidated Aeronautics LAKE LA-4-200 · S/N 746Cancelled Dec 14, 1976 · Exported to Australia · Lake Amphibian International IncN6025VLake LA-4-200 · S/N 778Cancelled Sep 15, 1976 · Exported to Sweden · Lake Amphibian Intl IncN6014VConsolidated Aeronautics LAKE LA-4-200 · S/N 769Cancelled Aug 17, 1976 · Exported to Finland · Lake Amphibian Intl IncN6009VLake LA-4-200 · S/N 764Cancelled Jul 16, 1976 · Exported to Sweden · Lake Amphibian Intl IncN1257LConsolidated Aeronautics LAKE LA-4-200 · S/N 755Cancelled Jun 10, 1976 · Exported to Canada · Lake Amphibian International IncN7173PPiper PA-24-250 · S/N 24-2342Cancelled May 26, 1976 · Norvell Victor RN1252LConsolidated Aeronautics LAKE LA-4-200 · S/N 750Cancelled May 17, 1976 · Exported to Canada · Lake Amphibian International IncN1242LLake LA-4 · S/N 741Cancelled Apr 8, 1976 · Exported to Canada · Lake Amphibian Intl IncN1240LLake LA-4 · S/N 739Cancelled Mar 24, 1976 · Exported to Canada · Lake Amphian Intl IncN1219LConsolidated Aeronautics LAKE LA-4-200 · S/N 722Cancelled Feb 5, 1976 · Exported to Australia · Lake Amphian International IncN1208LConsolidated Aeronautics LAKE LA-4 · S/N 713Cancelled Jan 20, 1976 · Exported to Australia · Lake Amphian International IncN5555QMooney M20C · S/N 2966Cancelled Nov 26, 1975 · Ericson Lester RN1200LConsolidated Aeronautics LAKE LA-4 · S/N 705Cancelled Nov 21, 1975 · Exported to Canada · Lake 4 Sales CorpN1205LConsolidated Aeronautics LAKE LA-4 · S/N 710Cancelled Nov 21, 1975 · Exported to Finland · Lake Amphibian International IncN1103LConsolidated Aeronautics LAKE LA-4 · S/N 694Cancelled Aug 21, 1975 · Exported to Australia · Lake 4 Sales CorpN1096LConsolidated Aeronautics LAKE LA-4 · S/N 689Cancelled Jul 21, 1975 · Exported to Canada · Lake 4 Sales CorpN1090LConsolidated Aeronautics LAKE LA-4 · S/N 683Cancelled Jun 13, 1975 · Exported to Canada · Lake 4 Sales CorpN966ZWing D-1 · S/N 22Cancelled Feb 21, 1975 · Clift William EN1050LLake LA-4 · S/N 643Cancelled Oct 31, 1974 · Exported to Australia · Lake 4 Sales CorpN1042LLake LA-4 · S/N 635Cancelled Sep 27, 1974 · Exported to Canada · Lake 4 Sales CorpN65728Lake LA-4-200 · S/N 626Cancelled Sep 23, 1974 · Exported to Canada · Lake 4 Sales CorpN1041LAerofab LAKE LA-4-200 · S/N 634Cancelled Sep 19, 1974 · Exported to Canada · Built 1974 · Lake 4 Sales CorpN1043LLake LA-4 · S/N 636Cancelled Sep 18, 1974 · Exported to Venezuela · Lake 4 Sales CorpN1039LLake LA-4 · S/N 632Cancelled Sep 9, 1974 · Exported to Canada · Lake 4 Sales CorpN1037LLake LA-4-200 · S/N 630Cancelled Aug 19, 1974 · Exported to Canada · Lake 4 Sales CorpN1036LLake LA-4 · S/N 629Cancelled Aug 14, 1974 · Exported to Canada · Lake 4 Sales CorpN65729Lake LA-4-200 · S/N 627Cancelled Aug 12, 1974 · Exported to Canada · Lake 4 Sales CorpN65730Lake LA-4-200 · S/N 628Cancelled Aug 12, 1974 · Exported to Canada · Lake 4 Sales CorpN65720Lake LA-4-200 · S/N 622Cancelled Aug 9, 1974 · Exported to Canada · Lake 4 Sales CorpN65722Lake LA-4-200 · S/N 623Cancelled Jul 31, 1974 · Exported to United Kingdom · Lake 4 Sales CorpN3170TCessna 177 · S/N 17700470Cancelled Jul 23, 1974 · Montgomery County Flying Club IncN65710Lake LA-4-200 · S/N 614Cancelled Jun 18, 1974 · Exported to Canada · Lake 4 Sales CorpN65708Lake LA-4-200 · S/N 612Cancelled May 21, 1974 · Exported to Brazil · Lake 4 Sales CorpN65712Lake LA-4-200 · S/N 615Cancelled May 21, 1974 · Exported to Canada · Lake 4 Sales CorpN65642Lake LA-4-200 · S/N 581Cancelled May 20, 1974 · Exported to New Zealand · Lake 4 Sales CorpN65709Lake LA-4-200 · S/N 613Cancelled May 14, 1974 · Exported to Canada · Lake 4 Sales CorpN65705Lake LA-4-200 · S/N 610Cancelled May 7, 1974 · Exported to Canada · Lake 4 Sales CorpN65657Lake LA-4-200 · S/N 589Cancelled Apr 8, 1974 · Exported to Canada · Lake 4 Sales CorpN65701Lake LA-4-200 · S/N 606Cancelled Apr 8, 1974 · Exported to Canada · Lake 4 Sales CorpN65697Lake LA-4-200 · S/N 603Cancelled Apr 1, 1974 · Exported to Canada · Lake 4 Sales CorpN65667Lake LA-4-200 · S/N 597Cancelled Mar 6, 1974 · Exported to Japan · Lake 4 Sales CorpN65674Lake LA-4-200 · S/N 599Cancelled Mar 6, 1974 · Exported to Canada · Lake 4 Sales Corp
Back to Conroe, TX