OpenAirDocs.org
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.

N4781JWyatt Steven Joseph · Caddo Mills, TXBuilt 1967 · S/N MB-231N4781LPhillips James W · Lancaster, SCBuilt 1967 · S/N 28-4116N4781ZM Forden LLC · Pana, ILBuilt 1961 · S/N 22-8343N47820Vascular Wings LLC · Friendswood, TXBuilt 1977 · S/N 28-7890139N47824Morris-Reade Jeffrey M · Blaine, WABuilt 1977 · S/N 28-7890140N4782GSeguin Elliot · Rosamond, CABuilt 1968 · S/N 77N4782POlson Allan K · Tarpon Springs, FLBuilt 1960 · S/N 27-338N4782RSchulert Peter A · Lebanon, TNBuilt 1979 · S/N 172RG0030N4782TJordan Kevin · Brookline, NHBuilt 1972 · S/N 28-7225204N4783Haire Kenneth H · Star City, ARS/N 93N47833Rtt Aviation LLC · Columbus, NEBuilt 1977 · S/N 28-7816138N47835Paddock Andrew S · Ainsworth, NES/N 28-7816139N47837Kolek Kirk A · Marion, IABuilt 1977 · S/N 28-7816141N47839Ohara Daniel J · Naknek, AKS/N 28R-7837006N4783LSikka Dhruv · Lutz, FLBuilt 1967 · S/N 28-4118N4783PBush Robert Edward · Mead, WABuilt 1977 · S/N AA5B-0526N4783WCmt Properties Inc · Dover, DEBuilt 1976 · S/N 14113N4784AFox Aviation International Inc · Justin, TXBuilt 1979 · S/N A1520891N4784EPeabody Jeffery L · Vinemont, ALBuilt 1978 · S/N 17271649N4784GShinn Steven M Allen · Larkspur, COBuilt 1973 · S/N 131N4784HKjeldgaard James K · Fremont, NEBuilt 1948 · S/N 11-737N4784JSale Reported · Crystal, MNSale reportedBuilt 1967 · S/N MB-220N4784LDelta Sierra LLC · Naples, FLBuilt 1967 · S/N 28-4119N4784YBig Sky Jet Inc · Bozeman, MTBuilt 1968 · S/N 25-4553N47856Vector-USA LLC · Olive Branch, MSBuilt 1979 · S/N 15283258N4785BBravo Zulu Aviation LLC · Torrance, CAS/N 15283633N4785FSoaring Society Of Boulder Inc · Boulder, COBuilt 1962 · S/N 18-7906N4785LTranswestern Air Service Inc · Golden, COBuilt 1967 · S/N 28-4120N4785SSchiller Matt D · San Francisco, CABuilt 1979 · S/N R18201426N4785YSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1968 · S/N 25-4556N4785ZMeigs David C · Phoenix, AZS/N 22-8349N47868Heartland Airplanes LLC · Olathe, KSFirst renewal noticeS/N 28-7890147N47869N47869 LLC · Spanish Fork, UTBuilt 1977 · S/N 28R-7837008N4786ETu Erik S · Pasadena, CABuilt 1978 · S/N 17271651N4786LZayas Omar · Fontana, CABuilt 1967 · S/N 28-4122N4786PAce High Aviation LLC · Long Beach, CAS/N 15284816N4786SMultiprop Ventures LLC · Danvers, MABuilt 1979 · S/N R18201427N4787AStock Matthew D · Clarence, NYBuilt 1956 · S/N 22-3938N4787ESilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1978 · S/N 17271652N4787SClassic Image Auto LLC · Huntsville, ALS/N R18201428N4787ZIdaho Airplanes LLC · Boise, IDS/N 22-8351N47880Halmon Henry W · Manvel, TXBuilt 1997 · S/N 2500N47881Griffin Jack D · Hamilton, OHBuilt 1977 · S/N 28-7816151N47882Pray Aviation Inc · Augusta, KSBuilt 1977 · S/N 28-7816152N47885Dynasty Adventure Inc · Mentone, CABuilt 1977 · S/N 28-7890148N47886N47886 LLC · Dover, DEBuilt 1977 · S/N 28-7890149N4788DJb Aviation Flight School Inc · Wonder Lake, ILBuilt 1979 · S/N 17272359N4788ETiernan Jeffery P · Waddington, NYBuilt 1978 · S/N 17271653N4788VM Fujii Inc · Costa Mesa, CABuilt 1980 · S/N 172RG0378N47899Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1977 · S/N 28-7816153
Back to AD 81-18-04 R2