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.

N8505Hiller UH-12B · S/N 733Cancelled May 20, 1971 · Exported to Italy · Metropolitan Airmotive IncN8936Dornier DO28 B-1 · S/N 3115Cancelled Apr 12, 1971 · Exported to Israel · Metropolitan Airmotive IncN8930Dornier DO28 B-1 · S/N 3102Cancelled Apr 9, 1971 · Exported to Israel · Metropolitan Airmotive IncN8932Dornier DO28 B-1 · S/N 3107Cancelled Apr 9, 1971 · Exported to Israel · Metropolitan Airmotive IncN9536Dornier DO-27 Q1 · S/N 204Cancelled Apr 7, 1971 · Exported to Israel · Metropolitan Airmotive IncN8933Dornier DO28 B-1 · S/N 3113Cancelled Mar 24, 1971 · Metropolitan Airmotive IncN8935Dornier DO28 B-1 · S/N 3114Cancelled Mar 24, 1971 · Metropolitan Airmotive IncN60933North American AT-6 · S/N 88-9402Cancelled Mar 2, 1971 · Trade-Ayer CoN60817North American AT-6 · S/N 59-1920Cancelled Feb 3, 1971 · Trade-Ayer CompanyN60864North American AT-6 · S/N 77-4524Cancelled Feb 3, 1971 · Trade-Ayer CoN60381North American SNJ-4 · S/N 88-11693Cancelled Jan 29, 1971 · Trade-Ayer CoN5553ASikorsky S-51 · S/N 122721Cancelled Jan 27, 1971 · Ming Ayer IncN5556ASikorsky S-51 · S/N 123139Cancelled Jan 27, 1971 · Ming Ayer IncN5557ASikorsky S-51 · S/N 124350Cancelled Jan 27, 1971 · Ming Ayer IncN58271North American SNJ-4 · S/N 88-9445Cancelled Jan 27, 1971 · Trade Ayer CoN52980Cessna T-50 · S/N 3626Cancelled Jan 22, 1971 · Gordon Ayer IncN4139ANorth American SNJ-4 · S/N 88-13624Cancelled Jan 15, 1971 · Ming AyerN4143ASikorsky S-51 · S/N 5124Cancelled Jan 15, 1971 · Built 1956 · Ming-Ayer IncN41827North American SNJ-4 · S/N 88-9438Cancelled Jan 12, 1971 · Trade Ayer IncN6302CDouglas DC-7 · S/N 44266Cancelled Sep 3, 1970 · Apa Services IncN52893North American SNJ-4 · S/N 88-11434Cancelled Sep 1, 1970 · Built 1942 · Trade Ayer CoN5554ASikorsky S-51 · S/N 122526Cancelled Sep 1, 1970 · Ming Ayer IncN6636DLockheed PV-2 · S/N 37480Cancelled Aug 19, 1970 · Trade Ayer IncN6647DLockheed PV-2 · S/N 37522Cancelled Aug 19, 1970 · Trade Ayer IncN6611DLockheed PV-2 · S/N 151190Cancelled Aug 18, 1970 · Ming Ayer IncN6617DLockheed PV-2 · S/N 37158Cancelled Aug 18, 1970 · Trade Ayer IncN8323Dornier DO-27 Q1 · S/N 2015Cancelled Aug 18, 1970 · Metropolitan Airmotive IncN4146DHelio H-391B · S/N 082Cancelled Jun 17, 1970 · Linden Flight Service IncN61274Cessna 150J · S/N 150-70935Cancelled Oct 23, 1969 · Linden Flight Service IncN10019Consolidated Vultee PBY-5A · S/N 48335Cancelled Nov 8, 1963 · Trade-Ayer IncN7430CLockheed PV-2 · S/N 151313Cancelled Dec 11, 1962 · Ming-Ayer IncN7433CLockheed PV-2 · S/N 151411Cancelled Dec 11, 1962 · Ming-Ayer IncN6603DLockheed PV-2 · S/N 151222Cancelled Nov 14, 1962 · Ming-Air IncN6606DLockheed PV-2 · S/N 151115Cancelled Nov 14, 1962 · Ming-Ayer IncN6607DLockheed PV-2 · S/N 151129Cancelled Nov 14, 1962 · Ming-Ayer IncN6608DLockheed PV-2 · S/N 151141Cancelled Nov 14, 1962 · Ming-Ayer IncN6609DLockheed PV-2 · S/N 151173Cancelled Nov 14, 1962 · Ming-Ayer IncN6613DLockheed PV-2 · S/N 151495Cancelled Nov 14, 1962 · Ming-Ayer IncN6625DLockheed PV-2 · S/N 37345Cancelled Nov 14, 1962 · Trade-Ayer IncN6626DLockheed PV-2 · S/N 37353Cancelled Nov 14, 1962 · Trade-Ayer IncN6627DLockheed PV-2 · S/N 37388Cancelled Nov 14, 1962 · Trade-Ayers IncN6628DLockheed PV-2 · S/N 37391Cancelled Nov 14, 1962 · Trade-Ayers IncN6630DLockheed PV-2 · S/N 37533Cancelled Nov 14, 1962 · Trade-Ayer IncN6642DLockheed PV-2 · S/N 37506Cancelled Nov 14, 1962 · Trade Ayer IncN6645DLockheed PV-2 · S/N 37517Cancelled Nov 14, 1962 · Trade Ayer IncN6646DLockheed PV-2 · S/N 37521Cancelled Nov 14, 1962 · Trade Ayer IncN6650DLockheed PV-2 · S/N 37534Cancelled Nov 14, 1962 · Trade Ayer IncN6652DLockheed PV-2 · S/N 37541Cancelled Nov 14, 1962 · Trade Ayer IncN6653DLockheed PV-2 · S/N 37545Cancelled Nov 14, 1962 · Trade Ayer IncN6654DLockheed PV-2 · S/N 37627Cancelled Nov 14, 1962 · Trade Ayer Inc
Back to Linden, NJ