OpenAirDocs.org
Alexandria, LA

Cancelled registrations · 61

Query with SQL
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 = 'LA' AND d.registrant_city = 'ALEXANDRIA'
  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.

N521LCCirrus Design SR22 · S/N 2007Cancelled Sep 7, 2023 · Exported to Bahamas · Built 2006 · Gauthier JonasN6461JPiper PA-28-180 · S/N 28-4884Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 1968 · Cooper BenjaminN25237Socata TB 10 · S/N 980Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 1990 · Cenlair LLCN46738Piper J-3C · S/N 10627Cancelled Feb 28, 2020 · Revoked, canceled · Built 1943 · Myers W HN6082HPiper J-3C · S/N 19236Cancelled May 4, 2019 · Revoked, pending cancellation · Built 1946 · Lovette B RN2135VBryan L Bossier SR JA30 · S/N JA 410-09-14Cancelled Dec 15, 2018 · Registration expired, pending cancellation · Built 2015 · Eutychus Air LLCN57957Boeing A75N1(PT17) · S/N 75-4825Cancelled May 30, 2018 · Sale reported, canceledN64983Boeing A75N1(PT17) · S/N 752594Cancelled Apr 5, 2018 · Revoked, canceled · Built 1941 · Perroux Joseph W JrN6396ATassin David Wayne LANCAIR 320/360 · S/N 934-320-774SFBCancelled Jan 5, 2018 · Registration expired, pending cancellation · Tassin David WN35660Piper J3L · S/N 6519Cancelled Nov 18, 2017 · Revoked, canceled · Built 1941 · Lovette B RN3345APiper PA-22-135 · S/N 22-1622Cancelled Oct 28, 2017 · Revoked, canceled · Built 1953 · Beard Charles MillerN96023Taylorcraft BC12-D · S/N 8323Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1946 · French Harry E JrN2507VBrown John SEADRAGON · S/N 0001Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Brown John CN4294ZPiper PA-18-150 · S/N 18-8543Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1967 · Lovette B RN2936GCallair A-5 · S/N 291Cancelled Feb 4, 2017 · Revoked, canceled · Built 1959 · Planters Dusting CoN501BECessna 501 · S/N 501-0263Cancelled Aug 31, 2015 · Built 1977 · 501 Be LLCN6683VBellanca 14-19-3 · S/N 4338Cancelled Nov 5, 2014 · Registration expired, pending cancellation · Built 1967 · French Harry E JrN4894ZPiper PA-22-108 · S/N 22-8478Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1961 · Younger David PN15934Piper PA-28-140 · S/N 28-7325204Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1972 · Lawson Terry CN9104QAerostar International RXS-8 · S/N RXS8-3019Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1993 · Thompson James WN67090Boeing A75N1(PT17) · S/N 75-661Cancelled Sep 26, 2013 · Revoked, canceled · Built 1941 · Perroux J WN9927PPiper PA-36-285 · S/N 36-7560037Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1975 · B R Lovette DBAN930XGrumman G-164A · S/N 442Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1967 · Cooper James TN118JSSchaub Jocelynn M SONERAI IIL · S/N 051270Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Schaub Jocelynn MN363PAPowrachute PEGASUS · S/N A470PEGCancelled Jan 31, 2013 · Registration pending, canceled · Built 2008N5372WPiper PA-28 · S/N 28-437Cancelled Jan 30, 2013 · Sale reported, canceled · Built 1962N4267PCentral La Soaring Soc MONERAI-S · S/N 280Cancelled Dec 7, 2012 · Sale reported, canceledN5023BBeech F35 · S/N D-4288Cancelled Aug 10, 2012 · Revoked, canceled · Built 1955 · Delong William GreggN45947Luscombe 8A · S/N 2474Cancelled Apr 19, 2012 · First renewal notice · Built 1946 · Sparks Robert B JrN4546KRyan NAVION · S/N TN7Cancelled Oct 9, 2009 · Registration revoked · Built 1948 · Byram James E JrN7224Grumman Acft ENG Cor-Schweizer G-164A · S/N 898Cancelled Aug 1, 2007 · Exported to Mexico · Built 1972 · Marien John HN64GKPiper PA-32R-300 · S/N 32R-7780327Cancelled Apr 17, 2007 · Deramus Jimmie DN6903KGrumman Acft ENG Cor-Schweizer G-164B · S/N 518BCancelled Mar 1, 2007 · Triennial form not returned · Built 1978 · Marien John H DBAN744GAGrumman American Avn. GA-7 · S/N GA7-0034Cancelled Jan 12, 2001 · Triennial form not returned · Myers Charles LN4938XRockwell International S-2R · S/N 2147RCancelled Aug 2, 2000 · Triennial form not returned · Chandler Flying ServiceN1012VCessna R172K · S/N R1722079Cancelled Oct 16, 1998 · Exported to Bolivia · Reid Fred MN2280XSemple Robert L JR SEMPLE MUSTANG MII · S/N 1306Cancelled Jun 24, 1996 · Registration pendingN494YGrumman G-164 · S/N 138Cancelled Sep 28, 1994 · Second triennial mailing, no response · Barbat PaxtonN4456APiper PA-22-150 · S/N 223789Cancelled Oct 12, 1993N4866XRockwell International S-2R · S/N 2062RCancelled Aug 16, 1983 · Built 1974 · Chandler Flying Service IncN57296Piper PA-28-151 · S/N 28-7415035Cancelled Apr 1, 1976 · Borskey Thomas SN15011Piper PA-28 · S/N 28-7225551Cancelled Jun 24, 1975 · Air Charter IncN900WBeech 65-A90 · S/N LJ-150Cancelled Jan 10, 1975 · Exported to Sweden · Waters C M JrN8826LPiper PA-25-235 · S/N 25-5325Cancelled Sep 18, 1974 · Chandler Flying Service IncN4981NBeech A45 · S/N 53-4094Cancelled Aug 2, 1974 · Built 1955 · U S Air ForceN3048YCessna 182E · S/N 18254048Cancelled May 20, 1974 · Exported to Costa Rica · Air Charter IncN9594MMooney M20F · S/N 670171Cancelled Nov 15, 1973 · Exported to Canada · Savage Samuel S & Dr Shaw Roger FN50032Cessna T-50 · S/N 5021Cancelled Oct 28, 1971 · Central Flying ServiceN54147Taylorcraft DC-65 · S/N 4581Cancelled Sep 7, 1971 · Revoked, pending cancellation · Built 1942 · French Harry EN5886ACessna 172 · S/N 28486Cancelled Jul 26, 1966 · Brown Thomas J
Back to Alexandria, LA