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.

N783NDVertol Systems Company Inc · Destin, FLBuilt 2016 · S/N 4496398N783RVAvexp1 LLC · Fayetteville, GABuilt 2013 · S/N 74002N783SCWeiblen Glenn P · Castroville, TXBuilt 1979 · S/N R18201002N783SHKmc Aircraft Leasing LLC · Spanish Fork, UTBuilt 2004 · S/N 3617N783VVanstory Randy · New Braunfels, TXBuilt 2020 · S/N 41763N783WWThomas Michael D · Centralia, WABuilt 1998 · S/N 18280351N78408On The Fly Aero LLC · Ocean City, NJBuilt 1968 · S/N 17257604N7840DDavis Steven T · Colleyville, TXBuilt 1957 · S/N 22-5490N7840FLederach David B · Bethlehem, PABuilt 1976 · S/N 28-7790228N7840NBiby Steven R · Churchs Ferry, NDBuilt 1969 · S/N 28-5294N7840VShedd John G · Hopewell, NJBuilt 1965 · S/N 462N7840WTomic Milos · Westminster, COBuilt 1964 · S/N 28-1857N7840XShaw Christopher S · Porterville, CAFirst renewal noticeBuilt 1961 · S/N 48340N7840YArno Philip A · Clarence Center, NYBuilt 1965 · S/N 30-920N7841HCross Thomas Ad · Yacolt, WABuilt 1946 · S/N 12-741N7841VKohler Donald L W · Hernando, FLS/N 463N7841WBasin Flyers LLC · Klamath Falls, ORS/N 28-1858N78424Acapulco Flying Club LLC · New Brighton, MNBuilt 1968 · S/N 17257611N78428Cypher Anne K · The Dalles, ORBuilt 1968 · S/N 17257612N78429Doughty Robert M · Earlville, ILBuilt 1968 · S/N 17257613N7842BLowe David M · Sacramento, KYBuilt 1956 · S/N 23-632N7842DCasler Robert A · Phelps, NYBuilt 1957 · S/N 22-5492N7842GChildress Aviation LLC · Conway, ARBuilt 1970 · S/N 17259542N7842HMcgregor Daniel A · Denali Park, AKS/N 12-742N7842NBoon Andrea Elizabeth · Bloomingdale, NYBuilt 1969 · S/N 28-5297N7842PFall Stuart W · Holland, MIBuilt 1962 · S/N 24-3065N7842SDoyle Terry W · Grapevine, TXBuilt 1976 · S/N 1173-76N78436Vp Aviation LLC · Woodstock, NYBuilt 1969 · S/N 17257616N7843GFlybarely LLC · Manitowoc, WIBuilt 1970 · S/N 17259543N7843NA10 Aviation LLC · Peachtree City, GABuilt 1969 · S/N 28-5298N78440Boeing Employees Flying Association · Renton, WABuilt 1968 · S/N 17257618N78441444.Com LLC · Wilmington, DEBuilt 1968 · S/N 17257619N78442Sullivan Darrell L · New Plymouth, IDBuilt 1947 · S/N 12-1953N78444Hupe John F · Wamego, KSBuilt 1968 · S/N 17257620N78445Wings Over Texas Holdings LLC · Denton, TXBuilt 1968 · S/N 17257621N78447Larson Larry L Trustee · Molt, MTBuilt 1947 · S/N 12-1957N78449Svendsen Gregory R · Anchorage, AKBuilt 1947 · S/N 12-1959N7844GRedington James F · Hot Springs, VABuilt 1970 · S/N 17259544N7844PTroy Watson Consulting Inc · Muleshoe, TXBuilt 1962 · S/N 24-3067N7844VBanterra Bank · Marion, ILBuilt 1964 · S/N 465N7844WSaddy Rock · Henderson, NVS/N 28-1861N78450Gage Farms Inc · Stanberry, MOBuilt 1947 · S/N 12-1962N78453Sale Reported · None, OKSale reported, canceledBuilt 1947 · S/N 12-1963N78454Powell Sherman B · Falkville, ALBuilt 1947 · S/N 12-1964N78456Deoudes Demitrios N · Anchorage, AKBuilt 1947 · S/N 12-1965N78458Heffley And Ruiz LLC · Waco, TXBuilt 1968 · S/N 17257624N78459Sutton George G · Richland Center, WIBuilt 1947 · S/N 12-1970N7845DParr Richard · Pittsboro, NCBuilt 1957 · S/N 22-5495N7845GSolorio Inc · Mission, TXBuilt 1970 · S/N 17259545N7845MGilbert David L · Madison, SDBuilt 1946 · S/N 121516
Back to AD 81-18-04 R2