Skip to content

Cancelled registrations · 46

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

N395WMMejia Angel O CHALLENGER II · S/N 1337Cancelled Nov 11, 2023 · Sale reported, canceled N95MLHerbison Alan S HERBISON CHALNGER II · S/N 000951Cancelled Nov 11, 2023 · Sale reported, canceled N63874Dean Bernard E F4U-1B · S/N 11Cancelled Apr 5, 2023 · Built 2002 · Coghill David K N662RDRobinson Helicopter R66 · S/N 0934Cancelled Mar 20, 2023 · Exported to Australia · Built 2019 · Carolina Kidney And Vascular Pa N381TWilliams WXB · S/N 1Cancelled May 7, 2022 · Registration expired, pending cancellation · Built 1964 · Foundation Of Wayne Community College Inc N779AWBell OH-58C · S/N 68-16726Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Nc Wayne County Sheriffs Office N508RDDunmire Properties LANCAIR EVOLUTION · S/N EVO-0048Cancelled Oct 12, 2021 · Exported to Canada · Built 2013 · Dunmire Properties LLC N5981HPiper PA-16 · S/N 16-608Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1949 · Foundation Of Wayne Community College Inc N9179RA1jack Gyrocopter MARK · S/N 1Cancelled Sep 6, 2019 · Revoked, canceled · Built 1960 · Armstrong John C N97151Stinson 108 · S/N 108-151Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1946 · Foundation Of Wayne Community College Inc N81433Aeronca 7AC · S/N 7AC51Cancelled Mar 19, 2019 · Revoked, canceled · Built 1945 · Goldsboro Flyers N995SABeech A100 · S/N B246Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1979 · Spitfire Sales And Leasing Inc N6930BPiper PA-22-150 · S/N 22-4208Cancelled Feb 4, 2017 · Revoked, canceled · Built 1956 · Dew Jerry Glenn N5170FCessna 172F · S/N 17253068Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1965 · United States Air Force Owner N2647WMooney M20C · S/N 3306Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1966 · Pitts Larry Glenn N6258SCessna 150G · S/N 15067058Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Built 1967 · Keen Sherrill R N14WCAero Commander 560-A · S/N 269Cancelled Aug 6, 2013 · Registration expired, pending cancellation · Built 1955 · Wayne Community College N41884Ercoupe 415-C · S/N 114Cancelled Nov 20, 2012 · Registration expired, pending cancellation · Built 1945 · Goldsboro Aerial Crop Spraying Svc N1140VHahn Louis KR2 · S/N 8780Cancelled Aug 6, 2012 · Registration pending, canceled · Built 1997 N142RVHam Darrell RV-7 · S/N 70023Cancelled Dec 28, 2011 · Exported to South Africa · Built 2003 · Ham Darrell N187WSSavage William Raymond RV-8 · S/N 80615Cancelled Jun 13, 2008 · Triennial form not returned · Built 2004 · Savage William R N112PEAllen R W/Edmundson W H 2/3 EARLYBIRD JENNY · S/N AE-001Cancelled Nov 29, 2006 · Triennial form not returned · Built 2003 · Allen Ronnie W N4703PPiper PA-23-250 · S/N 27-231Cancelled Sep 19, 2003 · Triennial form not returned · Built 1960 · Wayne Community College N5405Sikorsky UH-34D · S/N 147183Cancelled May 5, 1999 · Triennial form not returned · Wayne Community College N41GFCessna 150J · S/N 15069965Cancelled Jan 8, 1993 · Triennial form not returned · Grantham Aero Club N63116Cessna 150M · S/N 15077114Cancelled Nov 20, 1992 · Exported to Germany · Brewster Albert L N6431JPiper PA-28-180 · S/N 284849Cancelled Jan 31, 1991 · Thompson Chester Idell N704MWCessna 150M · S/N 15078729Cancelled Apr 4, 1990 · Triennial form not returned · Flying Bisons N3641JCessna 150G · S/N 15064941Cancelled Nov 10, 1983 · Built 1966 · Flying Bisons Club N3969NMooney M-20G · S/N 680070Cancelled Jul 24, 1978 · Exported to Germany · Immler Charles W Jr N3754Beech UC-45J · S/N 67200Cancelled Jun 2, 1975 · Wayne Community College N4681SBeech C18S · S/N 39228Cancelled May 28, 1974 · Wayne Community College N5167TChampion 7ECA · S/N 171Cancelled Oct 1, 1973 · Goldsboro-Wayne Aviation Inc N9177RBeech A45 · S/N 34-104Cancelled Jan 12, 1971 · United States Air Force N5683Beech C-45 · S/N 44-5683Cancelled Oct 28, 1969 · Wayne Community College N3549MPiper PA-12 · S/N 12-2394Cancelled Sep 19, 1969 · Exported to Canada · Lancaster James W N94021Ercoupe 415-C · S/N 1344Cancelled Apr 21, 1966 · Elmer Albert Miller III N45951Luscombe 8A · S/N 2478Cancelled Aug 21, 1964 · Billy F Sparks N5182HPiper PA-14 · S/N 14-500Cancelled Jan 31, 1962 · Exported to South Africa · Stevens Harold J N52751Boeing PT-13B · S/N 75-283Cancelled Jan 20, 1956 · Exported to Peru · Lowers Jack N52843Boeing PT-13B · S/N 75-216Cancelled Jan 20, 1956 · Exported to Peru · Lowers Jack N2056Travel Air 4000 · S/N 184Cancelled Dec 16, 1954 · Built 1928 · Vaughan Asahel William N25855Piper J3L · S/N 3805Cancelled Aug 24, 1954 · Built 1939 · Rose Milton J Et Al N93510Ercoupe 415-C · S/N 833Cancelled Apr 15, 1948 · Built 1946 · Goldsboro Aero Service N18519Arrow F · S/N 62Cancelled Sep 29, 1947 · Built 1937 · Grant Gereld L N22189Aeronca 50-C · S/N C-2939Cancelled Sep 24, 1939 · Built 1939 · Harrell Leon J

Back to Goldsboro, NC