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.

N571LFRegistered aircraftBuilt 2003 · S/N 478-2003N571MCThompson Gary R · Discovery Bay, CABuilt 2001 · S/N 18281038N571MDLemoine Julius D · Dahlonega, GABuilt 1975 · S/N 28-7625031N571MMMoment Stv L · Urbana, ILBuilt 2008 · S/N 06118N571MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2004 · S/N 40.396N571NDVertol Systems Co Inc · Destin, FLBuilt 2009 · S/N 172S10853N571PUPurdue University Trustees · West Lafayette, INBuilt 2002 · S/N 4496142N571RVKranz Monte L · Eagle Butte, SDBuilt 2005 · S/N 571N571SARegistration Pending · Azle, TXRegistration pendingBuilt 2005 · S/N 1009-2005N571SPChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 172S8496N571TCPardue Troy W · Downsville, LABuilt 2006 · S/N 20608271N571TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881871N571WCJewell Scott M · Willow, AKBuilt 2004 · S/N 10560N5720EInstall Pro Construction LLC · Henderson, NVBuilt 1978 · S/N 17271926N5720FHander Robert · Liberty Lake, WABuilt 1968 · S/N 28-24933N5720LKh Aircraft LLC · Denton, MTBuilt 1969 · S/N AA1-0120N5720PPatterman Emil S · Fort Worth, TXS/N 24-794N5720UHone Jason B · Carnation, WAS/N 28-26520N5720WThird Step 2 LLC · Gilbert, AZBuilt 1963 · S/N 28-1231N5720ZIrvine Hollis E Jr · Greenwich, NJBuilt 1963 · S/N 22-9559N5721LBerggren Ryan J · Newton, NJBuilt 1969 · S/N AA1-0121N5721QRawski Aviation LLC · Kingwood, TXBuilt 1965 · S/N 764N5721WPrecise William C Jr · Philadelphia, PABuilt 1963 · S/N 28-1247N5722FChrabasz Frank L · Arlington, TXBuilt 1968 · S/N 28-25023N5722PCrazy 8 Aviation LLC · Ridgecrest, CABuilt 1959 · S/N 24-796N5722QMyers Shawn · Louisville, KYBuilt 1965 · S/N 3063N5722UPfeifer Eric P · Hill City, KSS/N 28-26524N5723FOdyssia LLC · Corpus Christi, TXS/N 28-25024N5723HValiair Lc Trustee · Casper, WYBuilt 1949 · S/N 16-334N5723LPearlman Fredric M · Southfield, MIS/N AA1-0123N5723WWells Chad · Draper, UTBuilt 1963 · S/N 28-1281N5724FKim Sungtae · Fort Worth, TXFirst renewal noticeBuilt 1968 · S/N 28-25025N5724HPhillips Thomas D · San Antonio, TXBuilt 1949 · S/N 16-336N5724JPurdue Aviation LLC · West Lafayette, INBuilt 1980 · S/N 17273827N5724ZKpa LLC · Kalamazoo, MIS/N 22-9563N57252Mooney Flyers LLC · Crystal Lake, ILBuilt 1984 · S/N 24-1433N57259Trantham Joey L · Panama City, FLBuilt 1984 · S/N 24-1435N5725HPeterson Gordon L · De Pere, WIBuilt 1949 · S/N 16-337N5725PJason Waddell Pllc · Oklahoma City, OKBuilt 1959 · S/N 24-799N5725QBaughman Air Service Inc · Stockton, KSBuilt 1965 · S/N 721N5725ZHolt Gary E · Sandusky, OHBuilt 1963 · S/N 22-9564N57267Devine Robert · Albuquerque, NMBuilt 1984 · S/N 24-1436N5726QAllen Colin S · Leonardtown, MDBuilt 1965 · S/N 3065N5727EZeitvogel Jeanine · Gulf Shores, ALBuilt 1978 · S/N 17271928N5727FJones Brian W · Portland, ORBuilt 1968 · S/N 28-25028N57280Conklin Michael L · Grand Blanc, MIBuilt 1984 · S/N 24-1438N57283Collins James L · Bradenton, FLBuilt 1984 · S/N 24-1439N5728HBell Jeff J · Merritt Island, FLFirst renewal noticeS/N 16-340N5728PElite Aviation LLC · Grants Pass, ORBuilt 1959 · S/N 24-802N5728QKuss Luke A · Hutto, TXBuilt 1965 · S/N 3066
Back to AD 81-18-04 R2