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.

N3869NBenson George R · Woodlake, CABuilt 1947 · S/N D-1110N386ARRustic Corp · Fort Worth, TXBuilt 1999 · S/N 208B0787N386ATAirtrex Aircraft Mike Inc · Wichita, KSS/N FL-416N386DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30373N386GABarnes Inc · Lewiston, IDBuilt 1978 · S/N LJ-775N386MNTextron Aviation Inc · Wichita, KSS/N FL-1386N386RLKc Aviation Holdings LLC · Tonopah, NVS/N 386N387Mcghee Johnny A · Louisburg, NCBuilt 1947 · S/N D-916N38727United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28797N3873BNpa Baron LLC · Gladewater, TXBuilt 1981 · S/N TH-1255N3873JSalters James C · Montgomery, OHBuilt 1981 · S/N E-1855N3873LScott Terry Dale · Yerington, NVBuilt 1981 · S/N E-1857N3874NV Tail LLC · Milford, CTBuilt 1947 · S/N D-1116N3874YDavenport Henry B III · Charles Town, WVBuilt 1981 · S/N TH-1256N387AStatewide Transportation LLC · Oklahoma City, OKBuilt 1993 · S/N 560-0240N387ASMurfin Inc · Wichita, KSS/N LJ-1417N387ATAirtrex Aircraft November Inc · Wichita, KSS/N FL-449N387DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30374N387GDDodson International Parts Inc · Rantoul, KSS/N 560-0705N387JKTaylor Jason E · Keller, TXBuilt 1980 · S/N E-1638N387JRThree Eight Seven Jr LLC · Sunray, TXBuilt 2001 · S/N E-3393N387MMMesquite Aviation LLC · Lewes, DEBuilt 1991 · S/N 560-0109AN387TPEtpc Aviation LLC · Atlanta, GABuilt 2019 · S/N 208B5539N3886NBetson Kevin C · Newport Coast, CABuilt 1947 · S/N D-1130N388BBPw Transport LLC · Lafayette, LABuilt 1999 · S/N 281N388DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30375N388KFKiernan Companies LLC · Englewood, COBuilt 1981 · S/N LW-346N388MMAc Travel LLC · Palm Beach, FLBuilt 1986 · S/N 490N388PRicardo Barrantes Consulting Inc · Mount Dora, FLBuilt 1980 · S/N E-1778N388TAFloatsix Leasing LLC · Lubbock, TXBuilt 2014 · S/N 208B5127N388WA2029 Aircraft Trust 2 LLC Trustee · Davie, FLFirst renewal noticeS/N 27N388WWCwj Aviation LLC · Raleigh, NCBuilt 1983 · S/N 388N389DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30376N389DDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N FL389N389SRIgnite Enterprises LLC · Cerritos, CABuilt 2002 · S/N 258575N38APClear Canyon I LLC · Amarillo, TXBuilt 1988 · S/N LJ-1184N38CEBrad Keener Dds Pa · Harrison, ARBuilt 1971 · S/N TH-116N38DVMedic Choppers LLC · Springdale, ARBuilt 1968 · S/N E-83N38DZWoolard Flying Service Inc · Corning, ARBuilt 1990 · S/N TH-1577N38JVKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1992 · S/N BB-1439N38MRCam Jet Aviation LLC · Lamesa, TXBuilt 1997 · S/N 560-0412N38RLAtg112 LLC · Reno, NVBuilt 2001 · S/N 525-0420N38RRClark Martin B · Dayton, OHBuilt 1976 · S/N E-815N38SSKane Of The Upstate · Greenville, SCS/N E-544N38TLBonanza 1 LLC · Hernando, MSBuilt 1991 · S/N TH1642N38VSNv5 Geospatial Inc · Sheboygan Falls, WIBuilt 1988 · S/N BB-1313N38WBEighttwotwo LLC · Wilmington, DEBuilt 1980 · S/N E-1780N390Buford Phillip N · Bethesda, DCBuilt 1947 · S/N D-901N3908CMccreery Aviation Co Inc · Mcallen, TXBuilt 1976 · S/N 421C0136N390DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30536
Back to AD 2006-16-18 R1