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.

N3736KBloom Cory G · Indianola, IABuilt 1967 · S/N 28-23713N3736PKelly Larry M · Alexander City, ALBuilt 1955 · S/N 22-3456N3736TVelivis Bernard K · Hollis, NHBuilt 1967 · S/N 28R-30045N3736WLarsen Christopher R · West Melbourne, FLBuilt 1966 · S/N 32-650N3736XSmith William C · San Antonio, TXBuilt 1968 · S/N 5045N3737MMathur Arvind Kishore · Hemet, CABuilt 1978 · S/N 32-7840071N3737TKenny David Jack · Frederick, MDBuilt 1967 · S/N 28R-30046N3737UAirria Holdings LLC · BerlinBuilt 1980 · S/N ME-379N3737WVoss James S · Soldotna, AKS/N 32-651N3738MAnsell Nathan D · Mukwonago, WIS/N 32R-7885013N3738WNewton Machine Co Inc · Charlotte, NCBuilt 1966 · S/N 32-652N3739MAdair Steven M · Collierville, TNBuilt 1947 · S/N 12-2676N3739QN3739q LLC · Colleyville, TXFirst renewal noticeBuilt 1982 · S/N ME-378N3739WPacific Gold Aviation Association · Roseville, CABuilt 1966 · S/N 32-653N373BSPenn Mitchell · Poplar Bluff, MOBuilt 1969 · S/N 28-26555N373CACoco Aircraft Inc · Merritt Island, FLBuilt 1988 · S/N 2841014N373CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2844174N373CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281986N373EWBaker Sheryl Wolff · Elbert, COS/N 80476N373GHHaley Greg W · Frankston, TXBuilt 2013 · S/N 73495N373JWSousek Samuel V II · Shawano, WIBuilt 2020 · S/N 70373N373MKNorth Star Aviation · Mankato, MNBuilt 2025 · S/N 2881986N373RPHoward Mark C · Edmond, OKBuilt 2001 · S/N 3212N373SAnderson Thomas · Brooklyn, NYBuilt 1995 · S/N 1N373SAValiair Lc Trustee · Casper, WYBuilt 2019 · S/N 18283087N373SERegistration Pending · Phoenix, AZRegistration pendingBuilt 1996 · S/N 18-506N3740BWood Graham A · Marshall, WIS/N WA-186N3740TBibbey Mark A · Chandler, AZBuilt 1967 · S/N 28R-30049N3740XBarnato Peter M · Twain Harte, CABuilt 1968 · S/N 5050N3740ZCarl Eric Storm Trustee · Eagle River, AKBuilt 1966 · S/N 18-7496N3741APrice John C · Bennington, KSBuilt 1953 · S/N 22-1984N3741TIowair Inc DBA · Atkins, IABuilt 1968 · S/N 28R-30957N3741ZStanton Morgan · Anchorage, AKBuilt 1963 · S/N 18-7497N3742FBenson Edward A · San Antonio, TXBuilt 1977 · S/N 0755N3742WRibas Daniel · Atascadero, CABuilt 1966 · S/N 32-656N3742XHancock John R · Poplarville, MSBuilt 1968 · S/N 5052N3743PBulldog Aviation LLC · Ely, MNBuilt 1955 · S/N 22-3463N3743QTonneson Rollin J · Souris, NDBuilt 1977 · S/N 28-7790464N3743XHenderson Douglas A · Springerville, AZBuilt 1968 · S/N 5053N3744APhillips Mark W · New Underwood, SDBuilt 1954 · S/N 22-1987N3744PCaplinger Jimmy C · Justin, TXBuilt 1955 · S/N 22-3464N3744TAg Air Squadron One LLC · Saint Joseph, ILBuilt 1967 · S/N 28R-30054N3744XLongwill Dusty J · Raton, NMBuilt 1968 · S/N 5055N3744YKt 2022 LLC · Broomfield, COBuilt 2020 · S/N 172S12435N3744ZWild About Nature LLC · Fairbanks, AKBuilt 1960 · S/N 18-7502N3745ADock Engineering Inc · Stillwater, OKBuilt 1995 · S/N 1996-LN3745KMangels Christopher L · Wasilla, AKBuilt 1946 · S/N 1438N3745THill James C · Grand Saline, TXS/N 28R-30055N3745VHill Lesly G · Folsom, CABuilt 1948 · S/N 15022N3745ZFlint Paul L · Anchorage, AKBuilt 2001 · S/N 001
Back to AD 81-18-04 R2