AD 2000-11-05

Registered aircraft · 137

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:2000-11-05')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-11-05')
  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.

N5238SHayton James B · Sedro Woolley, WABuilt 1978 · S/N 301-0132N60057Sunflower Aero Inc · Atwood, KSBuilt 1994 · S/N 401-0951N619BBOver And Under Flying Service DBA · Knox, INS/N 401-0916N69WNAg Air Services LLC · Walla Walla, WABuilt 1988 · S/N 301-0683N7305GAerial Ag Services LLC · Hillsboro, TXBuilt 1985 · S/N 301-0603N7306LMehling Robert C · Hardin, MTBuilt 1985 · S/N 301-0607N7307YRoseau Ag Inc · Georgetown, MNBuilt 1985 · S/N 301-0615N7308WNeal Aircraft Inc · Slaton, TXBuilt 1986 · S/N 301-0641N7309DFarm Air Inc · Astoria, ILBuilt 1986 · S/N 301-0642N7309ZMccormick Monty C · Lubbock, TXBuilt 1986 · S/N 301-0645N73110Lofton Aviation Inc · Georgetown, MNBuilt 1986 · S/N 301-0660N73132Headwaters Flying Service LLC · Three Forks, MTS/N 401-0670N73135Mccormick Royce DBA · Seminole, TXBuilt 1987 · S/N 401-0671N7314QTall Towers Ag Service Inc · Page, NDS/N 501-0004N7314RNewberg Sky Spray LLC · Hector, MNBuilt 1987 · S/N 501-0005N8511SKubecka Donald P · Seminole, TXBuilt 1978 · S/N 301-0134N8586SR & D Leasing Inc · Lemoore, CABuilt 1978 · S/N 301-0152N8590SUltra Ag Cropdusters LLC · Le Mars, IABuilt 1978 · S/N 301-0156N8595SHeadwaters Flying Service LLC · Three Forks, MTBuilt 1978 · S/N 301-0159N8608SMid Continent Aircraft Corp · Hayti, MOBuilt 1978 · S/N 301-0164N8639SBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 301-0169N8753SGilbreath Tony C DBA · Olustee, OKBuilt 1979 · S/N 301-0182N8829SHaynes Barry B · Chillicothe, TXBuilt 1979 · S/N 301-0208N8864SCrop Doctor Aviation Inc · Hill City, KSBuilt 1979 · S/N 302-0218N8886SHayton James B · Sedro Woolley, WABuilt 1979 · S/N 301-0227N9156COconnor 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-0925N9192BKracke Spraying Service Inc · Fargo, NDBuilt 1993 · S/N 401-0929N9197QInternational Air Services Inc Trustee · Carson City, NVBuilt 1994 · S/N 401-0943N9197VA+ Aviation Services LLC · Goodland, KSBuilt 1994 · S/N 401-0944
Back to AD 2000-11-05