OpenAirDocs.org
Pine Bluff, AR

Cancelled registrations · 80

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

N7775WPiper PA-28-180 · S/N 28-1778Cancelled May 27, 2023 · Expired dealer · Lancam IncN59766Boeing A75N1(PT17) · S/N 751160Cancelled Feb 21, 2020 · Revoked, canceled · Built 1941 · White Rock IncN5971XBrantly B-2 · S/N 113Cancelled Feb 10, 2020 · Revoked, canceled · Built 1961 · England W DN32751Piper J3F-65 · S/N 5586Cancelled Dec 13, 2019 · Revoked, canceled · Built 1940 · Myhand & Deam IncN4282YMaule M-7-260C · S/N 30016CCancelled Jun 28, 2019 · Exported to Canada · Built 2000 · Hallman MichaelN4241XRockwell International S-2R · S/N 2016RCancelled Mar 5, 2018 · Registration expired, pending cancellation · Built 1974 · Bishop Brian D DBAN71057Piper J3C-65 · S/N 18079Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Myhand & Deam IncN3790KKindrick Louie L B-8M · S/N K8791LCancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1978 · Kindrick Louie LN3538KPiper J3C-65 · S/N 22229Cancelled Aug 17, 2016 · Third renewal notice · Built 1946 · Ag-Air IncN42563Piper J3C-65 · S/N 14844Cancelled Aug 17, 2016 · Third renewal notice · Built 1945 · Ag Air IncN6265PPiper PA-24-250 · S/N 24-1373Cancelled May 15, 2015 · Registration expired, pending cancellation · Purnell Carl DN8697SCessna 150F · S/N 15061997Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1965 · Priest Jay AN8514ABeech A35 · S/N D-1936Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1949 · Dobson Billy MN8852SORR Stephen W CHINOOK PLUS TWO · S/N 02140Cancelled Aug 27, 2013 · Sale reported, canceled · Built 2008N1425VCessna 172M · S/N 17263570Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1974 · Martin Jerry RN5334JGalaxy Balloons GALAXY 7 · S/N GLX-1647Cancelled May 10, 2013 · Sale reported, canceled · Built 1990N39883Bellanca 17-31ATC · S/N 73-31056Cancelled Nov 14, 2012 · Registration expired, pending cancellation · Built 1973 · Teague James EN522SPBeech 95-B55 · S/N TF-65Cancelled Oct 23, 2012 · Registration expired · Built 1966 · Arkansas Department Of CorrectionN32944Piper J3C-65 · S/N 5728Cancelled Oct 2, 2012 · Registration expired, pending cancellation · Built 1940 · Ag-Air IncN6771BPiper PA-18A 150 · S/N 18-5004Cancelled Sep 5, 2012 · Revoked, canceled · Built 1956 · Myhand And Deam IncN2157VCessna 182T · S/N 18281282Cancelled Aug 19, 2011 · Second renewal notice · Wings South IncN8738EPiper PA-28-151 · S/N 28-7615156Cancelled Aug 3, 2011 · Expired dealer · Built 1976 · Martin Aircraft Sales IncN31080Piper J3F-65 · S/N 5316Cancelled Jul 27, 2009 · Registration revoked · Built 1940 · Demasters William SN721MLGulfstream AM Corp Comm Div 690D · S/N 15002Cancelled Oct 24, 2005 · Exported to Canada · Built 1982 · Slfh Air LLCN25613Beech F33A · S/N CE-416Cancelled Sep 22, 2005 · Second triennial mailing, no response · Built 1973 · Harold Hall Roofing IncN104AYWsk-Pzl Warzawa-Okecie PZL-104 WILGA 80 · S/N CF21940943Cancelled Jun 14, 2005 · Exported to Mexico · Built 1994 · Galster MikeN2579LBalloon Works FIREFLY 7-15 · S/N F7-796Cancelled Oct 29, 2001 · Triennial form not returned · Ron Lusby Emergency ServicesN58792Cessna 182P · S/N 18262297Cancelled Nov 5, 1996 · Triennial form not returned · Tomlinson Avionics IncN65027Boeing B75N1 · S/N 752614Cancelled Jul 5, 1996 · Exported to Australia · Myhand Aircraft IncN492DMBeech C-45H · S/N 5210874Cancelled Jul 6, 1995 · Triennial form not returned · De Mint T EN1999Piper PA-18 · S/N 18-2648Cancelled Sep 9, 1994 · Built 1953 · Myhand And Deam IncN95177Piper PA-28-140 · S/N 2825834Cancelled Mar 24, 1992 · Triennial form not returned · Mckinstry RichardN91523Barrow BD-5 · S/N 2099BCancelled Apr 8, 1991 · Barrow Ted AN7242BBeech J35 · S/N D5582Cancelled Dec 29, 1990 · Self Ralph LN7273ZPiper PA-25-235 · S/N 25-3208Cancelled Apr 5, 1985 · Exported to Mexico · Myhand Aircraft IncN73013Cessna 207A · S/N 20700554Cancelled Dec 21, 1984 · Demint Thomas EN9779LBeech B19 · S/N MB-536Cancelled Jun 29, 1983 · Administratively canceled · Mc Cauley AviationN8098JPiper AEROSTAR 601 · S/N 61-0590-7962135Cancelled Jul 15, 1982 · Mccauley Aviation IncN58JMBeech H-18 · S/N BA-695Cancelled Dec 18, 1981 · Astro Airways CorpN9279MMooney M20E · S/N 1216Cancelled Jun 17, 1981 · Exported to Canada · Mccauley AviationN86169Cessna 337D · S/N 337-1101Cancelled Dec 24, 1980 · Exported to Canada · Grover Scruggs Sales & Service IncN52597Boeing A75N1 · S/N 752047Cancelled Oct 28, 1977 · Warriner Richard WN40134Stinson 108 · S/N 108-64Cancelled Jun 11, 1976 · Built 1946 · Mcdougale Pat HN41268Piper PA-28-151 · S/N 28-7415152Cancelled Jan 28, 1976 · Exported to Canada · Parkey Edward AN1536VDehavilland DH-104 · S/N 04355Cancelled Nov 8, 1975 · Built 1952 · Astro Airways CorpN6848ZPiper PA-25-235 · S/N 25-2521Cancelled Jul 18, 1975 · Ag Air IncN7297Shepherd B-8M · S/N 1Cancelled Apr 30, 1975 · Shepherd Jimmy DN9001SBeech D95A · S/N TD-638Cancelled Jan 27, 1975 · Exported to Canada · Grover Scruggs Sales And Service IncN6223VBeech E95 · S/N TD-708Cancelled May 15, 1973 · Exported to Canada · Grover Scruggs Sales & Service IncN33381Commonwealth 185 · S/N 1602Cancelled May 3, 1972 · Carter William L
Back to Pine Bluff, AR