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

N95HBBarr Harry DR 107 · S/N ABJD-32Cancelled Jan 23, 2025 · Exported to Lithuania · Built 1998 · Max Aviation LLC N1054SPiper PA-32R-301T · S/N 3257448Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 2007 · Faherty Richard L N97285Stinson 108 · S/N 108-285Cancelled Dec 17, 2018 · Revoked, canceled · Built 1946 · Pinkham Richard E N551TRDJI PHANTOM 2 · S/N PH645149431Cancelled May 30, 2018 · Sale reported, canceled N51983Piper J3C-65 · S/N 9699Cancelled May 18, 2018 · Revoked, canceled · Built 1942 · Teterboro Flying Club Inc N9014NHughes 269A · S/N 94-0316Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1964 · Kurtis Air Inc N80599Ewing B-8M · S/N E-1Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Strenz Robert A N26111Hall B-8M · S/N 1913Cancelled Jun 5, 2013 · Sale reported, canceled · Built 1976 N60236Cessna T-50 · S/N 5129Cancelled Aug 30, 2012 · Revoked, canceled · Built 1945 · Pinkham Richard E N925JSDiamond Aircraft Ind DA20-A1 · S/N 10280Cancelled May 6, 2004 · Exported to Germany · Built 1997 · Jbs Aircraft Leasing Six LLC N1251PPiper PA-23-150 · S/N 23-277Cancelled May 16, 1974 · Essex Aviation Co Inc N90091Cessna 140 · S/N 9152Cancelled Nov 28, 1972 · Lowry Peter B N3015VBeech 35 · S/N D-417Cancelled May 31, 1956 · Richard T Bethell N193ENew Standard D-25 · S/N 102Cancelled Mar 15, 1939 · Miller A K N7451Eaglerock A-2 · S/N 618Cancelled Feb 1, 1939 · A K Miller N868WAeromarine-Klemm L-26-B · S/N 3-82Cancelled May 1, 1936 · Miller A K N7283Atlantic FOKKER EXPERIMENTAL · S/N 1300Cancelled Feb 1, 1936 · Built 1928 · Miller A K N863YHageman Edwin POWERED GLIDER · S/N 7Cancelled Feb 8, 1933 · Built 1930 · Hageman Edwin N843WJoseph Wallace WALLACE W-1 · S/N 131Cancelled Feb 6, 1933 · Wallace Joseph N9102New Standard D-24 · S/N 112Cancelled Mar 28, 1930 · Built 1929 · Aircrafters Inc

Back to Montclair, NJ