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.

N159MDLaw Offices Of Shawn A Mcmillan Apc · San Diego, CABuilt 1959 · S/N D-5849N159NDSkyborne Airline Academy Inc · Vero Beach, FLBuilt 1998 · S/N 2842031N159PKRegistered aircraftBuilt 1957 · S/N D-5363N159RSTechnical Education Services Inc · Virginia Beach, VAS/N 27-2817N159SMMcneill Transportation LLC · Whiteville, NCS/N TH-2085N159WMFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 2002 · S/N 4496159N159ZIdaho State University · Pocatello, IDBuilt 1978 · S/N TJ-178N15ADoug Harris Aviation LLC · Pryor, OKBuilt 1966 · S/N TE-172N15AFRogers Jeff · Harrogate, TNBuilt 1976 · S/N 17267237N15APIndy Air Sales LLC · Anderson, INBuilt 1976 · S/N 18264944N15AZHopkins Todd · Russellville, INBuilt 1979 · S/N 18267118N15BCWingsleasing LLC · Wichita, KSBuilt 1964 · S/N 28-1712N15BEAvalon Aviation USA Corp · Murfreesboro, TNBuilt 1981 · S/N R18201806N15BFMayes Richard A · Bend, ORBuilt 1973 · S/N 18052353N15BPTidmore Argie D · Pottsville, PAFirst renewal noticeBuilt 1979 · S/N 18266877N15BREllis David E Jr · Midlothian, TXBuilt 1978 · S/N 32R-7880004N15CASpirit Of Life Ministries International Inc · Carthage, TXBuilt 2005 · S/N 3257401N15CBAaviation LLC · Telford, PABuilt 1976 · S/N 28R-7635291N15CGJwe Aviation LLC · Sugar Hill, GABuilt 1964 · S/N TC-568N15CHOrlando Flight Academy Inc · Apopka, FLBuilt 1974 · S/N 28-7415277N15CLDoran Jeffrey T · Westerville, OHS/N TC-818N15CWN15cw LLC · Wilmington, DEBuilt 1983 · S/N P21000824N15DACamborne USA LLC · Collierville, TNS/N 21061765N15DLSchlund Bradley D · Springtown, TXS/N CD-375N15DNSnowflake Aircraft LLC · Fayetteville, NYBuilt 1989 · S/N E-2472N15DQPrivette Hugh T Trustee · Colorado Springs, COBuilt 1975 · S/N 75-30773N15DSAll Attitude Aviation Inc · Edgewater, FLBuilt 1965 · S/N 320D0079N15DTBernal Cresencio · Pittsburg, CABuilt 1968 · S/N D-8725N15EEBorn To Fly LLC · Booker, TXBuilt 1981 · S/N 34-8133054N15FACivil Air Patrol · Maxwell Afb, ALBuilt 1978 · S/N 17270117N15FGShannon Jesse Lee · Boise City, OKBuilt 1975 · S/N 27-7554112N15FPFoxtrot Papa LLC · Slidell, LABuilt 1977 · S/N 17268574N15FSHappytails Aviation LLC · Fort Collins, COBuilt 1981 · S/N 34-8133046N15GK427 Siera Lima LLC · Ponte Vedra, FLBuilt 1974 · S/N TC-1681N15GMBristol Aviation De LLC · Wilmington, DEBuilt 1995 · S/N E2977N15GWFlight Brothers LLC · Sachse, TXBuilt 1969 · S/N 17258161N15HJMorehouse Cooper · North Pole, AKS/N 17268950N15JAAdams Harry Jay · New Waverly, TXBuilt 1979 · S/N TK95N15JDSwanson Alec · Hanahan, SCBuilt 1972 · S/N 310Q0476N15JEPremier Flight Center LLC · Hartford, CTBuilt 1964 · S/N 27-2494N15JFHumanitarian Airlift International · Owasso, OKS/N D-3095N15JMSale Reported · WurzburgSale reportedBuilt 1981 · S/N 44-8107060N15JUC&D Aviation LLC · Appleton, WIBuilt 1982 · S/N TJ-434N15JWTri-Cap International · Roanoke, TXBuilt 1959 · S/N TD-225N15KCGostanian Gregory K · Fresno, CAS/N D-3478N15KFH Aviation LLC · Celina, TXBuilt 1980 · S/N 32-8006073N15KYMcdougle Sean · Oklahoma City, OKBuilt 1965 · S/N 27-2780N15LSArch Air LLC · Paducah, KYBuilt 1972 · S/N TC-1465N15MEnglish Dexter · Syracuse, KSBuilt 1964 · S/N CD-794N15MLN15ml LLC · Cresskill, NJBuilt 1977 · S/N 21061780
Back to AD 98-21-21 R1