OpenAirDocs.org
AD 2006-16-18 R1

Registered aircraft · 11,797

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.

N1531WNeo Foot And Ankle Surgery Inc · Miami, OKBuilt 1972 · S/N E-325N1538GMiller Andrew D · Broomfield, COBuilt 1988 · S/N E-2465N1538HRobinson Manufacturing Inc · Rockford, ILBuilt 1988 · S/N E-2451N1539V39 Victor Aviation Inc · Macomb, ILBuilt 1989 · S/N E-2469N1539WM P W D Inc · Saint Charles, ILBuilt 1972 · S/N E-326N153GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-153N153KDMec International Trading LLC · Mission, TXBuilt 1968 · S/N 153N153UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 0839N1541WGobogo LLC · Fort Collins, COBuilt 1972 · S/N E-327N1544VGuardian Flight LLC · Lewisville, TXBuilt 1994 · S/N LJ-1366N1545WM T Air LLC · Olive Branch, MSBuilt 1989 · S/N TH-1545N1546FEmerald Aviation LLC · Bothell, WABuilt 1989 · S/N E-2478N1548FBovine Aerial LLC · Amarillo, TXBuilt 1989 · S/N E-2489N1548GG T Aviators LLC · Naples, FLBuilt 1989 · S/N E-2479N1548TWd21 Aviation Holdings LLC · Albany, NYBuilt 1989 · S/N E-2482N1548VFabtex Solutions Inc · Morganton, NCBuilt 1989 · S/N E-2477N1549KTallevast LLC · Sarasota, FLBuilt 1988 · S/N E-2460N1549NCampbell Catherine D · Dana Point, CAS/N E-2474N154GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-154N154JKRacd Holding LLC · Pembroke Pines, FLBuilt 1991 · S/N 560-0128N154KFRegistered aircraftBuilt 2016 · S/N FL-1054N154MNapier Aircraft Inc · Wilmington, DEBuilt 1981 · S/N E-1930N154RRN154rr LLC · Wilmington, DEBuilt 1998 · S/N 258375N154TSFalcon Aviation Holdings LLC · Hawthorne, CABuilt 2002 · S/N 30515N154UPUnited Parcel Service Co · Louisville, KYBuilt 2004 · S/N 0840N1550FMartens Bruce C · Wickenburg, AZBuilt 1989 · S/N E-2480N1550GGarrett Michael Barry · Redding, CABuilt 1989 · S/N E-2484N1550UMaxwell Monroe Air LLC · Miami, FLBuilt 1994 · S/N E-2839N1550WStulp Jensen T · Lamar, COBuilt 1972 · S/N E-329N15512Dt Holdings LLC · Olathe, KSBuilt 1989 · S/N E-2486N1552DDodson International Parts Inc · Rantoul, KSBuilt 1989 · S/N LJ-1204N1552GEast Atlantic Aviation LLC · Edenton, NCBuilt 1989 · S/N LJ-1206N1552UBendavid Gary F · Oak Bluffs, MABuilt 1989 · S/N E-2491N1553GMccloy Mark · Tatum, NMBuilt 1989 · S/N LJ-1214N1553KLl Aviation LLC · Hoover, ALBuilt 1988 · S/N E-2455N1553ZPierce Stephen J · Zebulon, NCBuilt 1990 · S/N E-2523N1555LGps Aviation LLC · Kennett, MOBuilt 1988 · S/N E-2419N1555YG E C Air LLC · Grove, OKBuilt 1989 · S/N E-2508N1557W557 Whiskey LLC · Superior, WIBuilt 1972 · S/N TH-229N155AVTeton Leasing LLC · Pocatello, IDBuilt 1985 · S/N BB-1216N155BBRegistration Pending · Greer, SCRegistration pendingBuilt 1997 · S/N BB-1554N155BWPoet Inc · Sioux Falls, SDBuilt 2018 · S/N 525-0988N155CGBigees Air LLC · Sioux Falls, SDBuilt 1997 · S/N 525-0214N155CJUe-55 LLC · Helena, MTS/N UE-55N155CLAircraft Structures International Corp · Enid, OKBuilt 1988 · S/N 208B0127N155ERAir Medical Services LLC · Denver, NCBuilt 1984 · S/N 55-098N155LSRainair Avionics Services LLC · Albertville, ALS/N LW-286N155PTWaypoint Aviation LLC · Wilmington, DEBuilt 1994 · S/N 560-0257N155SJLopez Fabio · Denver, NCBuilt 1984 · S/N 102N1560Davis Aviation Inc · Brandon, MSS/N BC-09
Back to AD 2006-16-18 R1