Miami, FL

Cancelled registrations · 5,508

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

N8774URans S12XL · S/N 075950635Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Guardian Angel AviationN897USFokker F.28 MK 0100 · S/N 11392Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Aircraft Finance Services IncN209KWCessna 206H · S/N 20608013Cancelled Jan 16, 2018 · Registration expired, pending cancellation · Built 1998 · N209kw LLCN156PBell 206B · S/N 611Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1971 · Mt Pleasant CorpN5614YPiper PA-23-250 · S/N 27-2723Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1965 · Russell Eugene GiovanniN101NLLadas/Brown/Gargano AMATEUR BUILT · S/N A86POWCancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 2001 · Ladas Nicholas DrN10590Moses Robert RIDGE RUNNER 3S · S/N 1030081445Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 2010 · Moses RobertN116PYAirbus Industrie A300 B4-203 · S/N 116Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Pyramid Leasing One IncN515HCMcdonnell Douglas DC-9-82(MD-82) · S/N 49515Cancelled Jan 9, 2018 · Registration expired, pending cancellation · A & W Aeronautic Service IncN7872FCessna A150L · S/N A1500451Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1973 · Pegasus Aircraft Parts & Systems IncN513HCMcdonnell Douglas DC-9-82(MD-82) · S/N 49513Cancelled Jan 8, 2018 · Registration expired, pending cancellation · A & W Aeronautic Service IncN6933RCessna T210H · S/N T210-0333Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Gaitan Luis CarlosN718TCThunder & Colt THUNDER AX8-105 S1 · S/N 2349Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1993 · Sunrise Community Promotions IncN7675FCessna 337C · S/N 337-0899Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1968 · Valdes RafaelN419MTMcdonnell Douglas DC-9-82(MD-82) · S/N 49419Cancelled Jan 4, 2018 · Registration expired, pending cancellation · A & W Aeronautic Service IncN446AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49472Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1987 · Air Capital Group LLCN48WAGates Lear Jet 25B · S/N 136Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1973 · Aircraft Trading IncN27FTPiper PA-23-250 · S/N 27-7654174Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Angiel Envirosafe IncN298SCChief Aircraft Of America SKYCHIEF SS · S/N SS0807001Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 2007 · Chief Aircraft Of America IncN3101HRobinson Helicopter R44 · S/N 1610Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 2006 · Bravo Helicopters LLCN1694PErick Magno & Assoc Pa DRIFTER · S/N UA005Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 2006 · Amador Frank PN20658Cessna 172M · S/N 17261467Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1973 · Pegasus Aircraft Parts & Systems IncN2117APiper PA-18A-135 · S/N 18-1847Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1952 · Hera Abel AN45WMMcadam W E CHRISTEN EAGLE II · S/N MCADAM-0001Cancelled Dec 19, 2017 · Exported to ArgentinaN1109CTextron B300 · S/N FL-1109Cancelled Dec 14, 2017 · Exported to Cameroon · Built 2017 · Africair IncN920CSCirrus Design SR22T · S/N 0286Cancelled Dec 14, 2017 · Exported to Colombia · Built 2012 · Helicraft Parts & Components LLCN294SWEmbraer EMB-120ER · S/N 120321Cancelled Dec 12, 2017 · Exported to Turks and Caicos Islands · Built 1996 · Jahn294sw LLCN2575BNorthrop C-125 · S/N 48638Cancelled Nov 22, 2017 · Revoked, canceled · Ambrose Frank Avia Co IncN2576BNorthrop C-125 · S/N 48639Cancelled Nov 22, 2017 · Revoked, canceled · Ambrose Frank Avia Co IncN2577BNorthrop C-125 · S/N 48640Cancelled Nov 22, 2017 · Revoked, canceled · Ambrose Frank Avia Co IncN215TVBritish Aerospace BAE JETSTREAM 3101 · S/N 784Cancelled Nov 21, 2017 · Exported to Venezuela · R & V Aviation Services IncN5502ECessna 150 · S/N 17002Cancelled Nov 21, 2017 · Revoked, canceled · Built 1958 · Liberty School Of Aviation IncN5523AStinson 108 · S/N 1084292Cancelled Nov 21, 2017 · Revoked, canceled · Crownover John AN55499Consolidated Vultee SNV-1 · S/N 791598Cancelled Nov 21, 2017 · Revoked, canceled · Built 1944 · Minehart Thomas EN7210BBeech J35 · S/N D-5515Cancelled Nov 21, 2017 · Revoked, canceled · Built 1958 · Grier James ScottN74389Bellanca 14-13-2 · S/N 1502Cancelled Nov 21, 2017 · Revoked, canceled · Built 1947 · Mcdonald Jimmie LN74690Curtiss Wright C-46D · S/N 33463Cancelled Nov 21, 2017 · Revoked, canceled · Aero Factors CorpN77569Piper J3C-65 · S/N 22061Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Shrum George WN7968QCessna 401B · S/N 401B0108Cancelled Nov 21, 2017 · Revoked, canceled · Built 1971 · Aviation Facilities IncN810WLCessna 310Q · S/N 310Q0439Cancelled Nov 21, 2017 · Exported to Dominican Republic · Built 1971 · Hernandez GiancarloN9394FHughes 269B · S/N 0117Cancelled Nov 21, 2017 · Revoked, canceled · Built 1964 · Jannack George WN9479HBoeing E75 · S/N 758794Cancelled Nov 21, 2017 · Revoked, canceled · Built 1943 · Palmer Harry C JrN9520CConsolidated Vultee PBY-6A · S/N 64053Cancelled Nov 21, 2017 · Revoked, canceled · Aircraft Instrument CorpN9531CConsolidated Vultee PBY-6A · S/N 46685Cancelled Nov 21, 2017 · Revoked, canceled · Aircraft Instrument CorpN9532CConsolidated Vultee PBY-6A · S/N 46666Cancelled Nov 21, 2017 · Revoked, canceled · Aircraft Instrument CorpN9533CConsolidated Vultee PBY-6A · S/N 64042Cancelled Nov 21, 2017 · Revoked, canceled · Aircraft Instrument CorpN9553CConsolidated Vultee PBY-6A · S/N 46642Cancelled Nov 21, 2017 · Revoked, canceled · Aircraft Instrument CorpN9554CConsolidated Vultee PBY-6A · S/N 64044Cancelled Nov 21, 2017 · Revoked, canceled · Aircraft Instrument CorpN9585ZBeech TC-45H · S/N AF-124Cancelled Nov 21, 2017 · Revoked, canceled · International Acft Dlvrs IncN53964Fairchild M-62A · S/N T435526Cancelled Nov 20, 2017 · Revoked, canceled · Built 1942 · Vino Jack J
Back to Miami, FL