Skip to content

Lockheed Martin Corp

Earlier aircraft under this name · 29

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

N483KLLockheed Martin DESERT HAWK EER · S/N AV-0001Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Owego, NY N442SBLockheed Martin INDAGO · S/N 3579Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Owego, NY N4797CLockheed Martin DESERT HAWK III · S/N AV-N00BCancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 2012 · Owego, NY N480NCLockheed Martin DESERT HAWK III · S/N AV-N00ACancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 2012 · Owego, NY N483HLLockheed Martin DESERT HAWK EER · S/N AV-0003Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 2012 · Owego, NY N483JLLockheed Martin DESERT HAWK EER · S/N AV-0002Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 2012 · Owego, NY N483MKLockheed Martin DESERT HAWK IIIK · S/N AV-0452Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 2012 · Owego, NY N483PKLockheed Martin DESERT HAWK IIIK · S/N AV-0454Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 2012 · Owego, NY N483QKLockheed Martin DESERT HAWK IIIK · S/N AV-0453Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 2012 · Owego, NY N575BSLockheed Martin DESERT HAWK IIIK · S/N NAIR001Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Owego, NY N599HSLockheed Martin DESERT HAWK IIIK · S/N NAIR002Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Owego, NY N474LLLockheed Martin DESERT HAWK III · S/N AV-0569Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 2011 · Owego, NY N2382JLockheed Martin 382J · S/N 5824Cancelled Dec 4, 2020 · Marietta, GA N1382JLockheed Martin 382J · S/N 5818Cancelled May 7, 2020 · Built 2017 · Marietta, GA N242XEJennings Aeronautics XE · S/N 242Cancelled May 4, 2019 · Registration expired, pending cancellation · Palmdale, CA N243XEJennings Aeronautics XE · S/N 243Cancelled May 4, 2019 · Registration expired, pending cancellation · Palmdale, CA N245XEJennings Aeronautics XE · S/N 245Cancelled May 4, 2019 · Registration expired, pending cancellation · Palmdale, CA N232XEJennings Aeronautics XE · S/N 232Cancelled Mar 2, 2019 · Registration expired, pending cancellation · Palmdale, CA N233XEJennings Aeronautics XE · S/N 233Cancelled Mar 2, 2019 · Registration expired, pending cancellation · Palmdale, CA N202XEJennings Aeronautics XE · S/N 202Cancelled Feb 25, 2019 · Registration expired, pending cancellation · Palmdale, CA N203XEJennings Aeronautics XE · S/N 203Cancelled Feb 25, 2019 · Registration expired, pending cancellation · Palmdale, CA N483NYLockheed Martin VECTOR HAWK · S/N V120-2Cancelled Jan 18, 2019 · Registration expired, pending cancellation · Built 2015 · Owego, NY N483TKLockheed Martin INDAGO · S/N 3500Cancelled Jan 18, 2019 · Registration expired, pending cancellation · Built 2014 · Owego, NY N483TTLockheed Martin VECTOR HAWK V90 · S/N V90-2Cancelled Jan 18, 2019 · Registration expired, pending cancellation · Built 2015 · Owego, NY N144TQDiamond Aircraft Ind DA40 D · S/N D4.013Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 2003 · Palmdale, CA N1102URaytheon HAWKER 800XP · S/N 258343Cancelled Sep 8, 2003 · Exported to South Korea · Built 1998 · Litchfield Park, AZ N23204Raytheon Corporate Jets HAWKER 800XP · S/N 258346Cancelled Sep 8, 2003 · Exported to South Korea · Built 1998 · Litchfield Park, AZ N23207Raytheon Corporate Jets HAWKER 800XP · S/N 258350Cancelled Sep 8, 2003 · Exported to South Korea · Built 1998 · Litchfield Park, AZ N2321VRaytheon Corporate Jets HAWKER 800XP · S/N 258353Cancelled Sep 8, 2003 · Exported to South Korea · Built 1998 · Litchfield Park, AZ

Back to Lockheed Martin Corp