OpenAirDocs.org
Troy, OH

Cancelled registrations · 52

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 = 'OH' AND d.registrant_city = 'TROY'
  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.

N8326VChampion 7GCAA · S/N 102Cancelled Aug 5, 2019 · Sale reported, canceledN715XMeyer Brian E SUPER ACE · S/N 081Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Built 2011 · Meyer Brian EN91467Vandervort PIETENPOL AIRCAMPER · S/N 1002Cancelled Feb 26, 2018 · Registration expired, pending cancellation · Built 1977 · Vandervort Matthew JN524RJKuschel R/Kuschel R REVELATION · S/N RE00/0006Cancelled Feb 14, 2018 · Registration expired, pending cancellation · Built 2002 · Kuschel Rodney RN96854Taylorcraft BF · S/N 9154Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Rohrer Harold LN4452CBrinkman Richard L SKYHOPPER · S/N 10Cancelled Dec 3, 2014 · Registration expired, pending cancellation · Brinkman Richard LN2576VCessna 170 · S/N 18081Cancelled Sep 22, 2014 · Registration expired, pending cancellation · Built 1948 · Brinkman Richard LN50199Cessna 150H · S/N 15069129Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1968 · Davis Joseph KN717BBPiper AEROSTAR 601P · S/N 61P08258063433Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1980 · Miami Valley Pressure Cleaning IncN9014FWaco ATO · S/N A-46Cancelled Sep 12, 2012 · Registration pending, canceledN4HKKasinoff SCORPION TOO SP-2 · S/N 5421Cancelled Dec 9, 2011 · Second renewal notice · Built 1974 · Kasinoff Harvey AN881CDCirrus Design SR22 · S/N 1378Cancelled Jul 6, 2011 · Exported to Canada · Built 2005 · Steel Aviation IncN1921VWaco 4 WACO 4 · S/N 02Cancelled Jun 24, 2008 · Triennial form not returned · Built 1992 · Waco 4 IncN59MEMeyer Brian E ACRO 2 · S/N 59Cancelled Feb 9, 2008 · Triennial form not returned · Built 2000 · Meyer Brian EN920WMeyer Brian E COOTIE · S/N 001Cancelled Feb 9, 2008 · Built 2006 · Meyer Brian EN3223NPiper J3C-65 · S/N 22415Cancelled Feb 19, 2003 · Triennial form not returned · Built 1946 · Bertke Michael LN6053BCessna 210M · S/N 21062671Cancelled Jun 21, 2002 · Triennial form not returned · Built 1978 · Davies A RobertN78483Cessna 172K · S/N 17257633Cancelled Sep 14, 1994 · Triennial form not returned · Skypark Aero ClubN33662Piper PA-28-180 · S/N 287505164Cancelled Jun 16, 1993 · Triennial form not returned · Skypark Aero ClubN2754ZBellanca 8KCAB · S/N 369-78Cancelled Jul 6, 1984 · Administratively canceled · Zimmerman VictoriaN7149GCessna 172K · S/N 17258849Cancelled Dec 24, 1981 · Sky Park Aero Club IncN4263ABeech 95-B55 · S/N TC-1332Cancelled Sep 29, 1975 · Exported to Canada · Kaebnick Warren WN3662QBeech A23-24 · S/N MA-244Cancelled May 16, 1975 · Sky Park Aero Club IncN3767NBeech 35 · S/N D-988Cancelled Dec 11, 1973 · Leavelle Joel DN24049Taylorcraft BC-65 · S/N 1584Cancelled Jan 29, 1972 · Holly Covert PN23797Stinson HW75 · S/N 7248Cancelled Apr 28, 1971 · Kriete Robert CN28888Luscombe 8A · S/N 1630Cancelled Dec 4, 1969 · Exported to Canada · Beisner James AN20568Taylorcraft A · S/N 579Cancelled Feb 17, 1960 · Johnson JulianN82242Aeronca 7AC · S/N 7AC-870Cancelled Jan 16, 1960 · Built 1946 · Campbell James HN91156North American NAVION · S/N NAV452Cancelled Mar 28, 1957 · Hill Kenneth DN3484EAeronca 7AC · S/N 7AC-6864Cancelled Oct 12, 1956 · Campbell James HN47442Ryan Aeronautical ST3KR · S/N 1392Cancelled May 5, 1954 · Eyre John RN3687HEngineering & Research 415-C · S/N 4312Cancelled Jan 2, 1952 · Built 1946 · Sturgiss George GN17415Aeronca C-3 · S/N 726Cancelled Aug 6, 1948 · Mills George Whitfield BentN853MWaco WACO N-7 · S/N AT3041Cancelled Feb 18, 1948 · Waco Aircraft CoN20901Waco UPF-7 · S/N 4659Cancelled Dec 26, 1939 · Built 1939 · Waco Aircraft CoN17731Waco ZVN-7 · S/N 4675Cancelled Sep 1, 1939 · Built 1937 · Troy Flying Service IncN14130Waco S3HD · S/N 3837Cancelled May 1, 1939 · Exported to Nicaragua · Built 1934 · Troy Flying Service IncN16599Waco WACO N-7 · S/N 4486Cancelled Sep 29, 1937 · Waco Aircraft Company IncN15240Waco YOC · S/N 4322Cancelled May 15, 1937 · Troy Flying Services IncN12435Waco KCA · S/N 3585Cancelled Mar 30, 1937 · Built 1931 · Troy Flying Service IncN14690Waco YOC · S/N 4288Cancelled Mar 30, 1937 · Troy Flying Services IncN13445Waco UIC · S/N 3793Cancelled Jan 19, 1934 · Waco Aircraft Co IncN12099Waco ATO · S/N 3234Cancelled Jan 15, 1934 · Herbert M ElkinsN622YWaco INF · S/N 3367Cancelled Mar 17, 1932 · Waco Aircraft CoN11243Waco QCF · S/N 3486Cancelled May 11, 1931 · Built 1931 · Waco Aircraft CoN803VWaco NAZ · S/N 4001Cancelled Sep 5, 1930 · Waco Aircraft CompanyN264MWaco 220T · S/N AS 3002Cancelled May 2, 1930 · D C FlowerN652NWaco RNF · S/N 3197Cancelled May 2, 1930 · D C FlowerN2480Charles Ralph CHARLES E1 · S/N 101Cancelled Mar 14, 1930 · Scott Raymond
Back to Troy, OH