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.

N6751JJones James L · White Hall, ARBuilt 1968 · S/N 28-24470N6751NParr Matthew R · Wellsville, PABuilt 1968 · S/N 680065N6751PGette Jason D · Kindred, NDS/N 24-1880N6751VManley William T Jr · Lakeside, TXS/N 700051N67527H & H Aviation Enterprises LLC · Fairfield, OHBuilt 1978 · S/N 15281892N6752JHutchins James R · Columbia, SCBuilt 1968 · S/N 28-24474N6752ULucarelli Michael · Surprise, AZBuilt 1963 · S/N 2474N6752ZVector USA LLC · Olive Branch, MSBuilt 1981 · S/N ME-340N67535Afana Lawrence L · Laughlin, NVBuilt 1978 · S/N 15281897N6753BThorpe Brandon · Bremerton, WABuilt 1956 · S/N 22-4087N6753JSpieth John W · Ann Arbor, MIBuilt 1968 · S/N 28-24475N6753NHarmon Benjamin P · Olive Branch, MSBuilt 1968 · S/N 680067N6753PScanlon Shawn M · Evans, GABuilt 1960 · S/N 24-1882N6753VDegraffenreid Donald R · Fort Mohave, AZBuilt 1970 · S/N 700052N67541Lane Community College · Eugene, ORBuilt 1978 · S/N 15281902N67542Haag Neil E · Elgin, SCBuilt 1980 · S/N WA-101N67549Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1978 · S/N 15281907N6754NCasady David E · Harriman, TNBuilt 1968 · S/N 680068N6754VTharp Kenneth Lynn · Apple Valley, CABuilt 1970 · S/N 700054N6754WBell Christopher K · Reynoldsburg, OHBuilt 1980 · S/N WA-99N67557Sunstate Aviation Inc · Kissimmee, FLBuilt 1978 · S/N 15281910N6755BTwotards Aviation LLC · Moses Lake, WABuilt 1956 · S/N 22-4089N6755JBon Investment Holdings LLC · Zephyrhills, FLBuilt 1968 · S/N 28-24478N6755PHensler Carl P · Watsonville, CABuilt 1960 · S/N 24-1884N6755WAeroqualite Maintenance · Cumberland, WIBuilt 1965 · S/N 28-20879N67563Canarr Nellie N E · Anchorage, AKS/N 15281913N67567Pinger Kevin R · Palo Alto, CAS/N 15281916N6756BNortheast State Community College · Blountville, TNBuilt 1980 · S/N M-2276N6756JAmv Aviation LLC · Miami, FLBuilt 1968 · S/N 28-24479N6756UBergland John E · Santa Monica, CABuilt 1963 · S/N 2478N6756VFelicione Frank S Jr · Idaho Falls, IDFirst renewal noticeBuilt 1970 · S/N 700055N6756WTrollinger Lari D · Wanette, OKBuilt 1965 · S/N 28-20880N6756ZKoenig Donald J · Las Animas, COBuilt 1963 · S/N 25-2376N6757Mattheis Mark E · Fort Wayne, INBuilt 1973 · S/N 174N67573Fixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1978 · S/N 15281921N6757BStuart Lee L · Smithville, ARBuilt 1956 · S/N 22-4091N6757NCoody John A · Idaho Falls, IDBuilt 1968 · S/N 680071N6757UScherger Mark A · Herndon, VABuilt 1963 · S/N 2479N6757XCall One Inc · Clarinda, IABuilt 1980 · S/N WA-118N67582Jackson William Gary · Clinton, MDBuilt 1978 · S/N 15281928N6758HGorge Winds Aviation Inc · Fairview, ORBuilt 1975 · S/N 17265570N6758JBroach William S · Forest Hill, MDBuilt 1968 · S/N 28-24828N6758NZwerko Kevin C · South Plainfield, NJBuilt 1968 · S/N 680072N6758PRoss David T · El Dorado Hills, CABuilt 1960 · S/N 24-1887N6758UN6758u LLC · Linden, MIBuilt 1963 · S/N 2480N67591Owen David A · Saint George, UTS/N 15281932N6759BDean Richard L · Ridgeland, SCBuilt 1956 · S/N 22-4094N6759UHodgson Michael D · Saint Francis, WIBuilt 1963 · S/N 2481N6759WMakeev Alexandre · Concord, CABuilt 1965 · S/N 28-20884N675CPCalifornia Polytechnic State University · San Luis Obispo, CABuilt 2008 · S/N 71243
Back to AD 81-18-04 R2