Skip to content

Cancelled registrations · 122

Query with SQL

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 = 'TYLER' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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

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 = 'TYLER'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N86023Aeronca 11AC · S/N 11AC-435Cancelled Mar 11, 2026 · Sale reported, canceled · Built 1946 N4146Mooney M-18C · S/N 312Cancelled Jan 27, 2024 · Sale reported, canceled · Built 1954 N7516YPiper PA-30 · S/N 30-580Cancelled Sep 6, 2023 · Built 1964 · Walker Dennis H N23282Cessna 150H · S/N 15068847Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Triad Asset Management LLC N7750J3D Robotics Y-6 · S/N 3DR000321204Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Systems Engineering And Laboratories N333WUYuneec Electric TYPHOON Q500 4K · S/N YU15262803B01Cancelled Sep 3, 2022 · Registration expired, pending cancellation · White David J DBA N6872UMooney M20C · S/N 2576Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Built 1963 · Klingman Gerard J Jr N594LBBeech A23 · S/N M-594Cancelled Mar 30, 2021 · Third renewal notice · Built 1964 · George Carl L N4763XCessna 150G · S/N 15064813Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 1966 · Mcelvain Keith N4623XCessna 150G · S/N 15064673Cancelled Nov 12, 2020 · Built 1966 · Sotolongo Kathryn M N113GASlingsby T67C · S/N 2080Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1992 · Soules John Edward N626FGYuneec International TYPHOON Q500 4K · S/N YU 15230549B04B01Cancelled Mar 13, 2019 · Registration expired, pending cancellation · Geissal Matthew P N626HGYuneec International TYPHOON Q500+ · S/N YU15150247B02B01Cancelled Mar 13, 2019 · Registration expired, pending cancellation · Geissal Matthew P N2002ZCessna 150C · S/N 15059802Cancelled May 18, 2018 · Revoked, canceled · Built 1962 · Stracener Mondee N1874KLuscombe 8E · S/N 4601Cancelled Apr 2, 2018 · Revoked, canceled · Built 1947 · Brown Harold T N80462Beech 35 · S/N D-62Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1947 · Gentry Robert L N5813PPiper PA-24-180 · S/N 24-893Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1959 · Mead Duane D N466KTCessna 182H · S/N 18255870Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1964 · Hale Eugene E N77332Cessna 120 · S/N 11774Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Mccarty A T N210WBCessna 150L · S/N 15072838Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1971 · Draffkorn Chris M N869LCessna 182P · S/N 18262557Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1973 · Hale Eugene G N5304CCessna 140A · S/N 15424Cancelled Feb 4, 2017 · Revoked, pending cancellation · Built 1950 · Mccarty At N1025KMantainer PTY ARDATH · S/N MA-1Cancelled Aug 8, 2016 · Third renewal notice · Built 1979 · Howard Anthony E N19065Cessna 150L · S/N 15074137Cancelled May 20, 2015 · Registration expired, pending cancellation · Eitel Thomas H N93509Bellanca 17-31A · S/N 73-32-128Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1973 · Gobfc LLC N7444JPiper PA-28R-180 · S/N 28R-30791Cancelled Dec 27, 2013 · First renewal notice · Built 1968 · Haas Charles D N918ETMesserschmitt-Boelkow-Blohm-Gm BO-105C · S/N S-583Cancelled Dec 23, 2013 · Exported to New Zealand · Built 1982 · E Texas Medical Center Regional Healthcare System N2205DDaun Frank V FW2C8OTR · S/N FW2C80TR06-0393Cancelled Nov 7, 2013 · Registration expired, pending cancellation · Daun Frank V N117TXMesserschmitt BK 117 B-1 · S/N 7177Cancelled Oct 28, 2013 · Exported to Canada · Built 1988 · Mother Frances Hospital N3541NMooney M20F · S/N 680091Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1967 · Zaber Jeffrey A N66TJBeech 200 · S/N BB-42Cancelled Oct 18, 2013 · Registration expired, pending cancellation · Built 1975 · Tyler Jet Aircraft Sales Inc N9018BAeronca 7FC · S/N 7FC-112Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1957 N204PFSlingsby T67C · S/N 2085Cancelled Aug 19, 2013 · Exported to Canada · Built 1993 · Foox G Peter N222NCPiper PA-23-250 · S/N 27-2019Cancelled Aug 2, 2013 · Registration expired, pending cancellation · Built 1962 · Nicholson Donald Eugene N778DBeech C35 · S/N D-3047Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1951 · Hansen Raymond S N8944ZCessna 310G · S/N 310G-0044Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1962 · Trowbridge Raymond M Jr N917ETMesserschmitt-Boelkow-Blohm BO-105S · S/N S-187Cancelled Mar 25, 2013 · Exported to Australia · Built 1974 · E Texas Medical Center Regional Healthcare System N757XACessna 152 · S/N 15280075Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1977 N37945Stokes 105C · S/N CH-X-66Cancelled Nov 13, 2012 · Registration expired, pending cancellation · Built 1977 · Redfearn Jerry N74638Cessna T-50 · S/N 4760Cancelled Sep 14, 2012 · Revoked, canceled · Built 1943 · Ellis Lillian V N125CBCameron Balloons V-56 · S/N 323Cancelled Jun 14, 2012 · Registration expired, pending cancellation · Built 1977 · Nautilus Balloon Works Inc N14TKBeech 65-A90 · S/N LJ-255Cancelled Jun 14, 2012 · Sale reported, canceled · Built 1967 N3681BBeech B50 · S/N CH-78Cancelled Jun 4, 2012 · Registration pending, canceled · Built 1954 N7ZUCessna 550 · S/N 550-0433Cancelled Jul 28, 2011 · Exported to Canada · Built 1982 N32UPGeneral Balloon NEWPORT · S/N 8102Cancelled Jun 30, 2011 · Expired dealer · Koonce Raymond D N1210SSwearingen SA26-T · S/N T26-27Cancelled Mar 2, 2011 · Expired dealer · Built 1968 · Wepco Inc DBA N15MTBeech E-55 · S/N TE-940Cancelled Feb 25, 2011 · Exported to Paraguay · Built 1973 · Sharper Aviation Solutions Inc N303AGMitsubishi MU-2B-25 · S/N 239Cancelled Sep 9, 2005 · Exported to Czech Republic · Built 1972 · Falconmitch Inc N460RBPiper PA-34-220T · S/N 34-8133177Cancelled Apr 26, 2005 · Exported to United Kingdom · Built 1981 · Tyler International School Of Aviation Inc N341BWPiper PA-34-220T · S/N 34-8333058Cancelled Nov 3, 2004 · Exported to Lebanon · Built 1983 · Tyler International School Of Aviation Inc

Back to Tyler, TX