OpenAirDocs.org
AD 98-15-18 R1

Registered aircraft · 1,210

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-15-18-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-15-18-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.

N563UMDelp Gregory E · Woodbury, CTBuilt 1979 · S/N 7254CN56406Blankenship Tyler D · Salisbury, NCBuilt 1980 · S/N 8013CN5640CUgalde Chester M · Fallon, NVBuilt 1980 · S/N 7321CN5640NK Top J Cattle Co LLC · Eldorado, TXBuilt 1980 · S/N 8010CN5641AGrandy Leland P · Rock Springs, WYS/N 9005CN5641KAndrews Nathan C · Vale, ORBuilt 1980 · S/N 7338CN5641LSale Reported · Pueblo, COSale reported, canceledBuilt 1980 · S/N 7344CN5641NRegistered aircraftS/N 8011CN56424Saunders Equipment Inc · Cold Spring, NYBuilt 1981 · S/N 8017CN56428Heaberlin Henry L · Corbin, KYS/N A7366CN5642MShower Michael K Jr · Wasilla, AKBuilt 1980 · S/N 7349CN5642TMark C Petersen · Sturgeon Bay, WIBuilt 1998 · S/N 21049CN5643MSandvick Randy R · Killdeer, NDFirst renewal noticeBuilt 1981 · S/N A7358CN5643NVelasquez Bailee Jude · Anchorage, AKBuilt 1981 · S/N A7361CN5643SShedd Christopher · Holly Pond, ALBuilt 1981 · S/N 7352CN5643ZMcduffie Rodney D · Cullman, ALBuilt 1981 · S/N 8019CN56442Registered aircraftBuilt 1982 · S/N 7391CN56445Sturdy Gary · Anacortes, WABuilt 1981 · S/N 7351CN56446Finch Ernest B · Anchorage, AKBuilt 1981 · S/N 7385CN56447Hutton Neil J · Wray, COBuilt 1981 · S/N 7383CN5644JLogan Craig F · Willow, AKS/N 7356CN5644MRosenbach Jay A · Chugiak, AKBuilt 1981 · S/N 7380CN5644NTerrane Exploration & Reconnaissance Co LLC · Chandler, AZBuilt 1981 · S/N 7347CN5644WHaynon Aircraft Services LLC · Palmer, AKBuilt 1980 · S/N 7350CN56454Anderson Stosh S · Kodiak, AKS/N 7388CN56455Boltman Erik C · Wasilla, AKBuilt 1981 · S/N 7389CN56458Arrowhead Outfitters LLC · Wasilla, AKBuilt 1982 · S/N 7400CN5645DFerenczy Vincent E · Anchorage, AKBuilt 1981 · S/N 7382CN56462Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1982 · S/N 7409CN56463Freegard Timothy G · Phoenix, AZBuilt 1982 · S/N 7411CN5646MMaule Flight Inc · Moultrie, GAS/N 7390CN5646NTennison Gary D · Marion, TXS/N 9010CN5646QGibbons Jack Lee · Alameda, CABuilt 1981 · S/N 7386CN56475Moertl Harald A · Anchorage, AKBuilt 1982 · S/N 7423CN5647LFrench Rollie T · Vermillion, SDBuilt 1981 · S/N 7370CN5647PKisken Bill D · Fairbanks, AKBuilt 1982 · S/N 7422CN5647SSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 7345CN5648DGuhr Robert · Stockholm, NJBuilt 1982 · S/N 7418CN5648MBrown Gary R · Eagle River, AKBuilt 1982 · S/N 7415CN5648NAlbert Daniel L · New Athens, ILBuilt 1982 · S/N 7434CN56491Registered aircraftBuilt 1982 · S/N 7399CN5649MChesnut Lonnie R · Palmer, AKBuilt 1981 · S/N 7395CN56500Bas Part Sales LLC · Greeley, COBuilt 1983 · S/N 7371CN56501Hair Heather D Trustee · Bonner, MTBuilt 1983 · S/N 8022CN5650JWaypoint LLC · Fairbanks, AKBuilt 1982 · S/N 7420CN5650PSlayton Paul · Roswell, NMBuilt 1982 · S/N 7398CN5650RWaco Air LLC · Wolfeboro, NHBuilt 1982 · S/N 7373CN5650WRwk LLC · Anchorage, AKBuilt 1981 · S/N 7381CN56515Norcross James H Jr · Homer, AKBuilt 1983 · S/N 7442CN56517Andrews Paul · Chugiak, AKBuilt 1983 · S/N 7450C
Back to AD 98-15-18 R1