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.

N9473DZweifel Douglas L · Anchorage, AKBuilt 1959 · S/N 18-7019N9473JEncounter Inc · Piedmont, OKBuilt 1966 · S/N 28-3588N9473VBarcus Roger L · Saint Paul, MNBuilt 1970 · S/N 700039N9473WRohrer Stephen B · Decatur, GABuilt 1969 · S/N 28-11202N9473ZGoldstein Jeffrey Edward · Dix Hills, NYBuilt 1998 · S/N 18280165N9474BDiehl Greg · Angola, INBuilt 1981 · S/N 172RG0833N9474JGerber Dennis J · Liverpool, NYBuilt 1966 · S/N 28-3589N9474NA-G-E Corp · Fort Pierre, SDS/N 28R-35191N9474VCasa Patrick Greg · Albuquerque, NMBuilt 1970 · S/N 700061N9474WGoines Russel D · Highland, CABuilt 1968 · S/N 28-11204N9475DRoe Dennis N · Fairbanks, AKBuilt 1958 · S/N 18-6725N9475EBerzinis Wayne T · Windham, MEBuilt 1979 · S/N 17272275N9475FLewis Steve · Canyon, TXBuilt 1998 · S/N 18280153N9475PGorin Eugene · Cedar Grove, NJBuilt 1971 · S/N 24-4987N9475TJohnson Marc · Westland, MIBuilt 1978 · S/N 38-78A0109N9475WGiese Aerial Inc · Hoffman, MNBuilt 1968 · S/N 28-11205N94768Indian River Flying Club Inc · Rockledge, FLBuilt 1983 · S/N 15285782N9476FF & M Miya LLC · Hanford, CABuilt 1998 · S/N 18280208N9476HHelicopter Partners Inc · Wellington, FLBuilt 1975 · S/N 17266172N9476JNery Thomas A · Mansfield, MABuilt 1966 · S/N 28-3592N9476LJohnson Nicholas J · Cantonment, FLBuilt 1971 · S/N AA1A-0276N9476NScheigert Delbert F Jr · Tucson, AZBuilt 1969 · S/N 28R-35193N9477DJ H Miller & Son Inc · Saint John, WABuilt 1958 · S/N 18-6729N9477JMatthews Byron Kim · Hooper, UTS/N 28-3593N9477LSlipstream Aviation LLC · Carrollton, GABuilt 1986 · S/N 17276562N9477VMurnville Glenlove Flyers Ltd · Delaware, OHBuilt 1970 · S/N 700062N9477WBaker John E · Westfield Center, OHBuilt 1968 · S/N 28-11210N9478LWeaver Iann · Polk, OHBuilt 1971 · S/N AA1A-0278N9478NChadwick Aviation Services LLC · Monroe, CTBuilt 1969 · S/N 28R-35196N9478WAmerican Aircraft Sales LLC · Lincolnshire, ILBuilt 1968 · S/N 28-11211N94790Kingsky Flight Academy LLC · Lakeland, FLS/N 15285788N9479DGrote Neal Scott · Harrison, NEBuilt 1959 · S/N 18-6822N9479TSouthern Colorado Flight Professionals LLC · Pueblo, COBuilt 1978 · S/N 38-78A0110N9479WSchacher Daniel E · Muleshoe, TXBuilt 1968 · S/N 28-11213N947AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13565N947ARPapoi Coral A · Sitka, AKBuilt 1972 · S/N 858-72N947CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281974N947KCPeterson Cassandra L · Poplar Grove, ILBuilt 2018 · S/N 1412-2018N947MRonneburger Brian · Northport, NYBuilt 1969 · S/N 30-1947N947RWWorkman Ron L · Lenoir City, TNBuilt 2010 · S/N 212264N947SFSnohomish Flying Service Inc · Snohomish, WABuilt 1983 · S/N 15285770N947TESkyway V LLC · Naples, FLBuilt 2003 · S/N 10226N947TTPucciariello Alexander A · Punta Gorda, FLBuilt 2000 · S/N 3947N947VATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13491N9480CDave Gross Inc · Midland, TXBuilt 1978 · S/N 28-7816480N9480DKent State University · Stow, OHBuilt 1985 · S/N 172RG1180N9480EMoyer Aviation Inc · Tobyhanna, PABuilt 1979 · S/N 17272277N9480HMoynihan Patrick J · Lakeville, MNBuilt 1975 · S/N 17266173N9480J217 Moriarty LLC · Stonewall, MSBuilt 1966 · S/N 28-3597N9480RWestern Montana Orthopaedic LLC · Missoula, MTS/N R18200708
Back to AD 81-18-04 R2