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.

N68DGDellar Randy Roger · Wasilla, AKS/N 1208-95N68DSSichak Stephen Jr · Wanaque, NJBuilt 1997 · S/N 18280033N68DWAero Group I LLC · Woodstock, VABuilt 1977 · S/N 28-7890006N68DZUsda Aphis-Ws · Cedar City, UTBuilt 2009 · S/N CC18-0036N68EEBurtt John B · Pierson, MIBuilt 1975 · S/N 18-7509087N68FSistrunk Donald M · Ragley, LABuilt 1956 · S/N 22-4107N68FDVargas Emmanuel N · Murrieta, CABuilt 1988 · S/N 306N68FFPeregrine Howard Partners II Lp · New Orleans, LABuilt 2023 · S/N 172S12934N68GJDc Foote & Associates Inc · Camarillo, CAS/N 28-7425210N68GPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1967 · S/N 301656N68HKPomeroy Andy Lee · Seattle, WABuilt 2004 · S/N 60323N68JBOtto Pilot LLC · Everett, WABuilt 1963 · S/N 24-3531N68JCCapps Jon T · Bentonville, ARBuilt 1975 · S/N AA5-0801N68JJRegistration Pending · N Richlnd Hls, TXRegistration pendingBuilt 1966 · S/N 1107N68JXRybarczyk Thomas B · Benton, KSBuilt 1992 · S/N S1-10-59N68JYHowell Jon · Texarkana, ARBuilt 1968 · S/N 28R-30850N68KAAakre Keith E · Granite Falls, MNBuilt 1958 · S/N 7GC-21N68KBKeller Bros Airport Inc · Lebanon, PABuilt 1961 · S/N 24-2467N68KFDelconte Anthony T · Old Hickory, TNBuilt 2012 · S/N S9505-0122N68KTHobein Ted · Wheaton, ILBuilt 1999 · S/N 22584N68KWKim Waters Inc · Gainesville, GABuilt 2023 · S/N 18283217N68LCDriver Matthew · Rio Rancho, NMBuilt 1966 · S/N 670243N68LHGottschall James W · Highland, WIBuilt 1990 · S/N 434N68LKKing Larry E Jr · Wenatchee, WABuilt 1968 · S/N 18-8642N68LRMs Aero Inc · Lakeville, OHBuilt 1966 · S/N 30-1000N68MABig Creek Flyers LLC · Lewes, DEBuilt 2004 · S/N 2277N68MCAlpha Enterprises · Burley, IDBuilt 1981 · S/N 8-0004N68MEPeigneux Brothers Llp · Malta, MTBuilt 1968 · S/N 625N68NDSand Nicholas Patrick · Alta, IABuilt 1992 · S/N 668-92N68PJOdonnell Paul E · Schuylerville, NYBuilt 2019 · S/N BD4C021N68PVAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 442-07/OTCN68QCobb Lee C · Van Alstyne, TXBuilt 1971 · S/N OHB-1970N68RLeroy Philippe G · Willcox, AZS/N 2114N68RLSlutz David E · Morristown, TNBuilt 1979 · S/N AA5A0865N68RRBaker Nelson J · Ocean City, NJBuilt 1993 · S/N WR4103N68RSAlston Walter III · Fernandina Beach, FLBuilt 2010 · S/N 73299N68RVSteed David A · Oklahoma City, OKS/N 20100N68SBLucey William E · Salisbury, NCBuilt 1984 · S/N 562N68SCBridges Lee P · Smithville, TNBuilt 1964 · S/N 30-633N68SDPro Aero LLC · Warrenton, VABuilt 1979 · S/N 32-7940126N68SVAviat Aircraft Inc · Afton, WYBuilt 2026 · S/N 3472N68TLShoenberger James · Orlando, FLBuilt 1971 · S/N 121N68TYKing Ty · Rogers, ARBuilt 1968 · S/N 28-11207N68VCammack Daniel P · Colorado Springs, COBuilt 1967 · S/N 28-4552N68VAAspen Helicopters Inc · Oxnard, CABuilt 2007 · S/N 440/CN68VEK F Aviation Inc · San Juan, PRBuilt 1970 · S/N 27-4457N68VRGene Coleman Machine Inc · Menominee, MIBuilt 2004 · S/N 434N68VVWhite Mark E · Charleston, WVBuilt 1968 · S/N 17700898N68WLGlobal Pilot Inc · Wilmington, DES/N 70600N68WPButseev Anthony · Tarzana, CABuilt 1996 · S/N 23661
Back to AD 81-18-04 R2