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.

N176WHarwell Evin Dtrustee · Howell, MIBuilt 1978 · S/N E-1335N176XClub Turbo 176 LLC · Santa Clara, CABuilt 1976 · S/N E868N176YVHill Air Executive Inc · Fort Pierce, FLBuilt 1995 · S/N UE-176N17703Dakota Aviation LLC · Sioux Falls, SDBuilt 1977 · S/N E-1007N17704Hall Thomas N · Dothan, ALBuilt 1977 · S/N E-1008N17719United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28938N1772WRichland Flight Academy LLC · Sidney, MTBuilt 1972 · S/N E-377N17730United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28798N17748Montineri Joseph A · Port Orange, FLBuilt 1977 · S/N E-1017N17764N17764 LLC · Quincy, WABuilt 1977 · S/N E-1021N17766Elworthy Steven M · Huntington Beach, CABuilt 1977 · S/N E-1023N17769Jmk Engineering Inc · Bloomfield Hills, MIBuilt 1977 · S/N E-1027N17785Registered aircraftBuilt 1977 · S/N E-1025N17794Getting Dean W · Fort Dodge, IABuilt 1977 · S/N E-1029N177CNRca Aviation 2 LLC · Tempe, AZBuilt 1984 · S/N BB-1191N177GATippen Steel Services Inc · Boyd, TXBuilt 1997 · S/N FL-160N177GCDiamond Bar LLC · Kirkland, WABuilt 1969 · S/N 263N177LACabeza De Vaca Holdings LLC · Carrollton, TXBuilt 1985 · S/N BB1203N177MKTrans Equipment Svcs Inc · Greenville, SCBuilt 1975 · S/N LW-149N177SWGruslin Jean Pol G · Kingwood, TXBuilt 1975 · S/N E-731N177VVDodson International Parts Inc · Rantoul, KSBuilt 1997 · S/N 525-0182N17812Best Aircraft Deals LLC · Salt Lake City, UTS/N BB236N17817Dye Barrett · Abilene, TXBuilt 1977 · S/N E-1034N17819Mclendon Brian · Hawkins, TXBuilt 1977 · S/N E-1035N17826Three Six Bonita LLC · Georgetown, TXBuilt 1977 · S/N E-1036N17832Arrow Inc · Mount Sterling, KYBuilt 1977 · S/N E-1039N17833Mccall Edmund B · Portland, ORBuilt 1977 · S/N TH-827N17836Bear Dorvin L · Elida, OHBuilt 1977 · S/N E-1041N17838N17838 LLC · Scottsdale, AZBuilt 1977 · S/N E-1046N17863Loon Song Flyers LLC · Brookside, NJBuilt 1977 · S/N E-1055N1789MMjr Aviation Consultants LLC · Clearwater, FLBuilt 2010 · S/N 208B2245N178DAAr Leasing LLC · Portland, ORBuilt 1984 · S/N S550-0004N178GCRigidworks LLC · Anaconda, MTBuilt 1980 · S/N 697N178LAPonca International LLC · Bentonville, ARBuilt 1982 · S/N LA-178N178YVAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-178N17931Unlimited Sky LLC · Swansboro, NCBuilt 1977 · S/N E-1022N1794WSkyhawk Flying Club Inc · Omaha, NEBuilt 1972 · S/N E-380N17979Alford Flying LLC · Wichita, KSBuilt 1977 · S/N TH-832N17980Rowles Robert · Pittsfield, ILBuilt 1977 · S/N TH-840N179MDGem City Properties LLC · Laramie, WYS/N LJ-1091N179SAPriority Air Charter LLC · Kidron, OHBuilt 1997 · S/N 208B0594N179WBShaken Aviation LLC · Madison, ALBuilt 2011 · S/N FL-773N17AQDalila Aero Inc · Wilmington, DENon-citizen corporation, flight hours not reportedS/N 120N17BRJds Management Co LLC · Warner Robins, GABuilt 1983 · S/N TH-1372N17CDDroddy Charles V · Bryan, TXBuilt 1976 · S/N E-931N17CELdc Air LLC · Rochester, NYS/N FL120N17EARegistration Pending · Melbourne, FLRegistration pendingBuilt 1997 · S/N E-3092N17EHSystem Packaging Co Inc · Bell, CABuilt 1986 · S/N BB1257N17GGJ Aviation LLC · Boca Raton, FLBuilt 2004 · S/N FL-419N17GVVolker Management LLC · Panama City Beach, FLBuilt 1972 · S/N E-343
Back to AD 2006-16-18 R1