Civil Air Patrol Inc

Registered aircraft · 127

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_name = 'CIVIL AIR PATROL INC' OR list_contains(g.other_registrant_names, 'CIVIL AIR PATROL INC')
  ORDER BY g.n_number"

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.

N1472FCessna 172N · S/N 17273007Built 1979 · Maxwell Afb, ALN17NJCessna 172P · S/N 17274527Built 1981 · Maxwell Afb, ALN19MJCessna U206G · S/N U20605372Built 1979 · Maxwell Afb, ALN2037TSchweizer SGS 2-33A · S/N 467Built 1977 · Maxwell Afb, ALN221CPSchleicher ASK-21 · S/N 21669Built 1998 · Maxwell Afb, ALN225TXCessna 182Q · S/N 18266946Built 1979 · Maxwell Afb, ALN229NYCessna 172N · S/N 17271323Built 1978 · Maxwell Afb, ALN235NYCessna 172P · S/N 17274911Built 1981 · Maxwell Afb, ALN236NYCessna 172N · S/N 17268975Maxwell Afb, ALN239TXCessna 172P · S/N 17276463Built 1985 · Maxwell Afb, ALN2474WSchweizer SGS 2-33 · S/N 30Built 1967 · Maxwell Afb, ALN2624HSchweizer SGS 2-33A · S/N 444Built 1976 · Maxwell Afb, ALN2890HSchweizer SGS 2-33A · S/N 550Built 1979 · Maxwell Afb, ALN2953HSchweizer SGS 2-33A · S/N 553Built 1979 · Maxwell Afb, ALN306BALet L-23 SUPER BLANIK · S/N 968304Built 1997 · Maxwell Afb, ALN335BALet L-23 SUPER BLANIK · S/N 988410Maxwell Afb, ALN352BALet L-23 SUPER BLANIK · S/N 998419Built 1999 · Maxwell Afb, ALN357BALet L-23 SUPER BLANIK · S/N 998319Built 1999 · Maxwell Afb, ALN358BALet L-23 SUPER BLANIK · S/N 998320Built 1999 · Maxwell Afb, ALN360BALet L-23 SUPER BLANIK · S/N 998701Built 1999 · Maxwell Afb, ALN361BALet L-23 SUPER BLANIK · S/N 008703Built 2000 · Maxwell Afb, ALN362BALet L-23 SUPER BLANIK · S/N 008704Built 2000 · Maxwell Afb, ALN363BALet L-23 SUPER BLANIK · S/N 008705Built 2000 · Maxwell Afb, ALN364BALet L-23 SUPER BLANIK · S/N 008706Built 2000 · Maxwell Afb, ALN366BALet L-23 SUPER BLANIK · S/N 008708Built 2000 · Maxwell Afb, ALN367BALet L-23 SUPER BLANIK · S/N 008709Built 2000 · Maxwell Afb, ALN371BALet L-23 SUPER BLANIK · S/N 008710Maxwell Afb, ALN378SPCessna U206G · S/N U20606322Built 1981 · Maxwell Afb, ALN387BALet L-23 SUPER BLANIK · S/N 018802Built 2001 · Maxwell Afb, ALN400AZLet L-23 SUPER BLANIK · S/N 998702Built 1999 · Maxwell Afb, ALN425CPCessna 172S · S/N 172S8687Built 2001 · Maxwell Afb, ALN427CPCessna 172S · S/N 172S8689Built 2001 · Maxwell Afb, ALN428CPCessna 172S · S/N 172S8690Built 2001 · Maxwell Afb, ALN429CPCessna 172S · S/N 172S8691Built 2001 · Maxwell Afb, ALN443BALet L-23 SUPER BLANIK · S/N 029018Built 2002 · Maxwell Afb, ALN4974NCessna 182Q · S/N 18267495Built 1979 · Maxwell Afb, ALN50935Cessna 172P · S/N 17274365Built 1981 · Maxwell Afb, ALN50MBCessna U206G · S/N U20605577Built 1980 · Maxwell Afb, ALN5154DCessna 172N · S/N 17272436Built 1979 · Maxwell Afb, ALN5204ECessna 182R · S/N 18268299Maxwell Afb, ALN521CPSchleicher ASK-21 · S/N 21694Built 1999 · Maxwell Afb, ALN5383NCessna 182Q · S/N 18267678Built 1980 · Maxwell Afb, ALN5622ECessna 182R · S/N 18268334Built 1983 · Maxwell Afb, ALN6183ECessna 182R · S/N 18268351Built 1983 · Maxwell Afb, ALN6205HCessna 182R · S/N 18267876Built 1981 · Maxwell Afb, ALN621CPSchleicher ASK-21 · S/N 21708Built 2000 · Maxwell Afb, ALN6296FCessna 172N · S/N 17273185Built 1979 · Maxwell Afb, ALN63312Cessna 172P · S/N 17275419Built 1981 · Maxwell Afb, ALN65809Schweizer SGS 2-33AK · S/N 311Built 1973 · Montgomery, ALN65846Schweizer SGS 2-33A · S/N 336Built 1974 · Montgomery, AL
Back to Civil Air Patrol Inc