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

N219DGCtrl Electrical LLC · Lexington, NCBuilt 1999 · S/N 3246134N219DKRegistered aircraftBuilt 1980 · S/N E-1599N219EPEpic Aviation Inc · New Smyrna, FLBuilt 2019 · S/N 4496458N219GMStewart Michael A · Washington, DCBuilt 1988 · S/N TH-1536N219JHNelson Jack L · Corinth, TXBuilt 1968 · S/N CD-1184N219JRRoberts Pipeline Inc · Middletown, INBuilt 1973 · S/N 28-7410026N219MLGelbard Dustin S · Lake Havasu City, AZBuilt 1966 · S/N TE-243N219QBoe John · Langdon, NDBuilt 1965 · S/N D-7790N219RMattioli Mark L · Lumberton, NJFirst renewal noticeS/N 28-11302N219RPMorrow Dennis J · Houston, TXBuilt 1976 · S/N E-885N219TGXin Han Aviation LLC · Atwater, CABuilt 1972 · S/N 34-7250315N219ZCarroll Sean Terence · Saint Petersburg, FLBuilt 1964 · S/N TC-789N21ABAriel J Quintela LLC · Odessa, FLBuilt 1980 · S/N 31-8052122N21ADBogart Donald W Jr · Long Beach, CABuilt 1961 · S/N 18253313N21AQCapiga Daniel P · North Fort Myers, FLBuilt 1973 · S/N 27-7305035N21ASBoa Properties LLC · Valdosta, GABuilt 1968 · S/N 28R-30862N21ATMeadville Aero Club LLC · Erie, PABuilt 1977 · S/N 17268907N21BBSmartin Enterprises LLC · Phoenix, AZS/N TC-1690N21BCAmelse Troy · Chippewa Falls, WIBuilt 1980 · S/N EA-65N21BESpecialized Helicopter Training LLC · Middleton, IDBuilt 1979 · S/N P21000456N21BMGandee James T · Bullhead City, AZS/N 21061941N21CCPlane Fun Inc Tr Trustee · Snellville, GABuilt 1980 · S/N 25-0376N21CDTwo Two Lima LLC · Port Orange, FLBuilt 1968 · S/N E-28N21CHSievert Stephen L Sr · Plainfield, ILBuilt 1954 · S/N D-3724N21CNV-Tail Aero LLC · Troy, MIBuilt 1953 · S/N D-3459N21CPT Howard And Associates Architects Inc · Dallas, TXBuilt 1961 · S/N 18253721N21CSHendrix Peter A · Plantation, FLBuilt 1973 · S/N 310Q0963N21CTFerreira Douglas B Trustee · Chico, CABuilt 1978 · S/N P21000021N21DAW Squared Holdings LLC · Edmond, OKBuilt 1978 · S/N TH-980N21DDHam Arthur J · Gun Barrel City, TXBuilt 1965 · S/N 895N21DFDose Gary W · Pinehurst, IDBuilt 1977 · S/N 18265789N21DPPacific Fleet Aviation LLC · Rochester, NYBuilt 1978 · S/N 27-7854097N21DSJohnson Brothers Enterprises Corp · Eldridge, ALBuilt 1968 · S/N 28-24322N21EDHutcheson Jon · Greencastle, INS/N 28-7716031N21EM2fly-Safety LLC · Azle, TXS/N 243129N21ETDepucchio Mark V · Plainville, CTBuilt 1976 · S/N E-889N21EWRountree Christopher B · Burbank, CAS/N 18255335N21FWilson Christopher J · W Hartford, CTBuilt 1967 · S/N 680043N21FC310 Pals LLC · Lake City, FLBuilt 1974 · S/N 310Q1080N21FFHor Aviation LLC · Harrisburg, PABuilt 1969 · S/N 18260179N21GBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 310R-1580N21HAEngle Scott · Plymouth, MNS/N 310R1850N21HGDrisco LLC · Ponca City, OKBuilt 1981 · S/N 31-8152078N21HLChieftain Aviation Inc · Marietta, GAS/N 31-8152126N21HZCrandall Jamie L · Waller, TXBuilt 1969 · S/N CE-260N21JPDmmag LLC · Windermere, FLBuilt 1977 · S/N TE-1092N21KBLow Carl S III · Aurora, TXBuilt 1973 · S/N 310Q0777N21KFFans Of Nola Corp · New Orleans, LABuilt 1976 · S/N TC-1926N21KJCherokee LLC · Lewiston, MES/N 28-20307N21KKLife'S A Beech LLC · Gulf Breeze, FLBuilt 1979 · S/N E-1563
Back to AD 98-21-21 R1