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.

N75871Blue Wing Flyer LLC · Marietta, GABuilt 1977 · S/N 17268011N75874Walled Lake Flying Club · Waterford, MIBuilt 1976 · S/N 17268012N75876Roe Amber · Scotts Valley, CABuilt 1976 · S/N 17268013N75878Milosevich Nikola · Deland, FLBuilt 1976 · S/N 17268014N75879Griffin Aviation LLC · Spokane, WABuilt 1976 · S/N 17268015N7587EBroderick William E · Sterling, MABuilt 1958 · S/N 7GC-19N7587JLaney Ricky Allen Jr · New London, NCBuilt 1968 · S/N 28R-30981N7587RFca Flight Training LLC · Washington C H, OHS/N 28-22154N7587VBradley Vaylan L · Keller, TXBuilt 1976 · S/N 177RG0878N7587WHawbaker Ray · Quinter, KSBuilt 1964 · S/N 28-1537N75884A-Z Aviation LLC · Bay City, MIBuilt 1956 · S/N 20-811N75885Mds Enterprises LLC · Lemont Furnace, PABuilt 1976 · S/N 17268019N7588CGrand Aviation Inc · Grove, OKBuilt 1975 · S/N 28-7625076N7588EGross Barbara J · Timber Lake, SDBuilt 1950 · S/N 18-305N7588FWilbanks Kari L · North Port, FLBuilt 1970 · S/N 751-70N7588HEagy Gregory L · Boise, IDBuilt 1946 · S/N 12-450N7588PMyres Ronald W Trustee · Mckinney, TXBuilt 1961 · S/N 24-2799N7588WRustic Getaways LLC · Eagar, AZBuilt 1964 · S/N 28-1538N7588YK&Cs Saveacomanche LLC · Spring Lake Park, MNBuilt 1964 · S/N 30-655N75890Milligan Tony L · Rumford, MEBuilt 1976 · S/N 17268020N75897Gopalakrishnan Sanjeev K · Spring, TXBuilt 1976 · S/N 17268023N75898Center O Flying Club · Tumwater, WABuilt 1976 · S/N 17268024N7589DBergstrom Aircraft Inc · Pasco, WABuilt 1979 · S/N 17272927N7589FAerial Advertising Services · Livermore, CAS/N 236-70N7589VCorwin Lloyd D · Idaho Falls, IDBuilt 1976 · S/N 177RG0880N758CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12726N758PANew Horizons Aviation Inc · Goshen, INBuilt 1978 · S/N 15282932N758RBde Aviation Services LLC · Chatham, ILS/N 82072/C1N758YSFly Sky Ads LLC · Manalapan, NJBuilt 1982 · S/N A1521017N758YTMountain Air Flying LLC · Brigham City, UTBuilt 1982 · S/N A1521018N75904Worley Dan L · Heber Springs, ARS/N 17268028N75907Rmb Leasing Inc · Dover, DEBuilt 1976 · S/N 17268031N75909Martin Michael J · Anchorage, AKS/N 17268033N7590JOhlman Matthew · Atlanta, GAS/N 28R-30985N7590KByers Steven J · San Diego, CABuilt 1950 · S/N 18-307N75917Abs Aviation · Lanham, MDBuilt 1976 · S/N 17268040N7591EYoung Carl J · Lubbock, TXBuilt 1958 · S/N 7GC-24N7591FFinger Lakes Soaring Club Inc · Dansville, NYFirst renewal noticeBuilt 1970 · S/N 210-70N7591GRochez Gerald A · Jensen Beach, FLBuilt 1970 · S/N 17259291N7591RRight Rudder Brothers LLC · East Point, GABuilt 1966 · S/N 28-22158N7591VHallack Daniel Edwin · Hart, MIBuilt 1976 · S/N 177RG0882N7591WBurin John · Durango, COBuilt 1964 · S/N 28-1541N75922Phillips Lester L · Pahrump, NVBuilt 1976 · S/N 17268045N75925A&A Aviation LLC · Edinburgh, INBuilt 1976 · S/N 17268047N75926Owens Flight Training LLC · Lafayette, LABuilt 1976 · S/N 17268048N7592HClaypool Kimberly A · Ottumwa, IABuilt 1946 · S/N 12-466N7592JWalker David C · Elk City, OKBuilt 1968 · S/N 28R-30987N7592PStrobach Kristin K · Rib Lake, WIS/N 24-2803N7592RInternational Security Network Inc · Pahrump, NVBuilt 1978 · S/N R18200654N7592VMisener Richard H · Hermiston, ORBuilt 1976 · S/N 177RG0883
Back to AD 81-18-04 R2