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.

N68WYAviation Mentoring Program LLC · Phoenix, AZBuilt 2011 · S/N 3138N68XLsk Aviation Corp · Wilmington, DEBuilt 1963 · S/N 30-238N6900Adams Paul T · Pompano Beach, FLBuilt 2023 · S/N 17-AN69007Jj Kramer Aviation LLC · Vero Beach, FLS/N 2933N69009Jwa Flight School LLC · Bolingbrook, ILBuilt 1978 · S/N 15282429N6900DMahoney Shane · Auburn, WABuilt 1957 · S/N 22-4827N6900HCp Aviation Inc · Santa Paula, CABuilt 1946 · S/N 20129N6900JCaruso Jerry W Jr · Kingsbury, NYBuilt 1976 · S/N 28-7615393N6900NBond William E · Elk River, MNBuilt 1968 · S/N 680168N6900PMyer Charles G · Forest Lake, MNBuilt 1960 · S/N 24-2034N6900TAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1982 · S/N 60-8265027N6900URegistered aircraftBuilt 1964 · S/N 2695N6900WHall William Brent · Tulia, TXBuilt 1965 · S/N 28-21063N6900ZIndependence Glider Club · Independence, ORBuilt 1964 · S/N 25-2634N69011Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15282431N69012Chapel Hill Flying Club Incdba · Sanford, NCBuilt 1978 · S/N 15282432N69016Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15282435N69019Lange Walter · Plymouth, MABuilt 1978 · S/N 15282438N6901ASpence Stephen L · Anchorage, AKBuilt 1956 · S/N 29001N6901HRieser Steven E II · Baltimore, OHS/N 17265637N6901NRagsdale James W · Geneva, FLS/N 680134N6901QCbus Flight LLC · Pickerington, OHBuilt 1967 · S/N MB-265N6901ULime Lounge LLC · Des Moines, IABuilt 1964 · S/N 2696N69023Gilbert Jeffrey R · Dahlonega, GABuilt 1978 · S/N 15282441N6902DFerrell Alan B · Arlington, OHBuilt 1957 · S/N 22-4829N6902NSherrill Charles H · Robert Lee, TXBuilt 1968 · S/N 680169N69031Lewis Garry L · Livingston, LABuilt 1978 · S/N 15282448N69036Long Robert D · Kinston, NCBuilt 1978 · S/N 15282451N6903BJones Gary L · Kerrville, TXBuilt 1956 · S/N 22-4175N6903JGreen Valley Aerospace LLC · Lexington, VABuilt 1976 · S/N 28-7690425N6903NRoland Jason R · Royse City, TXBuilt 1968 · S/N 680170N6903PStack Gregory R · Aurora, COBuilt 1960 · S/N 242037N6903QSullivan Lynford M · Hernando, MSBuilt 1967 · S/N MB-267N6903RFusion Marine Inc · Stuart, FLS/N 60-8365015N6903UPray Aviation Inc · Augusta, KSBuilt 1964 · S/N 2698N69042Poplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1978 · S/N 15282455N69043Davidson Craig H · Heber City, UTBuilt 1978 · S/N 15282456N69045Eburg Aero LLC · Ellensburg, WABuilt 1978 · S/N 15282457N69047Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282459N6904ALesser Antilles Corp Trustee · Wilmington, DEBuilt 1979 · S/N 27-7954076N6904DLucas Michael F · Germantown, OHS/N 22-4831N6904KHolcomb Garry M · Point, TXS/N 20-33N6904NSchaffhauser Daniel L · Garland, TXBuilt 1968 · S/N 680135N6904UMyers Ronnie L DBA · Appling, GABuilt 1964 · S/N 2699N69053Aerofeather Aviation Inc · Suffolk, VABuilt 1978 · S/N 15282463N6905DEvans Theresa K · Alexandria, MNBuilt 1957 · S/N 22-4832N6905HTang Flyer LLC · Wausau, WIBuilt 1975 · S/N 17265638N6905JDouble Delta Sierra LLC · Bristol, CTBuilt 1976 · S/N 28R-7635359N6905NZero Five November Holding Inc · Kalispell, MTBuilt 1968 · S/N 680171N6905PMampel Gregory J · New Port Richey, FLBuilt 1960 · S/N 24-2039
Back to AD 81-18-04 R2