OpenAirDocs.org
Midlothian, TX

Cancelled registrations · 38

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

N54WPJanicki Steven B RV4 · S/N 2197Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 2009 · Phillips Eric TN4059RPiper PA-32-300 · S/N 32-40364Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 1967 · Lauterbach Dennis RN4687PPiper PA-23-250 · S/N 27-216Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 1960 · Lauterbach Dennis RN2168APiper PA-32RT-300T · S/N 32R-7987010Cancelled Sep 4, 2019 · Third renewal notice · Built 1978 · Ross Charles DN921STAero Commander 690A · S/N 11200Cancelled Jan 22, 2019 · Exported to Canada · Built 1974 · Rodney William Debaun Family LpN145BWWard William F S2A · S/N S2A-1WCancelled Dec 15, 2018 · Registration expired, pending cancellation · Built 1994 · Chastain Gregory TN193QBeech S35 · S/N D-7708Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1964 · Bennett Robert DN714HMCessna 150M · S/N 15079189Cancelled Jun 5, 2018 · Registration expired, pending cancellation · Built 1977 · Cole RandallN4VXSibley Alfred E GLASAIR · S/N 301Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 1985 · Hall MarkN65857Cessna 172P · S/N 17275907Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1983 · Aeroplace Services IncN2559RPiper PA-28-180 · S/N 28-5648Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1969 · Bowling James LN6667ZPiper PA-25-235 · S/N 25-2268Cancelled Apr 17, 2014 · Third renewal notice · Built 1963 · Texas Soaring Association IncN85BHBell 206B · S/N 3792Cancelled Feb 7, 2014 · Built 1984 · Lauterbach DennisN41HEAero Commander 680FL · S/N 1396-53Cancelled Sep 27, 2013 · Registration expired, pending cancellation · Built 1964 · Millet Barron PN3904NBell Helicopter Textron 206L-1 · S/N 45605Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Lauterbach Dennis R DBAN965SLLadner Stanley PIETENPOL AIRCAMPER · S/N AS965Cancelled Aug 8, 2013 · Sale reported, canceledN3869XAero Commander 100 · S/N 166Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1967 · Clemmons JeritaN9783UGrumman American Avn. AA-1C · S/N AA1C0121Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1977 · Aeroplace Services IncN8164RBeech 95-B55 (T42A) · S/N TC-1746Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1974 · Cothron LesN761DKCessna T210M · S/N 21062172Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1977 · Martinez Juan M DBAN4091JCessna 150G · S/N 15065391Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Built 1966 · Clemmons JeritaN4487JPiper PA-28-140 · S/N 28-22905Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Built 1967 · Aeroplace Services IncN4506PPiper PA-23-250 · S/N 27-9Cancelled Nov 9, 2012 · Sale reported, canceled · Built 1960N20220Beech F33A · S/N CE-800Cancelled Aug 22, 2012 · Registration expired, pending cancellation · Built 1978 · Aeroplace Services IncN6389APiper PA-38-112 · S/N 38-78A0407Cancelled Jun 4, 2012 · Exported to El Salvador · Built 1978 · Dillon Michael CN510SPPeroyea John L II EXEC 162F · S/N 6172Cancelled Feb 24, 2010 · Exported to Canada · Peroyea John L IIN30WKSchleicher ASW-20B · S/N 20641Cancelled Nov 16, 2009 · Triennial form not returned · Built 1983 · Rider JamesN727LVDe Dominicis Hector RV-6 · S/N 001Cancelled Feb 23, 2009 · Exported to Netherlands · Built 1998 · Rv Training LLCN17TSPdps Pzl-Bielsko SZD-50-3 · S/N B-2109Cancelled Jul 30, 2007 · Exported to Australia · Built 1997 · Texas Soaring Association IncN911TCMcdonnell Douglas Helicopter 600N · S/N RN020Cancelled Oct 20, 2000 · Exported to Mexico · Cherokee AviationN123SVNord STAMPE SV4C · S/N 294Cancelled Jun 26, 2000 · Triennial form not returned · Peterson Don Collins IIIN520DDMcdonnell Douglas Helicopter 500N · S/N LN030Cancelled Jun 2, 1997 · Exported to Venezuela · Cherokee AviationN270LPCessna 340A · S/N 340A0917Cancelled Mar 20, 1997 · Exported to Philippines · Aeroplace Services IncN4586WRockwell International 112TC · S/N 13076Cancelled Sep 17, 1996 · Triennial form not returned · Carstens Fred D JrN17959Schweizer SGS 2-33AK · S/N 259Cancelled Jul 26, 1980 · Built 1972 · Texas Soaring AssocN731DXCessna A188B · S/N 18802825TCancelled Jun 10, 1980 · Exported to Canada · Red Bird Aircraft Sales IncN11819Cessna 150L · S/N 15075647Cancelled Aug 17, 1977 · Exported to Canada · Lauterbach Dennis RN9024BAeronca 7FC · S/N 7FC-116Cancelled Jun 17, 1974 · Exported to Canada · Curb Marvin N
Back to Midlothian, TX