Skip to content

Scottish SERIES 100 MDL 101

Registered aircraft · 19

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

N1004NStokes David A · Burton, MIBuilt 1972 · S/N 167 N104MRMccurdy Mark L · Tucson, AZBuilt 1972 · S/N 165 N105MRPayne Craig W · Plant City, FLBuilt 1971 · S/N 138 N108BDMorgan Edward Tull Jr · Gaithersburg, MDS/N 108 N114ECBulldog132llc · Boulder, COBuilt 1971 · S/N BH100/132 N118BDKortokrax Steven D · Roanoke, INBuilt 1971 · S/N 118 N123MYBaugh Shawn · Newnan, GABuilt 1971 · S/N 124 N123SYN123sy LLC · Saint Petersburg, FLBuilt 1972 · S/N 158 N146ECBulldog146llc · Longmont, COBuilt 1972 · S/N BH100/146 N19FGAchtel Stephen E · Delavan, WIBuilt 1972 · S/N 139 N4321BRegistered aircraftBuilt 1971 · S/N 119 N457FSMeskimen Scott B · Schertz, TXS/N 129 N51TLRegistered aircraftBuilt 1972 · S/N 162 N5KECebeci Paul · Saint Augustine, FLBuilt 1971 · S/N 155 N68TLShoenberger James · Orlando, FLBuilt 1971 · S/N 121 N701BDJohnsen Christian · Big Bear Lake, CAS/N 107 N713AMApling Patrick H · Hudson, MIBuilt 1972 · S/N 157 N8267EFlippin Steven P · Oak Ridge, NCBuilt 1971 · S/N 171 N8272RCooper Patrick R · Houston, TXBuilt 1972 · S/N 164

Back to Scottish SERIES 100 MDL 101