Skip to content

Cancelled registrations · 98

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 = 'NV' AND d.registrant_city = 'SPARKS' 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 = 'NV' AND d.registrant_city = 'SPARKS'
  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 = 'NV' AND d.registrant_city = 'SPARKS'
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.

N7340QCessna 182P · S/N 18260980Cancelled Oct 20, 2026 · Sale reported, canceled · Built 1972 N747USBoeing 747-8B5 · S/N 40905Cancelled Sep 25, 2025 · Built 2015 · Sierra Nevada Company LLC N590QPPolskie Zaklady Lotnicze Spzoo PZL M28 05 · S/N AJE00343Cancelled Aug 25, 2025 · Built 2015 · Sierra Nevada Corp N810LMCessna 172RG · S/N 172RG0386Cancelled Jan 14, 2023 · Registration expired, pending cancellation · Built 1980 · Aircraft Parts Warehouse LLC N50BCMaule M-4-210C · S/N 1111CCancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1973 · Loken Trygve N13NZNicholas Audenried KITFOX S7 SUPER SPOR · S/N KA18031360Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 2018 · Audenried Nicholas M N71SKKingman Stuart K LANCAIR 235 · S/N 283Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1999 · Read Gregory C N156SDAntares USA MA-32-R582 · S/N 0302Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Diaz David M N351SFBeechcraft B300 · S/N FL-924Cancelled Dec 9, 2020 · Built 2014 · Sierra Nevada Corp N774SCClyatt William S SIX CHUTER SPIRIT · S/N 2800Cancelled Feb 28, 2020 · Sale reported, canceled · Built 2002 N23LSStemme S6-RT · S/N 027Cancelled Dec 20, 2019 · Exported to Turkey · Built 2013 · Straight Flight Nevada Commercial Leasing LLC N846RESensefly EBEE RTK · S/N EB-01-23715Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Robison Engineering Co Inc N9220XCessna 182E · S/N 18253620Cancelled Jul 2, 2019 · Revoked, pending cancellation · Built 1961 · Sparks Flying Service N646VVDJI INSPIRE 1 · S/N W13DCB12020014Cancelled May 6, 2019 · Registration expired, pending cancellation · Venture Capital LLC N5557BMikoyan Gurevich MIG 15UTI · S/N 1A512032Cancelled Mar 9, 2019 · Registration expired, pending cancellation · Austin Fred L N13CGCessna 310R · S/N 310R0115Cancelled Jan 14, 2019 · Sale reported · Built 1974 N7066UGreen Harry C CHALLENGER I · S/N 0196Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 2007 · Green Lawrence H N9606MMooney M20F · S/N 670183Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1966 · Brown Gary L N3030TBartmess James M PC-1 · S/N 1Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Bartmess James M N10772Cessna 150L · S/N 15075025Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1973 · Schaeffer Andrew R N49115Grumman HU-16 · S/N 51-7240Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1951 · Parsons John N65PLCessna 177B · S/N 17701815Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1972 · Haisfield Jeffrey N6403SAerostar International S-60A · S/N S60A-3034Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1986 · Gray Jerry L N9020BAeronca 7FC · S/N 7FC114Cancelled Feb 4, 2017 · Revoked, canceled · Built 1957 · Sparks Flying Svc N896FLBeechcraft B300 · S/N FL-896Cancelled Sep 23, 2016 · Exported to Turkey · Built 2013 · Sierra Nevada Corp N58755Boeing B75N1 · S/N 75-6978Cancelled Aug 23, 2016 · Built 1942 · Stangel Margaret H N1019PSindelar John REVOLUTION MINI 500 · S/N 0282Cancelled Aug 17, 2016 · Third renewal notice · Kent James S N625BBeech D18S · S/N A-507Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1949 · Air Museum N8085MCessna 310I · S/N 310I0085Cancelled Apr 27, 2015 · Registration expired, pending cancellation · Built 1964 · Cloudbuster Aviation Co N305STPolskie Zaklady Lotnicze Spzoo PZL M28 05 · S/N AJE00305Cancelled Dec 24, 2014 · Exported to Guyana · Built 2004 · Straight Flight Nevada Commercial Leasing LLC N14KDPiper PA-34-200T · S/N 34-7870072Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1977 · Flower Stanley D N63353Cessna 150M · S/N 15077257Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1975 · Tronier Bruce C N48890Cessna 152 · S/N 15281032Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1977 · Dawson John A N356PHDehavilland DHC-8-202 · S/N 502Cancelled Jun 16, 2014 · Built 1997 · Airborne Services Global II LLC N4301VCessna 195 · S/N 7205Cancelled Apr 28, 2014 · Exported to Netherlands · Built 1948 · Lamski Eugene R Trustee N9244RCessna TR182 · S/N R18200672Cancelled Jan 17, 2014 · Exported to Mexico · Built 1979 · Cordova Jon T Trustee N66348Beech 76 · S/N ME-244Cancelled Sep 30, 2013 · Sale reported, canceled · Built 1979 N686PDDay Paull M STITS SA6B · S/N 1Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1986 · Nilsson William A N155CBCameron Balloons V-56 · S/N 415Cancelled Sep 25, 2013 · Registration expired, pending cancellation · Built 1979 · Balloons & Airships West N13KBCameron Balloons O-84 · S/N 157Cancelled Aug 5, 2013 · Registration expired, pending cancellation · Built 1975 · Balloons & Airships West N4081KCall David A PARAGREN II · S/N 002Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Call David A N24SJEuler-Crane MONERAI-S · S/N 0024Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Euler James J N87YAAero Commander 680-E · S/N 680-514-184Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1957 · Paullo James E N8682ABeech A35 · S/N D-2092Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1949 · Kraus John L Jr N8770MBeech A23 · S/N M-555Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1964 · Koch Claire L N80LLCessna 172M · S/N 17264922Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1975 · Hargett Christine L N7036GBeech A35 · S/N D-1542Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1948 · Reynolds Ed N12BGHayes BRIEGLEB BG12BD · S/N 1Cancelled Apr 10, 2013 · Registration expired, pending cancellation · Built 1972 · Hayes Charles A N5173RCessna TR182 · S/N R18200638Cancelled Apr 1, 2013 · Registration expired, pending cancellation · Built 1978 · Davco N917CStinson 108-3 · S/N 108-3917Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1947

Back to Sparks, NV