OpenAirDocs.org
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.

N140TUEngine8 ARES · S/N 1001Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Trumbull Unmanned LLCN141TUEngine8 ARES · S/N 1002Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Trumbull Unmanned LLCN142TUEngine8 ARES · S/N 1003Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Trumbull Unmanned LLCN2187NCessna 140 · S/N 12423Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 1947 · Weiss Jeffrey CN551BAEurocopter Deutschland EC 135 P2+ · S/N 0188Cancelled Aug 18, 2022 · Exported to Canada · Built 2001 · Era Leasing LLCN689GPDJI PHANTOM 2 VISION PLU · S/N PH645473355Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Satterfield And Pontikes Construction IncN8113SCessna 150F · S/N 15061713Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1965 · Martin Max ON984NURobert W Smith DJI S900 · S/N U1RE12Cancelled Jul 30, 2022 · Registration expired, pending cancellation · National Aeronautics And Space AdministrationN985NURobert W Smith DJI S900 · S/N U1RE13Cancelled Jul 30, 2022 · Registration expired, pending cancellation · National Air And Space AdministrationN369MMBuckeye Powered Parachutes BUCKEYE · S/N 3105Cancelled Jul 25, 2022 · Registration expired, pending cancellation · Built 1993 · Morris Michael DN2766RPiper PA-28R-200 · S/N 28R-35285Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 1969 · Flying Tigers Flight School LtdN631DWSensefly EBEE · S/N EB-03-07889Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Burns & Mcdonnell Engineering Co IncN71HSJiangxi Hongdu AV Ind CJ-6 · S/N 6232039Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 1996 · Karow Robert JN74521Mooney M20B · S/N 1908Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Mooney N74521 LLCN9745UGrumman American Avn. AA-5A · S/N AA5A-0145Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 1976 · Flying Tigers Flight School LtdN630YZDJI INSPIRE 1 · S/N W13DCI05040424Cancelled May 9, 2022 · Registration expired, pending cancellation · Burns & Mcdonnell Engineering Company IncN94446Swonke Larry J ANTARES-MA-32 · S/N 17-97Cancelled May 9, 2022 · Registration expired, pending cancellation · Built 1997 · Swonke Larry JN631CYDraganfly Innovations DRAGANFLYER X4-ES · S/N 288A76Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Burns & Mcdonnell Engineering Co IncN501CERaytheon 58 · S/N TH-1888Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1999 · Weiss Jeffrey CN599LXDJI INSPIRE 1 · S/N W13DBL 120 104 78Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Stephens Brian KN604NJDJI PHANTOM 3 ADVANCED · S/N P76DCF23013447Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Jefferies Brendan RN17AEEclipse EA500 · S/N 000017Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 2007 · Farrington Aviation LLCN214JKCirrus Design SR22 · S/N 1588Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 2005 · Avjel LLCN417WTBell 206B · S/N 4591Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 2005 · W T Byler Co IncN337SDCessna M337B · S/N 337M0266Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 1968 · Stahl Timothy HN86JBBlanton David L ACRO SPORT II · S/N 502Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 2006 · O Donnell Thomas EN94GHCessna 650 · S/N 650-0021Cancelled Nov 20, 2021 · First renewal notice · Built 1983 · Starflite Management Group IncN30625North American/Germain T-28C · S/N 140625(226-202)Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1957 · St Germain Raymond JN770AABeech A36 · S/N E-1413Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1978 · Davison Industries IncN314CHDJI MAVIC PRO · S/N 08Q2F3Q00S1254Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Mullen Lachlan SN7111ECessna 182B · S/N 52111Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Built 1959 · Cole ArthurN8ACMidget Mustang G · S/N 209Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Larue James C JrN711RRGlasflugel STANDARD LIBELLE · S/N 80Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 1969 · Watkins Raymond SN81193Grumman Aircraft ENG C-1A · S/N 146052Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 1955 · Lone Star Flight MuseumN591MEIsrael Aerospace Industriesltd GULFSTREAM G150 · S/N 253Cancelled Aug 9, 2021 · Exported to Canada · Built 2008 · Jlr Holdings I LLCN260CMChristen Industries PITTS S-2B · S/N 5192Cancelled Aug 5, 2021 · Exported to Canada · Built 1990 · Abbott Todd CN25131Silverman SPEZIO DAL-1 · S/N 309Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1976 · Lundquist Eric J JrN7411FHughes 269C · S/N 650410Cancelled Jul 20, 2021 · Built 1975 · City Of HoustonN7491FHughes 269C · S/N 350400Cancelled Jul 20, 2021 · Built 1975 · City Of HoustonN9298FHughes 269C · S/N 650416Cancelled Jul 20, 2021 · Built 1975 · City Of Houston Police DepartmentN575NCessna 337C · S/N 337-0927Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Built 1968 · Aquarius Gas Marketing IncN2279YCameron Balloons Z-65 · S/N 6527Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 2008 · Aerial Promotions IncN6871UMooney M20C · S/N 2575Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1963 · Burroughs Earl JosephN910SAmerican Eurocopter AS350B3 · S/N 7446Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 2012 · Enbridge Energy Co IncN260HRaytheon Corporate Jets BAE 125-800A · S/N 258248Cancelled Apr 19, 2021 · Exported to Mexico · Built 1993N1310HRaytheon Corporate Jets BAE 125-800 · S/N 258253Cancelled Mar 10, 2021 · Exported to Mexico · Built 1994 · Projets IncN2407YCessna 172D · S/N 17249707Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1962 · Blackhawk Aviation LLCN4002MCameron Balloons Z-65 · S/N 6443Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Aerial Promotions IncN4052RLindstrand Balloons 90A · S/N 5040Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1997 · Aerial Promotions IncN4056RCameron Balloons Z-65 · S/N 6441Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Aerial Promotions Inc
Back to Houston, TX