Skip to content

Luscombe Airplane Corp

Earlier aircraft under this name · 92

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 = 'LUSCOMBE AIRPLANE CORP' OR list_contains(d.other_registrant_names, 'LUSCOMBE AIRPLANE CORP') 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 = 'LUSCOMBE AIRPLANE CORP' OR list_contains(d.other_registrant_names, 'LUSCOMBE AIRPLANE CORP')
  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 = 'LUSCOMBE AIRPLANE CORP' OR list_contains(d.other_registrant_names, 'LUSCOMBE AIRPLANE CORP')
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.

N71431Luscombe 8A · S/N 2858Cancelled Feb 8, 1958 · Dallas, TX N2239BLuscombe T-8F · S/N 6666Cancelled May 30, 1957 · Exported to Canada · Built 1949 N1212KLuscombe 8A · S/N 3939Cancelled Feb 21, 1956 · Dallas, TX N1441KLuscombe 8A · S/N 4168Cancelled Feb 21, 1956 · Built 1946 · Dallas, TX N1369BLuscombe 8F · S/N 5996Cancelled Nov 17, 1955 N1385BLuscombe 8F · S/N 6012Cancelled Nov 17, 1955 N1413BLuscombe 8F · S/N 6040Cancelled Nov 17, 1955 N843BLuscombe 8F · S/N 6775Cancelled Nov 17, 1955 N847BLuscombe 8F · S/N 6779Cancelled Nov 17, 1955 N845BLuscombe 8F · S/N 6777Cancelled Oct 25, 1954 · Dallas, TX N1665KLuscombe 8A · S/N 4392Cancelled Dec 4, 1951 · Dallas, TX N2333KLuscombe 8A · S/N 5060Cancelled Nov 29, 1951 · Dallas, TX N1829BLuscombe XT-8H · S/N 6256Cancelled Oct 23, 1951 · Garland, TX N1593KLuscombe 8A · S/N 4320Cancelled Oct 1, 1951 · Dallas, TX N2835KLuscombe 8A · S/N 5562Cancelled Jul 23, 1951 · Dallas, TX N1600KLuscombe 8A · S/N 4327Cancelled Apr 25, 1951 · Dallas, TX N2864KLuscombe 8E · S/N 5591Cancelled Apr 5, 1951 · Dallas, TX N818BLuscombe 8F · S/N 6748Cancelled Mar 29, 1951 · Exported to Canada · Garland, TX N819BLuscombe 8F · S/N 6749Cancelled Mar 12, 1951 · Exported to Uruguay N833BLuscombe 8F · S/N 6765Cancelled Mar 6, 1951 · Exported to Mexico · Dallas, TX N828BLuscombe 8F · S/N 6759Cancelled Jan 30, 1951 · Exported to Canada · Dallas, TX N12701Luscombe 8E · S/N 5875Cancelled Jun 16, 1950 · Dallas, TX N1232BLuscombe 8E · S/N 5859Cancelled Mar 16, 1950 · Dallas, TX N1233BLuscombe 8E · S/N 5860Cancelled Mar 16, 1950 · Dallas, TX N1234BLuscombe 8E · S/N 5861Cancelled Mar 16, 1950 · Dallas, TX N1235BLuscombe 8E · S/N 5862Cancelled Mar 16, 1950 · Dallas, TX N1236BLuscombe 8E · S/N 5863Cancelled Mar 16, 1950 · Dallas 1, TX N1237BLuscombe 8E · S/N 5864Cancelled Mar 16, 1950 · Dallas 1, TX N1238BLuscombe 8E · S/N 5865Cancelled Mar 16, 1950 · Dallas, TX N1249BLuscombe 8E · S/N 5876Cancelled Mar 16, 1950 · Dallas, TX N1255BLuscombe/Hankins 8E · S/N 5882Cancelled Mar 16, 1950 · Dallas, TX N1256BLuscombe 8E · S/N 5883Cancelled Mar 16, 1950 · Dallas, TX N1266BLuscombe 8A · S/N 5893Cancelled Mar 16, 1950 · Dallas, TX N1295BLuscombe 8E · S/N 5922Cancelled Mar 16, 1950 · Dallas, TX N1296BLuscombe 8E · S/N 5923Cancelled Mar 16, 1950 · Dallas, TX N1297BLuscombe 8E · S/N 5924Cancelled Mar 16, 1950 · Dallas, TX N72042Luscombe 8A · S/N 3469Cancelled Feb 21, 1950 · Exported to Mexico N1668KLuscombe 8A · S/N 4395Cancelled Sep 15, 1949 · Dallas, TX N2492KLuscombe 8E · S/N 5219Cancelled Jun 9, 1949 · Dallas, TX N2982KLuscombe 8A · S/N 5709Cancelled Jun 9, 1949 · Dallas, TX N1363BLuscombe 8E · S/N 5990Cancelled May 27, 1949 · Dallas, TX N1590BLuscombe T-8F · S/N 6217Cancelled May 26, 1949 · Built 1948 · Dallas, TX N1602BLuscombe 11A · S/N 11-108Cancelled May 18, 1949 · Fort Worth, TX N2151BLuscombe T-8F · S/N 6578Cancelled May 18, 1949 · Dallas, TX N2705KLuscombe 11A · S/N 11-4Cancelled May 18, 1949 · Built 1947 · Oklahoma City, OK N2727KLuscombe 11A · S/N 11-3Cancelled May 18, 1949 · Dallas, TX N77954Luscombe 8A · S/N 3681Cancelled May 18, 1949 · Dallas, TX N77999Luscombe 8A · S/N 3726Cancelled May 18, 1949 · Dallas, TX N71527Luscombe 8A · S/N 2954Cancelled May 2, 1949 · Dallas, TX N72023Luscombe 8A · S/N 3450Cancelled Apr 29, 1949

Back to Luscombe Airplane Corp