Skip to content

American Champion 7GCBC

Registered aircraft · 232

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 ('21101PL')
  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 ('21101PL')
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.

N112RASchroeder Michael L · Ayr, NDBuilt 2002 · S/N 1328-2002 N112SCNiebrugge Donny · Oklahoma City, OKBuilt 1999 · S/N 1283-99 N113MSFly2walk LLC · Loveland, COBuilt 1996 · S/N 1217-96 N115SGAileron Aviation LLC · Knoxville, TNBuilt 2001 · S/N 1316-2001 N116PCGlobal Piloting Solutions LLC · Mankato, MNBuilt 2001 · S/N 1320-2001 N117CPC P Aviation Inc · Santa Paula, CABuilt 1999 · S/N 1275-99 N117SGPowell Ryan Christopher · Bozeman, MTS/N 1358-2004 N118TMHarper Jean · Centennial, COBuilt 2000 · S/N 1303-2000 N119SGSantangelo Joseph A · Johnstown, NYBuilt 2002 · S/N 1329-2002 N11JWWhite Blaine S · Castlewood, VABuilt 1998 · S/N 1242-98 N122HSafeline Aviation LLC · Apache Junction, AZBuilt 1999 · S/N 1274-99 N122JDGrasshopper Aviation LLC · Hockley, TXBuilt 2000 · S/N 1301-2000 N1230MGoos Farms Inc · Silver City, IABuilt 2002 · S/N 1327-2002 N124RDD'Agostini Robert J · Basking Ridge, NJBuilt 2007 · S/N 1440-2007 N1267TTroxel Jeffrey L · Menomonee Falls, WIBuilt 2020 · S/N 1477-2020 N12PNRegistration Pending · Maitland, MORegistration pendingBuilt 1998 · S/N 1243-98 N131SGPrewitt Thomas R · Hope Mills, NCBuilt 2002 · S/N 1324-2002 N133MAHunt Robert J II · Freeport, PABuilt 2008 · S/N 1443-2008 N137PCFlight Fundamentals Inc · Willcox, AZBuilt 2005 · S/N 1403-2005 N139PCSavage David Edward · American Falls, IDBuilt 2002 · S/N 1339-2002 N13LGN13lg Aviation LLC · Dover, DEBuilt 2017 · S/N 1473-2017 N13PBZimmerman Michael P · Verona, WIBuilt 2022 · S/N 1483-2022 N141SCVance John C · Coleman, TXBuilt 2000 · S/N 1286-99 N143PCFuqua Royce Owen · Early, TXBuilt 2004 · S/N 1379-2004 N144DHSky 1 Inc · Wilmington, DEBuilt 1996 · S/N 1219-96 N147PCAlexander John S · Warrensburg, NYBuilt 2004 · S/N 1366-2004 N151SAKennedy Jon P · Gillette, WYBuilt 2008 · S/N 1448-2008 N153RAWeiner Marc H · Hoboken, NJBuilt 2001 · S/N 1311-2001 N154RAFulwiler Air LLC · Green Bay, WIBuilt 2005 · S/N 1391-2005 N156RACase Bruce · Verona, WIBuilt 2007 · S/N 1429-2007 N158SBTargosz Andrew H · Orland Park, ILBuilt 1998 · S/N 1248-98 N159PCAircraft Owners And Pilots Assoc · Frederick, MDBuilt 2006 · S/N 1418-2006 N15GVCloud 916 LLC · Dover, DEBuilt 2000 · S/N 1297-2000 N15SEWilliams Paul E · Kendallville, INBuilt 2005 · S/N 1386-2005 N161WFMaier Diane K · Underwood, WABuilt 2017 · S/N 1472-2016 N162ACWatson Tommy R · Thibodaux, LABuilt 1997 · S/N 1235-97 N163BCClear Skies Aviation Inc · Hayward, CABuilt 2004 · S/N 1370-2004 N165RAEl Rancho Escondido Inc · Brownsville, TXBuilt 2004 · S/N 1367-2004 N167PCBlue Mountain Flyers Inc · Palmerton, PABuilt 2003 · S/N 1349-2003 N167TCFarzaneh-Far Ramin · Brookline, MABuilt 2001 · S/N 1304-2000 N169PCSachau Glen R · Spearfish, SDBuilt 2004 · S/N 1359-2004 N173PWSunspot Meadow LLC · Cloudcroft, NMBuilt 2004 · S/N 1362-2004 N174RAWelke Gregory E · Chippewa Falls, WIBuilt 2005 · S/N 1390-2005 N174SGMoore Stan · Amarillo, TXBuilt 2008 · S/N 1441-2007 N175RABrabec Frank F · Indio, CABuilt 2002 · S/N 1332-2002 N179RAMorter Roger P · Hermiston, ORBuilt 2004 · S/N 1352-2003 N183RAYaggie Allen · Wahpeton, NDBuilt 2005 · S/N 1396-2005 N186RABig T Aviation LLC · Wilmington, DEBuilt 2003 · S/N 1338-2002 N187LCArd Sammy · Pamplico, SCBuilt 1999 · S/N 1272-99 N189BCross X Country LLC · Great Falls, VABuilt 1998 · S/N 1246-98

Back to American Champion 7GCBC