Skip to content

Cancelled registrations · 71

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 = 'MS' AND d.registrant_city = 'GREENVILLE' 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 = 'MS' AND d.registrant_city = 'GREENVILLE'
  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 = 'MS' AND d.registrant_city = 'GREENVILLE'
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.

N164RBDJI AGRAS T40 · S/N 64TBL4A002002SCancelled Aug 10, 2024 · Sale reported, canceled N479JJJewell Jacob L RV 4 · S/N 79Cancelled Oct 13, 2022 · Sale reported, pending cancellation · Built 2001 N793AGDJI PHANTOM 3 PROFESSION · S/N P76DCJ21A21043Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Greenville Fire Department N52500Taylorcraft DC-65 · S/N 4280Cancelled Dec 10, 2019 · Revoked, pending cancellation · Built 1942 · Flying Fifteen Aero Club N3227NPiper J3C-65 · S/N 22418Cancelled Apr 22, 2019 · Revoked, canceled · Built 1946 · Russmam Frank N5577HPiper PA-11 · S/N 111103Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Ford Allen N24535Piper J3L · S/N 3245Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1939 · Ford Walter A N84414Aeronca 7AC · S/N 7AC3095Cancelled Apr 6, 2018 · Revoked, canceled · Built 1946 · Central Base Fund N98587Piper J3C-65 · S/N 18807Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1946 · Ford Walter A N28212Piper J4A · S/N 4-1138Cancelled Nov 22, 2017 · Revoked, canceled · Built 1940 · Drummond Pete N635MCCotton-Marvin PDQ-2 MODEL C · S/N MC-1Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1980 · Cotton Marvin N70152Piper J3C-65 · S/N 17137Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1946 · Huntley Blythe E DBA N2342TPiper PA-28-180 · S/N 28-7105211Cancelled Aug 13, 2013 · Sale reported, canceled · Built 1971 N78592Piper PA-12 · S/N 12-3958Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1947 · Herren Julian N1896RRaven Industries RX6 · S/N RX6-280Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1978 · Holman David E N108KTBrent Jesse/Collins MONI · S/N 00107Cancelled Apr 8, 2013 · Registration expired, pending cancellation · Brent Collins E N57930Boeing A75L3 · S/N 75-4782Cancelled Feb 21, 2013 · Revoked, canceled · Built 1943 · Abide Aero Farm Svc Inc N25356Cessna 152 · S/N 15280611Cancelled Jan 22, 2013 · Third renewal notice · Built 1977 · Thedford Aero Inc N4011SAyres S2R-600 · S/N 2541RCancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1979 · Aircraft Rentals Inc N5093HPiper PA-11 · S/N 11-995Cancelled Sep 5, 2012 · Registration pending, canceled · Built 1949 N8946QAero Commander S2R · S/N 1616RCancelled Aug 23, 2012 · Registration pending, canceled · Built 1972 N2420ZPiccard AX-6 · S/N 420Cancelled Aug 14, 2012 · Sale reported, canceled · Built 1977 N5167NBoeing N2S-3 · S/N 757763Cancelled Aug 13, 2012 · Revoked, canceled · Ours J B N9956UGrumman American Avn. AA-5A · S/N AA5A0356Cancelled Jan 12, 2001 · Triennial form not returned · Cheetah Aviation Inc N4280YIngram Robert S QCKSLVR MXL II SPRT · S/N 000569Cancelled May 13, 1998 · Triennial form undeliverable · Ingram Robert S N1710EClements Eugene PULSAR · S/N 171Cancelled Aug 20, 1997 · Triennial form not returned · Clements Eugene N8380GCessna 150F · S/N 15062480Cancelled Mar 24, 1997 · Hays John E N4246XRockwell International S-2R · S/N 2022RCancelled Apr 11, 1996 · Exported to Canada · C & J Equipment Inc N1198ZAmerican General Acft AG5B · S/N 10174Cancelled Jan 21, 1994 · Exported to Germany · Spragins Hal S III N11986American General Acft AG5B · S/N 10173Cancelled Nov 24, 1993 · Exported to Germany · American General Aircraft Corp N1194GAmerican General Acft AG5B · S/N 10078Cancelled Sep 1, 1993 · Exported to Germany · American General Aircraft Corp N1198EAmerican General Acft AG5B · S/N 10158Cancelled Aug 31, 1993 · Exported to Germany · Spragins Hal S III N1198NAmerican General Acft AG5B · S/N 10161Cancelled Aug 31, 1993 · Exported to Germany · Spragins Hal S III N1198GAmerican General Acft AG5B · S/N 10159Cancelled Aug 4, 1993 · Exported to Germany · Spragins Hal S III N18FAAmerican General Acft AG5B · S/N 10136Cancelled Jan 19, 1993 · Exported to Thailand · American General Aviation N100AGAmerican General Acft AG5B · S/N 10099Cancelled Jul 24, 1992 · Exported to Spain · American General Aircraft Corp N1195FAmerican General Acft AG5B · S/N 10091Cancelled Feb 20, 1992 · Exported to Spain · American General Aircraft Corp N1194YAmerican General Acft AG5B · S/N 10086Cancelled Nov 29, 1991 · Exported to Sweden · American General Aircraft Corp N4273ABoeing E75N1 · S/N 75-5540Cancelled May 29, 1991 · Exported to United Kingdom · Abide Lee C N865KGreat Lakes 2T-1(MENASCO SPECIAL · S/N 126Cancelled Jan 26, 1990 · Exported to United Kingdom · Abide Lee C Jr N9964GCessna A188A · S/N 18800764Cancelled Feb 14, 1985 · Administratively canceled · Thedford Aero Inc N5029UBellanca 8KCAB · S/N 44778Cancelled Jan 17, 1983 · Exported to Chile · Abide Aero Corp N4006SAyres S2R-600 · S/N 2497RCancelled Apr 27, 1979 · Exported to Costa Rica · Abide Aero Corp N82319Piper PA-25-235 · S/N 25-7656077Cancelled Nov 22, 1978 · Exported to Honduras · Built 1976 · Abide Aero Corporation N9615PPiper PA-25-235 · S/N 25-7656009Cancelled Dec 20, 1977 · Exported to Honduras · Abide Aero Corp N82359Piper PA-25-235 · S/N 25-7656107Cancelled Nov 16, 1977 · Exported to Honduras · Built 1976 · Abide Aero Corporation N82373Piper PA-25-235 · S/N 25-7656110Cancelled Nov 16, 1977 · Exported to Honduras · Built 1976 · Abide Aero Corporation N82399Piper PA-25-235 · S/N 25-7656117Cancelled Nov 14, 1977 · Exported to Honduras · Abide Aero Corp N8193DPiper PA-18A 150 · S/N 18-6131Cancelled Jan 20, 1976 · Lancaster Stanley P N16561Piper PA-28-140 · S/N 28-7325299Cancelled Dec 12, 1975 · Exported to Canada · C G Air Center Inc

Back to Greenville, MS