Skip to content

Registered aircraft · 260

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

N6059TSible Andrew · Mckinleyville, CABuilt 1964 · S/N 15060759 N6063TMid Florida Chapter 534 · Leesburg, FLBuilt 1964 · S/N 15060763 N6064TEsquivel Francisco · Thermal, CAS/N 15060764 N6066TDonaldson Ted · Thatcher, AZBuilt 1964 · S/N 15060766 N652CFGuenther Daniel R · New Bern, NCS/N 15060585 N7989ZLunsford William E · Delaware, OKBuilt 1963 · S/N 15060089 N7997ZDerry John · Monroe, MIBuilt 1963 · S/N 15060097 N7998ZFour Winds Aeronautics LLC · Cheyenne, WYBuilt 1963 · S/N 15060098 N79AWRoberson James V · Coolidge, AZBuilt 1964 · S/N 15060261 N901SWWilson Paul C · Jefferson, GABuilt 1964 · S/N 15060734

Back to Cessna 150D