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.

N14009Livingston Aviation Inc · Waterloo, IABuilt 1971 · S/N 27-4627N1400FBingham Edward K · Buchanan, GABuilt 1966 · S/N 17254895N1400GRotor Spec Aviation LLC · Star, IDBuilt 1961 · S/N D-6890N14012Rock Valley College · Rockford, ILBuilt 1971 · S/N 27-4629N1401DRegistered aircraftBuilt 1951 · S/N 19984N1401EUnited States Air Force Aero Club · Usaf Academy, COBuilt 1978 · S/N 17270986N14028Stoks Derek R · Canby, MNS/N 27-4689N1402FRegistration Pending · Pomona, CARegistration pendingBuilt 1966 · S/N 17254897N1402SJohnston Matthew A · Ventura, CABuilt 1976 · S/N 18264962N1402YRg Enterprises LLC · Tullahoma, TNBuilt 1961 · S/N 17249102N14033Nomadic Flight Training LLC · New Castle, DES/N 28-25388N14036Booth Donald V · Denison, TXBuilt 1971 · S/N 27-4648N14038Eagle Aviation And Logistics LLC · Cheyenne, WYS/N 700017N1403FGoedeker Jr Werner F · Waterville, NYBuilt 1966 · S/N 17254898N1403G1403g LLC · Wheat Ridge, COBuilt 1961 · S/N TC-227N1403SFarnsworth Scott · Crestwood, KYBuilt 1976 · S/N 18264963N1403VSmith Dennis A Trustee · Salem, ORBuilt 1974 · S/N 17263550N14040Island Aviation Inc Trustee · Wilmington, DEBuilt 1971 · S/N 27-4654N1404GJkc Farm LLC · Chinook, MTBuilt 1961 · S/N D-6893N1404HMiller Shawn C · Milaca, MNS/N 28-7716023N1404SRegistration Pending · Englewood, CORegistration pendingS/N 18264964N14051Sams Way · Eagle Mountain, UTBuilt 1971 · S/N 27-4663N14055Top Hand Inc · Laurel, MTBuilt 1952 · S/N 20937N1405GLefever Larry R · Fall City, WABuilt 1961 · S/N D-6891N1405MWilson George W · Tucson, AZBuilt 1975 · S/N 18264318N1405SVickers David A · Douglas, GABuilt 1976 · S/N 18264965N1405UGuardian Aerial Patrol LLC · Edmond, OKBuilt 1976 · S/N 17267075N1405XRij Edward · Clovis, CABuilt 1975 · S/N 28-7515292N1405YImrich Thomas S · Mercer Island, WABuilt 1961 · S/N 17249105N14060Skinner Daniel R · Mount Airy, GABuilt 1964 · S/N 28-20333N1406MHeisler Jon S · Auburn, WABuilt 1954 · S/N 30851N1406TCitabria Inc · Auburn, CABuilt 1972 · S/N 28R-7235280N14078Tundra Aviation Inc · Casselton, NDS/N 27-4679N1407SCaesar Wings LLC · Ubly, MIBuilt 1976 · S/N 18264967N1407TAndrews University · Berrien Springs, MIBuilt 1972 · S/N 34-7250311N1407UN R I Flying Club · Walnut Creek, CABuilt 1976 · S/N 17267077N1407XRavotti Air LLC · Leechburg, PABuilt 1975 · S/N 28-7505224N14089Szymanski Tadeusz · Fort Myers, FLS/N 27-4687N1408DParks James M · Potsdam, NYBuilt 1951 · S/N 19991N1408GMorris Travis T · Chandler, AZBuilt 1961 · S/N D-6892N1408SFrickel Well Service LLC · Atkinson, NEBuilt 1976 · S/N 18264968N1408TCarter Jeff · Paragould, ARS/N 28-7225505N1408YShawver Aviation LLC · Knoxville, IABuilt 1961 · S/N 17249108N1409DArcher William Todd · North Pole, AKBuilt 1951 · S/N 19992N1409GAir Care Leasing LLC · Lamar, COBuilt 1961 · S/N TC-233N1409TAnker Mark W · Cambridge, OHBuilt 1972 · S/N 28-7225506N1409XHolmberg Shane A · Fairbanks, AKBuilt 1975 · S/N 32-7540155N140ACApplebaugh Jeffrey · Mechanicsville, MDBuilt 1968 · S/N 28-25001N140AMSuchko Paul S · Venetia, PAS/N 28-26418N140BCN504fl LLC · Killeen, TXBuilt 1971 · S/N 28-7125313
Back to AD 98-21-21 R1