Skip to content

Cancelled registrations · 291

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 = 'TX' AND d.registrant_city = 'KERRVILLE' 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 = 'TX' AND d.registrant_city = 'KERRVILLE'
  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 = 'TX' AND d.registrant_city = 'KERRVILLE'
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.

N402YMBell UH-1D · S/N 8209Cancelled Sep 25, 2024 · Exported to Canada · Built 1969 · Rice Aircraft Services Inc N404YMBell UH-1D · S/N 8319Cancelled Sep 6, 2024 · Built 1969 · Rice Aircraft Services Inc N6173SCessna R182 · S/N R18201640Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1980 · Ret Gianni N888CNMooney International M10T · S/N 1TA-0001Cancelled Jun 18, 2022 · Expired dealer · Built 2015 · Mooney International Corp N362JMMooney M20F · S/N 22-1409Cancelled Dec 2, 2021 · Built 1976 · Major John A N264SPRaytheon B200 · S/N BB-1756Cancelled Feb 5, 2021 · Exported to Canada · Stieren George L N3929GBeech E-90 · S/N LW-55Cancelled Oct 27, 2020 · Built 1973 · M & H Flight Services LLC N7897YPiper PA-30 · S/N 30-984Cancelled Jan 31, 2020 · Registration expired · Built 1966 · Murcklen James O Sr N779KJDJI PHANTOM 3 ADVANCED · S/N P76DCK21A30721Cancelled Dec 2, 2019 · Registration expired, pending cancellation · C J Mac Ventures LLC N842PVDJI PHANTOM 2 VISION · S/N PH636050443Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Lehman Henry Clay N9038JDornak Thomas F ANTARES · S/N 81117Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 2003 · Dornak Thomas F N133SWCessna 150J · S/N 15069394Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Built 1968 · Anguiano Jerry Ybarra N60RWBeech A36TC · S/N EA-78Cancelled Apr 25, 2018 · Second renewal notice · Built 1980 · Jackson Henry L N44570Weikel John W VOLKSPLANE VP-1 · S/N VP106062005Cancelled Mar 23, 2018 · Registration expired, pending cancellation · Built 2005 · Weikel John W N20XRMooney M20R · S/N 29-0001Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 1994 · Mooney International Corp N1962ZCessna 150C · S/N 15059762Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Built 1962 · Williams Kyle G N9299MMooney M20E · S/N 1232Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 1966 · Dugosh Aircraft Service Co Inc N4062RRowland Richard S RANS S-12 XL · S/N 05990879Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Built 2000 · Cook Harry III N5764WPiper PA-28-150 · S/N 28-1546Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 1964 · Hoelscher David A N6053WPiper PA-28-140 · S/N 28-20065Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 1964 · Hoelscher David A N152TTTaylor Tommy REVOLUTION MINI-500 · S/N 0152Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Taylor Tommy N340PEAermacchi AM3-C · S/N 2020Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1973 · Hoelscher David A N3035VCessna 150M · S/N 15076362Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1974 · Hoelscher David A N2026SMooney International M20R · S/N 29-0523Cancelled Nov 8, 2017 · Exported to China · Built 2015 · Mooney International Corp N20XMMooney M20M · S/N 27-0001Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1989 · Mooney Aircraft Corporation N20XLMooney M20L · S/N 26-0001Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1987 · Mooney Aircraft Corporation N432BGMooney M20R · S/N 29-0427Cancelled Apr 6, 2017 · Exported to China · Built 2006 · Mooney International Corp N887PSMooney M20TN · S/N 31-0087Cancelled Apr 19, 2016 · Exported to China · Built 2008 · Mooney International Corp N865ACEmbraer EMB-110P2 · S/N 110.231Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1979 · Pacestar N668MRMooney International M20TN · S/N 31-0129Cancelled Dec 8, 2014 · Exported to China · Mooney International Corp N156MPMooney M20L · S/N 26-0037Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1988 · Mooney Aviation Co Inc N11418Cessna 150L · S/N 15075405Cancelled Aug 28, 2014 · Registration expired, pending cancellation · Built 1973 · Joseph L Kennedy Enterprises Ltd N230JWBradford JW HIPERLIGHT SNS-8 · S/N 731Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Bradford J W N91TDBeech A36 · S/N E-2624Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1991 · Gold Cup Pawn Shop Inc N329AGStinson VULTEE V-77 · S/N 77-57Cancelled Jul 15, 2013 · Registration pending, canceled N49358Aviat A-1 · S/N 1224Cancelled Jul 15, 2013 · Registration pending, canceled · Built 1993 N257LBLopresti Brothers Acft SHARKFIRE · S/N 001Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Lopresti Brothers Aircraft N8799Kirkwood BENSEN B-8M · S/N GG1Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1969 · Riexinger Albert J N79885Cessna 182P · S/N 18261842Cancelled May 13, 2013 · Registration expired, pending cancellation · Russell And Real Inc N76PThomas BPS · S/N X-1Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1958 · Buckman James H N5680MRaven S55A · S/N S55A-494Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Kennedy John R N84JGGary John W JR QUICKIE Q-2 · S/N 2089Cancelled Apr 2, 2013 · Sale reported, canceled N600GBNorthwing Design APACHE SPORT-B · S/N 36240Cancelled Feb 11, 2013 · First renewal notice · Built 2005 · Nathanson Roger N7219FPiper PA-28-140 · S/N 28-25130Cancelled Jul 9, 2012 · Registration pending, canceled · Built 1968 N8099KJoy Donald Gene GENESIS · S/N 15Cancelled May 18, 2012 · Registration expired, pending cancellation · Joy Donald Gene N738JHCessna 172N · S/N 17270010Cancelled Jul 12, 2011 · Exported to Argentina · Built 1977 · Meismer Bruce E N2704WMooney M20E · S/N 1017Cancelled Jan 3, 2011 · Expired dealer · Built 1966 · Mooney Aircraft Corporation N2717WMooney M20C · S/N 3335Cancelled Jan 3, 2011 · Expired dealer · Built 1966 · Mooney Aircraft Corporation N3448XMooney M20E · S/N 1134Cancelled Jan 3, 2011 · Expired dealer · Built 1966 · Mooney Aircraft Corporation N6789VMooney M20F · S/N 700066Cancelled Jan 3, 2011 · Expired dealer · Built 1970 · Mooney Aircraft Corporation

Back to Kerrville, TX