AD 2007-19-13

Registered aircraft · 2,446

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:2007-19-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:2007-19-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.

N411AVAircol 9 · Wilmington, DES/N 4011N413CMCargo Aircraft Management Inc · Wilmington, OHS/N 26988N416AVAircol 19 · Wilmington, DEBuilt 2009 · S/N 4167N419AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 26913N423AXOmni Planes LLC · Tulsa, OKBuilt 1996 · S/N 27569N426AVAircol 10 · Wilmington, DEBuilt 2009 · S/N 4026N426UAUnited Airlines Inc · Chicago, ILBuilt 1995 · S/N 510N427UAUnited Airlines Inc · Chicago, ILFirst renewal noticeBuilt 1995 · S/N 512N428UAUnited Airlines Inc · Chicago, ILBuilt 1995 · S/N 523N429MCAtlas Air Inc · Purchase, NYBuilt 1990 · S/N 24833N429UAUnited Airlines Inc · Chicago, ILBuilt 1995 · S/N 539N4304Bank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 4304N430UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 568N431AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1989 · S/N 24632N431UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 571N432AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27449N432UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 587N433AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1989 · S/N 24400N433UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 589N434UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 592N435GXBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 1763N435UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 613N436UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 638N437UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 655N438GTAtlas Air Inc · White Plains, NYBuilt 2002 · S/N 30766N438UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 678N439GTAtlas Air Inc · White Plains, NYBuilt 2002 · S/N 30767N439UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 683N440UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 702N441UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 751N442UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 780N443AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25202N443UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 820N444UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 824N445UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 826N446AVAircol 11 · Wilmington, DEBuilt 2009 · S/N 4046N446UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 834N447UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 836N448UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 842N449UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 851N451AVAircol 12 · Wilmington, DEBuilt 2009 · S/N 4051N451PEPa Msn 1451 LLC · Dallas, TXBuilt 2001 · S/N 01451N451UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 865N452UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 0955N453UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 1001N454AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5454N454UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 1104N455ACBank Of Utah Trustee · Salt Lake City, UTS/N 1364N455CMCargo Aircraft Management Inc · Wilmington, OHS/N 26983N455UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 1105
Back to AD 2007-19-13