OpenAirDocs.org
New Brunswick, NJ

Cancelled registrations · 29

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 = 'NJ' AND d.registrant_city = 'NEW BRUNSWICK'
  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.

N683ENDJI INSPIRE 1 · S/N W13DCD06030451Cancelled Nov 4, 2019 · Registration expired, pending cancellation · New Brunswick Development CorpN769TRDJI PHANTOM 2 · S/N PH646085119Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Rutgers The State University Of New JerseyN769VSDJI S1000+ · S/N 03P0015107Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Rutgersthe State University Of New JerseyN769ZUDJI PHANTOM 4 · S/N 07DDD460A10636Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Rutgers The State University Of New JerseyN176RVDJI Innovations PHANTOM 3 PROFESSION · S/N P76DCF26016200Cancelled May 4, 2019 · Registration expired, pending cancellation · Vanecek Robert JN578NRSteadidrone PTY QU4D X · S/N SDMAPQU4DX004Cancelled Dec 11, 2018 · Registration expired, pending cancellation · Rutgers The State University Of New JerseyN93965Ercoupe 415-C · S/N 1288Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1946 · Jinotti Walter JN70748Piper J3C-65 · S/N 17765Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1946 · Hadley Aircraft IncN42872Piper J3C-65 · S/N 15203Cancelled Sep 17, 2012 · Revoked, canceled · Built 1945 · Hadley Arcft IncN4268QCessna 172L · S/N 17260168Cancelled Jul 20, 1982 · Exported to Canada · Built 1971 · Moore DennisN322EGNavion NAVION A · S/N NAV41953Cancelled Jun 29, 1970 · Built 1949 · Nierenberg Richard Et AlN37500Lockheed 18 · S/N 2251Cancelled Nov 5, 1963 · Built 1942 · Johnson And JohnsonN97804Stinson 108-1 · S/N 108-804Cancelled Oct 23, 1959 · Walter GingrichN58499Taylorcraft DCO-65 · S/N L-5658Cancelled Feb 14, 1956 · Gianchiglia Louis & Henry HansenN23398Piper J3L · S/N 3132Cancelled Oct 6, 1955 · Built 1939 · Smith Robert HenryN2191EAeronca 7AC · S/N 7AC-5765Cancelled Jan 27, 1953 · Ondre Michael GN80332Beech D18S · S/N A-242Cancelled Nov 7, 1952 · Exported to Canada · Triangle Conduit & Cable Co IncN716YNew Standard D-29A · S/N 1034Cancelled Aug 31, 1950 · Built 1931 · Brittingham Nathaniel 3rdN19839Taylorcraft A · S/N 344Cancelled May 7, 1948 · Built 1937 · Meltz Robert E DBA Meltz Aircraft CoN28KNew Standard D-25 · S/N 147Cancelled Apr 29, 1948 · SoldN51754Fairchild M-62A · S/N T40-157Cancelled Oct 16, 1947 · Aeromotive Corp Of Nj IncN18956Lockheed 12A · S/N 1244Cancelled Apr 20, 1944 · Built 1937 · Johnson And JohnsonN15737Aeronca C-3 · S/N A-636Cancelled Apr 15, 1938 · Unger Aircraft IncN42KBird A · S/N 1072Cancelled Aug 1, 1935 · Fisher Fredrick G JrN217HUS Aircraft Corp Of NJ SP-7 · S/N 4Cancelled Sep 9, 1930 · United States Aircraft Co Of New JerseyN601HTravel Air B-4000 · S/N 1168Cancelled Jun 27, 1930 · Unger Aircraft IncN9837Travel Air B-4000 · S/N 1061Cancelled May 28, 1930 · Runyon Walter P JrN468NTravel Air B-4000 · S/N 1369Cancelled Jan 31, 1930 · Allen Albert JN1242Waco 9 · S/N 263Cancelled Mar 1, 1929 · Built 1927 · Reynolds Airways Inc
Back to New Brunswick, NJ