Newark, NJ

Cancelled registrations · 90

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

N5723NBoeing B-17F · S/N 6035Cancelled Dec 14, 1950 · Exported to Bolivia · Babb CompanyN38835Piper J3F-65 · S/N 7322Cancelled Sep 3, 1948 · Built 1941 · San Filippo Edward AN870KGreat Lakes 2T-1 · S/N 131Cancelled Apr 29, 1948 · Casey Jones School Of Aeronautics IncN433Kreider-Reisner CHALLENGER C-5 · S/N 179Cancelled Mar 29, 1948 · Okenfus L EugeneN88829Douglas DC3C-S1C3G · S/N 19415Cancelled Sep 30, 1946 · Veterans Air Express CoN385MTravel Air S-6000-B · S/N 6B2023Cancelled Jun 20, 1941 · Whitworth Donald O & Whitworth Marjorie EN562KMoth 60-GM · S/N 56Cancelled Jul 8, 1940 · Built 1929 · Huber AlfredN20672F Koepnick Jr/J Leisner/E Sayr SPORT · S/N 100Cancelled Oct 15, 1939 · Sayre Edgar Fred Koepnick Jr & Joseph LeisnerN15106Stinson A · S/N 9106Cancelled Oct 1, 1939 · Built 1935 · Airline Feeder System IncN23416Piper J-3 · S/N 3145Cancelled Jul 18, 1939 · North Jersey Flying Club IncN10525Baker Mcmillen CADET II · S/N 131Cancelled May 15, 1939 · Built 1930 · Lawrence Donald MN12271Bowlus PRIMARY GLIDER · S/N 100Cancelled May 1, 1939 · Built 1932 · Newark Glider Club IncN469MDetroit SEA ROVER E-2 · S/N 14Cancelled Nov 4, 1938 · Okenfus EugeneN11743Monocoupe 90A · S/N A672Cancelled Jul 25, 1937 · Built 1934 · Taliaferro C ChampeN123MFokker SUPER UNIVERSAL · S/N 864Cancelled Oct 15, 1935 · Fitzgerald T PN315NN C E Glider Club GLIDER · S/N 1Cancelled Mar 15, 1935 · Newark College Of Engineeringglider ClubN544VBellanca CH400 SKYROCKET · S/N 602Cancelled Sep 15, 1934 · Metropolitan Airways IncN1966Curtiss Wright JN4C · S/N 33788Cancelled Feb 3, 1934 · Built 1917 · Brookes Victor SN8399Curtiss Wright ROBIN · S/N 272Cancelled Oct 16, 1933 · Built 1929 · Newark Passenger Service IncN262HCurtiss Wright FLEDGLING · S/N B-39Cancelled Aug 25, 1933 · Exported to Peru · Casey Jones School Of Aeronautics IncN900MMoth 60-GM · S/N 101Cancelled Jul 28, 1933 · Dorset Fred LN55MMoth 60-GM · S/N 71Cancelled Feb 13, 1933 · Built 1929 · Coleman Clarence RayN347NAeromarine 39-B · S/N 55923Cancelled Feb 11, 1933 · Robertson DouglasN4112American Eagle A-1 · S/N 95Cancelled Feb 9, 1933 · Kroelinger Adam EN922MMoth 60-GM · S/N 121Cancelled Sep 27, 1932 · Built 1930 · Newark Air Service IncN387NAeromarine-Klemm L-26-B · S/N 2-62Cancelled Nov 6, 1931 · Swett A H JrN6887Douglas DC-6 · S/N X-1Cancelled Sep 10, 1931 · Airplane Sales & Service CompanyN5412Standard J-1 · S/N E1930Cancelled Mar 14, 1930 · Lawrence Elmer EN9732Moth 60G · S/N 912Cancelled Mar 14, 1930 · Heyer Products Co. IncN9989Travel Air 4-D · S/N 1165Cancelled Jan 30, 1930 · Marpole Airways IncN5226Travel Air 2000 · S/N 466Cancelled Jan 23, 1930 · Newark Passenger ServiceN8065Spartan C-3 · S/N 92Cancelled Aug 23, 1929 · Atlantic Air Service IncN1654Fairchild Airplane Mfg FC-2 · S/N 15Cancelled Jul 6, 1929 · Built 1927 · Harper Elizabeth CN2158Standard LAND PLANE · S/N UNKNOWNCancelled Aug 6, 1928 · Ahearn Roy LN331Kaess Aircraft Engineering Cor CL-1 · S/N CL-1Cancelled Aug 9, 1927 · Built 1926 · Muellet KarlN1433J O Eischeld BIPLANE · S/N 22641Cancellation date not recorded · Eischeid J ON2050Nieuport 23 · S/N A-240Cancellation date not recorded · Skyad FlyersN2220Standard J-1 · S/N 10Cancellation date not recorded · Gates Flying Circus & Aviation CoN3419Waco 10 · S/N 1111Cancellation date not recorded · Gottwalt FredN739Curtiss JN4D · S/N 1000ACancellation date not recorded · Shapiro Robert
Back to Newark, NJ