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.

N892BVGd Aviation Inc · Belleair, FLBuilt 2004 · S/N 18281329N892CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13059N892DLBd Aviation LLC · Sauget, ILBuilt 2021 · S/N 28020041N892EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12685N892NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 4496556N892PTTims Duane R · Hemet, CABuilt 2012 · S/N 70567N892SGCraik Evelyn June · Las Vegas, NVBuilt 1966 · S/N 1114N893012265 LLC · Mercer Island, WABuilt 1978 · S/N 15282706N8930DBeverly Lester E · Shepherd, TXS/N 22-6088N8930JMccracken Blake R · Lake Havasu City, AZBuilt 1965 · S/N 28-2948N8930MCuratola Bruce J · League City, TXS/N M-318N8930WMaurer Mark · Alamogordo, NMBuilt 1964 · S/N 28-10495N89310Kuyl Marinus D · Forest Grove, ORBuilt 1978 · S/N 15282708N89312Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15282710N8931VAeroventures 8 LLC · Mt Carmel, TNS/N 17264288N8932DRegistration Pending · Caldwell, IDRegistration pendingBuilt 1958 · S/N 22-6090N8932MOlivieri Michael R · Wasilla, AKBuilt 2009 · S/N 1-18N8932VEverett William M · Tuscumbia, ALBuilt 1974 · S/N 17264289N8932YStrohmeyer Gregory C · Wasilla, AKBuilt 1974 · S/N 18-7409042N89333Chapel Hill Flying Club Inc DBA · Sanford, NCBuilt 1978 · S/N 15282717N89337Davis Andrea E · Lake Oswego, ORBuilt 1983 · S/N 17276002N8933DGrandy Leland P · Rock Springs, WYS/N 22-6091N8933JQuilling John R · Cannon Falls, MNBuilt 1965 · S/N 28-2950N8933LDuncan Aviation Inc · Lincoln, NEBuilt 1974 · S/N 18-7409128N8933RThrall Gregory D · Seward, AKBuilt 1959 · S/N 7GC-159N8933WFlight Time LLC · Portland, ORBuilt 1964 · S/N 28-10500N8934CHandel Patrick A · Wautoma, WIBuilt 1953 · S/N 22-1532N8934PNermernuh LLC · Chester, CTBuilt 1966 · S/N 24-4390N8934VUniversal Aviators Academy Inc · El Monte, CABuilt 1974 · S/N 17264291N8934WNelson Cy D · Decorah, IABuilt 1964 · S/N 28-10501N8934YFuller John M · Minden, NVBuilt 1971 · S/N 39-95N89358Redstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1978 · S/N 15282724N89359Mccartney Robert · Mountain View, CABuilt 1978 · S/N 15282725N8935WJudd Ellen K · Burley, IDS/N 28-10502N8936JCloud Niners Inc · Brownsburg, INBuilt 1965 · S/N 28-2953N89372Rodriguez Devin · Arlington, TXBuilt 1978 · S/N 15282729N89377Bishops' Ltd · Virginia Beach, VABuilt 1978 · S/N 15282732N8937DBrunner Steve W · Mission Viejo, CABuilt 1958 · S/N 22-6099N8937LHood River Soaring · Hood River, ORBuilt 1971 · S/N 25-5402N8937RBeckett David · Wasilla, AKBuilt 1996 · S/N 0279N8937VCowden Steven B · Bellingham, WABuilt 1974 · S/N 17264294N8937WArmstrong Wanliss E · Jal, NMBuilt 1964 · S/N 28-10504N8938FSouthern Cross Aviation Inc · Wilmington, DEBuilt 1964 · S/N 44-0009N8938JMeier Daniel J · Greenwood, INBuilt 1965 · S/N 28-2955N8938YUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1971 · S/N 39-99N89390Nevill Jordan J · Ukiah, CABuilt 1978 · S/N 15282734N89392Story John D · Harrah, OKBuilt 1946 · S/N 8424N8939CRegistration Pending · Lakota, NDRegistration pendingS/N 28-7615133N8939JEstis Jonathan D · Walden, NYBuilt 1966 · S/N 28-2956N8939LWestern Carolina Ag Air Inc · Catawba, NCBuilt 1971 · S/N 25-5404
Back to AD 81-18-04 R2