Skip to content

Summit Aviation Inc

Earlier aircraft under this name · 36

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 = 'SUMMIT AVIATION INC' OR list_contains(d.other_registrant_names, 'SUMMIT AVIATION INC') 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 = 'SUMMIT AVIATION INC' OR list_contains(d.other_registrant_names, 'SUMMIT AVIATION INC')
  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 = 'SUMMIT AVIATION INC' OR list_contains(d.other_registrant_names, 'SUMMIT AVIATION INC')
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.

N422DSDiamond Aircraft Ind DA 40 · S/N 40.1122Cancelled Dec 11, 2019 · Exported to New Zealand · Built 2011 · Belgrade, MT N50561Butterfly GOLDEN BUTTERFLY · S/N GB2001Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 2008 · Temple, TX N1206LConsolidated Aeronautics LAKE LA-4 · S/N 711Cancelled Jun 25, 2009 · Registration revoked · Built 1975 · Summit, NJ N99128Dehavilland BEAVER U-6A · S/N 56-0353Cancelled Nov 18, 1980 · Middleton, DE N99132Dehavilland BEAVER U-6A · S/N 53-7894Cancelled Nov 18, 1980 · Exported to Haiti · Middleton, DE N5592YShort Bros. & Harland SC-7 SKYVAN · S/N SH-1868Cancelled Sep 5, 1980 · Exported to Malaysia · Middletown, DE N31363Dehavilland BEAVER U-6A · S/N 550688Cancelled Aug 12, 1980 · Exported to Haiti · Middletown, DE N1452SCessna T337H · S/N 33701920Cancelled Jul 3, 1980 · Exported to Thailand · Built 1979 · Middletown, DE N1477SCessna T337H · S/N 33701926Cancelled Jul 3, 1980 · Exported to Thailand · Built 1979 · Middletown, DE N1468SCessna T337H · S/N 33701924Cancelled Jun 30, 1980 · Exported to Thailand · Built 1979 · Middletown, DE N1482SCessna T337H · S/N 33701927Cancelled Jun 30, 1980 · Exported to Thailand · Built 1979 · Middletown, DE N3309RCessna A185F · S/N 18502871Cancelled Apr 20, 1980 · Exported to Canada · Built 1975 · Middletown, DE N53589Cessna 337G · S/N 33701726Cancelled Jul 8, 1977 · Middletown, DE N53535Cessna 337G · S/N 33701688Cancelled Jul 7, 1977 · Middletown, DE N3819VCessna 170 · S/N 18725Cancelled Jul 6, 1977 · Built 1951 · Middletown, DE N53579Cessna 337G · S/N 33701717Cancelled Sep 3, 1976 · Exported to Nicaragua · Middletwon, DE N53576Cessna 337G · S/N 33701714Cancelled Aug 11, 1976 · Exported to Nicaragua · Middletown, DE N53577Cessna 337G · S/N 33701715Cancelled Aug 11, 1976 · Exported to Nicaragua · Middleton, DE N53585Cessna 337G · S/N 33701723Cancelled Aug 11, 1976 · Exported to Nicaragua · Middletown, DE N53563Cessna 337G · S/N 33701703Cancelled Jun 22, 1976 · Exported to Nicaragua · Middletown, DE N53566Cessna 337G · S/N 33701705Cancelled Jun 22, 1976 · Exported to Nicaragua · Middletown, DE N53567Cessna 337G · S/N 33701706Cancelled Jun 22, 1976 · Exported to Nicaragua · Middleton, DE N53569Cessna 337G · S/N 33701707Cancelled Jun 22, 1976 · Exported to Nicaragua · Middleton, DE N53556Cessna 337G · S/N 33701699Cancelled May 17, 1976 · Exported to Haiti · Middletown, DE N5214JCessna 402B · S/N 402B0901Cancelled Jul 22, 1975 · Exported to Haiti · Middletown, DE N5778GCessna 150K · S/N 15071278Cancelled Jul 8, 1975 · Middletown, DE N53445Cessna 337G · S/N 33701629Cancelled Apr 23, 1975 · Exported to Haiti · Middletown, DE N53444Cessna 337G · S/N 33701628Cancelled Apr 22, 1975 · Exported to Haiti · Middletown, DE N53442Cessna 337G · S/N 33701626Cancelled Apr 14, 1975 · Exported to Haiti · Built 1975 · Middletown, DE N53440Cessna 337G · S/N 33701624Cancelled Mar 20, 1975 · Exported to Haiti · Middletoun, DE N53441Cessna 337G · S/N 33701625Cancelled Mar 20, 1975 · Exported to Haiti · Middletown, DE N53443Cessna 337G · S/N 33701627Cancelled Mar 20, 1975 · Exported to Haiti · Middletown, DE N55461Piper PA-28R-200 · S/N 28R7335238Cancelled Jun 17, 1974 · Exported to Germany · Middletown, DE N57327Piper PA-32-300 · S/N 32-7440043Cancelled May 23, 1974 · Exported to Germany · Middletown, DE N56185Piper PA-28R-200 · S/N 28R7335376Cancelled Jan 21, 1974 · Exported to Germany · Middleton, DE N5934TCessna 150D · S/N 15060634Cancelled Dec 8, 1965

Back to Summit Aviation Inc