Houston, TX

Cancelled registrations · 2,439

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 = 'HOUSTON'
  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.

N2233QCessna 402B · S/N 402B0319Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1972 · Cragg Gordon EN256RABeech C-45H · S/N AF-631Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Air International IncN47CSRobinson Helicopter R22 · S/N 0079Cancelled Jul 16, 2013 · Sale reported, canceled · Built 1980N413TBBeech C-45H · S/N AF-515Cancelled Jul 15, 2013 · Sale reported, canceled · Built 1953N2794VRaven Industries RALLY RX7 · S/N RX7-406Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1985 · Barnes John LN7980RCessna 310B · S/N 35734Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1958 · Comat IncN7PZScott F Brantley VENTURE 20 · S/N 21Cancelled Jul 3, 2013 · Registration expired, pending cancellation · Built 1991 · Scott F BrantleyN211PTSeales Frankie Paul PT2 · S/N PT1001Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1987 · Seales Frankie PaulN62194Dudley ARIES MOD. 1 · S/N 00001Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1974 · Dudley Bayard TN6229GCessna 150K · S/N 15071729Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1970 · Turcotte Joseph RN6467UAerostar International RX-7 · S/N RX7-3083Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1986 · Barker BradN166MDAmerican FALCON · S/N 0166Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Davis Morgan J JrN2413XHarmening HIGHFLYER DELUXE · S/N 006013Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Henderson Lowell ON8510QEagle Balloons C-7 · S/N E86794Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Pretty Balloons Ltd.N15155Balloon Works FIREFLY 7 · S/N 11002Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1981N8585JCessna 150G · S/N 15066485Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1967N4842PPiper PA-23-250 · S/N 27-413Cancelled Jun 26, 2013 · Third renewal notice · Built 1961 · X Aviation LLCN69DJPiper PA-31P · S/N 31P-7300155Cancelled Jun 24, 2013 · Sale reported, pending cancellationN227BAGrumman G-1159 · S/N 27Cancelled Jun 21, 2013 · Exported to Mexico · Grumman N227ba LLCN1081RRaven S55A · S/N S55A-271Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1976 · UtotemN3655YCessna 210C · S/N 21058155Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1963 · Butler Charles WN7134YReynoso Frank AZTEC 582 · S/N 001Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Reynoso Frank CN34667Cessna 177B · S/N 17701930Cancelled Jun 14, 2013 · Registration expired, pending cancellation · Built 1973 · Mayur Enterprises IncN9818PElizabeth Adams Walz A60S · S/N 185Cancelled Jun 14, 2013 · Registration expired, pending cancellation · Murtorff BillN2806FRaven S55A · S/N S55A-1095Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Tipton William PN6024YCessna 182T · S/N 18281827Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Built 2006 · Aop Supply CorporationN38RBBrehm OSPREY II · S/N 77Cancelled Jun 12, 2013 · Sale reported, canceledN3943QMeyer Frank W JR ROTORWAY EXEC · S/N BJ313Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Meyer Frank W JrN757MWCessna 152 · S/N 15279858Cancelled Jun 10, 2013 · Sale reported, canceled · Built 1977N252BKGates Lear Jet 25B · S/N 107Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1973 · Mcoco IncN4971CBuoy David C CASSUTT III M · S/N 1Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Budy David CN6081LEagle Balloons C-7 · S/N E82733Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1982 · Pretty Balloons Unlimited IncN8426BPiper PA-34-220T · S/N 34-8133194Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1981 · Ray John H Jr DBAN31223Sikorsky S-76A · S/N 760257Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1983 · Berkeley Ralph G Md DBAN3147FStokes James C HUMMER · S/N 0084Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Stokes James CN4011BRaven Industries RALLY RX7 · S/N RX7-272Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1981 · Newman Eddie GN1760Lane-Pitts Special S-1 · S/N JL1969Cancelled Jun 5, 2013 · Exported to Canada · Built 1982 · Witwer David WN9388NPiper PA-28R-200 · S/N 28R-35098Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Marshall John EN386BAFairchild F-27 · S/N 22Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1958 · Britt Airways IncN629ZBeech D18S · S/N A-367Cancelled May 31, 2013 · Sale reported, canceled · Built 1947N9999GBeech 35 · S/N D-1209Cancelled May 31, 2013 · Registration expired, pending cancellation · Built 1947 · Thompson William DN99WWOliver CASSUTT III · S/N DJ0-298-1Cancelled May 31, 2013 · Registration expired, pending cancellation · Built 1972 · Nesmith Robert EN424HWGreiner Howard W CH 801 ZENITH AIR · S/N 4851Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 2004 · Takis AlexandrosN9900VCessna 172M · S/N 17264551Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1974 · N9900v IncN54580Douglas C-54E · S/N 27326Cancelled May 23, 2013 · Registration expired, pending cancellation · Southfork CorporationN9616FHughes 269C · S/N 700025Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1970 · Powell Helicopters Inc DBAN96534Taylorcraft BC12-D · S/N 8834Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1946 · Hoffman David LN9205SBeech C23 · S/N M-1693Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1975 · Rainey Joe MN93DPPiccard AX-6 · S/N 743Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1975 · Tejas Aeronauts IncN94201Cessna A185F · S/N 18503288Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1977 · Liggins Clark & Associates Inc
Back to Houston, TX