OpenAirDocs.org
Lockport, NY

Cancelled registrations · 50

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 = 'NY' AND d.registrant_city = 'LOCKPORT'
  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.

N709BBrown Fred EXCALIBUR II · S/N 709Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 2011 · Mccandlish William DN780WNDJI PHANTOM 2 VISION + · S/N PH646030466Cancelled Dec 2, 2019 · Registration expired, pending cancellation · Niagara County Sheriffs OfficeN5120NBoeing N2S-3 · S/N 75-7042Cancelled Aug 23, 2018 · Revoked, canceled · Built 1943 · Barrie Aero CorpN9210KStinson 108-1 · S/N 108-2210Cancelled Mar 16, 2018 · Revoked, canceled · Built 1947 · Duchscherer Michael AN9565NSmith Ray W SUPERCUB · S/N 033128Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Smith Ray WN37867Porterfield LP-65 · S/N 1014Cancelled Nov 18, 2017 · Revoked, canceled · Built 1941 · Smith RayN93USPiccard AX-6 · S/N 693Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1974 · Dobos Charles JN6280LRaven S55A · S/N S55A-209Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Built 1974 · Zirnheld RichardN2029BLuscombe 8A · S/N 6456Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1948 · Vosburgh Simon D SrN2228APiper PA-22-135 · S/N 22-631Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1952 · Korosi Michael LN7089TCessna 172 · S/N 46689Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1959 · Kneeppel Duane HN60201Taylorcraft DCO-65 · S/N L-5664Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1943 · Trudnowski Paul DBAN22655Cessna 150H · S/N 15068430Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1968 · Howard Lee J DBAN95867Taylorcraft BC12-D · S/N 8167Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1946 · Klemann Richard LN8500KStinson 108-1 · S/N 108-1500Cancelled Sep 20, 2012 · Registration pending, canceled · Built 1947N47067Fairchild M-62A · S/N 4913AECancelled Aug 1, 2012 · Revoked, canceled · Built 1943 · Oconnor Corneilus NN32RKKorff Ralh STARDUSTER SA 100 · S/N 0086Cancelled Jul 8, 2008 · Exported to Canada · Built 1994 · Palmer Kim WN114AFRockwell International 114 · S/N 14004Cancelled Nov 28, 2006 · Exported to Australia · Built 1976 · Palmer Airmotive IncN34176Schweizer SGS 1-35 · S/N 16Cancelled Jun 15, 2006 · Exported to Canada · Built 1975 · Meli Anthony GN4857KRyan NAVION A · S/N NAV-4-1857Cancelled Dec 6, 2005 · Built 1949 · Gollus Daniel TN5000PPiper PA-24 · S/N 24-3Cancelled Jun 3, 2003 · Exported to Canada · Built 1957 · Praus Friedrich JN704GPCessna 150M · S/N 15078602Cancelled Mar 2, 2000 · Triennial form not returned · Stoner George H DBAN73627Cessna 172M · S/N 17267587Cancelled Apr 13, 1992 · Triennial form not returned · Stoner George HN5266TPiper PA-28-140 · S/N 287225381Cancelled May 3, 1991 · Triennial form not returned · Padula Armand LN64BTNorth American NA-64 · S/N 64-2159Cancelled Nov 16, 1984 · Clark Donald SN5639TCessna 172E · S/N 17251539Cancelled Mar 2, 1982 · 39 Tango IncN8643KStinson 108-1 · S/N 108-1643Cancelled Jul 22, 1981 · Exported to Canada · Kennis Lumber IncN83926Aeronca 7AC · S/N 7AC-2609Cancelled Apr 18, 1977 · Built 1946 · Harriman Dolores JN60428Boeing A75N1(PT17) · S/N 75-1479Cancelled Jun 24, 1976 · Sale reported · Built 1941N4615ACessna 180 · S/N 32213Cancelled Jun 2, 1975 · Built 1956 · El Comp Data Systems IncN39109Taylorcraft BF-65 · S/N 3326Cancelled May 12, 1975 · Norman V IngramN9255HFairchild M-62A-3 · S/N FT-699Cancelled Oct 23, 1974 · Klemann Richard LN38023Piper J4E · S/N 4-1523Cancelled Jan 26, 1972 · Butera Joseph MN35161Piper J3L-65 · S/N 6183Cancelled Dec 8, 1971 · H Paul HarpstN96701Taylorcraft BC12-D · S/N 9001Cancelled Dec 16, 1970 · Herbert R Aikin SrN6409HPiper J3C-65S · S/N 19596Cancelled Aug 18, 1970 · Built 1946 · Covell Donald R EtalN16834Fairchild 24 C8F · S/N 3129Cancelled Jun 30, 1970 · Graf George LN5212MTaylorcraft BC12-D · S/N 10512Cancelled Jun 30, 1970 · George L GrafN7141HPiper J3C-65 · S/N 20398Cancelled Jun 30, 1970 · Graf George LN9937HStinson VULTEE V-77 · S/N 77-371Cancelled Jun 29, 1970 · Lee HowardN60224Cessna T-50 · S/N 5806Cancelled Sep 20, 1957 · Graf George LN39262Taylorcraft BC12-D · S/N 6516Cancelled May 3, 1955 · Built 1945 · Wall JohnN60463Boeing A75 · S/N 75-121Cancelled Mar 10, 1955 · Built 1939 · Barrie Aeronautical CorpN8375KStinson 108-1 · S/N 108-1375Cancelled Mar 2, 1953 · Graf George LN85554Aeronca 7AC · S/N 7AC-4296Cancelled Aug 6, 1951 · Built 1946 · Crafts Wesley LN34720Porterfield LP-65 · S/N 886Cancelled Sep 17, 1948 · Georte L GrafN51899Fairchild M-62A · S/N T41-965Cancelled Aug 20, 1947 · Built 1945 · Graf George LN5108Waco GXE · S/N 1499Cancelled May 2, 1937 · Miller G JesseN490YStinson SM-8A · S/N M-4286Cancelled May 10, 1932 · Built 1931 · Wylam James NN1672Waco 10 · S/N 911Cancelled May 1, 1931 · Built 1927 · Miller Jesse G
Back to Lockport, NY