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.

N6123DCampi Curtis · Boulder City, NVBuilt 1957 · S/N 22-4767N6123FJws Aviation LLC · Edina, MNBuilt 1979 · S/N 17273153N6123NPfisters Flying Wahine · Waialua, HIBuilt 1969 · S/N MB-409N6123QAirflair Inc · Maurice, IABuilt 1976 · S/N 28-7790065N6123VWings Over La Aviation LLC · Van Nuys, CABuilt 1965 · S/N TD-613N6124DWegener Flying Services LLC · Indialantic, FLBuilt 1979 · S/N 17272608N6124JCrews Aaron Gregory · Boone, IABuilt 1976 · S/N 28-7690346N6124NPacific Coast Air Museum · Santa Rosa, CABuilt 1968 · S/N MB-410N6124QLewis Chip M · Eau Claire, WIS/N 10073CN6124TBanjo Ben Aviation LLC · Kilgore, TXS/N R18201911N6125BBv Road And Site LLC · Penfield, NYBuilt 1979 · S/N 15283904N6125LJohnson Gerald A · Sedro Woolley, WAS/N AA1-0325N6125PThomas Roger · Hudson, OHBuilt 2004 · S/N 18281387N6125ZSvendsen Jon A · Wasilla, AKBuilt 1960 · S/N 25-145N61260Syracuse Flight School Inc · Syracuse, NYBuilt 1978 · S/N 28R-7837255N6126DNeal Brian C · Monrovia, CABuilt 1957 · S/N 22-4770N6126MBishop Aeronautics LLC · Helena, MTBuilt 1977 · S/N 7161CN6126PDallas Jets Group LLC · Canton, TXBuilt 1959 · S/N 24-1226N6126SWise Joseph · Kilgore, TXBuilt 1965 · S/N 18-32N6126TGuida Associates Consulting Inc · Sandpoint, IDS/N S1496N6126WMatthews James C · Gilbert, SCBuilt 1964 · S/N 28-20142N6127AGilfert Thomas E · Selinsgrove, PABuilt 1979 · S/N 18-8009051N6127HBless Howard P · Pennsburg, PAFirst renewal noticeBuilt 1977 · S/N 28-7816226N6127MOhman Victor N · Glenrock, WYBuilt 1977 · S/N 7162CN6127VSorbi Aviation Inc · El Cajon, CAS/N 172RG0583N6127WLa Aviation Ltd · Wilmington, DES/N 28-20143N6127ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1960 · S/N 25-148N61289Huff Zachary Daniel · Mesa, AZBuilt 1974 · S/N 03N6128PTango Alpha Sierra LLC · Berthoud, COS/N 4057CN6128TStone Mark · Scotts Valley, CABuilt 1982 · S/N R18201912N6128UJoslyn Larry J · Las Vegas, NVBuilt 1993 · S/N S1655N6129CSumner Scott B · Catoosa, OKBuilt 1988 · S/N 11057CN6129HHouk Air LLC · Waverly, OHBuilt 1977 · S/N 28-7890209N6129JBlue Skies Aircraft LLC · Kalispell, MTBuilt 1976 · S/N 28-7625221N6129LDodson David W · Granger, INBuilt 1970 · S/N AA1-0329N612APThomas Lucas G · Beebe, ARBuilt 1978 · S/N 286-78N612BKKqm Aviation · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 20608325N612BZDerby City Aviation LLC · Vero Beach, FLBuilt 1979 · S/N 17272084N612CAOmni Aero LLC · Wilkesboro, NCBuilt 1978 · S/N 15282495N612DMRegistered aircraftBuilt 1977 · S/N 177RG1212N612DPCarlson Glenn Alan · Byron Center, MIBuilt 2007 · S/N 18281953N612EHIsland Flyers Inc · Addison, TXBuilt 1976 · S/N 277654161N612ERNelson James W · Lake Villa, ILBuilt 2018 · S/N 65-10237N612FTFlorida Institute Of Technology · Melbourne, FLBuilt 1977 · S/N 28-7816197N612GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881195N612GGMid Missouri Spray Service LLC · Richmond, MOBuilt 2016 · S/N 14016N612GPPlugge Glen A · Tuscaloosa, ALS/N 23920N612HKDickey Stephen H · De Leon, TXBuilt 1977 · S/N 177RG1303N612HPAmerican Patrols Inc · Midland, TXBuilt 1981 · S/N 17274933N612JATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13588
Back to AD 81-18-04 R2