OpenAirDocs.org
Jackson Heights, NY

Cancelled registrations · 38

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 = 'JACKSON HEIGHTS'
  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.

N30478Piper J3L-65 · S/N 4860Cancelled Nov 4, 2019 · Revoked, pending cancellation · Built 1940 · Lamberti George AN916TSBoeing 727-254 · S/N 20437Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1970 · Shuttle IncN913TSBoeing 727-254 · S/N 20250Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1969 · Shuttle IncN919TSBoeing 727-225 · S/N 20447Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1970 · Shuttle IncN914TSBoeing 727-254 · S/N 20251Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1970 · Shuttle IncN918TSBoeing 727-225 · S/N 20445Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1970 · Shuttle IncN6513RBeech B19 · S/N MB-725Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1974 · East Coast Aviation IncN912TSBoeing 727-254 · S/N 20438Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1970 · Shuttle IncN902TSBoeing 727-25 · S/N 18267Cancelled Jun 9, 1997 · Triennial form not returned · Shuttle IncN915TSBoeing 727-254 · S/N 20252Cancelled May 13, 1997 · Shuttle IncN901TSBoeing 727-25 · S/N 18257Cancelled Feb 1, 1996 · Triennial form not returned · Shuttle IncN903TSBoeing 727-25 · S/N 18272Cancelled Feb 1, 1996 · Triennial form not returned · Shuttle IncN908TSBoeing 727-214 · S/N 19685Cancelled Feb 1, 1996 · Triennial form not returned · Shuttle IncN911TSBoeing 727-214 · S/N 19689Cancelled Feb 1, 1996 · Triennial form not returned · Shuttle IncN909TSBoeing 727-214 · S/N 19686Cancelled May 23, 1995 · Triennial form not returned · Shuttle IncN8117NBoeing 727-25 · S/N 18268Cancelled May 22, 1995 · Triennial form not returned · Shuttle IncN904TSBoeing 727-25 · S/N 18291Cancelled Aug 8, 1994 · Exported to Democratic Republic of the Congo · Shuttle IncN910TSBoeing 727-214 · S/N 19687Cancelled Mar 26, 1993 · Exported to Belgium · Shuttle IncN7400PPiper PA-24-250 · S/N 24-2584Cancelled Jun 26, 1970 · Dot-Well IncN2597JCessna 150E · S/N 15061097Cancelled Mar 20, 1968 · Exported to Germany · Masin Joseph VN3784SCessna 172E · S/N 17250984Cancelled Mar 20, 1968 · Exported to Germany · Masin Joseph VN5623RCessna 172F · S/N 17253239Cancelled Mar 20, 1968 · Exported to Germany · Built 1965 · Masin JosephN9226WPiper PA-28-235 · S/N 28-10894Cancelled Jul 13, 1967 · Exported to Belgium · Masin Joseph VN7582DPiper PA-18-150 · S/N 18-5878Cancelled Mar 31, 1967 · Exported to Germany · Masin Joseph VN3373ZPiper PA-18-150 · S/N 18-7246Cancelled Mar 9, 1967 · Exported to Germany · Masin Joseph VN111CMooney M-18L · S/N 72Cancelled Jun 16, 1965 · Dot Will IncN301BBeech G35 · S/N D-4640Cancelled Nov 5, 1957 · Danko John FN90CDouglas DC3 · S/N 2199Cancelled Aug 19, 1955 · Exported to Colombia · American Airlines IncN9235HHoward DGA-15P · S/N 781Cancelled Apr 13, 1950 · Patecell Ted CN9240HHoward DGA-15P · S/N 764Cancelled Apr 13, 1950 · Patecell Ted CN16017Douglas DC3-G102 · S/N 1555Cancelled Feb 23, 1943 · American Airlines IncN14966Douglas DC2 · S/N 1406Cancelled Jul 22, 1941 · Built 1935 · American Airlines IncN14278Douglas DC2 · S/N 1311Cancelled Jun 5, 1941 · Built 1934 · American Airlines IncN14279Douglas DC2 · S/N 1312Cancelled Jun 5, 1941 · American Airlines IncN14282Douglas DC2 · S/N 1315Cancelled Dec 11, 1940 · Exported to India · American Airlines IncN14283Douglas DC2 · S/N 1316Cancelled Dec 11, 1940 · Exported to United Kingdom · Built 1934 · American Airlines IncN10175Aeronca C-2 · S/N A-51Cancelled May 15, 1932 · Hall Roy MN691George Francis Myers ANNULAR · S/N M A 6Cancelled Feb 28, 1930 · George Francie Myers
Back to Jackson Heights, NY