Skip to content

Registered aircraft · 119

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

N811BPietsch Warren A · Minot, NDBuilt 1950 · S/N 6741 N812BHawley Elizabeth Bourland · Wichita Falls, TXBuilt 1950 · S/N 6742 N813BSutter Timothy C · Glennallen, AKS/N 6743 N815BStrong James R · Williamsville, NYBuilt 1950 · S/N 6745 N822BRichter Paul J · Chelmsford, MABuilt 1950 · S/N 6753 N829BBaxter Thomas L · Stockbridge, GABuilt 1950 · S/N 6760 N831BMorrison Ronald J · Murfreesboro, TNBuilt 1950 · S/N 6762 N832PWatson Bobby · Hoxie, ARBuilt 1950 · S/N 6764 N836BLandrum Cristi C · Dallas, TXBuilt 1950 · S/N 6768 N837BHendry Rickey · Apple Springs, TXBuilt 1950 · S/N 6769 N840BWilkey Ryan J · Saint Louis, MOBuilt 1950 · S/N 6772 N882JBBock Gregory D · Walkertown, NCBuilt 1948 · S/N 6011 N937RMCoffey Daniel J · Hartford, WIBuilt 1948 · S/N 6056 N9916CLill Stephen P · Lafayette, LABuilt 1959 · S/N S-20 N9927CMartin Harry L · Clayton, GABuilt 1959 · S/N S-31 N9931CKessler Garry A · Lansing, WVBuilt 1959 · S/N S-35 N9932CAnderson Andrew A · Bates City, MOS/N S-36 N9941CWatson Bobby · Hoxie, ARBuilt 1959 · S/N S-45 N9944CLarsen John E · Adrian, MIS/N S-48

Back to Luscombe 8F