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.

N98251Wings Over Texas Holdings LLC · Denton, TXBuilt 1984 · S/N 17276269N98257Fly High Aviation LLC · Miami, FLBuilt 1969 · S/N 28-25954N9825GKanawha Aviators LLC · Bancroft, WVBuilt 1971 · S/N 17259725N9825WBunch Matthew B · Georgetown, KYBuilt 2000 · S/N 0412N98263Myers Bobby L · Brookhaven, MSBuilt 1969 · S/N 28-26132N98265Dickey Hugh B III Dr · Rock Hill, SCBuilt 1969 · S/N 28-26134N98266Lockhart Ralph E Jr · Beverly, OHBuilt 1969 · S/N 28-26135N98268Baldassari Roy L · Lawrenceville, NJBuilt 1969 · S/N 28-26137N98269B&R Aircraft LLC · Wadsworth, OHBuilt 1969 · S/N 28-26138N9826WWestrup Gregory W · Greensburg, INBuilt 1967 · S/N 28-23329N98271Mastin Aviation Inc · Pasadena, MDBuilt 1984 · S/N 17276272N98273Ortner Russell · Apopka, FLBuilt 1969 · S/N 28-26141N9827CKae Aviation LLC · Conover, WIBuilt 1978 · S/N R18200449N9827DQuality Aviation Inc · Marana, AZS/N 22-6717N9827GSpencer Jeffrey · Capistrano Beach, CABuilt 1971 · S/N 17259727N9827PSmith Terry L · Cedar Hill, TNS/N 25-7556146N9827UFiedler William K · Greensboro, GABuilt 1976 · S/N AA5A0227N9827YRegistration Pending · Sweet Home, ORRegistration pending, pending cancellationBuilt 1960 · S/N 50N9828LJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLBuilt 1986 · S/N 17276625N9828UAble Gary N · Houston, TXBuilt 1976 · S/N AA5A0228N98293Je Aircraft Repair LLC · Wasilla, AKBuilt 1969 · S/N 28-26150N98297Black Hawk Flight Progress LLC · Cedar Falls, IABuilt 1969 · S/N 28-26254N98298Parsons Mark E · Le Roy, WVBuilt 1969 · S/N 28-26154N9829JInflight Corp · Chaffee, MOBuilt 1980 · S/N 17273928N9829QChesnut Lonnie R · Palmer, AKBuilt 1954 · S/N 18-3328N9829YAnderson Isaac · Woods Cross, UTBuilt 1968 · S/N 253N9829ZKnevel Kenneth M · Manchester, MABuilt 1999 · S/N 299N982AAWings Over Texas Holdings LLC · Denton, TXBuilt 2025 · S/N 352/USN982BRThompson H S Trustee · Oakdale, CABuilt 1998 · S/N 18280277N982CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280227N982DSDelaware State University · Dover, DEBuilt 2019 · S/N 1025N982GCollester Rodney D · Danville, INBuilt 1967 · S/N 7ECA-321N982NWInternational Air Services Inc Trustee · Carson City, NVBuilt 1999 · S/N 21046CN982SKRowe Andrew L Jr · Hope, MEBuilt 1974 · S/N 17264042N982SPScott Kenneth C · Erie, COBuilt 1999 · S/N 172S8184N982WKnox Warren Henry · Santa Cruz, CABuilt 1962 · S/N 22-9219N982YGelm Jack H · Apex, NCBuilt 2004 · S/N 2331N98303Estes Jack · Memphis, TNBuilt 1946 · S/N 18462N98308Morse Robert M · Mayetta, KSBuilt 1969 · S/N 28-26162N9830GGonzalez Nicolas · Naples, FLBuilt 1971 · S/N 17259730N9830PHolmgren Michael G · Kulm, NDBuilt 1975 · S/N 25-7556148N9830VLeading Edge Flight Academy LLC · Bend, ORBuilt 1974 · S/N 17264518N98319Restin Air LLC · Kalispell, MTBuilt 1969 · S/N 28-26167N9831DHiginbotham Larry L · Littleton, COBuilt 1959 · S/N 22-6722N9831GStarr David · Mount Prospect, ILBuilt 1979 · S/N 17273637N9831UJaggers Aviation LLC · Tupelo, MSS/N AA1C0139N9831WMeyer Dale K · Altamont, NYS/N 28-23335N98320Flyg5 LLC · New London, WIBuilt 1969 · S/N 28-26168N98323Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276277N98326Lum Barnett K · Temple City, CABuilt 1984 · S/N 17276278
Back to AD 81-18-04 R2