OpenAirDocs.org
Stevensville, MD

Cancelled registrations · 22

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 = 'STEVENSVILLE'
  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.

N8244HDunn Melvin L TITAN · S/N MG98912C0HK0302Cancelled Feb 6, 2019 · Registration expired, pending cancellation · Built 1999 · Dunn Alta RN3232LCessna 172H · S/N 17256132Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1967 · Simpson Michael EN1169KLuscombe 8C · S/N 3896Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Fichera JosephN452AGAutogyro CALIDUS · S/N C00429Cancelled Sep 30, 2016 · Built 2016 · Autogyro USA LLCN451AGAutogyro CALIDUS · S/N C00428Cancelled Sep 29, 2016 · Built 2016 · Autogyro USA LLCN3812HEngineering & Research 415-D · S/N 4513Cancelled Aug 19, 2016 · Third renewal notice · Pender Robin JN4578KRyan NAVION · S/N NAV-4-1578Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1948 · Martin Robert CN7619JPiper PA-28R-180 · S/N 28R-31013Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1968 · Galdieri Aviation IncN3930NMooney M20C · S/N 680006Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1968 · Bonner John LN8111AMccarthy John E SPAD VII · S/N 2124Cancelled Nov 15, 2012 · Triennial form not returned · Mccarthy John EN526GCMoravan ZLIN 526F · S/N 1185Cancelled May 4, 2004 · Triennial form not returned · Built 1972 · Nagy John EN654RFIca Brasov IS-29D2 · S/N 209Cancelled Nov 1, 2000 · Friedhoff Ronald KN515TNMarteney Donald L PITTS S1S · S/N 7-0255Cancelled Aug 3, 2000 · Triennial form not returned · Nagy Teresa AN5088QCessna 152 · S/N 15285070Cancelled Jul 27, 1999 · Triennial form not returned · Aero Source IncN30590Cessna 177A · S/N 17701346Cancelled Mar 17, 1992 · Wemmer William AN3303VCessna 150M · S/N 15076455Cancelled Mar 10, 1992 · Journey Aviation IncN3794Midget Mustang LK1 · S/N RSG-1Cancelled Jul 24, 1982 · Built 1971 · Zimmerman RoydenN764AABeech A23-24 · S/N MA-149Cancelled Jul 21, 1976 · Dunn Charles G SrN2138RPiper PA-28-180 · S/N 28-5468Cancelled Sep 13, 1973 · Redshaw IncN3630KPiper PA-28-140 · S/N 28-23659Cancelled Mar 23, 1971 · Chesapeake Airacraft Sales IncN7545HPiper PA-12 · S/N 12-417Cancelled Apr 18, 1961 · Exported to Germany · Built 1946 · Meyer Ward AN2230DCessna 170B · S/N 20382Cancelled Dec 4, 1952 · Mylander Walter Jr C
Back to Stevensville, MD