Skip to content

Registered aircraft · 57

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

N107BJJanowsky Bruce G · Lakewood, NYBuilt 2003 · S/N 6054 N110BKSomes Jason S · Santa Rosa Valley, CABuilt 2007 · S/N 6077 N114PSPitts S2b LLC · Salinas, CABuilt 1998 · S/N 6006 N114RMImmelman Leasing Company LLC · Lompoc, CABuilt 1999 · S/N 6030 N126BBG & M Aviation LLC · Kokomo, INBuilt 2001 · S/N 6046 N127PSParsa Aviation LLC · Boca Raton, FLS/N 6010 N133PSBrew City Acro LLC · Milwaukee, WIBuilt 2000 · S/N 6037 N142PSSidney Aviation LLC · Sidney, NEBuilt 1999 · S/N 6022 N146PSAttitude Aerobatics LLC · Wilmington, DES/N 6061 N148FRamsey William · Eagan, MNBuilt 2000 · S/N 6035 N148PSAsplundh Wayne B · Philadelphia, PABuilt 2001 · S/N 6048 N148TABusiness Revenue Corp · Newton, IABuilt 1998 · S/N 6014 N15TABasham Kristina · Danville, CABuilt 2001 · S/N 6045 N166Vertical Works East LLC · Brielle, NJS/N 6025 N171JRParadox Aviation LLC · Whiting, IABuilt 1998 · S/N 6012 N177CDDyson Raymond E · Vero Beach, FLS/N 6069 N177PSOvaert Daniel · Tryon, NCBuilt 2000 · S/N 6038 N188PSBlackbird Jet LLC · Boca Raton, FLS/N 6074 N19FCRegistered aircraftBuilt 1999 · S/N 6027 N254BTTaylor Bryan E · Waco, TXBuilt 1999 · S/N 6023 N2UQCox Paul Bartlett · Granbury, TXBuilt 1999 · S/N 6031 N2ZFSplit S LLC · Bayfield, COBuilt 2000 · S/N 6040 N312PSCon Air LLC · Lake Providence, LABuilt 1998 · S/N 6011 N31TAFulltron Aviation LLC · Springfield, MOBuilt 2001 · S/N 6047 N325BFSunshine Flyer LLC · Denver, COBuilt 2002 · S/N 6051 N340BFRegistration Pending · Simi Valley, CARegistration pending, pending cancellationBuilt 2003 · S/N 6055 N370BFDaal Inc · Wilmington, DEBuilt 2004 · S/N 6065 N375BFDb Aviation LLC · Walnut Creek, CABuilt 2005 · S/N 6071 N37SGGroce Steven F · Springfield, MOBuilt 2001 · S/N 6050 N380BFTidmore Argie D · Pottsville, PABuilt 2005 · S/N 6072 N3812Kline Brad · Finksburg, MDBuilt 2004 · S/N 6064 N385BFGriffith Jonathan E · Newark, NJBuilt 2007 · S/N 6078 N411PS4d Aerosports Inc · Wilmington, DEBuilt 2004 · S/N 6067 N41PSGarwood Brandon A · Poland, OHBuilt 2003 · S/N 6058 N421SGElevate Our Vetrans Ltd · Meridian, IDBuilt 2003 · S/N 6059 N44HVMarinella Steve · Chandler, AZBuilt 2003 · S/N 6056 N44QQEastern Stearman Inc Trustee · Leesburg, VABuilt 2000 · S/N 6034 N454JMBentlage Roger E · Marquette, MIBuilt 2007 · S/N 6076 N49TASeubert Enterprises Inc · Cottonwood, IDBuilt 2003 · S/N 6049 N4LXAcroair II LLC · Litchfield Park, AZBuilt 1999 · S/N 6029 N51PSEastern Stearman Inc Trustee · Leesburg, VABuilt 2010 · S/N 6087 N531RMSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1999 · S/N 6018 N540BHExtreme Attitude Recovery & Aerobatics LLC · Cincinnati, OHBuilt 2000 · S/N 6033 N556DBSr Holding And Investment LLC · Wilmington, DEBuilt 2002 · S/N 6053 N57BCSchenk Douglas E · Tonawanda, NYBuilt 2001 · S/N 6042 N57SDNuza Philip A · Sidney, MEBuilt 2001 · S/N 6043 N64LBThermal Research Corp · Pensacola, FLBuilt 1999 · S/N 6028 N69KDBrewer John Eric · Fresno, CABuilt 1998 · S/N 6016 N727AZLazy 8 Aerobatics LLC · Cushing, MEBuilt 2008 · S/N 6080 N86PSHelijet Holdings LLC · Wellington, FLBuilt 2004 · S/N 6063

Back to Aviat S-2C