AD 2003-06-01

Registered aircraft · 135

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:2003-06-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-06-01')
  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-0132N550BHWoodley Aerial Leasing LLC · Walnut, ILS/N 302-0184N6072YBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 0397N6082YDash Flying Service LLC · Chilton, WIBuilt 1980 · S/N 0273N69WNAg Air Services LLC · Walla Walla, WABuilt 1988 · S/N 301-0683N73005Mid Atlantic Ag LLC · Nassau, DEBuilt 1985 · S/N 400-0520N73006Mid Continent Aircraft Corp · Hayti, MOBuilt 1985 · S/N 400A-0501N7300EMark Gary Flying Service Inc · Inverness, MSBuilt 1984 · S/N 400-0517N7305GAerial Ag Services LLC · Hillsboro, TXBuilt 1985 · S/N 301-0603N7306LMehling Robert C · Hardin, MTBuilt 1985 · S/N 301-0607N7307TAas LLC · Ovid, MIBuilt 1985 · S/N 400-0610N7307YRoseau Ag Inc · Georgetown, MNBuilt 1985 · S/N 301-0615N73080Tall Towers Aviation Inc · Page, NDBuilt 1985 · S/N 400-0639N73084Precision Aerial Ag LLC · Seneca, KSBuilt 1985 · S/N 400-0638N73085Woodley Aerial Leasing LLC · Walnut, ILBuilt 1985 · S/N 301-0636N7308ADevil Dusters Inc · Artesia, NMBuilt 1985 · S/N 400-0624N7308WNeal 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-0660N73127Georges Aircraft Repair · Vernon, TXBuilt 1987 · S/N 301-0667N81400E&D Farms LLC · Wilmington, DEBuilt 1981 · S/N 400-0353N82400Stubbs Mickey Lee · Rochelle, GABuilt 1981 · S/N 400-0372N8511SKubecka 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-0182N8791SWoodley Aerial Leasing LLC · Walnut, ILBuilt 1979 · S/N 301-0194N8829SHaynes 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-0227N8907SWoodley Aerial Leasing LLC · Walnut, ILBuilt 1979 · S/N 301-0230
Back to AD 2003-06-01