Skip to content

Earlier aircraft under this name · 87

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 = '2F TRADE LLC' OR list_contains(d.other_registrant_names, '2F TRADE 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 = '2F TRADE LLC' OR list_contains(d.other_registrant_names, '2F TRADE 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 = '2F TRADE LLC' OR list_contains(d.other_registrant_names, '2F TRADE 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.

N3787EPiper PA-36-300 · S/N 36-7860078Cancelled Jan 26, 2024 · Exported to Brazil · Built 1978 · Collinsville, TX N830JACessna 210N · S/N 21064839Cancelled Oct 19, 2022 · Exported to Brazil · Built 1984 · Collinsville, TX N5633DBeech F33A · S/N CE-1631Cancelled Aug 13, 2021 · Exported to Brazil · Built 1991 · Collinsville, TX N61880Cessna A185F · S/N 18504267Cancelled Aug 11, 2021 · Exported to Brazil · Built 1981 · Collinsville, TX N761DQCessna T210M · S/N 21062177Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1977 · Mckinney, TX N7311MCessna T210M · S/N 21062007Cancelled May 6, 2019 · Exported to Brazil · Built 1977 · Collinsville, TX N5035VCessna 210L · S/N 21060823Cancelled Dec 26, 2017 · Exported to Brazil · Built 1975 · Mckinney, TX N331TWCessna 210L · S/N 21061556Cancelled Oct 19, 2017 · Exported to Brazil · Built 1976 · Mckinney, TX N1603XCessna 210L · S/N 21060639Cancelled Jan 17, 2017 · Exported to Brazil · Built 1975 · Mckinney, TX N4949SCessna R182 · S/N R18201488Cancelled Nov 28, 2016 · Exported to Brazil · Built 1980 · Mckinney, TX N4637YCessna 210N · S/N 21063965Cancelled Oct 14, 2016 · Exported to Brazil · Built 1980 · Mckinney, TX N8001SCessna 150F · S/N 15061601Cancelled Sep 26, 2016 · Exported to Brazil · Built 1965 · Mckinney, TX N94186Cessna 152 · S/N 15285616Cancelled Sep 20, 2016 · Exported to Brazil · Built 1982 · Collinsville, TX N4702CCessna T210N · S/N 21063591Cancelled Aug 3, 2016 · Exported to Brazil · Built 1979 · Mckinney, TX N30326Cessna 210L · S/N 21059914Cancelled Jul 27, 2016 · Exported to Brazil · Built 1973 · Collinsville, TX N4673CCessna T210N · S/N 21063586Cancelled Jul 19, 2016 · Expired dealer · Built 1979 · Mckinney, TX N221ATCessna T210N · S/N 21064567Cancelled Jun 24, 2016 · Exported to Brazil · Built 1981 · Mckinney, TX N6622NCessna T210N · S/N 21063125Cancelled May 24, 2016 · Exported to Brazil · Built 1978 · Mckinney, TX N9073MCessna 210M · S/N 21062058Cancelled Mar 9, 2016 · Exported to Brazil · Built 1977 · Mckinney, TX N4746QCessna T210M · S/N 21062586Cancelled Sep 16, 2015 · Exported to Brazil · Collinsville, TX N5212VCessna T210L · S/N 21060862Cancelled Sep 16, 2015 · Exported to Brazil · Collinsville, TX N2145UCessna T210N · S/N 21064776Cancelled Aug 20, 2015 · Exported to Brazil · Built 1982 · Mckinney, TX N732KTCessna T210M · S/N 21061579Cancelled Aug 13, 2015 · Exported to Brazil · Mckinney, TX N102CRCessna T210N · S/N 21064745Cancelled Jul 31, 2015 · Exported to Brazil · Built 1982 · Mckinney, TX N8WECessna 210L · S/N 21060766Cancelled Jul 30, 2015 · Exported to Brazil · Built 1975 · Mckinney, TX N7398MCessna T210M · S/N 21062018Cancelled May 8, 2015 · Exported to Brazil · Built 1977 · Mckinney, TX N58GTBeech 58 · S/N TH1090Cancelled Apr 28, 2015 · Exported to Brazil · Built 1979 · Collinsville, TX N718JBBeech E-55 · S/N TE-1201Cancelled Apr 22, 2015 · Exported to Brazil · Built 1982 · Mckinney, TX N93028Cessna 210L · S/N 21060225Cancelled Mar 24, 2015 · Exported to Brazil · Built 1974 · Mckinney, TX N6598YCessna T210N · S/N 21064451Cancelled Mar 20, 2015 · Exported to Brazil · Built 1981 · Mckinney, TX N220PCCessna T210N · S/N 21063771Cancelled Mar 4, 2015 · Exported to Brazil · Built 1979 · Mckinney, TX N770HYCessna 206H · S/N 20608288Cancelled Jan 23, 2015 · Exported to Brazil · Built 2007 · Mckinney, TX N224MECessna 206H · S/N 20608110Cancelled Nov 7, 2014 · Exported to Brazil · Built 2000 · Collinsville, TX N732HNCessna T210L · S/N 21061527Cancelled Nov 6, 2014 · Exported to Brazil · Built 1976 · Mckinney, TX N7793UCessna T210R · S/N 21064979Cancelled Oct 17, 2014 · Exported to Brazil · Built 1986 · Mckinney, TX N9755YCessna T210N · S/N 21064589Cancelled Oct 14, 2014 · Exported to Brazil · Built 1981 · Mckinney, TX N515ESBeech E-55 · S/N TE-1200Cancelled Oct 10, 2014 · Exported to Brazil · Built 1982 · Mckinney, TX N6372UCessna T210R · S/N 21064945Cancelled Aug 25, 2014 · Exported to Brazil · Mckinney, TX N4904NCessna 182Q · S/N 18267448Cancelled Aug 19, 2014 · Exported to Brazil · Built 1979 · Mckinney, TX N6573FBeech 58 · S/N TH-1368Cancelled Aug 18, 2014 · Exported to Brazil · Built 1983 · Collinsville, TX N463CPHawker Beechcraft G58 · S/N TH-2367Cancelled Jul 23, 2014 · Exported to Brazil · Built 2013 · Mckinney, TX N215DRBeech 95-B55 · S/N TC-2390Cancelled Jun 11, 2014 · Exported to Brazil · Built 1981 · Collinsville, TX N2485UCessna 210N · S/N 21064786Cancelled May 23, 2014 · Exported to Brazil · Built 1983 · Collinsville, TX N1YBeech 58 · S/N TH-1783Cancelled Feb 18, 2014 · Exported to Brazil · Built 1996 · Collinsville, TX N500DYHawker Beechcraft G58 · S/N TH-2314Cancelled Sep 11, 2013 · Exported to Brazil · Collinsville, TX N5524TCessna R182 · S/N R18201885Cancelled Aug 30, 2013 · Exported to Brazil · Built 1982 · Collinsville, TX N38779Cessna T210N · S/N 21064068Cancelled Aug 5, 2013 · Exported to Paraguay · Built 1980 · Collinsville, TX N5355TCessna R182 · S/N R18201859Cancelled Aug 5, 2013 · Exported to Brazil · Collinsville, TX N103ELCessna A185F · S/N 18504192Cancelled Jul 25, 2013 · Exported to Brazil · Built 1981 · Collinsville, TX N62624Beech 58 · S/N TH-1684Cancelled Jul 1, 2013 · Exported to Brazil · Built 1993 · Collinsville, TX

Back to 2f Trade LLC