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.

N2600QBivens Jason D · Duncan, OKBuilt 1966 · S/N 18257800N2600ROrlandella Vito P · Auberry, CABuilt 1967 · S/N 18258300N2600VErickson Rodney L · Rutland, NDBuilt 1948 · S/N 18238N2600WDeaero LLC · Darwin, MNS/N 3285N2600YCurrin Thomas E · Pendleton, ORBuilt 1962 · S/N 18051100N2601BQualitair LLC Trustee · MichelstadtBuilt 2006 · S/N 3257421N2601DHerrmann Mark D · Dillingham, AKS/N 20753N2601FFly3h4 LLC · Hillsboro, NDBuilt 1965 · S/N 18256701N2601LCobb William J · Cincinnatus, NYBuilt 1967 · S/N 17255801N2601RHarden Aviation LLC · Washington, PABuilt 1969 · S/N 28R-35223N2601UK D Helicopters Inc · Shingleton, MIBuilt 1963 · S/N 17250201N26024H&J Holdings LLC · Moses Lake, WABuilt 1985 · S/N 28-8690005N2602CRrb Aviation LLC · Jasper, TXBuilt 1954 · S/N 35002N2602DAllen Matt · Bullhead City, AZS/N 20754N2602GConran Joshua · Belmont, MIBuilt 1959 · S/N 51902N2602RSiegel Jeffrey P · Snowmass Village, COS/N 18258302N2602UVan Zee Charles C · Rancho Cucamonga, CABuilt 1963 · S/N 17250202N2602WHartman William J · Yuba City, CABuilt 1965 · S/N 951N2603Intentus Aviation LLC · Sunset, TXS/N 32957N2603FHolloway Graham · Orcutt, CABuilt 1965 · S/N 18256703N2603KPadilla Management Inc · Burlington, WABuilt 1978 · S/N 18053013N2603LMagel David J · Lakemoor, ILBuilt 1967 · S/N 17255803N2603RHopper Jeremy G · Amity, ORS/N 18258303N2603WMorrey Joseph T · Erie, COBuilt 1965 · S/N 952N2603YNorton Raquel D Trustee · Stateline, NVBuilt 1985 · S/N 28-8690006N2604DO4dflys LLC · Enterprise, ORBuilt 1952 · S/N 20756N2604GBlessing Christopher B · Houston, DEBuilt 1959 · S/N 51904N2604UTalboy Theodore Neal · Lathrop, CABuilt 1963 · S/N 17250204N2604WIghzawi Saif F · Green Bay, WIBuilt 1965 · S/N 953N2604YLawson Charles A · Arlington, WABuilt 1962 · S/N 18051104N2604ZBurgan Grover W · Jacksonville, FLBuilt 1981 · S/N 27-8154012N2605FRose Walter W · Arena, WIBuilt 1965 · S/N 18256705N2605GInnes Stephen L · Bentonville, ARBuilt 1959 · S/N 51905N2605WHarman David M · Ballwin, MOBuilt 1965 · S/N 3287N2606DMoran Craig L · Krotz Springs, LABuilt 1952 · S/N 20758N2606QElsayed Von Bayreuth Alaaeldeen Mohamed · Fairfield, CABuilt 1966 · S/N 18257806N2606UJanovyak Aviation LLC · Lockport, ILBuilt 1979 · S/N 28R-7931291N2606XSmith And Cherry Aviation LLC · Knoxville, TNBuilt 1965 · S/N P206-0106N2607DMachen Matthew W · Lander, WYBuilt 1952 · S/N 20759N2607GJensen Rodney · Aptos, CABuilt 1959 · S/N 51907N2607RSullivan Christopher · Duson, LAS/N 28R-35226N2607SHunter Gary A · Fort Wayne, INBuilt 1976 · S/N 21061338N2607VHamlin Ryan C · Naples, MES/N 18117N2607WPlumb Russell V · Apple Valley, CAS/N 954N2607YAero-Sphere Inc · Longmont, COBuilt 1985 · S/N 28-8516086N2607ZSidney Aviation LLC · Sidney, NEBuilt 1963 · S/N 185-0607N2608QMiller David C · Burlington, CTBuilt 1966 · S/N 18257808N2608RRegistered aircraftBuilt 1967 · S/N 18258308N2608VWohl Mitch A · Deer Park, ILBuilt 1948 · S/N 18118N2608XOdonnell James E · Northport, NYBuilt 1965 · S/N P2060103
Back to AD 98-21-21 R1