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.

N642GInguagiato Thomas · Hood River, ORBuilt 1987 · S/N E-2372N642TDN642td LLC · Newark, DEBuilt 1978 · S/N LJ-766N6431SGold Aviation LLC · Tulsa, OKBuilt 2010 · S/N FL-717N643EAAir Adventures Corp · Charleston, SCBuilt 2001 · S/N LJ-1643N643RTOld Glory Leasing LLC · Fargo, NDBuilt 1989 · S/N 560-0019N644ASAlaska Airlines Inc · Seattle, WABuilt 2003 · S/N 30795N644JCBic Aviation LLC · Fort Smith, ARS/N LJ-698N6450LZimin Transportation LLC · South Naknek, AKBuilt 2010 · S/N FL-720N6451DEastern Stearman Inc Trustee · Leesburg, VABuilt 1982 · S/N BB-1009N6458CMb/F Inc · Greensboro, NCBuilt 1985 · S/N TH-1495N645ATHinterland Holdings LLC · Anchorage, AKBuilt 2013 · S/N 208B5009N645SKBendavid Gary · Oak Bluffs, MAS/N TH-2118N64609Sr Aviation LLC · Pocola, OKBuilt 1982 · S/N E-2055N6467XScottfree Aviation LLC · West Palm Beach, FLBuilt 1982 · S/N E-2056N646ATHinterland Holdings LLC · Anchorage, AKBuilt 2014 · S/N 208B5087N646DRWilderness Aircraft Co LLC · Bloomington, MNBuilt 1980 · S/N BB-646N646VPM2 Aviation LLC · Pasadena, TXBuilt 2007 · S/N 525-0646N64774Davis Aviation Inc DBA · Brandon, MSS/N FL-684N64793N64793 LLC · Naples, FLBuilt 1982 · S/N E-2057N647MCCollier Mosquito Control District · Naples, FLBuilt 1967 · S/N 087N64809United Airlines Inc · Chicago, ILBuilt 2013 · S/N 42821N64844United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42184N648ASale Reported · Chicago, ILSale reportedBuilt 2004 · S/N 560-0657N648DDDashdale Aviation LLC · Fort Dodge, IABuilt 1999 · S/N BB-1683N648HERocket Air LLC · Carson City, NVBuilt 1997 · S/N 525-0219N648JRStreamline Aviation LLC · Henderson, NVBuilt 1977 · S/N E-1070N648SBHays Kelly · Dumas, TXBuilt 1979 · S/N 421C0648N648TTTownes Aircraft Sales LLC · Paris, TXBuilt 2017 · S/N 208B5408N6492CSouth River Services LLC · Myrtle Beach, SCBuilt 1982 · S/N LJ-1050N649ECDriggers David M · Tifton, GABuilt 1981 · S/N TH-1323N649JCDeja Air LLC · Morristown, TNBuilt 1980 · S/N BB-649N649TTTownes Aircraft Sales LLC · Paris, TXBuilt 2005 · S/N 342N64BWSkyjams Holdings LLC · Las Vegas, NVBuilt 1975 · S/N E-656N64DDMorton Steven D · Wynantskill, NYS/N E-73N64DWNavation LLC · Lauderhill, FLBuilt 1973 · S/N TH-306N64FBFremont Bank · Fremont, CABuilt 2020 · S/N FL-1238N64FFSanford Health · Sioux Falls, SDBuilt 2000 · S/N FL-308N64FTTennison Bryan · Aledo, TXBuilt 1991 · S/N 5600142N64HAJoe Air LLC · Sellersburg, INBuilt 1999 · S/N 258448N64KAXin Han Aviation LLC · Helena, MTBuilt 1973 · S/N LJ-606N64LAHanner Investments LLC · Appling, GAS/N TH-978N64LMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1995 · S/N TH-1749N64LVDitch Diggers Aviation LLC · Lisle, ILBuilt 1996 · S/N 560-0345N64PFW & L Consultants Inc · Dunn, NCS/N E-3452N64SVR S & I Inc · Idaho Falls, IDBuilt 2007 · S/N 560-0764N64TRUS Special Operations Command · Tampa, FLBuilt 2007 · S/N FL-544N64VBTamworth Aviation LLC · Allen, TXBuilt 1973 · S/N TH-305N64WRAlesia Holdings LLC · Beaumont, TXBuilt 2001 · S/N TH-1981N64ZLewis Timothy W · Thousand Palms, CABuilt 1976 · S/N E-918N6509TTextron Aviation Inc · Wichita, KSS/N 208B5982
Back to AD 2006-16-18 R1