OpenAirDocs.org
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.

N908BPApollo JET STAR AS-II · S/N 00003KCancelled Aug 10, 2024 · Sale reported, canceled · Built 2009N21484Piper J-3C · S/N 2320Cancelled Oct 14, 2023 · Revoked, canceled · Built 1938 · Deville J CN685NJDJI PHANTOM 4 PRO · S/N 07DDD5A0A11344Cancelled Apr 3, 2020 · Registration expired, pending cancellation · New Jersey Institute Of TechnologyN19HFSikorsky S-76B · S/N 760315Cancelled Dec 13, 2019 · Built 1985 · Heliflite Shares LLCN430HFBell 430 · S/N 49052Cancelled Dec 13, 2019 · Built 1999 · Heliflite Shares LLCN51681Boeing A75N1(PT17) · S/N 754689Cancelled May 18, 2018 · Revoked, canceled · Built 1943 · N J Tow Banner And Cargo CoN6484SCessna 150H · S/N 15067284Cancelled Mar 28, 2018 · Registration expired, pending cancellation · Fernandes Joaquim SilvaN2184ECessna 172N · S/N 17271181Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Fernandes Joaquim SilvaN210PDEnstrom F-28F · S/N 805Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1996 · Fernandes Joaquim SN7233XCessna 150A · S/N 15059333Cancelled Nov 21, 2017 · Revoked, canceled · Built 1961 · 150th Aero Flying Club IncN401JDBeech D50C · S/N DH-272Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 1960 · Donato John FN7616CBeech C-45G · S/N 51-11491Cancelled Feb 4, 2017 · Revoked, canceled · Built 1951 · Belvon Aircraft Leasing IncN2511BPiper PA-38-112 · S/N 38-79A0098Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1978 · Bruce Alvin RN51951Hunting PEMBROKE MK 51 · S/N K66B-4003Cancelled Apr 1, 2013 · Registration expired, pending cancellation · Kennedy PaulN56469Cessna T-50 · S/N 4355Cancelled Sep 28, 2012 · Revoked, canceled · Built 1943 · Mercury Automatic Fire Alarm CoN4717Bensen GYROCOPTER · S/N B7M-627654Cancelled Aug 1, 2012 · Revoked, canceled · Coggins FrankN430CHBell 430 · S/N 49037Cancelled Mar 13, 2012 · Sale reported · Built 1998N23TLPiper PA-31-350 · S/N 31-8152172Cancelled Jul 30, 2010 · Triennial form not returned · Built 1981 · Central Jersey Airlines LLCN7736FCessna 150F · S/N 15063836Cancelled Nov 9, 2009 · Exported to Brazil · Built 1966 · Ratte FredericoN1717QCessna 150L · S/N 15073017Cancelled May 21, 2009 · Exported to Brazil · Built 1971 · Ratte FredericoN5322QCessna 150L · S/N 15073222Cancelled Apr 8, 2009 · Exported to Brazil · Built 1972 · Ratte FredericoN23WABeech 65-B80 · S/N LD345Cancelled Nov 17, 1993 · Exported to Argentina · Garavano MarioN8745CPiper PA-22 · S/N 22-1397Cancelled Oct 25, 1974 · Dolan Michael EN1524VDehavilland BEAVER DHC-2 · S/N 139Cancelled Nov 30, 1970 · The Babb Company IncN1525VDehavilland BEAVER DHC-2 · S/N 164Cancelled Nov 30, 1970 · The Babb Company IncN94583Aeronca 7BCM · S/N 7BCM-475Cancelled Aug 21, 1968 · Built 1956 · Civil Air PatrolN2741ALockheed 49E-46 · S/N 1971Cancelled Oct 7, 1965 · Modern Air Transport IncN1081HAeronca 15AC · S/N 15AC-100Cancelled May 18, 1965 · Rapant FredN3935CCurtiss Wright C-46A · S/N 27063Cancelled Dec 21, 1961 · Exported to Canada · Modern Air Transport IncN50549Curtiss Wright C-46 · S/N 30200Cancelled Oct 9, 1961 · Exported to Canada · Built 1951 · Modern Air Transport IncN3969CNorth American B-25J · S/N 108-35365Cancelled Apr 21, 1961 · Built 1954 · Babb Co IncN3970CNorth American B-25H · S/N 22000Cancelled Apr 21, 1961 · Built 1953 · Babb Co IncN3947CCurtiss Wright C-46 · S/N 33479Cancelled Mar 14, 1961 · Exported to Panama · Aviation Management CorpN21207Taylorcraft A · S/N 624Cancelled Jun 3, 1960 · Built 1938 · Essex County Vocational SchoolsN46448Piper J-3 · S/N 9059Cancelled Oct 25, 1957 · Exported · Bass Allan AN73823Commonwealth 185 · S/N 1828Cancelled Aug 28, 1956 · Mercury Automatic Fire Alarm CoN60623Fairchild M-62C · S/N 252SLCancelled Nov 15, 1955 · Damore Nathan JN64761Consolidated Vultee BT-13A · S/N 8476Cancelled Oct 25, 1955 · Built 1942 · Brick Frank R And Menges Kay AN69320Cessna T-50 · S/N 2602Cancelled Oct 25, 1955 · Built 1943 · Caullett WarrenN9029EAeronca 11AC · S/N 11AC-660Cancelled Oct 17, 1955 · Built 1946 · Berman Irving JN28388North American P-51B · S/N 25789Cancelled May 13, 1955 · Built 1944 · Cochran Jacquelin DBA Jacquelin Cochran CosmeticsN1551VFairchild PT-26A · S/N EW-376 (T43-4435)Cancelled May 3, 1955 · The Babb Company IncN46719Fairchild M-62A · S/N T43-5875Cancelled Mar 31, 1955 · Stephan John EdwinN9978FFairchild PT-26B · S/N FZ338Cancelled Mar 30, 1954 · Exported to Morocco · Babb Company IncN2118EAeronca 7AC · S/N 7AC-5689Cancelled Jul 22, 1953 · Erwin Douglas RN1581VDehavilland DHC-2 · S/N 172Cancelled Jan 13, 1953 · Babb Co IncN1550VDehavilland BEAVER DHC-2 · S/N 385Cancelled Dec 17, 1952 · Exported to Vietnam · Babb Co IncN3963CDouglas C-47 · S/N 9041Cancelled Sep 24, 1952 · Exported to Canada · Built 1952 · Babb Co IncN1546VNorth American/Victoria MNT LT AT-6A · S/N 786433Cancelled Apr 24, 1952 · Babb Co IncN1542MBoeing B-17F · S/N 6332Cancelled Jun 21, 1951 · Exported to Bolivia · National Aircraft Maintenance Corp
Back to Newark, NJ