Skip to content

Morrisville, NC

Cancelled registrations · 30

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

N416BLDiamond Aircraft Ind DA 40 NG · S/N 40.NC086Cancelled Feb 26, 2024 · Exported to Taiwan · Built 2019 · Blue Line Aviation LLC N4113SDiamond Aircraft Ind DA20-C1 · S/N C0473Cancelled Aug 28, 2020 · Exported to Canada · Built 2007 · Blue Line Aviation LLC N939AFDiamond Aircraft Ind DA20-C1 · S/N C0208Cancelled Jan 23, 2020 · Exported to Canada · Built 2003 · Blue Line Aviation LLC N391JADiamond Aircraft Ind DA20-C1 · S/N C0201Cancelled Apr 29, 2019 · Exported to Canada · Built 2002 · Berry Stephen B N7783DPiper PA-18 · S/N 18-5974Cancelled Feb 4, 2017 · Revoked, canceled · Built 1957 · Gunter H D N357RAS.O.C.A.T.A. RALLYE 235E · S/N 13148Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Rallye Aircraft Corp N28990Gulfstream American AA-5B · S/N AA5B0925Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1978 · Wra Inc N7498SSmith AEROSTAR 600 · S/N 60-0049-110Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1970 · W R A Inc N5890Johnson SKYBIRD · S/N AJ001Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Johnson Alan M N576BBeech 65-80 · S/N LD-94Cancelled Sep 25, 2012 · Sale reported, pending cancellation · Built 1963 N19PPHubbell Wheeler L MD PRESCOTT PUSHER · S/N 09Cancelled Feb 3, 2012 · Third renewal notice · Built 1990 · Air Dat LLC N26171Grumman American Avn. AA-5A · S/N AA5A0463Cancelled Jul 13, 1994 · Second triennial mailing, no response · Ram Air Freight Inc N26312Grumman American Avn. AA-5A · S/N AA5A0521Cancelled Jul 13, 1994 · Second triennial mailing, no response · Ram Air Freight Inc N21211Cessna 182P · S/N 18261490Cancelled Mar 18, 1991 · Exported to Tanzania · Ram Air Freight Inc N49472Cessna 152 · S/N 15281295Cancelled Jul 29, 1980 · Exported to Canada · Built 1978 · Raleigh Durham Aviation Inc N354RAS.O.C.A.T.A. MS RALLYE 235C · S/N 13261Cancelled Jul 23, 1980 · Exported to Sweden · Built 1979 · Rallye Aircraft Corp N351RAS.O.C.A.T.A. MS893E · S/N 13179Cancelled Jun 26, 1980 · Exported to Canada · Rallye Aircraft Corp N358RAS.O.C.A.T.A. RALLYE 235E · S/N 13149Cancelled Jun 17, 1980 · Exported to France · Built 1979 · Rallye Aircraft Corp N359RAS.O.C.A.T.A. RALLYE 235E · S/N 13150Cancelled Jun 16, 1980 · Exported to France · Rallye Aircraft Corp N12642Cessna 172M · S/N 172-62137Cancelled Feb 25, 1975 · Exported to Canada · Raleigh-Durham Aviation Inc N6417JPiper PA-28-180 · S/N 28-4834Cancelled Sep 4, 1974 · Exported to Australia · Raleigh Durham Aviation Inc N5975UPiper PA-28-140 · S/N 28-26512Cancelled Sep 3, 1974 · Exported to Australia · Raleigh-Durham Aviation Inc N53041Cessna A185F · S/N 18502332Cancelled Aug 14, 1974 · Exported to Paraguay · Raleigh Durham Aviation Inc N4130QCessna 310N · S/N 310N-0030Cancelled Feb 14, 1974 · Exported to Australia · Raleigh-Durham Aviation Inc N71ACWatts GRUDIEAIRE G-20 · S/N 2245Cancelled Oct 30, 1973 · Cudney Albert W N2887QCessna 172L · S/N 172-59887Cancelled Feb 14, 1973 · Exported to Canada · Raleigh Durham Aviation Inc N4757Cudney-Bensen B8MJG · S/N 637Cancelled Jan 21, 1971 · Albert Wilson Cudney N4683SBensen B-8M · S/N 12345Cancelled Dec 4, 1970 · Cudney Albert W N6902WPiper PA-28-140 · S/N 28-21066Cancelled Jan 26, 1966 · Raleigh Durham Aviation Inc N5478WPiper PA-28-160 · S/N 28-561Cancelled Oct 29, 1963 · Carolina Air Traders Inc

Back to Morrisville, NC