OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,720

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.

N152TRWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281247N152UCSkylink Xpress Inc · San Bernardino, CABuilt 1978 · S/N 15281879N152UFWest Valley Flying Club · Palo Alto, CABuilt 1979 · S/N 15284001N152VPConservation Aviation LLC · Washington, DCBuilt 2011 · S/N GA8-11-160N152WBing Kenneth · Millersport, OHS/N 15282154N152WAAces High Aviatio LLC · Long Beach, CABuilt 1979 · S/N 15283845N152WHBecker Steven Hollyfield · New Meadows, IDBuilt 1977 · S/N 15279700N152XTDiaz Alcides L · Archbald, PABuilt 1979 · S/N A1520907N15304Smeltzer And Sons Inc · Cape May C H, NJBuilt 1972 · S/N 28-7310032N1530JCountry Club Mortgage LLC · Grain Valley, MOBuilt 1967 · S/N 28-23929N1530XQualitair LLC Trustee · MichelstadtBuilt 1975 · S/N 28R-7535312N15310N15310 LLC · Alexandria, VABuilt 1972 · S/N 28-7325035N15311Johnson Darin Charles · Wells, MNBuilt 1972 · S/N 28-7305055N15313Beine Gilbert J · Campbellsport, WIBuilt 1972 · S/N 28R-7335049N15319Merchant Jerry J · Bogata, TXBuilt 1972 · S/N 28-7325037N1531JPerception Prime LLC · Beverly, MABuilt 1967 · S/N 28-23931N1531RMorgan Virginia K · Artesian, SDBuilt 1975 · S/N AA5B-0031N1531VOneonone Flight Training LLC · Hagerstown, MDBuilt 1974 · S/N 17263648N15322Ofner Josef P · Canterbury, NHBuilt 1972 · S/N 28-7305056N15323Coastal Flight Inc · Tierra Verde, FLBuilt 1972 · S/N 28-7305057N15324Lewis Christopher Dean · Bettendorf, IABuilt 1972 · S/N 28R-7335050N15327Carey Nicholas Andrew · Glencoe, ILBuilt 1972 · S/N 28-7325040N1532JRosario Pamela Peralta · Orlando, FLBuilt 1967 · S/N 28-23932N1532RAdkins Todd D · Manassas, VABuilt 1975 · S/N AA5B-0032N1532VSutton Aviation LLC · Maunaloa, HIBuilt 1950 · S/N 18-572N15334Shuart Bruce E · Wantage, NJBuilt 1972 · S/N 28R-7335051N1533APearson Trevor · San Ysidro, CABuilt 1951 · S/N 20-729N1533EPhoenix East Aviation LLC · Daytona Beach, FLS/N 34-7350050N1533JTolmachoff Alex W · Rogers, TXBuilt 1967 · S/N 28-23933N1533PHager John S · Big Island, VAS/N 22-2398N1533RAnderson Michael · Byhalia, MSBuilt 1975 · S/N AA5B-0033N1533XBurkhardt Stacie M · Wasilla, AKBuilt 1975 · S/N 28-7505240N15343Bridger'S Hvac And Welding LLC · Milan, TNBuilt 1972 · S/N 28-7305061N1534ADelta Charlie Aviation LLC · Glendale, AZS/N 20-730N1534EStull Carl · Farmington, UTBuilt 1978 · S/N 17271038N1534HCooley Norbert · Elkton, MDBuilt 1975 · S/N 177RG0709N1534JChapman Melvin Newton II · Mishawaka, INBuilt 1967 · S/N 28-23934N1535White Philip E · Hudson Oaks, TXBuilt 2010 · S/N 3335N15354Stephen Swift · Justin, TXBuilt 1972 · S/N 28-7305062N15355Brandvold Larry J · Fairfield, MTBuilt 1972 · S/N 28-7310037N15358Daffer Jon T · Edgewood, NMBuilt 1972 · S/N 28-7310038N15359Kobberdahl Matthew T · Maple Grove, MNBuilt 1972 · S/N 28-7325046N1535AHerve Keith E · North Pole, AKBuilt 1951 · S/N 20-731N1535HStramer Todd Personal Representative · Hazelton, NDBuilt 1975 · S/N 177RG0710N15360Registered aircraftBuilt 1972 · S/N 28-7325047N15361Williams Darren M · Carthage, ILBuilt 1972 · S/N 28-7305063N15363Creativity Before Capital LLC · Tampa, FLBuilt 1972 · S/N 28-7310039N15367Labrousse Ronald E · Tidewater, ORBuilt 1972 · S/N 28-7325048N1536ACoughlin Edmund Timothy · Manlius, NYBuilt 1951 · S/N 20-732N1536RCape Cod Aero Club LLC · Falmouth, MABuilt 1975 · S/N AA5B-0036
Back to AD 81-18-04 R2