Skip to content

Cancelled registrations · 40

Query with SQL

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 = 'NE' AND d.registrant_city = 'ALLIANCE' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'NE' AND d.registrant_city = 'ALLIANCE'
  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.

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 = 'NE' AND d.registrant_city = 'ALLIANCE'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N97484Stinson 108 · S/N 108-484Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 1946 · Last Pass Aviation Inc N48416Grumman Acft ENG Cor-Schweizer G-164B · S/N 22BCancelled Mar 30, 2021 · Built 1976 · Western Cooperative Co N263TMPowrachute SKY-RASCAL · S/N SR-097Cancelled Jul 15, 2020 · Built 2007 · Nelson Trent A N9026LChampion 7GCAA · S/N 215-70Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1970 · Last Pass Aviation N84580Aeronca 7AC · S/N 7AC-3289Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 1946 · Andrick Ben N64252Consolidated Vultee SNV-1 · S/N 8631Cancelled Aug 6, 2013 · Revoked, canceled · Prairie Airways Inc N4812APiper PA-22-150 · S/N 22-3964Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1956 · Padhandle Flying Club N84743Aeronca 7AC · S/N 7AC-3455Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1946 · Savastano James C N733FYCessna 172N · S/N 17268272Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1976 · Alliance Aero Services Inc N6371YPiper PA-23-250 · S/N 27-3647Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1967 · Don Air Service Inc N64428Consolidated Vultee BT-13 · S/N 791222Cancelled Apr 22, 2013 · Revoked, pending cancellation · Built 1944 · Prairie Airway Inc N5821QKurz Robert JR ROTEC RALLY 3A · S/N 25427Cancelled Dec 13, 2012 · Sale reported, pending cancellation N39468Stinson 108 · S/N 108-24Cancelled Nov 14, 2012 · Registration expired, pending cancellation · Built 1946 · Bowman Daniel M N50546Cessna 150J · S/N 15069388Cancelled Sep 6, 2012 · Sale reported, pending cancellation · Built 1968 N50212Boeing A75N1(PT17) · S/N 751062Cancelled Aug 10, 2012 · Revoked, canceled · Bmb Air Svc N7255DPiper PA-22-150 · S/N 22-5081Cancelled Aug 7, 2006 · Triennial form not returned · Built 1957 · Sutton Gary N22269Cessna 150H · S/N 15068180Cancelled Aug 20, 2001 · Triennial form not returned · Jensen Jeffrey S N89838Cessna 140 · S/N 8887Cancelled Apr 10, 1998 · Triennial form not returned · Bowman Daniel M N4662YPiper PA-25-235 · S/N 254385Cancelled Sep 7, 1995 · Exported to Peru · Krejci Dwight DBA N5399YPiper PA-23-250 · S/N 272474Cancelled Mar 13, 1995 · Triennial form not returned · Furman James W N3934EAeronca 11BC · S/N 11BC-16Cancelled Jul 22, 1982 · Built 1947 · Anderson Tim C N40565Piper PA-23-250 · S/N 27-7405307Cancelled Dec 23, 1981 · Don Air Service Inc N739DNCessna 172N · S/N 17270462Cancelled Sep 29, 1980 · Brown Ruth Q N4123CStinson 108-3 · S/N 108-5123Cancelled Dec 11, 1974 · Built 1949 · Dobson Park Jr N5961QMooney M20C · S/N 3198Cancelled Jul 25, 1974 · Brown Phil E N2968EAeronca 7AC · S/N 7AC-6554Cancelled Jan 25, 1972 · Built 1946 · Stanton Ralph E & Burton Wesley E N6060MStinson 108 · S/N 1084060Cancelled Dec 2, 1971 · Revoked, pending cancellation · Built 1947 · Butcher J O N2164UBrantly B-2B · S/N 326Cancelled Sep 21, 1970 · Donald W Brown N4922MPiper PA-11 · S/N 11-1631Cancelled Dec 24, 1959 · Built 1947 · Mracek James E N73318Fairchild PT-26 M62A3 · S/N FX 183Cancelled Feb 20, 1958 · Bmb Air Service N6239MStinson 108-3 · S/N 108-4239Cancelled Jan 17, 1957 · Alliance Tractor & Implement Co N53308Cessna T-50 · S/N 6638Cancelled May 19, 1955 · Praire Airways Inc N58976Boeing E75 · S/N 75-5584Cancelled Jun 22, 1954 · Exported to Mexico · B M B Air Service N2620KLuscombe 8E · S/N 5347Cancelled Sep 16, 1952 · Sorensen Clarence N N34710Porterfield LP-65 · S/N 876Cancelled May 15, 1951 · John Nash N17019Sparks Sport Plane MODIFIED FLYING FLEA · S/N X-2Cancelled Aug 5, 1948 · Burton Aubrey Wesley N10972Curtiss Wright JR CW1 · S/N 1150Cancelled Dec 20, 1937 · Built 1931 · Miller Harold M N6649Ryan B1 · S/N 134Cancelled Nov 12, 1931 · Davee William L N602YWaco RNF · S/N 3322Cancelled Apr 1, 1931 · Reddish H E N64263Cessna T-50 · S/N 4544Cancellation date not recorded · Lunger V L

Back to Alliance, NE