Skip to content

Smith AEROSTAR 600

Registered aircraft · 40

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

N10ABAm Defense · St Johns, FLS/N 60-0349-126 N11111Star Flight LLC · Bellevue, WABuilt 1976 · S/N 60-0329-121 N16HMRfs Aviation LLC · Greer, SCBuilt 1977 · S/N 60-0483-156 N1THall George E Jr · Hillsborough, NCBuilt 1969 · S/N 60-0014 N21VTCle Aviation LLC · Palm Beach Gardens, FLBuilt 1974 · S/N 60-0185-082 N21WDMullens Aviation LLC · Estero, FLBuilt 1975 · S/N 60-0197-087 N2PBRoth Jon A · Rch Palos Vrd, CABuilt 1973 · S/N 60-0140-060 N318TCGilmer Thomas · Toccoa, GABuilt 1976 · S/N 60-0316-117 N338NAMeister Scott R · Skillman, NJBuilt 1978 · S/N 60-0487-158 N3WRAic Advocates LLC · Toccoa, GAS/N 60-0386-137 N409JBPenstar Partners LLC · Wilmington, DEBuilt 1969 · S/N 60003988 N48TNWest Thomas L · Payson, AZBuilt 1975 · S/N 60-0214-094 N511ASRucker Gary R · Kingman, AZBuilt 1974 · S/N 600153067 N5678Hutter Peter S · Aspen, COBuilt 1969 · S/N 60-0017 N5FABiehunko Robert Bryan · Munford, ALS/N 600310115 N600EDWeskalnies Michael · Jarrettsville, MDBuilt 1969 · S/N 60-0013 N600FABeaver Creek Adventures LLC · Bangor, MEBuilt 1975 · S/N 60-0246-101 N600JKMcdonald Harry · Toccoa, GABuilt 1975 · S/N 60-0257-104 N600NJKralta Enterprises LLC · Sioux Falls, SDBuilt 1975 · S/N 60-0199-088 N600RSavanna Lakes LLC · Dover, DEBuilt 1969 · S/N 60-0018 N60GWBangert Computer Systems Inc · Shawnee, KSBuilt 1969 · S/N 60-0030 N60PRHarben Grover III · Gainesville, GABuilt 1978 · S/N 60-0490-159 N60VBVvs Implements LLC · Wilmington, DES/N 60-0182-080 N612HMWhittram Properties LLC · Kalispell, MTBuilt 1976 · S/N 60-0299-112 N70VBPalmy LLC · Lander, WYS/N 60-0446-150 N722TTNext Gen Aviation LLC · Jenks, OKBuilt 1976 · S/N 60-0285-108 N7400SHutter Charles G · Carson City, NVBuilt 1968 · S/N 60-0002 N7411SNaik Narayan · Claremore, OKBuilt 1969 · S/N 60-0016 N7438SFrana Joel A · Fort Myers, FLBuilt 1969 · S/N 60-0025 N7496SSmith Linda L · Port Charlotte, FLBuilt 1970 · S/N 60-0047-108 N7528SDoran Jeff T · Westerville, OHS/N 60-0190-086 N7533SD & T Wilson Co Inc · Hillsboro, INBuilt 1974 · S/N 60-0165-073 N78TSCeleritas Corp · Cranford, NJBuilt 1977 · S/N 60-0470-155 N8025JTorres Rafael · San Juan, PRBuilt 1978 · S/N 60-0503-163 N8818XBeech Bash In The Bluegrass LLC · Fort Myers, FLBuilt 1973 · S/N 60-0143-063 N90349Williams David Anthony · Port Saint Lucie, FLBuilt 1975 · S/N 60-0202-090 N90500Hutter Karl G · Carson City, NVBuilt 1976 · S/N 60-0293-110 N90509Mccollum Timothy L · Toccoa, GABuilt 1976 · S/N 60-0297-111 N92MGCastle Aviation Inc · North Canton, OHBuilt 1977 · S/N 60-0363-129 N9762QMazda Russell · Newark, DEBuilt 1977 · S/N 60-0383-136

Back to Smith AEROSTAR 600