National Aeronautics And Space Administration

Earlier aircraft under this name · 53

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL
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 = 'NATIONAL AERONAUTICS AND SPACE ADMINISTRATION' OR list_contains(d.other_registrant_names, 'NATIONAL AERONAUTICS AND SPACE ADMINISTRATION')
  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.

N982NURobert W Smith DJI S900 · S/N U1RE10Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Houston, TXN984NURobert W Smith DJI S900 · S/N U1RE12Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Houston, TXN481NUHoneywell HONEYWELL T-HAWK · S/N 09091140Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Kennedy Space Ctr, FLN484NUHoneywell HONEYWELL T-HAWK · S/N 10021204Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Kennedy Space Ctr, FLN441NUDJI MATRICE 100 · S/N M02DCF16010170Cancelled Jul 26, 2019 · Registration expired, pending cancellation · Kennedy Space Ctr, FLN983NURobert W Smith DJI S900 · S/N U1RE11Cancelled May 6, 2019 · Registration expired, pending cancellation · Houston, TXN912NANorthrop T-38A · S/N 65-10354Cancelled Dec 20, 2018 · Registration expired, pending cancellation · Houston, TXN525NADassault/Sud FAN JET FALCON SER F · S/N 447Cancelled Dec 6, 2018 · Registration expired, pending cancellation · Hampton, VAN863NANorthrop T-38A · S/N 68-8116Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Edwards, CAN864NANorthrop T-38B · S/N 68-8113Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Edwards, CAN919NANorthrop T-38A · S/N 66-8385Cancelled Feb 26, 2018 · Registration expired, pending cancellation · Built 1966 · Houston, TXN940NSBoeing 377 SG · S/N 15938Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1949 · Houston, TXN605NALearjet 23 · S/N 23-049Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Built 1919 · Cleveland, OHN944NAGulfstream American G-1159 · S/N 144Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Built 1974 · Houston, TXN911NABoeing 747-SR-46 · S/N 20781Cancelled Sep 28, 2015 · Third renewal notice · Built 1973 · Houston, TXN511NANorthrop T-38A · S/N 65-10329Cancelled May 21, 2015 · Registration expired, pending cancellation · Built 1969 · Houston, TXN945NAGrumman G-1159 · S/N 118Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1972 · Houston, TXN948NAGrumman American Avn. G-1159 · S/N 222Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1978 · Houston, TXN423NAShort Bros C23A SHERPA · S/N 88-1862Cancelled Oct 30, 2014 · First renewal notice · Wallops Island, VAN840NAMcdonnell Douglas FA-18A · S/N 160780Cancelled Dec 8, 2011 · First renewal notice · Edwards, CAN837NAMcdonnell Douglas F-15B · S/N 71-0290Cancelled Nov 17, 2011 · First renewal notice · Edwards, CAN845NAMcdonnell Douglas FA-18B · S/N 160781Cancelled Nov 17, 2011 · First renewal notice · Edwards, CAN847NAMcdonnell Douglas FA-18A · S/N 161520Cancelled Nov 17, 2011 · First renewal notice · Edwards, CAN851NAMcdonnell Douglas FA-18A · S/N 161705Cancelled Nov 17, 2011 · First renewal notice · Edwards, CAN710NAConvair 30 · S/N 30-29Cancelled Jun 29, 2009 · Triennial form not returned · Built 1962 · Edwards, CAN419NABell UH-1H · S/N 65-09708Cancelled Jun 16, 2008 · Triennial form not returned · Kennedy Space Cntr, FLN618NABeech T-34C · S/N 160632Cancelled Feb 6, 2004 · Triennial form not returned · Cleveland, OHN510NABeech T-34C · S/N GL-108Cancelled Jan 29, 2004 · Triennial form not returned · Hampton, VAN566NAGates Lear Jet 25 · S/N 064Cancelled Apr 7, 2003 · Triennial form not returned · Built 1972 · Bay Saint Louis, MSN424NABell UH-1B · S/N 64-13907Cancelled Dec 4, 1981 · Wallops Island, VAN704NABell X-14A · S/N 56-4022Cancelled Nov 18, 1981 · Moffett Field, CAN716NADehavilland C-8A · S/N 63-13686Cancelled Sep 8, 1981 · Exported to Canada · Moffett Field, CAN810NALing-Temco-Vought F-8A · S/N 141353Cancelled Nov 12, 1980 · Edwards, CAN432NADouglas C-54G · S/N 45-5637Cancelled Sep 4, 1977 · Built 1969 · Wallops Island, VAN707NAConvair 440 · S/N 3Cancelled Apr 26, 1977 · Moffett Field, CAN709NALockheed U-2 · S/N 56-6682Cancelled Dec 13, 1976 · Moffett Field, CAN718NANorth American OV-10A · S/N 152881Cancelled May 26, 1976 · Moffett Field, CAN816NALing-Temco-Vought F-8A · S/N 145385Cancelled May 6, 1975 · Edwards, CAN703NANorth American F-100C · S/N 53-1709ACancelled Aug 2, 1974 · Moffett Field, CAN671NALockheed EC-121P · S/N 143201Cancelled Apr 9, 1974 · Wallops Island, VAN705NARyan XV-5B · S/N 62-4506Cancelled Mar 11, 1974 · Moffett Field, CAN711NAConvair 30A · S/N 30A-1Cancelled May 10, 1973 · Moffett Field, CAN957NANorthrop T-38A · S/N 69-7086Cancelled Dec 8, 1972 · Houston, TXN802NADouglas F5D-1 · S/N 142350Cancelled Dec 7, 1971 · Edwards, CAN510NALockheed T-33A · S/N 53-5172Cancelled Apr 27, 1971 · Hampton, VAN943NALockheed T-33A · S/N 57-0720Cancelled Mar 24, 1971 · Houston, TXN672NAVertol CH21C · S/N 56-4343Cancelled Feb 3, 1971 · Exported to Canada · Wallops Island, VAN673NAVertol CH21C · S/N 56-4344Cancelled Feb 3, 1971 · Wallops Station, VAN535NASikorsky UH-19D · S/N 56-1552Cancelled Jul 10, 1970 · Hampton, VAN422NALockheed C-121A · S/N 2605Cancelled May 11, 1970 · Greenbelt, MD
Back to National Aeronautics And Space Administration