Skip to content

American Champion 8KCAB

Registered aircraft · 450

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('2121000')
  ORDER BY 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.

SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('2121000')
ORDER BY n_number

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.

N101BYRegistered aircraftBuilt 2004 · S/N 9492004 N102JVWestern Michigan University · Battle Creek, MIBuilt 2013 · S/N 1128-2013 N104JWGobeli Michael T · East Lyme, CTBuilt 1992 · S/N 688-92 N106ACUpside Down Vt LLC · Milton, VTS/N 648-91 N107ACBad Attitude LLC · Lisbon, OHBuilt 1991 · S/N 650-91 N108HSContrails II Inc · Kerrville, TXS/N 1008-2005 N108JGStilts Steven · Houma, LABuilt 1996 · S/N 764-96 N109PCFort Wayne Aircraft LLC · Fort Wayne, INBuilt 2005 · S/N 994-2005 N111GWInternational Air Services Inc Trustee · Carson City, NVBuilt 2013 · S/N 1123-2013 N111LSGrant William S · Azle, TXBuilt 1995 · S/N 740-95 N113JJRendleman Robert T · Murphysboro, ILBuilt 2000 · S/N 858-2000 N1177BTakacs John Paul III · Colorado Springs, COBuilt 1991 · S/N 651-91 N117TMRegistered aircraftBuilt 2000 · S/N 874-2000 N118AC9 Echo LLC · Muskogee, OKBuilt 1992 · S/N 672-92 N121SGTaliaferro Leigh · Abilene, TXBuilt 2006 · S/N 1036-2007 N1230SSpecialized Aero Works LLC · Bend, ORBuilt 2005 · S/N 1011-2005 N123BYRegistered aircraftBuilt 2003 · S/N 915-2003 N123WAAshem Aviation LLC · Wilmington, DEBuilt 1993 · S/N 726-94 N124SCK2 Worldwide Inc · Simi Valley, CAS/N 8822001 N124SGFull Props LLC · Ridgeland, SCBuilt 2008 · S/N 1071-2008 N125RSAlexander William F · Chapmansboro, TNBuilt 1991 · S/N 657-91 N126WBFlying Blank LLC · La Crosse, WIBuilt 2005 · S/N 983-2005 N127SAVintage Tailwheel LLC · Wilmington, DEBuilt 2006 · S/N 1026-2006 N12TNEgret Aero Inc · Colorado Springs, COBuilt 2013 · S/N 1127-2013 N130ACBilco Air LLC · Danville, ILBuilt 1992 · S/N 663-92 N131GSStanley Gerald L · Littleton, COBuilt 1999 · S/N 839-99 N1322XGrecor LLC · Ashville, ALBuilt 2015 · S/N 1163-2015 N132ACScott John A · Odebolt, IABuilt 1992 · S/N 675-92 N132DPKarl Mark G · Wilbraham, MABuilt 1999 · S/N 822-99 N132PAAumont Eric J · Yucca Valley, CABuilt 1998 · S/N 817-98 N133NO'Brien Daniel R · Naples, FLS/N 1113-2012 N136ACPreacher John R · Jackson, GAS/N 673-92 N137ACHare Michael Aubrey · Foley, ALBuilt 1992 · S/N 676-92 N138ACZimmerman Gerald M · Savannah, GABuilt 1992 · S/N 677-92 N139ACDavis Mark A · Lubbock, TXBuilt 1992 · S/N 686-92 N141SEHydro Flyers LLC · Woodside, CABuilt 2006 · S/N 1024-2006 N142ACFly For Fun LLC · Rockville, MDBuilt 1992 · S/N 683-92 N145ACTrusler William L · Magnolia, TXBuilt 1992 · S/N 684-92 N146MAHong Ted · San Jose, CABuilt 2002 · S/N 903-2002 N147TPPatty Wagstaff Aviation Safety LLC · Saint Augustine, FLBuilt 2008 · S/N 10602008 N147TQIron Thermal LLC · Hogansville, GABuilt 2003 · S/N 920-2003 N148ACMach 1 Aircraft LLC · Malibu, CABuilt 1993 · S/N 717-93 N148AKMurphy Patrick · Englewood, COBuilt 2014 · S/N 1140-2014 N148PCSuperd LLC · Everett, WABuilt 2005 · S/N 996-2005 N149SAVan Bergen Matthew D · Arlington Heights, ILBuilt 2008 · S/N 10672008 N149SGWaterwings Seaplanes LLC · Hoover, ALBuilt 2006 · S/N 1021-2006 N14EJPrecision Air LLC · Trent, SDBuilt 1993 · S/N 709-93 N14KFParker Jerry · Houston, TXS/N 656-91 N14SASidney Aviation LLC · Sidney, NEBuilt 2014 · S/N 1146-2014 N14XDAero Leasing Inc · Wilmington, DEBuilt 2014 · S/N 1152-2014

Back to American Champion 8KCAB