OpenAirDocs.org
Ft Worth, TX

Cancelled registrations · 476

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 = 'FT WORTH'
  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.

N92969Commonwealth 185 · S/N 1702Cancelled Nov 4, 2023 · Revoked, canceled · Built 1946 · Cole William HN2981FCessna T210G · S/N T210-0277Cancelled May 7, 2022 · Registration expired, pending cancellation · Tarrant County College DistrictN103BNAirrobot US AR180 · S/N 00420Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Bnsf Railway Uas ProgramN108BN3D Robotics SPEKTRE · S/N S-101Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Bnsf Railway Uas ProgramN4121BAero Commander 520 · S/N 520-24Cancelled Jul 13, 2021 · Second renewal notice · Built 1952 · Tarrant County Junior CollegeN902RACessna 172L · S/N 17260190Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1971 · Rich Aviation Services LLCN40163Stinson 108 · S/N 108-93Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1946 · Devenney Michael WN620RTCessna 414 · S/N 414-0378Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Rvr Aircraft Sales LLCN78GJIsrael Aircraft Industries 1124 · S/N 310Cancelled Mar 9, 2020 · First renewal notice · Built 1980 · Tai Acquisition Corp DBAN33BNDJI INSPIRE 1 · S/N W13DCL21060530Cancelled Jan 31, 2020 · Registration expired, pending cancellation · Bnsf Railway Uas ProgramN90101Cessna 120 · S/N 9162Cancelled Nov 1, 2019 · Revoked, canceled · Built 1946 · Hyson BillN4851NBoeing A75L3 · S/N 756872Cancelled Sep 20, 2019 · Revoked, canceled · Martin Ruth CN504BNSensefly EXOM · S/N EX-01-26568Cancelled Sep 5, 2019 · Registration expired, pending cancellation · Bnsf Railway Uas ProgramN430EXBell Helicopter Textron Canada 430 · S/N 49001Cancelled Dec 19, 2018 · Built 1995 · Bell Helicopter Textron IncN49865Cessna 152 · S/N 15281369Cancelled Sep 17, 2018 · Exported to Taiwan · Built 1978 · Gold Star Aviation IncN11545Cessna 150L · S/N 15075507Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1973 · Krone Robert PrestonN559AAMcdonnell Douglas DC-9-82(MD-82) · S/N 53089Cancelled Apr 23, 2018 · Built 1991 · American Airlines IncN64658Consolidated Vultee BT-13 · S/N 2058Cancelled Apr 5, 2018 · Revoked, canceled · Built 1941 · Morrow Fred ON252GBeech V35B · S/N D-10266Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Built 1979 · Avprop LLCN5298MCessna 152 · S/N 15284519Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Luna LindaN75521Cessna 172N · S/N 17267778Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Built 1976 · Sawicki DonaldN552APPower Andrew J RANS S6S · S/N 7076Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Power Andrew JN2217GPiper PA-28-181 · S/N 28-7990209Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 1978 · Swint James M JrN118TTBeech B35 · S/N D-2602Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1950 · Burgin LeeN1166Beech 35 · S/N D-460Cancelled Oct 28, 2017 · Revoked, canceled · Built 1947 · Morrow Timothy WN16614Graywolf TEENIE TWO · S/N 5-10792Cancelled Oct 28, 2017 · Revoked, canceled · Built 1975 · Graywolf LucasN214CECessna T206H · S/N T20608592Cancelled Sep 11, 2017 · Exported to Paraguay · Built 2006 · Hrsh LLCN5530MAero Commander 100 · S/N 116Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1967 · Griffin DaleN94377Cessna 152 · S/N 15285658Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1982 · Qualiflight Training IncN67650Cessna 152 · S/N 15281962Cancelled Feb 16, 2017 · Registration expired, pending cancellation · Built 1978 · Poulikakos MichaelN7387CBeech C-45F · S/N 44-87390Cancelled Feb 4, 2017 · Revoked, canceled · Built 1963 · Allright Investments IncN543VSBell Helicopter Textron Canada 407 · S/N 54161Cancelled Jun 19, 2015 · Bell Helicopter Textron IncN3312CBeech E35 · S/N D-3978Cancelled May 8, 2015 · Registration expired, pending cancellation · Built 1954 · Eng Clifford KN86853Bellanca 14-13 · S/N 1215Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1946 · Paara Ronald DN30NLGasparek Nickie L SCAMP · S/N NLG3Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1992 · Parran Anthony W SrN34397Meyers Industries 200B · S/N 279Cancelled Dec 22, 2014 · Revoked, canceled · Built 1963 · Wright Marion HN69034Republic F-47 · S/N 4222504Cancelled Dec 22, 2014 · Revoked, canceled · Cobell Industries IncN6031UChristen Industries PITTS S-2B · S/N 5122Cancelled Dec 18, 2014 · Registration expired, pending cancellation · Built 1987 · Rawls Vernon CN45AKStinson L-5G · S/N 4618Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1946 · Asher Gerald WN99USPiccard AX-6 · S/N 699Cancelled Dec 1, 2014 · Registration expired, pending cancellation · Built 1974 · Conn Richard C DBAN8213MPiper PA-32-301 · S/N 32-8006050Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1980 · Armadillo EnterprisesN8109XCessna 172B · S/N 17248609Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1961 · Conley Bernie EN7045ECessna 175A · S/N 56545Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1960 · Avemco Aircraft Investment CorpN711JPiper PA-23 · S/N 23-190Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1956 · Maciokas Thomas MN4598RPiper PA-28-140 · S/N 28-21345Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1965 · Badgero Jack IN2617VCessna 170 · S/N 18127Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1948 · Champion David WN10811Cessna 150L · S/N 15075055Cancelled Sep 8, 2014 · Registration expired, pending cancellation · Built 1973 · Holzapfel Kris GaleN431UTBell 430 · S/N 49011Cancelled Dec 4, 2013 · Third renewal notice · Built 1996 · Bell Helicopter Textron IncN5053KSargent Kenneth GRASSHOPPER D-8 · S/N 001Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1962 · Renshaw Kevin JN479RBBell Helicopter Textron Canada 429 · S/N 57116Cancelled Oct 28, 2013 · Exported to Turkey · Built 2012 · Bell Helicopter Textron Inc
Back to Ft Worth, TX