OpenAirDocs.org
Bemidji, MN

Cancelled registrations · 43

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 = 'MN' AND d.registrant_city = 'BEMIDJI'
  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.

N5208WPiper PA-28-150 · S/N 28-244Cancelled Oct 19, 2023 · Sale reported · Built 1961N6627NTaylorcraft BC12-D · S/N 3-13018Cancelled Sep 20, 2019 · Sale reported, canceled · Built 1950N29768Taylorcraft BC12-65 · S/N 2616Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Shaw Brian WN43358Taylorcraft BC12-D · S/N 7017Cancelled May 30, 2018 · Sale reported, canceled · Built 1946N99CUEkstrom David L CUMULUS · S/N CU03010Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 2004 · Ekstrom David LN6132HCessna 152 · S/N 15284133Cancelled Sep 15, 2016 · Built 1979 · Bemidji Aviation Services IncN6956HCessna 172M · S/N 17265661Cancelled Sep 15, 2016 · Built 1975 · Bemidji Aviation Service IncN6513YPiper PA-23-250 · S/N 27-3804Cancelled Aug 4, 2015 · Third renewal notice · Built 1967 · Bemidji Aviation Services IncN915DMCelier XENON914T · S/N CAK03871TCancelled May 21, 2015 · Sale reported, canceledN104BABeech 65-B80 · S/N LD-411Cancelled Aug 4, 2014 · Built 1969 · Bemidji Aviation Services IncN107BABeech 65-B80 · S/N LD-358Cancelled Sep 27, 2013 · First renewal notice · Built 1967 · Bemidji Aviation Services IncN36CWWockner Clark M AIR COMM 532 ELITE · S/N 1Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1988 · Gregory Tony FN6909SCessna 150H · S/N 15067609Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1967 · Sonneman David JN4016ABeech 58 · S/N TH-9Cancelled Jan 17, 2013 · Built 1970 · Bemidji Aviation Services IncN133JRRockensock James E CHRISTAVIA MK1 · S/N 000133Cancelled Oct 18, 2012 · Registration expired, pending cancellation · Rockensock James EN138BABeech 65-B80 · S/N LD-361Cancelled Apr 25, 2012 · Registration expired · Built 1967 · Bemidji Aviation Services IncN70DDBeech 58 · S/N TH-370Cancelled Mar 27, 2012 · Second renewal notice · Built 1973 · Bemidji Aviation Services IncN204RDPiper PA-23-250 · S/N 27-3994Cancelled Feb 16, 2010 · Exported to Philippines · Built 1968 · Air Direct AircraftN6881YPiper PA-23-250 · S/N 27-4230Cancelled Sep 30, 2008 · Exported to Philippines · Built 1969 · Air Direct AircraftN1802Bensen B-8M · S/N 37566521Cancelled May 15, 1999 · Triennial form not returned · Krause Herbert WN4421DBeech G35 · S/N D4574Cancelled Mar 3, 1994 · Bemidji Aviation Services IncN68FPPartenavia P.68C · S/N 233Cancelled Jul 15, 1991 · Exported to Venezuela · Shefland Raymond CN25774Cessna 152 · S/N 15280776Cancelled Jun 14, 1989 · Built 1977 · Bemidji Aviation Services IncN95284Piper PA-28-140 · S/N 28-25874Cancelled May 2, 1978 · Exported to Canada · Built 1969 · Bemidji State College Flyling Club IncN78399Cessna 172K · S/N 17257601Cancelled Jul 16, 1974 · Exported to Canada · Bemidji Aviation Services IncN5460CCessna 170A · S/N 19494Cancelled Mar 9, 1973 · Exported to Canada · Moberg Ralph JN1760APiper PA-20 · S/N 20863Cancelled Sep 17, 1970 · Exported to Canada · Fankhanel David L EtalN5227XChampion 7KCAB · S/N 205Cancelled Jun 12, 1970 · Bemidji Aviation Services IncN2281CCessna 180 · S/N 30581Cancelled Nov 12, 1965 · Mathew R WilsonN87729Piper J3C-65 · S/N 15387Cancelled Sep 6, 1961 · Exported to Canada · Built 1946 · Chandler Charles EN9613EAeronca 11AC · S/N 11AC-1252Cancelled May 31, 1961 · Exported to Canada · Built 1946 · Bemidji Aviation Services IncN1265HAeronca 15AC · S/N 15AC-277Cancelled Dec 21, 1960 · Exported to Canada · Esther J KleebN3369NPiper J3C-65 · S/N 22569Cancelled May 9, 1960 · Exported to Canada · Built 1946 · Hall H ON815CStinson 108-3 · S/N 108-3815Cancelled May 9, 1957 · Exported to Canada · Nickelson MaynardN21053Aeronca K · S/N K-334Cancelled Feb 22, 1956 · Built 1938 · Larson Bert EtalN93294Rearwin 185 · S/N 1857Cancelled Oct 13, 1955 · Rideout Frank And Vanasse TomN9695HConsolidated Vultee BT-13A · S/N 10273Cancelled Mar 31, 1955 · Bemidji Aviation Services IncN3359APiper PA-18-135 · S/N 18-3010Cancelled Jan 13, 1954 · Exported to Canada · Born Wayne LN967CStinson 108-3 · S/N 108-3967Cancelled Jan 27, 1953 · Exported to Canada · Ledyard Gleason HN96462Taylorcraft BC12-D · S/N 8762Cancelled Mar 27, 1952 · Exported to Canada · Bemidji Aviation Services IncN33933Taylorcraft BFS12-65 · S/N 2783Cancelled May 25, 1949 · Ralph MobergN97396Stinson 108 · S/N 108-396Cancelled Jan 5, 1948 · Sawdey S MN9089Travel Air 2000 · S/N 870Cancelled Feb 26, 1939 · Moberg Ralph
Back to Bemidji, MN