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.

N140TCCreekmore Thomas D TEAM ROCKET F-1 · S/N 030Cancelled May 21, 2013 · Registration expired, pending cancellation · Built 2002 · Creekmore Thomas DN3731JCessna 150G · S/N 15065031Cancelled May 21, 2013 · Registration expired, pending cancellation · Built 1966 · Sky AdsN9010PPiper PA-24-260 · S/N 24-4471Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1966 · Washburn Thomas NN9044ZRobinson Helicopter R22 · S/N 0114Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1981 · H D C Equipment CoN1062LAdams Balloon A55 · S/N 063Cancelled May 16, 2013 · Registration expired, pending cancellation · Built 1980 · Mccreary Mark DN86088Cessna 337D · S/N 337-1073Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1969 · Budziszewski Thomas NN8646GCessna 150F · S/N 15062746Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1966 · Chase Paul T SrN87755Cessna 337A · S/N 337-0334Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1967 · Turner JamesN87766Hiller UH-12D · S/N 1090Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1959 · B&H Service Co IncN87USPiccard AX-6 · S/N 687Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1974 · Tejas Aeronauts IncN8876EPiper PA-28-181 · S/N 28-7690228Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1976 · B & T FlyingN2962MPiper PA-12 · S/N 12-1356Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1946 · Harrison J D JrN824QBeech 65 · S/N LC-28Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1961 · Wooldridge Raymond EN8335GCessna 150F · S/N 15062435Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1965 · Brown Edwin W JrN8387EMooney M20A · S/N 1586Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1960 · Krouse Robert FN8522GCessna 150F · S/N 15062622Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1965 · Globexim IncN642CBCessna 421B · S/N 421B0010Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1970 · Pratt Peter E Jr ReceiverN8071ECessna 172N · S/N 17272127Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1978 · Powell Kenneth WN81355Fairchild 24W-46 · S/N W46255Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1946 · Satterfield W SN817GBeech 65 · S/N LC-31Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1960 · Seaback Homes IncN5435LGrumman American Avn. AA-5 · S/N AA5-0335Cancelled May 10, 2013 · Sale reported, canceled · Built 1973N714WKCessna 152 · S/N 15279488Cancelled May 10, 2013 · Sale reported, canceled · Built 1977N777BPDeland-Keller COUGAR I · S/N JPB-1Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1974 · Crunk Douglas WN78USPiccard AX-6 · S/N 678Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1973 · Murtorff BillN758PSCessna R172K · S/N R1723257Cancelled May 8, 2013 · Registration expired, pending cancellation · Herlong William BryonN76388Cessna 140 · S/N 10809Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1946 · Mathis Robert L JrN1388KBallard Bobby J QUICKIE I · S/N 0386Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1982 · Mcdade Ross E IIIN731TTCessna P210N · S/N P21000547Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1980 · World Jet Sales IncN73849Cessna 172N · S/N 17267720Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1976 · Habelman Alfred CN7216LPiper PA-25-235 · S/N 25-7405583Cancelled May 6, 2013 · Registration expired, pending cancellation · Built 1974 · Franks Crop Dusting Service IncN418LGCessna 421B · S/N 421B0541Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1973 · Davis Joseph VN711BRLockheed 18-56 · S/N 2208Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1942 · Wheeler LeonN68796Cessna 152 · S/N 15282379Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1978 · Cruse Aviation IncN6913VMooney M20F · S/N 22-1293Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1975 · R & R LeasingN92FChilmonik Robert RV-6A · S/N 20456Cancelled May 2, 2013 · Registration expired, pending cancellation · Chilmonik RobertN67RCCessna T210L · S/N 21059935Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1973 · Mattco Investment CorpN6426WPiper PA-28-140 · S/N 28-20496Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1964 · Lambert Gary LN6169QCessna 152 · S/N 15285181Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1981 · Mort Hall Aviation IncN2114EBeechcraft-Hawker BH-125-600A · S/N 256022Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1973 · Arnoni Aviation IncN25056Cessna 152 · S/N 15280519Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1977 · Sauberli Keith AN6009NStevens AKRO · S/N 0002BCancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1969 · Alfanco IncN6052XMooney M20A · S/N 1643Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1960 · Rodgers Richard B DBAN605FLPiper PA-28-140 · S/N 28-7125481Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1971 · Jones Lawrence JN60911Cessna 150J · S/N 15070662Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1969 · Brandon Gary SN5912VPiper PA-34-200T · S/N 34-7770270Cancelled Apr 24, 2013 · Registration expired, pending cancellation · Built 1977 · Gulf Coast Aero ServicesN5719TRaven Industries RALLY RX7 · S/N RX7-260Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1981 · Veir David AN5831CBeech C35 · S/N D-2783Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1951 · Smith Alvin NN53979Bellanca 7ECA · S/N 1156-76Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1976 · Hutton Rex MartinN43191Piper PA-34-200 · S/N 34-7450182Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Built 1974 · G & W PartnershipN3172Haselwood TEENIE TWO · S/N 510565Cancelled Apr 16, 2013 · Registration expired, pending cancellation · Built 1969 · Haselwood James S Jr
Back to Houston, TX