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.

N7321BAdvanced Aviation School LLC · Venice, FLBuilt 1977 · S/N A1520743N7321FWebster Joshua P · West Rutland, VTBuilt 1968 · S/N 28-25231N7321MWood Robert B · Woods Cross, UTBuilt 1958 · S/N 55621N7321PTappan East LLC · New Philadelphia, OHBuilt 1961 · S/N 24-2498N7322DRainey William F III · Mt Pleasant, TNBuilt 1957 · S/N 22-5110N7322FEdixon James Richard II · Cameron Park, CAS/N 28-25189N7322KBudd Douglas N · Crawford, NEBuilt 1950 · S/N 20-232N7322PRuple Michael D · Palm Bay, FLBuilt 1961 · S/N 24-2499N7322WLocum Mike M · Sparta, TNBuilt 1963 · S/N 28-1190N7323DWilkerson Dwight T · Kirkland, WABuilt 1957 · S/N 22-5111N7323GSpiker Jeffrey A · Granville, OHBuilt 1970 · S/N 17259023N7323PCrawford Patricia C · Denton, NCBuilt 1961 · S/N 24-2500N7323WHigh Desert Skys LLC · Blackfoot, IDS/N 28-1192N7323YFoster Jay W · Marshfield, MOBuilt 1964 · S/N 30-367N7324DRuach LLC · Wilmington, DES/N 22-5112N7324KBurley Joseph D · Fayetteville, GABuilt 1950 · S/N 20-230N7324PWright Havis L · Pleasant Hill, MOBuilt 1961 · S/N 24-2502N7324WFerreira Barney Manuel · Truckee, CAS/N 28-1193N7324YMccaslin Dale Alan Trustee · Holt, MOBuilt 1964 · S/N 30-369N73250Skaya Aircraft LLC · Buford, GABuilt 1976 · S/N 17267337N73254Swensen Jason D · Norfolk, NEBuilt 1976 · S/N 17267338N7325JBasco Richard A · Charlotte, NCBuilt 1968 · S/N 28-24678N7325KMouton Charles J Jr · Gladewater, TXBuilt 1950 · S/N 20-233N7325SVineyard View Aviation Inc · Napa, CABuilt 1981 · S/N R18201705N7325WMitchell Lawrence Jr · Steubenville, OHFirst renewal noticeBuilt 1963 · S/N 28-1195N73262Air Spacers Inc · Santa Monica, CABuilt 1976 · S/N 17267342N73267Schutze Eric D · Ojai, CABuilt 1976 · S/N 17267344N7326DAllen Jason J · Benson, NCBuilt 1957 · S/N 22-5114N7326EMountain South Aviation LLC · Telford, TNS/N 17272085N7326FByrd Jonathan L · Rome, GAS/N 28-25235N7326KSiebert Mark R · Monticello, MNBuilt 1950 · S/N 20-234N7326PHarris David M · Costa Mesa, CABuilt 1961 · S/N 24-2504N7326WHeinze William J · Ashley, MIBuilt 1963 · S/N 28-1196N7326YHighsky Aero Inc · Arlington, TXBuilt 1964 · S/N 30-371N7327DFrankfort Flying Club Inc · Beulah, MIBuilt 1957 · S/N 22-5115N7327FAirconrad LLC · Duncansville, PAS/N 28-25236N7327JWhite Benjamin M · Hallsville, TXBuilt 1968 · S/N 28-24681N7327PTown Terry N · Lake Havasu City, AZBuilt 1961 · S/N 24-2505N7327WCerto Russell · Grand Island, NYBuilt 1963 · S/N 28-1198N7327YGeyman Edward J · Wilmington, OHBuilt 1964 · S/N 30-372N73289Correggio James · Shapleigh, MEBuilt 1976 · S/N 17267346N7328CGuiver Douglas G · Mesquite, NVBuilt 2003 · S/N 60582N7328GShort Larry D DBA · Allen, KYBuilt 1970 · S/N 17259028N7328JNightline Air LLC · Saratoga Springs, UTBuilt 1968 · S/N 28-24682N7328PCoffee Bean Connoisseur LLC · Highland, NYBuilt 1961 · S/N 24-2506N7328YBarnett David K · Brock, TXS/N 30-374N73293Shawano Flying Service Inc · Shawano, WIBuilt 1976 · S/N 17267349N73294G And G Maintenance Corp · Miami, FLBuilt 1976 · S/N 17267350N73295Whitten Chris D · Townville, SCBuilt 1976 · S/N 17267351N73296Han Farms Inc · Inverness, MTBuilt 1976 · S/N 17267352
Back to AD 81-18-04 R2