OpenAirDocs.org
Jennings, LA

Cancelled registrations · 41

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

N912RSSmith Michael J RANS S12S · S/N 06000922Cancelled Sep 30, 2023 · Sale reported, canceledN362PInfinity Power Parachutes C-912S · S/N IPP7-361Cancelled Mar 21, 2023 · Sale reported, canceled · Built 2008N28435Grumman American Avn. AA-5B · S/N AA5B0611Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1977 · Carter Aviation Services LLCN48594Grumman Acft ENG Cor-Schweizer G-164A · S/N 1677Cancelled Apr 24, 2021 · Built 1976 · Riceland Aviation IncN92662Piper J3C-65 · S/N 17037Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Zigler Flying SvcN3438EAeronca 7AC · S/N 7AC-6837Cancelled Apr 2, 2018 · Revoked, canceled · Built 1947 · Zigler Flying Service IncN14196Piper PA-23-250 · S/N 27-4758Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1971 · Jefferson Davis Parish Mosquito DistrictN1122CPiper PA-22-135 · S/N 22-956Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1953 · Hawthorn Benjamin MN69GFFranceschini Guy T QUICKSILVER SPORT 2S · S/N 0135Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 2005 · Clay DarrinN42SAAlexander Steve GYROPLANE · S/N ALEX-0001Cancelled Jun 14, 2017 · Registration expired, pending cancellation · Alexander Steve CN4305DWSK PZL Mielec M-18A · S/N 1Z022-19Cancelled Dec 12, 2013 · First renewal notice · Riceland Aviation IncN80384Mcculloch David BENSEN B8M · S/N 1Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1979N3626RSchweizer G-164B · S/N 721BCancelled Nov 5, 2008 · Exported to Argentina · Built 1983 · Deep South Flying Service IncN62446Bell 47G-4A · S/N 7655Cancelled Jan 16, 2003 · Built 1968 · Deep South Helicopters IncN20AGRoche Daniel J CGS HAWK · S/N H-1-20CCancelled Sep 11, 2000 · Triennial form not returned · Hebert Michael JN7070UWSK PZL Mielec M-18 DROMADER · S/N 1Z00920Cancelled Mar 4, 1997 · Triennial form not returned · Riceland Aviation IncN9546Grumman Acft ENG Cor-Schweizer G-164A · S/N 1208Cancelled Jun 27, 1994 · Triennial form not returned · Riceland Aviation IncN530YGrumman G-164 · S/N 167Cancelled Apr 1, 1971 · A B Leonard Aviation Co IncN5308NBoeing E75 · S/N 75-5608Cancelled Mar 15, 1971 · Zigler Flying Service IncN83099Champion 7AC · S/N 7AC1756Cancelled Feb 17, 1971 · Zigler Flying ServiceN3507CCessna 170B · S/N 26550Cancelled Apr 12, 1966 · Caraway Julius Garrett JrN75074Cessna 170A · S/N 19428Cancelled Jan 12, 1960 · Moag Roger JN59745Boeing A75N1 · S/N 75-1578Cancelled Nov 18, 1957 · Zigler Flying Service IncN75259Boeing A75N1 · S/N 75-6692Cancelled Oct 12, 1955 · Zigler Flying Service IncN5305NBoeing E75 · S/N 75-5661Cancelled Oct 6, 1955 · Zigler Flyiing Service IncN3296EAeronca 11AC · S/N 11AC-1667Cancelled Oct 4, 1955 · Zigler Flying Service IncN8114ACessna 170B · S/N 20966Cancelled Apr 29, 1955 · Mcburney W JN2439APiper PA-20-135 · S/N 20-930Cancelled Apr 30, 1953 · Exported to Mexico · Thomas David ON75248Boeing N2S-5 · S/N 75-8639Cancelled Dec 14, 1951 · Daniel F BasinN3340VBeech 35 · S/N D-803Cancelled Sep 7, 1951 · Walker Electric ServiceN9648KStinson 108-2 · S/N 108-2648Cancelled Aug 7, 1951 · Zigler Flying Service IncN75230Boeing A75N1 · S/N 75-3411Cancelled Jun 19, 1951 · Zigler Flying ServiceN75225Boeing B75N1 · S/N 75-1292Cancelled Jun 7, 1951 · Zigler Flying Service IncN75229Boeing B75N1 · S/N 75-7052Cancelled Jun 7, 1951 · Zigler Flying ServiceN75238Boeing A75N1 · S/N 75-3397Cancelled Jun 7, 1951 · Zigler Flying ServiceN75249Boeing E75 · S/N 75-8411Cancelled Jun 7, 1951 · Robert M MayoN75255Boeing A75N1 · S/N 75-4889Cancelled Jun 7, 1951 · Zigler Flying Service IncN2462EAeronca 7AC · S/N 7AC-6041Cancelled Oct 9, 1950 · Zigler Flying ServiceN75247Boeing E75 · S/N 75-8557Cancelled Jun 28, 1949 · Jefferson E Hooper JrN86602Grumman G-44A · S/N 1428Cancelled Jun 16, 1949 · Built 1945 · Zigler Flying Service IncN75231Boeing A75N1 · S/N 75-3439Cancelled Apr 1, 1949 · Zigler Flying Service
Back to Jennings, LA