OpenAirDocs.org
AD 98-21-21 R1

Registered aircraft · 85,616

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.

N10ASCrewson Gary · East Aurora, NYBuilt 1972 · S/N 28R-7235196N10BDCalkins Mark E · Longview, TXBuilt 1978 · S/N 310R1539N10BNBlack Thomas D DBA · Clearwater, FLBuilt 1975 · S/N 34-7570050N10BPPeyton James L II · Granby, COBuilt 1973 · S/N D-9533N10BSB R S Leasing Inc · Wilmington, DEBuilt 1971 · S/N TE-841N10BVZondlo Todd · Phoenix, AZBuilt 1972 · S/N D-9345N10CCSmith Kord S · Salmon, IDBuilt 1964 · S/N 206-0166N10CHGulf Coast Rail Service Inc · Victoria, TXBuilt 1969 · S/N 690048N10CRCarlile Aviation LLC · Peculiar, MOBuilt 1981 · S/N R18201808N10DBBrandon Donald A Trustee · El Monte, CABuilt 1977 · S/N 21062016N10DCHbk LLC · Lynden, WAS/N U206-05366N10DEDragoo Robert E · Raleigh, NCS/N 73-32-108N10DJNovak Todd · Lumberton, NJBuilt 1979 · S/N 17272246N10DRFlying W LLC · Camden, DEBuilt 1994 · S/N 3448044N10EEBucci Dennis · Pittsburgh, PABuilt 1971 · S/N D-9307N10ETTech Nav LLC · Columbus, INBuilt 1971 · S/N 310Q0415N10EVCafiero Vincent · Haskell, OKBuilt 1955 · S/N D-4186N10EXDrachen Air LLC · Stafford, VABuilt 1980 · S/N 24-1047N10FCKnott Me LLC · Phoenix, AZBuilt 1973 · S/N 310Q0796N10FLRandall P Roumillat · Dallas, TXS/N 21062892N10GRamsey Wayne · Abilene, TXBuilt 1979 · S/N R18201161N10GCBanks Keith Allen · Salisbury, MDBuilt 1953 · S/N 30159N10GGMartinelli Alexander Joseph · Waco, TXBuilt 1947 · S/N D-1065N10GHPeters Darvin Leroy · Meservey, IAS/N 28-20482N10GLMakulu Adventures LLC · Fort Pierce, FLBuilt 1983 · S/N R18201934N10GMAlo Aviation LLC · Titusville, FLS/N T210-0151N10HGGerardy Harlan D · Gruver, TXBuilt 1974 · S/N 21060169N10HLHoyt Robert H Trustee · Canby, ORBuilt 1975 · S/N 21060646N10HMAggst LLC · Shingle Springs, CABuilt 1978 · S/N 21062908N10HVRegistered aircraftBuilt 1965 · S/N 715N10HXIjh Farm Inc · Seminole, TXS/N 21063588N10JKZalan Aviation LLC · Cincinnati, OHBuilt 1978 · S/N 32R-7887242N10JVHale Thomas O · Cotuit, MABuilt 1973 · S/N 18502242N10KMJohnson Walter N · Hico, TXS/N 310I0101N10KYMckinnon Laughlin Neil Trustee · Carlsbad, CABuilt 1971 · S/N 18501898N10LFive States Holdings LLC · Helena, MTBuilt 1972 · S/N E-347N10LJHarris Michael V · Wildwood, MOBuilt 1982 · S/N EA-276N10MAPatterson Casey Paul · Kinston, ALS/N 24-4180N10MNAircraft Sales Of America LLC · Fenton, MIFirst renewal noticeBuilt 1970 · S/N TE-831N10NFThompson Benjamin K · Nevada, TXBuilt 1976 · S/N TJ-64N10NNK&L Air LLC · Lakewood Ranch, FLBuilt 1994 · S/N E-2895N10NWLinzey David Wayne · Boone, NCBuilt 1963 · S/N 24-3548N10NZConnor Reginald W · The ValleyNon-citizen corporation, flight hours not reportedS/N 34-7870158N10PBNeves Frank Jr · North Miami Beach, FLBuilt 1974 · S/N 34-7570031N10PJMiller Kenneth R · Russellville, KYBuilt 1967 · S/N 32-40285N10PRVillalobos Jesus F · Farmington, NMBuilt 1961 · S/N 310-0032N10PWAircraft Partner Holdings Inc Trustee · BerlinBuilt 1995 · S/N E-2950N10QBAsc Aviation LLC · Brandon, MSBuilt 1978 · S/N 31-7812065N10RP4f Aviation LLC · Palmer Lake, COBuilt 1972 · S/N 21059779N10RRLeonard Christopher S · Moravia, NYBuilt 1954 · S/N D-3706
Back to AD 98-21-21 R1