OpenAirDocs.org
AD 98-21-21 R1

Registered aircraft · 85,612

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.

N29215Lzl Aviation LLC · Wilmington, DEBuilt 1979 · S/N 28-7916420N29217Dawson Adam J · Eveleth, MNBuilt 1968 · S/N U206-1171N29218Israelsen Martin · Santa Rosa Beach, FLBuilt 1979 · S/N 28-7916422N2921AStanford Jeffrey S · Anchorage, AKBuilt 1953 · S/N 30121N2921BMurray Michael E · Fallbrook, CABuilt 1964 · S/N D-7372N2921CMensink David L · Preston, MNS/N 30821N2921DErlandson Lloyd V · Hilmar, CABuilt 1955 · S/N 26864N2921LFellowship Of The Wing LLC · Riverton, UTBuilt 1967 · S/N 670315N2921NZephyr Air Corp · Dellwood, MNBuilt 1979 · S/N 32-7940204N2921QAmbler Aviation LLC · Ambler, PAS/N 32R7780267N2921RZiegler James F · Darwin, MNBuilt 1969 · S/N 28R-35329N2921SAirworthy Services LLC · Pompano Beach, FLBuilt 1979 · S/N 32-7940203N29220Paris Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-7916423N29222Paris Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-7916426N29224Phelan Ricky Ray · Jefferson, ORBuilt 1968 · S/N U206-1176N29227Towne Diana L · Lakeside, CABuilt 1979 · S/N 28-7990438N2922AFowler Kenneth Russell · Locust Fork, ALS/N 30122N2922FKalil Joseph J Jr · Morgan, UTBuilt 1966 · S/N 18257022N2922QWw Aero LLC · Jonesboro, ARS/N 32R-7780268N2922ULowcountry Aviation Company Brokerage LLC · Walterboro, SCBuilt 1979 · S/N 34-7970377N2922WHiwassee Aviation LLC · Calhoun, TNS/N 34-7970378N2922YBeckstrand John James Wendell · Eagan, MNS/N 28R-8031029N29230Hawbaker Keith J · Manitou Springs, COS/N 28-8090025N29239Gibson Aviation Services LLC · Hudson, WIBuilt 1974 · S/N 17264108N2923AWicklander Richard O · Spanaway, WABuilt 1953 · S/N 30123N2923CColley Robert E · Jamestown, TNBuilt 1955 · S/N D-310N2923DHurd Nathan A · Lisbon Falls, MEBuilt 1955 · S/N 26866N2923KSallee Daniel C · Port Angeles, WABuilt 1979 · S/N 18053131N2923LHess Daniel G · Sonora, CABuilt 1967 · S/N 670317N2923NSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 32-7940207N2923QRegistration Pending · Sandy, UTRegistration pendingS/N 28-7716124N2923UWeber James · Fall Creek, WIBuilt 1963 · S/N 17250523N2923YS & R Aviation Inc · Boise, IDBuilt 1962 · S/N 18253923N29247Bas Part Sales LLC · Greeley, COBuilt 1979 · S/N 28R-7931195N2924ABennett Ross D · Anchorage, AKBuilt 1953 · S/N 30124N2924BBonanza N2924b LLC · Hermann, MOBuilt 1953 · S/N D-3565N2924CFour Star Aero Services Inc · Palm Coast, FLS/N 34-7970379N2924FReese Howard Aviation LLC · Anderson, SCBuilt 1966 · S/N 18257024N2924LSeidel Robert P · Belle Mead, NJS/N 34-7970381N2924MJones Joshua D · Gallatin Gateway, MTBuilt 1977 · S/N 28R-7837105N2924YLilcad Diversified LLC · Holly Pond, ALBuilt 1962 · S/N 18253924N29251Southeast Aviation Services Inc · Hattiesburg, MSBuilt 1974 · S/N 17264110N29257Blackwell Aviation LLC · Tacoma, WABuilt 1979 · S/N 34-7970244N2925AVan Der Molen Baron J · Readstown, WIBuilt 1953 · S/N 30125N2925CElla Butte Farming Co · Ione, ORBuilt 1954 · S/N 30825N2925DFackair LLC · Granville, OHBuilt 1979 · S/N 28-7990558N2925FRegistered aircraftAssigned, pending cancellationS/N 18257025N2925NClausen Steven L · Hallam, NES/N 28R-7918223N2925RSpeedbird Aviation Alpha Charlie LLC · Glenn Heights, TXBuilt 1969 · S/N 28R-35330N2925YTrinity Air LLC · Lewes, DES/N 18253925
Back to AD 98-21-21 R1