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.

N297DRMingus Mason · Scottsville, KYBuilt 1978 · S/N 62398N297HPCherokee Investments LLC · Monroe, VABuilt 1997 · S/N 3246081N297JGInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 317952043N297MAFlaps 30 Gear Down LLC · Laguna Niguel, CABuilt 1997 · S/N 3246062N297MGGeorgia Aviation Authority · Eastman, GABuilt 2017 · S/N 2843863N297VLewis Rodney · Andalusia, ALBuilt 1966 · S/N 3389N297ZEnovi LLC · Las Vegas, NVBuilt 1981 · S/N U20606223N2980AWest David R · Newalla, OKBuilt 1978 · S/N D-10154N2980CBrown Cow LLC · Eagle River, AKS/N 30880N2980LJentes Charles A · Smithville, OHFirst renewal noticeBuilt 1967 · S/N 670339N2980QBlb Aircraft Partners LLC · Wilmington, DES/N 32R-7780274N2980RSlagle Noah J · Griffin, GABuilt 1969 · S/N 28R-35368N2980YLeisz Jeffrey A · Bloomington, INBuilt 1962 · S/N 18253980N2981BStowells Outlaw Services LLC · Rigby, IDS/N D-3621N2981DYoungblood Allyson M · Anchorage, AKS/N 26924N2981ECox William Warren · Collierville, TNBuilt 1978 · S/N 17271394N2981KNiles Air LLC · Concord, NCBuilt 1980 · S/N 18053145N2981YBeebe Michael · Rangeley, MEBuilt 1962 · S/N 18253981N29821Jks Enterprises Inc · Park Rapids, MNBuilt 1972 · S/N 18261233N2982ASkywagon Pilots Inc · Santa Clara, CABuilt 1953 · S/N 30182N2982KHalcomb Billy J · Pond Creek, OKBuilt 1980 · S/N 18053146N2982LBurgdorf Brandon M · Evansville, INBuilt 1967 · S/N 670341N2982MBergeron John E · Shenandoah, TXBuilt 1977 · S/N 28R-7803158N2983BFisher Bryce Anthony · Cleveland, TNS/N D-3623N2983DIngalsbe David L · Flowery Branch, GABuilt 1955 · S/N 26926N2983FHalle Michael P · Livingston, TXBuilt 1966 · S/N 18257083N2983VBellgardt Robert · North Bend, WABuilt 1947 · S/N D-380N2984CRosser Brian K · Minden, NVBuilt 1954 · S/N 30884N2984UJuris Ronald D · Bickleton, WABuilt 1966 · S/N 17255040N2984YRondeb Aircraft LLC · Wilmington, DEBuilt 1962 · S/N 18253984N2985CBraham John P · Fairbanks, AKBuilt 1954 · S/N 30885N2985LHeskett Sean D · Steamboat Springs, COBuilt 1967 · S/N 670344N2985UConnersville Flying Club Inc · Connersville, INBuilt 1963 · S/N 17250585N2985YJones Aviation Inc · Biggs, CABuilt 1962 · S/N 18253985N2986AMorris Blain E · Delta Junction, AKBuilt 1953 · S/N 30186N2986BBrittian Scott A · Wichita, KSBuilt 1953 · S/N D-3496N2986KSmith John F III · Middletown, DEBuilt 1980 · S/N 18053149N2986RArmstrong Dustin L · Hobbs, NMS/N 28R-35375N2986ULuebke Austin D · Corsica, SDS/N 17250586N2987BKrog Donald C · Somerville, NJBuilt 1953 · S/N D-3625N2987CYount Lawrence F · Shelton, WABuilt 1954 · S/N 30887N2987DScheda Mark R · Brockport, NYBuilt 1955 · S/N 26930N2987FRegistered aircraftBuilt 1966 · S/N 18257087N2987KSpielvogel Heinz · Charlestown, RIBuilt 1980 · S/N 18053150N2987UMott Charles A Jr · Chesapeake, VABuilt 1963 · S/N 17250587N2988DBrown Hector M · Glenwood Springs, COBuilt 1955 · S/N 26931N2988FTaf Aerial Services LLC · Beeville, TXBuilt 1966 · S/N 18257088N2988KMelvin Perry D · Warner Robins, GABuilt 1980 · S/N 18053151N2988RSpilman Kathleen M · Mandan, NDBuilt 1970 · S/N 28R-35671N2988UFrost Eddy L · Bishop, TXS/N 17250588
Back to AD 98-21-21 R1