Skip to content

Registered aircraft · 1,193

Aircraft with this engine 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 engine_model_code IN ('55556')
  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 engine_model_code IN ('55556')
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.

N286AShore Aviation · Painter, VABuilt 2000 · S/N B025 N2871AGrimes Josh J · Oakwood, OHBuilt 2008 · S/N 2307147 N2910PHughes Daniel T · Broomfield, COBuilt 1999 · S/N 000772 N2919PSeltenright Iceses L · Plymouth, INBuilt 1999 · S/N 4583 N291ABurns Stephen A · Austin, TXS/N 0020 N2969AMorris Fred H · Bondurant, WYBuilt 1995 · S/N 7302007 N2977AMurray Chaz D · Stockton, CAS/N 9062006 N297ABurns Stephen A · Austin, TXBuilt 2002 · S/N 0030 N2999PScott Andrew J · Marathon, FLBuilt 1999 · S/N 582 KFB 99 N3009BMetcalf Robert Lawrence · Hollis, NHS/N 4C0574 N300PEDepaula Saulo · Princeton, MAS/N 0891115 N3024Autrey Randy D · Bethel, MEBuilt 2000 · S/N 4885 N30460Wilson John D · Inverness, FLBuilt 2011 · S/N CH2-0601-2098 N30621Baker Paul L · Sugar City, IDBuilt 2001 · S/N 6134 N30ACMyler Ashley C · Casper, WYBuilt 2018 · S/N 001 N3101LLeake Kenneth · Sapulpa, OKBuilt 2006 · S/N A331PEG N31042Blackburn Keith · Friona, TXBuilt 2005 · S/N HD05143M N3107VLim Ronald T · Redding, CAS/N SPORT 2S 0202 N3111PSale Reported · Muncie, INSale reportedBuilt 2007 · S/N IPP4-230 N3115HShute David A · Rudyard, MIBuilt 2007 · S/N IPP6-336 N31162Kelley Michael J · Discovery Bay, CAS/N 001 N31204Truax Wesley M · Macdoel, CABuilt 2003 · S/N SPIRITXL-2932 N3120LBill Steven Scott · Hollywood, MDS/N A326POW N3126RCroman Russell · Buda, TXBuilt 2003 · S/N ACJS 001 N3127XKerfoot John B · Tucson, AZS/N A293PEG N31342Stapleton Robert E · Anchorage, AKBuilt 2002 · S/N 11RES N313JGGiesbrecht Craig A · Farwell, TXBuilt 2002 · S/N 1949 N3145FZimmerman Enos J · Goshen, INS/N 3849 11/97 N314ZTBowen Robert Joseph Jr · Fort Worth, TXBuilt 2013 · S/N 0278 N3150RHorner Tom D · Mineral Wells, TXBuilt 2001 · S/N 32/2001 N3156FKinscherff Mark · Nebo, ILBuilt 2003 · S/N 16315 N31590Johnson Delmar G · Fairbanks, AKBuilt 1997 · S/N 97-1654-2SR7 N3160KLarsen Jonathan · Lagro, INBuilt 2007 · S/N 4195 N3162CNoble Raymond D · East Windsor, CTBuilt 1986 · S/N 01102 N31639Chesnutt Brad R · Lodi, CABuilt 1997 · S/N 529 N3163YFitzhenry Thomas M · Richfield, MNBuilt 2007 · S/N 16322 N31640Countryview Powered Parachutes LLC · Goshen, INBuilt 1996 · S/N 06910 N31648Sutton Alan C · Francesville, INBuilt 2000 · S/N 4998 N3164UButler William E · Quitman, MSS/N 02193X3 N3166KTurner Richard · Charlestown, INBuilt 2004 · S/N 5004 N3167UJohnson Gordon Harold · Juneau, AKBuilt 1997 · S/N 3721 N31712Zoerb Dale G · Litchfield, NEBuilt 1993 · S/N A135PEG N31725Hanshaw Joe W · Louisa, KYBuilt 2003 · S/N 16357 N31731Annis Larry · Mattoon, ILBuilt 2002 · S/N 16264 N31755Goebel David K · Ashland, KYBuilt 2000 · S/N 4878 N3176FCline Patrick E · Cedar Park, TXBuilt 2003 · S/N 0021 N3177LSchweizer Christian · Ramona, CABuilt 1998 · S/N 98-1868-25R7 N319PSSmith Patrick J · Terrell, TXBuilt 2003 · S/N 06.02/B04.07 N321JNSmith Roland J · Tulsa, OKBuilt 2003 · S/N 304058 N32211Cufr Michael J · Milton, FLBuilt 2005 · S/N 07040992

Back to Rotax 582SER