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.

N9529SRegistered aircraftBuilt 1965 · S/N 331N9529WFlight Operations Aircraft LLC · Wilmington, DEBuilt 1998 · S/N 17280470N952AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843804N952DAEppes Michael Scott · Austin, TXBuilt 1995 · S/N 3213103N952EROliver Lawrence G · Lewiston, MEBuilt 2011 · S/N 1109-2011N952GSStiffler Gary C · Goshen, OHBuilt 1974 · S/N AA1B-0434N952JAHuerta Holdings Inc · Santa Ana, CABuilt 2007 · S/N 172S10474N952JCCarver Jonathan E · Oxford, NCBuilt 2004 · S/N 5282N952LCThorx Aviation LLC · Tampa, FLBuilt 2007 · S/N 40021N952MKhan Mohsin H · Lodi, CABuilt 1966 · S/N 3364N952NDUniversity Of North Dakota · Grand Forks, NDBuilt 2020 · S/N 2881370N952SCMike Charlie Aviation LLC · Scottsdale, AZBuilt 2014 · S/N 172S11406N952SHNelson Chris · Crown Point, INBuilt 2005 · S/N 3920N952SMBarnes Kingsley · Springfield, MOBuilt 2002 · S/N 21074CN952TBLong Jacob · Bend, ORBuilt 2011 · S/N 25074N952TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881952N952WAMcenery William J · East Haddam, CTBuilt 1973 · S/N 394-73N95302Wright David W · Arlington, TXBuilt 1969 · S/N 28-25878N95303Morrison Robert F II · Denton, TXS/N 28-25879N95305Eagle Aviation Inc · Tucson, AZFirst renewal noticeBuilt 1969 · S/N 28-25880N9530BSierra Alpha Aeronautical LLC · San Antonio, TXBuilt 1981 · S/N 172RG0858N9530HHorizon Aircraft Sales & Leasing Inc · Chesapeake, VABuilt 2013 · S/N 172S11295N9530JNations Jeffrey L · Kingshill, VIS/N 28-3657N9530LClark Dale H · Discovery Bay, CABuilt 1974 · S/N AA5-0530N9530URegistered aircraftBuilt 1977 · S/N AA1C0026N9530WGateway Flight Training LLC · Saint Louis, MOBuilt 1967 · S/N 28-22958N95314Menagerie Enterprises Inc · Denison, TXBuilt 2014 · S/N 172S11403N95315Valencic Adam · Apopka, FLBuilt 1969 · S/N 28-25885N9531DAtp Aircraft 4 LLC · Wilmington, DEBuilt 1999 · S/N 17280473N9531JGrayhawk Flight Training LLC · Lucas, TXBuilt 1966 · S/N 28-3658N9531KCline Timothy E · Rome, GABuilt 1976 · S/N 28-7610104N9531LBaker Bob E · Carmichael, CABuilt 1974 · S/N AA5-0614N9531MWright Bradley S · Quitaque, TXS/N 670108N9531UClarke Adam M · Lompoc, CAS/N AA1C0027N95327Seashell Aviation LLC · Milton, FLBuilt 1969 · S/N 28-25889N95329Jay Stylz Trucking LLC · Cedar Rapids, IABuilt 1969 · S/N 28-25891N9532DPayne Frederick B · Fayetteville, GABuilt 1958 · S/N 22-6448N9532JHarris Jason L · Clanton, ALFirst renewal noticeBuilt 1966 · S/N 28-3659N9532LShattuck Charles W · Goshen, CTBuilt 1974 · S/N AA5-0532N9532PAerial Banners North Inc · Pembroke Pines, FLBuilt 1974 · S/N 25-7405618N9532URosenkranz James H · Garland, TXBuilt 1977 · S/N AA1C0028N9532WRodriguez Santos Jr · West Plains, MOS/N 28-22960N9533GSmith James R · Delaware, NJBuilt 1998 · S/N 18280354N9533JWadel Ronald A · Shippensburg, PABuilt 1966 · S/N 28-3660N9533MHattensty Robert Wade · Burleson, TXBuilt 1966 · S/N 670110N95343Obert Megan E · Hartselle, ALBuilt 1969 · S/N 28-25896N95346Jackson Douglas A · Cynthiana, KYBuilt 1969 · S/N 28-25512N95347Jora Imports LLC · Atlanta, GABuilt 1969 · S/N 28-25728N9534DLevinson Isaac F · White Salmon, WAS/N 22-6450N9534HBotezatu Florin · Gig Harbor, WABuilt 1975 · S/N 17266208
Back to AD 81-18-04 R2