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.

N9654BDonohue Andrew · Tulsa, OKBuilt 1981 · S/N 172RG0947N9654JMouton Charles J Jr · Gladewater, TXBuilt 1966 · S/N 28-3820N9654QFly Pioneer Valley LLC · Gill, MABuilt 1975 · S/N 17265738N9654URealty Investment Co Ltd · Hilo, HIBuilt 1975 · S/N AA5A-0020N9654VN9654v LLC · Lakeland, FLS/N 17264434N96558Baxter Daniel D · Lake Oswego, ORBuilt 2007 · S/N 2454N9655JDunn James Blair Jr · Bumpass, VABuilt 1966 · S/N 28-3822N9655MJarco Group LLC · Lititz, PABuilt 1967 · S/N 670111N96567Gmt Aviation LLC · Newtown, CTBuilt 1984 · S/N 17276086N9656DSpearman Clint · Scottsbluff, NEBuilt 1959 · S/N 22-6572N9656JVolpe Robert · Holiday, FLBuilt 1966 · S/N 28-3823N9656MWashington Aviation Inc · Seattle, WABuilt 1967 · S/N 670112N9656PLee Gerald R · Glennallen, AKBuilt 1974 · S/N 18-7409149N9656QMccort Daniel R · Pensacola, FLBuilt 1975 · S/N 17265740N9656RGlenn Jeff P · Billings, MTBuilt 1960 · S/N TD-331N9656ULanglois Zachary J · Deerfield, NHBuilt 1975 · S/N AA5A-0022N96573Condor Aero Club Inc · Zelienople, PABuilt 1984 · S/N 17276088N96574Baxter David C · Saint Helens, ORBuilt 2019 · S/N LS-5N96575Biryukov Ruslan B · Encino, CABuilt 1984 · S/N 17276089N96576Baxter David C · Saint Helens, ORBuilt 1989 · S/N 1332N96579Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 17276090N9657LLongobardi Vito A · Westport Island, MES/N AA1B-0157N9657PJacobsen Nathaniel · Juneau, AKBuilt 1974 · S/N 18-7409150N9657SWhite Wayne A · Scenic, SDBuilt 1966 · S/N 26N9657VChorman Spraying LLC · Milton, DEBuilt 1974 · S/N 17264437N9657WNorth Stephen P · Rochester, NYBuilt 1967 · S/N 28-23119N9658DSwann Sherrie Kim Trustee · Toledo, OHBuilt 1959 · S/N 22-6574N9658FFerguson William T · Fayetteville, TNBuilt 1971 · S/N 210090N9658KFlying Particles Inc · Livermore, CABuilt 1976 · S/N 28-7690271N9658MReames B Robert Jr · Six Lakes, MIS/N 670235N9658URegistration Pending · Spencer, NERegistration pendingBuilt 1975 · S/N AA5A-0024N9658WGraham Joel A · Marietta, GABuilt 1967 · S/N 28-23120N9659AAugust Aero LLC · Kalispell, MTBuilt 1978 · S/N 1006N9659HJd Griffin LLC · Wilmington, DEBuilt 1975 · S/N 17266296N9659KBell Michael J · Duck Key, FLBuilt 1976 · S/N 28R-7635254N9659LMoffatt Thomas · Dallas, GABuilt 1974 · S/N AA5-0659N9659QMacrafic Bruce A · Garden City, MNBuilt 1975 · S/N 17265743N9659SRandall Timothy J · Skidmore, MOBuilt 1966 · S/N 69N9659WMitchell Matthew · Ypsilanti, MIBuilt 1967 · S/N 28-23121N965AAWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282465N965ACNaples Air Center Inc · Naples, FLBuilt 1989 · S/N 2841134N965AUAuburn University · Auburn University, ALBuilt 2020 · S/N 172S12480N965BBBascom Kimber Keith · Mckinney, TXBuilt 2013 · S/N 172S11251N965CCannon Travis H II · Corinth, TXBuilt 2013 · S/N 2137N965CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281965N965CWAir Capital Aviators Club · Wichita, KSBuilt 2000 · S/N 18280769N965CZStadler Frederic L · Oshkosh, WIBuilt 2006 · S/N 5321N965EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S13013N965JRichardson Cotton Inc · Wilmington, DEBuilt 2025 · S/N 1490-2025N965JBKeevair LLC · Rockaway, NJBuilt 1997 · S/N 3246097
Back to AD 81-18-04 R2