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.

N2905ECappadona Roy · Iliamna, AKBuilt 1978 · S/N 17271369N2905LSteel Alan P · Odessa, TXBuilt 1967 · S/N 670299N2905RKlassen Thomas · Corpus Christi, TXS/N 310G0105N2905UKear Edward B · Bonita Springs, FLBuilt 1963 · S/N 17250505N29061Swalling Frederick M · Anchorage, AKBuilt 1968 · S/N U206-1045N29062Jackson Stephen D · Pennsboro, WVBuilt 1979 · S/N 28-8011054N29068Jd Flying LLC · Bellingham, WABuilt 1968 · S/N U206-1049N2906CNewman Dan A · Oak View, CABuilt 1954 · S/N 30806N2906DKennedy Ken · Lubbock, TXBuilt 1955 · S/N 26849N2906LHogue Aviation LLC · Dover, PABuilt 1967 · S/N 670300N2906QCage James D · Muleshoe, TXS/N 18503542N2906ULynch Lawrence C · Ladson, SCBuilt 1963 · S/N 17250506N29070Buzick Carey B · Fargo, NDBuilt 1978 · S/N R18200639N2907BPowell Gregory S · Paso Robles, CAS/N D-3552N2907CPiedmont Southern Associates Inc · Clayton, GABuilt 1954 · S/N 30807N2907DSandhu Tejpal · Southlake, TXS/N 34-7970348N2907QTweto Matthew E · Montgomery, TXS/N 34-7970349N2907RFricks Cline Thomas Jr · Toccoa, GABuilt 1969 · S/N 28R-35324N2907UServer William F · Sterling, MIBuilt 1963 · S/N 17250507N29084D E C Holdings · Hansen, IDBuilt 1972 · S/N 21059798N2908CWilliams Daniel P · Afton, WYBuilt 1954 · S/N 30808N2908FCooprider Lee W Trustee · Littleton, MABuilt 1966 · S/N 18257008N2908LGurney Stephen E · Niceville, FLBuilt 1967 · S/N 670302N2908XArtsplane LLC · Parker, TXS/N 34-7970352N2908YAnco Air Inc · Weston, FLS/N 32R-8129100N29098Gill Stuart W Jr · Kingsport, TNBuilt 1979 · S/N 28-7990436N2909ARasor William E · Brookville, OHBuilt 1953 · S/N 30109N2909BIsland Hoppers Inc · Glenridge, NJBuilt 1979 · S/N 32-7940196N2909CHall Michael A · Spirit Lake, IDBuilt 1954 · S/N 30809N2909DPainter Kelly A · Cantwell, AKBuilt 1955 · S/N 26852N2909QHelman Tom · Evanston, WYBuilt 1979 · S/N 28-7916533N290FCRegistration Pending · Greenwood, MSRegistration pendingBuilt 1965 · S/N 18256135N290HADon'T Call Me Shirley LLC · Fort Myers, FLBuilt 1966 · S/N 28-3624N290MSurging Skyward Inc · Newtown, PAS/N 27-7554111N290MGGeorgia Aviation Authority · Eastman, GABuilt 2014 · S/N 2843761N290NDChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 4496021N290SGinter Aviation LLC · Oakland, MDBuilt 1971 · S/N E-292N290VGAlmy David W · Riverside, CAS/N 23-5N29107Wrong Brothers Aviation LLC · Brighton, MIBuilt 1974 · S/N 17264100N2910BShively Aurora J · Anchorage, AKS/N D-3554N2910DDomke Daniel Carl · Anchorage, AKS/N 26857N2910LBurger Walter F III · Sugar Land, TXBuilt 1967 · S/N 670304N29110Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1968 · S/N U206-1080N29113Figueroa Angel Lara · Winfield, ALBuilt 1973 · S/N 21059806N29114Grey Goose LLC · Wasilla, AKBuilt 1968 · S/N U206-1084N2911DPagano Ralph V · Cranbury, NJBuilt 1979 · S/N 18267459N2911FRegistration Pending · Fayetteville, ARRegistration pendingBuilt 1966 · S/N 18257011N2911GOrtega Rolando J · Sanford, FLBuilt 1979 · S/N 28-7916537N2911PHayes Gregory S · Edinboro, PABuilt 1979 · S/N 28R-7918216N2911UNight Sky LLC · Canton, SDBuilt 1963 · S/N 17250511
Back to AD 98-21-21 R1