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.

N13383Alpha Aviation-1 LLC · Naples, FLBuilt 1973 · S/N 17262718N13384Premier Vacations LLC · Haines City, FLBuilt 1973 · S/N 17262719N13386Crosswind Aviation Of Oklahoma LLC · Stillwater, OKS/N 17262720N1338FVogel Auto Repair LLC · Palmer, NEBuilt 1966 · S/N 17254833N1338GWings Air Charter LLC · Wisconsin Rapids, WIBuilt 1974 · S/N 310R0022N1338YRegistered aircraftBuilt 1961 · S/N 17249038N13391Brazos Valley Flight Services LLC · College Station, TXBuilt 1973 · S/N 17262723N13394Ck Leasing Services LLC · Wilmington, DEBuilt 1973 · S/N 17262725N13399Great Plains Spraying Inc · Colby, KSBuilt 1973 · S/N 17262729N1339FFriedlander Edward R · Hattiesburg, MSBuilt 1966 · S/N 17254834N1339GLyon Aviation Inc · Pittsfield, MABuilt 1974 · S/N 310R0023N1339W39 Whiskey LLC · Clovis, NMBuilt 1963 · S/N 227N1339YMiller Henry C · Mckinney, TXS/N 17249039N1339ZSmith Derek D · Brooks, GABuilt 1961 · S/N TC-139N133AGRaritan Valley Flying School · Princeton, NJS/N CE-1470N133BSMusser Merton · Billings, MTBuilt 1988 · S/N CE-1234N133CBBrown Milton S III · Raleigh, NCBuilt 1974 · S/N 28R-7435318N133CGRoq Farm LLC · Diboll, TXBuilt 1989 · S/N CE1416N133CLDukes Grant M · Horseshoe Bay, TXBuilt 1970 · S/N 700004N133CTValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 31-7912118N133CWDeniro Corp · Hampton, NHBuilt 1978 · S/N 310R1260N133DB3h Mech LLC · Grand Junction, COBuilt 1982 · S/N 24-1275N133DSHagopian Donald D · Van Nuys, CABuilt 1965 · S/N 18256837N133ECMf33a Enterprises LLC · Amarillo, TXBuilt 1992 · S/N CE-1679N133EMWheels Up LLC · Lincoln, NES/N E-517N133FCWisdom Blake Andrew · Chapmansboro, TNBuilt 1962 · S/N CD-470N133GMBem Holdings LLC · Nashville, TNBuilt 1987 · S/N CE-1170N133LBlair Byron · Ajo, AZBuilt 1952 · S/N D-3300N133MGolden Age Flight Museum · Bakersfield, CAS/N D-557N133MDWells Rich · Aspen, COBuilt 1987 · S/N CE-1163N133MRPrecision Aero LLC · Wilmington, DEBuilt 1978 · S/N TC-2173N133MWSky Mile Limit · Murrayville, GABuilt 1967 · S/N CE-188N133PTKittle David · Siloam Springs, ARS/N 32-7440136N133QFreeland Christopher G · Brownwood, TXBuilt 1957 · S/N D-5319N133RJKirby Kevin M · Dayton, OHFirst renewal noticeBuilt 1981 · S/N 24-1157N133SBColeman Terry Michael · Meridianville, ALS/N CE-891N133SFNelson Dennis E · Jamestown, NDBuilt 1966 · S/N 28-22323N133SMSpivack Peter · Philadelphia, PABuilt 1979 · S/N 25-0001N133TDLanyi Clifford · Attleboro, MABuilt 1990 · S/N CE-1548N133TSHunter Stephen Eugene · Grace, MSBuilt 1966 · S/N 18257883N133VMCathey Gary C · El Dorado Hills, CAS/N CE786N133VWAlpine Katmai LLC · Alpine, WYBuilt 1975 · S/N 18263927N13400Opolka John G · Midlothian, TXBuilt 1973 · S/N 17262730N13402Cartwright Edward N · Winterville, NCBuilt 1973 · S/N 17262731N13404Kroner David S · Rock Creek, OHBuilt 1973 · S/N 17262733N13405Kelley Aircraft LLC · Weyers Cave, VABuilt 1973 · S/N 17262734N13406Shore Stephen A · Thurmond, NCS/N 17262735N1340TMaw Enterprises USA LLC · Hudson, FLBuilt 1972 · S/N 28-7225470N1340WJohnson Jon · El Paso, TXBuilt 1963 · S/N 228N1340YStephens Christopher L · Kelso, WAS/N 17249040
Back to AD 98-21-21 R1