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.

N3019VTimmons Mark M · New Port Richey, FLBuilt 1947 · S/N D-423N301CLWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N 221N301CTVatm Sky Investments LLC · Thomson, GABuilt 1980 · S/N TH-1166N301CWSky 005 LLC · Colorado Springs, COBuilt 1985 · S/N FA-53N301DRKeeton Joe M · Hertford, NCBuilt 1977 · S/N 501-0273N301JFGrace Eric C · Valdosta, GABuilt 1979 · S/N E-1593N301KHAeko Kula LLC DBA · Honolulu, HIBuilt 1995 · S/N 27904N301NWAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33342N301PRussell Bill W · Victoria, TXBuilt 1978 · S/N TH-890N301PAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31255N301TSNeptune Aviation Services Inc · Missoula, MTBuilt 1979 · S/N BE-76N301WYOrion Air Holdings LLC · Cheyenne, WYS/N BB-476N3021VMunoz Pedro L · Ontario, NYBuilt 1947 · S/N D-425N3021WElliott Robert · Hartington, NES/N E-459N3024HMll Air LLC · Kalispell, MTBuilt 1994 · S/N E-2863N30282Saucerman Equipment Leasing LLC · Indianapolis, INFirst renewal noticeBuilt 1987 · S/N E-2357N3028WK2 Aviation LLC · Carroll, IABuilt 1973 · S/N E-465N302BCG2 Leasing LLC · Cedar Spring, MIBuilt 1982 · S/N E-1982N302BZFerguson And Sons Construction LLC · Emmett, IDBuilt 1980 · S/N 501-0193N302CGKiowa Turbine LLC · Galesburg, ILS/N BB-1112N302FLBank Of Utah Trustee · Salt Lake City, UTS/N 30072N302PSF90x LLC · Modesto, CABuilt 1990 · S/N FA-213N302WDivine John S III DBA · Myrtle Beach, SCS/N E-302N302WCCst Management LLC · Pflugerville, TXBuilt 1995 · S/N 560-0329N3030DBoardwalk Management LLC · Kalispell, MTBuilt 1999 · S/N E-3230N3030GDutch Aviation LLC · Perry, IAS/N LJ-1117N3030SBrewer Mike · Cameron Park, CABuilt 1978 · S/N E-1280N3031QBrut N3031q · Los Angeles, CAFirst renewal noticeBuilt 1998 · S/N E-3196N3033BPalms Edward M · Greenwood Village, COBuilt 1998 · S/N TH-1869N3034CTyler Bonnie Flying LLC · Tyler, TXBuilt 1986 · S/N E-2341N303CAM&H Flight Services LLC · Kerrville, TXBuilt 1986 · S/N LJ1134N303CJLand Of Indiana Inc · Bedford, INBuilt 1979 · S/N BB-596N303CPDjh1 LLC · Liberty Township, OHBuilt 2000 · S/N 560-0539N303GVState Of Alaska · Palmer, AKBuilt 1996 · S/N 208B0581N303HCN303hc LLC · Amarillo, TXBuilt 1998 · S/N 560-0460N303HVRegistered aircraftBuilt 1994 · S/N E-2864N303KHNas Aircraft Leasing Company LLC · Anchorage, AKBuilt 1999 · S/N 25606N303KMCoastal Rentals LLC · Allen, KYBuilt 2000 · S/N 525-0180N303MPAir Cargo Services LLC · Miami, FLS/N 390N303NMiles James · Memphis, TNBuilt 1981 · S/N E-1880N303PCJc Pace Holding Co · Fort Worth, TXBuilt 1999 · S/N 650-7098N303RRG2 Leasing LLC · Fargo, NDBuilt 1997 · S/N FL-178N303SASoder Christopher R · Hewitt, TXBuilt 1971 · S/N E-303N303TSCheyenne Air LLC · Ocean City, NJBuilt 1981 · S/N 31T-8166007N303TTCoop Aero LLC · New Albany, MSBuilt 2001 · S/N E-3377N303TWLogistic Air Inc · Reno, NVS/N 20116N30401United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30118N3041VGood Brian L · Wildomar, CABuilt 1947 · S/N D-448N3044W625 Mike Tango LLC · Dickinson, TXBuilt 1973 · S/N TH-344N3045TRegistered aircraftBuilt 1987 · S/N E-2369
Back to AD 2006-16-18 R1