Skip to content

Veracity Aviation LLC

Earlier aircraft under this name · 29

Cancelled registrations that named this owner when they ended, newest first.

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_name = 'VERACITY AVIATION LLC' OR list_contains(d.other_registrant_names, 'VERACITY AVIATION LLC') 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_name = 'VERACITY AVIATION LLC' OR list_contains(d.other_registrant_names, 'VERACITY AVIATION LLC')
  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_name = 'VERACITY AVIATION LLC' OR list_contains(d.other_registrant_names, 'VERACITY AVIATION LLC')
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.

N544RTRobinson Helicopter R44 II · S/N 12600Cancelled Mar 12, 2026 · Exported to Mexico · Built 2009 · Seguin, TX N40574Robinson Helicopter R66 · S/N 1350Cancelled Jul 11, 2024 · Exported to Brazil · Built 2024 · Seguin, TX N4059QRobinson Helicopter R66 · S/N 1282Cancelled Dec 14, 2023 · Exported to Brazil · Built 2023 · Seguin, TX N570PMPiper PA46-500TP · S/N 4697570Cancelled Dec 6, 2022 · Exported to Brazil · Built 2014 · Seguin, TX N4414ZPiper PA46-500TP · S/N 4697568Cancelled Nov 29, 2021 · Exported to Brazil · Built 2014 · Seguin, TX N499RVRonald L Owen VANS RV-10 · S/N 40373Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 2011 · Seguin, TX N87KHEurocopter EC 130 B4 · S/N 3490Cancelled Sep 2, 2014 · Exported to Brazil · Built 2001 · Seguin, TX N151VALearjet 45 · S/N 45-2034Cancelled Jan 22, 2014 · Exported to Brazil · Seguin, TX N134VAAmerican Eurocopter AS350B2 · S/N 7407Cancelled May 9, 2013 · Exported to Brazil · Built 2012 · Seguin, TX N141VARobinson Helicopter R44 II · S/N 12392Cancelled Apr 2, 2013 · Exported to Brazil · Seguin, TX N130VAAmerican Eurocopter AS350B2 · S/N 7387Cancelled Mar 14, 2013 · Exported to Brazil · Built 2012 · Seguin, TX N89CURockwell International 690B · S/N 11355Cancelled Jan 10, 2013 · Exported to Brazil · Built 1976 · Seguin, TX N7037JRobinson Helicopter R66 · S/N 0197Cancelled Nov 29, 2012 · Exported to Brazil · Seguin, TX N7071KRobinson Helicopter R66 · S/N 0171Cancelled Aug 13, 2012 · Exported to Brazil · Seguin, TX N256SHRobinson Helicopter R22 BETA · S/N 4221Cancelled Jun 25, 2012 · Exported to Brazil · Built 2007 · Seguin, TX N40436Robinson Helicopter R22 BETA · S/N 1674Cancelled Jun 25, 2012 · Exported to Brazil · Built 1991 · Seguin, TX N764ZSRobinson Helicopter R22 BETA · S/N 3235Cancelled Jun 25, 2012 · Exported to Brazil · Built 2001 · Seguin, TX N936SHRobinson Helicopter R22 BETA · S/N 3906Cancelled Jun 25, 2012 · Exported to Brazil · Built 2005 · Seguin, TX N4478HRobinson Helicopter R44 II · S/N 13255Cancelled Apr 23, 2012 · Exported to Brazil · Seguin, TX N156AFCessna T310R · S/N 310R1289Cancelled Mar 30, 2012 · Exported to Brazil · Built 1978 · Seguin, TX N120VAAmerican Eurocopter AS350B2 · S/N 7255Cancelled Mar 16, 2012 · Exported to Brazil · Seguin, TX N606ACPiper PA46R-350T · S/N 4692070Cancelled Jan 20, 2012 · Exported to Brazil · Built 2008 · Seguin, TX N119VAAmerican Eurocopter AS350B2 · S/N 7208Cancelled Dec 30, 2011 · Exported to Brazil · Built 2011 · Seguin, TX N455MSPiper PA 46-350P · S/N 4622199Cancelled Nov 3, 2011 · Exported to Brazil · Built 1995 · Seguin, TX N954SHRobinson Helicopter R22 BETA · S/N 3924Cancelled Sep 23, 2011 · Exported to Brazil · Built 2005 · Seguin, TX N763FCessna 510 · S/N 510-0276Cancelled Jul 22, 2011 · Exported to Brazil · Built 2009 · Seguin, TX N167JLRobinson Helicopter R44 II · S/N 10782Cancelled Jun 6, 2011 · Exported to Brazil · Built 2005 · Seguin, TX N118VAAmerican Eurocopter AS350B3 · S/N 7044Cancelled Apr 11, 2011 · Exported to Brazil · Built 2010 · New Braunfels, TX N116VARobinson Helicopter R44 · S/N 1941Cancelled Oct 19, 2010 · Exported to Brazil · Built 2008 · New Braunfels, TX

Back to Veracity Aviation LLC