Skip to content

Globe Aircraft Corp

Earlier aircraft under this name · 54

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 = 'GLOBE AIRCRAFT CORP' OR list_contains(d.other_registrant_names, 'GLOBE AIRCRAFT 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 = 'GLOBE AIRCRAFT CORP' OR list_contains(d.other_registrant_names, 'GLOBE AIRCRAFT 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 = 'GLOBE AIRCRAFT CORP' OR list_contains(d.other_registrant_names, 'GLOBE AIRCRAFT 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.

N78020Globe GC-1B · S/N 2020Cancelled Mar 16, 1956 · Built 1946 N80988Globe GC-1B · S/N 1181Cancelled Feb 23, 1956 · Fort Worth, TX N3362KGlobe GC-1B · S/N 1355Cancelled Oct 17, 1955 · Ft Worth, TX N3776KGlobe GC-1B · S/N 1469Cancelled Oct 17, 1955 N3369KGlobe GC-1B · S/N 1362Cancelled Apr 25, 1951 · Ft Worth, TX N80755Globe GC-1A · S/N 158Cancelled Jun 23, 1950 · Built 1946 · Fort Worth, TX N80738Globe GC-1A · S/N 141Cancelled Nov 21, 1949 · Built 1946 · Fort Worth, TX N80994Globe GC-1B · S/N 1187Cancelled Sep 12, 1949 · Fort Worth, TX N80751Globe GC-1A · S/N 154Cancelled Jul 14, 1949 · Built 1946 · Fort Worth, TX N80784Globe GC-1A · S/N 187Cancelled Jun 24, 1949 · Built 1946 · Fort Worth, TX N80814Globe GC-1A · S/N 217Cancelled Jun 24, 1949 · Fort Worth, TX N80816Globe GC-1A · S/N 219Cancelled May 23, 1949 · Fort Worth, TX N80810Globe GC-1A · S/N 213Cancelled Apr 28, 1949 · Ft Worth, TX N80638Globe GC-1B · S/N 1043Cancelled Mar 31, 1949 · Built 1946 · Ft Worth, TX N80631Globe GC-1B · S/N 1036Cancelled Mar 30, 1949 · Built 1946 · Ft Worth, TX N78235Globe GC-1B · S/N 2235Cancelled Mar 9, 1949 · Exported to Uruguay · Fort Worth, TX N80660Globe GC-1B · S/N 1065Cancelled Mar 9, 1949 · Exported to Sweden · Built 1946 · Ft Worth, TX N78189Globe GC-1B · S/N 2189Cancelled Mar 8, 1949 · Ft Worth, TX N78239Globe GC-1B · S/N 2239Cancelled Mar 8, 1949 · Exported to Uruguay · Fort Worth, TX N78240Globe GC-1B · S/N 2240Cancelled Mar 8, 1949 · Exported to Uruguay · Fort Worth, TX N78303Globe GC-1 · S/N 2303Cancelled Mar 8, 1949 · Exported to Chile · Forth Worth, TX N80554Globe GC-1A · S/N 57Cancelled Mar 7, 1949 · Built 1946 · Fort Worth, TX N80697Globe GC-1B · S/N 1102Cancelled Mar 7, 1949 · Built 1946 · Ft Worth, TX N80996Globe GC-1B · S/N 1189Cancelled Feb 24, 1949 · Fort Worth, TX N33344Globe GC-1B · S/N 1003Cancelled Nov 23, 1948 · Built 1946 · Fort Worth, TX N80670Globe GC-1B · S/N 1075Cancelled May 24, 1948 · Exported to Mexico · Built 1946 · Ft Worth, TX N3784KGlobe GC-1B · S/N 1477Cancelled Jan 30, 1948 · Ft Worth, TX N3316KGlobe GC-1B · S/N 1309Cancelled Jan 29, 1948 · Ft Worth, TX N80701Globe GC-1A · S/N 104Cancelled Jan 8, 1948 · Built 1946 · Fort Worth, TX N80553Globe GC-1A · S/N 56Cancelled Dec 10, 1947 · Built 1976 · Fort Worth, TX N3724KGlobe GC-1B · S/N 1417Cancelled Aug 4, 1947 · Exported to Venezuela · Ft Worth, TX N80522Globe GC-1A · S/N 25Cancelled Mar 13, 1947 · Built 1946 · Fort Worth, TX N80509Globe GC-1A · S/N 12Cancelled Jan 28, 1947 · Built 1946 · Fort Worth, TX N80939Globe GC-1B · S/N 1132Cancelled Dec 13, 1946 · Ft Worth, TX N3347KGlobe GC-1B · S/N 1340Cancelled Dec 2, 1946 · Ft Worth, TX N3276KGlobe GC-1B · S/N 1269Cancelled Nov 22, 1946 · Exported to South Africa · Fort Worth, TX N3279KGlobe GC-1B · S/N 1272Cancelled Nov 22, 1946 · Exported to South Africa · Fort Worth, TX N17690Globe GC-1 · S/N GC-1Cancelled Dec 1, 1944 · Built 1941 · Fort Worth, TX N17688Globe GC-1 · S/N 1Cancelled Apr 17, 1942 · Built 1941 · Fort Worth, TX N17640Globe GC-1A · S/N 1Cancellation date not recorded · Built 1944 · Fort Worth, TX N3250KGlobe GC-1B · S/N 1243Cancellation date not recorded · Built 1946 · Fort Worth, TX N3275KGlobe GC-1B · S/N 1268Cancellation date not recorded · Built 1946 · Fort Worth, TX N3277KGlobe GC-1B · S/N 1270Cancellation date not recorded · Built 1946 · Fort Worth, TX N3278KGlobe GC-1B · S/N 1271Cancellation date not recorded · Built 1946 · Fort Worth, TX N3280KGlobe GC-1B · S/N 1273Cancellation date not recorded · Built 1946 · Fort Worth, TX N3281KGlobe GC-1B · S/N 1274Cancellation date not recorded · Built 1946 · Fort Worth, TX N3330KGlobe GC-1B · S/N 1323Cancellation date not recorded · Built 1946 · Fort Worth, TX N3359KGlobe GC-1B · S/N 1352Cancellation date not recorded · Built 1946 · Ft Worth, TX N59226Cessna T-50 · S/N 6066Cancellation date not recorded · Ft Worth, TX N59227Cessna T-50 · S/N 6375 (43-32437)Cancellation date not recorded

Back to Globe Aircraft Corp