Skip to content

Cancelled registrations · 68

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 = 'CA' AND d.registrant_city = 'TEHACHAPI' 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 = 'CA' AND d.registrant_city = 'TEHACHAPI'
  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 = 'CA' AND d.registrant_city = 'TEHACHAPI'
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.

N1583PPiper PA-22-150 · S/N 22-2577Cancelled Dec 6, 2025 · Sale reported, canceled · Built 1955 N7363KPiper PA-20 · S/N 20-271Cancelled Dec 21, 2024 · Sale reported, canceled N2819HErcoupe 415-D · S/N 3444Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 1946 · Sandy George T N2344BGlobe GC-1B · S/N 3644Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1948 · Samuelian Stephen P N199AKHill Brad APIS WR · S/N 01Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 2002 · Kreigh Inc N17KSSchleicher ASW-20B · S/N 20621Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Russette Patrick M N46724Cessna 172K · S/N 17257454Cancelled May 9, 2022 · Registration expired, pending cancellation · Built 1968 · Coleman Charles T N364CSSkovgard Charles RP JDT V-MAX · S/N MK-788Cancelled Jul 17, 2021 · Sale reported, canceled · Built 2008 N600UFBloomquist David BLOOMQUIST 2000GTXSE · S/N H2 03 14 600Cancelled Jun 5, 2021 · Sale reported, canceled · Built 2004 N26LWAB Sportine Aviacija GENESIS 2 · S/N 2026Cancelled May 17, 2021 · Exported to Australia · Built 2001 · Kuhar William T N385MUUrbanczyk Miroslaw RADIO FLYER · S/N 01Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 2009 · Nunamaker Charles N7820Monocoupe 70 · S/N 132Cancelled May 2, 2020 · Registration expired, pending cancellation · Built 1975 · Hetge Kenneth R N589XQ3D Robotics SOLO · S/N S111A5606971Cancelled Apr 19, 2019 · Registration expired, pending cancellation · Betkar Brian James N168WMGulfstream Aerospace G-IV · S/N 1002Cancelled Apr 17, 2019 · Expired dealer · Built 1986 · Jet Crew Services LLC N3604ZPiper PA-22-150 · S/N 22-7492Cancelled Nov 6, 2018 · Sale reported, canceled N2422Beech D17S · S/N 304Cancelled Jul 19, 2018 · Registration expired, pending cancellation · Built 1939 · Meyer Robert R Jr Trustee N7740KPiper PA-20 · S/N 20-563Cancelled May 31, 2018 · Sale reported, canceled · Built 1950 N331AAllen THORP T-18 · S/N 331Cancelled May 30, 2018 · Sale reported, canceled · Built 1975 N122FRCessna 172N · S/N 17273927Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Built 1980 · Excell Aviation Inc N22833Piper J3C-65 · S/N 2755Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Built 1939 · Oquinn Russell P N330GPKmak Andrew S ANTARES MA-33 · S/N GP01Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Kmak Andrew S N5129RCessna 172M · S/N 17263346Cancelled Sep 18, 2017 · Registration expired, pending cancellation · Built 1974 · Davis Gordon A N62VRDodd Lee P JR RV-4 · S/N 1051Cancelled Jun 20, 2017 · Registration expired, pending cancellation · Built 2002 · Dodd Lee P Jr N9592VCessna 172M · S/N 17264394Cancelled Dec 9, 2016 · Exported to Philippines · Built 1974 · Stripe Joseph R N205JMJonathan P Marion LOEHLE SPORT PARASOL · S/N SP-01JMCancelled Oct 13, 2016 · Marion Jonathan P N3124NCessna 120 · S/N 13382Cancelled Mar 5, 2016 · Built 1947 · Markle-Allen Inigo G N242LSSchreck Loren R AVENTURA II · S/N AP2A0096Cancelled Dec 2, 2015 · Built 2001 · Icon Aircraft Inc N505GWLynch Gregory R BLUE MORPHO · S/N B128Cancelled Jul 1, 2015 · Lynch Gregory R N30RTSchweizer SGS 1-26A · S/N 30Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1956 · Kennard James B N2414BTemco GC-1B · S/N 3714Cancelled May 8, 2015 · Registration expired, pending cancellation · Built 1949 · Potter Ritchie R N851LTTrusty THORP T-18 · S/N 851Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1974 · Trlica Lee G N37686Fechtner Joseph M KR-2 · S/N J/E-727779Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Robins David M N2VHHammock EAA BIPLANE P-2 · S/N 3Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1975 · Newman John Morgan N251JMCessna 172K · S/N 17259188Cancelled Feb 24, 2014 · First renewal notice · Built 1970 · Novinger George W Trustee N271JBJonathan Barraclough MANTA 503 · S/N JB503-001Cancelled Nov 4, 2013 · Exported to Canada · Barraclough Jonathan N74209Bellanca 14-13 · S/N 1322Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1946 · Martin Ronald P N211APPitts Andrew BG 12 BD · S/N 211Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1983 · Pitts Carl Andrew N123ZUGrigsby BJ-1B · S/N 120Cancelled Apr 23, 2013 · Sale reported, pending cancellation · Built 1977 N4997TCessna 411 · S/N 411-0197Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Built 1966 · Gold Coast Services N377CHStinson 108-1 · S/N 108-1562Cancelled Nov 9, 2012 · Registration expired, pending cancellation · Built 1947 · Dahle Lee Ann N100FKKimmel Fred KOLB MARK II · S/N 1Cancelled Aug 24, 2012 · Registration expired, pending cancellation · Built 1989 · Freedom Express Co N8468ABeech A35 · S/N D-1886Cancelled Jul 24, 2012 · Registration pending, canceled · Built 1948 N97869Aerovodochody L-29 DELFIN · S/N 2847Cancelled Sep 19, 2011 · Triennial form not returned · Built 1968 · Zweigle David L N3829ASchweizer SGS 1-26A · S/N 96Cancelled Jan 19, 2010 · Triennial form not returned · Built 1959 · Cant Charles Ian Hamilton N6319Phillips Ronald R HUMMELBIRD · S/N 61336Cancelled Apr 16, 2009 · Sale reported N3128VCessna 150M · S/N 15076393Cancelled May 9, 2008 · Exported to Philippines · Built 1974 · Zebro Dale J N250KBBetchan Don KR II · S/N D-002Cancelled Aug 11, 2007 · Triennial form not returned · Built 1988 · Engineering & Design N300NWAkro Tech GILES G-300 · S/N G-3001Cancelled Apr 12, 2007 · Triennial form not returned · Built 1997 · Meyer Robert R Jr N5826ECessna 150 · S/N 17326Cancelled Oct 19, 2006 · Triennial form not returned · Built 1959 · Holloway James E N6511NBellanca 14-13-3 · S/N 1630Cancelled Apr 5, 2006 · Built 1949 · Hedlund Robert L

Back to Tehachapi, CA