OpenAirDocs.org
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.

N31691Slaughter Don Wayne · Farmville, NCBuilt 1985 · S/N 301-0585N3169AWakefield William F · Devils Lake, NDBuilt 1984 · S/N 301-0567N3169DClassic Arrow Inc · Hutchinson, MNBuilt 1984 · S/N 301-0569N3169UWhitten Flying Service Equipment LLC · Snook, TXBuilt 1984 · S/N 301-0577N331KECrop Air LLC · Eaton, COBuilt 1982 · S/N 400A-0460N3648SSale Reported · Page, NDSale reportedS/N 301-0231N3650DWoodley Aerial Leasing LLC · Walnut, ILBuilt 1980 · S/N 302-0240N3650YWerth Lance C · Johnson Lake, NES/N 301-0253N3652ZCotton Ag Inc · Walters, OKBuilt 1980 · S/N 400-0256N3653YPhoenix Equpiment Lc · Nickerson, KSS/N 301-0275N36542Harris Spraying Inc · Circle, MTBuilt 1980 · S/N 301-0310N3654GDixie Flying Service Inc · Bradley, ARS/N 400-0281N3654NCountry Air Service Inc · Hecla, SDS/N 301-0289N3655BWoodley Aerial Leasing LLC · Walnut, ILBuilt 1980 · S/N 301-0291N3655TPutz Gary D · Hearne, TXS/N 301-0300N3657TCentral Planes Aviation Inc · Sauk Centre, MNBuilt 1980 · S/N 301-0316N3658UBonner Aerial Applicators Inc · Summerdale, ALBuilt 1981 · S/N 301-0335N3659DAnf Air Service Inc · Garwood, TXBuilt 1981 · S/N 301-0327N3659NHoppe Air LLC · Beaman, IAS/N 400-0294N3659TAura LLC · Elsie, MIBuilt 1981 · S/N 301-0329N3660CAero Charter Express Inc · Bismarck, ILBuilt 1980 · S/N 301-0324N3660TNorth Texas Dusters & Sprayers Inc. · Gainesville, TXBuilt 1981 · S/N 301-0336N400DQOregon Trail Air Service LLC · Nyssa, ORS/N 301-0343N400XXAbernathy Spraying Service Inc · Tipton, OKBuilt 1986 · S/N 4000646N4052PRadium Inc · Warren, MNBuilt 1985 · S/N 301-0605N4322SEdwards Kristin L · Wichita Falls, TXS/N 300-0002N4326SMarlow Aviation LLC · Lamoni, IAS/N 301-0006N432WAWoodley Aerial Leasing LLC · Walnut, ILS/N 400-0435N4332SBonner Irma L · Robertsdale, ALBuilt 1975 · S/N 301-0013N4344SFallon Mike · Tom Bean, TXBuilt 1975 · S/N 300-0024N4350JPhoenix Equipment Lc · Nickerson, KSBuilt 1982 · S/N 400A-0463N4350SAura LLC · Elsie, MIBuilt 1976 · S/N 301-0030N4351SSales Joe H · Seminole, TXBuilt 1976 · S/N 301-0031N4370SGoat Rancho LLC · Euless, TXS/N 301-0050N4397SJohnson Kendall M · Wolf Point, MTS/N 301-0057N4401SSilver Wings Flying Company LLC · Olympia, WABuilt 1975 · S/N 301-0061N4403SSilver Wings Flying Company LLC · Olympia, WAS/N 301-0063N4422SSouther Field Aviation Inc · Americus, GAS/N 301-0082N4426SCrop-Serv Inc · Meade, KSBuilt 1977 · S/N 301-0086N4440SAeschliman Arlie W · Tribune, KSBuilt 1977 · S/N 301-0100N444ASAas LLC · Ovid, MIBuilt 1982 · S/N 400-0438N444MSAas LLC · Ovid, MIS/N 400-0444N497GATri-State Aerial LLC · Canton, SDBuilt 1984 · S/N 400A-0502N5017SDefenbaugh Matthew J · Biggsville, ILS/N 301-0106N501JKBarjoseph Shirley · Chanute, KSS/N AT400-0482N5050SSimpson Don DBA · Bryan, TXBuilt 1977 · S/N 301-0110N5070SEldringhoff Jim · Wecota, SDBuilt 1977 · S/N 301-0111N5073SHughes Todd R · Rocky Ford, COBuilt 1978 · S/N 301-0113N5079SNish Robert M · Spearman, TXBuilt 1978 · S/N 301-0116N5236SMorrison Lynn · Vernon, TXBuilt 1978 · S/N 301-0130
Back to AD 2003-06-01