Skip to content

Airbus A319-112

Registered aircraft · 27

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

N1630ABank Of Utah Trustee · Salt Lake City, UTS/N 1630 N177XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 2836 N1805ABank Of Utah Trustee · Salt Lake City, UTS/N 1805 N285GXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 1936 N301NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2319 N302NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2005 · S/N 2387 N305NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2005 · S/N 2398 N306NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2005 · S/N 2420 N307NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2005 · S/N 2427 N308NVSunrise Asset Management LLC · Las Vegas, NVS/N 2450 N324NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2006 · S/N 2709 N325NVSunrise Asset Management LLC · Las Vegas, NVS/N 2729 N338NVSunrise Asset Management LLC · Las Vegas, NVS/N 2378 N524VAN524va Trust · Wilmington, DEBuilt 2007 · S/N 3204 N527VAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 3417 N553SXUmb Bank Na Trustee · Salt Lake City, UTS/N 3171 N771XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2003 · S/N 1980 N772XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2003 · S/N 1997 N773XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2003 · S/N 2012 N774XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2003 · S/N 2019 N775XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 2198 N776XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 2209 N778XFBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4127 N910FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2002 · S/N 1781 N941FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2483 N943FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2518 N949FRUmb Bank N A Trustee · Salt Lake City, UTBuilt 2006 · S/N 2857

Back to Airbus A319-112