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.

N777JEAir LLC · Huntingburg, INBuilt 2012 · S/N FL-818N777KNardi Greg · Titusville, FLBuilt 1982 · S/N BB-1017N777KATake-Off LLC · Knoxville, TNBuilt 1978 · S/N LW-285N777MXAirplane III LLC · Fulshear, TXBuilt 1984 · S/N 650-0051N777MYGraham Elmer R Jr · Graford, TXBuilt 2000 · S/N E-3328N777NKTaylor Jonathan K II · Granbury, TXBuilt 1996 · S/N E-2996N777NVNevada Department Of Transportation · Carson City, NVBuilt 2019 · S/N FL-1198N777PBWw Build Inc · Deland, FLBuilt 1973 · S/N E-439N777QAMabry Kelly · Russellville, ARBuilt 1970 · S/N TH-143N777RABirdsong Michael L · St Simons Island, GABuilt 1981 · S/N TH-1273N777RQSchelde Brian L · Marble Falls, TXBuilt 1973 · S/N TH-298N777SGClaw LLC · Lake Saint Louis, MOS/N TH805N777SSCalderwood Aviation LLC · Shafter, CABuilt 1980 · S/N BB-661N777TKProfessional Paving Services LLC · Macon, GABuilt 1979 · S/N TH-1018N777TQG And G Operators Ltd · Dalhart, TXBuilt 1989 · S/N BB-1335N777WVIndependent Mortgage · Westlake, LABuilt 1996 · S/N TH-1784N777WYGulf Atlantic Airways Inc · Gainesville, FLBuilt 1999 · S/N 560-0525N777XPRbwdb Aircraft LLC · Lufkin, TXBuilt 1987 · S/N FA-124N777YFLandsgaard Equipment Leasing LLC · Wellington, COBuilt 1989 · S/N E-2495N777YNPilots Choice LLC · Shreveport, LABuilt 2001 · S/N LJ-1657N7788HTeodoro Financial Group Inc · Mill Valley, CABuilt 1988 · S/N E-2436N778BValiair Lc Trustee · Casper, WYBuilt 1999 · S/N 560-0523N778DMTextron Aviation Inc · Wichita, KSS/N 208B5985N778FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0275N778MAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 34704N778RMAero Advantage Services Corp Trustee · Wilmington, DES/N 258178N7794RCherokee Aviation LLC · New Smyrna Beach, FLBuilt 1968 · S/N E-126N779AMSerenity Aviation LLC · Irvine, CABuilt 2019 · S/N FL-1178N779FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0276N779RKMcaire LLC · Newton, NCBuilt 2008 · S/N 560-0779N779VFColeman Aviation LLC · Livingston, TNS/N LJ-1254N77ACEagle Aviation Consulting LLC · Wilmington, DEBuilt 1991 · S/N E-2675N77CA77ca Associates LLC · Coral Gables, FLBuilt 1980 · S/N BB-717N77CESmall Plane LLC · Carson City, NVBuilt 1978 · S/N LW-257N77DBDarrigo Bros Co Of California · Salinas, CABuilt 2001 · S/N 525-0443N77DCOmega 377 Pennsylvania LLC · Shavertown, PABuilt 1985 · S/N E-2289N77FDN77fd LLC · Kathleen, GABuilt 1982 · S/N 5010250N77HCHlh Properties LLC · Cohutta, GABuilt 1998 · S/N E-3189N77HDArkansas Department Of Transportation · Little Rock, ARBuilt 1991 · S/N BB-1397N77HEDavis Aviation Inc · Brandon, MSBuilt 1981 · S/N LJ969N77HFCb Aircraft Inc · Fort Lauderdale, FLBuilt 1994 · S/N 650-7036N77HTLac Aero LLC · Liberal, KSBuilt 1978 · S/N E-1324N77JEEngelhardt John L · Netarts, ORBuilt 1977 · S/N E-1080N77JJCc99 LLC · Wilmington, DEBuilt 2025 · S/N 208B5912N77KNAlta Aviation LLC · Phoenix, AZBuilt 2014 · S/N 5250821N77LBEleuthera II LLC · Mesa, AZBuilt 1974 · S/N TH-536N77LXWatford Horizons LLC · College Station, TXBuilt 1995 · S/N 650-7051N77MAM Aire LLC · Wilmington, DEBuilt 1994 · S/N 560-0273N77MDDerby Michael R · Falls Church, VABuilt 1970 · S/N E-234N77METrilogy Investments Ag LLC · Las Vegas, NVBuilt 1982 · S/N 96
Back to AD 2006-16-18 R1