Skip to content

Usaf Academy, CO

Cancelled registrations · 22

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 = 'CO' AND d.registrant_city = 'USAF ACADEMY' 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 = 'CO' AND d.registrant_city = 'USAF ACADEMY'
  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 = 'CO' AND d.registrant_city = 'USAF ACADEMY'
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.

N421BALet L13 AC BLANIK · S/N 028902Cancelled Sep 18, 2017 · Registration expired, pending cancellation · Built 2002 · United States Air Force Academy 94 Fts Cc N424BALet L13 AC BLANIK · S/N 028905Cancelled Aug 31, 2017 · Registration expired, pending cancellation · Built 2002 · United States Air Force Academy N435BALet L13 AC BLANIK · S/N 029101Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 2002 · United States Air Force Academy 94 Fts Cc N408BALet L 33 SOLO · S/N 020603Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 2002 · United States Air Force Academy 94 Fts Cc N31AFSchweizer SGM2-37 · S/N 1Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1982 · United States Air Force N27AFSchweizer SGM2-37 · S/N 7Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1983 · United States Air Force N148XSAeromot AMT-200S · S/N 200.148Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 2003 · 94th Flight Training Squadron N2447WSchweizer SGS 2-33 · S/N 12Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1967 · United States Air Force N97LPCessna 172P · S/N 17274398Cancelled Feb 5, 2013 · Built 1980 · United States Air Force Aero Club N1192SSchweizer SGS 2-33A · S/N 202Cancelled Aug 13, 2003 · Triennial form not returned · Built 1970 · United States Air Force N225AFSchweizer SGS 2-25 · S/N 1Cancelled May 5, 2000 · Triennial form not returned · US Air Force N7904NCessna R172E · S/N R1720295Cancelled Jul 24, 1997 · Triennial form not returned · U S Air Force N3043FCessna T-41B · S/N R1720135Cancelled Feb 18, 1997 · Triennial form not returned · US Air Force Owner N7634SBellanca 8GCBC · S/N 21076Cancelled May 21, 1996 · Triennial form not returned · Fischer Agency Inc N33894Schweizer SGS 1-26E · S/N 624Cancelled Feb 5, 1996 · United States Air Force N17920Schweizer SGS 1-26E · S/N 530Cancelled Jun 24, 1994 · Triennial form not returned · US Air Force Academy N1191SSchweizer SGS 2-33A · S/N 201Cancelled May 16, 1991 · Triennial form not returned · US Air Force N1193SSchweizer SGS 2-33A · S/N 203Cancelled May 16, 1991 · Triennial form not returned · US Air Force N5218FCessna 172F · S/N 17253243Cancelled May 7, 1981 · Usaf Academy Aero Club N24628Beech C23 · S/N M1407Cancelled Mar 13, 1981 · Built 1972 · Usaf Academy Aero Club N7735SSchweizer SGS 1-26D · S/N 435Cancelled Nov 1, 1977 · U S Air Force Academy N7746LCessna 172K · S/N 17259009Cancelled Apr 19, 1976 · Usaf Academy Aero Club

Back to Usaf Academy, CO