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.

N9065WJ & K Enterprises Inc · Waukesha, WIBuilt 1965 · S/N 28-10663N90669Cape Copters LLC · Scott City, MOBuilt 1981 · S/N 0119N9066EKilmer Randall W · Bellefonte, PAFirst renewal noticeBuilt 1977 · S/N 7076CN9066LPasco Gary R · Brockport, NYBuilt 1970 · S/N 773-70N9066RForage Jean Pierre Md · Lakeway, TXBuilt 1978 · S/N R18200660N9066WKurtz Brian · Troy, ALBuilt 1965 · S/N 28-10665N9067DWing Robert E · Fairbanks, AKS/N 18-6432N9067JEvans Jennifer M · Escalante, UTS/N 28-3102N9067LGabriel Thomas G · Clinton, PABuilt 1970 · S/N 774-70N9067VAdventist World Aviation · Wilson, NCS/N 690010N90687Robinson Jere L · Burnet, TXBuilt 1968 · S/N 18-8734N9068HGundlach Mark A · Fruitland, WABuilt 1975 · S/N 17265928N9068JGregory Brent · Townsend, DES/N 28-3103N9068SBuehler Andrew · Eatonville, WABuilt 1981 · S/N 0172N9068VPyle Brian D · Mooresville, NCBuilt 1968 · S/N 690012N90697Mccreary Daniel R · Bonney Lake, WABuilt 1946 · S/N 1791N9069FWoodman Dwight C · Hudson, FLBuilt 1981 · S/N 0177N9069LCitabria Flyers LLC · North Salt Lake, UTBuilt 1970 · S/N 252-70N9069VErban Bryce · Stillwater, MNBuilt 1968 · S/N 690011N9069WSchultz David L · Bernalillo, NMBuilt 1965 · S/N 28-10669N906AZN906az LLC · Miami, FLBuilt 1978 · S/N 15282474N906CCColumbus Paul S · Laguna Beach, CABuilt 2001 · S/N 9924CCN906CRRed 6 Technologies LLC · Santa Monica, CABuilt 2023 · S/N CR-001N906ELRushing Eric R · Molalla, ORBuilt 2023 · S/N 41561N906GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881471N906GDAir Charter Inc DBA · Culebra, PRBuilt 1979 · S/N 847N906GSStevens Donald R · North Plains, ORBuilt 1989 · S/N 20241N906GTPure Sports Inc · Tavares, FLBuilt 2007 · S/N 2412N906JJetran LLC · Horseshoe Bay, TXBuilt 2021 · S/N 18283160N906JBAcosta Marcos E · Yorktown Heights, NYBuilt 1976 · S/N AA5A-0196N906JHTop Gun Aviation LLC · Pasadena, MDBuilt 2025 · S/N 18283303N906JRAmeriflyers Of Texas Inc · Addison, TXBuilt 2006 · S/N 172S10231N906KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1979 · S/N 17272697N906MDFive Rivers Flight Training LLC · Livermore, CABuilt 1976 · S/N 17268038N906PSGravitas Services LLC · Richmond Hill, GAS/N 28-777N906RGClark Rachael P · Elizabethtown, NCBuilt 2006 · S/N 71379N906RVFennell Stacy L · Conroe, TXBuilt 2006 · S/N 90330N906TMRkt Productions · Bristow, VAFirst renewal noticeBuilt 2010 · S/N 18282269N906WAPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1976 · S/N 17268112N906WFPapesh Sandra J · Cottonwood, CABuilt 1971 · S/N 28-7125163N90704Qualitair LLC Trustee · MichelstadtBuilt 1977 · S/N AA-5A0301N9070JCruiser Club Inc · Wahpeton, NDS/N 28-5115N9070VPinneo Mark · Foley, ALBuilt 1968 · S/N 690013N9070WUwharrie Flying Club Inc · Albemarle, NCBuilt 1965 · S/N 28-10670N9071DSturgis Richard G · Wasilla, AKS/N 18-6437N9071EAntique Aircraft And Automobile LLC · Van Alstyne, TXBuilt 1977 · S/N 7068CN9071LWolfley Jody K · Mountain Home, IDS/N 276-70N9071WWalker Cleon M · Slidell, LABuilt 1965 · S/N 28-10671N9073DJohnson Joseph S · Eagle River, AKBuilt 1958 · S/N 18-6439N9073JStewart Kenneth E Trustee · Raleigh, NCBuilt 1966 · S/N 28-3109
Back to AD 81-18-04 R2