AD 2012-09-07

Registered aircraft · 1,119

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

N326NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2005 · S/N 2586N327NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2005 · S/N 2556N328NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2006 · S/N 2821N328NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 298N329NVSunrise Asset Management LLC · Las Vegas, NVS/N 2876N329NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 306N330NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2006 · S/N 2786N331NVSunrise Asset Management LLC · Las Vegas, NVS/N 2625N332NVSunrise Asset Management LLC · Las Vegas, NVS/N 2638N333NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 329N334NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2006 · S/N 2831N334NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 339N335NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2006 · S/N 2852N335NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 340N336NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 355N337NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2170N338NVSunrise Asset Management LLC · Las Vegas, NVS/N 2378N338NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 360N339NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 367N340NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 372N341NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 380N342NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 381N343NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 387N344NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 388N345AVAircol 20 · Wilmington, DEBuilt 2010 · S/N 4345N345NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 399N347NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 408N348NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 410N349NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 417N350NADelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 418N351NWDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 766N352NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 778N353ASAersale Inc · Coral Gables, FLS/N 553N353NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 786N354NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 801N355FLBank Of Utah Trustee · Salt Lake City, UTS/N 2553N355NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 807N356NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 818N357DCAwas 3896 Trust · Wilmington, DES/N 3896N357NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 830N358NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 832N359NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 846N360NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 0903N361NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 0907N362NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 0911N363NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 0923N364NWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 0962N365NWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 0964N366DXDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8694N366NWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 0981
Back to AD 2012-09-07