Skip to content

Cancelled registrations · 55

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 = 'FALLON' 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 = 'FALLON'
  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 = 'FALLON'
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.

N64BRPiper PA-31-350 · S/N 31-7752124Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1977 · Sefton Donald H N6532DCessna 172N · S/N 17272850Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 1979 · Lease Harold G N6328DCessna 172N · S/N 17272718Cancelled Jul 6, 2021 · Registration expired, pending cancellation · Built 1979 · Wardwell Walter L N4175VPiper PA-28-181 · S/N 2843126Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Innova Aero N1417EAeronca 7AC · S/N 7AC-4980Cancelled Aug 27, 2020 · Registration expired, pending cancellation · Built 1946 · Huntsman David M N3958RPiper PA-28-180 · S/N 28-7105063Cancelled Jan 17, 2020 · Sale reported, canceled · Built 1970 N7195ACessna 172 · S/N 29295Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Built 1956 · Gomes Charles F N116GEKrucker Manufacturing TUNDRA 912 · S/N KLM005Cancelled Sep 13, 2018 · Sale reported, canceled · Built 2004 N94483Aero Commander CALLAIR B-1 · S/N 10010Cancelled Apr 4, 2018 · Registration expired, pending cancellation · Built 1966 · Anderson William R N4773ECessna 172N · S/N 17271638Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1978 · Wardell Walter L N2072KLuscombe 8A · S/N 4799Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1947 · Marchant Harold M N320KPCessna 320D · S/N 320D0070Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1966 · Hook Luther H III N90KCessna 195A · S/N 7439Cancelled Mar 1, 2016 · Registration expired · Built 1949 · Turner Lawrence L N7920Beech D-45 · S/N BG-63Cancelled May 8, 2015 · Revoked, pending cancellation · Navy Fallon Flying Club N7840GCessna 172L · S/N 17259540Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1970 · York Ray W N74234Bellanca 14-13-2 · S/N 1347Cancelled May 4, 2015 · Registration expired, pending cancellation · Tarver Dalton K N91WRWalkling John L WINDROSE · S/N 180Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1991 · Conner Jerry L N272DBeech S35 · S/N D-7463Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1964 · Urquhart Dan DBA N9537GCessna A188B · S/N 18801518TCancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1974 · Frey Norman W N96253Taylorcraft BC12-D · S/N 8553Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1946 · Turk William E N4940BBeech C-50 · S/N CH-329Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1955 · White John Michael N3567VCessna 150M · S/N 15076549Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1975 · Luhrs Steven A N8321ACessna 170B · S/N 25173Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1952 · Koecke; Henry J N59STThornton Stephen V PULSAR · S/N 250Cancelled Aug 29, 2013 · Sale reported, canceled N86677Beech Baby Ace C · S/N EB-101Cancelled Aug 22, 2013 · Sale reported, canceled N836VVElrod Clifford E VARI VIGGEN · S/N 359Cancelled Aug 13, 2013 · Sale reported, canceled N16228Bell TH-13T · S/N 6717096Cancelled Jul 30, 2013 · Sale reported, canceled N81610Alexander Duane A RV-8 · S/N 80175Cancelled Jul 8, 2013 · Built 1999 · Whitt Robin D N97324Stinson 108 · S/N 108-324Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1946 · Fisk Richard E N8178VCessna A188 · S/N 188-0428Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1968 · Turner Lawrence DBA N7332KPiper PA-20 · S/N 20-242Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1950 · Lahonton Valley Broadcasting Co N688CTGolden Circle T-BIRD II · S/N RT4731Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Built 1992 · Tolley Randy J N84755Aeronca 7AC · S/N 7AC-3468Cancelled Nov 13, 2012 · Sale reported, pending cancellation · Built 1946 N28852Luscombe 8A · S/N 1594Cancelled Jul 23, 2009 · Registration revoked · Built 1940 · Boak William L N3936DCessna 182A · S/N 34636Cancelled May 7, 2008 · Built 1957 · Landry Paul G N4081WPiper PA-32-300 · S/N 3240127Cancelled Dec 11, 1996 · Triennial form not returned · Wight Leonard E N1234MCessna 182F · S/N 18254577Cancelled Apr 29, 1995 · Triennial form not returned · Carey Transport N8360ZCessna 210-5(205) · S/N 2050360Cancelled Jun 29, 1994 · Triennial form not returned · Heaverne Clifford J N2399QBeech 23 · S/N M478Cancelled Jan 15, 1993 · Triennial form not returned · Leatherdale Richard E N80873Cessna A185F · S/N 18503140Cancelled Oct 9, 1992 · Exported to Canada · Mountain Air N6282PPiper PA-24-250 · S/N 241392Cancelled Oct 2, 1992 · Triennial form not returned · Stelling Donald E N8176WPiper PA-28-180 · S/N 282300Cancelled Feb 12, 1991 · Triennial form not returned · Calkins Dean N925RZBeech A23A · S/N M-969Cancelled Oct 2, 1982 · Administratively canceled · Kecle Donald E N761EFCessna T210M · S/N 21062192Cancelled Mar 23, 1982 · Hammond Jon G N21JLLingwall-Stitts SA-3B · S/N P214Cancelled Jun 3, 1981 · Built 1970 · Lattin Albert H N379ZBeech 35 · S/N D-1242Cancelled May 25, 1976 · Sale reported · Built 1948 N68904Taylorcraft DC-65 · S/N 6019Cancelled Mar 13, 1972 · Built 1945 · Main William A N5138TChampion 7GCAA · S/N 123Cancelled Jan 25, 1971 · Manha Maurice J N96811Taylorcraft BC12-D · S/N 9111Cancelled Dec 17, 1964 · Lhugh Hutchins N32837Piper J3C-65 · S/N 5645Cancelled Jun 30, 1959 · Doren B Deneal

Back to Fallon, NV