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.

N123SPMain Wesley Jake · Kenai, AKBuilt 1991 · S/N 11083CN123VAKarinen Joel J · Anchorage, AKS/N 19041CN124CHSpearhead Aviation Inc · Parker, COS/N 2001CN125ABTkc Aviation LLC · York, SCBuilt 2000 · S/N 14102CN125HSHenderson State University · Arkadelphia, ARBuilt 2007 · S/N 21093CN126CMSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2003 · S/N 25094CN126DPGuedon Air LLC · Natchez, MSS/N 25004CN1275VCarney George R · Apple Valley, CAS/N 25062CN127CPHatfield David E Trustee · Bangs, TXBuilt 2001 · S/N 18065CN128CPMaule Flight Inc · Moultrie, GAS/N 18066CN128DHMorris Thomas E · Orlando, FLBuilt 1998 · S/N 18040CN129CPUpright Aviation LLC · Helena, MTBuilt 2001 · S/N 18067CN12BEElliott Russell R · Wasilla, AKS/N 7082CN12LPBlewett John Thomas Jr · Springfield, GABuilt 1998 · S/N 21056CN12PGGrimes Richard J · Greenville, MIBuilt 1996 · S/N 20057CN12VRCulver Lane M · Laceys Spring, ALBuilt 1988 · S/N 10058CN1300PHerzog Gregory L · Star, IDBuilt 2001 · S/N 18068CN131CPFlorida Seaplanes LLC · Altamonte Springs, FLBuilt 2001 · S/N 18069CN131PHMori Glenn E · West Ossipee, NHS/N 20014CN134CPHoughton Lewis · Waxhaw, NCBuilt 2002 · S/N 18070CN136CPMaule Flight Inc · Moultrie, GABuilt 2002 · S/N 18071CN136HSHenderson State University · Arkadelphia, ARBuilt 2007 · S/N 21094CN138CPPlumstead Lawrence · Seminole, FLS/N 18072CN139CPLai LLC · Pearl, MSS/N 18073CN13PZCroft Jordan · Rosamond, CABuilt 1994 · S/N 20002CN13ZF13zf LLC · Bend, ORBuilt 1987 · S/N 10051CN141AREpp Robert Jackson · New Kent, VAS/N 8060CN141DFNaumann Reuben D · Blackwell, MOS/N 19011CN141WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 4036CN142BESugar Pop Group LLC · Saco, MEBuilt 2001 · S/N 14103CN142CPMasters Michael David · Blue Ridge, GAS/N 18075CN143BHTappan Holdings Inc · Cadiz, OHS/N 21003CN143JDHarris Steven V · Springtown, TXS/N 8083CN143SDWhiskey Fox Group LLC · Destin, FLS/N 25005CN1474Loon Mountain Aviation LLC · Mccall, IDBuilt 1995 · S/N 23013CN147WMSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1995 · S/N 19044CN148DPHenke Kristen C · Bettendorf, IAS/N 11015CN14HFSkopek Darin A · River Falls, WIBuilt 2003 · S/N 18084CN14LMFeuerborn Ethan · Boise, IDBuilt 1976 · S/N 70-40CN152HSHenderson State University · Arkadelphia, ARBuilt 2007 · S/N 21095CN155BHRyan John P · Kankakee, ILS/N 8087CN156DSFanoe Nicholas J · Salinas, CABuilt 2000 · S/N 23064CN159JDDorrance John Charles Jr · Randle, WABuilt 1987 · S/N 4042CN15CKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1985 · S/N 10012CN15SNRobinson Brian · Bedford, NHBuilt 2001 · S/N 25074CN164BMMachtemes Brian A · Minnetonka, MNBuilt 1972 · S/N 2114CN1653AFarmah Aviation LLC · Cary, NCBuilt 2007 · S/N 14121CN166LMFlight Rt LLC · Thonotosassa, FLS/N 4063CN166RWGrasshopper Aviation LLC · Betsy Layne, KYBuilt 1984 · S/N 8041-CN169WWPro Aire Inc · Chisago City, MNBuilt 1967 · S/N 1057C
Back to AD 98-15-18 R1