OpenAirDocs.org
Monroe, LA

Cancelled registrations · 151

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

N757AMCessna 152 · S/N 15279586Cancelled Apr 7, 1992 · Triennial form not returned · Mcmahan Aviation IncN9785VCessna A188 · S/N 1880235Cancelled Dec 13, 1991 · Exported to South Africa · Evans Robert AN9788VCessna A188 · S/N 1880238Cancelled Dec 13, 1991 · Exported to South Africa · Evans Robert AN4788BCessna 152 · S/N 15283635Cancelled Mar 27, 1991 · Triennial form not returned · Mcmahan Aviation IncN737QSCessna 172N · S/N 17269597Cancelled Apr 8, 1985 · Fleeman Enterprises IncN1997JCessna T188C · S/N T18803332TCancelled Nov 24, 1982 · Administratively canceled · Wright Ray JN1160YCessna 150B · S/N 15059560Cancelled Oct 10, 1980 · Estes Gary LN8064MCessna 310I · S/N 310I0064Cancelled Oct 8, 1980 · Exported to Nigeria · International Housing Nigeria LtdN72XBeech A100 · S/N B-104Cancelled Mar 8, 1978 · Exported to Canada · Camp Co Of Monroe IncN8786LPiper PA-28-235 · S/N 25-5270Cancelled Oct 20, 1976 · Huenefeld Fred SrN7386TCessna 172A · S/N 46986Cancelled May 8, 1974 · C B Mcmahan Aerial Pipeline Patrols IncN85789Aeronca 7AC · S/N 7AC-4539Cancelled Apr 24, 1974 · Built 1946 · Knickerbocker Bobby GN2202Cessna 182A · S/N 51179Cancelled Mar 23, 1971 · Aerial Pipeline Patrols IncN6421MStinson 108-3 · S/N 108-4421Cancelled Feb 2, 1971 · C B Mcmahan AerialN64906Aeronca 0-58B · S/N 58B-9443Cancelled Feb 2, 1971 · Built 1945 · Koontz Charles MN6486YPiper PA-23-250 · S/N 27-3783Cancelled Jan 28, 1971 · Built 1969 · Bakers Piggly Wiggly StoresN4131CStinson 108-3 · S/N 108-5131Cancelled Dec 31, 1970 · C B Mcmahan Aerialpipeline Patrol IncN2426APiper PA-18A-135 · S/N 18-1930Cancelled Dec 4, 1970 · North Louisiana Aero CorpN1348MBoeing A75N1 · S/N 758098Cancelled Jun 30, 1970 · Delta Air Lines IncN17608Huff Daland PETREL PUFFER · S/N 73Cancelled Jun 30, 1970 · Delta Air Lines IncN1924MBoeing A75N1 · S/N 75-8800Cancelled Jun 30, 1970 · Delta Air Lines IncN1925MBoeing E75N1 · S/N 75-8746Cancelled Jun 30, 1970 · Delta Air Lines IncN1926MBoeing E75N1 · S/N 75-5308Cancelled Jun 30, 1970 · Delta Air Lines IncN4312EBoeing A75 (PT13) · S/N 75-226Cancelled Jun 30, 1970 · Built 1940 · Delta Air Lines IncN4936NBoeing A75N1 · S/N 75-5179Cancelled Jun 30, 1970 · Built 1942 · Delta Air Lines IncN49649Boeing A75N1 · S/N 75-4678Cancelled Jun 30, 1970 · Built 1943 · Delta Air Lines IncN49652Boeing A75N1 · S/N 4677Cancelled Jun 30, 1970 · Built 1942 · Delta Air Lines IncN49730Boeing A75N1 · S/N 75-4330Cancelled Jun 30, 1970 · Built 1942 · Delta Air Lines IncN49736Boeing A75N1(PT17) · S/N 754815Cancelled Jun 30, 1970 · Built 1943 · Delta Air Lines IncN52139Boeing E75 · S/N 755234Cancelled Jun 30, 1970 · Delta Air Lines IncN53775Boeing A75N1 · S/N 75-4869Cancelled Jun 30, 1970 · Delta Air Lines IncN55100Boeing A75N1 · S/N 75-310Cancelled Jun 30, 1970 · Delta Air LinesN55356Boeing A75N1 · S/N 75-4455Cancelled Jun 30, 1970 · Delta Air Lines Dusting DivisionN66477Boeing E75 · S/N 758221Cancelled Jun 30, 1970 · Built 1948 · Delta Air LinesN275KHuff Daland DUSTER · S/N 34Cancelled Jun 29, 1970 · Delta Airlines Incdusting DivisionN395NHuff Daland DUSTER · S/N 56Cancelled Jun 29, 1970 · Built 1925 · Delta Air CorpN487EHuff Daland DUSTER · S/N DA-3Cancelled Jun 29, 1970 · Delta Air Lines IncN523BBeech J35 · S/N D-5372Cancelled Jun 29, 1970 · Fleeman Enterprises IncN4148CStinson 108-3 · S/N 108-5148Cancelled Apr 16, 1968 · Exported to Canada · C B Mcmahan Aerial Pipeline Patrols IncN6988MStinson 108-3 · S/N 108-4988Cancelled Apr 16, 1968 · Exported to Canada · C B Mamahan Aerial Pipeline Patrols IncN730CStinson 108-3 · S/N 108-3730Cancelled Apr 16, 1968 · Exported to Canada · C B Mcmahan SrN1211MBoeing A75N1(PT17) · S/N 75-8492Cancelled Jun 17, 1966 · Delta Air Lines IncN30269Piper J3L-65 · S/N 4746Cancelled May 25, 1965 · Built 1940 · Bell Jack EN506CStinson 108-3 · S/N 108-3506Cancelled May 18, 1965 · Built 1947 · Mcmahan C BN94FCessna 195 · S/N 7706Cancelled Mar 1, 1961 · Exported to Canada · North Louisiana Aero CorpN4941NBoeing A75N1 · S/N 75-6431Cancelled Nov 18, 1957 · Delta Air Lines IncN88399Piper J3C-65 · S/N 16017Cancelled Mar 20, 1956 · Built 1946 · Dumas James V JrN97186Stinson 108 · S/N 108-186Cancelled Oct 17, 1955 · Built 1946 · Mcmahan C B SrN48197Boeing A75N1 · S/N 75-1116Cancelled Sep 23, 1955 · Built 1945 · Delta Airlines Inc Dusting DivisionN97717Stinson 108 · S/N 108-717Cancelled Mar 18, 1955 · Built 1946 · Mcmahan C B
Back to Monroe, LA