OpenAirDocs.org
Mineola, NY

Cancelled registrations · 44

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

N3645JAerostar International S-60A · S/N S60A-3144Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1990 · Re Max Of Ny Hot Air Balloon FundN2424CFairchild M-62A-3 · S/N FV-728Cancelled Feb 21, 2013 · Revoked, canceled · Built 1943 · Geddes Harry EN5091ZPiper PA-22-108 · S/N 22-8725Cancelled Aug 10, 2012 · Revoked, canceled · Built 1961 · Greves JohnN4FLCessna 210L · S/N 21061382Cancelled Feb 24, 2009 · Exported to Brazil · Built 1976 · Plandome Aviation LtdN28774Grumman American Avn. AA-5B · S/N AA5B0727Cancelled Feb 11, 1994 · Triennial form not returned · Keegan Rich JN602PDBell 47G-3B · S/N 3186Cancelled Sep 22, 1980 · Nassau County Consolidated Off Of Civil DefenseN5036FFairchild Hiller FH-1100 · S/N 183Cancelled Jan 6, 1978 · Sale reported · Built 1969N601PDFairchild Hiller FH-1100 · S/N 80Cancelled May 8, 1975 · County Of NassauN604PDBell 47D1 · S/N 519Cancelled May 8, 1975 · Nassau County Consdt OcdN605PDBell 47G · S/N 1177Cancelled May 8, 1975 · Nassau Co Consolidated Office Of Civil DefenseN606PDBell 47D1 · S/N 827Cancelled May 8, 1975 · Nassau Couonty Consolidated Office Of Civil DefensN607PDBell 47G · S/N 1211Cancelled May 8, 1975 · Nassau County Sonsolidated Office Of Civil DefenseN602PDBell 47D1 · S/N 526Cancelled Oct 15, 1973 · Nassau County Consldt OcdN4779QCessna A185E · S/N 185-1246Cancelled Oct 14, 1971 · Exported to Canada · Northrop Air Service IncN94527Grumman G-44 · S/N 1352Cancelled Dec 22, 1959 · Aero Trades IncN9054ACessna 170A · S/N 18813Cancelled Jan 4, 1956 · Stott Tool & Machine CoN6161KRepublic RC-3 · S/N 349Cancelled Nov 15, 1955 · Stott Tool & Machine CoN9690ACessna 140A · S/N 15411Cancelled Jun 8, 1950 · Personal Airplane Sales CorpN17730Waco ZGC-7 · S/N 4578Cancelled Jan 16, 1945 · Built 1937 · Pester Propeller SerivceN6892Ford 4-AT-B · S/N 28Cancelled Mar 30, 1943 · Built 1928 · Atlantic Airmotive CorpN5493Ford 4-AT-B · S/N 22Cancelled Jun 10, 1942 · Atlantic Airmotive CorpN1239Waco VKS-7 · S/N 5227Cancelled Jun 5, 1942 · Ailor Sales CorporationN482HStinson SM-2AC · S/N M1120Cancelled Mar 3, 1942 · Walling Donald BN4400Cessna T-50 · S/N 1008Cancelled Sep 25, 1941 · Built 1940 · Atlantic Aviation Sales IncN13711Douglas DC2 · S/N 1237Cancelled Mar 18, 1941 · Built 1934 · Cox & Stevens Aircraft CorporationN785VBrewster FLEET 2 · S/N 366Cancelled Sep 1, 1940 · Hangar Services IncN12177Stinson W · S/N 3051Cancelled Dec 15, 1939 · Purchase Flying Service IncN1302Trimmer Gilbert/Purchase Louis T-2 · S/N 1000Cancelled Dec 15, 1939 · Gilbert G TrimmerN954MRaab-Katzenstein Acft RK2C · S/N 2C-100Cancelled Oct 15, 1939 · Built 1929 · Copeland Hugh Et AlN14177Stinson SR-5E · S/N 9281-ACancelled Oct 11, 1939 · Built 1934 · Gordon William JN260HCurtiss Wright FLEDGLING · S/N B-37Cancelled Jun 15, 1939 · Built 1929 · Braman-Johnson Flying Service IncN9379Fairchild 22 C7E · S/N 1700Cancelled Jul 14, 1938 · Manning HarryN10172Aeronca C-2 · S/N 48Cancelled Apr 1, 1936 · Roosevelt Field IncN10174Aeronca C-2 · S/N 50Cancelled Mar 1, 1935 · Roosevelt Field IncN921KCurtiss Wright ROBIN C-1 · S/N 582Cancelled Jan 31, 1934 · Eugene LandloisN5918Avro 504K · S/N 2453Cancelled Feb 27, 1933 · Roosevelt Field Inc.N6949Sopwith Snipe 7F1 · S/N 7-F-1Cancelled Jan 3, 1933 · Roosevelt Field IncN10389Curtiss Wright JN4C · S/N 1898Cancelled Dec 19, 1932 · Built 1916 · Roosevelt Field IncN5754Nieuport 28 28 · S/N 503Cancelled Aug 15, 1932 · Roosevelt Field IncN14074Waco YMF · S/N 3964Cancelled Aug 5, 1931 · Built 1934 · Waco Sales Of Ny IncN76KBird A · S/N 1076Cancelled Jun 11, 1931 · Kelm GeorgeN242HFleet 2 · S/N 110Cancelled Dec 7, 1929 · Built 1929 · Roosevelt Aviation School IncN6090Travel Air Mfg 2000 · S/N 594Cancelled Nov 24, 1928 · N R Airways IncN1897Travel Air Manufacturing BIPLANE · S/N 244Cancelled Aug 23, 1928 · Built 1927 · Geo A Wies Inc
Back to Mineola, NY