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.
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
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.
N982NURobert W Smith DJI S900 · S/N U1RE10N984NURobert W Smith DJI S900 · S/N U1RE12N481NUHoneywell HONEYWELL T-HAWK · S/N 09091140N484NUHoneywell HONEYWELL T-HAWK · S/N 10021204N441NUDJI MATRICE 100 · S/N M02DCF16010170N983NURobert W Smith DJI S900 · S/N U1RE11N912NANorthrop T-38A · S/N 65-10354N525NADassault/Sud FAN JET FALCON SER F · S/N 447N863NANorthrop T-38A · S/N 68-8116N864NANorthrop T-38B · S/N 68-8113N919NANorthrop T-38A · S/N 66-8385N940NSBoeing 377 SG · S/N 15938N605NALearjet 23 · S/N 23-049N944NAGulfstream American G-1159 · S/N 144N911NABoeing 747-SR-46 · S/N 20781N511NANorthrop T-38A · S/N 65-10329N945NAGrumman G-1159 · S/N 118N948NAGrumman American Avn. G-1159 · S/N 222N423NAShort Bros C23A SHERPA · S/N 88-1862N840NAMcdonnell Douglas FA-18A · S/N 160780N837NAMcdonnell Douglas F-15B · S/N 71-0290N845NAMcdonnell Douglas FA-18B · S/N 160781N847NAMcdonnell Douglas FA-18A · S/N 161520N851NAMcdonnell Douglas FA-18A · S/N 161705N710NAConvair 30 · S/N 30-29N419NABell UH-1H · S/N 65-09708N618NABeech T-34C · S/N 160632N510NABeech T-34C · S/N GL-108N566NAGates Lear Jet 25 · S/N 064N424NABell UH-1B · S/N 64-13907N704NABell X-14A · S/N 56-4022N716NADehavilland C-8A · S/N 63-13686N810NALing-Temco-Vought F-8A · S/N 141353N432NADouglas C-54G · S/N 45-5637N707NAConvair 440 · S/N 3N709NALockheed U-2 · S/N 56-6682N718NANorth American OV-10A · S/N 152881N816NALing-Temco-Vought F-8A · S/N 145385N703NANorth American F-100C · S/N 53-1709AN671NALockheed EC-121P · S/N 143201N705NARyan XV-5B · S/N 62-4506N711NAConvair 30A · S/N 30A-1N957NANorthrop T-38A · S/N 69-7086N802NADouglas F5D-1 · S/N 142350N510NALockheed T-33A · S/N 53-5172N943NALockheed T-33A · S/N 57-0720N672NAVertol CH21C · S/N 56-4343N673NAVertol CH21C · S/N 56-4344N535NASikorsky UH-19D · S/N 56-1552N422NALockheed C-121A · S/N 2605
Back to National Aeronautics And Space Administration