Skip to content

Cancelled registrations · 77

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 = 'AR' AND d.registrant_city = 'STUTTGART' 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 = 'AR' AND d.registrant_city = 'STUTTGART'
  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 = 'AR' AND d.registrant_city = 'STUTTGART'
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.

N35FUEa Vision EA J100 · S/N 85579Cancelled May 2, 2026 · Sale reported, canceled N630NPBoeing 757-2B7 · S/N 27811Cancelled Nov 12, 2024 · Sale reported, pending cancellation · Built 1995 N26JMMckinley EAA BIPLANE P2 · S/N JM-1Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1976 · Morris Adam R N45260Naval Aircraft Factory N3N-3 · S/N 1785Cancelled Jun 26, 2020 · Revoked, canceled · Built 1940 · Hiryak Joe C N104UABoeing 747-422 · S/N 26902Cancelled Sep 23, 2019 · Sale reported · Built 1998 N545UABoeing 757-222 · S/N 25323Cancelled Nov 17, 2018 · Sale reported, canceled · Built 1991 N520UABoeing 757-222 · S/N 24890Cancelled Aug 28, 2018 · Sale reported, pending cancellation · Built 1990 N1790DCessna 170B · S/N 20233Cancelled Apr 2, 2018 · Revoked, canceled · Built 1951 · Crosby Ray C N701CTRobinson Helicopter R44 · S/N 1161Cancelled Mar 28, 2018 · Registration expired, pending cancellation · Built 2002 · Heien Britt N8694CPiper PA-22-135 · S/N 22-1337Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1953 · Stoner Frank O N3608KPiper J3C-65 · S/N 22297Cancelled Oct 28, 2017 · Revoked, pending cancellation · Built 1946 · Arkansas Aerial Dusters N7502ZSchweizer G-164B · S/N 822BCancelled Sep 19, 2017 · Exported to Philippines · Built 1990 · Jareds Flying Service Inc N60023Air Tractor AT-502B · S/N 502B-0315Cancelled May 4, 2017 · Exported to Australia · Bear Bayou Ag Service N42367Piper J3C-65 · S/N 14620Cancelled Feb 4, 2017 · Revoked, pending cancellation · Built 1945 · Holbert Charles E N135RAWSK PZL Mielec M-18A · S/N 1Z01333Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1984 · Bear Bayou Ag Service Inc N668FAGrumman Acft ENG Cor-Schweizer G-164B · S/N 499BCancelled May 4, 2015 · Registration expired, pending cancellation · Jareds Flying Service Inc N8323TCessna 175C · S/N 17557023Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1961 · Chapmon Russell P N3546VMiehl David J TEAM HI MAX 1700R · S/N 001Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1997 · Morris Adam R N2155XCessna 337 · S/N 337-0055Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Built 1965 · Heien George A N502SWBoeing 737-5H4 · S/N 24179Cancelled Jan 29, 2014 · Sale reported · Built 1990 N6962ECessna 175A · S/N 56462Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1959 · Chapmon Russell P N5407Grumman G-164A · S/N 1020Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1972 · Eddins Flying Service Inc N9678Grumman Acft ENG Cor-Schweizer G-164A · S/N 1198Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1974 N8044SHughes TH-55 · S/N 67-18383Cancelled Feb 27, 2013 · Sale reported, canceled N46771Aeronca 0-58B · S/N 058B-1922Cancelled Sep 18, 2012 · Revoked, canceled · Built 1942 · Moore Charles N4546Grumman Acft ENG Cor-Schweizer G-164A · S/N 1054Cancelled Sep 12, 2012 · Registration pending, canceled N42418Piper J3C-65 · S/N 14679Cancelled Jun 14, 2012 · Revoked, canceled · Built 1945 · Fischer Carl N35338Piper J3C-65 · S/N 6305Cancelled May 24, 2012 · Revoked, canceled · Built 1941 · Holbert Charles E N1388HAeronca 15AC · S/N 15AC-439Cancelled Jul 6, 2009 · Registration revoked · Built 1949 · Farmers Aerial Seeders Corp N4471TPiper PA-23-250 · S/N 27-3670Cancelled Nov 13, 2007 · Triennial form not returned · City Of Stuttgart N46658Cessna 172K · S/N 17257416Cancelled May 11, 2005 · Triennial form not returned · Built 1968 · Dierks Donald N7486Grumman Acft ENG Cor-Schweizer G-164A · S/N 963Cancelled May 3, 2005 · Triennial form not returned · Built 1972 · Vanhouten Flying Service Inc N7150VMooney M20C · S/N 20-0037Cancelled Feb 3, 2005 · Triennial form not returned · Built 1974 · Allen Eddie Bruce N15VZAero Commander 690 · S/N 11035Cancelled Jun 4, 2001 · Exported to Canada · Romero Leasing Inc N7314CAir Tractor AT-501 · S/N 5010002Cancelled Mar 19, 1997 · Triennial form not returned · Hartley Flying Service Inc N85635Aeronca 7AC · S/N 7AC4379Cancelled Mar 30, 1995 · Triennial form not returned · Goetz Scott N8436SCessna 182H · S/N 18256536Cancelled Feb 5, 1993 · Triennial form not returned · Wheatley Farm Inc N7497Grumman Acft ENG Cor-Schweizer G-164A · S/N 976Cancelled Nov 17, 1983 · Van Houten Paul E N5239Grumman G-164A · S/N 1135Cancelled Jul 7, 1977 · Vanhouten Paul E N82372Aeronca 7AC · S/N 7AC-1005Cancelled Aug 19, 1974 · Built 1946 · Gunnell William W N6878WPiper PA-28-140 · S/N 28-21034Cancelled Apr 24, 1974 · Gregorski Thomas E N55560Boeing A75N1 · S/N 75-428Cancelled Oct 18, 1971 · Pate Willard E N75879Piper J3C-65 · S/N 6104Cancelled Aug 27, 1971 · Holbert Charles E N77561Piper J3C-65 · S/N 22052Cancelled Aug 26, 1971 · Holbert Charles E N8663CPiper PA-18A-135 · S/N 18-2797Cancelled Feb 18, 1971 · J O Dockery N45322Naval Aircraft Factory N3N-3 · S/N 4491Cancelled Jan 21, 1971 · W O Miller N6303HPiper J3C-65 · S/N 19484Cancelled Jan 4, 1971 · Hargrove W N N6317DSnow S2B · S/N 1003Cancelled Sep 24, 1970 · Fischer Carl N2727WMooney M20F · S/N 670025Cancelled Sep 4, 1970 · Dockery J O N3452NPiper J3C-65 · S/N 22667Cancelled Sep 4, 1970 · Dockery J O

Back to Stuttgart, AR