AD 98-05-14 R1

Registered aircraft · 909

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-05-14-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-05-14-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.

N787AQHiflynal LLC · Harrisburg, ORS/N P21000844N79DVDiscovery Associates Inc · Midland, TXBuilt 1979 · S/N P21000233N79RCBach II LLC · Lafayette, LABuilt 1982 · S/N 21064697N7ALFlying Fortress Of Swfl LLC · Fort Myers, FLS/N 21063261N7LVBas Part Sales LLC · Greeley, COBuilt 1980 · S/N P21000506N7MFBarger Christopher H Trustee · Mesa, AZBuilt 1980 · S/N P21000583N7RRTavan Richard M · Saratoga, CAS/N 21063468N800LGPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N P21000669N802MSMarotta Scientific Controls Inc · Montville, NJBuilt 1983 · S/N 21064780N80SGFerland Henry L III · Vidalia, GABuilt 1980 · S/N 21064014N818PCWindigo Transportation Inc · Waterloo, IABuilt 1982 · S/N P21000803N81DTKbk Aviation LLC · Youngsville, LAS/N 21064519N81KCCraigo Keith A · Addison, TXBuilt 1981 · S/N 21064386N81MTBennett Thomas Richard · Brooklyn Park, MNBuilt 1981 · S/N P21000794N81VRRaviele Vincent · Richmond, TXBuilt 1986 · S/N P21000868N824MAE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1981 · S/N P21000763N827RPJireh Aviation LLC · Zeeland, MIBuilt 1980 · S/N P21000541N828RJNielsen Ron E · Lindon, UTS/N 21063836N829BAAdaptive Resources Inc · Fort Morgan, COBuilt 1983 · S/N P21000819N833RTNash LLC · Carbondale, ILBuilt 1982 · S/N P21000809N839HFFour Boys Flying LLC · Kalispell, MTBuilt 1980 · S/N P21000633N83CEElsner Kelly J · Menahga, MNBuilt 1980 · S/N P21000578N8424WExtra Equipment Inc · Stuart, FLBuilt 1979 · S/N 21063732N843YTTrue Drilling LLC · Casper, WYBuilt 1979 · S/N 21063334N84SJLabelle Gregory D Trustee · Newbury Park, CABuilt 1984 · S/N 21064867N852SDauenhauer Manufacturing Inc · Ketchum, IDBuilt 1978 · S/N P21000081N858BBEchelon Group Inc · Boise, IDBuilt 1979 · S/N 21063277N85ADEagle Eye Produce Inc · Idaho Falls, IDS/N P21000795N86DHHolloway'S Tire And Auto Service Inc · Thomaston, GABuilt 1984 · S/N 21064832N86MTWhite Knuckles Aviation LLC · Carson City, NVBuilt 1980 · S/N P21000533N888ECArrow Aviation LLC · Noblesville, INS/N P21000076N888HFFlight1 Hsw LLC · Norwood, COBuilt 1981 · S/N P21000658N888JWRedd Brand Aviation LLC · Twin Falls, IDBuilt 1986 · S/N P21000872N888PJPatterson Edward · Midland, TXBuilt 1981 · S/N 21064244N893BWLahbak Enterprises LLC · Hilton Head Island, SCBuilt 1980 · S/N P21000498N898BHPompa Oliver · Tuscon, AZBuilt 1980 · S/N 21064108N89KPRegistered aircraftBuilt 1979 · S/N 21063501N8CCMag 3 Aviation LLC · Vidor, TXBuilt 1981 · S/N 21064437N8EYMoore Robert Russel Sr · Austin, TXBuilt 1985 · S/N P21000850N8KRQualitair LLC Trustee · MichelstadtBuilt 1981 · S/N P21000709N900AGFriedman & Friedman Ltd · Chicago, ILBuilt 1981 · S/N P21000607N9046FCenturion Aviation LLC · Lewes, DEBuilt 1979 · S/N 210-63014N9079HJoey Os LLC · Darlington, PABuilt 1979 · S/N 21063829N907JMWright Flight Inc · Tucson, AZS/N 21063665N90MJBlack Alan · Mariposa, CAS/N 21063458N90RWWallace Richard · Santa Teresa, NMBuilt 1979 · S/N 21063283N90TLColorado Aviators LLC · Gypsum, COBuilt 1979 · S/N P21000206N913SEHill Capital Leasing LLC · Phoenix, AZBuilt 1978 · S/N P21000038N920NZAltura Aviation 3-Nz LLC · Waxhaw, NCS/N P21000309N92BMNugent James S · Diamondville, WYS/N P21000557
Back to AD 98-05-14 R1