Skip to content

Earlier aircraft under this name · 58

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

N8055HBeech C18S · S/N 44-47121Cancelled Sep 18, 2009 · Registration revoked · Cody, WY N5438FPiper PA-28-181 · S/N 287790122Cancelled Nov 11, 1977 · Burley, ID N53413Cessna 337G · S/N 33701607Cancelled Dec 9, 1975 · Exported to Canada · Troutdale, OR N1067VCessna TU206F · S/N U20602437Cancelled Jul 5, 1974 · Exported to Canada · Troutdale, OR N55892Piper PA-28-180 · S/N 28-7305493Cancelled Jun 27, 1974 · Exported to Germany · Vandalia, OH N12149Cessna 172M · S/N 17261844Cancelled Jul 16, 1973 · Exported to Canada · Troutdale, OR N70469Cessna A185F · S/N 18502183Cancelled Apr 30, 1973 · Exported to Canada · Troutdale, OR N42231Cessna 180J · S/N 180-52327Cancelled Apr 16, 1973 · Exported to Canada · Troutdale, OR N70407Cessna A185F · S/N 18502154Cancelled Mar 23, 1973 · Exported to Canada · Built 1973 · Troutdale, OR N70425Cessna A185F · S/N 18502163Cancelled Mar 23, 1973 · Exported to Canada · Built 1973 · Troutdale, OR N8093GCessna 177RG · S/N 177RG0093Cancelled Feb 16, 1973 · Exported to Canada · Built 1971 · Troutdale, OR N60306Cessna 150J · S/N 15070213Cancelled Feb 6, 1973 · Exported to Canada · Troutdale, OR N1143LLake LA-4 · S/N 305Cancelled Nov 24, 1972 · Exported to Canada N70169Cessna 185 · S/N 18502034Cancelled Jul 13, 1972 · Exported to Canada · Troutdale, OR N849PSPiper PA-23-250 · S/N 27-3913Cancelled Jul 5, 1972 · Exported to Canada · Vandalia, OH N70134Cessna A185E · S/N 18502011Cancelled May 26, 1972 · Exported to Canada · Troutdale, OR N3172RPiper PA-28R-180 · S/N 28R-31120Cancelled Apr 24, 1972 · Exported to Germany · Built 1969 · Vandalia, OH N34103Cessna 177B · S/N 17701643Cancelled Mar 3, 1972 · Exported to Germany · Troutdale, OR N7917QCessna 401B · S/N 401B-0017Cancelled Mar 31, 1971 · Troutdale, OR N5041ZPiper PA-22 · S/N 22-8661Cancelled Jan 25, 1971 · Vandalia, OH N5829JCessna A185E · S/N 185 01798Cancelled Aug 17, 1970 · Exported to Canada · Troutdale, OR N22872Cessna 150H · S/N 15068579Cancelled Jul 6, 1970 · Troutdale, OR N29145Cessna U206 · S/N U206-1115Cancelled Jul 6, 1970 · Troutdale, OR N1278MCessna 337E · S/N 33701278Cancelled Jun 25, 1970 · Exported to Canada N1967UCessna A185E · S/N 18501691Cancelled Apr 13, 1970 · Exported to Canada · Troutdale, OR N1934UCessna A185E · S/N 18501627Cancelled Feb 6, 1970 · Exported to Canada · Troutdale, OR N1920UCessna A185E · S/N 185-1591Cancelled Dec 3, 1969 · Exported to Canada · Built 1969 · Troutdale, OR N4790QCessna 185E · S/N 185-1259Cancelled Sep 6, 1967 · Exported to Canada · Troutdale, OR N3310JCessna 150G · S/N 15066010Cancelled May 2, 1967 · Exported to Canada · Troutdale, OR N2987JCessna 150G · S/N 15065787Cancelled Mar 16, 1967 · Exported to Canada · Troutdale, OR N3113JCessna 150G · S/N 15065813Cancelled Mar 16, 1967 · Exported to Canada · Troutdale, OR N4374APiper PA-18-150 · S/N 18-4776Cancelled Feb 23, 1967 · Exported to Canada · Built 1956 · Cody, WY N1902EAeronca 7AC · S/N 7AC5469Cancelled May 25, 1965 · Vandalia, OH N84603Aeronca 7AC · S/N 7AC3310Cancelled May 24, 1965 · Vandalia, OH N1342EAeronca 7AC · S/N 7AC-4903Cancelled May 22, 1965 · Vandalia, OH N2889EAeronca 7AC · S/N 7AC6472Cancelled May 22, 1965 · Vandalia, OH N6792PPiper PA-24-250 · S/N 24-1925Cancelled May 20, 1965 · Vandalia, OH N2636UCessna 172D · S/N 17250236Cancelled Jun 8, 1964 · Exported to Canada · Troutdale, OR N2140YCessna 172D · S/N 17249640Cancelled Sep 4, 1963 · Exported to Canada · Portland, OR N2189ZCessna 180F · S/N 18051289Cancelled Sep 4, 1963 · Exported to Canada · Troutdale, OR N7069DPiper PA-18-150 · S/N 18-5609Cancelled Jul 11, 1958 · Exported to Canada N39633Aeronca 7AC · S/N 7AC-4Cancelled Mar 5, 1956 · Built 1945 · Vandalia, OH N64728Consolidated Vultee BT-13A · S/N 2595Cancelled Feb 17, 1956 · Vandalia, OH N1938BLuscombe 8A · S/N 6365Cancelled Nov 14, 1955 · Cooperstown, ND N61635Fairchild PT-23 · S/N H0-308Cancelled Oct 12, 1955 · Vandalia, OH N3674HEngineering & Research 415-C · S/N 4299Cancelled Jan 14, 1955 · Built 1946 · La Crosse, WI N3171NCessna 120 · S/N 13429Cancelled Jun 1, 1949 · Norfolk, NE N3770HEngineering & Research ERCOUPE 415-C · S/N 4395Cancelled Jun 1, 1949 · La Crosse, WI N87472Republic RC-3 · S/N 22Cancelled Mar 31, 1949 N33459Piper J3F-65 · S/N 5968Cancelled Aug 19, 1948 · Des Plaines, IL

Back to Skyways Inc