OpenAirDocs.org
Las Vegas, NM

Cancelled registrations · 41

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

N31MXAlexander Schleicher ASH 31 MI · S/N 31003Cancelled Feb 7, 2018 · Second renewal notice · Built 2010 · Holliday Robert RN3951FPiper PA-31T · S/N 31T-7520010Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1975 · Barron Thomas Aviation IncN7178ACessna 172 · S/N 29278Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1956 · Barron Thomas Aviation IncN1QEBeech B50 · S/N CH-100Cancelled Aug 28, 2014 · Registration expired, pending cancellation · Built 1954 · Barron Thomas Aviation IncN754BBeech D50A · S/N DH-156Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Barron Thomas AviationN76007Beech B50 · S/N CH-59Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Built 1954 · Barron Thomas Aviation IncN411HGCessna 411 · S/N 411-0109Cancelled Aug 14, 2013 · Registration expired, pending cancellation · Built 1965 · Barron Thomas Aviation IncN14234Handley Page HP-137 MK1 · S/N 234Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1969 · Barron Thomas Aviation IncN318EBeech 95-C55 · S/N TE-368Cancelled Feb 25, 2013 · Registration expired, pending cancellation · Built 1967 · Barron Thomas Aviation IncN3816CAero Commander 500 · S/N 706Cancelled Nov 13, 2012 · Registration expired, pending cancellation · Built 1959 · Barron Thomas Aviation IncN21AKAero Commander 1121 · S/N 59Cancelled Aug 23, 2012 · Registration expired, pending cancellation · Built 1966 · Barron Thomas Aviation IncN105LVPiper PA-42-1000 · S/N 42-5527010Cancelled Nov 29, 2005 · Exported to Sweden · Bank Of Las VegasN4654PPiper PA-23-250 · S/N 27-177Cancelled Mar 8, 2002 · Triennial form not returned · Built 1960 · Barron Thomas Aviation IncN2840LCessna 172H · S/N 17256040Cancelled Oct 26, 1998 · Triennial form not returned · Rising Sun Enterprises TrustN410HBeech 65 · S/N LC167Cancelled Jan 13, 1994 · Triennial form not returned · Barron Thomas Aviation IncN6144XAero Commander 680-F · S/N 680F94516Cancelled Jan 13, 1994 · Triennial form not returned · Barron Thomas Aviation IncN89MRAero Commander 1121 · S/N 11219Cancelled Jan 13, 1994 · Triennial form not returned · Barron Thomas Aviation IncN8155ACessna T-310P · S/N 310P0032Cancelled Oct 26, 1993 · Triennial form not returned · Barron Thomas Avn IncN1213Handley Page HP-137 MK1 · S/N 213Cancelled Oct 20, 1993 · Triennial form not returned · Barron Thomas Avn IncN21PCMitsubishi MU-2B-25 · S/N 295Cancelled Oct 20, 1993 · Triennial form not returned · Barron Thomas Aviation IncN245MAMitsubishi MU-2B-35 · S/N 576Cancelled Oct 20, 1993 · Triennial form not returned · Barron Thomas Aviation Inc.N26CAPiper PA-31T · S/N 31T7820062Cancelled Oct 20, 1993 · Triennial form not returned · Barron Thomas Aviation Inc.N346KMitsubishi MU-2B-25 · S/N 292Cancelled Oct 20, 1993 · Triennial form not returned · Barron Thomas Avn IncN3560XMitsubishi MU-2B · S/N 029Cancelled Oct 20, 1993 · Triennial form not returned · Barron Thomas Aviation IncN400KKMitsubishi MU-2B-15 · S/N 118Cancelled Oct 20, 1993 · Triennial form not returned · Barron Thomas Aviation IncN55PCMitsubishi MU-2B-20 · S/N 146Cancelled Oct 20, 1993 · Triennial form not returned · Barron Thomas Aviation IncN852HCessna T310Q · S/N 310Q0519Cancelled Oct 20, 1993 · Triennial form not returned · Barron Thomas Aviation IncN866KBeech 65-A90 · S/N LJ76Cancelled Oct 19, 1993 · Barron Thomas Aviation IncN45CMAero Commander 680FL P · S/N 150117Cancelled Aug 12, 1993 · Exported to Mexico · Barron Thomas Aviaton IncN5002Piper PA-31-325 · S/N 317812128Cancelled Dec 13, 1991 · Exported to Chile · Barron Thomas Aviation IncN860KBeech 65-A90 · S/N LJ122Cancelled May 24, 1991 · Exported to Honduras · Barron Thomas Aviation IncN9400CCessna 180 · S/N 31798Cancelled Dec 16, 1971 · Southwest Broadcasters IncN64FBeech C35 · S/N D-3133Cancelled Feb 17, 1971 · Manlove EarlN5558BCessna 182 · S/N 33558Cancelled Aug 28, 1970 · Conkling Randall M& Hallford J CarlN9501ZBeech C-45H · S/N 51-11684Cancelled Dec 27, 1960 · Exported to Mexico · Dillon JackN2569DCessna 170B · S/N 20721Cancelled Jun 23, 1958 · Bible Flying ServiceN15210Waco YOC · S/N 4298Cancelled Feb 1, 1956 · New Mexico Highlands UniversityN1420DCessna 170A · S/N 20133Cancelled Jan 24, 1956 · Thrasher A LN5454CCessna 170A · S/N 19488Cancelled Apr 15, 1953 · Bible Flying ServiceN92233Piper J3C-65 · S/N 16676Cancelled May 5, 1949 · Watson J BN12219Harvey B Taylor THUNDERBIRD · S/N 1Cancelled Jul 19, 1948 · Mexico State Department Of Vocational Education
Back to Las Vegas, NM