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.

N1594YSexson Lance Mason · Ogallala, NES/N 17249294N1594ZWondra Wayne L · Friendswood, TXBuilt 1961 · S/N D-6886N15955Air Wings Enterprise LLC · Roca, NEBuilt 1973 · S/N 28-7325210N15956Hanson Mark E · Griffin, GABuilt 1973 · S/N 28-7305196N15957Jones John E Jr · Metter, GABuilt 1973 · S/N 28-7305197N1595LClemens Jerry W · Parsons, KSBuilt 1976 · S/N D-9869N1595UJoiner Aviation LLC · Vinemont, ALBuilt 1973 · S/N U20602269N1595WHope John W · Greeneville, TNFirst renewal noticeS/N TC-1448N15961Kings Wings · Jupiter, FLBuilt 1973 · S/N 32-7300022N15962Romero Jason Nathanial · Broken Arrow, OKS/N 28-7325213N15966Acosta Aaron · El Paso, TXBuilt 1973 · S/N 28-7325214N15968Culberson Donald J · Orange Park, FLBuilt 1973 · S/N 28-7305200N1596CFennell Kenneth J · Palmer, AKBuilt 1953 · S/N 30296N1596DSchneider Carl S · Tulsa, OKBuilt 1972 · S/N CD-1297N1596ETeam 172-03 LLC · Warsaw, INS/N 17271060N1596JWard Lawrence G · Mckenzie, ALBuilt 1941 · S/N 28-24007N1596MKret Geoffrey W · Godley, TXBuilt 1975 · S/N 18264386N1596ZBarnett Paul S · Brookhaven, MSBuilt 1961 · S/N D-6887N15975Bourgeois David · Westminster, MABuilt 1973 · S/N 28-7305226N15976Lake Life Aviation LLC · Yukon, OKBuilt 1973 · S/N 28-7305203N15979Tron Aviation LLC · Newburgh, INBuilt 1973 · S/N 28-7310079N1597BRehman Furqan · Germantown, MDBuilt 1997 · S/N 2843104N1597JLs Aviation LLC · Searcy, ARS/N 28-24008N1597LTougas John D · Huntingtown, MDS/N CE-638N1597MDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 18264387N1597SJones William F · Seneca, SCBuilt 1962 · S/N CD-540N1597WSmith William J · Wichita Falls, TXBuilt 1972 · S/N D-9359N1597YHelderman Laban W · Newton, NCBuilt 1962 · S/N 17249297N15984Hewitt Jeremy K · West Jordan, UTBuilt 1973 · S/N 28-7325218N1598HCarey Philip J Trustee · Wasilla, AKBuilt 1977 · S/N 18503314N1598JHassard Maitland · Goodyear, AZBuilt 1967 · S/N 28-24009N1598MZigler James B · Big Lake, MNBuilt 1975 · S/N 18264388N1598SDougherty William G · Hacksneck, VABuilt 1962 · S/N D-7008N1598TRegistered aircraftBuilt 1981 · S/N EA-263N1598WCanvasback Investments LLC · Kerrville, TXBuilt 1972 · S/N D-9356N1598ZMitchell Lester L · Okmulgee, OKBuilt 1961 · S/N D-6889N15994Self Thomas C · Madisonville, TNS/N 28-7325222N15997Stockman Greg · Allenton, MIBuilt 1973 · S/N 28-7305210N15999Emmert Jason L · Douglas, WYBuilt 1973 · S/N 28-7310081N1599RLuka Robert E · Berea, KYBuilt 1967 · S/N 28-3845N1599VQuigley Ryan P · Chemung, NYBuilt 1947 · S/N D-55N1599XDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1975 · S/N 28-7505245N1599ZBurks Aviation Inc · Hattiesburg, MSBuilt 1962 · S/N TC-216N159AMakray Joseph C · Port Charlotte, FLBuilt 1958 · S/N D-5598N159AARegistered aircraftBuilt 1975 · S/N E-765N159AEGalbari Geno · Wales, WIS/N 17249954N159BOppold Robert S · Overland Park, KSBuilt 1977 · S/N 27-7754047N159ERTetterton Marshall O · Crescent City, FLBuilt 1989 · S/N 2841211N159GMArmy Air Corps LLC · Wilmington, DEBuilt 1978 · S/N CE-765N159LHFarmingdale State University · Farmingdale, NYS/N 2842200
Back to AD 98-21-21 R1