OpenAirDocs.org
AD 2004-22-13

Registered aircraft · 312

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:2004-22-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-22-13')
  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.

N613LHTop 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 51270N85AWScotts Helicopter Service · Le Sueur, MNS/N 45261N868HWeyerhaeuser Nr Co · Seattle, WABuilt 1989 · S/N 51318N86PHProvine Helicopter Service Inc · Greenwood, MSBuilt 1991 · S/N 51436N899BHNisource Corporate Services Co · Gary, INFirst renewal noticeS/N 51089N89AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45433N8BQBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 51108N902EHNorth Wind Aviation LLC · Chelan, WAS/N 45769N903BAMarks Lloyd L · Lafayette, LAS/N 45756N907RGBentley Drive LLC · Anchorage, AKBuilt 1982 · S/N 51041
Back to AD 2004-22-13