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.

N3078YDodson International Parts Inc · Rantoul, KSBuilt 1987 · S/N E-2386N3079WFerr Air Ltd · Southampton, PABuilt 1987 · S/N E-2388N307ACBank Of Utah Trustee · Salt Lake City, UTS/N 30700N307DMBank Of Utah Trustee · Salt Lake City, UTBuilt 1978 · S/N BB-332N307FMNorris Aviation LLC · Mansfield, TXBuilt 1977 · S/N 421C-0323N307JSPittard Kirk L · Grapevine, TXBuilt 1999 · S/N E-3268N307MRSilverstar II LLC · Houston, TXBuilt 1977 · S/N 501-0012N307PRDog Is My Copilot Inc · Jackson, WYBuilt 1996 · S/N 208B0541N307TLHedloc Aviation LLC · Midland, TXBuilt 2019 · S/N FL-1179N307XPSkybridge Aviation Group Inc · Apopka, FLBuilt 1996 · S/N 258307N3080FGreyhawk Aviation LLC · Ketchum, IDBuilt 1999 · S/N FL-249N3080KSnuggs Ronald S · Driggs, IDBuilt 1987 · S/N E-2389N30813T L Irrigation · Hastings, NEBuilt 1987 · S/N E-2393N3083HSalters Flying LLC · South Dartmouth, MABuilt 1988 · S/N E-2425N3083VAnderson Charles E · Fort Worth, TXBuilt 1947 · S/N D-498N3084ZMather Clay · Orange Beach, ALBuilt 1988 · S/N E-2426N3085FA To Z Endeavors LLC · Leawood, KSBuilt 1987 · S/N E-2396N3085KBennett Ross G · Eustis, FLBuilt 1987 · S/N E-2401N3086KRicotta Tom · Yuma, AZBuilt 1988 · S/N E-2406N3088DAquasol Corp · Rock Hill, SCBuilt 1987 · S/N E-2398N3088VStartz John D · Dallas, TXBuilt 1947 · S/N D-504N3089VMaximus Aviation LLC · Cheyenne, WYBuilt 1947 · S/N D-505N3089ZSnyder Stephen F · Paradise Valley, AZBuilt 1987 · S/N E-2402N308ABLift Time III LLC · Cincinnati, OHS/N E-3533N308ADC208b0327 Inc Trustee · Wilmington, DEBuilt 1992 · S/N 208B0327N308CMCattlemen Logistics LLC · Minden, NEBuilt 2023 · S/N 525-1156N308CSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N LJ-1478N308DD225sbi LLC · Stuart, FLBuilt 2004 · S/N 258665N308GLN308gl LLC · Fort Worth, TXBuilt 1985 · S/N S550-0036N308MDGem City Properties LLC · Laramie, WYBuilt 1990 · S/N LJ1246N308MRStonegate Holdings LLC · San Antonio, TXBuilt 1988 · S/N 650-0153N308NJ22ase LLC · Aspen, COS/N 525-0912N308PWTexas Parks And Wildlife Department · Austin, TXBuilt 2025 · S/N 208B5856N308RMN308rm LLC · Boca Raton, FLBuilt 1974 · S/N LJ628N3093VBeavers Charles M · Rockmart, GABuilt 1947 · S/N D-510N3096VNovak Warren Devereaux Grey · Lake Placid, FLBuilt 1947 · S/N D-513N309DEDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 29634N309PCAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31258N30AFEchelon Diagnostics Inc · Reno, NVS/N 6500049N30BPLkh Group LLC · Naples, FLBuilt 2014 · S/N 525-0816N30CVTweety Bird LLC · Henderson, NVBuilt 1991 · S/N 560-0150N30DMNagle Derek · Ada, MIBuilt 1979 · S/N E-1536N30FEBpnr LLC · Lubbock, TXBuilt 1988 · S/N FA-148N30GTCal Asset Holding LLC · Fresno, CABuilt 1980 · S/N LA-37N30HEClassic Aircraft Aviation Museum Inc · Hillsboro, ORBuilt 1967 · S/N 51N30HVCustom Fabricating & Repair Inc · Marshfield, WIBuilt 1989 · S/N FA-173N30KCSkillman Management LLC · Wellington, FLBuilt 1977 · S/N LW-241N30KDHolmander John D · East Greenwich, RIS/N E-3502N30KMRefreshed 0110 LLC · Dover, DEBuilt 2021 · S/N 525-1073N30LAAerokb LLC · Wilmington, DEBuilt 1993 · S/N 5250041
Back to AD 2006-16-18 R1