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.

N6154HTravis Air Force Base Aero Club · Travis Afb, CABuilt 1977 · S/N 28-7890212N6154MPeeler John · Cottonwood Heights, UTBuilt 1978 · S/N 7177CN6154PLonhart Donald E · Greeley, COBuilt 1959 · S/N 24-1255N6154QViman LLC · Bear, DEBuilt 1981 · S/N 15285174N61557Angle Of Attack LLC · Boise, IDBuilt 1975 · S/N 17264638N6155DCurtis Jeremy A · Fairbanks, AKBuilt 1957 · S/N 22-4802N6155JAnderdoc Aviation Inc · Wilmington, DEBuilt 1974 · S/N AA50503N6155KFreeway Airport Inc · Mitchellville, MDBuilt 1980 · S/N 17274170N6155LPeterson Walter R · Appling, GABuilt 1970 · S/N AA1-0355N6155PSturm Steve G Trustee · Springdale, ARBuilt 1959 · S/N 24-1256N6155QFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1981 · S/N 15285175N61566Modin John · El Dorado Hills, CABuilt 1974 · S/N 17264644N61567Enzyme Holdings LLC · Wilmington, DEBuilt 1975 · S/N 17264645N6156WHousley Steven W · Hot Springs, SDS/N 28-20175N6156XMathews Dale M · Fairbanks, AKBuilt 2021 · S/N 003N61571Engineers Flying Club Inc · Bethany, OKBuilt 1975 · S/N 17264648N61573Registered aircraftS/N 17264650N61574Bruns Michael Wesley · Scottsdale, AZBuilt 1974 · S/N 17264651N61577Ingle Daniel B · Coraopolis, PABuilt 1975 · S/N 17264653N6157DBadinelli Ralph D · Blacksburg, VABuilt 1957 · S/N 22-4804N6157FLa Placa Peter · Lake Havasu City, AZBuilt 1973 · S/N A1500434N6157JSale Reported · Columbus, OHSale reportedBuilt 1976 · S/N 28-76-25224N6157LMelcher Robert L Trustee · Muskego, WIBuilt 1970 · S/N AA1-0357N6157PFrazier Jon A · Vista, CABuilt 1959 · S/N 24-1258N6157SKearley Christopher · Assonet, MABuilt 1980 · S/N R18201632N6157WLaminar Skies Aviation LLC · Broken Arrow, OKBuilt 1964 · S/N 28-20176N6157XBluesky Geospatial Ltd · North Adams, MABuilt 1960 · S/N 500A-1009-37N61581Brat Equipment Co LLC · Slinger, WIBuilt 1975 · S/N 17264655N61585Mele Michael L · Fairview, ORBuilt 1975 · S/N 17264658N61586Evalt Ralph D II · Dillingham, AKS/N 17264659N61588L&W Aircraft Investment LLC · Homestead, FLBuilt 1975 · S/N 17264661N6158GCag Aircraft Holdings LLC · Crystal River, FLBuilt 1979 · S/N 17273573N61594Hawk Aviation Inc · Rush City, MNBuilt 1975 · S/N 17264664N6159DDavis James J · Beaver Dam, WIBuilt 1957 · S/N 22-4806N6159JSmathers James R Jr · Mission Viejo, CABuilt 1976 · S/N 28-7615316N6159LLuciano Nicolas · Harlingen, TXBuilt 1970 · S/N AA1-0359N6159NCrothall George · Oceanside, CABuilt 1978 · S/N 38-78A0069N6159RBagamaspad Alan M · Reseda, CABuilt 1979 · S/N 172RG0098N6159WSale Reported · San Luis Obispo, CASale reportedBuilt 1964 · S/N 28-20178N615ADontje Robert E · East Moline, ILS/N 22-18N615ADHill Douglas L · Berrien Springs, MIBuilt 1946 · S/N 12-229N615EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12716N615FTFlorida Institute Of Technology · Melbourne, FLBuilt 1980 · S/N 28-8116123N615JSPollak Steven D · Cincinnati, OHBuilt 2003 · S/N 1388-2003N615KAKoerner Alex J · Kankakee, ILBuilt 2003 · S/N 22347N615MADowling Thomas · Mechanicville, NYBuilt 2004 · S/N 1372-2004N615PDRegistered aircraftBuilt 2026 · S/N 42498N615PMMcclanahan Luke D · Midland, TXBuilt 1993 · S/N MK0051N615PSSanchez Peter J · Sioux Falls, SDS/N 40267N615RKKunz Russell G · Neosho, WIBuilt 2014 · S/N CH405
Back to AD 81-18-04 R2