Skip to content

Earlier aircraft under this name · 24

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 = 'AVN AIR LLC' OR list_contains(d.other_registrant_names, 'AVN AIR 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 = 'AVN AIR LLC' OR list_contains(d.other_registrant_names, 'AVN AIR 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 = 'AVN AIR LLC' OR list_contains(d.other_registrant_names, 'AVN AIR 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.

N296SFLearjet 31A · S/N 166Cancelled Dec 19, 2014 · Exported to Mexico · Built 1998 · Danbury, CT N503MTBell 407 · S/N 53498Cancelled Feb 9, 2010 · Built 2001 · Danbury, CT N179EXDassault FALCON 2000EX · S/N 179Cancelled Sep 29, 2009 · Exported to Brazil · Built 2008 · Danbury, CT N2HBCessna 560XL · S/N 560-5579Cancelled Sep 23, 2008 · Exported to Brazil · Built 2005 · Danbury, CT N370NARaytheon B300 · S/N FL-345Cancelled Sep 23, 2008 · Exported to Brazil · Built 2002 · Danbury, CT N998GCGates Learjet 35A · S/N 343Cancelled Jun 12, 2008 · Exported to Argentina · Danbury, CT N55PXCessna 525 · S/N 525-0285Cancelled Feb 25, 2008 · Exported to Brazil · Built 1998 · Danbury, CT N210KPHawker Beechcraft 390 · S/N RB-210Cancelled Jan 14, 2008 · Exported to Brazil · Built 2007 · Danbury, CT N429KRaytheon C90GT · S/N LJ-1771Cancelled Sep 5, 2007 · Exported to Brazil · Danbury, CT N7221YRaytheon C90GT · S/N LJ-1821Cancelled Aug 14, 2007 · Exported to Brazil · Built 2007 · Danbury, CT N690GTRaytheon C90GT · S/N LJ-1727Cancelled Jul 20, 2007 · Exported to Brazil · Built 2004 · Danbury, CT N7007YRaytheon C90GT · S/N LJ-1807Cancelled Jun 1, 2007 · Exported to Brazil · Danbury, CT N6QXAgusta A109E · S/N 11676Cancelled Dec 7, 2006 · Exported to Brazil · Built 2006 · Danbury, CT N37324Raytheon C90GT · S/N LJ-1794Cancelled Nov 28, 2006 · Exported to Brazil · Danbury, CT N470XPRaytheon 400A · S/N RK-470Cancelled Nov 27, 2006 · Exported to Brazil · Danbury, CT N705QDSocata TBM 700 · S/N 231Cancelled Jul 10, 2006 · Triennial form not returned · Built 2002 · Reading, PA N61788Raytheon C90GT · S/N LJ-1763Cancelled Jun 13, 2006 · Exported to Brazil · Danbury, CT N6174QRaytheon 58 · S/N TH-2074Cancelled Feb 17, 2006 · Exported to Brazil · Danbury, CT N37155Raytheon B200 · S/N BB-1915Cancelled Jan 18, 2006 · Exported to Brazil · Danbury, CT N125DFLearjet 31A · S/N 214Cancelled Dec 29, 2005 · Exported to Brazil · Built 2000 · Danbury, CT N646RARaytheon 58 · S/N TH-1983Cancelled Aug 15, 2005 · Exported to Brazil · Built 2001 · Danbury, CT N90XPRaytheon C90A · S/N LJ-1644Cancelled May 14, 2004 · Exported to Brazil · Built 2001 · Danbury, CT N878CSIsrael Aircraft Industries GALAXY · S/N 027Cancelled Apr 30, 2004 · Exported to Brazil · Built 2000 · Danbury, CT N955MCRaytheon HAWKER 800XP · S/N 258384Cancelled Mar 1, 2004 · Exported to United Kingdom · Built 1998 · Danbury, CT

Back to Avn Air LLC