AD 98-01-01

Registered aircraft · 1,289

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-01-01')
    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-01-01')
  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.

N172JPWnc Aviation LLC · Arden, NCBuilt 1998 · S/N 17280560N172KKIasco Flight Training Inc · Redding, CABuilt 1998 · S/N 17280574N172LKPinnacle Aviation Services Inc · Encinitas, CABuilt 1997 · S/N 17280129N172RCWings Over Texas Holdings LLC · Denton, TXBuilt 1997 · S/N 17280204N172SJCommonwealth Of Massachusetts · Bridgewater, MABuilt 1997 · S/N 17280291N172TQAvolant Aviation LLC · Mooresville, NCBuilt 1998 · S/N 17280391N172WGWings Over Texas Holdings LLC · Denton, TXBuilt 2001 · S/N 17281018N172WYCrosshares Aircraft Holdings LLC · Plymouth, INBuilt 1998 · S/N 17280334N1737STms Aviation Inc · Wilmington, DEBuilt 2000 · S/N 18280763N1747LCoco Aircraft Inc · Merritt Island, FLBuilt 2007 · S/N 17281489N174GFMarcus Air LLC · Plano, TXBuilt 1998 · S/N 17280532N178AFSoutheast Aircraft Leasing LLC · Jacksonville, FLBuilt 2003 · S/N 17281177N181MWCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1997 · S/N 17280181N1823CA&E Flying Club Of Los Angeles · Hawthorne, CABuilt 1998 · S/N 18280171N1828MCampbell Larry Lance · White Lake, MIBuilt 2000 · S/N 18280893N182ABFoyhwg Inc · Holbrook, NYS/N 18280023N182AMScavella George A Jr · Hauppauge, NYBuilt 1998 · S/N 18280116N182CKDowning Richard C · Arlington, TXBuilt 1997 · S/N 18280018N182DDGulf Coast Helicopters Inc · Pearland, TXS/N 18280063N182EERegistered aircraftBuilt 1998 · S/N 18280295N182ELElmore Donald B · Orange Beach, ALBuilt 1997 · S/N 18280009N182FNSumner Investments LLC · Denham Springs, LABuilt 1997 · S/N 18280004N182GFGormley Lane Martin · Stanwood, WAS/N 18280058N182GHTroy-Oakland Pilots Flying Club Inc · Troy, MIBuilt 1998 · S/N 18280003N182JDRegistered aircraftBuilt 2000 · S/N 18280770N182JSJohn W Spurlock Md Ltd · Bethlehem, PABuilt 1999 · S/N 18280655N182KGKeefe Patrick M · Watersmeet, MIS/N 18280020N182KHDowning Billy G · Imboden, ARBuilt 1998 · S/N 18280246N182LUTvpx Aircraft Solutions Inc Owner Trustee · North Salt Lake, UTBuilt 2000 · S/N 18280793N182PJHarris William · Bullard, TXBuilt 1998 · S/N 18280270N182SVSky-Vu Flyers Inc · Fishers, INBuilt 2001 · S/N 18280928N182TAJeppesen Employees Flying Assiciation Inc · Englewood, COS/N 18280062N182TRSalley George M · Advance, NCBuilt 1998 · S/N 18280160N182VBNemirsky Nicholas · Huntington Beach, CABuilt 1997 · S/N 18280025N182VPJobsight Delta Inc · Sugar Grove, ILBuilt 1998 · S/N 18280247N182WGBurgett Dale · Lake Lure, NCBuilt 2000 · S/N 18280831N182WMZjt Aviation LLC · Vidalia, GAS/N 18280223N182XSCamp Chris M · Marshallville, OHBuilt 2000 · S/N 18280742N182YYForrest C Cranfill Construction Co · Shallotte, NCS/N 18280340N182YZSouthern Latitude LLC · Alabaster, ALBuilt 1998 · S/N 18280198N184AFG & M Aircraft Inc · Wheat Ridge, COBuilt 2003 · S/N 17281184N184RDAfrican Parks Aviation Trustee · Cheyenne, WYBuilt 1999 · S/N 18280466N187DBSummerwind Aviation LLC · Mooresville, NCBuilt 2000 · S/N 18280922N18LWDirty Side Down Aviation LLC · Georgetown, TXBuilt 1998 · S/N 17280403N18PMNoel Michael Patrick · Poplar Grove, ILS/N 18280300N191CACsa Aircraft Leasing LLC · Salt Lake City, UTS/N 17281243N192YSanders Leonard S III · Electric City, WABuilt 2000 · S/N 18280912N197BALewis University · Romeoville, ILBuilt 1997 · S/N 17280314N198BWFixed Wing Holding Co Inc · Pembroke Pines, FLS/N 17280382N1998FSpartan Education Group LLC · Tulsa, OKBuilt 1998 · S/N 17280347
Back to AD 98-01-01