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.

N6482QStevenson Randall J · Wildwood, MOBuilt 1967 · S/N 680024N64831Obregon Ernest · Oakley, CABuilt 1978 · S/N 15281442N64834Golden Mahalo LLC · Sheridan, WYBuilt 1982 · S/N 17275632N6483JCimarron Flying Lc · Elkhart, KSS/N 28-4912N6483PLee Charles C · New Buffalo, MIBuilt 1959 · S/N 24-1601N6483UFalk Edward A · Seattle, WAS/N 2230N6483ZSpokane Soaring Society · Spokane, WABuilt 1962 · S/N 25-2002N64849Garcia Herbert A · Houston, TXBuilt 1981 · S/N 15285280N6484JMathis Flight Solutions LLC · Dubberly, LABuilt 1968 · S/N 28-4913N64859Leyva Maria · New Smyrna Beach, FLBuilt 1982 · S/N 17275636N6485HBentley Dan G · Worcester, NYBuilt 1979 · S/N 15284170N6485JYankee Flyers LLC · Berryville, VABuilt 1968 · S/N 28-4914N6485QWaller Drew · Bellville, TXBuilt 1967 · S/N 680027N6485WShades Daniel L · Tumwater, WABuilt 1965 · S/N 28-20560N64866Universal Aviators Academy Inc · El Monte, CABuilt 1982 · S/N 17275639N6486C86 Charlie Corp · Roscoe, ILBuilt 1978 · S/N 32R-7885029N6486JSpredemann Carl A · Emmett, IDBuilt 1980 · S/N 17273877N6486LHarrison Ashley L · Danbury, CTS/N 15284414N6486PBerg Alvin L · Overgaard, AZBuilt 1959 · S/N 24-1604N6486QHilhorst Kenneth E · Rocky Mount, NCBuilt 1967 · S/N 680028N6486UDof Aviation Inc · Schertz, TXBuilt 1962 · S/N 2233N6486WSommerfeld Jordan Maxwell · Kittanning, PABuilt 1964 · S/N 28-20561N6486ZSouthern Eagles Soaring Inc · Butler, GABuilt 1962 · S/N 25-2005N64875Air America Flight Center LLC · Daytona Beach, FLBuilt 1982 · S/N 17275642N6487DWayne County Airport Board · Monticello, KYBuilt 1979 · S/N 17272831N6487QGordon Jeff · Cleveland, OHFirst renewal noticeBuilt 1967 · S/N 680029N6487RNurney Steven P · Fountain Hills, AZBuilt 1966 · S/N 28-21678N6487UScheifele Gay F · Derwood, MDBuilt 1962 · S/N 2234N64882Blue Sky Flyers Inc · Greeley, COBuilt 1982 · S/N 17275643N6488JWccrt LLC · Enterprise, KSS/N 28-4918N6488PSooner Answer Service Inc · Edmond, OKS/N 24-1607N6488QClark Thomas L · Kingman, AZBuilt 1967 · S/N 680030N6488R6 Aerospace LLC · Albuquerque, NMS/N 28-21679N6488UWings Leman F · Richmond, CAS/N 2235N6488WKendall Ralph L Jr · Cape Coral, FLBuilt 1965 · S/N 28-20563N64891Executive Aircraft Resources LLC · Birmingham, ALBuilt 1978 · S/N 15281458N64892Montgomery Flying Club Inc · Montgomery, ALBuilt 1982 · S/N 17275644N64893Weitzel Laury D · Meadow, TXBuilt 1978 · S/N 15281459N64898Fazzini Pamela A · Sedona, AZBuilt 1978 · S/N 15281464N6489JPatten Jeffery D · Rapid City, SDBuilt 1968 · S/N 28-4920N6489MSouthern Illinois University Board Of Trustees DBA · Murphysboro, ILBuilt 1980 · S/N 15284753N6489QMccurry Aviation Company LLC · Weatherford, TXBuilt 1967 · S/N 680031N648CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12624N648FTFlorida Institute Of Technology · Melbourne, FLBuilt 2013 · S/N 2843708N648NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881164N648RHill Martin J III · Yorktown, VABuilt 1992 · S/N 20823N648SAFour Delta Tango LLC · Wilmington, DEBuilt 2005 · S/N S-0010N648SPHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1998 · S/N 172S8055N648TXStegemoeller Troy L · Idalou, TXBuilt 2009 · S/N 82487N648VKuitems Philip P · Mt Juliet, TNBuilt 1960 · S/N TD-340
Back to AD 81-18-04 R2