AD 98-21-21 R1

Registered aircraft · 85,616

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.

N1292GBahig Saliba · Scottsdale, AZBuilt 1974 · S/N 310Q1141N1292MCool Change Rentals LLC · Beaufort, NCBuilt 1975 · S/N 18264277N1292PEm Turbines Corp · Fort Lauderdale, FLS/N 23-327N1292UFlynn James M · Plain City, OHBuilt 1976 · S/N 17266986N1292XBurns Barry D · Amarillo, TXBuilt 1963 · S/N 165N12931Walden David C · Mesa, AZBuilt 1973 · S/N 17262382N12933Van Anda Aviation LLC · Apopka, FLBuilt 1973 · S/N 17262384N12935Ray Aviation LLC · Burkett, TXBuilt 1973 · S/N 17262386N12936Quinlan Patrick J · Cooper City, FLBuilt 1973 · S/N 17262387N1293DAlder George A · Palmer, AKBuilt 1951 · S/N 19869N1293FT-Craft Aero Club · Nampa, IDBuilt 1979 · S/N 17272987N1293SMeyer Raymond · Belding, MIBuilt 1976 · S/N 18264860N1293TN1293t LLC · Wilmington, DES/N 34-7250283N1293VEgmond Aircraft LLC · Lewes, DES/N 310Q1038N12940Buffoon Flying Club · Mansfield, OHBuilt 1973 · S/N 17262388N12943Titsworth R G · Seekonk, MABuilt 1973 · S/N 17262415N12947Alltek Lebelle Ltd · Wilmington, DEBuilt 1973 · S/N 17262393N1294FClover Park Technical College · Lakewood, WABuilt 1979 · S/N 17272988N1294RGubler Mark A · Pintura, UTS/N 31032N1294SSheehan Dennis M · Stoughton, WIBuilt 1976 · S/N 18264861N1294XMcglynn Brian · Friday Harbor, WABuilt 1963 · S/N 167N12951Huestis Peggy J · Havre, MTS/N 17262397N12952Wesselhoff Rick · Sedona, AZBuilt 1973 · S/N 17262398N12953Witmer Travis R · Odenton, MDBuilt 1973 · S/N 17262399N12955American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262400N1295DBlessum Jay A · Minot, NDBuilt 1950 · S/N 19871N1295TLutz Brian · Carmel, INBuilt 1972 · S/N 28-7205278N1295URegistration Pending · Monroe, WIRegistration pendingBuilt 1976 · S/N 17266989N1295XOz Aviation Inc · Cottonwood Falls, KSBuilt 1963 · S/N 168N12960Hennessee Timothy H · New Braunfels, TXBuilt 1973 · S/N 17262405N12968Rtd Aviation LLC · Hillsborough, NJBuilt 1973 · S/N 17262413N1296AN1296a LLC · Asheville, NCBuilt 1969 · S/N D-9030N1296FWalker Brandon · Anchorage, AKBuilt 1975 · S/N 18502816N1296GAir Dogs LLC · Watford City, NDBuilt 1976 · S/N 310R0698N1296UKirk Claire Y · Huntington Beach, CABuilt 1976 · S/N 17266990N1296XFox Judy · Ridgefield, WAS/N 169N12973Mor Aviation LLC · Gaithersburg, MDBuilt 1973 · S/N 17262418N12974Forest Ken W · Wales, NDBuilt 1972 · S/N 17262419N12976Wanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1973 · S/N 17262421N1297DPerk LLC · Glendale, AZBuilt 1951 · S/N 19873N1297FJprg Aviation Inc · Orlando, FLBuilt 1979 · S/N 17272990N1297GPilot Mountain Aviation LLC · Marietta, OHBuilt 1974 · S/N 310R0003N1297HHop A Chopper Inc · Dover, DES/N 32-7700010N1297SAlpine Skylane LLC · Alpine, WYS/N 18264864N1297TReich David W · Fort Lauderdale, FLBuilt 1972 · S/N 32-7240112N1297XScott Benjamin D · Grove City, OHS/N 170N12983Haman Aviation Services LLC · Nokomis, FLBuilt 1973 · S/N 17262427N12985Alamakee Flyers · Waukon, IABuilt 1973 · S/N 17262429N1298DGlaser Gerald A · Sebastopol, CABuilt 1951 · S/N 19874N1298MRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1975 · S/N 18264280
Back to AD 98-21-21 R1