AD 2000-08-22

Registered aircraft · 433

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

N4265JRatcliff Dustin · Saltville, VABuilt 1979 · S/N 790542DN4292DUrocopters Inc · Lancaster, CAS/N 0364EN42FFBeef Aviation LLC · Bradenton, FLBuilt 1984 · S/N 0141EN43BATerrell Bill · Port Orange, FLS/N 770160DN451HAIron Horse Aviation LLC · Marshalltown, IABuilt 1979 · S/N 490484DN454JHJack Harter Helicopters Inc · Lihue, HIBuilt 1991 · S/N 0454EN457GMCentury Aviation Inc Trustee · Wilmington, DEBuilt 2010 · S/N 0603EN458HWHeliwild Investments LLC · Austin, TXBuilt 1979 · S/N 390483DN458PBBarbaro Paul G · Argyle, TXBuilt 1985 · S/N 0123EN46662Brown Helicopter Inc · Pensacola, FLBuilt 1979 · S/N 590510DN469FCFerguson And Sons Construction LLC · Emmett, IDBuilt 1980 · S/N 1100854DN46EEUnited States Department Of Agriculture · Cedar City, UTBuilt 1990 · S/N 0406EN473EOchoco Wood Products LLC · Prineville, ORBuilt 1991 · S/N 0473EN484Bhh Leasing #2 LLC · Pensacola, FLS/N 870177DN48MPPope James D · Lewiston, IDBuilt 1982 · S/N 1137DN499SLHlh Leasing LLC · Wilmington, DEBuilt 1979 · S/N 190448DN49WKRail N LLC · Oracle, AZBuilt 1981 · S/N 611006DN500ARHelicopter Roundup Service LLC · Nephi, UTS/N 0149EN500BHAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1998 · S/N 0537EN500DCHva Holdings LLC · Gettysburg, PABuilt 1978 · S/N 290456DN500EKKar Aviation LLC · Saltville, VABuilt 1979 · S/N 1190610DN500EVSnohomish County Sheriff · Snohomish, WABuilt 1989 · S/N 0340EN500FCFerguson And Sons Construction LLC · Emmett, IDBuilt 1983 · S/N 0442EN500FFRegistered aircraftN-number assigned (import), not yet registeredS/N 1270251DN500GKN969md Inc · Middletown, DES/N 911074-DN500HJ392e Inc Trustee · Wilmington, DEBuilt 1990 · S/N 0392EN500HWHeliwild Investments LLC · Austin, TXBuilt 1978 · S/N 480294DN500KYRotor Imaging LLC · Reading, PABuilt 1989 · S/N 0345EN500LKWinco Inc · Aurora, ORBuilt 1983 · S/N 0009EN500MUHva Inc · Summersville, WVBuilt 1996 · S/N 0533EN500MVTreeline Helicopters Inc · Bristol, TNBuilt 1977 · S/N 770156DN500NCSanders Associates LLC · Bluefield, VABuilt 1977 · S/N 1260052DN500PHPrecision Heli-Support LLC · Mesa, AZS/N 0187EN500RMHawkeye Helicopter LLC · Lyndon, KSS/N 0119EN500SLPatriot Marine LLC · New Haven, CTBuilt 1988 · S/N 0309EN500SYNalas Inc Trustee · Wilmington, DEBuilt 1983 · S/N 0007EN500TNOnespan Powerline Services LLC · Peachtree City, GABuilt 1979 · S/N 590521DN500TYSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1984 · S/N 0086EN500TZGulf Helicopters LLC · Santa Fe, TXBuilt 1979 · S/N 590507DN500VSVertol Systems Company Inc · Destin, FLBuilt 1977 · S/N 170072DN500WXTre Aviation Corp · Wilmington, DEBuilt 1992 · S/N 0493EN500XVSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 1200881DN501EFAirwest Helicopters Inc · Redlands, CABuilt 1977 · S/N 270091DN501HPHonolulu Police Department · Honolulu, HIBuilt 2009 · S/N 0593EN501MDAgricultural Air Services LLC · Jupiter, FLBuilt 1991 · S/N 0485EN501RMCity Of Pasadena · Pasadena, CABuilt 2009 · S/N 0598EN501VSVertol Systems Co Inc · Destin, FLBuilt 1977 · S/N 170050DN5027PBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 611002DN502CHVertol Systems Co Inc · Destin, FLFirst renewal noticeBuilt 1978 · S/N 180252DN502HBActive Aviation LLC · Newark, DEBuilt 1978 · S/N 480291D
Back to AD 2000-08-22