OpenAirDocs.org
Hattiesburg, MS

Cancelled registrations · 52

Query with SQL
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 = 'HATTIESBURG'
  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.

N4354UHerrington Billy R BREEZE · S/N 001Cancelled Dec 20, 2025 · Sale reported, canceled · Built 2008N85801Aeronca 11AC · S/N 11AC-204Cancelled Aug 4, 2025 · Sale reported, canceled · Built 1946N132WBDiamond Aircraft Ind DA 40 NG · S/N 40.N393Cancelled Feb 24, 2025 · Exported to United Kingdom · Built 2019N147DDCessna 182T · S/N 18282367Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 2013 · Chancellor John M JrN1940QCessna 177RG · S/N 177RG0340Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Built 1973 · York GaleN1659DPiper PA-31-350 · S/N 317952017Cancelled Nov 1, 2019 · Exported to Mexico · Built 1979 · Lcq Aviation IncN669YB3D Robotics SOLO · S/N S111A5601499Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Baker Richard WN4043SZorn Tony ROTEC PANTHER · S/N 1563Cancelled Mar 23, 2018 · Registration expired, pending cancellation · Built 1992 · Jennings Howard E SrN31CSSmith STEEN SKYBOLT · S/N 1Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1979 · Packard Glenn SN22CHPiper AEROSTAR 601P · S/N 61P06127963275Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1979 · Bravo Aviation LLCN1655YCessna 172C · S/N 17249355Cancelled Oct 28, 2017 · Revoked, canceled · Built 1962 · Bowen Kenneth LeeN444TTSmith AEROSTAR 601P · S/N 61P-0444-168Cancelled May 15, 2017 · Registration expired, pending cancellation · Bravo Aviation LLCN6474RPiper PA-28-140 · S/N 28-21663Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1966 · Burks Aviation IncN600MTTaber Mark K SUPER ES · S/N ES-051Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 2002 · Taber Mark KN760CVSmith AEROSTAR 601 · S/N 61-0270-104Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 1975 · Bravo Aviation LLCN3508APiper PA-22-135 · S/N 22-1780Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1953 · Lee Richard EN3104APiper PA-23-250 · S/N 27-2798Cancelled Sep 25, 2014 · Sale reported, pending cancellation · Built 1965N65757Aerostar International RX-7 · S/N RX7-3157Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1988 · Watford Nancy PN8110ACessna 170B · S/N 20962Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1952 · Fowler Butane Gas Co IncN1527KBalloon Works FIREFLY 7 · S/N 10989Cancelled Jan 31, 2013 · Registration expired, pending cancellation · Built 1981 · Cloudbuster IncN12JFFeuerstein John B PIETENPL ARCMPR F-22 · S/N J/F-1Cancelled Aug 21, 2012 · Registration pending, canceled · Built 1994N61394Cessna A185F · S/N 18504171Cancelled Apr 28, 2011 · Expired dealer · Built 1980 · Fagan Russell DN37906Douglas DC3C · S/N 13647Cancelled Jan 21, 2011 · Revoked, pending cancellation · Southern Flyer IncN3112MPiper PA-12 · S/N 12-1800Cancelled Jul 27, 2009 · Registration revoked · Built 1947 · St Germain David BN5882WPiper PA-28-150 · S/N 28-2603Cancelled Jan 12, 2009 · Built 1965 · Smutzer Charles DBAN8726SCessna 150F · S/N 15062026Cancelled Dec 12, 2008 · Exported to Thailand · Built 1965 · Aztec IncN3832WPiper PA-32-260 · S/N 32-766Cancelled Mar 17, 2005 · Triennial form not returned · Built 1966 · Cayman Flying Club LtdN9601Davenport EAA BIPLANE · S/N 1Cancelled Apr 29, 1998 · Triennial form not returned · Holgate Jack FN61185Cessna 150J · S/N 15070870Cancelled Mar 12, 1998 · Exported to Jamaica · Southeast Aviation Services IncN157TPAermacchi IMPALA MB-326M · S/N 469Cancelled Oct 16, 1995 · Flight Research IncN153TPAermacchi IMPALA MB-326M · S/N 493Cancelled Feb 1, 1994 · Built 1993 · Flight Research IncN9216BCessna 175 · S/N 55016Cancelled Aug 2, 1977 · Edmonson R. Lee ChipN111BMCessna 421B · S/N 421B0443Cancelled Dec 8, 1976 · Exported to Bolivia · Built 1973 · First Mississippi National BankN777SBeech D18S · S/N A-834Cancelled Jun 10, 1975 · Hattiesburg Aviation IncN1777QCessna 150L · S/N 15073077Cancelled Jun 10, 1974 · Hattiesburg Aviation IncN30947Piper J5A · S/N 5-290Cancelled Sep 22, 1971 · Built 1940 · Kepper Karl WN4983MPiper PA-11 · S/N 11-471Cancelled Sep 3, 1970 · English Flying ServiceN8298ACessna 170B · S/N 25150Cancelled May 20, 1965 · English Noel LN1483NPiper J3C-65 · S/N 23010Cancelled May 18, 1965 · James W BarronN1520DCessna 195A · S/N 7742Cancelled Dec 14, 1956 · G Ross General InsuranceN5332KRyan NAVION B · S/N NAV-4-2232BCancelled Dec 14, 1956 · Jerry G Alexander CoN94177Ercoupe 415-C · S/N 1500Cancelled Oct 14, 1955 · Currie Overton AN46736Piper J3C-65 · S/N 10201Cancelled Oct 10, 1955 · English Flying ServiceN1629NFunk B85C · S/N 409Cancelled Oct 5, 1955 · Culpepper W LouieN2864MPiper PA-12 · S/N 12-1286Cancelled Apr 28, 1954 · Built 1946 · Parker Albert F / Nelson Clayton VN1288HAeronca 15AC · S/N 15AC-305Cancelled Apr 5, 1954 · W R Fairchild Const Co LtdN9565KStinson 108-2 · S/N 108-2565Cancelled Jan 15, 1954 · K D Curry & B W Curry JrN48254Consolidated Vultee BT-15 · S/N 7224Cancelled Nov 26, 1951 · Hamilton M WN1324BLuscombe 8A · S/N 5951Cancelled Nov 8, 1951 · L L GreerN97587Stinson 108 · S/N 108-587Cancelled May 18, 1949 · Taylor-Wheless Company
Back to Hattiesburg, MS