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.

N6905VOscar Mike Appraisal Group LLC · Greenville, SCBuilt 1975 · S/N 20-1175N6905WPodeweltz Wayne L · Merrill, WIBuilt 1965 · S/N 28-21071N6905ZZellers And Smith Enterprises LLC · Flowood, MSBuilt 1968 · S/N 28R30649N69066Lake Elmo Aero LLC · Lake Elmo, MNBuilt 1978 · S/N 15282470N6906KWilliams Don D · Athens, ALS/N 20-9N6906PKapeller James A · Wickenburg, AZFirst renewal noticeBuilt 1960 · S/N 24-2040N6906QFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1967 · S/N MB-283N6906VMatthews Cheryl L · Baker City, ORS/N 20-1176N6906WStandard American Adjusters Inc · Alba, TXS/N 28-21072N69078Central Texas College · Killeen, TXBuilt 1981 · S/N 15285345N6907BJordan Walter B · Chehalis, WABuilt 1956 · S/N 22-4182N6907NHensley Tyler · Leland, NCBuilt 1968 · S/N 680136N6907PHolbein Mark A · Freeport, PAS/N 24-2041N6907VPounds Gregory S · Sykesville, MDBuilt 1975 · S/N 20-1177N6908BMeriden Aviation Center LLC · Meriden, CTBuilt 1985 · S/N 28-8516050N6908KRegistration Pending · Dillingham, AKRegistration pendingBuilt 1950 · S/N 20-12N6908UPaul Michael · Fort Worth, TXBuilt 1964 · S/N 2703N6908VForoozesh Paymon Michael · Olalla, WABuilt 1975 · S/N 20-1178N6909BKaufmann Arnold L · Davenport, IABuilt 1956 · S/N 22-4184N6909KJersey Devil Dusters LLC · Southampton, NJBuilt 1950 · S/N 20-14N6909NDevore John A C · Marion, OHS/N 680174N6909PWest Texas Weather Modification Association · San Angelo, TXBuilt 1960 · S/N 24-2043N6909QHuston Lee E · Graham, WABuilt 1967 · S/N MB-281N6909UVandivort Austin J · Strawberry Plains, TNS/N 2704N690ABKirkland Klayton E · College Station, TXS/N B-001N690BLincwings Society LLC · Austin, TXBuilt 1955 · S/N 23-382N690HAAims Community College · Greeley, COBuilt 2025 · S/N 2881865N690JTAviationmt LLC · Kalispell, MTS/N 28-7205042N690LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881196N690PMMiddlefield Farm And Garden Co · Middlefield, OHBuilt 2024 · S/N 2881728N690RGRegistration Pending · Gurabo, PRRegistration pendingBuilt 1969 · S/N 274260N690SHCorriher Mark B · Mocksville, NCBuilt 1966 · S/N 132N690TSMartin Tony A · Kingwood, TXS/N 177RG0384N690VBruegger Traylin T · Lance Creek, WYBuilt 1990 · S/N 20051N690ZKalisz John B · Newhall, CABuilt 1992 · S/N 2029N691Rice James L · Mckinney, TXBuilt 1958 · S/N 3N69104Giger Janice F · Weston, ORBuilt 1978 · S/N 15282484N6910DWood Robert A · Sheboygan, WIBuilt 1957 · S/N 22-4837N6910JPlane Nonsense Inc · Middletown, DEBuilt 1976 · S/N 28-7615395N6910NThornton Michael W · Clinton, NCBuilt 1968 · S/N 680137N6910PBlue Skies Aviation LLC · Algona, IABuilt 1985 · S/N 28-8511008N6910UEmbrey Quentin S · Beaver Dam, KYBuilt 1964 · S/N 242N6910VLehman Aubrey M · Temple, TXS/N 22-1290N69110Zumbrun Dennis · Montz, LABuilt 1978 · S/N 15282488N6911HHarbour Aviation LLC · Weatherford, TXBuilt 1975 · S/N 17265639N6911JJacksonville Airport Authority · Jacksonville, ILBuilt 1976 · S/N 28-7615396N6911KHatley Sean P · Mount Horeb, WIBuilt 1950 · S/N 20-16N6911PMalo Blake Ridgway Trustee · Portland, ORBuilt 1985 · S/N 28-8590050N6911QKirby Richard L Trustee · Albuquerque, NMBuilt 1985 · S/N 28-8511009N69121Everett Rylan C · Broken Bow, NES/N 15282496
Back to AD 81-18-04 R2