Skip to content

Registered aircraft · 1,257

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:2000-11-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-11-21') 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:2000-11-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-11-21')
  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:2000-11-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-11-21')
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.

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 N301NBDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 1058 N301NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2319 N302NBDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 1062 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 N309NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2007 · S/N 3084 N311NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2006 · S/N 2702 N312NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2289 N313NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2300 N314NBDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 1191 N315NBDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 1230 N315NVSunrise Asset Management LLC · Las Vegas, NVS/N 2412 N316NBDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 1249 N316NVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2481 N317NBDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 1324 N318NBDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 1325 N318NVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2492 N319NBDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 1346

Back to AD 2000-11-21