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.

N9639TBasinger Kenneth J · Mcdonough, GABuilt 1978 · S/N 38-78A0149N9639UAslaksen Jay P · Richmond, TXBuilt 1975 · S/N AA5A-0005N9639WUlmer Daniel J · Menno, SDBuilt 1967 · S/N 28-23097N963ACYoung Paul J · Hudson, MABuilt 1999 · S/N 172S8259N963AUAuburn University · Auburn University, ALBuilt 2020 · S/N 172S12478N963AYStark Truss Co Inc · Canton, OHBuilt 1982 · S/N R18201908N963CCMansfield Heliflight Inc · Milton, VTBuilt 1989 · S/N 1013N963CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281973N963EAEcho Alpha Aero LLC · Saint Petersburg, FLBuilt 1962 · S/N 2256N963EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2023 · S/N 172S13007N963JKeith William F · Bakersfield, CABuilt 1962 · S/N 24-3195N963JADeland Aviation LLC · Deland, FLBuilt 2007 · S/N 172S10521N963KMMiller Karl E Trustee · Chandler, AZBuilt 1974 · S/N 17264198N963LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12033N963MRAerospace Trust Management LLC · Wilmington, DEBuilt 1967 · S/N 28-10838N963MSMount San Antonio College · Walnut, CABuilt 1982 · S/N 15285655N963NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 2881888N963PPopp Timothy L · Sun City, AZBuilt 2012 · S/N 70634N963RDBloxom Chase L · Josephine, TXBuilt 1993 · S/N JS001N963RVRoberts Jim E · Portland, ORBuilt 1997 · S/N 001N963SPAero Aircraft 11 LLC · Jacksonville, FLBuilt 1999 · S/N 172S8166N963TASvetfur Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9610N963TBOpdyke Tod J · Concord, CABuilt 1976 · S/N 14158N963TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881963N963TTAmerican Capital Aviation LLC · Kalispell, MTBuilt 2020 · S/N 1189-2020N963WCCavorite Aviation LLC · Lehi, UTBuilt 2000 · S/N 2843381N9640HCorriher Mark B · Mocksville, NCBuilt 1975 · S/N 17266287N9640LRice Mark A · Independence, ORBuilt 1973 · S/N AA1B-0140N9640MDavis Psychological Services Pc · Grinnell, IABuilt 1966 · S/N 670217N9640SFrancis James E · King City, CABuilt 1966 · S/N 6N9640VN9640v LLC · Ann Arbor, MIS/N 17264420N9641HBarton Alva L · Hollister, CABuilt 1975 · S/N 17266288N9641JRegistration Pending · Fresno, CARegistration pendingS/N 28-3865N9641KWempen Steven R · Assumption, ILBuilt 1976 · S/N 28-7615221N9641QBhairavi Aviation LLC · Santa Clarita, CABuilt 1975 · S/N 17265725N9641UHunt David C · Middlebury, CTBuilt 1975 · S/N AA5A-0007N9641VRink Douglas B · Woolwich, MEBuilt 1974 · S/N 17264421N9641WHoover Anna L · Anchorage, AKBuilt 1967 · S/N 28-23100N9642CBarts Flying Service Inc · Storm Lake, IABuilt 1978 · S/N 28-7816509N9642DMalsom Isaac B · Box Elder, SDBuilt 1959 · S/N 22-6556N9642JSafety First Flying · Murphysboro, ILS/N 28-3870N9642PSouthern California Soaring Academy Inc · Valencia, CABuilt 1976 · S/N 25-7656023N9642RAvian Flight Center Inc · Bremerton, WABuilt 1959 · S/N TD-328N9642STaylor Jonathan K II · Granbury, TXBuilt 1966 · S/N 3N9642WN9642w Leasing LLC · Corunna, MIBuilt 1967 · S/N 28-23101N9643DBlumhorst Ricky W · Paola, KSBuilt 1959 · S/N 22-6557N9643EEl Gato Grande Aviation LLC · Philadelphia, PABuilt 1977 · S/N 77-32-169N9643HMor Aviation N9643h LLC · Gaithersburg, MDBuilt 1975 · S/N 17266290N9643JHitchings Fred · Chesapeake, OHBuilt 1967 · S/N 28-3871N9643LBrockett William F · Rapid City, SDBuilt 1973 · S/N AA1B-0143
Back to AD 81-18-04 R2