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.

N9481DBoemig Madison K · Dalton, NHBuilt 1985 · S/N 172RG1181N9481JRuffner Samuel D · Powder Springs, GABuilt 1966 · S/N 28-3598N9481KHepp Investments LLC · Warrens, WIBuilt 1976 · S/N 28-7615205N9481NKing Cindy · Purvis, MSBuilt 1969 · S/N 28R-35199N9481VStutzman Mervin · Kingman, INBuilt 1970 · S/N 700046N9481WMcintyre Stephen C · Lumberton, NCBuilt 1968 · S/N 28-11216N94822Elon Aviation LLC · Burlington, NCBuilt 1983 · S/N 15285795N94823Black Hills Information Security Inc · Bozeman, MTBuilt 2013 · S/N 18282363N94825Vaughan Aviation LLC · Leesburg, VABuilt 2013 · S/N 18282324N9482CSchuetz Ray · Davie, FLBuilt 1978 · S/N 28-7816481N9482DHanley Company LLC · Littleton, COBuilt 1958 · S/N 18-6734N9482TReid John · Emmett, IDBuilt 1978 · S/N 38-78A0111N9482WCantrall Aviation Flying Club LLC · Elizabethtown, KYBuilt 1968 · S/N 28-11218N9482ZChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280455N9483CCnczilla Co · Royersford, PABuilt 1978 · S/N 28-7816482N9483TLindley Mark E · Wakefield, RIBuilt 1978 · S/N 38-78A0113N9483VScholls Arnold W · Syosset, NYBuilt 1970 · S/N 700042N9483WFlying D Aviation Of Kansas LLC · Wichita, KSBuilt 1969 · S/N 28-11221N9484HN9484h LLC · Wheeling, ILBuilt 1975 · S/N 17266175N9484KDoll Electric Co Inc · South Lake Tahoe, CABuilt 1976 · S/N 28-7615206N9484LHarrington Paul J · Queen Creek, AZBuilt 1971 · S/N AA1A-0284N9484NBourjeili Elias · Glendora, CABuilt 1969 · S/N 28R-35202N9484VHannon Fredrick W · Punta Gorda, FLBuilt 1970 · S/N 700064N9485FGonzales David M · Corvallis, ORBuilt 1966 · S/N 1260294N9485JBlakely Jerry II · Coeur D Alene, IDBuilt 1966 · S/N 28-3602N9485LRoll George N · Freeport, FLBuilt 1971 · S/N AA1A-0285N9485VBrown Douglas B · Petaluma, CABuilt 1970 · S/N 700043N9486BMccoy Robert P · Fairbanks, AKBuilt 1981 · S/N 172RG0837N9486CRhodes Ryan · Dallas, TXBuilt 1978 · S/N 28-7890415N9486JJames Andy K · Shallowater, TXBuilt 1966 · S/N 28-3603N9486KAerial Avionics Inc · Modesto, CABuilt 1976 · S/N 28-7615207N9486NRahimi Navid B · Silver Spring, MDBuilt 1969 · S/N 28R-35205N9487JElmenhurst Daniel D · Walla Walla, WABuilt 1966 · S/N 28-3604N9487KInverted Air LLC · Mesa, AZBuilt 1976 · S/N 28-7690254N9487RBoyer Air Lc · West Des Moines, IABuilt 1978 · S/N R18200710N9487WPikes Peak Fliers LLC · Colorado Springs, COBuilt 1968 · S/N 28-11226N9488DClear Prop Aviation LLC · Sioux City, IABuilt 1959 · S/N 18-6740N9488GTap Solutions Inc · San Diego, CABuilt 1979 · S/N 17273629N9488JSneed Associates LLC · Fort Morgan, COBuilt 1966 · S/N 28-3605N9488VMarlow Michael L · Bandera, TXBuilt 1970 · S/N 700045N94891Avcorp Holdings Inc · Jackson, MIBuilt 1983 · S/N 15285806N9489FHensley Richard · Bertram, TXS/N 870325N9489JIndiana County Flying Club Inc · Blairsville, PABuilt 1966 · S/N 28-3606N9489LFord John C · Norman, OKS/N AA1A-0289N9489VReeder John Galen · Cedar Falls, IAS/N 700048N948CBSouth Plains Implement Ltd · Seminole, TXS/N T20608833N948CPCivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282115N948DBBoard David N · Moundsville, WVBuilt 1963 · S/N 22-7600N948JTThompson James L · Thousand Oaks, CABuilt 2000 · S/N 001N948PWEagles Soar LLC · Lewes, DEBuilt 1979 · S/N 948
Back to AD 81-18-04 R2