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.

N40656Fairly Dustin L · Fairbury, NES/N 2170CN40657Frickel Thomas L · Bristow, NEBuilt 1973 · S/N 2172CN40661Barkay Ido M · Anchorage, AKBuilt 1973 · S/N 2173CN40667Nelson Bradley C · Williston, NDBuilt 1973 · S/N 1081CN40669Copp Perry T · Adin, CABuilt 1973 · S/N 2177CN40674Miller Sean C · New Carlisle, OHBuilt 1973 · S/N 2179CN40676Farrell Tammy Jean · Sterling, AKS/N 2180CN40677Merrell Jared · Wasilla, AKS/N 2181CN40684Johnson Jeff · Wasilla, AKBuilt 1973 · S/N 1083CN40686Bentley Aviation Services LLC · Lewes, DEBuilt 1973 · S/N 1084CN40689Combs Christopher G · Durham, CABuilt 1973 · S/N 1085CN40692Rocky Mountain Distributing LLC · Buffalo, MTS/N 1088CN40694Yeager And Co Inc · Boulder, COBuilt 1973 · S/N 2184CN407XCallahan Ashton G · Homer, AKS/N 7041CN40807Hamilton Richard M Trustee · Willow, AKS/N 2076CN4089CBork Joseph L · Mosier, ORS/N 15N408XQuint Jeane E · Janesville, WIS/N 6184CN409XDunn Blake · Bristol, COBuilt 1976 · S/N 7043CN40KMFlight Tech LLC · Prosser, WABuilt 2000 · S/N 23063CN40PXHealey David A · Hammondsport, NYBuilt 2003 · S/N 14110CN410TXSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1995 · S/N 22007CN411CBOsky Deuce LLC · Saguache, COBuilt 1968 · S/N 2037CN412EPMasters Mission · Nenana, AKBuilt 2003 · S/N 23073CN4130CSwift Stephen V · Redding, CAS/N 4N413JSClearwake Inc · Kaysville, UTBuilt 1984 · S/N 8042-CN4140CAllen Ira R · Tallahassee, FLS/N 6N4140PRenda Gregory L · Saratoga, CABuilt 1999 · S/N 21064CN414UTRoth Colin E · Anchorage, AKBuilt 1982 · S/N 7408CN41510Clemente Motor Inc · Wilmington, DEBuilt 1999 · S/N 34001CN4157ASpina Frank S · Long Beach, CABuilt 1999 · S/N 21061CN4159CPerkins Kenneth D II · Eagle River, AKBuilt 1962 · S/N 9N4159KRegistered aircraftBuilt 1998 · S/N 22015CN4170CDemientieff Oscar · Anchorage, AKS/N 11N417XMiller Christopher A · Broomfield, COBuilt 1976 · S/N 7047CN4180CMckenney Bret · Billings, MTBuilt 1962 · S/N 12N418KMMassimini Sebastian Vince · Arlington, VABuilt 2002 · S/N 25075CN418XMerrell Robert H · Farmington, NHBuilt 1976 · S/N 7042CN4198RTaf Aerial Services LLC · Beeville, TXBuilt 1999 · S/N 14096CN419XBellamy William J · Duluth, MNBuilt 1976 · S/N 7048CN41VZCarver Co LLC · Chugiak, AKBuilt 1976 · S/N 7026CN420CDBritton Mark W · Wasilla, AKS/N 10064CN420KBPierson Bradley A · Anchor Point, AKS/N 6097CN4220GVoorhies Danny L · Albertville, ALBuilt 1999 · S/N 21068CN42269Gabel Paul D · Canyon, TXS/N 18047CN422NPGarvin Honi J Trustee · Monument, COBuilt 2007 · S/N 23103CN4235RWustman Charles Dryer · Westerly, RIBuilt 1999 · S/N 25033CN4239WSmith James W · Newtown, CTS/N 21079CN4244LRaser Gary · Birdsboro, PABuilt 2002 · S/N 25079CN4244YSalvucci Patsy J · Anchorage, AKBuilt 1998 · S/N 23045CN4245RR J Aviators LLC · Dover, DEBuilt 2001 · S/N 25061C
Back to AD 98-15-18 R1