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.

N2724YBeech 95 · S/N TD-63Cancelled Oct 18, 2019 · Revoked, pending cancellation · Built 1958 · Steely Robert LN755BUTarot T18 · S/N 427B0AEEBA1AE875E635D8CFBC12D6Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Unmanned Trop ReconnaissanceN22018Luscombe 8 · S/N 868Cancelled Oct 4, 2019 · Revoked, canceled · Built 1938 · Kastrop Robert RN6684BBeech 200 · S/N BB-631Cancelled Oct 4, 2019 · Exported to Mexico · Built 1980 · Projets IncN1309CPiper PA-22 · S/N 22-1121Cancelled Oct 2, 2019 · Revoked, canceled · Built 1953 · Condon Charles JN2858YCessna 182E · S/N 18253858Cancelled Sep 20, 2019 · Revoked, canceled · Built 1962 · Crane Rental CorporationN686ZWDJI PHANTOM 3 PROFESSION · S/N P76DCG02016194Cancelled Sep 9, 2019 · Registration expired, pending cancellation · Worley Robert TN689FPDJI PHANTOM 3 PROFESSION · S/N P76DCH22A27441Cancelled Sep 9, 2019 · Registration expired, pending cancellation · Satterfield And Pontikes Construction IncN689MJDJI PHANTOM 3 PROFESSION · S/N P76DCF17016256Cancelled Sep 9, 2019 · Registration expired, pending cancellation · Satterfield And Pontikes Construction IncN1310DCessna 170A · S/N 19886Cancelled Sep 6, 2019 · Revoked, canceled · Built 1951 · Wilborn Alton WN19845Taylorcraft A · S/N 350Cancelled Sep 6, 2019 · Revoked, canceled · Built 1937 · Ward Arlen RN199MRDJI Innovations PHANTOM 3 PROFESSION · S/N P76DCH26A20695Cancelled Sep 6, 2019 · Registration expired, pending cancellation · London Offshore ConsultantsN632PPDJI PHANTOM 3 PROFESSION · S/N P76DCG08016811Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Slocum Productions LLCN689JSDJI PHANTOM 2 VISION + · S/N PH646030068Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Satterfield And Pontikes Construction IncN689KPDJI PHANTOM 2 VISION + · S/N PH646029941Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Satterfield And Pontikes Construction IncN689LJDJI PHANTOM 3 PROFESSION · S/N P76DCG23010525Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Satterfield And Pontikes Construction IncN689NSDJI PHANTOM 3 PROFESSION · S/N P76DCF22017122Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Satterfield And Pontikes Construction IncN85998Aeronca 11AC · S/N 11AC418Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Ingram Keith SN9012RRuiz E RAF 2000 · S/N H2-99-10-436Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1999 · Grosshans John MichaelN9247ACessna 170B · S/N 19008Cancelled Sep 6, 2019 · Revoked, canceled · Built 1949 · South Texas Flying EnterpriseN981AAArch Aerial ARCH AERIAL OCTO · S/N AA15103Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Arch Aerial LLCN990AAArch Aerial ARCH AERIAL OCTO · S/N AA15102Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Arch Aerial LLCN91137North American NAVION · S/N NAV-4-31Cancelled Sep 4, 2019 · Registration expired, pending cancellation · Built 1946 · Holmes Marion LN212NAPiper PA-28-161 · S/N 28-7916150Cancelled Aug 28, 2019 · Second renewal notice · Built 1978 · Ahmed SharfarazN203RJHawker Beechcraft B300 · S/N FL-837Cancelled Aug 26, 2019 · Exported to Canada · Built 2013 · Joy Holdings Management LLCN7579JPiper PA-28R-180 · S/N 28R-30969Cancelled Aug 20, 2019 · First renewal notice · Built 1968 · Flying Tigers Flight School LtdN719CCIsrael Aircraft Industries 1124 · S/N 290Cancelled Aug 13, 2019 · Built 1980 · Avalair Aircraft Management LLCN7408CLockheed PV-1 · S/N 151234Cancelled Aug 5, 2019 · Revoked, canceled · Aviation Sales And Engng CoN477TCCirrus Design SR20 · S/N 1378Cancelled Jul 25, 2019 · Registration expired, pending cancellation · Built 2003 · Air Akhtar Heating & Air Conditioning LLCN8FAEurocopter AS 350 B3 · S/N 4400Cancelled Jul 10, 2019 · Exported to Kenya · Built 2008 · Friedkin Aviation IncN61939Boeing A75N1 · S/N 752712Cancelled Jul 5, 2019 · Revoked, canceled · Built 1941 · Aero SprayersN34TRBearce Duane G S-5/RANS · S/N 0703334Cancelled Jun 13, 2019 · Built 2008 · Bearce Duane GN983AAArch Aerial ARCH AERIAL OCTO · S/N AA15100Cancelled May 6, 2019 · Registration expired, pending cancellation · Arch Aerial LLCN983NURobert W Smith DJI S900 · S/N U1RE11Cancelled May 6, 2019 · Registration expired, pending cancellation · National Aeronautics And Space AdministrationN985AAArch Aerial ARCH AERIAL OCTO · S/N AA15101Cancelled May 6, 2019 · Registration expired, pending cancellation · Arch Aerial LLCN281WDTrimble Navigation ZX5 · S/N ZX50041507371Cancelled May 4, 2019 · Registration expired, pending cancellation · Western Data Systems IncN9706UGrumman American Avn. AA-5A · S/N AA5A-0106Cancelled Apr 16, 2019 · Registration expired · Built 1976 · Flying Tigers Flight School LtdN193BMCessna 152 · S/N 15283399Cancelled Apr 10, 2019 · Exported to Peru · Built 1979 · Flight School IncN660TL3D Robotics SOLO · S/N S111A5701544Cancelled Mar 23, 2019 · Registration expired, pending cancellation · Trumbull Unmanned LLCN661TLLockheed Martin Procerus Tech AG INDAGO · S/N 3600Cancelled Mar 23, 2019 · Registration expired, pending cancellation · Trumbull Unmanned LLCN937WDTrimble Navigation UX5 · S/N EBX00626Cancelled Mar 16, 2019 · Registration expired, pending cancellation · Western Data Systems IncN30604Cessna 177A · S/N 17701354Cancelled Mar 9, 2019 · Registration expired, pending cancellation · Built 1969 · Wilson Russell EN557RFAscending Technologies ASCTEC FALCON 8 · S/N 30326-F377Cancelled Mar 9, 2019 · Registration expired, pending cancellation · Forte Jason TN778PSikorsky S-76A · S/N 760035Cancelled Mar 4, 2019 · Sale reported, canceledN246CABeech F90 · S/N LA-27Cancelled Mar 2, 2019 · Registration expired, pending cancellation · Built 1980 · Aceite Aviation LLCN507PFJim Faist CALIDUS · S/N C00282Cancelled Mar 2, 2019 · Registration expired, pending cancellation · Built 2014 · Barnhart Constructors IncN9415KStinson 108-2 · S/N 108-2415Cancelled Feb 26, 2019 · Registration expired, pending cancellation · Built 1947 · Alpe Louis AN3392BPiper PA-18-135 · S/N 18-3316Cancelled Feb 19, 2019 · Revoked, canceled · Built 1954 · Holder Robert LN662TLSensefly EXOM · S/N EX-01-23745Cancelled Feb 12, 2019 · Registration expired, pending cancellation · Trumbull Unmanned LLCN120FFPiper PA-28-161 · S/N 28-8016306Cancelled Feb 8, 2019 · Exported to Colombia · Parra Carlos Alberto Riveros
Back to Houston, TX