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.

N722SBWoodward James W · Sagle, IDBuilt 1989 · S/N 7499CN7235Hale Edward S Jr · Brawley, CABuilt 2001 · S/N 18061CN7235AValiair Limited Co Trustee · Casper, WYBuilt 2026 · S/N 24002CN723CJNicholson Scott V · Kalamazoo, MIS/N 20011CN723MRaber Micah D · Wasilla, AKS/N 23003CN725JKAlkay Flight LLC · Lewes, DEBuilt 1988 · S/N 7480CN725YPMilton John L · Heathsville, VABuilt 2000 · S/N 25064CN728JWMagnusson Dwayne · Anchorage, AKBuilt 2003 · S/N 23075CN730MWWardlaw Mack · Sonora, TXBuilt 1990 · S/N 4092CN734JReynolds John C · Macon, GABuilt 2006 · S/N 23091CN737WBFour M Aviation LLC · Clinton, CTBuilt 1977 · S/N 7108CN7424Stansbury Tracy E · The Dalles, ORBuilt 2006 · S/N 14119CN743KTWilson Jeffrey S · Grass Valley, CABuilt 2002 · S/N 18056CN745JMPlane Fun LLC · Garretson, SDBuilt 2001 · S/N 25071CN747DGPetereit David F · Sterling, AKBuilt 1982 · S/N 7419CN74YWBresette Matt T · Gretna, NEBuilt 1974 · S/N 6044CN755MMDewberry Danny · Olivet, MIBuilt 1976 · S/N 6160CN75VXSandberg Tobias · Anchorage, AKBuilt 1993 · S/N 4021CN7602AAlbers Julie H · Burlington Flats, NYS/N 1023N760JMTibbetts Harrison J · Santa Rosa, CAS/N 19007CN7613XCampbell Michael W · Fayetteville, TNBuilt 1988 · S/N 7498CN770ASTyrrells Trails LLC · Fairbanks, AKBuilt 1984 · S/N 4017CN770XRArrowhead Outfitters LLC · Wasilla, AKS/N 23057CN772TWBugden Michael S · Newnan, GAS/N 21075CN773BCGwennhadu Air LLC · Wilmington, DES/N 18012CN773MCAlexy Kenneth J · Washington, MIS/N 11019CN775RGSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 6048CN776FFTaylor Bruce J · Anthem, AZBuilt 2003 · S/N 18080CN779ZGiarratana Stephen J · Clinton, MSBuilt 2008 · S/N 14126CN781DCO'Nan Harry A · Mooresville, NCBuilt 1999 · S/N 25041CN787GWRegent Trust Corp Trustee · Wichita, KSBuilt 2004 · S/N 25101CN788WTFletcher Joseph E · Enid, OKBuilt 1999 · S/N 25036CN790PRMoody William J · Port Angeles, WABuilt 1988 · S/N 7494CN797GAdvanced Global Services Inc · Vero Beach, FLBuilt 2005 · S/N 18090CN799ZBeckley Michael J · Brookings, ORBuilt 2008 · S/N 22024CN79HSHenderson State University · Arkadelphia, ARBuilt 1998 · S/N 17006CN79VEIsocelestian Concepts LLC · Pelzer, SCBuilt 2023 · S/N 25118CN7UELowery Land Company LLC · Amagon, ARBuilt 1988 · S/N 4061CN7ZVBritton Mark W · Wasilla, AKS/N 20018CN800CPSpot-Air LLC · Burlington, TXS/N 14058CN8070Farrington Andrew J · Shelton, WABuilt 1985 · S/N 8070CN8074WDevens Frederick G · Sussex, NJBuilt 1974 · S/N 6012CN808CJHalle Warren M · Rapid City, SDBuilt 1985 · S/N 10008CN811SGDodson International Parts Inc · Rantoul, KSBuilt 2008 · S/N 18105CN812RRAstraeus LLC · Greenport, NYBuilt 2004 · S/N 25100CN8143BBeauchamp Joshua Kane · Denton, NCBuilt 2006 · S/N 14113CN815KTFrase Kenneth E · Fall Creek, WIBuilt 1993 · S/N 19009CN817YLandon William Walton IV · Fairbanks, AKS/N 8085-CN820WWPilotmaster 73 LLC · Eagle River, AKBuilt 1978 · S/N 7224CN824GPShasta Trinity Aviation Group LLC · Mccall, IDBuilt 2006 · S/N 18093C
Back to AD 98-15-18 R1