AD 98-21-21 R1

Registered aircraft · 85,620

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:98-21-21-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:98-21-21-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.

N222QLindeen Karen D · Anchorage, AKS/N 18257622N222RBwr Aircraft LLC · Paramus, NJBuilt 2001 · S/N TH-1977N222RACaptain Rick LLC · Miami Lakes, FLBuilt 1973 · S/N 28R-7435127N222RBM & B Llp · Iowa City, IABuilt 1990 · S/N TH-1592N222REN222re LLC · Indianapolis, INBuilt 1973 · S/N E-467N222RGVaerus Jet Sales LLC · Topeka, KSBuilt 1994 · S/N TH-1698N222RJAmbrose James · Dyersburg, TNBuilt 1977 · S/N 22-1438N222RSDawson Douglas L · Fernley, NVBuilt 1978 · S/N 28R-7803221N222RZP & M Reis Trucking Inc · Nantucket, MABuilt 1977 · S/N TH-857N222SPresley Wilber L · Columbus, OHBuilt 1969 · S/N D-9008N222SBFuglestad Jon T · Anchorage, AKBuilt 1953 · S/N 30360N222SDSloan Kevin · Edmond, OKBuilt 1973 · S/N E-473N222SGPacific Aviation Aircraft Management Inc · Fresno, CAS/N 210-64410N222SJTriple Deuce LLC · Harrisonville, MOBuilt 1972 · S/N 21059732N222SMMacknight James G · Morgan Hill, CABuilt 1976 · S/N D-9958N222SNNorris Jason M · Smyrna, TNBuilt 1969 · S/N 31004N222SPRobinson Avery Clark · Phoenix, AZBuilt 1965 · S/N 701N222SSE C Investments LLC · Elfin Cove, AKS/N 3257260N222STEau Claire Aviation LLC · Eau Claire, WIBuilt 1976 · S/N 310R0679N222TDTango Leasing Inc · Bullhead City, AZBuilt 1977 · S/N E-1078N222TJSimmons Scott C · Pleasant Prairie, WIBuilt 1979 · S/N 28-7911314N222TKMachowicz Mark M · Eastpointe, MIBuilt 1967 · S/N 18257973N222TTLaukkanen Eric M · Sisters, ORBuilt 1956 · S/N D-4446N222UClukey David Alan · Bryant Pond, MEFirst renewal noticeBuilt 1957 · S/N 23-912N222USTicoair LLC · Wilmington, DEBuilt 1979 · S/N 17273491N222UWFlyin In Style LLC · Greenwood, MSBuilt 1979 · S/N EA-49N222VCMatlock Gary W · Burleson, TXBuilt 1969 · S/N CE-273N222WAWiseman Aviation Inc · Flagstaff, AZS/N R18201443N222WBPower Robert R · Brenham, TXBuilt 1968 · S/N 27-3992N222WFBailey Steve · Chehalis, WABuilt 1963 · S/N 205-0220N222WPFord Scott S · Punta Gorda, FLBuilt 1974 · S/N E-516N222WSCenterline Aviation Services LLC · Huntsville, NCS/N TC-1311N222WTLopes Jeremy B · Peoria, AZBuilt 1952 · S/N 20372N222XLFox Jeffery R · Spooner, WIBuilt 1981 · S/N 18504278N222ZBonanza Parts Inc · Davis, CABuilt 1951 · S/N D-2732N2230CHendricks Construction LLC · Phoenix, AZS/N 30530N2230DHendricks Construction LLC · Phoenix, AZBuilt 1976 · S/N 18503053N2230QSchmidt John J · Pueblo West, COBuilt 1979 · S/N 28R-7931072N2230TWhite Pelican LLC · Union City, TNBuilt 1971 · S/N 28-7105189N2230WJac & Phill Corp · San Ysidro, CAS/N 17250077N2230XPoff Matthew W · Miramar Beach, FLBuilt 1979 · S/N 28-7990374N2231DFisher Air LLC · Cardington, OHBuilt 1952 · S/N 20383N2231GKelly Richard · Ogdensburg, NYS/N 51531N2231JWares Auto Sales Inc · Traverse City, MIBuilt 1978 · S/N 32R-7985053N2231MGreat Lakes Aviation Services Inc · Kimball, MIS/N 32-975N2231THewitt David E · Newcastle, MEBuilt 1968 · S/N 185-1383N2232ASummit Air LLC · Clarks Summit, PABuilt 1976 · S/N 28-7690460N2232EPink Skies Inc · Willoughby, OHBuilt 1978 · S/N 17271195N2232FPritchard Dale G · St Maries, IDBuilt 1966 · S/N 310L-0032N2232GBigler Mark · Topeka, KSS/N 51532
Back to AD 98-21-21 R1