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.

N563VWRichen Owyn · Seattle, WABuilt 1968 · S/N 32-1029N563WSSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 995-2005N563WWJimenez Daniel L · Goodyear, AZBuilt 2013 · S/N 82390N56404Mark Lindstrom · Fort Worth, TXBuilt 1973 · S/N 287305586N56406Blankenship Tyler D · Salisbury, NCBuilt 1980 · S/N 8013CN5640EHunt Jacky R · Bowling Green, KYBuilt 1978 · S/N 17271909N5640HMitchell Zachary · Franklin, NHBuilt 1949 · S/N 16-251N5640NK Top J Cattle Co LLC · Eldorado, TXBuilt 1980 · S/N 8010CN5640QProps To You LLC · Mount Pleasant, SCBuilt 1965 · S/N 676N5640UJustfly Inc · Houston, TXBuilt 1969 · S/N 28-26436N56410Ehrler Andrew N · Flushing, NYS/N 28R-7335433N56413Hupert Jason M · Grand Blanc, MIBuilt 1973 · S/N 34-7350329N56414Gordon David P · Truckee, CABuilt 1973 · S/N 287305588N56418Shepler John E · Mobile, ALBuilt 1973 · S/N 28R7335434N5641AGrandy Leland P · Rock Springs, WYS/N 9005CN5641KAndrews Nathan C · Vale, ORBuilt 1980 · S/N 7338CN5641LSale Reported · Pueblo, COSale reported, canceledBuilt 1980 · S/N 7344CN5641VFlight Leasing Corp · Wilmington, DES/N 28-7716188N5641WThibodeau Tom M · Kenai, AKBuilt 1962 · S/N 28-789N5641ZScout Aviation LLC · Arnaudville, LAS/N 22-9460N56424Saunders Equipment Inc · Cold Spring, NYBuilt 1981 · S/N 8017CN56429Norman Ronald E · Lopez Island, WABuilt 1973 · S/N 287325628N5642HSlaughter Don W · Farmville, NCFirst renewal noticeBuilt 1949 · S/N 16-253N5642MShower Michael K Jr · Wasilla, AKBuilt 1980 · S/N 7349CN5642TMark C Petersen · Sturgeon Bay, WIBuilt 1998 · S/N 21049CN5643Fingerlakes Wing And Rotor LLC · Seneca Falls, NYS/N 4033N56432Ladig Aviation LLC · Mount Washington, KYS/N 287305591N5643LChaney Timothy W · Peoria, AZBuilt 1968 · S/N AA1-0043N5643MSandvick Randy R · Killdeer, NDFirst renewal noticeBuilt 1981 · S/N A7358CN5643NVelasquez Bailee Jude · Anchorage, AKBuilt 1981 · S/N A7361CN5643PRed Cardinal Aviation LLC · Chantilly, VABuilt 1959 · S/N 24-713N5643QGray Eric W · Erie, COBuilt 1965 · S/N 3020N5643SShedd Christopher · Holly Pond, ALBuilt 1981 · S/N 7352CN5643UExotic Sky LLC · Kalispell, MTBuilt 1969 · S/N 28-26439N5643ZMcduffie Rodney D · Cullman, ALBuilt 1981 · S/N 8019CN56440Registration Pending · Wilmington, NCRegistration pending, pending cancellationS/N 28R7335437N56442Registered aircraftBuilt 1982 · S/N 7391CN56446Finch Ernest B · Anchorage, AKBuilt 1981 · S/N 7385CN56447Hutton Neil J · Wray, COBuilt 1981 · S/N 7383CN5644HPoliti Terris P · Lake Placid, NYBuilt 1949 · S/N 16-255N5644LMartinez Pedro M · BreeNon-citizen corporation, flight hours not reportedBuilt 1968 · S/N AA1-0044N5644MRosenbach Jay A · Chugiak, AKBuilt 1981 · S/N 7380CN5644NTerrane Exploration & Reconnaissance Co LLC · Chandler, AZBuilt 1981 · S/N 7347CN5644QRichey Johnny · Shady Shores, TXBuilt 1965 · S/N 678N5644UDonaubauer Stefan · Charlotte, NCBuilt 1969 · S/N 28-26441N5644WHaynon Aircraft Services LLC · Palmer, AKBuilt 1980 · S/N 7350CN5644ZVon Drashek Bruce P · Prior Lake, MNBuilt 1962 · S/N 22-9461N564514gaviation LLC · Reading, PABuilt 1973 · S/N 287305595N56453Richard G Trudeau LLC · Alto, TXBuilt 1973 · S/N 28R-73-35439N56455Boltman Erik C · Wasilla, AKBuilt 1981 · S/N 7389C
Back to AD 81-18-04 R2