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.

N28131Kaczmarek John F · Weatherford, TXBuilt 1978 · S/N 78-30870N28134Rowand Kent · Powell, OHBuilt 1979 · S/N 80-30975N28135Bffe Inc · Homestead, FLS/N 80-30976N28138Todd Jared · Victoria, TXBuilt 1977 · S/N 78-31142N28139Banchero Robert · Queen Creek, AZBuilt 1980 · S/N 80-30983N2813ADoig Margaret · Omaha, NEBuilt 1969 · S/N D-9057N2813CFray Jonathan C · Wasilla, AKBuilt 1954 · S/N 26356N2813FDan Air LLC · Greenville, SCBuilt 1966 · S/N 18256913N2813LFoster Neal W · Nome, AKBuilt 1967 · S/N 17256013N2813QOriginal Design Ministries · Eatonville, WABuilt 1971 · S/N 17259813N2813TKamper Gregory S · Ripon, CABuilt 1972 · S/N 28-7225237N2813VAdair Edward A · Hemet, CABuilt 1947 · S/N D-214N28141Viking Air Inc Trustee · Wilmington, DEBuilt 1980 · S/N 80-30982N2814CStone Robert D · Anchorage, AKBuilt 1954 · S/N 26357N2814KMacario Mark A · Weirsdale, FLBuilt 1979 · S/N 18053085N2814LStewarts Aircraft Service Inc · Waynesville, OHBuilt 1967 · S/N 17256014N2814QGill Robert L · Dixon, CABuilt 1975 · S/N U20602998N2814RCypress Aviation Inc · Naples, FLBuilt 1967 · S/N 18258414N2814YYankee Tango Mike LLC · Dublin, TXS/N 18253814N28154Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843728N2815CCooper David A · Mc Kittrick, CAS/N 26358N2815FKlopping William E · Apple Valley, CAS/N 28-7916438N2815KStudniski Alois W · Saint Joseph, MNS/N 18053086N2815MEd Hamilton Investments Lc · Richmond, TXBuilt 1977 · S/N 28R-7803147N2815RKimmel Aviation Insurance Agency Inc · Greenwood, MSBuilt 1967 · S/N 18258415N2815UHarris Tony James · Stanley, NCBuilt 1963 · S/N 17250415N2815YFlakes LLC · Fort Worth, TXBuilt 1962 · S/N 18253815N28160Sobol Anthony J · Sandia Park, NMBuilt 1979 · S/N 79-31153N28166Lark Thomas · Coppell, TXBuilt 1978 · S/N 79-30910N28168Walker Investment Co Construction · Cookeville, TNBuilt 1978 · S/N 79-30912N28169Zollars Byron · Georgetown, TXBuilt 1979 · S/N 79-30937N2816GGiles Aviation LLC · Spring, TXBuilt 1979 · S/N 28-7990451N2816KVigna Douglas Del · Portland, MEBuilt 1979 · S/N 18053087N2816NAlford Hobart R · Palm City, FLBuilt 1979 · S/N 28-7990452N2816PNetz Aviation LLC · Grand Ledge, MIS/N 28-7990453N2816RBipes Anthony G · Forest Lake, MNS/N 28R-35297N28177Perez Philip G · Ft Worth, TXBuilt 1978 · S/N 78-30883N28179Canto Aviation LLC · Buxton, NCBuilt 1979 · S/N 79-30923N2817ARamey Shane · Buffalo, WYBuilt 1953 · S/N 30017N2817C2817c Inc · Wilmington, DEBuilt 1978 · S/N R18200231N2817D2b Group LLC · West Dundee, ILBuilt 1979 · S/N 28-7990455N2817LHopkins Dennis L · Bark River, MIBuilt 1979 · S/N 28-7990456N2817RHunt Loren M · Nevada, MOBuilt 1969 · S/N 28R-35298N2817UAero Ventures Inc · Yukon, OKBuilt 1963 · S/N 17250417N28181Cheslar Aviation LLC · Lewes, DEBuilt 1978 · S/N 78-30905N28189Knipe Ronald C · Orlando, FLBuilt 1979 · S/N 79-30932N2818AHengemuhle Ronald J · Long Prairie, MNBuilt 1979 · S/N 28-7990459N2818CSchmidt Wolf E · Anchorage, AKBuilt 1954 · S/N 26361N2818DSlodki David · Massapequa Park, NYBuilt 1978 · S/N 17270704N2818ESale Reported · Lexington, NCSale reportedBuilt 1978 · S/N 17271334
Back to AD 98-21-21 R1