OpenAirDocs.org
AD 2006-16-18 R1

Registered aircraft · 11,798

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:2006-16-18-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:2006-16-18-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.

N840AAD And S Western Holdings LLC · Garden City, TXBuilt 1997 · S/N 560-0433N840BMJsj LLC · Wilmington, DEBuilt 2000 · S/N 650-7118N840CAMetrea Special Aerospace Isr Inc · Bethany, OKS/N FL-104N840CTKeith Hammett LLC · Missoula, MTBuilt 1993 · S/N 560-0236N840DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31951N840JATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1985 · S/N 20800056N840MABank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 208B2423N840NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 33518N840PMCassill Aircraft Leasing Inc · Cedar Rapids, IABuilt 2004 · S/N 525-0541N840SYBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 42084N841DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31952N841FEFederal Express Corp · Memphis, TNBuilt 1988 · S/N 208B0144N841KYPinaire Holdings LLC · Hendersonville, TNS/N BB-841N841MSSafari Intl LLC · Lewes, DEBuilt 1984 · S/N 650-0056N841NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30914N841TWMorton Mark H · Granbury, TXBuilt 1994 · S/N E2881N841UPWheels Up Partners LLC · New York, NYBuilt 2015 · S/N FL-987N842CTCenac Towing Co LLC · Houma, LABuilt 2019 · S/N FL-1174N842DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31953N842DYAltimate Transportaton Services LLC · Dallas, TXFirst renewal noticeBuilt 1977 · S/N 421C0312N842EElectric Boat Corp · Groton, CTBuilt 1998 · S/N UE-336N842EBIsr Aviation LLC · Wilmington, DEBuilt 1989 · S/N 208B0146N842EXUnited States Navy · Patuxent River, MDBuilt 2005 · S/N FL-456N842NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31099N8430NFitch John A · Cary, ILBuilt 1978 · S/N 421C0490N843AHDynamics Flight LLC · Milwaukee, WIBuilt 1984 · S/N E2190N843BCA To Z Aviation LLC · Paradise Valley, AZS/N BB-1011N843CMLamar Lending LLC · League City, TXBuilt 1975 · S/N E-754N843DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31954N843EElectric Boat Corp · Groton, CTBuilt 1998 · S/N UE339N843FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0147N843FSWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N FL-843N843NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30906N843RBReal Logistics LLC · Wlimington, DES/N 208B5173N843SASpirit Air Inc · Salmon, IDBuilt 2002 · S/N 208B0930N844BEJoe Koch Construction Inc · Youngstown, OHBuilt 1984 · S/N E2199N844CN844c LLC · Fort Lauderdale, FLS/N LJ-866N844CAWilmington Trust Co Trustee · Wilmington, DEBuilt 2002 · S/N FL-350N844CKTurpin Time LLC · Helena, MTBuilt 1979 · S/N 421C0706N844DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31955N844FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0149N844MMGp Aviation LLC · Morristown, NJBuilt 2014 · S/N 525-0844N844NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 33212N845Air Choini LLC · Miami, FLBuilt 2015 · S/N 208B5256N845AMWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 36706N845ATApalach Adventures LLC · Chattanooga, TNBuilt 2000 · S/N 560-0547N845BBN845bb Partners LLC · Richmond, VABuilt 2000 · S/N 650-7115N845DBPierce Ryan · Longview, TXBuilt 1982 · S/N E-2044N845DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31956N845FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0152
Back to AD 2006-16-18 R1