OpenAirDocs.org
Augusta, GA

Cancelled registrations · 146

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 = 'GA' AND d.registrant_city = 'AUGUSTA'
  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.

N892MAMitsubishi MU-2B-36A · S/N 721SACancelled Jun 14, 1994 · Triennial form not returned · Bush Field Aircraft CoN339MAMitsubishi MU-2B-35 · S/N 607Cancelled Mar 3, 1994 · Bush Field Aircraft CompanyN437MAMitsubishi MU-2B-60 · S/N 1521SACancelled May 14, 1993 · Exported to Canada · Bush Field Aircraft CompanyN6846DCessna 425 · S/N 4250078Cancelled Sep 28, 1992 · Triennial form not returned · Morris Communication CorpN2862ECessna 172N · S/N 17271351Cancelled Jun 12, 1992 · Triennial form not returned · Augusta Aviation IncN7119DBeech 60 · S/N P113Cancelled Jun 12, 1992 · Triennial form not returned · Bush Field Aircraft CoN6215YCessna 210N · S/N 21064298Cancelled Jan 10, 1992 · Exported to Brazil · Augusta Aviation IncN273MAMitsubishi MU-2B-60 · S/N 785SACancelled Aug 6, 1991 · Exported to Canada · Bush Field Aircraft CompanyN101JRPiper PA-23-250 · S/N 277854115Cancelled Mar 29, 1991 · Triennial form not returned · Augusta Aviation IncN24MWMitsubishi MU-2B-40 · S/N 434SACancelled Dec 7, 1990 · Exported to Canada · Bush Field Aircraft CompanyN69038Cessna 152 · S/N 15282453Cancelled Dec 19, 1985 · Sapp Tom DN26711Cessna 340A · S/N 340A0748Cancelled Apr 13, 1981 · Built 1979 · Colonial Leasing CoN6058VLake LA-4-200 · S/N 787Cancelled Dec 3, 1979 · Exported to Canada · Enginuity IncN9427QBeech B-55 · S/N TC-1425Cancelled Jun 25, 1973 · Mullins D F JrN3345ZPiper PA-22-160 · S/N 22-7285Cancelled Nov 24, 1972 · Boardman Jr Clayton P Frank S Dennis Jr Robert DenN9051RAero Commander 520 · S/N 52022Cancelled Aug 14, 1972 · Aviation Management IncN600CStinson 108-3 · S/N 108-3600Cancelled Mar 8, 1972 · Murphy William RN26803Piper J3L · S/N 4184Cancelled Jan 17, 1972 · Fort Gordon Flying ClubN4762SSteinheiser Dee C PRECEPTOR ULTRA-PUP · S/N 1Cancelled Sep 23, 1970 · Howell C Jones JrN5140YPiper PA-23-250 · S/N 27-2171Cancelled Jun 30, 1970 · Augusta Aviation IncN2779APiper PA-18-125 · S/N 18-928Cancelled Jun 29, 1970 · US ArmyN6643PPiper PA-24-250 · S/N 24-1765Cancelled Oct 5, 1965 · Augusta Aviation IncN2804PPiper PA-22-150 · S/N 22-3096Cancelled May 22, 1965 · Augusta School Of Aviation IncN358GAPiper PA-22 · S/N 22-1859Cancelled May 20, 1965 · Prestwood Electronics CoN7527KPiper PA-18 · S/N 18-243Cancelled Sep 20, 1956 · Augusta School Of Aviation IncN41111Piper J3L-65 · S/N 7757Cancelled Mar 5, 1956 · Built 1941 · Evans James A JrN61313Consolidated Vultee BT-13B (SNV-2) · S/N 79-1336Cancelled Feb 15, 1956 · J L Murphy JrN46077Taylorcraft DCO-65 · S/N L-4956Cancelled Oct 21, 1955 · Laughlin H RN91845Schweizer SGU 2-22 · S/N 18Cancelled Oct 13, 1955 · Gromelins Air Activities IncN66232Consolidated Vultee BT-13B (SNV-2) · S/N 79-1300Cancelled Dec 16, 1953 · Lewis Randolph PN81129Funk B85C · S/N 259Cancelled Oct 21, 1953 · Sferra Pasqual JN16569Aeronca C-3 · S/N A-705Cancelled Sep 8, 1949 · Kitts Joe CN3975EAeronca 11BC · S/N 11BC-60Cancelled Apr 29, 1949 · Exported to Cuba · Built 1947 · Borneman John K ColN84685Aeronca 7AC · S/N 7AC-3398Cancelled Mar 23, 1949 · Augusta School Of AviationN46828Piper J3L-65 · S/N G-221Cancelled Oct 4, 1948 · Boshears Willis MN69488Cessna T-50 · S/N 1242Cancelled Jul 26, 1948 · Poole Samuel E JrN1314MDouglas RB-18 · S/N 2548Cancelled May 13, 1948 · Built 1939 · Triair IncN1315MDouglas RB-18 · S/N 2579Cancelled Apr 21, 1948 · Built 1939 · Triair IncN34694Stinson 10A · S/N 7994Cancelled Mar 30, 1948 · Willis M BoshearsN91816Schweizer SGU-1-19 · S/N 34Cancelled Oct 9, 1947 · Cromelin'S Air Activities IncN14570Stinson SR-5A · S/N 9314ACancelled Apr 29, 1944 · Built 1934 · Boshears Willis MN32630Piper J3L-65 · S/N 5499Cancelled Jan 19, 1941 · Stephens Thomas JN11757Monocoupe 90A · S/N A-686Cancelled Mar 7, 1939 · Weeks KatherineN9037Travel Air S-6000-B · S/N 838Cancelled Apr 7, 1938 · Allentown Aviation CorpN11327Great Lakes 2T-1A · S/N 244Cancelled Sep 19, 1936 · Built 1931 · Southern Airways IncN66247Cessna T-50 · S/N 4983Cancellation date not recorded · W M Boshears DBA Augusta Schoolof Aviation
Back to Augusta, GA