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.

N1466UConcepcion Leonardo · Downey, CAS/N 17267133N1466VGak Flight LLC · Scandia, MNBuilt 1974 · S/N 17263603N1467FJetceo LLC · Kalispell, MTBuilt 1975 · S/N 18502845N1467TThree2tango LLC · Mount Pleasant, SCBuilt 1972 · S/N 28-7205305N1467XWilson David K · Mckinney, TXBuilt 1975 · S/N 34-7570252N14680Hendricks Aric W · Floydada, TXS/N 74-30643N14687Dalessio Enterprises Inc · Smithville, TNS/N 74-30671N1468DAhrens David R · Guthrie Center, IABuilt 1951 · S/N 20051N1468MArctic Barnabas Ministries · Kenai, AKBuilt 1970 · S/N U20601468N1468THindle John Charles IV · Whitehouse Station, NJBuilt 1972 · S/N 28R-7235296N1468VMonmouth Flying Club · Monmouth, ILBuilt 1974 · S/N 17263605N14690Davis Scott · Morse, TXBuilt 1973 · S/N 74-30637N14691Weakley Robert Kayce · Pleasant View, TNS/N 74-30682N14695Johnson Charles E · Vernon, TXBuilt 1974 · S/N 74-30688N1469FSkywagon 185 LLC · Ocala, FLBuilt 1975 · S/N 18502847N1469SS & J Farms · Floydada, TXBuilt 1976 · S/N 18265016N1469TThree Wing Flight School LLC · Stratford, CTBuilt 1972 · S/N 28R-7235297N146BPNoughton Larry W · Fort Myers, FLBuilt 1994 · S/N CE-1775N146CPlanes & Parts Inc · Weston, FLBuilt 1964 · S/N TC-599N146DSale Reported · San Diego, CASale reported, pending cancellationBuilt 1948 · S/N D-1791N146DB4405 LLC · Jenks, OKBuilt 1999 · S/N 3257100N146DCAztec Worldwide Airlines Inc · Wilmington, DES/N 31-7305109N146FCUsda Forest Service Fepp · Malvern, ARBuilt 1966 · S/N P206-0247N146JMarc Inc · Bolton, MSBuilt 1977 · S/N 31-7852005N146JWDodge Inc · Wilmington, DEBuilt 1976 · S/N 28-7615348N146LWBelvedere Inc · Marion, IABuilt 1979 · S/N 287911236N146MBMlc Flying Club LLC · Saint Peters, MOBuilt 1978 · S/N 32-7840160N146PWilliams Mike C · Sonora, TXS/N 24-366N146PTCoco Aircraft Inc · Merritt Island, FLBuilt 1979 · S/N 28-7916307N146RAerospatiale LLC · Selah, WAS/N HH-145N146SCFantasy Aire Inc · Wilmington, DEBuilt 1968 · S/N 32-985N146SWFairway Systems LLC · New Port Richey, FLBuilt 1980 · S/N 32-8006040N146TAShamash Micah I · Larkspur, COBuilt 1980 · S/N EA-176N146YBayer Peter D · Naperville, ILBuilt 1955 · S/N 32098N146YSHorn George A · Spicewood, TXBuilt 1952 · S/N 25713N146ZUtah State University · Logan, UTBuilt 1982 · S/N TJ-426N14702Cartel Oil Records LLC · Kansas City, MOBuilt 1973 · S/N 74-32-136N14705Bernath Robert J · Saint Johns, FLBuilt 1974 · S/N 74-30668N14706Carter Delton W · Sumner, TXS/N 74-30716N14709Godfrey Lawrence J · Leucadia, CABuilt 1973 · S/N 74-30650N1470BBerger Leo · Nampa, IDS/N 31-7512061N1470GBaker Dennis J · Shipman, ILS/N CD-465N1470HCherokee Air Inc · Lexington, SCS/N 32R-7780162N1470QHillyer Joe F · Soldotna, AKBuilt 1977 · S/N 18503483N1470UScientific Aerial Imaging Inc · Saint Helena, CABuilt 1976 · S/N 17267137N1470VGiron Lawrence N · Anchorage, AKBuilt 1974 · S/N 17263607N14714Poco Loco LLC · Mesa, AZBuilt 1973 · S/N 74-31084N14718Slys Aircraft Service · Platte, SDBuilt 1974 · S/N 74-32-142N1471DSchwarzkopf Michael A · St Peters, MOBuilt 1951 · S/N 20054N1471EKdrd Holdings LLC · Texas City, TXBuilt 1978 · S/N 17271014
Back to AD 98-21-21 R1