Skip to content

Cancelled registrations · 46

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 = 'FORT SMITH' 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 = 'FORT SMITH'
  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 = 'FORT SMITH'
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.

N1011MNavion NAVION G · S/N NAV-4-2470Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1962 · Clear Blue Sky LLC N3815ZBeech 77 · S/N WA-219Cancelled Jul 12, 2022 · Sale reported, canceled · Built 1981 N3598RBeech A23 · S/N M-779Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Built 1965 · Bap Group LLC N301PCIsrael Aircraft Industries 1124A · S/N 377Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 1981 · Dude Inc N7954LHorizon Hobby CHROMA CAMERA DRONE · S/N 0548258584Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Larsen Kaia L N53749Fairchild M-62A · S/N 9754AECancelled Apr 5, 2018 · Revoked, canceled · Built 1943 · Bullock Walter L N65816Six Chuter Inc SR.2 SR.2 POWER PARACHUTE · S/N 96-15352Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 1996 · Yandell Jim Roy N43ASRomero G A/Romero SG PULSAR XP · S/N 194Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 1995 · Faught W L N125SGAmerican Champion 8KCAB · S/N 966-2004Cancelled Jan 30, 2018 · Exported to Brazil · Built 2004 · Bens Travel Gear LLC N5861VPiper J3C-65 · S/N 11977Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Built 1944 · Medley Jim N10503Maule MX-7-180B · S/N 22016CCancelled Apr 5, 2017 · Second renewal notice · Built 1998 · Parthenon LLC N2234CCessna T303 · S/N T30300073Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1982 · Wilson Steven K N9877WPiper PA-28-140 · S/N 28-23397Cancelled Aug 13, 2013 · Sale reported, canceled · Built 1967 N69TPLafevers Michael F QUICKSILVER GT · S/N 1247Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1987 N5407JCessna 421B · S/N 421B0955Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1975 · Bradley Machine Co Inc N51439Maule M-4-210C · S/N 1102CCancelled Mar 25, 2013 · Registration expired, pending cancellation · Built 1973 · Medley Jim N669RACessna 172N · S/N 17269401Cancelled Mar 15, 2013 · Exported to Belarus · Built 1977 · Fort Smith Flying Club Inc N1700ZRaytheon 58 · S/N TH-1796Cancelled Dec 14, 2012 · Exported to Paraguay · Built 1996 · C & J Forms & Label Co N4EWRaytheon 58 · S/N TH-1912Cancelled Oct 20, 2010 · Exported to Brazil · Built 1999 · Defy Gravity LLC N300GLSwearingen SA226TC · S/N TC308Cancelled Apr 30, 2008 · Exported to Canada · Built 1979 · Interair Lease LLC N6005VBeech C23 · S/N M-2124Cancelled Feb 8, 2006 · Exported to Canada · Built 1978 · Ross Executive Aviation Inc N32050Schlitter Randy J RANS S6ES COYOTE II · S/N 0991221Cancelled Oct 26, 2005 · Triennial form not returned · Built 1991 · Henley Rommy M N2237FPiper PA-28-236 · S/N 28-7911058Cancelled May 18, 2004 · Exported to Canada · Built 1978 · Caro Inc N6754CBeech C23 · S/N M-2273Cancelled Oct 4, 2001 · Exported to Canada · Built 1980 · Ross Executive Aviation Inc N8027NPiper PA-28-140 · S/N 28-25271Cancelled Mar 3, 2000 · Triennial form not returned · Bell James P N550BKRoberds Kenneth A RANS S-12 · S/N 0295559Cancelled Apr 3, 1998 · Roberds Kenneth A N7157BSchlitter Randy J RANS S-6 COYOTE II · S/N 0460117Cancelled Jul 23, 1996 · Henley Rommy Mack N8834VBellanca 17-31A · S/N 3241Cancelled Jun 8, 1994 · Triennial form not returned · Poe Mcdonald Jr Md N7488SSmith AEROSTAR 600 · S/N 600045100Cancelled Jul 19, 1991 · Edwards Lawrence R N338JPiper PA-31 · S/N 31P-51Cancelled Jul 22, 1982 · Built 1971 · Leisure Lodge Inc N6055RCessna 172G · S/N 17253724Cancelled Dec 8, 1975 · Exported to Canada · Faulkner Leo C N115RGDouglas A-26 · S/N 44-34134Cancelled Sep 14, 1971 · Registration revoked · Sexton Sam Jr N9046ACessna 170B · S/N 18805Cancelled Feb 23, 1971 · Pharis Raymond C N9703JPiper PA-28-180 · S/N 28-3893Cancelled Jun 11, 1968 · Exported to Canada · Built 1967 · Superior Home Improvement Co N3539KPiper J3C-65 · S/N 22230Cancelled Apr 27, 1956 · Exported to Mexico · Du Val Jr Dibrell L N75923Consolidated Vultee SNV-1 · S/N 7495Cancelled Oct 24, 1955 · Epps J W N24970Piper J3L-65 · S/N 3572Cancelled Apr 13, 1951 · Built 1939 · Scheihing Roy N88761Cessna T-50 · S/N 2617Cancelled Jun 30, 1949 · Garnero Joseph N50510Waco SRE · S/N 5096Cancelled Nov 12, 1948 · Built 1940 · Ward Furniture Mfg Co N908ECommand-Aire 3C-3 · S/N 617Cancelled Aug 17, 1939 · Wilson Penn N3555Travel Air 4000 · S/N 274Cancelled Aug 19, 1938 · Built 1928 · Southern Crop Dusting Co N9040Travel Air 4000 · S/N 880Cancelled May 11, 1938 · Southern Crop Dusting Co N3620Travel Air 4000 · S/N 284Cancelled Jul 29, 1937 · Built 1929 · Southern Crop Dusting Company N1379Waco GXE · S/N 890Cancelled Feb 15, 1935 · Dewey D Holley N74Curtiss JN4D · S/N 7623Cancelled Feb 11, 1933 · Scheihing Roy N1694American Eagle 101 · S/N 51Cancelled Apr 15, 1931 · Built 1927 · Moore Everett L

Back to Fort Smith, AR