Skip to content

Cancelled registrations · 34

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 = 'NC' AND d.registrant_city = 'SALISBURY' 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 = 'NC' AND d.registrant_city = 'SALISBURY'
  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 = 'NC' AND d.registrant_city = 'SALISBURY'
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.

N92ALLand Raymond Alan EXEC 162 F · S/N 6619Cancelled Jan 17, 2023 · Sale reported, canceled N3151VBeech 35 · S/N D-581Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Built 1949 · Astraeos Aviation LLC N10003Charles N Campbell PIETENPOL AIRCAMPER · S/N 1Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Campbell Charles N N193CTCat CAT AVIATION-A · S/N 001Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Built 2009 · Kluttz Robert T N629CDBeech 65-A90 · S/N LJ-173Cancelled Jun 15, 2020 · Exported to Mexico · Built 1966 · Piedmont Skydiving Center LLC N2000RCessna 182G · S/N 18255200Cancelled Jun 18, 2018 · Registration pending, canceled · Built 1963 N9208ZMacnutt William Phillip YOST 1 · S/N 001Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Macnutt William Phillip N2648PPiper PA-22-150 · S/N 22-2986Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 1955 · Sifford Steve M N7103LGrumman American Avn. AA-5 · S/N AA5-0403Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 1973 · Adkins David N N10WWPiper PA-32R-300 · S/N 32R-7680319Cancelled Aug 4, 2015 · Exported to Curacao · Built 1976 · Gold Star Aviation Inc N1120VBeech D17S · S/N 6734Cancelled Jun 7, 2013 · Sale reported, canceled · Built 1944 N7687TCessna 172A · S/N 47287Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1960 · Coop Phil O N3180HErcoupe 415-C · S/N 3805Cancelled Sep 27, 2012 · Registration expired, pending cancellation · Built 1946 · Johnson Allen S Jr N71437Mullis Curtis SCORPION II · S/N 1946Cancelled Oct 7, 2009 · Second triennial mailing, no response · Mullis Curtis N4031RPiper PA-32-300 · S/N 32-40327Cancelled Apr 18, 2002 · Second triennial mailing, no response · Built 1967 · Lawson William B N6588SBeech 58TC · S/N TK4Cancelled Oct 6, 1994 · Triennial form not returned · Donald L Weinhold P A N5854ZPiper PA-22-108 · S/N 22-9710Cancelled Aug 24, 1982 · Overcash Jerry L N8866BCessna 172 · S/N 36566Cancelled Mar 3, 1982 · Wilkerson Johnny William Sr N4756XCessna 150G · S/N 15064806Cancelled May 6, 1981 · Swain Clay S N22HDCessna 337D · S/N 337-1039Cancelled Oct 24, 1978 · Exported to Chile · Coffman Earl N201FHMooney M20J · S/N 240153Cancelled Aug 8, 1978 · Howell Frank W Jr N6020Bensen GYROCOPTER B-8M · S/N 224-05-7652Cancelled Apr 24, 1974 · Crane John C N7910WPiper PA-28-180 · S/N 28-1943Cancelled Jun 30, 1970 · Salisbury Aircraft Inc N5466DBeech H35 · S/N D-4984Cancelled Apr 13, 1970 · Miller Equipment Co N49749Aeronca L-3C · S/N 058B7622Cancelled May 20, 1965 · Brown George K N17280Piper J-2 · S/N 946Cancelled Oct 6, 1955 · Salisburyaircraft Service N55871Consolidated Vultee BT-13A · S/N 3112Cancelled Jan 26, 1954 · John A Noble N2540HEngineering & Research ERCOUPE 415-C · S/N 3165Cancelled Sep 8, 1950 · Built 1946 · Salisbury Aircraft Service N99804Erco 415-C · S/N 2427Cancelled May 19, 1949 · Salisbury Aircraft Service N2466HEngineering & Research ERCOUPE 415-C · S/N 3091Cancelled Nov 8, 1948 · Built 1946 · Salisbury Aircraft Service N2206HEngineering & Research ERCOUPE 415-C · S/N 2829Cancelled Apr 20, 1948 · Built 1946 · Salisbury Aircraft Service N990HStar CAVALIER · S/N 109Cancelled Oct 21, 1937 · E H Brockenbrough N835KGreat Lakes 2T-1A · S/N 96Cancelled May 22, 1935 · Lybrook William R N9603JPiper PA-28-180 · S/N 28-3749Cancellation date not recorded · Built 1966 · Swaim Clay S

Back to Salisbury, NC