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.

N278NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4253 N279NVSunrise Asset Management LLC · Las Vegas, NVS/N 5250 N280NVDustland LLC · Las Vegas, NVS/N 5320 N281AVAircol 14 Trust · Wilmington, DEBuilt 2010 · S/N 4281 N281GXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2830 N281NVDustland LLC · Las Vegas, NVS/N 5381 N282GXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2851 N282NVSunrise Asset Management LLC · Las Vegas, NVS/N 2875 N283NVSunrise Asset Management LLC · Las Vegas, NVS/N 2920 N284AVAircol 16 · Wilmington, DEBuilt 2010 · S/N 4284 N284NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2012 · S/N 5045 N285GXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 1936 N285NVAllegiant Air LLC · Las Vegas, NVBuilt 2012 · S/N 5067 N286NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4447 N287NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4508 N288NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4537 N289GXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 3016 N289NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2011 · S/N 4574 N290NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2191 N290XCMojave Jet LLC · Wilmington, DES/N 290 N291GXGlobal Crossing Airlines Inc · Miami, FLBuilt 2007 · S/N 3349 N291NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2206 N292NVBank Of Utah Trustee · Salt Lake City, UTS/N 4891 N293NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4913 N294NVBank Of Utah Trustee · Salt Lake City, UTS/N 4941 N295NVBank Of Utah Trustee · Salt Lake City, UTS/N 4942 N296NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 2674 N297NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 2778 N298NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 2800 N299NVAllegiant Air LLC · Las Vegas, NVBuilt 2011 · S/N 4870 N3014RAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5842 N301DVDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 6923 N301NBDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 1058 N301NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2319 N302DNDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 7031 N302NBDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 1062 N302NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2005 · S/N 2387 N303DNDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 7061 N304DNDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 7112 N305DNDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 7149 N305NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2005 · S/N 2398 N306DNDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 7165 N306NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2005 · S/N 2420 N307DXDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 7214 N307NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2005 · S/N 2427 N308DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7233 N308NVSunrise Asset Management LLC · Las Vegas, NVS/N 2450 N309DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7268 N309NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2007 · S/N 3084 N310DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7293

Back to AD 2011-19-01 R1