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.

N956RWTrevitue LLC · San Antonio, TXBuilt 1979 · S/N 38-79A0721N956SLLittle James S · Douglass, TXBuilt 1977 · S/N 846N956SMMississippi Forestry Commission · Pearl, MSBuilt 2000 · S/N 18280783N956SPN3812q LLC · San Diego, CABuilt 1999 · S/N 172S8156N956TAAir Corriente LLC · Wilmington, DEBuilt 2014 · S/N 2380N956TERaw Logistics LLC · Bethel, NCBuilt 2004 · S/N 10235N9570AUpper Fifteen Inc · Latham, NYBuilt 1998 · S/N 18280286N9570JCharlie November Romeo LLC · Denver City, TXBuilt 1966 · S/N 28-3707N9570UFranken Todd V · Martindale, TXBuilt 1975 · S/N AA5A-0070N9570VAwp Holdings LLC · Murphysboro, ILS/N 18280285N9571HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266236N9571JMeunier Barry · Rehoboth, MABuilt 1966 · S/N 28-3708N9571KOtter Fly LLC · Maricopa, AZS/N 28-7615213N9571MSale Reported · Sacramento, CASale reportedBuilt 1966 · S/N 670148N9571VTempleton John E · Loami, ILBuilt 1974 · S/N 17264373N95722Frick Gregory A · Portland, ORBuilt 1985 · S/N 15285962N9572AEagle Eye Marketing LLC · Reno, NVBuilt 1998 · S/N 18280279N9572HGeneral Aviation LLC · Henderson, NVBuilt 1975 · S/N 17266237N9572LJav Air Services LLC · Anchorage, AKBuilt 1986 · S/N 17276582N9572VHill Timothy E · Hooks, TXBuilt 1974 · S/N 17264374N9572WDr Equipment LLC · Ackerly, TXBuilt 1998 · S/N 17280544N9573Styer David B · Pendleton, ORBuilt 1972 · S/N 131N95737Kent State University · Stow, OHBuilt 1985 · S/N 15285964N9573BDocarmo Aviation LLC · Dallas, TXBuilt 1981 · S/N 172RG0890N9573LCrosetto Pierre F · Downey, CABuilt 1974 · S/N AA5-0573N9573MAndrews Geoffrey M · Stoneham, MABuilt 1966 · S/N 670150N9573PAerial Banners Inc · Pembroke Pines, FLBuilt 1974 · S/N 25-7405683N9573SOppegard Nicholas D · Eagle River, AKBuilt 1966 · S/N 66N9573VReynolds Darryl G · Wills Point, TXBuilt 1974 · S/N 17264375N9573WPyxl Sky LLC · Cogan Station, PABuilt 1967 · S/N 28-23013N9574BHinds Community College · Bolton, MSBuilt 1981 · S/N 172RG0891N9574HJb III LLC · Stuart, FLBuilt 1975 · S/N 17266238N9574LRiederich John B · Huntington Beach, CABuilt 1974 · S/N AA5-0574N9574SKrejchik Daniel J · Portage, WIBuilt 1965 · S/N 14N9575DLaird Cristina R · Fairbanks, AKBuilt 1958 · S/N 18-6757N9575JJones Anthony J · North Royalton, OHBuilt 1966 · S/N 28-3712N9575UBarnett Gary L · Bertram, TXBuilt 1975 · S/N AA5A-0075N9575VFurnari Alfio · Hutchinson Island, FLBuilt 1974 · S/N 17264377N9575WMike Flying Service LLC · Terrell, TXBuilt 1967 · S/N 28-23015N9576Roznick John A · Stillwater, MNBuilt 1972 · S/N 133N9576CMercer Paul A · Salida, CABuilt 1978 · S/N 28-7816497N9576JWright Jason C · Thorntown, INBuilt 1966 · S/N 28-3713N9576KClearwater Valley Aero Club Inc · Kamiah, IDBuilt 1976 · S/N 28-7615215N9576LBusch Robert M · Duluth, MNBuilt 1976 · S/N AA1B0676N9576MRpm Commander Holdings Inc · Vero Beach, FLS/N 670153N9576PPhiladelphia Glider Council · Hilltown, PABuilt 1974 · S/N 25-7405689N9577BRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1981 · S/N 172RG0894N9577DBerry Matthew G · Creedmoor, NCBuilt 1958 · S/N 18-6760N9577JBrown Dennis N · Bakersfield, CAS/N 28-3715N9577LSquire Barry H · Sarasota, FLBuilt 1974 · S/N AA5-0577
Back to AD 81-18-04 R2