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.

N51578Middle Tennessee State University · Murfreesboro, TNBuilt 1974 · S/N 6020CN51579Whyley Philip C · Encinitas, CABuilt 1974 · S/N 6032CN51585Hanan Roy T · Edgewater, FLS/N 10040CN51587Werner Platte River Crossings Lp · Douglas, WYS/N 5006CN51592Merrell Jared · Wasilla, AKS/N 6023CN51598Morgan Christopher D · Ogden, UTBuilt 1974 · S/N 6038CN515AKHigh Mark Aviation LLC · Enid, OKBuilt 1999 · S/N 23059CN51602Krebs Martin C · Miami, FLBuilt 1974 · S/N 5013CN51619Isabella Ralph N · Delanson, NYBuilt 1974 · S/N 5009CN51620Bork Joseph L · Mosier, ORS/N 5012CN51621Johnson Lucas G · Pleasant Lake, MIBuilt 1974 · S/N 5014CN51626Silvey Brandon · Cascade, IDBuilt 1974 · S/N 5015CN51629Phillips Aaron W · Fort Scott, KSS/N 5017CN51631Noguess James E · Deming, NMBuilt 1974 · S/N 6043CN51632Mcguire Dennis B · Howell, MIBuilt 1974 · S/N 6029CN51635Kovaleski Thomas J · Chugiak, AKBuilt 1974 · S/N 5025CN51636Rulewicz Dennis G · Jackson, MIBuilt 1974 · S/N 6045CN51638Janczak Gillian · Golden Valley, AZS/N 5027CN51647Feuerborn Ethan T · Boise, IDS/N 5031CN51648Esh Christopher J · Girdwood, AKBuilt 1974 · S/N 5032CN51655Clear Blue Marketing Inc · Reno, NVBuilt 1974 · S/N 5039CN518THBelairplane LLC · Bel Aire, KSS/N 18020CN52TGBarbosa David J · Caribou, MES/N 2126CN531SBEmanuel Francis J · North Bend, NEBuilt 2009 · S/N 25111CN531WSBeale Joseph E · Stuart, FLBuilt 2008 · S/N 25107CN535TKSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 14025CN540BVYoder Land & Cattle · Dalhart, TXS/N 23078CN540JCFedorko Daniel J · Saylorsburg, PABuilt 1963 · S/N 33N54328Schwabland Peter A · Lake Forest Park, WAS/N 25095CN547XMoyle Dean E DBA · Filer, IDBuilt 1976 · S/N 7008CN54HSHenderson State University · Arkadelphia, ARBuilt 1998 · S/N 17004CN54MJNychka Robert James Paul · Wills Point, TXBuilt 1998 · S/N 18034CN5500KMcintyre Ian C · Pace, FLBuilt 2001 · S/N 18079CN5503LAnderson Firearms LLC · Montgomery, TXBuilt 1999 · S/N 25040CN5503XGreat Bear Outfitters LLC · Kalispell, MTBuilt 2002 · S/N 14107CN5505BPickard Martin D · High Springs, FLS/N 22020CN5510ZYellow Maule LLC · Wilmington, DES/N 23083CN5511ABuller Paul W · Laguna Hills, CABuilt 2002 · S/N 23076CN5512CGayle William G · Harpersville, ALBuilt 2001 · S/N 18076CN5515LDoody Michael C · Knoxville, TNBuilt 2003 · S/N 18060CN5517ZTravnicek Sandy R · Bowie, TXBuilt 2002 · S/N 25085CN5518MHickey Michael J · Honey Grove, TXS/N 21085CN5518ZJohnson Russell L · Boise, IDS/N 14117CN5519CKukeeza LLC · Williston, NDBuilt 2001 · S/N 14105CN5519GBalkema Jeff · Scotts, MIBuilt 2005 · S/N 23090CN5519YTonks Nick · Driggs, IDS/N 18055CN555AQFreeman Michael D · Morgantown, INS/N 7027CN55LETimmreck Joseph P · Anchorage, AKBuilt 1974 · S/N 5004CN55RWCauvin John R H · Carefree, AZS/N 25034CN55TGPrzyborowski James J · Colchester, CTBuilt 1981 · S/N 7375C
Back to AD 98-15-18 R1