Skip to content

Alliant DESTINY XLT

Registered aircraft · 16

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 ('0590197', '05901BW')
  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 ('0590197', '05901BW')
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.

N1465RRozinski Tim · Columbus, WIBuilt 2004 · S/N 4C0632 N2541VMonroe Roger · Shelbyville, INBuilt 2003 · S/N 4C0603 N25578Miller George Lorin · Winnemucca, NVBuilt 2002 · S/N 4C0999A N2703NGraetz Alton P · Pound, WIBuilt 2005 · S/N 5C0639 N3009BMetcalf Robert Lawrence · Hollis, NHS/N 4C0574 N30987Blue Glendale R Jr · Cottonwood Falls, KSBuilt 2005 · S/N 4C0641 N325JLOstry James A · Bruno, NEBuilt 2004 · S/N 4C0623 N401EJLedford Timothy J · Erwin, TNBuilt 2007 · S/N 4C0600 N5076VBolinger Andy L · La Follette, TNBuilt 2006 · S/N 4C0593 N5091FColosky Kelly A · Flushing, MIBuilt 2006 · S/N 1C0209 N5095KEngler Brenda L · Bad Axe, MIS/N 3C0454 N5695NKrush Paul R · New Berlin, WIS/N 4C0604 N6538LEnsinger Charles W · Elliottsburg, PABuilt 2007 · S/N 4778 N7056FAdam Tim E · Dewitt, MIBuilt 2007 · S/N 4C0583 N9475GBorths Jamie C · Kenosha, WIBuilt 2005 · S/N 4C0642 N9475VTharp Joseph M · Lonedell, MOBuilt 2003 · S/N 4C0592

Back to Alliant DESTINY XLT