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.

N3959NRobinson Shawn Tracy · Valencia, PABuilt 1947 · S/N D-1219N395AAAdvanced Air LLC · Hawthorne, CABuilt 1991 · S/N FL39N395ABFr Air LLC · Palm Harbor, FLBuilt 1999 · S/N LJ-1575N395AMHollan Air LLC · Amarillo, TXS/N BB-1101N395AVAdvanced Air LLC · Hawthorne, CAS/N FL-375N395CFCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N FL-395N395DNDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30773N395GFEverbank Na · Chicago, ILBuilt 2014 · S/N FL-933N395HEBillron LLC · Houston, TXBuilt 1992 · S/N 228N395MBAdvanced Air LLC · Hawthorne, CABuilt 2002 · S/N FL-347N395RCHealdsburg Red Car Partners LLC · Pacific Palisades, CABuilt 2007 · S/N FL-559N395SAFmco Promotions Inc · North Little Rock, ARBuilt 2000 · S/N E-3313N395TGWhite Crow Air LLC · San Luis Obispo, CABuilt 2014 · S/N FL-910N3963CRoberts Aviation LLC · Acworth, GABuilt 2019 · S/N 208B5524N3968GWatkins Aviation LLC · Golden Valley, MNBuilt 1977 · S/N 421C0422N396DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30378N396FSAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2001 · S/N LJ-1648N396GFEverbank Na · Chicago, ILBuilt 2014 · S/N FL-967N396JR396jr LLC · Macon, GABuilt 2005 · S/N 341N396MFRango Aviation LLC · Mesa, AZBuilt 1992 · S/N BB-1421N39726United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28796N39728United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28944N3975NBas Part Sales LLC · Greeley, COS/N D-860N397DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30537N397GFEverbank Na · Chicago, ILBuilt 2015 · S/N FL-989N398AStr Holdings LLC · Lafayette, INBuilt 1994 · S/N 208B0390N398BBDodson International Parts Inc · Rantoul, KSBuilt 1988 · S/N RJ-39N398DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30774N398EPJg'S Mallardaire LLC · Benton, ARBuilt 1982 · S/N E-2029N398GFEverbank Na · Chicago, ILBuilt 2015 · S/N FL-1019N398TWaffensmith Walter L Trustee · Golden Valley, MNBuilt 1976 · S/N E-976N399ABRkwa LLC · Shreveport, LABuilt 2018 · S/N 525-0990N399ALBallard Aviation Inc · Newton, KSS/N BB-1623N399DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30379N399G399g LLC · Moody, ALS/N 525-0183N399PDSpraytec Aviation Inc · Urbandale, IABuilt 2025 · S/N 525-1190N399TABeattie Richard N Trustee · Anacortes, WABuilt 2000 · S/N E-3311N399TTJuliet Foxtrot LLC · Youngstown, NYBuilt 1986 · S/N 20800099N399TWArx Air LLC · Windermere, FLBuilt 1983 · S/N LA-203N399WSGuardian Flight LLC · Lewisville, TXBuilt 1999 · S/N LJ-1547N39ADRobbins William Clark · Anchorage, AKBuilt 1972 · S/N E316N39CBRedstar Air Shows Inc · Discovery Bay, CABuilt 1976 · S/N 306-116N39CJBagwell Aviation LLC · Raleigh, NCBuilt 1993 · S/N 525-0039N39FBButler National Inc · New Century, KSS/N LJ-1165N39FNGh Equipment LLC · Dover, DEBuilt 1974 · S/N 006N39HHDig N Wings LLC · Knoxville, TNBuilt 1979 · S/N 501-0132N39HLCoastal Mobility LLC · Wilmington, NCBuilt 1985 · S/N TH-1500N39MZTiger Takeoff LLC · Columbia, MOBuilt 2000 · S/N FL-277N39TCPutnam Larry Paul · Tucson, AZBuilt 1979 · S/N E-1486N39WHGolden Touch LLC · Kalispell, MTBuilt 1976 · S/N 421C0070
Back to AD 2006-16-18 R1