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.

N635SAGrellet-Aumont Pierre A · East Quogue, NYBuilt 2000 · S/N E-3336N63669Zimin Transportation LLC · South Naknek, AKS/N FL-639N6366SUS Special Operations Command · Macdill Afb Tampa, FLBuilt 2009 · S/N FL-666N636BDavid Aviation Inc DBA · Brandon, MSBuilt 1978 · S/N BC-61N636BAClock Adam D · Columbus, INS/N E-3482N636BERios Ralph · Chester, VABuilt 1992 · S/N E-2687N636EAdams Aerial Solutions LLC · Decatur, ILBuilt 1978 · S/N E-1262N636NCitation 501sp LLC · Sanford, FLS/N 501-0069N636RALoyd Randolph · Gassville, ARBuilt 1999 · S/N E-3229N636TAToth Financial Advisory Corp · Leesburg, VABuilt 2002 · S/N BB-1792N636WTlkco LLC · Wilmington, DES/N E-3475N63740Davis Aviation Inc DBA · Brandon, MSS/N FL-640N63769Registered aircraftS/N FL-659N637PRocky Mountain Frm LLC · Kalispell, MTS/N E-3557N637WMOhmestede Industrial Services Inc · League City, TXS/N BB-1768N63820United Airlines Inc · Chicago, ILBuilt 2014 · S/N 43534N63858Skyway Aviation Inc · Jackson, MIS/N TH-1360N6388PMurfin Drilling Co Inc · Wichita, KSBuilt 1981 · S/N E-1991N63890United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42194N63899United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62816N638GMSkytrain Aviation LLC · Dallas, TXBuilt 2008 · S/N 560-0785N638LDDion Aviation LLC · Key West, FLBuilt 1976 · S/N TH765N638WCBrown Everette · Edenton, NCBuilt 1975 · S/N TH-632N63936Sea & Ski Nw LLC · Portland, ORBuilt 1982 · S/N E-2053N639ARBraden Health LLC · Greensboro, NCBuilt 2000 · S/N TH-1968N63BHN63bh LLC · Auburn, ALBuilt 1977 · S/N E-1186N63BMDayton Aircraft Services Inc · Daytona Beach, FLS/N E-3410N63BRLevel Up Capital LLC · Roswell, GAS/N E-3061N63FFFuntime63ff LLC · Bozeman, MTBuilt 1990 · S/N 560-0063N63FXTrn Aviation LLC · Lewes, DEBuilt 1994 · S/N 6500234N63JG63jg LLC · Colorado Springs, COBuilt 1992 · S/N 560-0189N63JTLiberty Flight Co LLC · Jonesboro, ARBuilt 1988 · S/N S550-0156N63LBBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N BB-1894N63RSTeewinot Aviation LLC · Jackson, WYBuilt 1985 · S/N S550-0046N63TMartin Sky LLC · Beaufort, SCBuilt 1975 · S/N E-703N63TCRegistered aircraftBuilt 1972 · S/N E-384N63TLAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2000 · S/N E-3307N63TRRj Air LLC · Irvine, CABuilt 2017 · S/N 525-0956N63YASarasbrij International Inc · Wilmington, DES/N 525-0830N63YMSun Country Products LLC · Tampa, FLBuilt 2003 · S/N 258636N640ACPlane Old LLC · Wildwood, MOBuilt 1974 · S/N TH-458N640CSCsds Asset Management LLC · Marana, AZS/N 26078N640DFWhy Not LLC · Montezuma, KSBuilt 1992 · S/N LJ-1312N640RBTalfin Leasing II LLC · Heflin, ALBuilt 1998 · S/N 650-7092N640RJMidwest Executive LLC · Reno, NVBuilt 1985 · S/N LJ-1106N6410MGrimmway Enterprises Inc · Bakersfield, CABuilt 2010 · S/N FL-710N6416NMcdonald Marshall H · Saint Petersburg, FLBuilt 1982 · S/N E-2043N641MCRouses Enterprises LLC · Schriever, LABuilt 2006 · S/N FL-495N641TSLifewings II LLC · Harrisonville, MOS/N BB641N6425DZimin Transporation LLC · South Naknek, AKS/N FL-625
Back to AD 2006-16-18 R1