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.

N945TELebanon Flying Club Inc · Lebanon, TNBuilt 2003 · S/N 10224N945TLShirley Mae LLC · Franklin, MIBuilt 2004 · S/N 40.413N945UMd Ag Services LLC · Sterling City, TXBuilt 2005 · S/N 10763N945VKTiedemann Daniel W · Carmel, INBuilt 2001 · S/N 20118N945XPeraton Services LLC · Bozeman, MTBuilt 2016 · S/N 172S11692N94609Heavy Metal Air LLC · Farmingdale, NYBuilt 1983 · S/N 15285742N9460BEdwards Ag Service · Primghar, IABuilt 1958 · S/N 55260N9460DOlsen Marr B · Kelseyville, CABuilt 1959 · S/N 18-6810N9460JDerosa Michael D · Hewitt, TXBuilt 1966 · S/N 28-3573N9460VDodie Aviation LLC · Sheridan, WYBuilt 1970 · S/N 700038N94618Flight Trainer LLC · Wilmington, DEBuilt 2012 · S/N 172S11209N9461CClub Cherokee Inc · Crystal, MNBuilt 1978 · S/N 28-7890412N9461DDurghinescu Cris Nicolae · Rancho Mirage, CABuilt 1984 · S/N 172RG1174N9461JKobbeman Joseph B · Louisville, KYBuilt 1966 · S/N 28-3574N9461LAnthonson Ronald G · Cortland, NYBuilt 1971 · S/N AA1A-0261N9461NJames Neville & Company Inc · Ocala, FLBuilt 1969 · S/N 28R-35177N9461PErickson Jess L · Saco, MTBuilt 1975 · S/N 18-7509133N9461VZembraski Jeffrey · Nocona, TXBuilt 1970 · S/N 700056N94626New Horizons Aviation Inc · Goshen, INS/N 15285747N9462DEvans Randall Btrustee · Fallon, NVBuilt 1959 · S/N 18-6811N9462LBrake Kevin · Mars, PABuilt 1971 · S/N AA1A-0262N9462NLombardo Gene S · New Bern, NCBuilt 1969 · S/N 28R-35178N94631Flight Trainer LLC · Wilmington, DEBuilt 2012 · S/N 172S11213N9463DHarris Aircraft Leasing Co · Oklahoma City, OKBuilt 1984 · S/N 172RG1175N9463KRegistered aircraftBuilt 1976 · S/N 28-7690253N9463LFlight Trainer LLC · Wilmington, DEBuilt 2012 · S/N 172S11212N9463VHatcher Mark F · Aloha, ORBuilt 1970 · S/N 700057N9463WHassebroek Leroy A · Little Rock, IABuilt 1968 · S/N 28-11186N9464D907 Aviators LLC · Eagle River, AKBuilt 1958 · S/N 18-6707N9464JReinert Roger J · Duluth, MNS/N 28-3578N9464LLehman Logan R · Front Royal, VABuilt 1971 · S/N AA1A-0264N9464NTempleton Katherine M · Madison, WIBuilt 1969 · S/N 28R-35180N9464WHollingsworth Ronald W · Shawnee, KSBuilt 1968 · S/N 28-11187N94652Maryak Hans F · Somersworth, NHBuilt 1983 · S/N 15285752N94655Iowa Great Lakes Flyers Inc · Cheyenne, WYBuilt 1983 · S/N 15285753N94659Pavco Inc · Gig Harbor, WABuilt 1983 · S/N 15285755N9465DMehrer Fritz J · Oceanside, CAS/N 172RG1176N9465JTaylor Robert J · Woodbridge, VABuilt 1966 · S/N 28-3579N9465NStenhouse Place I LLC · Fountain Inn, SCBuilt 1969 · S/N 28R-35181N94661Fjiro Aviation N94661 LLC · Vancouver, WAFirst renewal noticeBuilt 1983 · S/N 15285756N9466DGerrard Michael K · Kaysville, UTS/N 18-6813N9466EGood Flight Aviation LLC · Stockton, CABuilt 1979 · S/N 17272272N9466JHawk Aviation Academy LLC · Saint Petersburg, FLBuilt 1966 · S/N 28-3580N9466KSpanaflight LLC · Puyallup, WABuilt 1976 · S/N 28R-7635244N9466LEastern Slope Aviation Academy · North Conway, NHS/N AA1A-0266N9466NWingert Douglas L · Smithfield, KYBuilt 1969 · S/N 28R-35182N9466PNewton Bros · Stratford, CABuilt 1973 · S/N 18-7309016N9466WDisorbo Stephen S · New Milford, CTBuilt 1968 · S/N 28-11190N9466XFlight Trainer LLC · Wilmington, DEBuilt 2012 · S/N 172S11233N9467Allen Lanny Dean · Indianapolis, INBuilt 1970 · S/N 700036
Back to AD 81-18-04 R2