OpenAirDocs.org
AD 2006-08-08 R1

Registered aircraft · 257

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-08-08-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-08-08-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.

N616JBAdams Aerial Solutions LLC · Decatur, ILBuilt 1997 · S/N 402A-1033N6174HWoodley Aerial Leasing LLC · Walnut, ILBuilt 1995 · S/N 402B-0994N6175STri-Rotor Spray And Chemical · Ulysses, KSBuilt 1995 · S/N 402B-0993N61762Chisenhall Agricultural Service Inc · Foley, ALBuilt 1996 · S/N 401B-1008N61775Cruce Aviation LLC-Series Leasing · Marquette Heights, ILBuilt 1996 · S/N 401B-1009N619BBOver And Under Flying Service DBA · Knox, INS/N 401-0916N623LANeal Aircraft Inc · Slaton, TXBuilt 2000 · S/N 402A-1127N712GSAt402 LLC · Banquete, TXBuilt 2007 · S/N 402B-1189N73005Mid Atlantic Ag LLC · Nassau, DEBuilt 1985 · S/N 400-0520N7300EMark Gary Flying Service Inc · Inverness, MSBuilt 1984 · S/N 400-0517N7307TAas LLC · Ovid, MIBuilt 1985 · S/N 400-0610N73080Tall Towers Aviation Inc · Page, NDBuilt 1985 · S/N 400-0639N73084Precision Aerial Ag LLC · Seneca, KSBuilt 1985 · S/N 400-0638N7308ADevil Dusters Inc · Artesia, NMBuilt 1985 · S/N 400-0624N73132Headwaters Flying Service LLC · Three Forks, MTS/N 401-0670N73135Mccormick Royce DBA · Seminole, TXBuilt 1987 · S/N 401-0671N73LACameron Parish Mosquito Abatement · Creole, LABuilt 2006 · S/N 402B-1173N789KAWilbur Ellis Air LLC · Huron, SDS/N 402B-1204N80060Bank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 402B-1355N81400E&D Farms LLC · Wilmington, DEBuilt 1981 · S/N 400-0353N820RGMacys Flying Service Inc · Tulelake, CABuilt 2007 · S/N 402B-1195N82400Stubbs Mickey Lee · Rochelle, GABuilt 1981 · S/N 400-0372N825BKKlein Flying Service · Lawrenceville, ILBuilt 1993 · S/N 402-0902N84FCWilliams Fertilizer Services LLC · Oregon, MOBuilt 1994 · S/N 402-0946N85022Bergo LLC · Harrisburg, ARBuilt 2001 · S/N 402A-1140N8521PThomas Air Service Inc · Hastings, NEBuilt 2004 · S/N 402B-1148N8525FJlr Ag Aircraft LLC · Fowler, COBuilt 2005 · S/N 402B-1169N8526LJack Olham Oil Inc · Dumas, TXBuilt 2005 · S/N 402B-1167N874MRLoewen Air LLC · Park River, NDBuilt 2011 · S/N 402B-1239N90210Robertson Crop Dusting Service Inc · South Haven, MIBuilt 1992 · S/N 402-0889N9032TBarts Flying Service Inc · Storm Lake, IABuilt 2000 · S/N 402A-1130N9033NJohn Georg Aerial LLC · La Crosse, KSBuilt 1999 · S/N 402A-1097N9053SShearer John W · The Dalles, ORBuilt 1992 · S/N 402-0890N9071ZJohnson Airspray Inc · Argyle, MNBuilt 2001 · S/N 401B-1131N90772Ag Enterprises LLC · Flagler, COBuilt 1999 · S/N 402A-1112N9090MIndependent Dusting Service Inc · El Campo, TXBuilt 2000 · S/N 402B-1122N9091UMeadow Creek Aerial Application Inc · Kelliher, MNBuilt 2000 · S/N 402A-1119N91266Air Dusters Inc · Roggen, COBuilt 2001 · S/N 402A-1134N9156COconnor Dallas · Poplar, MTBuilt 1993 · S/N 401-0898N9159ABarajas Samuel · Mission, TXS/N 401-0900N9179AFrontier Agricultural Services Inc · Calexico, CABuilt 1993 · S/N 401-0904N9179NWilliams Delbert D · Goldfield, NVBuilt 1989 · S/N 401-0897N9185XWilbur-Ellis Co · Salinas, CABuilt 1993 · S/N 401-0910N9186JSwancutt Aviation Inc · Chester, IABuilt 1993 · S/N 401-0912N9187VPlu'S Flying Service Inc · Ekalaka, MTS/N 401-0907N9188BTlc Flying Inc · Colfax, WABuilt 1993 · S/N 401-0899N9190QDodson International Parts Inc · Rantoul, KSBuilt 1989 · S/N 401-0925N9190VT&T Highcountry Flying Service LLC · Saint Anthony, IDBuilt 1993 · S/N 402-0919N9192BKracke Spraying Service Inc · Fargo, NDBuilt 1993 · S/N 401-0929N9196CWoodley Aerial Leasing LLC · Walnut, ILBuilt 1994 · S/N 402A-0937
Back to AD 2006-08-08 R1