OpenAirDocs.org
AD 96-18-05 R1

Registered aircraft · 318

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:96-18-05-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:96-18-05-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.

N59CHAir Center Helicopters Inc · Burleson, TXS/N 45284N601GMNorth Wind Aviation LLC · Cottage Grove, ORBuilt 1981 · S/N 45638N601SJAg Air Inc · Longmont, COBuilt 1985 · S/N 51128N60VGFarwest Aviation LLC · Billings, MTBuilt 1991 · S/N 51494N6133CRedlands Heli Flight LLC · Redlands, CABuilt 1991 · S/N 51544N613LHTop Flight Aviation Of Mississippi LLC · Picayune, MSBuilt 1992 · S/N 51594N6160YGm Leasing Co LLC · Broussard, LABuilt 1992 · S/N 51609N619Air Flite Inc · Shawnee, OKBuilt 1980 · S/N 45393N620LHNorth Wind Aviation LLC · Cottage Grove, ORBuilt 1991 · S/N 51461N623QJb Air Services LLC · Brighton, COBuilt 1988 · S/N 51258N626United States Department Of Interior · Boise, IDBuilt 1985 · S/N 51139N629LSShook Farms LLC · Milan, MIBuilt 1984 · S/N 51077N63AEAir Evac Ems Inc · O Fallon, MOS/N 45499N641HAHelicopter Applicators Inc · Gettysburg, PABuilt 1991 · S/N 51444N64FCZma LLC · North Little Rock, ARBuilt 1981 · S/N 45539N6501SInternational Air Services Inc Trustee · Carson City, NVBuilt 1990 · S/N 51395N651HAHelicopter Applicators Inc · Gettysburg, PABuilt 1986 · S/N 51185N6533UTop Flight Aviation Of Mississippi LLC · Picayune, MSBuilt 1991 · S/N 51439N6603XAerial Applicators Of Missouri LLC · Jonesboro, ARBuilt 1990 · S/N 51412N660HAHelicopter Applicators Inc · Gettysburg, PABuilt 1979 · S/N 45219N6651HR & R Conner Aviation LLC · Conner, MTBuilt 1979 · S/N 45211N66RRRiggs Rock Alan · Lake Mary, FLBuilt 1979 · S/N 45278N67SJSan Juan Aviation LLC · Wilmington, DES/N 51098N68AEAir Evac Ems Inc · O Fallon, MOBuilt 1981 · S/N 45647N70606Registration Pending · Rome, NYRegistration pendingBuilt 1989 · S/N 51282N711TTFaithful Flyers LLC · Lakeside, CABuilt 1991 · S/N 51433N712MScotts Helicopter Service Inc · Le Sueur, MNBuilt 1983 · S/N 51072N7159HPremier Rotors LLC · Saint Martinville, LABuilt 1990 · S/N 51397N71JJInterstate Helicopters Inc · Bethany, OKBuilt 1989 · S/N 51329N720BGentem Inc Trustee · Wilmington, DEBuilt 1980 · S/N 45452N726HGm Leasing Company LLC · Broussard, LABuilt 1992 · S/N 51548N749FFHunt-Lo Farms LLC · Chesterland, OHBuilt 1983 · S/N 45773N76DCAdvanced Trucking LLC · Kalispell, MTBuilt 1980 · S/N 45471N777EMAlaskan Wings LLC · Anchorage, AKBuilt 1983 · S/N 45767N790RBRight Brother Aviation LLC · Rome, NYBuilt 1988 · S/N 51248N7978KMowata Farms LLC · Mamou, LABuilt 1982 · S/N 45492N79AEAvid Aviation Group Inc · Jupiter, FLBuilt 1980 · S/N 45436N79LRHeger Scott · Scappoose, ORBuilt 1979 · S/N 45200N79TMAbove & Beyond Aviation Inc · Anchorage, AKBuilt 1991 · S/N 51472N79TVBank Of Utah Trustee · Salt Lake City, UTBuilt 1982 · S/N 45718N7DQMinnesota Helicopters Inc · Blaine, MNBuilt 1981 · S/N 45685N801CLAv8-Orr Helicopter Services Inc · Hamilton, MTBuilt 1979 · S/N 45354N808HLRegistered aircraftN-number assigned, not yet registeredS/N 51581N828WPBas Part Sales LLC · Greeley, COBuilt 1979 · S/N 45294N83AEAir Evac Ems Inc · O Fallon, MOS/N 45272N852SSAg Air Inc · Johnstown, COS/N 51270N853SSTippmann Choppers LLC · Fort Wayne, INBuilt 1980 · S/N 45584N85AWScotts Helicopter Service · Le Sueur, MNS/N 45261N868HWeyerhaeuser Nr Co · Seattle, WABuilt 1989 · S/N 51318N86PHProvine Helicopter Service Inc · Greenwood, MSBuilt 1991 · S/N 51436
Back to AD 96-18-05 R1