Cancelled registrations · 20

Query with SQL

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 = 'RIDGEFIELD PARK' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'RIDGEFIELD PARK'
  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.

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 = 'RIDGEFIELD PARK'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N1554APiper PA-20 · S/N 20-754Cancelled May 27, 2023 · Revoked, canceled · Built 1951 · Mellor Howard Seaplane Base N4735MPiper PA-11 · S/N 11-252Cancelled Jan 10, 2020 · Revoked, canceled · Built 1947 · Air Svc Mellor Howard N3324BPiper PA-22-135 · S/N 22-2139Cancelled Nov 29, 2019 · Revoked, canceled · Built 1954 · Air Svc Mellor Howard N92693Piper J3C-65 · S/N 17034Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Mellor-Howard Seaplane & Ase N60076Cessna 150J · S/N 15070057Cancelled Mar 2, 2019 · Sale reported, canceled · Built 1968 N2362TNavion NAVION G · S/N NAV-4-2362Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1961 · Island Airways N6111HPiper J-3 · S/N 19261Cancelled Aug 5, 2013 · Revoked, canceled · Built 1946 · Air Svc Mellor Howard N8617BEnstrom F-28F · S/N 700Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1981 · Spectrum Helicopters Inc N5662YPiper PA-23-250 · S/N 27-2778Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1965 · Interair Leasing Systems Inc N51721Enstrom Helicopter 280C · S/N 1127Cancelled Apr 1, 2013 · Registration expired, pending cancellation · Built 1978 · Spectrum Helicopters Inc N5328XCessna U206G · S/N U20605647Cancelled Nov 21, 1983 · Amw Corporation N5120KCessna 172N · S/N 17273976Cancelled Nov 17, 1983 · Built 1980 · A M W Corporation N86623Grumman G-44A · S/N 1449Cancelled Mar 20, 1956 · Lambros Sealane Base N97881Stinson 108-1 · S/N 108-881Cancelled Oct 17, 1955 · Built 1946 · Mellor-Howard Flying School N6221KRepublic RC-3 · S/N 424Cancelled Jun 23, 1953 · Mellor Alfhild N9425EAeronca 11AC · S/N 11AC-1061Cancelled Oct 31, 1952 · Exported to Canada · Built 1946 · Alfhild Mellor N5558HPiper PA-11 · S/N 11-1071Cancelled Feb 19, 1952 · Exported to Canada · Mellor Alfhild N6135KRepublic RC-3 · S/N 321Cancelled Nov 1, 1950 · Mellor-Howard Seaplane Base N4368MPiper PA-12 · S/N 12-3305Cancelled Jul 16, 1948 · Ahrendt Herbert N465MDetroit SEA ROVER E-2 · S/N 9Cancelled Aug 22, 1936 · Built 1931 · Wyss Hubert Charles

Back to Ridgefield Park, NJ