Miramar, FL

Cancelled registrations · 135

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 = 'FL' AND d.registrant_city = 'MIRAMAR'
  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.

N9149KStinson 108 · S/N 108-2149Cancelled Feb 4, 2017 · Revoked, canceled · Built 1947 · Brown Famous RN640AWAirbus Industrie A320-232 · S/N 448Cancelled Jul 12, 2016 · Sale reported · Built 1994N598FMDJI INSPIRE 1 · S/N W13DCB13020306Cancelled Jul 1, 2016 · Jessurun MaxN4936UCessna 210E · S/N 21058636Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1965 · Soto Susana MN9519WPiper PA-28-140 · S/N 28-22945Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1967 · Midwest Atlantic IncN7500ADouglas DC3 · S/N 11693Cancelled Dec 18, 2014 · Registration expired, pending cancellation · Built 1956 · Swain JeffN654GTSocata TB20 · S/N 2208Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 2003 · Rfm Technical Consulting LLCN6655FCessna 150F · S/N 15063255Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1966 · Ocean Pacific IncN707PPCessna 172D · S/N 17249752Cancelled Sep 22, 2014 · Registration expired, pending cancellation · Built 1962 · Rene Hodelin FN1341QCessna U206F · S/N U20602886Cancelled Jul 1, 2014 · Exported to Bolivia · Built 1975 · Fuqaha VaniaN49WTCessna U206F · S/N U20602768Cancelled Jan 8, 2014 · Exported to Bolivia · Built 1975 · Fuqaha VaniaN6064GCessna 150K · S/N 15071564Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Built 1969 · Waddell Dorothy HN2135CCessna 152 · S/N 15282631Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1978 · H A C Investments IncN749GBBrown Gordon E NIEUPORT C-1 · S/N 00749Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 2000 · Van Etten Edward AN4420QQualley James B GOLDWING · S/N 197Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Qualley James BN942VJDouglas DC-9-31 · S/N 47057Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1967N952VJDouglas DC-9-31 · S/N 47574Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1973N60061Cessna 150J · S/N 15070044Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Built 1968 · Estes & Dawns Aircraft IncN4576QCessna 402A · S/N 402A0076Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1969N6886ACessna 172 · S/N 28986Cancelled Jul 29, 2013 · Revoked, pending cancellation · Built 1956 · Garey Daniel W SrN979VJDouglas DC-9-31 · S/N 47372Cancelled Jul 16, 2013 · Sale reported, canceled · Built 1969N919PJMcdonnell Douglas DC-9-51 · S/N 47663Cancelled Jul 3, 2013 · Registration expired, pending cancellation · Built 1977 · Avteam IncN2262HEngineering & Research ERCOUPE 415-C · S/N 2887Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1946 · Fridley R MarkN956VJMcdonnell Douglas DC-9-31 · S/N 47588Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1973N953VJDouglas DC-9-31 · S/N 47583Cancelled Jun 14, 2013 · Sale reported, canceled · Built 1973N989VJDouglas DC-9-31 · S/N 47212Cancelled Jun 14, 2013 · Sale reported, canceled · Built 1968N3413MPiper PA-12 · S/N 12-2062Cancelled May 31, 2013 · Registration expired, pending cancellation · Built 1947 · Aviation Enterprises IncN52PBSukhoi SU-29 · S/N 72-03Cancelled May 30, 2013 · Registration expired, pending cancellation · Aerial Three IncN73948Bell 47J-2 · S/N 2836Cancelled May 7, 2013 · Registration expired, pending cancellation · Action Helicopters IncN941VJDouglas DC-9-31 · S/N 47054Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1967N975VJDouglas DC-9-31 · S/N 47146Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1967N993VJDouglas DC-9-31 · S/N 47332Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1969N940VJDouglas DC-9-31 · S/N 47053Cancelled Mar 20, 2013 · Sale reported, canceled · Built 1967N951VJMcdonnell Douglas DC-9-31 · S/N 47576Cancelled Mar 20, 2013 · Sale reported, canceled · Built 1972N4948TPiper PA-28-140 · S/N 28-7225287Cancelled Mar 18, 2013 · Registration expired, pending cancellation · Built 1972 · Murphy Barry CN56111Piper PA-32-260 · S/N 32-7300051Cancelled Feb 21, 2013 · Revoked, canceled · Built 1973 · West Ender CorporationN6817XCessna 172A · S/N 47717Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1960N12505Mcdonnell Douglas DC-9-32 · S/N 45788Cancelled Nov 8, 2012 · Registration expired, pending cancellation · Built 1967 · Avteam IncN1019UCessna 170A · S/N 19312Cancelled Oct 11, 2012 · Registration expired, pending cancellation · Gallina RobertN25833Cessna 152 · S/N 15280806Cancelled Sep 12, 2012 · Registration expired, pending cancellation · Built 1977 · H A C Investments IncN470ASAirbus Industrie A300 B4-103 · S/N 063Cancelled Sep 6, 2012 · Registration expired, pending cancellation · Aviation Sales Leasing CoN3088NCessna 140 · S/N 13346Cancelled Sep 5, 2012 · Sale reported, canceled · Built 1947N50849Cessna 150J · S/N 15069595Cancelled Aug 22, 2012 · Registration pending, canceled · Built 1968N4654SSikorsky S-52-2 · S/N 130114Cancelled Jul 31, 2012 · Revoked, canceled · Built 1965 · Tropical Helicopters IncN3HTCessna 337 · S/N 337-0046Cancelled May 24, 2012 · Registration pending, canceled · Built 1965N141ABCessna 550 · S/N 550-1044Cancelled Apr 11, 2011 · Exported to Brazil · Built 2002 · Jetwaves IncN911BHMesserschmitt BO105CBS · S/N S-685Cancelled Jun 21, 2010 · Exported to Suriname · Suri-Tech IncN140TFCessna 550 · S/N 550-1015Cancelled Dec 16, 2009 · Exported to Brazil · Built 2002 · Jetwaves IncN8450CAero Commander 560-E · S/N 759Cancelled Sep 15, 2009 · Registration revoked · Built 1959 · Owens KennethN6618UCessna U206G · S/N U20605505Cancelled Jul 16, 2009 · Exported to Honduras · Built 1979 · Goff Amador Jaser
Back to Miramar, FL