Skip to content

Registered aircraft · 104

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

N121LJN121lj LLC · Elmira, NYBuilt 1996 · S/N 121 N125FSAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1996 · S/N 125 N127VLE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1991 · S/N 036 N128BGE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 2000 · S/N 212 N139LRBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 139 N154RTRise Aircraft 3 LLC · Tomball, TXBuilt 1998 · S/N 154 N171ARThunderun Aviation Corp · Buffalo, NYBuilt 1999 · S/N 171 N1926SHigh Performance Aircraft LLC · El Cajon, CABuilt 1999 · S/N 180 N1932KSpeed Aviation Holdings LLC · Lewes, DEBuilt 1994 · S/N 099 N200KBRainier Jets LLC · Middletown, DEBuilt 1994 · S/N 098 N204RTCalifornia Motorsports Group Inc · San Diego, CABuilt 2000 · S/N 204 N20XPVenture Jets LLC · Lititz, PABuilt 2000 · S/N 197 N218NBDavid L Samani Md Inc · Lincoln, NEBuilt 1998 · S/N 146 N229LJN229lj LLC · Bentonville, ARBuilt 2001 · S/N 229 N239AYCavalljet Corp · The Woodlands, TXS/N 189 N239CASantiago Communities Inc · Orange, CABuilt 1996 · S/N 126 N239JCIbikunle Christopher · Dover, DEBuilt 2002 · S/N 239 N240BThunderun Aviation Corp · Glenwood, NYBuilt 1999 · S/N 175 N255TKTurbine Aircraft Services LLC · Bethany, OKBuilt 2000 · S/N 193 N25BBPark Air LLC · Glendale, CABuilt 1995 · S/N 102 N260LFEthos Aviation LLC · Cleveland, OHBuilt 2001 · S/N 231 N260RCValiair Limited Company Trustee · Casper, WYBuilt 1993 · S/N 080 N269HPJudd Air LLC · Escondido, CABuilt 1998 · S/N 161 N278TTThunderun Aviation Corp · Buffalo, NYBuilt 1995 · S/N 104 N29SNRsb Investments LLC · Washington, PAS/N 194 N2SMMagnus Caro LLC · Alpine, WYBuilt 1991 · S/N 040 N312TLSterling Aircraft LLC · Anaheim, CABuilt 1999 · S/N 172 N314SGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N 133 N31DTFa31dt LLC · Owasso, OKBuilt 1997 · S/N 147 N31EAAery Aviation LLC · Wilmington, DEBuilt 1996 · S/N 130 N31KHAery Aviation LLC · Wilmington, DEBuilt 1999 · S/N 173 N31LJDelta November LLC · Lewes, DEBuilt 1994 · S/N 097 N31TKLear 31 Partners LLC · Edwards, COBuilt 1992 · S/N 059 N31ZVEzair International Leasing And Management Inc · Wilmington, DEBuilt 1996 · S/N 127 N322PRN322pr LLC · Scottsdale, AZBuilt 1991 · S/N 038 N32HHPhi Health LLC · Tempe, AZBuilt 2000 · S/N 201 N331JAM K Rockwell Investments LLC · Fayetteville, ARBuilt 2001 · S/N 224 N331JVBoulder Falcon LLC · Salt Lake City, UTS/N 219 N331USN331us LLC · Hillsboro, ORBuilt 2000 · S/N 196 N342JPDtm Aviation LLC · Statesboro, GABuilt 1994 · S/N 100 N351ACLuna Jet LLC · Hauula, HIS/N 051 N352EFDodson International Parts Inc · Rantoul, KSBuilt 1992 · S/N 046 N365GLTms Jet 31 LLC · Wilmington, DEBuilt 1996 · S/N 128 N36BLGo Fast Aviation LLC · El Cajon, CABuilt 1994 · S/N 094 N37BMLas Express Aviation LLC · Las Vegas, NVBuilt 1994 · S/N 096 N405VSCalspan Corporation · Buffalo, NYBuilt 2001 · S/N 226 N406VSCalspan LLC · Buffalo, NYS/N 206 N40LJJcm Aviation LLC · Nashville, TNBuilt 1998 · S/N 153 N412SWThunderforce Investments LLC · Washington, DCBuilt 2002 · S/N 238 N418DLRsb Investments LLC · Washington, PABuilt 1999 · S/N 181

Back to Learjet 31A