Skip to content

Cancelled registrations · 159

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

N369AEBoeing 737-8Q8 · S/N 33699Cancelled Aug 6, 2024 · Exported to Democratic Republic of the Congo · Built 2003 · Hemisphere Aerospace Investments LLC N88216Piper J3C-65 · S/N 15833Cancelled Jun 17, 2023 · Revoked, canceled · Built 1946 · Central Dusting & Spraying Svc N6327Timothy A Hays ZODIAC CH650 B · S/N 65-10665Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 2020 · Hays Timothy A N512JJCessna 421C · S/N 421C1410Cancelled Apr 18, 2022 · Exported to Canada · Built 1984 · Rio Brazos Investments Group LLC N970KKBeech 300 · S/N FA-29Cancelled Jun 23, 2021 · Exported to Guatemala · Built 1985 · Blackhawk Modifications Inc N5098JCessna 172N · S/N 17273701Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 1979 · State Of Texas N569SHHoward Stephen R HOWARD II · S/N 569Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1997 · Howard Stephen R N22215Taylorcraft BF · S/N 1153Cancelled Oct 4, 2019 · Revoked, canceled · Built 1939 · Miller Jerry G N9625LGrumman American Avn. AA-1B · S/N AA1B-0125Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1973 · Brown Daniel R N1327HAeronca 15AC · S/N 15AC-362Cancelled Jun 25, 2019 · Revoked, pending cancellation · Built 1949 · Waco Avia Sch Inc N95571Cessna 152 · S/N 15285931Cancelled Jan 25, 2019 · Registration expired, pending cancellation · State Of Texas N9452DCessna 172RG · S/N 172RG1168Cancelled Jan 8, 2019 · Registration expired, pending cancellation · Built 1984 · State Of Texas N95563Cessna 152 · S/N 15285926Cancelled Jan 8, 2019 · Registration expired, pending cancellation · Built 1984 · State Of Texas N95564Cessna 152 · S/N 15285927Cancelled Jan 8, 2019 · Registration expired, pending cancellation · Built 1984 · State Of Texas N95566Cessna 152 · S/N 15285929Cancelled Jan 8, 2019 · Registration expired, pending cancellation · Built 1984 · State Of Texas N95570Cessna 152 · S/N 15285930Cancelled Jan 8, 2019 · Registration expired, pending cancellation · Built 1984 · State Of Texas N3601RPiper PA-28-180 · S/N 28-5707Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 1970 · Texas State Technical College N3104KSuperior CULVER V · S/N V-323Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1946 N47689Aeronca 0-58B · S/N 058B5272Cancelled Jun 26, 2018 · Revoked, pending cancellation · Built 1943 · Kiesz Albert C N43DRGates Learjet 25D · S/N 353Cancelled Jun 19, 2018 · Sale reported, pending cancellation N37950Piper J3C-65 · S/N 6730Cancelled Mar 16, 2018 · Revoked, canceled · Built 1941 · Central Dust & Spray Svc N32SSSchleicher ASW-20L · S/N 20473Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Schmid Susan L N9240GBell OH-58A · S/N 70-15118Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Mclennan County Sheriffs Department N60730Cessna 150J · S/N 15070531Cancelled Feb 15, 2018 · Registration expired, pending cancellation · Built 1969 · State Of Texas N3825PPiper PA-22-150 · S/N 22-3515Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1955 · Franklin Eugene R N8878BCessna 172 · S/N 36578Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 1958 · Spicer Gary Don N6891WPiper PA-28-140 · S/N 28-21048Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1965 · Wright Charles M N2401CPiper PA-38-112 · S/N 38-79A0172Cancelled Jan 16, 2018 · Registration expired, pending cancellation · Built 1978 · Hart Darin R N84042Aeronca 7AC · S/N 7AC-2729Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Waco Aviation Inc N8747ABeech A35 · S/N D-2169Cancelled Nov 21, 2017 · Revoked, canceled · Built 1949 · Miller Avn Inc N53ABSchempp-Hirth K G VENTUS A · S/N 43Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Built 1981 · Schmid Fred N39814Bellanca 17-30A · S/N 73-30505Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 1972 · Obst Josephine S N880DLRay Donald W KR2XL · S/N 1240Cancelled Jun 1, 2017 · Registration expired, pending cancellation · Ray Donald W N714RKDassault FALCON 2000EX · S/N 714Cancelled Oct 27, 2016 · Exported to South Korea · Built 2013 · L-3 Communications Integrated Systems N30678Air Tractor AT-802 · S/N 802-4026Cancelled Sep 6, 2016 · Exported to Jordan · Built 2014 · L-3 Communications Integrated Systems N5422ASwinger Joseph L MX SUPER · S/N 1006Cancelled May 21, 2015 · Sale reported, canceled N1939BLuscombe 8A · S/N 6366Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1948 · Franklin Robert L N63462Cessna 150M · S/N 15077333Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1975 · Smith Jerome E N88763Cessna R172E · S/N R172-0216Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1973 · State Of Texas N7450PPiper PA-24 · S/N 24-2639Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1961 · Texas State Technical College N45RTBoeing 707-320B · S/N 18961Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1965 · Buffalo Holding Inc N726RKDassault FALCON 2000EX · S/N 726Cancelled Dec 22, 2014 · Exported to South Korea · L-3 Communications Integrated Systems N25988Cessna 152 · S/N 15280898Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1977 · Mcglasson Investment Comp Inc N6328VCessna 172RG · S/N 172RG0627Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 1980 · State Of Texas N628FRPiper PA-23-250 · S/N 27-3428Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1966 · Carib Ventures Ltd N9186RBeech C18S · S/N 6053Cancelled Oct 14, 2014 · Revoked, pending cancellation · Built 1944 · Miller Walter D Jr N25965Cessna 152 · S/N 15280883Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1977 · Mcglasson Investment Comp Inc N908KACessna 208 · S/N 20800359Cancelled Feb 18, 2014 · Exported to Australia · Built 2002 · Blackhawk Modifications Inc N2823FConvair T-29B · S/N 51-7901Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1951 · Texas State Technical College N43541Taylorcraft BC12-D · S/N 7200Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Built 1946 · Price Frank David

Back to Waco, TX