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.

N64067Duvall Chris D · Tahlequah, OKBuilt 1975 · S/N 17264998N64069Whiskey Tango Aviation LLC · Keene, NDBuilt 1981 · S/N 17275515N6406HRizzo John Jr · Dunnellon, FLBuilt 1946 · S/N 19587N6406JAntonovich Thomas W · Mesa, AZBuilt 1968 · S/N 28-4823N6406QHilten Robert W · Columbus, MTBuilt 1967 · S/N 670146N64074Green Norman D · Lake City, FLBuilt 1975 · S/N 17265000N64079Portneuf Holdings LLC · Chubbuck, IDBuilt 1981 · S/N 17275516N6407DWalo Enterprises LLC · Aurora, COBuilt 1979 · S/N 17272790N6407JSleepy Creek Farm - Ga LLC · Gray, GABuilt 1968 · S/N 28-4824N6407LVetter Johnathon A · Moundridge, KSFirst renewal noticeBuilt 1972 · S/N AA1A-0407N6407PSmith Wesley K · Billings, MTBuilt 1959 · S/N 24-1517N6407RKubisiak Steven F · Amherst, WIBuilt 1966 · S/N 28-21586N6407VWard Matthew A · Fort Worth, TXBuilt 1980 · S/N 172RG0669N6407WDoeden Patricia · Hillsborough, NCBuilt 1964 · S/N 28-20476N64081Burrows Donna M Trustee · Grain Valley, MOBuilt 1975 · S/N 17265004N64082Mcdonald Douglas W Sr · Cornelia, GABuilt 1975 · S/N 17265005N64087California Airways LLC · Hayward, CABuilt 1981 · S/N 17275519N6408ASpecialty Aero LLC · Creswell, ORBuilt 2000 · S/N 22079N6408DRuple Farms Inc · Pleasanton, TXS/N 18-908N6408GWebb Joe R · Union, WABuilt 1979 · S/N 17273594N6408JGish David L · Mooresville, NCBuilt 1968 · S/N 28-4825N6408UMckee Michael S · Piney Creek, NCBuilt 1962 · S/N 2155N64092Falcon William D · Elkhorn, WIS/N 17265012N64095Righthand 2004 LLC · Charlotte, NCBuilt 1975 · S/N 17265015N64096Bissey Roy H II Trustee · Big Horn, WYBuilt 1975 · S/N 17265016N6409CCrider Richard S · Prescott, AZS/N 32-7840083N6409DMontgomery Aviation LLC · San Diego, CABuilt 1979 · S/N 17272791WPN6409LKirkpatrick Joshua · Cleburne, TXBuilt 1972 · S/N AA1A-0409N6409MCendejas Agustin · Chino, CABuilt 1980 · S/N 15284713N6409QButz Kyle W · Swanton, OHBuilt 1967 · S/N 670149N6409RFly 365 Ltd · Montrose, COBuilt 1966 · S/N 28-21588N6409UJohnson Lynn · San Diego, CAS/N 2156N640CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281518N640DGGeese Douglas A · Churubusco, INBuilt 2009 · S/N DAG-20041N640FTFlorida Institute Of Technology · Melbourne, FLBuilt 2008 · S/N 2842317N640JFHarwell Benny M · Yelm, WABuilt 2001 · S/N S 9805-0156N640KRCarson Michael W · Oxnard, CABuilt 2011 · S/N 71028N640MGAviate LLC · Green Bay, WIBuilt 1975 · S/N 17265248N640NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881145N640RHNagler Matthew Todd · Omaha, NEBuilt 1975 · S/N BH120/310N640SAMcm Aircraft LLC · San Antonio, TXBuilt 2005 · S/N S-0003N640SPJet Air Inc · Iowa City, IABuilt 1998 · S/N 172S8048N640SUThrush Robert L · Bandon, ORBuilt 2006 · S/N 20834N640TCWingsleasing LLC · Wichita, KSS/N 2843491N64103Parra Raymond · Miami, FLS/N 17275522N64106Long Leslie Bruce Jr · New Durham, NHBuilt 1981 · S/N 17275523N64107Cmbb Enterprises LLC · Plainview, TXBuilt 1975 · S/N 17265023N64108Wiater Mark S · Crete, ILBuilt 1975 · S/N 17265024N6410JNoggle George · Bucyrus, OHBuilt 1968 · S/N 28-4827N6410PMac Duffie Phillip J · Port Orange, FLBuilt 1959 · S/N 24-1520
Back to AD 81-18-04 R2