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.

N143CRNkm LLC · Glasgow, MTBuilt 1993 · S/N EA-550N143DBBernard Daniel · GrillyBuilt 1965 · S/N 18256678N143DROroca Flying Club LLC · Weehawken, NJBuilt 1972 · S/N 17261119N143DSBen-David Meir · Woodland Hills, CABuilt 1981 · S/N TJ-357N143DWCardinal Aviation LLC · Towson, MDBuilt 1974 · S/N 32-7440164N143EYTriple D Aviation LLC · Merritt Island, FLBuilt 1968 · S/N 28-24348N143FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290178N143HJHurlburt Ward B IV · Anchorage, AKBuilt 1976 · S/N 18503032N143JMMa Cedric Sek-Kong · Los Angeles, CABuilt 1964 · S/N 28-20358N143KPescitelli Paul · Atlanta, GABuilt 1964 · S/N D-7664N143KMBc Aircraft LLC · Edmonds, WABuilt 1977 · S/N 18265435N143LWMurphy Law Office Pc · Rapid City, SDBuilt 1979 · S/N R18201265N143MBHughes Kathryn G · Council, IDBuilt 1963 · S/N CD-693N143MGPatriot Air Inc · Maryland Heights, MOS/N 310K0134N143MMPalo Michael Scott · Melbourne, FLBuilt 1970 · S/N 39-18N143PBHemdmm Corp · Wilmington, DEBuilt 1977 · S/N 28R-7703243N143RMOft7 LLC · Ponca, ARBuilt 1975 · S/N 18263650N143SWBb&D Airways LLC · N Redngtn Bch, FLS/N 310R1856N143TBSmith Timothy T · Turkey, NCBuilt 1979 · S/N 28-8011053N143TCHarris William D · Topeka, KSBuilt 1962 · S/N 205-0064N143XAllman Gary · Charlotte, NCBuilt 1960 · S/N CD-147N14401Berggren Ryan · Newton, NJBuilt 1967 · S/N 27-3722N14407Hanson Rod D · Wasilla, AKBuilt 1964 · S/N 185-0676N1440R39a LLC · Sioux Falls, SDBuilt 1966 · S/N TE-175N1440SPolkowske Leroy A · La Jara, COBuilt 1976 · S/N 18264988N1440UPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 28020248N1440XAlldredge Brad · Redlands, CABuilt 1963 · S/N 24-3478N1441FMartin Michal R · Alva, OKBuilt 1966 · S/N 17254936N1441PN1441p LLC · Pompano Beach, FLBuilt 1973 · S/N 17260993N1441SHustad Kenneth H · Spokane, WABuilt 1976 · S/N 18264989N1441VYegge David J · Hartland, MIBuilt 1974 · S/N 17263579N1442Viotto Stephen J · Anchorage, AKS/N 52072N1442DBiggs James R · Piney Flats, TNBuilt 1973 · S/N 18262106N1442MLorenzo Blake D · Wynne, ARBuilt 1975 · S/N 18264332N1442STodd Philip A · Wendell, NCBuilt 1976 · S/N 18264990N1442TKeller Mark · Alexandria, KYBuilt 1972 · S/N 28-7205298N1442UEastern Idaho Flying Club · Idaho Falls, IDBuilt 1976 · S/N 17267109N1443FNelson Harold G · Pendleton, ORBuilt 1966 · S/N 17254938N1443GLewis Andrew P · Altoona, IABuilt 1962 · S/N CD-518N1443MBahnmiller Dennis D · Highwood, MTBuilt 1975 · S/N 18264333N1443VSchovanec David L · Stuart, FLBuilt 1974 · S/N 17263580N1444FStrope Byron P · Upland, CABuilt 1966 · S/N 17254939N1444GLam Lawrence Y · Rosemead, CAS/N D-15002N1444MPhillips Jason Marc · Milford, NJBuilt 1965 · S/N CD-827N1444SEagle Forestry Services Inc · Monticello, ARBuilt 1976 · S/N 18264992N1444XWaddell Charles · Elk Grove, CABuilt 1975 · S/N 28R-7535283N1444YHiggins Derrick G · Arbyrd, MOBuilt 1962 · S/N 17249144N1445ESouth Aero LLC · Albuquerque, NMBuilt 1978 · S/N 17271004N1445FMorris Loyd Albert · Alvarado, TXBuilt 1966 · S/N 17254940N1445HNelson Joshua M · Eagle, IDBuilt 1999 · S/N 3257092
Back to AD 98-21-21 R1