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.

N774CPCivil Air Patrol · Montgomery, ALBuilt 2010 · S/N 18282257N774DSRosebud LLC · Libertyville, ILBuilt 2011 · S/N 71087N774GHarmon Larry · Springfield, OHS/N 001N774GAAircraft Resource Center Inc · Lakeville, MNBuilt 1978 · S/N GA7-0061N774HAExtreme Helicopter Service LLC · Alice, TXBuilt 1989 · S/N 1084N774JBJb Air LLC · Oakwood, GABuilt 2004 · S/N 1365-2004N774JCUS Department Of The Interior · Boise, IDBuilt 2014 · S/N CC18-0066N774LAJaguar Aviation LLC · Hillsboro, ORBuilt 2024 · S/N 172S13117N774LLLedet Corp · Houma, LABuilt 2003 · S/N 3246213N774LRCampbell Jeffrey R · Surprise, AZBuilt 1974 · S/N 28R-7435297N774LSDroge John W · Sisters, ORBuilt 1977 · S/N 32-7840004N774MGPs Aviation Inc · Jackson, MNS/N 17269250N774NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881042N774PCHarrell Brian · Auburn, ALBuilt 1973 · S/N 28-7405018N774PDTump Christopher · Hartland, WIBuilt 1968 · S/N 17701281N774PKHcb Media LLC · Los Angeles, CABuilt 2011 · S/N 007N774PMAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1977 · S/N 1-0055N774RPDanny Buys LLC · San Antonio, TXBuilt 2000 · S/N 25205N774RVSlutz Gary J DBA · Beach City, OHS/N 2047N774TMVan Bortel Aircraft Inc · Arlington, TXBuilt 2019 · S/N 18283088N7750DCarruthers Matthew L · Charlotte Hall, MDBuilt 1957 · S/N 22-5430N7750GVitt Edward J · Sewell, NJBuilt 1970 · S/N 17259450N7750MDoran Jeffrey · Westerville, OHBuilt 1974 · S/N 22-0016N7750PLeonardi Aldo · Woodland, CAS/N 24-2775N7750YWelden Charles R · Hoover, ALFirst renewal noticeBuilt 1965 · S/N 30-853N7751MM&M Aircraft LLC · Arnold, MOS/N 20-0013N7751PGulf South Aero LLC · Raymond, MSBuilt 1961 · S/N 24-2965N7751VGoodman Matthew R · Kenly, NCBuilt 1976 · S/N 177RG0909N7751WSmith Derek D · Portland, ORS/N 28-1719N7752MSteen Robert Z · Billings, MTBuilt 1974 · S/N 21-0028N7752NCote Daniel A · Montpelier, VTS/N 28-5197N7752WCavender John S · Centerville, MDBuilt 1964 · S/N 28-1728N7753GCw Enterprise LLC · Jewell Ridge, VABuilt 1970 · S/N 17259453N7753HMarvin Carlton R · Tomahawk, WIBuilt 1946 · S/N 12-651N7753MHangarone Air Services LLC · Los Altos, CAFirst renewal noticeBuilt 1974 · S/N 22-0017N7753NSonner Michael J · Golden, COBuilt 1968 · S/N 28-5198N7753PDarr Jacob L · Trinity, NCBuilt 1962 · S/N 24-2967N7753WNortheastern Oregon Flying Club Inc · La Grande, ORBuilt 1964 · S/N 28-1758N7753ZSt Louis Soaring Association Inc · Saint Louis, MOS/N 25-3936N7754GRegistration Pending · Sioux Falls, SDRegistration pendingBuilt 1970 · S/N 17259454N7754HLa Paloma LLC · Bozeman, MTBuilt 1946 · S/N 12-652N7754KKoch Paul D · Morgan Hill, CABuilt 1951 · S/N 20582N7754NSan Juan Flyers Inc · Pagosa Springs, COBuilt 1968 · S/N 28-5201N7754PMagner Air LLC · Leesburg, VABuilt 1961 · S/N 242969N7754VVos Jonathan R · Monee, ILBuilt 2018 · S/N 002N7754WMartin Travis James · Gladewater, TXBuilt 1964 · S/N 28-1772N7755DWellborn Ralph Lee · Kenai, AKBuilt 1957 · S/N 22-5436N7755GSagori Aviation LLC · Orlando, FLBuilt 1970 · S/N 17259455N7755HGoos Lynn · Aguila, AZFirst renewal noticeBuilt 1946 · S/N 12-653N7755PBubak Land And Cattle LLC · Imperial, NEBuilt 1961 · S/N 24-2971
Back to AD 81-18-04 R2