Skip to content

Gulfstream American AA-5A

Registered aircraft · 99

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

N1234DGonzales Jaime T · Mandeville, LABuilt 1979 · S/N AA5A0860 N131KYJett Edward C Jr · Bloomfield, KYBuilt 1979 · S/N AA5A0828 N22RLFrewen Maclain S · Saint Francis, KSBuilt 1979 · S/N AA5A0856 N26253Tompkins Robert G · Panacea, FLBuilt 1979 · S/N AA5A-0819 N26717Dumpling Girls LLC · Concord, NCBuilt 1978 · S/N AA5A0671 N26718Owen James T · Broken Arrow, OKS/N AA5A0673 N26722Neutren Glenn · Fort Bragg, CABuilt 1978 · S/N AA5A0675 N26723Fulcrum Software Corp · Raleigh, NCBuilt 1978 · S/N AA5A0676 N26725Registered aircraftS/N AA5A0678 N26728Schmicker Robert A · Edmond, OKBuilt 1978 · S/N AA5A0680 N26737Noser Thomas C · Bowling Green, KYBuilt 1978 · S/N AA5A0683 N26738Hardy David G · Gilbert, SCBuilt 1978 · S/N AA5A0684 N26743Lian Jay · Gold Beach, ORBuilt 1978 · S/N AA5A0686 N26744Flying Tigers Flight School Ltd · Houston, TXBuilt 1978 · S/N AA5A0688 N26757Terranova Jay · Lawrenceville, GAS/N AA5A0695 N26758Cooley Carolyn A · Bonifay, FLBuilt 1978 · S/N AA5A0696 N26760Davis Dana J · Pismo Beach, CABuilt 1978 · S/N AA5A0699 N26768Cheetah268 LLC · Kailua Kona, HIBuilt 1978 · S/N AA5A0704 N26770Tuan Vo · Falls Church, VABuilt 1978 · S/N AA5A0705 N26780Campbell Joseph · Niceville, FLBuilt 1978 · S/N AA5A0715 N26781Landon Easton Jeffrey Allen · Dresden, TNBuilt 1978 · S/N AA5A0716 N26784Texas Cheetah LLC · Sugar Land, TXS/N AA5A0717 N26788Redwood Aircraft LLC · Santa Rosa, CABuilt 1978 · S/N AA5A0722 N26792Mayer David J · Ingleside, ILBuilt 1978 · S/N AA5A0725 N26793Registered aircraftBuilt 1978 · S/N AA5A0727 N26794Seveca Ventures LLC · Arcola, TXBuilt 1978 · S/N AA5A0728 N26799Barton Steve K · Canon City, COBuilt 1978 · S/N AA5A0734 N26800Registration Pending · Peyton, CORegistration pendingS/N AA5A0735 N26805Barry Robert J · Gresham, ORBuilt 1978 · S/N AA5A0737 N26813Weingart Matthew S · Port Charlotte, FLBuilt 1978 · S/N AA5A0738 N26814Desert Cat Aviation LLC · Tempe, AZBuilt 1978 · S/N AA5A0739 N26822Terrier Douglas A · Southlake, TXBuilt 1978 · S/N AA5A0742 N26825Redline Aerospace LLC · Kalispell, MTS/N AA5A0744 N26829Parr Russell R · Auburn, WABuilt 1978 · S/N AA5A0747 N26830Butcher Alden K · Jane Lew, WVBuilt 1978 · S/N AA5A0748 N26831Horn Charles R Jr · Avondale, AZBuilt 1978 · S/N AA5A0749 N26839Brown Timothy · Plainfield, INBuilt 1978 · S/N AA5A0756 N26840White Mary · Thurmont, MDS/N AA5A0757 N26845Thornton Charles A · Collinsville, ILS/N AA5A0761 N26847Anderson Wayne D · Providence Forge, VAS/N AA5A0762 N26850Palm Michael · Middletown, RIBuilt 1978 · S/N AA5A0765 N26855Clarke George W · Sierra Vista, AZBuilt 1978 · S/N AA5A0769 N26860Robinson Andrew T · South Windsor, CTBuilt 1978 · S/N AA5A0773 N26872Hughes Tool & Die LLC · Norfolk, VABuilt 1978 · S/N AA5A0777 N26874Sale Reported · Sacramento, CASale reported, pending cancellationS/N AA5A0778 N26875Yin Steve · Del Mar, CABuilt 1978 · S/N AA5A0779 N26880Sinclair Ian · Pembroker, NYBuilt 1978 · S/N AA5A0782 N26885Ahern Joseph · Lake Worth, FLS/N AA5A0787 N26887Patel Ronik M · Pearland, TXS/N AA5A0789 N26888Mcguire Eric · Weare, NHBuilt 1979 · S/N AA5A0790

Back to Gulfstream American AA-5A