Cancelled registrations · 28

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

N59ZABell 206-L4 · S/N 52348Cancelled Oct 27, 2026 · Exported to South Africa · Built 2007 · 59za LLC N9459BCessna 175 · S/N 55259Cancelled Jun 24, 2026 · Registration pending, canceled · Built 1958 N2854LLester Lydzinski NW-FREEDOM · S/N 122EF51076414Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Built 2016 · Lydzinski Lester N7299SCessna 150H · S/N 15067999Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1967 · Von Bargen Daniel J N274EEaa Biplane BIPLANE · S/N GHS-01Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1964 · Sollart George H N65792Beech A36 · S/N E-2066Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1983 N5320QCessna U206F · S/N U20603062Cancelled Jul 15, 2013 · Sale reported, canceled · Built 1975 N6707WPiper PA-28-140 · S/N 28-20818Cancelled Jul 1, 2013 · Revoked, pending cancellation · Built 1965 · Dimartino Concetta N74RBeech AT-11 · S/N 1461Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1942 · Lopez Joseph N4249PPiper PA-23-160 · S/N 23-1748Cancelled Sep 14, 2012 · Revoked, canceled · Built 1959 · Vierling Anton N3369UCessna 182F · S/N 18254769Cancelled Sep 12, 2012 · Sale reported, canceled · Built 1963 N121SACessna 402 · S/N 402-0035Cancelled Jun 7, 2012 · Sale reported, canceled · Built 1967 N962ATBeech 65-A90 · S/N LJ-207Cancelled Mar 13, 2003 · Triennial form not returned · Built 1966 · Metroair Inc N17906Schweizer SGS 1-26E · S/N 526Cancelled Aug 11, 1997 · Triennial form not returned · Circkot Michael N30SGSwearingen SA26-T · S/N T2628Cancelled Mar 14, 1991 · Triennial form not returned · Metroair Inc N1ZWBeech 95-B55 (T42A) · S/N TC-1744Cancelled Apr 24, 1980 · Administratively canceled · Stroudsburg Pocono Airport Inc N101ABBeech 35-B33 · S/N CD629Cancelled Nov 4, 1975 · Kipikasha Frank E N4843LPiper PA-28-180 · S/N 28-4189Cancelled Sep 9, 1975 · Sale reported · Built 1967 N3797ABeech F33A · S/N CE-291Cancelled Aug 8, 1975 · Exported to Belgium · Built 1970 · Belair International Inc N6054QMooney M20C · S/N 3245Cancelled Aug 24, 1970 · Bennett Earl S N3062DCessna 310 · S/N 35262Cancelled May 1, 1958 · Petruska Michael N9392HExel George 100 · S/N 4Cancelled Jul 12, 1956 · Built 1947 · Exel George N51981Cessna T-50 · S/N 4829Cancelled May 5, 1950 · Sky Fresh Food Company N2473KLuscombe 8E · S/N 5200Cancelled Jul 5, 1949 · Vihl Bernard N53044Fairchild M-62A · S/N T42-3940Cancelled Mar 1, 1949 · Built 1945 · Barton Jesse Joseph N173MNew Standard STANDARD D-29A · S/N 1020Cancelled May 15, 1941 · Century Of Progress Flying Club Inc N13279John Wodziak WODZIAK-HEATH · S/N 1Cancelled Feb 1, 1935 · John Wodziak N81912Bensen B8M · S/N 1002Cancellation date not recorded · Reh John G

Back to Clifton, NJ