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.

N9832DNimmick Robert A · Three Forks, MTBuilt 1959 · S/N 22-6723N9832UMadison Harvey H · Lubbock, TXBuilt 1978 · S/N AA1C0140N9832WMcmillin Joey D · Edmond, OKBuilt 1967 · S/N 28-23337N98335Wiggs Billy L Jr · Fayetteville, NCBuilt 1969 · S/N 28-26174N98339Carlson Jeremy · Yucaipa, CABuilt 1968 · S/N MA297N9833QRussell Michael A · Randolph, MNBuilt 1953 · S/N 18-3358N9833VMartin Kendall L · Wills Point, TXBuilt 1974 · S/N 17264521N98345Fly Around Alaska LLC · Palmer, AKBuilt 1969 · S/N 28-26178N98348Industrial Transportation & Distr Consulting LLC · Franklin, OHBuilt 1969 · S/N 28-26179N9834CN8184h LLC · Thiensville, WIBuilt 1978 · S/N R18200454N9834GNielson Douglas W · East Troy, WIBuilt 1971 · S/N 17259734N9834LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276628N9834PScott Dale E · Ava, NYBuilt 1976 · S/N 18-7609034N9834UN9834u Owners LLC · Lakewood, COS/N AA5A0234N9834WExceptional Construction LLC · Greenacres, WABuilt 1967 · S/N 28-23340N98351Carufel Elizabeth R · Mesa, AZBuilt 1969 · S/N 28-26180N98352Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276281N98354Jin Jin Aviation LLC · Anchorage, AKBuilt 1984 · S/N 17276282N98357Mook Jerry L · Merritt Island, FLS/N 28-26185N9835GPiedmont Flight Inc · Winston Salem, NCBuilt 1971 · S/N 17259735N9835QMathis Michael Jay · Deridder, LABuilt 1954 · S/N 54-2356N98360Jts Aircraft LLC · Rock Hill, SCS/N 28-26184N98363Fala Lee A · Glendale, AZS/N 28-26187N98365Woolery Timothy A · Maryville, MOBuilt 1969 · S/N 28-26190N9836BSoulek Paul A · Spearfish, SDBuilt 1982 · S/N 172RG1051N9836CDominguez Robert R · Temecula, CABuilt 1978 · S/N R18200456N9836DBuffo Perry P · Berlin, NJBuilt 1959 · S/N 22-6727N9836GSchafhausen Mark G · Spokane, WABuilt 1971 · S/N 17259736N98371Buhrow Chris Alan · Humble, TXBuilt 1969 · S/N 28-26195N98372Harlow James Patrick · Liberty Hill, TXBuilt 1969 · S/N 28-26196N98377Sloan Allen Lee · North Augusta, SCBuilt 1969 · S/N 28-26198N98378Basta Scott C · Hayes, VABuilt 1969 · S/N 28-26199N9837DDavis Scott · Bingham, NEBuilt 1959 · S/N 22-6728N9837LIal Corp · Wilmington, DEBuilt 1986 · S/N 17276629N9837WSpeare Clifford W · Saint Charles, ILBuilt 1967 · S/N 28-23344N98380Reese Trenton · Post Falls, IDBuilt 1969 · S/N 28-26128N98383Dunn Karl L · Hazel Green, ALBuilt 1969 · S/N 28-26202N98384Macmillan Alfred R Jr · Salisbury, MDBuilt 1969 · S/N 28-26203N98388Salzwedel Timothy F · New Lisbon, WIBuilt 1969 · S/N 28-26155N98389Sale Reported · Rosenberg, TXSale reportedBuilt 1969 · S/N 28-26207N9838BJacks Charles D · Morse, LABuilt 1982 · S/N 172RG1052N9838CWellman A Ryan · San Jose, CABuilt 1978 · S/N R18200458N9838GMcdonald James E · Harleyville, SCS/N 17259738N9838HBaeder Mark A · Mesa, AZBuilt 1981 · S/N 18268059N9838QAmmon Robert L · Queensbury, NYS/N 18-3372N9838VWaypoint Equipment LLC · Mckinney, TXBuilt 1974 · S/N 17264524N9838WDutton Margaret Stephanie Executor · Mooresville, NCBuilt 1967 · S/N 28-23345N98395Dury Aviation Services Inc · De Soto, ILBuilt 1985 · S/N 17276285N9839DMason Andrew D · Russell, IABuilt 1959 · S/N 22-6730N9839GLong William F · Belton, TXBuilt 1979 · S/N 17273638
Back to AD 81-18-04 R2