Skip to content

Registered aircraft · 10

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

N110SLaysoncraft LLC · Clarkston, MIBuilt 1960 · S/N S-79 N3534GSchrock Michael L · Felton, DEBuilt 1959 · S/N S-63 N9901CGritt Bradley · Marseilles, ILBuilt 1957 · S/N S-4 N9908CBarker Geoffrey B · Plattsburgh, NYBuilt 1959 · S/N S-11 N9911CSilva Brenda M · Snowflake, AZBuilt 1959 · S/N S-15 N9912CMcmillin Christopher W · Tucson, AZBuilt 1959 · S/N S-16 N9915CRobertson Terry N · Boynton Beach, FLBuilt 1959 · S/N S-19 N9922CCarswell Chris · Kent, WABuilt 1959 · S/N S26 N9930CRoach Stephen W · Glen Saint Mary, FLBuilt 1959 · S/N S-34 N9938CDupea Vincent P · Lilliwaup, WABuilt 1959 · S/N S-42

Back to Silvaire 8F