Skip to content

Cancelled registrations · 63

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 = 'MS' AND d.registrant_city = 'MERIDIAN' 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 = 'MS' AND d.registrant_city = 'MERIDIAN'
  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 = 'MS' AND d.registrant_city = 'MERIDIAN'
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.

N490TWBalony Kubicek Spol S R O BB34ED · S/N 1284Cancelled Sep 9, 2024 · Built 2016 · Poole Frederick J N98PTBeech M35 · S/N D-6337Cancelled May 13, 2023 · Sale reported, canceled N969TRNorth American NAVION A · S/N NAV-4-342Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1946 · Boyd Williams Real Estate Company N4093ULindstrand Balloons 90A · S/N 5057Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Poole Frederick J N6828TCessna 310D · S/N 39128Cancelled May 5, 2020 · Revoked, pending cancellation · Built 1960 · Huddleston Contractor N82807Mcgrath Thomas P CHALLENGER · S/N CH2-0498-R-1738Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 1998 · Price Gregg O N791ZHDJI PHANTOM 4 · S/N 07DDD6U0B10331Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Hook Scott M N77BPHinton Paul M RV-4 · S/N 3281Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1995 · Swiggart James H N7919SBell 47G-4A · S/N 7568Cancelled Mar 29, 2018 · Registration expired, pending cancellation · Built 1967 · Smith Roger L N69DEBeech A60 · S/N P-241Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1973 · Queen City Flying Group LLC N69029Cessna 152 · S/N 15282446Cancelled Sep 6, 2017 · First renewal notice · Built 1978 · Meridian Airport Authority N622RJPiper PA-23-150 · S/N 23-700Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1956 · Edwards Aviation LLC N1644XCessna 210L · S/N 21060680Cancelled Feb 17, 2017 · Registration expired, pending cancellation · Built 1975 · Hill R Bruce N3433HDouglas DC3C · S/N 43090Cancelled Dec 22, 2014 · Revoked, canceled · Built 1943 · Meridian Air Cargo Inc N6492JPiper PA-28-180 · S/N 28-4923Cancelled Jan 28, 2014 · First renewal notice · Built 1968 · Fairhaven LLC N9527XCameron Balloons US V-90 · S/N 5654Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Built 1990 · Pet Surgery Incorporated N3662YBalloon Works FIREFLY 7 · S/N F7-055Cancelled Sep 27, 2013 · Registration expired, pending cancellation · Built 1983 · Kimbrell James R N2961ZPiper PA-22-150 · S/N 22-6935Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Built 1959 · Stovall Marlin T N36683Balloon Works FIREFLY 7 · S/N F7-083Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1983 · Landrum Don DBA N77247Cessna 120 · S/N 11709Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1946 · Lowry E M N19872Cameron Balloons US V-77 · S/N 5250Cancelled May 31, 2013 · Sale reported, canceled · Built 1987 N679NCCameron Balloons US N-105 · S/N 5257Cancelled May 31, 2013 · Sale reported, canceled N7165PLee Donald R A · S/N DRL-0542Cancelled May 16, 2013 · Registration expired, pending cancellation · Built 1990 · Lee Donald R N20GTTwente George E II PITTS MODEL 12 · S/N 86Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 2001 · Twente George E II N900RERotec Engineering PANTHER 2 PLUS · S/N 1028Cancelled Apr 9, 2013 · Sale reported, canceled · Built 1985 N31MTStovall Marlin T KR-2 · S/N 7197-431MTCancelled Nov 21, 2012 · Registration expired, pending cancellation · Stovall Marlin T N930JMPiper PA-31-310 · S/N 31-321Cancelled Nov 19, 2012 · Sale reported, pending cancellation · Built 1968 N56990Douglas DC3C · S/N 20404Cancelled Nov 15, 2012 · Revoked, canceled · Built 1943 · Meridian Air Cargo Inc N40421Balloon Works FIREFLY 7 · S/N 7859Cancelled Jul 19, 2012 · Sale reported, pending cancellation · Built 1979 N46445Maples Phillip M MAPLES 2000 GTXSE · S/N H2-05-16-635Cancelled Feb 2, 2012 · Built 2005 · Maples Phillip M N27612Taylorcraft BC-65 · S/N 2254Cancelled Dec 9, 2010 · Revoked, pending cancellation · Built 1940 · Hensley Robert E N697MAPiper PA-32R-301 · S/N 3246069Cancelled May 21, 2004 · Triennial form not returned · Built 1997 · Williams Mark D N200DLBeech 58 · S/N TK34Cancelled Apr 14, 1997 · Triennial form not returned · Callahan Joel T N1544TBalloon Works FIREFLY 7-B · S/N 10272Cancelled Mar 15, 1994 · Triennial form not returned · Hasson James J N60077Cessna 150J · S/N 15070058Cancelled Oct 18, 1993 · Triennial form not returned · Scheider Kurt B N2981VCameron Balloons US O-84 · S/N 5174Cancelled Sep 4, 1991 · Triennial form not returned · Shannon George W III N70543Cessna 182L · S/N 18259295Cancelled Jan 2, 1986 · Poitevent Fred O Jr N40560Balloon Works FIREFLY 7 · S/N 11101Cancelled Dec 29, 1983 · Kimbrell James R N756SMCessna U206G · S/N U20604320Cancelled Aug 17, 1982 · Carney A P Jr N6647GCessna 150L · S/N 15072147Cancelled Jul 2, 1977 · Key Brothers Flying Service Inc N60785Cessna 150J · S/N 15070578Cancelled Feb 21, 1973 · Exported to Canada · Key Bros Flying Service Inc N1976YMooney M20D · S/N 241Cancelled Feb 1, 1971 · Wheeless Nathan N1048NCurtiss P40E · S/N 1047Cancelled May 18, 1965 · Boy Scouts Choctaw Area Council N93858Ercoupe 415-C · S/N 1181Cancelled Jan 7, 1957 · Mullican W M N76307Cessna 140 · S/N 10721Cancelled Dec 14, 1951 · Key Brothers Flying Service Inc N52547Consolidated Vultee BT-13B (SNV-2) · S/N 9-1547Cancelled Apr 17, 1951 · G Halbert Soule DBA Bob & Harvey Aircraft Service N27156Piper J3C-65S · S/N 4400Cancelled Apr 13, 1951 · Built 1940 · Soule G H N73091Cessna 140 · S/N 10307Cancelled Aug 4, 1950 · Key Brothers Flying Service Inc N3413KPiper J3C-65 · S/N 22104Cancelled Mar 29, 1950 · Key Brothers Flying Service Inc N52577Fairchild PT-23-SL · S/N 18-SLCancelled Dec 2, 1948 · Key Brothers Flying Service Inc

Back to Meridian, MS