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.

N9946WHangar 0205 Inc · Calhoun, GABuilt 1967 · S/N 28-23491N9947CLoftin Aviation Group LLC · Suwanee, GABuilt 1978 · S/N R18200489N9947QQuarberg Donald M · Delta Junction, AKBuilt 1954 · S/N 18-3552N9947WDwinal Gary Lee · Lisbon, MEBuilt 1967 · S/N 28-23492N9948QPemberton Addison J · Spokane, WABuilt 1954 · S/N 18-3557N9948UDully David F W · Fernandina Beach, FLBuilt 1977 · S/N AA5A0348N9949RJeca Flight LLC · Liberal, KSBuilt 1960 · S/N TD-388N9949ULindquist Bonnie C Trustee · Webster, MNBuilt 1978 · S/N AA1C0163N994ACCoonan James A · Streator, ILBuilt 2019 · S/N JA395-07-14N994BCEast Coast Flyers LLC · Rockville, MDBuilt 1970 · S/N 28R-7135036N994CCStraight And Level Productions Inc · Bentonville, ARBuilt 2000 · S/N 9911CCN994CS994 Charlie Sierra Inc · Jacksonville, FLBuilt 1978 · S/N 28-7990089N994DBBest Equipment Leasing LLC · Bakersfield, CAS/N 994N994DSDelaware State University · Dover, DEFirst renewal noticeBuilt 2019 · S/N 1029N994FGFlightgest Academy LLC · Morrisville, NCBuilt 2024 · S/N 2881831N994KCCayton Sidney M · Aurora, NCBuilt 2006 · S/N 11083N994KSEegt Inc · Helena, MTBuilt 2001 · S/N 90058N994LAJaguar Aviation LLC · Hillsboro, ORBuilt 2024 · S/N 172S13120N994MBAquila Air Charter LLC · Wilmington, DEBuilt 1985 · S/N 28-8590037N994RSShane Richard D · Canandaigua, NYBuilt 1978 · S/N 15282505N994TAmerican Champion Aircraft Corp · Rochester, WIBuilt 2026 · S/N 1235-2026N994WWMabry Properties And Holdings LLC · Jonesboro, ARBuilt 1999 · S/N 17280719N994XList Martinus R · Wasilla, AKBuilt 2011 · S/N 994N99507Alyeska Helicopters LLC · Girdwood, AKBuilt 2002 · S/N 3386N99508Lee Randall Ross · Houston, TXBuilt 1985 · S/N 17276456N9950DSierra Charlie Aviation LLC · Sandpoint, IDS/N 22-6738N9950QTymitz Peter A · Eagle River, AKBuilt 1955 · S/N 18-3563N9950WPlane Jane Aviation LLC · Lincoln, NEBuilt 1967 · S/N 28-23495N9950YAnders Rod D · Wasta, SDS/N 7GCB-156N99517Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276459N99519Alyeska Helicopters LLC · Girdwood, AKBuilt 2012 · S/N 2180N9951DDicenzo Eugene N · Cumberland, RIBuilt 1959 · S/N 22-6739N9951V9951v Aircraft Leasing LLC · Spanish Fork, UTS/N 17264569N99527Delta State University · Cleveland, MSBuilt 1985 · S/N 17276460N9952DLynch John E · Bourbonnais, ILBuilt 1959 · S/N 22-6740N99532Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276462N9953DNiner Niner Five Three Delta LLC · Marshall, WIS/N 22-6742N9953UCarey William H · Henderson, NVS/N AA1C0169N9953YBlock Larry F · Palmer, AKS/N 7GCB-157N9954DJoy Derek T · Bad Axe, MIBuilt 1959 · S/N 22-6743N99553Jka LLC · Notasulga, ALBuilt 1985 · S/N 17276465N99554Briner Micah · Martinsville, INBuilt 1977 · S/N C-1N9955CBrenna Matt R · Austin, TXBuilt 1978 · S/N R18200491N9955QWerba Travis J · Anchorage, AKBuilt 1955 · S/N 18-3918N9955RWhitefish Mountain Acft Rentals & Flt School LLC · Whitefish, MTS/N TD-426N9955UMatteson Gary E · Monmouth, ORBuilt 1977 · S/N AA5A0355N9956RMiga Holdings LLC · Flower Mound, TXBuilt 1960 · S/N TD-394N9956TSanderson Michael · Newberg, ORBuilt 1988 · S/N 2346N9957DLinett Michael J · Elsmere, DEBuilt 1959 · S/N 22-6746N9957EReisman Richard H · Montrose, COBuilt 1979 · S/N 17272298
Back to AD 81-18-04 R2