Ocala, FL

Cancelled registrations · 183

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

N4231KFaulkender Walter R KR-2 · S/N WF-1Cancelled May 7, 2015 · Registration expired, pending cancellation · Built 1981 · Larose William GN599WTHelpling Helen C TANGO 2 · S/N T021Cancelled Mar 12, 2015 · First renewal notice · Built 2013 · Helpling Helen CN74AKCogdell Saundra K Peper B-2 · S/N X-1Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1986 · Cogdell Saundra K PeperN233JCChambers James Berney II JBC-B3 · S/N X-6Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1985 · Chambers James BN91747North American NAVION · S/N NAV4-191Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1947 · Sepper ScottN5879ZPiper PA-22-108 · S/N 22-9739Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1963 · Marsh Densel LN2640RRaven S55A · S/N S55A-418Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1978 · Chambers James BN14AKRaven S-40A · S/N S40A-114Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1967 · Cogdell SaundraN321JKKruszka Jerome M CHRISTIAN EAGLE II · S/N JMK-0001Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1996 · Petes Planes IncN5684URaven S55A · S/N S55A-524Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Chambers James B IIN733NJCessna 172N · S/N 17268417Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1976 · Parker Stephen LN100HESaint Stephen F GENESIS · S/N 029Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1996 · Saint Stephen FN7493YPiper PA-30 · S/N 30-554Cancelled Aug 28, 2013 · Registration expired, pending cancellation · Built 1964 · Orient Air IncN25733Piper J4A · S/N 4-816Cancelled Aug 27, 2013 · Sale reported, canceled · Built 1939N2453Starduster Too SA-300 · S/N 284Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1972N40122Stinson 108 · S/N 108-52Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1946N64430Beech C18S · S/N 5661Cancelled Aug 6, 2013 · Revoked, canceled · Built 1943 · Guided Tour ProductionsN85QBGorham Raymond L VANS RV-4 · S/N 2148Cancelled Jul 30, 2013 · Sale reported, canceledN70887Boeing B-29 · S/N 45-21768Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Kee Bird Limited Liability CompanyN120ABCessna 120 · S/N 10910Cancelled Jul 16, 2013 · Registration expired, pending cancellation · Built 1946 · Eadie AlanN8012MMoore Jack C ROTORWAY EXEC · S/N 3075Cancelled Jul 16, 2013 · Registration expired, pending cancellation · Hambleton John AN5672TRaven Industries RX6 · S/N RX6-302Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1978 · Scherm Peter JN742JCColt Balloons 105-A · S/N 742Cancelled Jul 3, 2013 · Registration expired, pending cancellation · Built 1986 · Chambers JimN28FBGrumman TBM-1 · S/N 53828Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1959N90672Robinson Helicopter R22 · S/N 0169Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1981 · Stanleys Diesel Towing & Ser IncN18908Ryan Aeronautical SCW-145 · S/N 202Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1938 · Leeward Development Group IncN5392Pietenpol GN-1 · S/N 338Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Built 1973 · Merchant Duane EN808CBChambers James B CRUISAIR JBCTS1 · S/N X5Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1982 · Chambers James BN96087Beech 65 · S/N LC-205Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1966 · Silver Steven AN80215Cessna 172M · S/N 17266451Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1975 · Aero Quad Aviators Club IncN81961Aeronca 7AC · S/N 7AC-586Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1946 · Sigmon Marshall WN5519KBellanca 8KCAB · S/N 384-78Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1978 · Rocky Top Aero IncN10AFPiper PA-23-250 · S/N 27-7854071Cancelled Apr 10, 2013 · Registration expired, pending cancellation · Macquarrie & Associates PaN748PMSeymour Michael Matthew JR ROTORWAY 162F · S/N 6393Cancelled Mar 8, 2013 · Exported to Brazil · Built 2002 · Magnuson Peter CN1230LLockheed 18 · S/N 2547Cancelled Nov 29, 2012 · Registration revoked · Pb Investment CorpN43327Taylorcraft BC12-D · S/N 6986Cancelled Nov 26, 2012 · Registration expired, pending cancellation · Built 1946 · Thorp Vernon EN7037KLowdermilk Thomas WOODSTOCK II · S/N 187Cancelled Nov 19, 2012 · Registration expired, pending cancellation · Lowdermilk Thomas CN82561Helio H-395 · S/N 618Cancelled Nov 8, 2012 · Sale reported, canceledN3145EAeronca 11AC · S/N 11AC-1523Cancelled Sep 27, 2012 · Registration expired, pending cancellation · Built 1947 · Regner Carl GN2517UCessna 172D · S/N 17250117Cancelled Sep 12, 2012 · Registration expired, pending cancellation · Built 1963 · Cone Al JN7SEPiper PA-23 · S/N 23-1127Cancelled Sep 12, 2012 · Registration pending, canceled · Built 1957N505RSBeech 65-80 · S/N LD-41Cancelled Sep 6, 2012 · Sale reported, pending cancellation · Built 1962N2950NCessna 140 · S/N 13208Cancelled Aug 30, 2012 · Sale reported, canceled · Built 1947N2186PPiper PA-23 · S/N 23-795Cancelled Aug 27, 2012 · Registration expired, pending cancellation · Built 1956 · Hamer Sanford LN9175PSmith Jennifer Louise ADVENTURE AIR · S/N 151Cancelled Aug 27, 2012 · Sale reported, canceledN6569LMitsubishi MU-2B-35 · S/N 645Cancelled Aug 22, 2012 · Registration pending, canceledN12496Aeronca C-3 · S/N 210Cancelled Aug 13, 2012 · Registration pending, canceled · Built 1932N181PMDouglas DC3A · S/N 2191Cancelled Aug 13, 2012 · Registration expired, pending cancellation · Built 1940 · American Eagle International IncN1417PPiper PA-23 · S/N 23-472Cancelled Jun 27, 2012 · Registration expired, pending cancellation · Built 1956 · Walkwitz Raymond DN11798Monocoupe 90A · S/N A-722Cancelled Jun 4, 2012 · Sale reported, canceled · Built 1936
Back to Ocala, FL