Skip to content

Civil Air Patrol Inc

Earlier aircraft under this name · 299

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 = 'CIVIL AIR PATROL INC' OR list_contains(d.other_registrant_names, 'CIVIL AIR PATROL INC') 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 = 'CIVIL AIR PATROL INC' OR list_contains(d.other_registrant_names, 'CIVIL AIR PATROL INC')
  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 = 'CIVIL AIR PATROL INC' OR list_contains(d.other_registrant_names, 'CIVIL AIR PATROL INC')
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.

N61795Cessna A185F · S/N 18504256Cancelled Mar 16, 2026 · Exported to Canada · Built 1981 · Maxwell, AL N5404ECessna 182R · S/N 18268315Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Built 1983 · Maxwell Afb, AL N2770ZSchweizer SGU 2-22E · S/N 211Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1965 · Maxwell Afb, AL N381BALet L-23 SUPER BLANIK · S/N 018801Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 2001 · Maxwell Afb, AL N9514XCessna 182R · S/N 18268542Cancelled Apr 27, 2020 · Exported to Russia · Maxwell Afb, AL N99162Cessna 172P · S/N 17276413Cancelled May 15, 2019 · Exported to Russia · Built 1985 · Maxwell Afb, AL N704DECessna 182Q · S/N 18266237Cancelled May 3, 2018 · Registration expired, pending cancellation · Built 1978 · Maxwell Afb, AL N2480WSchweizer SGS 2-33 · S/N 34Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1967 · Montgomery, AL N7771SSchweizer SGS 2-33A · S/N 141Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 1969 · Maxwell Afb, AL N5342GDehavilland BEAVER U-6A · S/N 854Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 1954 · Maxwell Afb, AL N5117NCessna 182Q · S/N 18267528Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1980 · Maxwell Afb, AL N4793CDehavilland BEAVER DHC-2 MK.1 · S/N 296Cancelled Mar 21, 2017 · Built 1951 · Maxwell Afb, AL N914CPCessna 172S · S/N 172S8334Cancelled Mar 21, 2017 · Built 1999 · Maxwell Afb, AL N4810NCessna 182Q · S/N 18267384Cancelled Mar 7, 2017 · Built 1979 · Maxwell Afb, AL N4732NCessna 182Q · S/N 18267321Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1979 · Maxwell Afb, AL N734WACessna 172N · S/N 17269162Cancelled Feb 23, 2017 · Registration expired, pending cancellation · Built 1977 · Maxwell Afb, AL N65844Schweizer SGS 2-33A · S/N 335Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1974 · Maxwell Afb, AL N50760Cessna 310 · S/N 38116Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Maxwell Afb, AL N79058Cessna 172K · S/N 17257850Cancelled Jul 9, 2013 · Third renewal notice · Built 1968 · Maxwell Afb, AL N99562Cessna 172P · S/N 17276468Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1985 · Maxwell Afb, AL N98991Cessna 172P · S/N 17276393Cancelled May 8, 2013 · First renewal notice · Maxwell Afb, AL N58630Cessna 182P · S/N 18262187Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1973 · Maxwell Afb, AL N5079DBeech 65 · S/N LF-31Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Maxwell Afb, AL N99087Cessna 172P · S/N 17276400Cancelled Apr 4, 2013 · First renewal notice · Built 1985 · Maxwell Afb, AL N61914Cessna 172M · S/N 17264882Cancelled Oct 31, 2012 · First renewal notice · Built 1975 · Maxwell, AL N356BALet L-23 SUPER BLANIK · S/N 998420Cancelled Mar 6, 2012 · Second renewal notice · Built 1999 · Maxwell Afb, AL N96960Cessna 172Q · S/N 17276140Cancelled Feb 16, 2012 · First renewal notice · Built 1984 · Maxwell Afb, AL N2046TSchweizer SGS 2-33A · S/N 476Cancelled Feb 3, 2012 · Built 1977 · Maxwell Afb, AL N62602Cessna 172P · S/N 17275308Cancelled Oct 28, 2011 · First renewal notice · Built 1981 · Maxwell Afb, AL N151TPiper PA-18-105 SPECIAL · S/N 18-2265Cancelled Jun 30, 2009 · Registration revoked · Built 1953 · Brewster, KS N6703ECessna 172N · S/N 17272051Cancelled Jun 8, 2009 · Triennial form not returned · Built 1978 · Maxwell Afb, AL N9474ECessna 182R · S/N 18268418Cancelled Oct 22, 2008 · Triennial form not returned · Built 1984 · Maxwell Afb, AL N9928HCessna 182R · S/N 18268119Cancelled Oct 22, 2008 · Triennial form not returned · Built 1982 · Maxwell Afb, AL N6211ECessna 182R · S/N 18268352Cancelled Mar 29, 2006 · Triennial form not returned · Built 1983 · Maxwell, AL N9474LCessna 172P · S/N 17276560Cancelled Mar 7, 2006 · Triennial form not returned · Built 1986 · Maxwell Afb, AL N1185UCessna 172M · S/N 17266886Cancelled Feb 9, 2006 · Triennial form not returned · Built 1976 · Maxwell Afb, AL N99245Cessna 172P · S/N 17276419Cancelled Feb 1, 2006 · Triennial form not returned · Built 1985 · Maxwell Afb, AL N6319HCessna 182R · S/N 18267882Cancelled Jan 31, 2006 · Triennial form not returned · Built 1981 · Maxwell Afb, AL N2393ECessna 172N · S/N 17271264Cancelled Jan 30, 2006 · Triennial form not returned · Built 1978 · Maxwell Afb, AL N2365GCessna 182B · S/N 51665Cancelled Dec 1, 2004 · Triennial form not returned · Built 1958 · Maxwell Afb, AL N5230DCessna 172N · S/N 17272460Cancelled Oct 6, 2004 · Triennial form not returned · Built 1979 · Montgomery, AL N9307XCessna 182R · S/N 18268482Cancelled Oct 23, 2002 · Triennial form not returned · Built 1985 · Maxwell Afb, AL N4896NCessna 182Q · S/N 18267443Cancelled Oct 22, 2002 · Triennial form not returned · Built 1979 · Maxwell Afb, AL N5823VSchweizer SGU 2-22E · S/N 199Cancelled Oct 21, 2002 · Triennial form not returned · Built 1964 · Maxwell Afb, AL N758NECessna R172K · S/N R1723222Cancelled Oct 21, 2002 · Triennial form not returned · Built 1979 · Maxwell Afb, AL N9919HCessna 182R · S/N 18268112Cancelled Sep 13, 2002 · Triennial form not returned · Built 1981 · Maxwell Afb, AL N99261Cessna 172P · S/N 17276423Cancelled Sep 13, 2002 · Triennial form not returned · Built 1985 · Maxwell Afb, AL N17869Schweizer SGS 2-33A · S/N 242Cancelled Aug 21, 2002 · Triennial form not returned · Built 1972 · Maxwell Afb, AL N2033TSchweizer SGS 2-33A · S/N 463Cancelled Aug 21, 2002 · Triennial form not returned · Built 1976 · Maxwell Afb, AL N5040LLake LA-4-200 · S/N 497Cancelled Aug 21, 2002 · Triennial form not returned · Built 1972 · Maxwell Afb, AL

Back to Civil Air Patrol Inc