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.

N510LBLindstrand Balloons 77A · S/N 5033Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Built 1997 · Aerial Promotions IncN9761MMooney M20C · S/N 670055Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1967 · Kunka Howard SN4093VCessna 170 · S/N 18425Cancelled Apr 5, 2018 · Revoked, canceled · Built 1948 · Allen Jack HN53722Fairchild M-62A · S/N T411158Cancelled Apr 5, 2018 · Revoked, canceled · Built 1941 · Smith Albert ON97034Stinson 108-1 · S/N 108-1034Cancelled Apr 4, 2018 · Registration expired, pending cancellation · Built 1946 · Holt Stanton GN607BPMcdonnell Douglas Helicopter 600N · S/N RN036Cancelled Apr 2, 2018 · Registration expired, pending cancellation · Built 1998 · Military Museum Of TexasN317HSchlemeyer-Jungmiester Replica 1 · S/N 10Cancelled Mar 16, 2018 · Revoked, canceled · Built 1965 · Cochran William S IIIN3180FCessna 177 · S/N 17700423Cancelled Mar 16, 2018 · Revoked, canceled · Built 1967 · Clyburn James WilliamN3941PPiper PA-22-150 · S/N 22-3616Cancelled Mar 16, 2018 · Revoked, canceled · Built 1956 · Durham I M JrN3963PPiper PA-22-150 · S/N 22-3643Cancelled Mar 16, 2018 · Revoked, canceled · Built 1956 · Rinker GlennN489WBCessna 421B · S/N 421B0223Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 1972 · 45 Srl IncN9752MMooney M20C · S/N 670046Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 1967 · Jackson Mark EN555CXCotton Galen M HELICYCLE · S/N 03-021-E24Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 2005 · Cotton Galen MN56RDSikorsky S-76B · S/N 760368Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 1991 · Rdc Marine IncN265RWBourne Steven M SONERAI II L · S/N 0175Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1987 · Clark Benny J JrN7019MCessna 175 · S/N 55319Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1958 · Kingsbury Cecil R JrN809RDButcher Russell A RV9A · S/N 90781Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 2008 · Schmitt Marcus JN66JRRushing BUSHBY MUSTANG II · S/N MII-350Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Built 1976 · Bordelon Greg MN5076MBeech 76 · S/N ME-62Cancelled Mar 9, 2018 · First renewal notice · Built 1978 · Flying Tigers Flight School LtdN212DHLithuanian Factory Of LAK-12 · S/N 6200Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 1992 · Beck Michael RN931NABoeing KC-135A · S/N 63-7998Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Nasa Johnson Space CenterN8461TPiper PA-28-161 · S/N 28-8216057Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1981 · J & D Aircraft LLCN8567CPiper PA-28-151 · S/N 28-7615118Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1976 · J&D Aircraft LLCN8697RHoney Bee HB · S/N 2Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1966 · Smith Frank C JrN65395Pilatus B4-PC11 · S/N 219Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1976 · Brooks MichaelN7711VAero Commander 520 · S/N 520-19Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1952 · Kaplan Mitchell JN50YAYakovlev YAK-50 · S/N 853009Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Built 1985 · Cooling John BN6724FCameron Balloons US V-77 · S/N 5761Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Built 1991 · Fritsche Alan RN2555GCessna 182B · S/N 51855Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 1959 · Riffle John WN29243Aeronca 65-CA · S/N C10160Cancelled Mar 1, 2018 · Revoked, pending cancellation · Built 1940 · Parks SamN15781Boeing 727-232 · S/N 20636Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 1973 · Continental Airlines Purchasing Services LpN7581MSchild August W S-14 · S/N A 0895084SCancelled Feb 28, 2018 · Registration expired, pending cancellation · Schild August WN1372WMooney M20C · S/N 2653Cancelled Feb 27, 2018 · Registration pending, canceled · Built 1963N1977VKennedy H F AX7 · S/N HAB6Cancelled Feb 27, 2018 · Registration expired, pending cancellation · Ballooning Adventures Of TexasN5489UBeech 95-C55 · S/N TE-422Cancelled Feb 27, 2018 · Registration pending, canceled · Built 1967N919NANorthrop T-38A · S/N 66-8385Cancelled Feb 26, 2018 · Registration expired, pending cancellation · Built 1966 · National Aeronautics And Space AdministrationN8122GKamas Frank T GENESIS · S/N FK0501Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Kamas Frank TN7567WPiper PA-28-180 · S/N 28-1508Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Built 1964 · Murch Sam EN3648Canadair CT-33 · S/N 133648Cancelled Feb 15, 2018 · Registration expired, pending cancellation · Garrison Anthony LynnN40485Lindstrand Balloons 90A · S/N 5065Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1998 · Aerial Promotions IncN8415SCessna 182H · S/N 18256515Cancelled Feb 13, 2018 · Exported to Mexico · Built 1965 · Kane DanielN5343PCessna 152 · S/N 15284922Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 1981 · Pvp Aviation LLCN95289Harmenning HIGH FLYER DELUXE · S/N 006011Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Hughes Scott AN57PZBlakey Richard GENESIS · S/N 6E99/003Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 2008 · Blakey Kerie NicoleN729CSNichols James S EINDECKER E3 · S/N 100903Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 2008 · Nichols James SN55ESCustard Michael L LANCAIR ES · S/N 002MCCancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1994 · Conde Jose CN94775Ercoupe 415-E · S/N 4886Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1948 · Madigan John EN4486GSpitfire II SPITFIRE II · S/N 0502582002Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 2002 · Groover Alyn DN5122CBeech B35 · S/N D-2407Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1950 · Houston Bonanza AssociationN38JBBolding VAN'S RV-3 · S/N 97Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1980 · Keim Tom A
Back to Houston, TX