Skip to content

Lockheed Aircraft Corp

Earlier aircraft under this name · 68

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

N5547LLockheed 1329-25 JETSTAR II · S/N 5221Cancelled Apr 13, 1978 · Exported to Libya · Marietta, GA N3628RCessna 172E · S/N 17251543Cancelled Sep 7, 1977 · Burbank, CA N5529LLockheed 1329-25 JETSTAR II · S/N 5203Cancelled May 11, 1977 · Exported to Iran · Marietta, GA N1604LLockheed Aircraft Intl 402-2 · S/N 1019Cancelled Jul 12, 1974 · Burbank, CA N7967SLockheed 382E-44K-20 · S/N 4512Cancelled Apr 11, 1974 · Exported to Philippines · Marietta, GA N7992SLockheed 382C-29D · S/N 4503Cancelled Jan 23, 1974 · Exported to Saudi Arabia · Marietta, GA N7775Lockheed 1329 · S/N 5073Cancelled May 25, 1973 · Marietta, GA N974PSBoeing 727-14 · S/N 18912Cancelled Mar 16, 1972 · Exported to Mexico · Burbank, CA N125DLockheed TV-2 · S/N 1000Cancelled Oct 26, 1970 · Burbank, CA N7985SLockheed 382E-44K-20 · S/N 4358Cancelled Oct 20, 1970 · Exported to Peru · Marietta, GA N4652Lockheed C-130B · S/N 3572Cancelled Jan 22, 1970 · Exported to Colombia · Marietta, GA N5501LLockheed 1329-23E · S/N 5137Cancelled Nov 7, 1969 · Exported to Iran · Marietta, GA N5500LLockheed 1329-23E · S/N 5136Cancelled Oct 22, 1969 · Exported to Libya · Marietta, GA N7975SLockheed 1329-23E · S/N 5130Cancelled Jun 25, 1969 · Exported to Saudi Arabia · Marietta, GA N7974SLockheed 1329-23E · S/N 5129Cancelled Jun 3, 1969 · Exported to Saudi Arabia · Marietta, GA N7983SLockheed 382C · S/N 4291Cancelled Jan 24, 1969 · Exported to Brazil · Marietta, GA N7966SLockheed 1329-23D · S/N 5121Cancelled Dec 13, 1968 · Exported to Germany · Built 1968 · Marietta, GA N4654Lockheed C-130B · S/N 3587Cancelled Jun 19, 1968 · Exported to Bahamas · Marietta, GA N9264RLockheed 382C · S/N 4202Cancelled Apr 7, 1967 · Exported to Brazil · Built 1967 · Marietta, GA N9224RLockheed 1329 · S/N 5059Cancelled Oct 20, 1965 · Exported to Indonesia · Marietta, GA N329KLockheed CL329 · S/N 1002Cancelled Jun 8, 1965 · Burbank, CA N6940CLockheed CL475 · S/N 4751001Cancelled Jun 8, 1965 · Burbank, CA N9296RLockheed C-130B · S/N 3583Cancelled May 25, 1965 · Exported to Indonesia · Built 1960 · Marietta, GA N9297RLockheed C-130B · S/N 3582Cancelled May 25, 1965 · Exported to Indonesia · Built 1960 · Marietta, GA N9298RLockheed C-130B · S/N 3580Cancelled May 22, 1965 · Exported to Indonesia · Built 1960 · Marietta, GA N9289RLockheed 1329 · S/N 5046Cancelled Oct 6, 1964 · Exported to Indonesia · Marietta, GA N18565Douglas DC3A · S/N 4911Cancelled Sep 14, 1962 · Exported to Germany · Built 1942 N9213RLockheed 1329 · S/N 5025Cancelled Sep 4, 1962 · Marietta, GA N9287RLockheed 1329 · S/N 5022Cancelled Feb 14, 1962 · Marietta, GA N93114Douglas DC-6B · S/N 45065Cancelled Jan 27, 1962 · Marietta, GA N9291RLockheed C-130B · S/N 3616Cancelled Sep 25, 1961 · Exported to Indonesia · Marietta, GA N9292RLockheed C-130B · S/N 3615Cancelled Sep 25, 1961 · Exported to Indonesia · Marietta, GA N9293RLockheed C-130B · S/N 3601Cancelled Sep 25, 1961 · Exported to Indonesia · Marietta, GA N9294RLockheed C-130B · S/N 3599Cancelled Sep 25, 1961 · Exported to Indonesia · Marietta, GA N9295RLockheed C-130B · S/N 3598Cancelled Sep 25, 1961 · Exported to Indonesia · Marietta, GA N9299RLockheed C-130B · S/N 3578Cancelled Mar 6, 1961 · Marietta, GA N1882Lockheed 188A · S/N 188A-1002Cancelled Jul 24, 1959 · Exported to China · Burbank, CA N86520Lockheed 649-79 · S/N 649-2503Cancelled Dec 29, 1947 · Exported to Mexico · Burbank, CA N88849Lockheed 49 · S/N 2049Cancelled Oct 2, 1947 · Exported to Brazil · Burbank, CA N90821Lockheed 49-46 · S/N 049-2083Cancelled Jun 4, 1947 · Exported to Netherlands · Burbank, CA N33603Lockheed 18-08 · S/N 2169Cancelled Apr 6, 1943 · Burbank, CA N913Lockheed VEGA 1 · S/N 1Cancelled Jan 18, 1939 · Built 1927 · Burbank, CA N17394Lockheed 14-H · S/N 1439Cancelled May 16, 1938 · Xxx, OK N12278Lockheed ORION 9 · S/N 193Cancelled Sep 13, 1937 · Burbank, CA N868ELockheed VEGA 5B · S/N 68Cancelled Sep 21, 1931 N8497Lockheed VEGA 1 · S/N 154Cancelled Aug 4, 1931 · Detroit, MI N349VLockheed SIRIUS 8A · S/N 141Cancelled Jan 13, 1931 · Burbank, CA N14WLockheed SIRIUS 8A · S/N 144Cancelled Nov 18, 1930 · Burbank, CA N100NLockheed VEGA 5 · S/N 111Cancelled Oct 3, 1930 N521KLockheed 3 AIR EXPRESS · S/N 91Cancelled Jul 22, 1930 · Burbank, CA

Back to Lockheed Aircraft Corp