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.

N8044WKananen Agency Inc · Joliet, MTBuilt 1965 · S/N 28-2114N80454Tadao LLC · Tucson, AZBuilt 1976 · S/N 17266593N80456Barash Geva S · Ashland, MABuilt 1976 · S/N 17266595N80458Kolpack Glenn H · Sonora, CABuilt 1976 · S/N 17266597N8045CConrad Daniel R · Sweet Home, ORBuilt 1954 · S/N 22-2231N8045DLarson Larry E · Twin Valley, MNBuilt 1957 · S/N 22-5570N8045KEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1989 · S/N 1141N8045NCti Aircraft Leasing LLC · Memphis, TNBuilt 2019 · S/N 4496488N8045PDuncan Mark L · Hyampom, CABuilt 1962 · S/N 24-3291N8045RCcf Ventures Inc · Bangor, MES/N 64-18084N8045SHenry Mark A · Dickinson, TXBuilt 1964 · S/N 85-0365N8045WOpen Engineering LLC · Ames, IABuilt 1965 · S/N 28-2919N80469Hetherly Bryce D · Clintondale, NYS/N 17266603N8046RComputer Solutions Inc · Casper, WYBuilt 1981 · S/N 28-8211022N8046WMuthandi John M · Woodland, WABuilt 1965 · S/N 28-2116N80470Coddiwomple LLC · Newberg, ORBuilt 1976 · S/N 17266604N80471Dairy Air Inc · Wyoming, PABuilt 1976 · S/N 17266605N80472Simons George Trustee · Bouse, AZBuilt 1976 · S/N 17266606N80475Texas Southern University · Houston, TXS/N 17266608N80476Sky Roamers LLC · Columbus, NEBuilt 1976 · S/N 17266609N8047DMurphy Robert · Kent, WABuilt 1957 · S/N 22-5572N8047LHolmes Frank L · Enterprise, ALBuilt 1967 · S/N 47-0699N8047WFlying Fossil LLC · Franklin, TNBuilt 1965 · S/N 28-2119N80483Harrell Matthew J · Grand Haven, MIBuilt 1976 · S/N 17266611N80484Mor Aviation 172m LLC · Gaithersburg, MDBuilt 1976 · S/N 17266612N80486Romoser Carey E · Simpsonville, SCBuilt 1976 · S/N 17266613N80487Williams Fredrick Glen · Auburn, ALS/N 17266614N80489P & K Aviation LLC · Neshkoro, WIBuilt 1976 · S/N 17266615N8048CDegraff Claude Md · Fort Myers, FLBuilt 1975 · S/N 28-7625093N8048DBarnstormers Aerial Advertising LLC · North Myrtle Beach, SCBuilt 1954 · S/N 54-2592N8048PCoastal Virginia Aviation LLC · Chesapeake, VABuilt 1962 · S/N 24-3293N80490American Patrols Inc · Midland, TXS/N 17266616N80491Duffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1976 · S/N 17266617N80495Space Coast Aero LLC · Melbourne, FLBuilt 1976 · S/N 17266619N80496Bickel Gregory A · Mckinleyville, CABuilt 1976 · S/N 17266620N80497Ducksrus LLC · Indianapolis, INBuilt 1976 · S/N 17266621N8049DFerrell Alan B · Arlington, OHBuilt 1957 · S/N 22-5573N8049GStone & Phillips Aviation LLC · Youngstown, FLBuilt 1971 · S/N 177RG0049N8049NKolbjornsen Arne · Middletown, DES/N 28-25295N8049PFranklin Ricky L · Glade Hill, VAS/N 56-0535N8049WTennis Gayland L · Bath, MIBuilt 1965 · S/N 75-0349N804ATFlight School Of Texas LLC · Wilmington, DEBuilt 2013 · S/N 4496333N804BD G Leasing LLC · Houston, TXBuilt 1976 · S/N 17266584N804BLFlores Omar Javier · New Braunfels, TXBuilt 1979 · S/N 17273041N804ERDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYBuilt 2003 · S/N 40.311N804GASaber Safa · Newburyport, MABuilt 1977 · S/N AA5A-0460N804JSButler Jack L · Bennington, OKBuilt 2004 · S/N 491-2004N804KSKansas State University · Salina, KSBuilt 2025 · S/N 172S13391N804LGDem Ventures LLC · Wichita, KSBuilt 1976 · S/N 61P-0298-075N804NVMoody Bible Institute Of Chicago · Spokane, WABuilt 2001 · S/N 1065
Back to AD 81-18-04 R2