Skip to content

Board Of Trustees

Earlier aircraft under this name · 23

Cancelled registrations that named this owner when they ended, newest first.

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_name = 'BOARD OF TRUSTEES' OR list_contains(d.other_registrant_names, 'BOARD OF TRUSTEES') 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_name = 'BOARD OF TRUSTEES' OR list_contains(d.other_registrant_names, 'BOARD OF TRUSTEES')
  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_name = 'BOARD OF TRUSTEES' OR list_contains(d.other_registrant_names, 'BOARD OF TRUSTEES')
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.

N3053LCessna 310J · S/N 310J0053Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1965 · Southern Illinois University, Carbondale, IL N18231Cessna 150L · S/N 15073884Cancelled Jul 12, 2019 · Registration expired, pending cancellation · Built 1972 · Southern Illinois University, Carbondale, IL N4668GCessna 172N · S/N 17273294Cancelled Mar 9, 2019 · Registration expired, pending cancellation · Built 1979 · Southern Illinois University, Murphysboro, IL N2414XBell 206B · S/N 9035Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Southern Illinois University, Carbondale, IL N141VUCessna 172RG · S/N 172RG1146Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1984 · Vincennes University, Lawrenceville, IL N64503Cessna 310A · S/N 38066Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1957 · Savoy, IL N4148PPiper PA-28-181 · S/N 2843177Cancelled Aug 4, 2014 · Built 1998 · University Of Illinois, Savoy, IL N67125Bell TH-13T · S/N 3644Cancelled May 1, 2013 · Registration expired, pending cancellation · Built 1967 · Southern Illinois University, Murphysboro, IL N221SBell 47D1 · S/N 476Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Southern Illinois University, Carbondale, IL N2636YCessna 310R · S/N 310R1652Cancelled Apr 15, 2004 · Triennial form not returned · Built 1979 · Southern Illinois University, Carbondale, IL N1851ZBeech C23 · S/N M-2343Cancelled Nov 14, 2003 · Triennial form not returned · Built 1981 · University Of Illinois, Savoy, IL N67124Bell TH-13T · S/N 3681Cancelled Nov 18, 1999 · Triennial form not returned · Southern Illinois University, Carbondale, IL N1108RRaven S55A · S/N S55A-291Cancelled Mar 10, 1984 · Administratively canceled · Raven Industries Inc, Sioux Falls, SD N111WKKleinbauer WAKE ISLAND SCORPION · S/N WJK-1-74Cancelled Jun 25, 1983 · Administratively canceled · Kleinbauer William J, Hawthorne, CA N110SQBell 47G-3B · S/N 3100Cancelled Dec 5, 1982 · Administratively canceled · Ohio State University, Columbus, OH N111NTCessna 320D · S/N 320D0093Cancelled Oct 30, 1982 · Administratively canceled · Banks Harold N, Republic, WA N11112Funkhouser COUGAR 1 · S/N 10201Cancelled Aug 12, 1982 · Administratively canceled · Judson Arthur T, Stony Brook, NY N11013Cessna 150L · S/N 15075194Cancelled Apr 15, 1982 · Administratively canceled · Sulland Marion, Richmond, MO N1107JAero Commander 112 · S/N 107Cancelled Jun 13, 1981 · Administratively canceled · Rockwell International Corporation, Bethany, OK N1108LConsolidated Aeronautics LAKE LA-4 · S/N 699Cancelled Jun 6, 1981 · Administratively canceled · Hartig Robert L, Anchorage, AK N9047North American F-86 · S/N 53-1396Cancelled May 14, 1979 · Helena, MT N209SBeech C-45 · S/N AF438Cancelled Aug 4, 1970 · Carbondale, IL N2324VCessna 140 · S/N 14560Cancelled Nov 20, 1950 · Urbana, IL

Back to Board Of Trustees