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.

N2173KInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 28-7921002N2173LPritchard Timothy L · Fargo, NDBuilt 1976 · S/N CE-666N2173RRegistered aircraftBuilt 1964 · S/N 18255373N2173SSunrise Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 44-7995245N2173TDitatus LLC · Cornville, AZBuilt 1971 · S/N 28-7205033N2173YLowe Body And Glass Inc · Asheboro, NCBuilt 1962 · S/N 17249673N21741Boniek Martin J · Glennallen, AKBuilt 1974 · S/N 17263998N21743Childers Brian L · Edgemont, SDBuilt 1975 · S/N 17263999N21745Bellingham Aviation Services LLC · Bellingham, WABuilt 1974 · S/N 17264000N21747N21747 Lc · Wichita, KSBuilt 1974 · S/N 17264002N2174EHans Aviation Inc · Davie, FLBuilt 1978 · S/N 28-7916164N2174KGoodhue David H · Vancouver, WABuilt 1978 · S/N 28R-7931003N2174RTurner Ryan J · Pittsburg, TXBuilt 1969 · S/N 28-5478N2174SBarakat Robert H · Rocklin, CABuilt 1979 · S/N 32-7940054N2174TSmith Dustin E · Helena, ALBuilt 1971 · S/N 28-7205023N2174XBennett Milton J · Gig Harbor, WABuilt 1979 · S/N 28-7990362N2174YJohnson Fred A · Five Points, ALBuilt 1962 · S/N 17249674N21754Sale Reported · Kalispell, MTSale reportedBuilt 1974 · S/N 17264005N21757Olson Terry L · Rapid City, SDBuilt 1974 · S/N 17264007N2175ACrawford Garrett Ross · Artesia, NMBuilt 1979 · S/N 32R-7987012N2175FAircraft Trust Services Inc Trustee · Dover, DES/N 28R-7918012N2175GStem John T · Marlin, TXBuilt 1958 · S/N 51475N2175NVenezia Domenick · Shoreline, WABuilt 1979 · S/N 28-7916262N2175RHolt Kristopher T · Wichita, KSS/N 18255375N2175SMichael Lauder K · Littleton, COBuilt 1975 · S/N 21061136N2175TFlying Partners Of Venice LLC · Port Charlotte, FLBuilt 1971 · S/N 28-7205025N21764Blue Sky Flyers Inc · Evans, COFirst renewal noticeBuilt 1974 · S/N 17264010N21769Overseas Aviation Inc · Wilmington, DEBuilt 1974 · S/N 17264013N2176FClaw Aviation LLC · Missoula, MTBuilt 1965 · S/N U206-0376N2176GWhite Robert G · Damascus, ORBuilt 1958 · S/N 51476N2176KLino Edson · Saugus, MAS/N 28R-7931032N2176TSteeplechase LLC · Medfield, MABuilt 1971 · S/N 28-7205034N2176VAspen Avionics Inc · Phoenix, AZFirst renewal noticeBuilt 1979 · S/N 32R-7987116N2176XKnighten Daniel · Portland, ORBuilt 1979 · S/N 28-7990363N2176YFischer James H · Wisconsin Rapids, WIBuilt 1962 · S/N 17249676N21774Miller William A · Wallkill, NYS/N 17264016N21776Beebe Jerry D · Cassville, MOBuilt 1966 · S/N 986N2177FSchofield William R · Fort Mill, SCBuilt 1979 · S/N 28-7911097N2177GSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 51477N2177PMidwest Environmental Products Inc · Wichita, KSBuilt 1956 · S/N 23-783N2177RCalongne Michelle H · Cypress, TXS/N 18255377N2177SFerkin Planes LLC · Caldwell, IDBuilt 1975 · S/N 21061138N2177TRegistration Pending · Pine Mountain, GARegistration pending, pending cancellationBuilt 1971 · S/N 28-7205032N2177YNewbary Jason W · Missoula, MTBuilt 1962 · S/N 17249677N2177ZRegistration Pending · Fayetteville, NCRegistration pendingBuilt 1979 · S/N 28-7911154N21785Dibiaso Thomas F · Mount Laurel, NJBuilt 1974 · S/N 17264018N21788Kenco Associates Inc · Ashland, KYBuilt 1978 · S/N 34-7870450N2178DAir Werks LLC · Fenton, MIBuilt 1953 · S/N D-3525N2178GRegistration Pending · Saint Augustine, FLRegistration pendingBuilt 1978 · S/N 32R-7987067N2178KAbby Aviation LLC · Wilmington, DEBuilt 1978 · S/N 28R-7931033
Back to AD 98-21-21 R1