Annapolis, MD

Cancelled registrations · 78

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 = 'MD' AND d.registrant_city = 'ANNAPOLIS'
  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.

N17LHLearjet 35A · S/N 428Cancelled Dec 17, 1996 · Exported to Australia · Hunter Aviation IncN145GJLearjet 35A · S/N 145Cancelled Sep 25, 1996 · Exported to Australia · Hunter Aviation IncN200YGates Lear Jet 36 · S/N 014Cancelled Sep 12, 1996 · Exported to Australia · Hunter Aviation IncN136STGates Lear Jet 36A · S/N 36A049Cancelled Aug 16, 1996 · Exported to Australia · Hunter Aviation IncN2252QPiper PA-32R-300 · S/N 32R7780235Cancelled Nov 22, 1994 · Exported to Israel · Aloft Enterprises IncN5631DMaule M-5-235C · S/N 7239CCancelled May 14, 1993 · Exported to Canada · Hunter Aviation IncN730TJPiper PA-22-135 · S/N 22730Cancelled May 5, 1993 · Exported to United Kingdom · Tango Juliet Airparts IncN123WTCessna 150M · S/N 15077050Cancelled Jun 25, 1992 · Exported to Germany · Applegate Richard CraigN8140ACessna 170B · S/N 20992Cancelled Jun 4, 1991 · Exported to Canada · Stephen Apple GateN5001SVan Dine Peter MERGANSER · S/N VND001ACancelled May 10, 1983 · Built 1978 · Vandine Peter DN7429ECessna 210 · S/N 57129Cancelled Mar 26, 1982 · Green Marvin DN9327BCessna 175 · S/N 55127Cancelled Oct 14, 1981 · Gessner Richard AN31NAGrumman American Avn. AA-1C · S/N AA1C-0208Cancelled Apr 9, 1980 · Naval Academy Flying ClubN8804WPiper PA-28-235 · S/N 28-10350Cancelled Dec 15, 1975 · W F Mann Reality IncN4211CStinson 108-3 · S/N 108-5211Cancelled Aug 14, 1975 · Exported to Canada · Built 1948 · Horn Tiemann NN66335Cessna 150M · S/N 150-75989Cancelled May 20, 1975 · Sollenberger Robert TN5839XCessna 310F · S/N 310-0139Cancelled Nov 22, 1974 · Albrecht Glen DBA Air TraderN532S N I A S SE 3130 ALOUETTE II · S/N 1145Cancelled Feb 18, 1971 · Sanders Aviation CoN2263UBrantly B-2B · S/N 425Cancelled Jun 30, 1970 · State Of Maryland/Dept Of Chesapeake BayaffairsN504Sud SE3130 ALOUETTE II · S/N 1085Cancelled Jun 19, 1970 · Sanders Aviation CompanyN46090Taylorcraft DCO-65 · S/N 4356Cancelled Oct 24, 1955 · Dixie Aero IncN2HStruble Arthur Dewey PD3-1 · S/N PD-3-1Cancelled Oct 17, 1955 · Built 1949 · Struble Arthur D JrN6269KRepublic RC-3 · S/N 479Cancelled Oct 17, 1955 · Welling ConradN46983Fairchild M-62A · S/N T41-488Cancelled Nov 6, 1951 · Edward D HaasN87511Republic RC-3 · S/N 64Cancelled Jun 7, 1949 · State Of MarylandN2236MPiper J3C-65 · S/N 21028Cancelled Jun 2, 1949 · Hinson-Mitchell Aviation IncN88348Piper J3C-65 · S/N 15966Cancelled Apr 7, 1949 · Hinson Mitchell Aviation IncN2755HErcoupe 415-C · S/N 3380Cancelled Nov 9, 1948 · Exported to Cuba · Sullivan J W
Back to Annapolis, MD