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.

N3046DAldredge John F · Cornville, AZBuilt 1994 · S/N E-2866N3046KBas Part Sales LLC · Greeley, COBuilt 1987 · S/N E-2362N3048VBoswell Craig A · Hernando, MSBuilt 1987 · S/N E-2363N3048WEarthbound Aviation Group LLC · Wilmington, DEBuilt 1973 · S/N E-484N3049DAnchor Equipment Leasing LLC · Covington, KYBuilt 1998 · S/N TH-1873N304BPIntermountain Air Inc · Colorado Springs, COBuilt 2019 · S/N 525-1017N304DEGreen Flash Aviation LLC · Audubon, IABuilt 2019 · S/N FL-1194N304JSRegistration Pending · Pharr, TXRegistration pendingBuilt 1988 · S/N FA142N304PCFlorida Avm LLC · Venice, FLBuilt 1986 · S/N 650-0110N304SHJaimlubec LLC · Austin, TXBuilt 1986 · S/N FA-89N30501Dutchess Community College · Poughkeepsie, NYS/N 383N3050KWalter Jones III Md Inc · Redlands, CABuilt 1987 · S/N E-2364N3051KBuilding Corp LLC · Huntsville, TXBuilt 1994 · S/N BB-1495N3052JParker Joe B · Uvalde, TXBuilt 1986 · S/N E-2346N3054ANocek Aviation LLC · Skaneateles, NYBuilt 1998 · S/N E3201N3054RJamms Aviation LLC · Bedford, NHBuilt 1994 · S/N E-2879N3056VMinneman Alan R · Jefferson, TXBuilt 1947 · S/N D-469N3058ROn Top Aviation LLC · Salinas, CABuilt 1998 · S/N TH-1870N305ELRoper Aviation LLC · Wilmington, DEBuilt 1981 · S/N BB947N305LGEaglemed LLC · Wichita, KSBuilt 2001 · S/N BB-1789N305LRAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1980 · S/N 305N305NCNca Aircraft LLC · Opa Locka, FLFirst renewal noticeBuilt 2013 · S/N 208B5052N305NXAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31253N305SAIndigo Blue Aviation LLC · Spartanburg, SCBuilt 1986 · S/N FA-111N305TTZulu Air LLC · Opa Locka, FLBuilt 1981 · S/N LJ992N305WP3192 Golf Inc · Wauchula, FLBuilt 1984 · S/N TH-1426N305ZAZulu Air LLC · Opa Locka, FLBuilt 1996 · S/N LJ-1439N3060WRegistration Pending · Ojai, CARegistration pendingBuilt 1973 · S/N E-488N3061VRegistration Pending · Amboy, INRegistration pending, pending cancellationBuilt 1947 · S/N D-474N3064VLehmann Mark C · Trade, TNS/N D-478N3065VEvans Bruce E · Aztec, NMBuilt 1947 · S/N D-479N3066BAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1987 · S/N TH-1514N3066DN3066d LLC · Pompano Beach, FLBuilt 1998 · S/N TH-1866N3066WFortis Aircraft Leasing LLC · Reno, NVBuilt 1998 · S/N LJ-1536N3067TLandsberg Bruce S · Mount Pleasant, SCBuilt 1987 · S/N E-2368N3068VBurgin Lee · Borger, TXS/N D-482N3068WSneebler Transport LLC · Burke, VABuilt 1973 · S/N E-490N306NYAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33343N306PFiebiger Brian · Davie, FLS/N E-3617N306PAAerotrust Services Corp Trustee · Wilmington, DES/N 650-0053N306PBAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31257N3072WJennings Dennis · Sequim, WABuilt 1973 · S/N E-492N3074VHancock Steven W M · Bristow, VABuilt 1947 · S/N D-488N3075PWjs Inc · Greeneville, TNBuilt 1999 · S/N TH1887N3076DSilverman Alan · Moscow, PABuilt 1987 · S/N E-2378N30771Dodson International Parts Inc · Rantoul, KSBuilt 1987 · S/N TH-1518N3077WWipaire Inc · South Saint Paul, MNBuilt 1973 · S/N E-496N3077ZBravo Air LLC · Troy, MIBuilt 1987 · S/N TH-1516N30787Jetsons Holdings LLC · Birmingham, ALBuilt 1987 · S/N TH-1521N3078PKirby Maurice H III · Marco Island, FLBuilt 1986 · S/N E-2342
Back to AD 2006-16-18 R1