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.

N125XAdams Carl J NIEUPORT 11 · S/N 1103Cancelled Jul 16, 2001 · Adams Carl JN813ACSpagnoletti Anthony AIR COMMAND 582 · S/N 582AC11004Cancelled May 5, 2000 · Spagnoletti AnthonyN235FCCarter Franklin M III SPACEWALKER II · S/N SW209F016Cancelled May 1, 2000 · Wimp Ivan GN82904Aeronca 7AC · S/N 7AC1554Cancelled Mar 25, 1998 · Triennial form not returned · Conservair Inc DBAN18KFCessna 421B · S/N 421B0809Cancelled Jul 2, 1997 · Exported to Canada · Max Mahaffey Ford IncN44WTBeech D18S · S/N A249Cancelled Jun 4, 1997 · Triennial form not returned · Philips Dudley A III MdN3166GNorth American AT-6G · S/N 493270Cancelled Feb 18, 1997 · Triennial form not returned · Conservair IncN8824ZCessna 172H · S/N 17255474Cancelled Jan 7, 1997 · Triennial form not returned · Frazier Doris CN4590MBeech A36 · S/N E1242Cancelled May 14, 1996 · Triennial form not returned · Tisdale Company IncN4357RCessna 172M · S/N 17263108Cancelled Jul 25, 1995 · Second triennial mailing, no response · Alworth Lee GN736KACessna R172K · S/N R1722577Cancelled Jul 13, 1995 · Exported to Turkey · Blue Bird AviationN202AZAdams/Zinke QUICKIE Q2 · S/N 2068Cancelled Jun 14, 1995 · Triennial form not returned · Conlin MichaelN800DHMitsubishi MU-2B-20 · S/N 166Cancelled Apr 18, 1994 · Aircraft Exchange IncN11382Cessna 150L · S/N 15075371Cancelled May 10, 1993N5707ECessna 150 · S/N 17207Cancelled Jan 13, 1992 · Schank Travis WN808WMitsubishi MU-2B-35 · S/N 609Cancelled Apr 15, 1991 · Triennial form not returned · Cavenaugh Aviation IncN7317TCessna 172A · S/N 46917Cancelled Feb 11, 1991 · Triennial form not returned · Thrasher CarlieN55WPPiper PA-28R-200 · S/N 28R-7635356Cancelled Jan 18, 1988 · Registration expired, pending cancellation · Built 1976 · B & C Aircraft LeasingN6958Aerospatiale SA341G GAZELLE · S/N 1063Cancelled Oct 18, 1983 · Exported to United Kingdom · Heliflight Systems IncN37748Aerospatiale SA341G GAZELLE · S/N 1097Cancelled Oct 17, 1983 · Exported to United Kingdom · Heliflight Systems IncN62406S N I A S SA341G · S/N 1155Cancelled Oct 14, 1983 · Exported to United Kingdom · Heliflight Systems IncN65430Cessna 152 · S/N 15281548Cancelled Jun 30, 1983 · Exported to Mexico · Martin Tony LN54370Sikorsky S-76A · S/N 760162Cancelled Mar 11, 1983 · Exported to Mexico · Heliflight Systems IncN54026Sikorsky S-76A · S/N 760144Cancelled Oct 25, 1982 · Exported to Mexico · Heliflight Systems IncN5402XSikorsky S-76A · S/N 760143Cancelled Oct 25, 1982 · Exported to Mexico · Heliflight Systems IncN8008ALake LA-4-200 · S/N 1050Cancelled Apr 26, 1982 · Exported to Peru · Lake Amphibian IncN8011HLake LA-4-200 · S/N 1060Cancelled Jul 27, 1981 · Exported to Canada · Lake Amphibian IncN8010SLake LA-4-200 · S/N 1057Cancelled Jun 22, 1981 · Exported to Australia · Lake Amphibian IncN8010XLake LA-4-200 · S/N 1058Cancelled Jun 22, 1981 · Exported to Australia · Lake Amphibian IncN8006QLake LA-4-200 · S/N 1043Cancelled Mar 9, 1981 · Exported to Australia · Lake Amphibian IncN8007BLake LA-4-200 · S/N 1045Cancelled Mar 9, 1981 · Exported to Australia · Lake Amphibian IncN8007XLake LA-4-200 · S/N 1047Cancelled Mar 9, 1981 · Exported to Australia · Lake Amphibian IncN8004NLake LA-4-200 · S/N 1027Cancelled Feb 13, 1981 · Exported to Colombia · Lake Amphibian IncN8004MLake LA-4-200 · S/N 1026Cancelled Jan 30, 1981 · Exported to Colombia · Lake Amphibian IncN8004ELake LA-4-200 · S/N 1024Cancelled Oct 2, 1980 · Exported to Colombia · Lake Amphibian IncN8003SLake LA-4-200 · S/N 1015Cancelled May 20, 1980 · Exported to Finland · Lake Amphibian IncN8002XAerofab LAKE LA-4-200 · S/N 1003Cancelled Feb 1, 1980 · Exported to Argentina · Lake Amphibian IncN3107PConsolidated Aeronautics LAKE LA-4-200 · S/N 981Cancelled Dec 10, 1979 · Exported to Canada · Lake 4 Sales CorpN2861PConsolidated Aeronautics LAKE LA-4-200 · S/N 928Cancelled Oct 30, 1979 · Exported to Argentina · Lake Amphibian International IncN3053PConsolidated Aeronautics LAKE LA-4-200 · S/N 970Cancelled Oct 30, 1979 · Exported to Australia · Lake 4 Sales CorpN3047PConsolidated Aeronautics LAKE LA-4-200 · S/N 969Cancelled Sep 17, 1979 · Exported to Australia · Lake 4 Sales CorpN2781PConsolidated Aeronautics LAKE LA-4-200 · S/N 912Cancelled Aug 15, 1978 · Exported to Australia · Lake Amphibian International IncN2770PConsolidated Aeronautics LAKE LA-4-200 · S/N 910Cancelled Aug 14, 1978 · Exported to Australia · Lake Amphibian International IncN2778PLake LA-4-200 · S/N 911Cancelled Aug 14, 1978 · Exported to Australia · Built 1978 · Lake Amphibian Intl IncN2579PConsolidated Aeronautics LAKE LA-4-200 · S/N 874Cancelled Apr 3, 1978 · Exported to Australia · Lake Amphibian International IncN2530PConsolidated Aeronautics LAKE LA-4 · S/N 866Cancelled Nov 28, 1977 · Exported to Australia · Lake Amphibian International OmcN2518PConsolidated Aeronautics LAKE LA-4 · S/N 864Cancelled Nov 22, 1977 · Exported to Australia · Lake Amphibian International IncN6217VConsolidated Aeronautics LAKE LA-4-200 · S/N 857Cancelled Oct 26, 1977 · Exported to Belgium · Lake Amphibian Int'L IncN6246VLake LA-4-200 · S/N 860Cancelled Oct 26, 1977 · Exported to Chile · Lake Ampibian Intl IncN6199VConsolidated Aeronautics LAKE LA-4-200 · S/N 852Cancelled Sep 13, 1977 · Exported to Argentina · Lake Amphibian Intl Inc
Back to Conroe, TX