OpenAirDocs.org
Linden, NJ

Cancelled registrations · 159

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

N68100Beech AT-11 · S/N 4549Cancelled Aug 28, 2018 · Revoked, canceled · Built 1942 · Trade Ayer IncN5846WPiper PA-28-160 · S/N 28-2271Cancelled Apr 2, 2018 · Registration expired, pending cancellation · Built 1965 · Jorges John AN407EPBell 407 · S/N 53116Cancelled Mar 19, 2018 · Exported to Canada · Built 1997 · Ttm CorpN392ESCessna 172R · S/N 17280132Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1997 · Richmond Pilots CorpN63QBell 206B · S/N 2063Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1976 · Dudley Paul PN65428North American SNJ-5 · S/N 787290Cancelled Nov 22, 2017 · Revoked, pending cancellation · Built 1942 · Trade Ayer CoN9494HNorth American SNJ-5 · S/N 787405Cancelled Nov 21, 2017 · Revoked, canceled · Built 1942 · Trade Ayer CoN52924North American SNJ-5 · S/N 8811814Cancelled Nov 20, 2017 · Revoked, canceled · Built 1946 · Trade Ayer CoN877EZRichter MODEL-I · S/N 877Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Richter David BN453AEEurocopter EC 130 B4 · S/N 3487Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 2001 · Meridian Consulting Co IncN738MXCessna 172N · S/N 17270094Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1977 · Mistral Aviation IncN401LHEurocopter AS 350 BA · S/N 3059Cancelled Aug 13, 2013 · Third renewal notice · Built 1997 · Meridian Consulting I Corp IncN87285Cessna 402B · S/N 402B1100Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1976 · Linden Flight Service IncN6ZVBell 206-L4 · S/N 52046Cancelled Jul 17, 2013 · Registration expired · Built 1993 · Air Sansone LLCN7215MCessna 175 · S/N 55515Cancelled May 6, 2013 · Registration expired, pending cancellation · Built 1958 · Howard Precision IncN49568Cessna 152 · S/N 15281313Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Built 1978 · Linden Flight Service IncN5555ASikorsky S-51 · S/N 122522Cancelled Aug 23, 2012 · Revoked, canceled · Built 1957 · Ming Ayer IncN614CLAerospatiale AS 355F2 · S/N 5614Cancelled Mar 12, 2012 · Exported to Hungary · Built 1997 · Ancad Services LLCN6964SCessna 150H · S/N 15067664Cancelled Dec 12, 2008 · Triennial form not returned · Built 1967 · Linden Air ServicesN120LHEurocopter EC120B · S/N 1052Cancelled Apr 12, 2007 · Exported to Russia · Built 1999 · Air Pegasus Enterprises IncN444LHEurocopter AS 350 BA · S/N 3001Cancelled Jul 3, 2002 · Exported to Ecuador · Built 1997 · Meridian Consulting Co IncN355DSAerospatiale AS355F TWINSTAR · S/N 5110Cancelled Mar 3, 1999 · Exported to Canada · Meridian Consulting Co IncN17023Cessna 150L · S/N 15073589Cancelled Apr 30, 1993 · Linden Air Services CoN999TNavion NAVION A · S/N NAV41670Cancelled Apr 23, 1983 · Administratively canceled · Bochenek George SN93207Martin 202A · S/N 14077Cancelled Jul 8, 1981 · Built 1950 · Associated Products Of America IncN400USDouglas DC-7 · S/N 45358Cancelled Nov 15, 1977 · Apa Services IncN402USDouglas DC-7 · S/N 45485Cancelled Nov 15, 1977 · Apa Services IncN403USDouglas DC-7 · S/N 44904Cancelled Nov 15, 1977 · Apa Services IncN1382UCessna 172M · S/N 17267053Cancelled Dec 27, 1976 · Linden Flight Service IncN7162QCessna 172L · S/N 17260462Cancelled Feb 7, 1975 · Linden Flight Service IncN4101PPiper PA-23-160 · S/N 23-1581Cancelled Aug 2, 1974 · Built 1959 · Ritchey James V IIIN1985QCessna 177RG · S/N 177RG0385Cancelled Apr 12, 1974 · Linden Flight Service IncN2931LMooney M20F · S/N 670325Cancelled Jan 30, 1974 · Exported to Germany · Metropolitan Airmotive IncN4145ASikorsky S-51 · S/N 5154Cancelled Jan 14, 1974 · Built 1956 · Ming-Ayer IncN7310NDornier DO 27 Q-4 · S/N 499Cancelled Feb 8, 1973 · Exported to Germany · Metropolitan Airmotive IncN74185Dornier DO 27 A5 · S/N 380Cancelled Dec 11, 1972 · Metropolitan Airmotive IncN9182XDornier DO28 B-1 · S/N 3087Cancelled Aug 22, 1972 · Exported to Israel · Metropolitan Airmotive IncN9454Dornier-Werke DO 27 A · S/N 474Cancelled Jul 18, 1972 · Exported to Israel · Built 1970 · Metropolitan Airmotive IncN9456Dornier-Werke DO 27 A · S/N 475Cancelled Jul 18, 1972 · Exported to Israel · Built 1970 · Metropolitan Airmotive IncN10025Sikorsky YH 5-A · S/N SS165Cancelled Mar 8, 1972 · Trade Ayer IncN60942Cessna 150J · S/N 15070683Cancelled Feb 23, 1972 · Linden Flight Service IncN5943Dornier DO-27 Q1 · S/N 109Cancelled Aug 10, 1971 · Exported to Israel · Metropolitan Airmotive IncN5944Dornier DO-27 Q1 · S/N 167Cancelled Aug 10, 1971 · Exported to Israel · Metropolitan Airmotive IncN5945Dornier DO 27 · S/N 184Cancelled Aug 10, 1971 · Exported to Israel · Metropolitan Airmotive IncN9535Dornier DO-27 Q1 · S/N 178Cancelled Jul 20, 1971 · Exported to Israel · Metropolitan Airmotive IncN9537Dornier DO-27 Q1 · S/N 219Cancelled Jul 16, 1971 · Exported to Israel · Metropolitan Airmotive IncN9538Dornier DO 27 · S/N 325Cancelled Jul 12, 1971 · Exported to Israel · Metropolitan Airmotive IncN9533Dornier DO 27 · S/N 126Cancelled Jun 14, 1971 · Exported to Israel · Built 1971 · Metropolitan Airmotive IncN9534Dornier DO 27 · S/N 147Cancelled Jun 14, 1971 · Exported to Israel · Metropolitan Airmotive IncN9532Dornier DO 27 · S/N 125Cancelled May 27, 1971 · Exported to Israel · Metropolition Airmotive Inc
Back to Linden, NJ