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.

N9081LReed William B Trustee · San Jose, CABuilt 1970 · S/N 224-70N9081VSale Reported · Phoenix, AZSale reportedBuilt 1968 · S/N 690015N9081WStickley John E · Lothian, MDBuilt 1965 · S/N 28-10683N90829Leading Edge Aviation Consultants LLC · Windsor, CTBuilt 1985 · S/N 28-8690011N9082DLeahy Garry E · Van Wert, IABuilt 1958 · S/N 18-6450N9082LSmethurst Jeffrey C · San Francisco, CABuilt 1970 · S/N 781-70N90839White Jake W · San Antonio, TXS/N 101N9083BNorth Coast Flight School Inc · Meadville, PABuilt 1985 · S/N 28-8590076N9083DSachs Randy S · S Huntington, NYBuilt 1986 · S/N 28-8690050N9083KShuey Robert D III · Albertville, ALBuilt 1977 · S/N 28-7890174N9083LPeavy Michael J · Chico, CAS/N 256-70N9083NKnoxville Flyers Inc · Knoxville, TNBuilt 1986 · S/N 28-8611005N9084FIsland Bound LLC · Dunedin, FLBuilt 1980 · S/N 172RG0352N9084VLinear Air LLC · Herriman, UTBuilt 1968 · S/N 690018N9085JBligh Michelle C · Oceanside, CABuilt 1966 · S/N 28-3122N9085KSale Reported · Grayling, MISale reportedBuilt 1977 · S/N 28-7890175N9085LBlanton Jeffrey D · Valley Center, KSBuilt 1970 · S/N 226-70N9085WColip Lydia · Bowling Green, INS/N 28-10689N9086DDarrow John K · Soldotna, AKBuilt 1958 · S/N 18-6460N9086JBrogan William J · Port Matilda, PABuilt 1966 · S/N 28-3123N9086KMedia Stew LLC · Carson City, NVBuilt 1977 · S/N 28-7890176N9086ZCy Air LLC · Springfield, MOBuilt 2011 · S/N 18282281N90874Myers Brian R · South Bend, INBuilt 1985 · S/N 28-8690014N90878Schmoll Steven D · Zimmerman, MNBuilt 1974 · S/N 194HN9087DBolden Family Farms · Little Rock, ARBuilt 1986 · S/N 2816001N9087LDeterding Jim L · Pond Creek, OKS/N 783-70N9087VPyne Jeffery G · Waxhaw, NCBuilt 1986 · S/N 32R-8613005N9087WKohlhardt Ronald C Trustee · Cameron Park, CABuilt 1965 · S/N 28-10692N90882Bucciarelli Dominick F · Pueblo, COBuilt 1976 · S/N 848N9088DMetro Aircraft Co · Bloomington, MNBuilt 1986 · S/N 28-8616049N9088EBrink Kirk H · Greeneville, TNBuilt 1977 · S/N 7092CN9088JRiggins Ryan W · Durango, COBuilt 1966 · S/N 28-3126N9088LLegends LLC · Willow, AKBuilt 1970 · S/N 782-70N9088QGolf Foxtrot Yankee LLC · Kingston, NYBuilt 1986 · S/N 2890002N9088UPennington Daniel W · Rutland, VTBuilt 1986 · S/N 28-8611008N9089K&M Land Surveying Inc · Lincoln, NEBuilt 1966 · S/N 32-215N90898Nation Steven R · Hurricane, UTBuilt 2007 · S/N 24131N9089CCrew Sourcing Inc · Wilmington, DEBuilt 1985 · S/N 28-8690016N9089HDavis Joseph S · Andalusia, ALBuilt 1975 · S/N 17265936N908AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843802N908AFRobinson Craig M · Colfax, CABuilt 1967 · S/N 28-23976N908AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881946N908AZWingsleasing LLC · Wichita, KSS/N 40.388N908BLBoudreaux Jacques P · Shreveport, LABuilt 2006 · S/N 90854N908CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8331N908DRRhodes Dennis R · Taylorsville, GABuilt 2008 · S/N 91359N908ENEl Aviation LLC · Alpena, MIBuilt 2000 · S/N 20608105N908EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12970N908FGRidgeline Assets LLC · Wilmington, DEBuilt 2021 · S/N 172S12724N908GDCorpus Terra Investments LLC · Hialeah, FLBuilt 1988 · S/N 2040
Back to AD 81-18-04 R2