Cancelled registrations · 26

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

N17879Schweizer SGS 2-33A · S/N 249Cancelled Dec 3, 2022 · Built 1972 · Jersey Ridge Soaring LLC N828GCDJI MAVIC PRO · S/N O8QDE150120395Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Cuppek Joshua A N7463CDJI PHANTOM 3 PROFESSION · S/N P76DCI22A27079Cancelled Jun 14, 2019 · First renewal notice · Cuppek Joshua A N3872ASchweizer SGS 1-26A · S/N 14Cancelled Mar 2, 2019 · Registration expired, pending cancellation · Built 1955 · Leal Paul J N1510Schleicher K 6 CR · S/N 6585Cancelled Feb 9, 2019 · Registration expired, pending cancellation · Leal Paul J N6121SAir & Space America 18A · S/N 1827Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1965 · Kd Helicopters Inc N10087Cessna 150L · S/N 15074783Cancelled Mar 15, 2011 · Exported to Argentina · Built 1973 · Aero Ventures LLC N5527QCessna 152 · S/N 15285116Cancelled Nov 1, 2010 · Exported to Poland · Built 1981 · Aero Ventures LLC N4285LCessna 172G · S/N 17254354Cancelled Jan 19, 2010 · Exported to Spain · Built 1966 · Aero Ventures LLC N9GSSmith BABY GREAT LAKES · S/N J-282BCancelled Oct 31, 2006 · Triennial form not returned · Built 1975 · Poster John T N19024Cessna 150L · S/N 15074102Cancelled Jan 25, 2006 · Exported to Poland · Built 1972 · Kd Helicopters Inc N350BBI.C.A.-Brasov IS-28B2 · S/N 103Cancelled Jul 25, 2005 · Second triennial mailing, no response · Built 1977 · Aero Club Albatross Inc N3618TSchweizer SGS 1-36 · S/N 15Cancelled Jul 25, 2005 · Second triennial mailing, no response · Built 1981 · Aero Club Albatross Inc N8216QI.C.A.-Brasov IS-28B2 · S/N 360Cancelled Jul 25, 2005 · Built 1995 · Aero Club Albatross Inc N97VTI.C.A.-Brasov IS-28B2 · S/N 104Cancelled Jul 25, 2005 · Triennial form not returned · Built 1977 · Aero Club Albatross N70CMCessna 310N · S/N 310N-0126Cancelled May 24, 2000 · North Warren Aviation Inc N120BGSchleicher ASW-20C · S/N 20798Cancelled Jun 23, 1999 · Exported to Canada · Leslie Gregg T N339CBritish Aerospace HS-748-2A · S/N 1720Cancelled Sep 25, 1997 · Exported to Australia · S & H Aircraft Sales Inc N2253JCessna 150G · S/N 15065453Cancelled Aug 9, 1974 · Okeefe Aviation Service N84698Aeronca 7AC · S/N 7AC-3411Cancelled Apr 25, 1969 · Exported to Canada · Blair Air Inc N39459Stinson 10A · S/N 8259Cancelled May 7, 1957 · Built 1942 · Rusweiler A G N17303Ryan Aeronautical ST-A SPECIAL · S/N 137Cancelled Sep 24, 1952 · Built 1936 · Zenock Raymond N6997KPiper PA-20 · S/N 20-103Cancelled Nov 8, 1951 · Smith Kenneth N1733EAeronca 7AC · S/N 7AC-5300Cancelled Jul 11, 1950 · Built 1946 · Aviation Schools And Servicesinc N2650Waco 9 · S/N 323Cancelled Jul 15, 1939 · Built 1926 · Noe Gordon N60430Cessna 150J · S/N 15070300Cancellation date not recorded · Airstown Aero Service Inc

Back to Blairstown, NJ