Skip to content

Cancelled registrations · 82

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 = 'NY' AND d.registrant_city = 'ALBANY' 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 = 'NY' AND d.registrant_city = 'ALBANY'
  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 = 'NY' AND d.registrant_city = 'ALBANY'
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.

N46WWGoodemote Arthur O GOODEMOTE BLUEBIRD · S/N 2Cancelled Sep 29, 2026 · Registration pending, canceled · Built 2009 N8678BCessna 172 · S/N 36378Cancelled Sep 1, 2026 · Registration pending, canceled N27796Stinson 10A · S/N 7744Cancelled Jul 8, 2023 · Revoked, pending cancellation · Built 1940 · Dreisenstock William N5821BBusko George KR-2 · S/N 1Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1987 · Long Arthur N8260FSig Mfg LT-40 TRAINER · S/N LT40 RC-67Cancelled Apr 5, 2021 · Registration expired, pending cancellation · Pazienza Francis C N697UAPrecisionhawk HAWKEYE MKIII LANCAS · S/N PCN-048-201548-045-MSICancelled Nov 20, 2019 · First renewal notice · Research Foundation For The State Univ Of New York N570GPDJI PHANTOM 3 PROFESSION · S/N P76DCG20016012Cancelled Apr 30, 2019 · Registration expired, pending cancellation · Greenman Pedersen Inc N552BADJI PHANTOM 2 VISION + · S/N PH645475918Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Greenman Pedersen Inc N2214EAeronca 7AC · S/N 7AC5788Cancelled May 18, 2018 · Revoked, canceled · Built 1946 · Mead Harold D N505MBBeaver M H GLASAIR II RG · S/N 1044Cancelled May 8, 2015 · Registration expired, pending cancellation · Built 1990 · Pennypacker II LLC N5219BMooney M20 · S/N 1082Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1956 · Systems Design N6571CDouglas DC-8-21 · S/N 45391Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1960 · Union National Bank N43560Taylorcraft BCS12-D · S/N 7219Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1946 N9910CLuscombe 8F · S/N S-13Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1959 · Tallent Charles H N1876BLuscombe 8F · S/N 6303Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Tallent Charles H N66905Beech F33A · S/N CE-893Cancelled Jun 13, 2013 · Sale reported, canceled · Built 1979 N8513KUniversal Stinson 108-1 · S/N 108-1513Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1947 · Perry Paul M N6646BCessna 310B · S/N 35746Cancelled May 8, 2013 · Sale reported, pending cancellation · Built 1958 N686KBeech 65 · S/N LC-154Cancelled May 1, 2013 · Sale reported, pending cancellation · Built 1963 N49VFleet 8 · S/N 803Cancelled Apr 8, 2013 · Built 1931 · New York State Education Department N2842ACessna 180 · S/N 30042Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Built 1953 · Dyer Larry A N2279PPiper PA-23 · S/N 23-890Cancelled Mar 14, 2011 · Expired dealer · Built 1957 · Shield Aviation Inc N321ADBeech 77 · S/N WA-108Cancelled Dec 1, 2009 · Exported to Canada · Built 1980 · Townsend Michael S DBA N430PCessna 182T · S/N 18280973Cancelled Sep 17, 2007 · Exported to Canada · Built 2001 · Ourplane Corp N9075RCessna TR182 · S/N R18200661Cancelled Apr 3, 2006 · Exported to New Zealand · Built 1978 · Upper Fifteen Inc N37233Cessna 310R · S/N 310R0967Cancelled Feb 3, 2003 · Second triennial mailing, no response · Built 1977 · Mer Leasing Corporation N607FDiamond Aircraft Ind DA20-A1 · S/N 10027Cancelled Sep 13, 2001 · Exported to Canada · Townsend Michael N605FDiamond Aircraft Ind DA20-A1 · S/N 10018Cancelled Aug 31, 2001 · Exported to Canada · Townsend Michael N60393Grumman TBM-3E · S/N 53842Cancelled Mar 21, 1995 · Triennial form not returned · State Of New York N6105ECessna 172 · S/N 46205Cancelled Dec 28, 1994 · Triennial form not returned · Condon Perry DBA N55EABell Helicopter Textron 206L-1 · S/N 45588Cancelled Dec 27, 1990 · Exported to Ecuador · Barry Bette And Led Duke N63334Cessna 150M · S/N 15077243Cancelled Dec 6, 1983 · Research Foundation Of State University Of N Y N4031XAero Commander 100-180 · S/N 5131Cancelled Aug 23, 1983 · Built 1969 · Hoeltzel Harry E N7JGGilmore James R 3D-2 · S/N 1Cancelled Apr 17, 1980 · Gilmore James R N9990DPiper PA-22-160 · S/N 22-6782Cancelled Jun 18, 1979 · Exported to Canada · Gillis William A N4723GSmith Miniplane DSA-1 · S/N WB001Cancelled Jul 7, 1977 · Built 1968 · Wielt Royal N5665XRockwell International S-2R · S/N 1865RCancelled Feb 1, 1974 · Exported to Mozambique · Rockwell International N1736VCessna 140 · S/N 13921Cancelled Sep 13, 1973 · Built 1947 · Slatcher James R N2422NCessna 120 · S/N 12671Cancelled Sep 8, 1972 · Exported to Canada · Built 1947 · Dubuque Lewis A N31567Stinson 10A · S/N 7816Cancelled Jul 26, 1971 · Exported to Canada · Williams Arthur G N60059Consolidated Vultee BT-15 · S/N 10777Cancelled Aug 18, 1970 · Connor Thomas H O N72161Cessna 140 · S/N 9328Cancelled May 22, 1965 · Tullis David N7323BBeech E35 · S/N D-3786Cancelled May 21, 1965 · New York State Department Of Commerce N40665Piper J3C-65 · S/N 7424Cancelled Jan 27, 1960 · Exported to Canada · Gervais Thelma H N600Dehavilland DHC-3 · S/N 256Cancelled Nov 25, 1959 · State Of New York Conservation Department N36567Aeronca S-65-CA · S/N CA16731Cancelled Feb 27, 1956 · Pasquini Angelo N N87495Republic RC-3 · S/N 47Cancelled Feb 24, 1956 · Oconnor Aircraft Co N54857North American AT-6A · S/N 78-6456Cancelled Jan 12, 1954 · Rapple Kenneth N9123HNorth American AT-6A · S/N 78-6118Cancelled Nov 5, 1953 · Rapple Aircraft Sales N2655KLuscombe 8E · S/N 5382Cancelled Jun 15, 1953 · Exported to Canada · Stephens Thomas G

Back to Albany, NY