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.

N4933NBoeing E75 · S/N 75-8721Cancelled Nov 13, 1953 · Northeast Aviation Service IncN49741Boeing A75N1 · S/N 75-4465Cancelled Aug 27, 1953 · Built 1943 · Delta Air Lines Inc/ Dusting DivisionN17607Huff Daland PETREL PUFFER · S/N 71Cancelled Aug 25, 1952 · Delta Air Lines IncN28505Fairchild 24R-40 · S/N R40-413Cancelled Nov 26, 1951 · Exported to Cuba · Built 1940 · Mcmahan Cb SrN84351Aeronca 7AC · S/N 7AC3050Cancelled Jun 23, 1950 · Severance F LN14540Aeronca C-3 · S/N A-435Cancelled Feb 12, 1950 · Mcwilliams William FredN72642Cessna 120 · S/N 9818Cancelled Jan 4, 1950 · Monroe AirparkN53797Taylorcraft DCO-65 · S/N L-3623Cancelled Dec 13, 1949 · Wallace George FosterN2951Huff Daland PETREL PUFFER · S/N 59Cancelled Oct 14, 1949 · Delta Air Lines IncN2955Huff Daland DUSTER · S/N 57Cancelled Oct 14, 1949 · Deltal Airlines IncN4463NBoeing A75N1 · S/N 75-3355Cancelled Oct 14, 1949 · Delta Air Lines Incdusting DivisionN15042Fairchild 24 C8C · S/N 2679Cancelled Sep 26, 1949 · Turner Field AirportN86901Bellanca 14-13 · S/N 1263Cancelled Jun 21, 1949 · Delta Ship Service Co Inc Aviation DivN2091MPiper J3C-65 · S/N 20869Cancelled Jun 7, 1949 · Northeast Aviation Service IncN2100MPiper J3C-65 · S/N 20885Cancelled Jun 7, 1949 · Northeast Aviation Service IncN3372NPiper J3C-65 · S/N 22572Cancelled Jun 7, 1949 · Built 1946 · Northeast Aviation Service IncN7836HPiper PA-12 · S/N 12-736Cancelled Jun 7, 1949 · Northeast Aviation Service IncN53551Ryan Aeronautical ST3KR · S/N 1657Cancelled Mar 2, 1949 · Kelly John JN47857Taylorcraft DCO-65 · S/N L-5078Cancelled Jan 7, 1949 · Harry SchroederN52433Fairchild M-62A · S/N T40-164Cancelled Nov 10, 1948 · Built 1945 · Severance Fayette LN32118Waco UPF-7 · S/N 5750Cancelled Aug 20, 1948 · Northeast Junior College Of L S UN6253Stearman C3-B · S/N 144Cancelled Mar 31, 1948 · Delta Air CorpN8814Stearman C3-B · S/N 228Cancelled Mar 22, 1948 · Delta Air CorpN5396Travel Air 4000 · S/N 502Cancelled Mar 12, 1948 · Delta Air CorpN3359Keystone PUFFER · S/N DA-5Cancelled Aug 10, 1944 · Delta Air CorpN14924Douglas DC2 · S/N 1410Cancelled Apr 22, 1941 · Delta Air CorporationN3984Fairchild Airplane Mfg FC-2 · S/N 51Cancelled Jun 25, 1940 · Delta Air CorpN16133Stinson SR-8B · S/N 9708Cancelled Sep 20, 1938 · Miller HenryN4891Mono-Aircraft MONOCOUPE (MODEL 22) · S/N 16Cancelled Jan 11, 1938 · Elliott Henry EN4316Travel Air Mfg 2000 · S/N 369Cancelled Sep 1, 1937 · Built 1928 · Delta Air CorporationN64ETravel Air 4000 · S/N 154Cancelled Aug 9, 1937 · Delta Air CorpN5506Waco GXE · S/N 1523Cancelled Jun 1, 1937 · Mclean D LN22YAeronautical Industries B-3-A · S/N 372Cancelled Nov 1, 1936 · Zarro M JN15134Stinson A · S/N 9111Cancelled Aug 27, 1936 · Built 1935 · Delta Air CorpN14599Stinson A · S/N 9103Cancelled Aug 14, 1935 · Built 1935 · Delta Air CorpN5395Travel Air 3000 · S/N 501Cancelled Oct 1, 1934 · Delta Air CorpN4003Waco 9 · S/N 344Cancelled Jul 20, 1934 · Built 1928 · Edney Frank BN11897Curtiss Wright CW-1 · S/N 1267Cancelled May 22, 1933 · H C MillerN1647Douglas M-4 · S/N 310Cancelled Jul 11, 1932 · Norton C EN4033Curtiss JN4D · S/N 38304Cancelled Mar 28, 1930 · Greer James DorrisN2961Huff Daland PETREL PUFFER · S/N 61Cancelled Jan 10, 1930 · Exported to Peru · Built 1925 · Huff Daland Dusters IncN2958Huff Daland PETREL PUFFER · S/N 52Cancelled May 17, 1929 · Exported to Peru · Huff Daland Dusters IncN2957Huff Daland PETREL PUFFER · S/N A-1308Cancelled Oct 16, 1928 · Huff Daland Dusters IncN2959Huff Daland PETREL PUFFER · S/N A-1310Cancelled Oct 16, 1928 · Huff Daland Dusters IncN2962Huff Daland PETREL PUFFER · S/N A-1302Cancelled Oct 16, 1928 · Built 1925 · Huff Daland Dusters IncN2964Huff Daland PETREL PUFFER · S/N 63Cancelled Sep 21, 1928 · Huff Daland Dusters IncN2965Huff Daland PETREL PUFFER · S/N 35Cancelled Apr 13, 1928 · Built 1925 · Huff Daland Dusters IncN17606Huff Daland PETREL PUFFER · S/N 70Cancellation date not recorded · Built 1937 · Delta Air CorpN275KUnknown UNKNOWN · S/N 34Cancellation date not recorded · Delta Air Service IncN2950Huff Daland PETREL PUFFER · S/N 54Cancellation date not recorded · Huff Daland Dusters Inc
Back to Monroe, LA