Skip to content

Gulfstream American AA-5B

Registered aircraft · 216

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

N105NABond Gary G · Harvest, ALBuilt 1978 · S/N AA5B-1016 N123ESPlane Fun Inc Tr Trustee · Snellville, GABuilt 1979 · S/N 1021 N1353NSubsonic Aviation Leasing LLC · Grandville, MIBuilt 1979 · S/N AA5B1242 N144RLHanshew James M · Phoenix, AZS/N AA5B1034 N148RRDunbar Richard · El Dorado Hills, CABuilt 1978 · S/N AA5B-1008 N1520Littler David E · Largo, FLBuilt 1978 · S/N AA5B0957 N15NBMorris Russell K · Cameron Park, CABuilt 1978 · S/N AA5B0974 N1673KRoznowski Wayne A · Alpena, MIS/N AA5B1193 N16PXSmith Howard Michael · Wynne, ARBuilt 1979 · S/N AA5B1079 N1966LTiger N1966l Corp · New York, NYBuilt 1979 · S/N AA5B1220 N1979GBerardo Frederick Andrew · Redmond, ORBuilt 1978 · S/N AA5B1041 N2072XBraude Bradford H · Independence, OHS/N AA5B-1101 N2121TSiebols Johan · Friendswood, TXS/N AA5B-1031 N22JTThompson Joseph Trustee · Adams, MAS/N AA5B1198 N2332TFinch Stanley F · San Marcos, TXBuilt 1978 · S/N AA5B0934 N241TTTherrell G Tony · Kannapolis, NCBuilt 1979 · S/N AA5B1113 N254Russell Dale Christopher · Sierra Vista, AZBuilt 1978 · S/N AA5B0970 N28003Jensen Larry R · Palo Alto, CABuilt 1978 · S/N AA5B0935 N28006Hellwig Frederic C · Nevada City, CABuilt 1978 · S/N AA5B0938 N28214Wellum Jeffrey B · West Terre Haute, INBuilt 1978 · S/N AA5B0939 N28218Bottorff Todd N · Roachdale, INBuilt 1978 · S/N AA5B0942 N28220Registered aircraftBuilt 1978 · S/N AA5B0943 N28222Just Plane Erie LLC · Erie, COBuilt 1978 · S/N AA5B0945 N28224Barchik Edward C · Huntington Mills, PABuilt 1978 · S/N AA5B0946 N28226Brown Jeremy D · Angleton, TXS/N AA5B0948 N28227Hicks Tony L · Bixby, OKBuilt 1978 · S/N AA5B0949 N28230Kozak Gary D · Downers Grove, ILBuilt 1978 · S/N AA5B0953 N28236Cathmoir Ruari M · Forfar AngusBuilt 1978 · S/N AA5B0956 N28240Cannon Mark E · Indialantic, FLBuilt 1978 · S/N AA5B0958 N28241Teague Jason H · Fort Worth, TXS/N AA5B0959 N28242Registered aircraftBuilt 1978 · S/N AA5B0960 N28243Newsum Robert G · Columbia, TNBuilt 1978 · S/N AA5B0961 N28244Nelson William Richard · League City, TXBuilt 1978 · S/N AA5B0964 N28247Flying 64th Inc · Oak Ridge, TNBuilt 1978 · S/N AA5B0966 N28250Wallace Kelly W · Gaithersburg, MDS/N AA5B0968 N28263Fletchair Inc · Comfort, TXBuilt 1978 · S/N AA5B0977 N28264Baisley Daniel W · Lynnwood, WABuilt 1978 · S/N AA5B0978 N28265Thiel Wolfgang Edward · Athens, TXBuilt 1978 · S/N AA5B0980 N28268Flr Aero LLC · Newman, CABuilt 1978 · S/N AA5B0983 N28269Abram Simoff & Assoc · Madison, NJBuilt 1978 · S/N AA5B0985 N28274Hall David G · Rossford, OHS/N AA5B0989 N28277Boyd Aviation LLC · Sandy, UTBuilt 1978 · S/N AA5B0992 N28969Silva Carlos A · Massapequa, NYBuilt 1978 · S/N AA5B0911 N28976Kirby Benjamin · Colorado Springs, COBuilt 1978 · S/N AA5B0914 N28981Walker William B · Spokane, WABuilt 1978 · S/N AA5B0919 N28983Radel Anne-Marie · West Hills, CABuilt 1978 · S/N AA5B0921 N28986Recreation Plus Inc · London, OHBuilt 1978 · S/N AA5B0922 N289915 By 5 Aircraft LLC · New Braunfels, TXBuilt 1978 · S/N AA5B0926 N28993Fradkin Tyler Jacob · Redondo Beach, CABuilt 1978 · S/N AA5B0927 N28995Carlson Linda · Broomfield, COBuilt 1978 · S/N AA5B0929

Back to Gulfstream American AA-5B