Skip to content

Registered aircraft · 549

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

N278GXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 1954 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 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 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 N334NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 339 N335NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 340 N336NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 355 N338NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 360 N339NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 367 N340NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 372 N341NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 380 N342NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 381 N343NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 387 N344NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 388 N345AVAircol 20 · Wilmington, DEBuilt 2010 · S/N 4345 N345NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 399 N347NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 408 N348NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 410 N349NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 417 N350NADelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 418 N351NWDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 766 N352NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 778 N353ASAersale Inc · Coral Gables, FLS/N 553 N353NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 786 N354NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 801

Back to AD 2017-12-13