Skip to content

AD 2011-19-01 R1

Registered aircraft · 1,371

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2011-19-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-19-01-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2011-19-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-19-01-R1')
  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, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2011-19-01-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-19-01-R1')
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.

N215NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1292 N218NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1229 N219NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1255 N220NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1262 N224NVSunrise Asset Management LLC · Las Vegas, NVS/N 1694 N226VLSetna Io LLC · Lincolnshire, ILS/N 2264 N228NVSunrise Asset Management LLC · Las Vegas, NVBuilt 1997 · S/N 716 N230ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 3667 N230FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6773 N230NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2001 · S/N 1372 N231XCMojave Jet LLC · Nolensville, TNS/N 231 N232FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6838 N233FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7095 N233NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2003 · S/N 2001 N235FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7272 N235NVSunrise Asset Management LLC · Las Vegas, NVS/N 1130 N236FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7389 N238FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7458 N238NVUmb Bank Na Trustee · Salt Lake City, UTS/N 2133 N239NVUmb Bank N A Trustee · Salt Lake City, UTS/N 2144 N245NVSunrise Asset Management LLC · Las Vegas, NVS/N 1550 N246NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7664 N247NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7704 N248NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7781 N249NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7766 N250NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7743 N251NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7838 N252NJAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 252 N252NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7868 N253ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 3690 N253NVAllegiant Air LLC · Las Vegas, NVBuilt 2017 · S/N 7900 N254NVAllegiant Air LLC · Las Vegas, NVBuilt 2017 · S/N 7913 N255NVAllegiant Air LLC · Las Vegas, NVBuilt 2017 · S/N 7989 N256NVSunrise Asset Managment LLC · Las Vegas, NVBuilt 2018 · S/N 8220 N257NVAllegiant Air LLC · Las Vegas, NVBuilt 2018 · S/N 8329 N258NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4015 N259NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4057 N260NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4104 N261NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4115 N262NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4122 N271NVAllegiant Air LLC · Las Vegas, NVBuilt 2006 · S/N 2932 N272NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2007 · S/N 2995 N273NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2007 · S/N 3076 N274NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2007 · S/N 3079 N275NVSunrise Asset Management LLC · Las Vegas, NVS/N 2807 N276GXFalcon Msn 2695 Trust · Wilmington, DEBuilt 2006 · S/N 2695 N276NVAllegiant Air LLC · Las Vegas, NVBuilt 2019 · S/N 8671 N277GXWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 2480 N277NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2007 · S/N 3205 N278GXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 1954

Back to AD 2011-19-01 R1