AD 98-21-21 R1

Registered aircraft · 85,616

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.

N11YTAnm Air LLC · Grimes, IABuilt 1986 · S/N 32-8606018N11YYAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1967 · S/N 30-1573N11YZHuggins David R · Carmichael, CABuilt 1970 · S/N 18260401N12000Bear Creek Air LLC · Helena, MTBuilt 1968 · S/N 18259487N1200USowers Harry D · S Bloomingvle, OHBuilt 1978 · S/N 17272035N1200XLacola Joseph D · Commerce Township, MIBuilt 1963 · S/N 103N1201AByrne Michael · Fountain Hills, AZBuilt 1978 · S/N 24-0552N1201FRed Door Aviation LLC · Dover, DEBuilt 1979 · S/N 17272966N1201JHall Brian E · Bedford, INBuilt 1978 · S/N 24-0504N1201SFlying J Ranch Of Ocala Inc · Port Saint Lucie, FLBuilt 1978 · S/N 24-0556N1201TTrudel Serge · The Woodlands, TXBuilt 1978 · S/N 24-0557N1201VSchutz Ronald W · Portland, ORBuilt 1978 · S/N 24-0558N1201XSimmons Herbert H Trustee · Pasadena, CABuilt 1963 · S/N 2604N1202BDavis Aviation Inc DBA · Brandon, MSBuilt 1974 · S/N TC1825N1202GTyler Brenda · Mountain Top, PABuilt 1974 · S/N 310Q1057N1202XBrady Creative Services LLC · Forsyth, MOBuilt 1963 · S/N 2605N1203FRawson Aviation LLC · Collinsville, OKBuilt 1979 · S/N 17272968N1203TProfessional Locators & Acquisition Specialists Ll · Severance, COBuilt 1972 · S/N 28-7225420N1203WPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1980 · S/N 310R-2106N1203XMcelwain Russell D · Lancaster, KSBuilt 1963 · S/N 2606N1204FMoroney Aviation LLC · Chugiak, AKBuilt 1975 · S/N 18502767N1204THigh Sky LLC · Ellensburg, WABuilt 1972 · S/N 28-7225421N1204XMcdonald Monroe · Aguila, AZBuilt 1963 · S/N 2607N1204ZAquila Aero LLC · Denison, TXBuilt 1961 · S/N D-6667N1205BEngel Shane J · Willow, AKBuilt 1963 · S/N 205-0190N1205GKnapp James Ross · Apex, NCBuilt 1974 · S/N 310Q1060N1205TAmerican Aircraft Management LLC · Irving, TXBuilt 1972 · S/N 28-7225422N1205UBordeaux Marvin · Willcox, AZBuilt 1976 · S/N 17266904N1205XOsborn Aviation LLC · Claude, TXBuilt 1963 · S/N 183N1206APelham Aircraft LLC · Dallas, TXBuilt 1966 · S/N 301206N1206FHarrah Daniel R · Juneau, AKBuilt 1975 · S/N 18502769N1206TCps 1 LLC · Pelham, ALBuilt 1972 · S/N 28-7205266N1206XNlw 1 LLC · Washington, UTS/N 184N1206ZGlg Properties LLC Series 13 · Bridgeport, TXS/N D-6678N12077Crawley Michael P · Penn Valley, CABuilt 1965 · S/N 18255966N1207HVenture West LLC · Mesa, AZS/N 28-7790295N1207PN73481 LLC · Ault, COBuilt 1955 · S/N 23-223N1207UKasakoff Lloyd · Diamond Bar, CAS/N 17266906N12082Lopez George · Dover, DES/N 17261797N1208DMusgrove James F · Burien, WABuilt 1955 · S/N 19762N1208FYukon Air Service Inc · Fairbanks, AKBuilt 1975 · S/N 18502771N1208HWaldel Ltd · West Lafayette, INS/N 28-7790296N1208XCartaya Lazaro C · Miami, FLBuilt 1963 · S/N 2611N1208ZMaurice L Prince Jr Pc · Lafayette, LABuilt 1961 · S/N TC-60N12090Diaz Aviation LLC · Mount Upton, NYBuilt 1973 · S/N 17261800N12091K D Farms Inc · Cosmos, MNBuilt 1973 · S/N 17261801N12097Aerolease Aviation Rental LLC · Cartersville, GABuilt 1973 · S/N 17261807N12098Traywick James D · Cope, SCBuilt 1973 · S/N 17261808N1209MShook Steve Trustee · Boulder, COBuilt 1975 · S/N 18264243N1209RRowley Timothy · Roopville, GABuilt 1954 · S/N 26152
Back to AD 98-21-21 R1