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.

N90AJBank Of Utah Trustee · Salt Lake City, UTBuilt 1991 · S/N 052N90AMTexas A And M University · College Station, TXBuilt 1989 · S/N BB-1328N90ASVs Air LLC · Atlanta, GABuilt 1986 · S/N 650-0112N90AWAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N LJ-697N90CNPrice Services Inc · Monticello, ARBuilt 1995 · S/N LJ-1410N90CTToccoa Group LLC · Odessa, FLBuilt 1974 · S/N LJ-645N90CXRock Hard Aviation LLC · Mclean, VABuilt 1999 · S/N LJ-1583N90DBDura-Built Of Delaware LLC · Lewes, DEBuilt 2018 · S/N 525-1005N90EBJet Set Aircraft Inc · Van Nuys, CABuilt 1976 · S/N TH-793N90ELTrue Airspeed LLC · Pace, FLBuilt 1973 · S/N LJ-592N90FAirborne Flight Ops Inc · Reno, NVS/N LA-235N90FBLitton Global LLC · Wilmington, DEBuilt 2003 · S/N 258613N90GLRedding Aero Enterprises Inc · Redding, CABuilt 1990 · S/N 208B0229N90HCFalcon Aviation LLC · Jupiter, FLS/N 208N90HKSantana Trading LLC · Edinburg, TXBuilt 1982 · S/N LA-176N90JFIsr Aviation LLC · Wilmington, DEBuilt 1985 · S/N 20800005N90JNScg Leasing LLC · Owensboro, KYBuilt 1973 · S/N LW-74N90JZEmerald Coast Sunsets LLC · Miramar, FLBuilt 1990 · S/N LJ-1239N90KSRelease The Twins LLC · Longview, TXBuilt 1998 · S/N LJ-1517N90LBMaza Flight LLC · Wilmington, DEBuilt 1973 · S/N LJ-573N90MEMonument Aviation LLC · North Chesterfield, VABuilt 1975 · S/N LJ-661N90MKBs LLC · Huntsville, TXBuilt 1977 · S/N 421C0282N90MURwc Aircraft Sales LLC · Gillespie, ILBuilt 1976 · S/N LJ-679N90PHTriple R Spraying LLC · Dumas, TXBuilt 1973 · S/N LW-60N90PRSfclh LLC · Yukon, OKBuilt 1996 · S/N LJ-1437N90RTFlavin Development LLC · Lake Charles, LABuilt 1981 · S/N LA-146N90SBDavidson Logistics Inc · Bridgeton, MOBuilt 1981 · S/N LA-154N90TDMike Russell Construction Inc · Marysville, CABuilt 1982 · S/N LA-183N90TJTalcorp Ec Inc · Justin, TXS/N LW-228N90TPFairview Air LLC · Fresno, CABuilt 1980 · S/N LA-66N90UAUniversal Avionics Systems Corp · Tucson, AZBuilt 1980 · S/N LA-21N90WFRegistration Pending · Midland, TXRegistration pendingBuilt 1988 · S/N FA-164N90WJDodson International Parts Inc · Rantoul, KSBuilt 1971 · S/N LJ-525N90WPRegistered aircraftBuilt 2004 · S/N 258692N9107QRitter Disposables Inc · Marion, ARBuilt 1971 · S/N E-241N9109SThomas Timber Inc · Harrells, NCBuilt 1976 · S/N E-816N910AJL'Eagle Air II Inc · Newark, DEBuilt 1981 · S/N BB-910N910ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29512N910BS5836 (Cnmi) LLC · Saipan, MPBuilt 2025 · S/N 208B5850N910DFAbotan Air LLC · Fort Lauderdale, FLS/N 650-0081N910DUDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32011N910ECState Of Tennessee Department Of Transportation · Nashville, TNBuilt 2004 · S/N 208B1090N910EHGuardian Flight LLC · Lewisville, TXBuilt 2005 · S/N LJ-1751N910FEFederal Express Corporation · Memphis, TNBuilt 1986 · S/N 208B0010N910JLHuska Trey K · Kingston, WAS/N D-850N910KGLg Air LLC · Baton Rouge, LABuilt 1983 · S/N BB1051N910KSAircraft Holding Solutions LLC · Newark, DEBuilt 1982 · S/N NA0328N910NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 31160N910SAPersistent Roots LLC · Carpentersville, ILBuilt 1999 · S/N TH-1910N910TKThompson Nathan · Boulder, COBuilt 1995 · S/N 560-0288
Back to AD 2006-16-18 R1