OpenAirDocs.org
AD 84-01-02 R1

Registered aircraft · 498

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:84-01-02-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:84-01-02-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.

N458HWHeliwild 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 0406EN47267Mckee John R · Central Point, ORBuilt 1969 · S/N 68-17267N473EOchoco Wood Products LLC · Prineville, ORBuilt 1991 · S/N 0473EN478NWTmds Air Inc · Gig Harbor, WABuilt 1973 · S/N 530478SN484Bhh Leasing #2 LLC · Pensacola, FLS/N 870177DN488NSSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N 450738SN48MPPope James D · Lewiston, IDBuilt 1982 · S/N 1137DN499SLHlh Leasing LLC · Wilmington, DEBuilt 1979 · S/N 190448DN49TJShoreline Aircraft Leasing LLC · Lewes, DEBuilt 1975 · S/N 550747SN49WKRail N LLC · Oracle, AZBuilt 1981 · S/N 611006DN500ARHelicopter Roundup Service LLC · Nephi, UTS/N 0149EN500BHAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1998 · S/N 0537EN500CVParadise Air LLC · White City, ORS/N 240561SN500DCHva 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 0119EN500RTCessna 210 LLC · Waynesville, MOBuilt 1976 · S/N 1050773SN500SLPatriot 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 170072DN500VZSea Corp Helicopters Inc · Wilmington, DEBuilt 1975 · S/N 450735SN500WBSearok Aviation LLC · Pierson, FLS/N 1000269SN500WXTre 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, FLBuilt 1978 · S/N 180252D
Back to AD 84-01-02 R1