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.

N1JQJacquot Daniel C · Colorado Springs, COBuilt 1965 · S/N 24-4327N1JYRicks Electric Plus LLC · Middleton, IDBuilt 1958 · S/N 51474N1KPSherman Loren R Jr · Granbury, TXBuilt 1973 · S/N 21060006N1KUUniversity Of Kansas Aerospace Engineering Dept · Lawrence, KSBuilt 1974 · S/N 17262270N1KYCatherines Aviation Services LLC · Sewanee, TNBuilt 1968 · S/N CJ-3N1LJN1lj LLC · Edgewood, WABuilt 1950 · S/N D-2537N1LLC&L West Coast Flyers LLC · Dixon, CAS/N 21-0031N1LPRegistration Pending · Lynn Haven, FLRegistration pendingBuilt 1965 · S/N 28-2666N1LQStrydom Cornelis F · Liberal, KSBuilt 1966 · S/N T210-0148N1LVMcarthur Thomas M · Annapolis, MDBuilt 1966 · S/N CE15N1LXDix Justin T · South Boston, VABuilt 1973 · S/N E-419N1MEHall James C · Redington Beach, FLBuilt 1967 · S/N 30-1439N1MFWise Christopher J · Plano, TXS/N TH-835N1MPFly One Mp LLC · Omaha, NEBuilt 1972 · S/N 28-7305143N1MQGc4 Aero LLC · Birmingham, ALBuilt 1976 · S/N TH-731N1NMShaffer Thomas F DBA · Somerset, PAS/N D-5211N1NTDmac Aircraft LLC · Savannah, GABuilt 1964 · S/N 30-262N1PFTownes Patrick S · Lucerne Valley, CABuilt 1964 · S/N 2898N1PHRegistered aircraftBuilt 1983 · S/N CE-1018N1PVMuzny Gregory · Magnolia, TXS/N D-3028N1PZRegistered aircraftBuilt 1972 · S/N TE-890N1QABender Edward C Jr · Lansdale, PABuilt 1973 · S/N 28R-7335303N1QGLos Arboles Management Company LLC · Moriarty, NMBuilt 1966 · S/N D-8328N1QPN667sr LLC · Richmond, KYBuilt 1972 · S/N 18261605N1QSUniversal Investment Group LLC Trustee · La Crescenta, CABuilt 1975 · S/N 17265177N1QYJet X Leasing Inc · Johnson, KSBuilt 1964 · S/N CD-798N1RMMeggers Roger D · Baker, MTBuilt 1975 · S/N 18502686N1RTFrost Darrell G · Atlanta, TXBuilt 1966 · S/N TE-185N1SBHattan John A · Goddard, KSBuilt 1974 · S/N 18502377N1SKWienhoff Kevin Bruce · Salem, ORS/N D-9339N1SRRensberger Scott C · Lake Jackson, TXBuilt 1962 · S/N 27-2050N1SYPacific Fleet Aviation LLC · Rochester, NYS/N 27-7654186N1TAJustine Lorraine F · Newark, DEBuilt 1972 · S/N 17260453N1UGRegistered aircraftS/N 32R-7780308N1UKPenn Flight School LLC · Quakertown, PABuilt 1977 · S/N 28-7790564N1UZJet X Leasing Inc · Johnson, KSBuilt 1964 · S/N D-7420N1VKChupito Sabrocito LLC · Paso Robles, CABuilt 1960 · S/N TD-403N1VZKilian Michael S · Morrow, OHBuilt 1979 · S/N E-1491N1WDBushcraft Aviation LLC · Cypress, TXBuilt 1961 · S/N TC-192N1WFRegistered aircraftBuilt 1968 · S/N D-8880N1WUN1wu LLC · Loganville, GABuilt 1966 · S/N 30-1383N1WYBultron Cristina · Ocala, FLBuilt 1964 · S/N 24-4018N1XSaitto Jeffrey M · Media, PABuilt 1965 · S/N 17252958N1XACowell Aviation Maintenance LLC · Easley, SCBuilt 1964 · S/N 24-3599N1XDOne X-Ray Delta LLC · Shreveport, LABuilt 1961 · S/N D-6702N1YCMay Thomas W · Texarkana, TXBuilt 1976 · S/N 310R0621N1YDBerg Bradley · Tulare, CABuilt 1968 · S/N 21059105N1YMSupreme Aeronautics LLC · Haymarket, VAS/N D-1145N1YRPerley Kevin G Trustee · Sioux City, IABuilt 1975 · S/N D-9797N1YTOne Yankee Tango LLC · Jenks, OKBuilt 1978 · S/N 18266473
Back to AD 98-21-21 R1