Skip to content

Cancelled registrations · 146

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

N4426ZPzl-Swidnik PW-5 · S/N 17.09.012Cancelled Sep 9, 2026 · Built 1997 · Barchie James N302HHHam Howard S CLASSIC · S/N C0110Cancelled Jun 22, 2026 · Sale reported, canceled · Built 1995 N6798TCessna 310D · S/N 39098Cancelled Dec 4, 2023 · Built 1960 · Hodges Eric E N4216JPiper PA-28-140 · S/N 28-22564Cancelled Sep 22, 2023 · Built 1966 · Sivunigunta Satya N621EWCessna 172L · S/N 17260545Cancelled Aug 7, 2023 · Registration pending · Built 1972 N9430XCessna 182R · S/N 18268522Cancelled Apr 26, 2023 · Built 1985 · Energy Transfer Aviation LLC N7452ECessna 210 · S/N 57152Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Pooler Charles T N387WSDJI MAVIC PRO · S/N 08QCE960223YNYCancelled Mar 4, 2023 · Registration expired, pending cancellation · Shea Michael N883DWPiper PA-23 · S/N 23-443Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1956 · Wilkerson Nathaniel N285WBWebber Tim B CHALLENGER 2PL STD · S/N CH2-0797-B-1634Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Webber Tim N24175Beech 95-B55 (T42A) · S/N TC-2125Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Built 1978 · Lasley Charles D N991UAUnmanned Ad-Hoc Industries HIGH ENDURANCE FOLD · S/N HEFF 004Cancelled Jun 14, 2022 · Registration expired, pending cancellation · Unmanned Ad Hoc Industries Inc N992UADJI SPREADINGWINGS S1000 · S/N 03Q0012399Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Unmanned Ad-Hoc Industries Inc N771JMartin Joe R 1 · S/N 10001Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1988 · Martin Joe R N990UAUnmanned Ad-Hoc Industries HIGH ENDURANCE FOLD · S/N HEFF 002Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Unmanned Ad-Hoc Industries Inc N13LLDJI PHANTOM VISION 2+ · S/N PH645495837Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Blessing Brian N94777Carnett John R BUCKEYE · S/N 001Cancelled Apr 5, 2021 · Registration expired, pending cancellation · Built 2002 · Carnett John R N3442BBeech D35 · S/N D-3680Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Holmes John K N82601Aerovodochody L-29 DELFIN · S/N 792661Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Built 1967 · Dyczko Stephen Allen N344LMYakovlev YAK 18T · S/N 0833Cancelled Sep 11, 2020 · Exported to Canada · Built 1993 · Hergenrather Michael L N67659Bell 206B · S/N 5185Cancelled Jul 10, 2020 · Sale reported, canceled · Built 1994 N7703JPiper PA-32-260 · S/N 32-1070Cancelled Feb 13, 2020 · Built 1968 · Baptista Jose R N906BAS N I A S AS-350B ECUREUIL · S/N 1479Cancelled Dec 2, 2019 · Registration expired, pending cancellation · Built 1981 · Helicopter Services Inc N773AVYuneec TYPHOON Q500+ · S/N YU15130229B02B01Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Luley Enterprises Inc DBA N774AVYuneec TYPHOON H · S/N YU16190018B08A01Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Luley Enterprises Inc N670HRDJI INSPIRE 1 PRO · S/N W13DCK11051527Cancelled Nov 4, 2019 · Registration expired, pending cancellation · All Aerial Access LLC N728EPDJI PHANTOM 3 PROFESSION · S/N P76DCD30011934Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Pinpoint Drone Imagery LLC N734BYCessna 172N · S/N 17268737Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1977 · Burke John E N3633DCessna 310 · S/N 35333Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1956 · Dorris James P N777GSBeech A100 · S/N B-241Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1978 · Fire Fighter Tool Supply Inc N8809TCessna 182C · S/N 52709Cancelled Sep 6, 2019 · Revoked, canceled · Built 1960 · Lee John S DBA N350BHEurocopter AS 350 B2 ECUREUIL · S/N 2813Cancelled Dec 31, 2018 · Exported to Panama N993UADJI Innovations INSPIRE 1 · S/N W13DCE15030042Cancelled Dec 14, 2018 · Registration expired · Unmanned Ad-Hoc Industries Inc N278RGS N I A S AS350BA · S/N 1355Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 1980 · Helicopter Services Inc N217LNMesserschmitt-Bolkow-Blohm BK 117 B-2 · S/N 7042Cancelled Jun 27, 2018 · Exported to Canada · Built 1984 · Gulf State Aviation LLC N14AVAero Commander 500-A · S/N 500A-914-22Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1960 · Aerial Viewpoint Aerial Photography N40431Robinson Helicopter R44 II · S/N 14197Cancelled May 1, 2018 · Exported to Tunisia · Gulf State Aviation LLC N6GYYoung Gregory RV-6 · S/N 23070Cancelled May 1, 2018 · Built 2001 · Young Gregory N1239GCessna 310Q · S/N 310Q1090Cancelled Mar 29, 2018 · Second renewal notice · Built 1974 · Potters Gertrude M N3350PPiper PA-23-160 · S/N 23-1303Cancelled Mar 16, 2018 · Revoked, canceled · Built 1958 · Rnk Ranch Inc N2865ARogers Lonnie K QUICKSILVER SPORT II · S/N 1042053Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 2000 · Reenders Michael D N160RGGalbraith Ronald L LONG EZ · S/N 88-1704Cancelled Feb 26, 2018 · Registration pending, pending cancellation · Built 1989 N5308HCameron Balloons US V-90 · S/N 6145Cancelled Feb 6, 2018 · Registration expired · Built 1998 · Hand Donald E Jr N29317Cessna 177 · S/N 17700808Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1968 · Travland Lawrence D N83742Aeronca 7AC · S/N 7AC2420Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1946 · Del Martin L P N425DMCessna 425 · S/N 425-0098Cancelled Oct 23, 2017 · Exported to Canada · Built 1981 · Balboa Island Services LLC N825XGGreen Charles Edwin HUMMELBIRD · S/N 12151951Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Green Charles Edwin N19GWPiper PA-28-140 · S/N 28-7625021Cancelled Oct 19, 2017 · Registration expired, pending cancellation · Built 1975 · Westerfield Mark H N51RMPiper PA-31T1 · S/N 31T-8004054Cancelled Oct 19, 2017 · Registration expired, pending cancellation · Built 1980 · Pastrana Juan Trustee N4322PPiper PA-23-160 · S/N 23-1823Cancelled May 22, 2017 · Registration expired, pending cancellation · Built 1959 · Kaur Rajeeep

Back to Spring, TX