AD 81-18-04 R2

Registered aircraft · 81,733

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

N8852CWobken Mark E · Orange, CABuilt 1976 · S/N 28R-7635184N8852LFederman Cecilia · Beaumont, CABuilt 1974 · S/N AA1B-0452N8852WSussex Aero Maintenance Inc · Georgetown, DEBuilt 1964 · S/N 28-10405N8852YWikle Luther M · Laceys Spring, ALBuilt 1969 · S/N 39-7N8853DSlaughter Don Wayne · Farmville, NCBuilt 1958 · S/N 22-6024N8853JN8853j LLC · Oak Park, ILBuilt 1965 · S/N 28-2817N8854CMid Continent Aircraft Corp · Hayti, MOBuilt 1953 · S/N 18-2900N8854DKidd Clifford L Jr · Monahans, TXBuilt 1958 · S/N 22-6025N8854LPfs Air Inc · Yellville, ARBuilt 1974 · S/N AA5-0654N8854WCherokee235 LLC · Kalispell, MTFirst renewal noticeBuilt 1964 · S/N 28-10408N8854YSeeds John S Jr Trustee · Tequesta, FLBuilt 1970 · S/N 39-9N88553Riggin Flight Service Inc · Madison, SDBuilt 1946 · S/N 16178N8855NIndy Distributors Inc · Noblesville, INBuilt 1969 · S/N 28-25709N8855PTja Pop Ltd · Dix Hills, NYBuilt 1965 · S/N 24-4311N8856CBritton Mark W · Wasilla, AKBuilt 1953 · S/N 18-2913N8856FRotorcraft Unlimited LLC · Brooksville, FLS/N 43-0194N8856JFifty Six Juliet LLC · West Lafayette, INS/N 28-2820N8856LRuales Edison R · Miami, FLFirst renewal noticeBuilt 1974 · S/N AA5-0656N8856NGrant Shane J · Cape Coral, FLBuilt 1969 · S/N 28-25711N8856WSouthard Brian W · Washington, OKS/N 28-10410N8857Aviation Management Systems LLC · Fallbrook, CABuilt 1973 · S/N 254-73N8857CValkenburg Toby · Anchorage, AKBuilt 1953 · S/N 18-2914N8857DHollan William E Jr · Winston Salem, NCBuilt 1958 · S/N 22-6028N8857JNguyen Tu K · Costa Mesa, CABuilt 1965 · S/N 28-2822N8857MDunn Brady · Gilmer, TXS/N M-597N8857NWolf Terry T · Lake Katrine, NYBuilt 1969 · S/N 28-25712N8857YLewis Leslie S · Glendale, AZBuilt 1970 · S/N 39-12N88587Tucker Anthony W · Brazoria, TXBuilt 1946 · S/N 16213N8858CLebron Renard Jr · Gulfport, MSBuilt 1953 · S/N 18-2922N8858JBirdie N88 LLC · Conifer, COBuilt 1965 · S/N 28-2928N8858LRedro Inc · Owatonna, MNBuilt 1974 · S/N AA1B-0358N8858WCassidy Kirk B · La Canada, CABuilt 1964 · S/N 28-10412N8859DBbc Group LLC · Sanford, NCBuilt 1958 · S/N 22-6030N8859NThrash Enterprises LLC · Clarksville, TNBuilt 1969 · S/N 28-5340N885ACWingsleasing LLC · Wichita, KSBuilt 2020 · S/N 2881396N885ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496322N885CFJulian Michael · Las Vegas, NVBuilt 2025 · S/N 140228N885EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12812N885FTFlorida Institute Of Technology · Melbourne, FLBuilt 2006 · S/N 4496225N885GTYellow Jacket Flying Club Inc · Atlanta, GABuilt 2004 · S/N 172S9601N885LHNomad Aircraft Leasing And Sales LLC · Panama City Beach, FLBuilt 2002 · S/N 1268N885SABlevins Edgar R · Zachary, LABuilt 2001 · S/N 0014N885SFSemper Fly Helicopters LLC · Edmond, OKBuilt 2009 · S/N 1008N885SMDews Robert Mark · Jefferson, TXS/N 24673N8860DCooley Tony A · Dallas, ORBuilt 1958 · S/N 22-6032N8860JBjg LLC · Langdon, NHBuilt 1965 · S/N 28-2826N8860LCrowe George J · East Ridge, TNBuilt 1974 · S/N AA1B-0360N8860WLayth Air LLC · Martin, TNBuilt 1964 · S/N 28-10414N88610Cape May Aerial Advertising LLC · Rio Grande, NJBuilt 1946 · S/N 16238N8861FMurtaza Syed S · Minneapolis, MNBuilt 1976 · S/N 28-7715292
Back to AD 81-18-04 R2