Skip to content

Cancelled registrations · 39

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_state = 'NM' AND d.registrant_city = 'LOS ALAMOS' 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_state = 'NM' AND d.registrant_city = 'LOS ALAMOS'
  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_state = 'NM' AND d.registrant_city = 'LOS ALAMOS'
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.

N820LADJI INSPIRE 1 · S/N W13DCC17030820Cancelled Sep 27, 2023 · Los Alamos National Laboratory N344LADJI INSPIRE 1 · S/N W13DCC23030440Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Los Alamos National Laboratory N34476Cessna 177B · S/N 17701829Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 1972 · Pajarito Flying Club N2822FPiper PA-34-200T · S/N 34-7970260Cancelled Jul 6, 2021 · Third renewal notice · Flying Ponderosa LLC N876VFox Will E VENTURE · S/N 64Cancelled Jun 7, 2021 · Registration expired, pending cancellation · Fox Barbara M N803LADJI INSPIRE 1 · S/N W13DCC28030232Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Los Alamos National Laboratory N611YTDJI INSPIRE 1 · S/N W13DCC07020188Cancelled Mar 8, 2019 · Registration expired, pending cancellation · Limback Nathan P N260TSSiai-Marchetti SF260 · S/N 15-09Cancelled Mar 29, 2018 · Second renewal notice · Suchocki Thomas P N8072SCortesy John AIRBORNE EDGE-X · S/N 200582300Cancelled Mar 29, 2018 · Registration expired, pending cancellation · Built 2001 · Cortesy John E N66761Cessna 150M · S/N 15076257Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 1974 · Los Alamos Aircraft Maintenance Inc N155FTBeech A36 · S/N E-1922Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1981 · Cavasos Gary N572KERoebuck Kenneth VARI EZE · S/N 1905Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1982 · Swannack Clarke E N1881BLuscombe 8F · S/N 6308Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1948 · Lane Marjorie A N639CCessna 210 · S/N 57126Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1960 · Chase William R N5739FSchleicher Alexander K 7 · S/N 211Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1960 · Sangre De Cristo Soaring Club Inc N5112QCessna 152 · S/N 15285076Cancelled Mar 25, 2013 · Registration expired, pending cancellation · Built 1981 · Roberts Lonnie N4560BCessna 180 · S/N 31459Cancelled Mar 11, 2013 · Registration expired, pending cancellation · Built 1955 · Glass Neel W N395AMooney M-18L · S/N 56Cancelled Sep 21, 2012 · Sale reported, canceled · Built 1949 N8175MCessna 310I · S/N 310I0175Cancelled Jun 22, 2005 · Built 1964 · Akin Air Inc N3441APiper PA-22 · S/N 22-1713Cancelled Jul 27, 2004 · Built 1953 · Seale Forrest D N9304YBeech M35 · S/N D-6527Cancelled Aug 14, 2000 · Triennial form not returned · Lehman Hugh R N9455JPiper PA-28-180 · S/N 283568Cancelled Dec 10, 1997 · Workmam William S N238JFSchleicher ASW-20B · S/N 20623Cancelled Mar 25, 1991 · Triennial form not returned · Fee James A N586MAMooney M-20G · S/N 680008Cancelled Feb 10, 1982 · Exported to Germany · Ames Susan N3715APiper PA-22-135 · S/N 22-1955Cancelled Nov 16, 1977 · Wachocki Tadeusz J N19798Cessna 172M · S/N 17260761Cancelled Sep 16, 1977 · Built 1972 · Hawk Inc N3781YCessna 210D · S/N 21058281Cancelled Jun 2, 1975 · Sears James E Et Al N1957NCessna 140 · S/N 12193Cancelled Dec 30, 1970 · Wachocki Tadeusz J N3041Chaney EFG-1 · S/N 1Cancelled Jun 29, 1970 · Chaney William S N1211CPiper PA-22 · S/N 22-1024Cancelled Jun 19, 1970 · Spaulding Robert L Jr N4572VBeech 35 · S/N D-1403Cancelled Jan 26, 1966 · Bonanza Flyers Incorporated N1071CMooney M20A · S/N 1342Cancelled May 18, 1965 · Bonce Douglas S N90209Johnson ROCKET 185 · S/N 16Cancelled Oct 26, 1955 · Built 1946 · Lee Howard N75422Stinson V77 · S/N 77-364Cancelled Oct 24, 1955 · Howard Lee N32379Porterfield LP-65 · S/N 833Cancelled Oct 20, 1955 · Built 1940 · Miller Ralph N1256HAeronca 15AC · S/N 15AC-268Cancelled Jun 10, 1954 · E Miller Flock N18595Cessna C-37 · S/N 380Cancelled Nov 23, 1951 · Welch George W N5759HPiper PA-16 · S/N 16-371Cancelled Mar 9, 1951 · Los Alamos Clippers Inc N47971Fairchild M-62A · S/N T41-930Cancelled Oct 18, 1950 · Morris Carl R

Back to Los Alamos, NM