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.

N586MAWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1999 · S/N 2843297N586RHLugar Daniel A · St Helena Is, SCS/N 597RN586SRice James L · Mckinney, TXBuilt 1981 · S/N 17274646N586SBKareon Consulting LLC · Wilmington, DEBuilt 1966 · S/N 28-10781N586TSUniversity Of North Dakota · Grand Forks, NDBuilt 2021 · S/N 30076N587Plane Management LLC · Conroe, TXBuilt 1972 · S/N 649N5870PPaul Eric C · Grapevine, TXBuilt 1959 · S/N 24-953N5870QScott Stewart · Columbia, MOBuilt 1965 · S/N 3143N5870UWhite Thomas A · Roanoke, TXBuilt 1970 · S/N 28-26702N5871LSleeper James A · Middleburg, FLBuilt 1972 · S/N AA5-0071N5871NBraun Janet M · Pocono Pines, PABuilt 1978 · S/N 14416N5871PHammons John A · Maurice, LABuilt 1959 · S/N 24-954N5871QNeosho Investments LLC · Neosho, MOBuilt 1965 · S/N 800N5871ZJohnson Nathan P · Rapid City, SDBuilt 1963 · S/N 22-9729N5872LMai David A · Chattanooga, TNBuilt 1972 · S/N AA5-0072N5872NMeans Loren Alonzo III · Wasilla, AKBuilt 1978 · S/N 14417N5872QAir Mods And Repair Inc · Robbinsville, NJBuilt 1965 · S/N 3144N5872ZCollins James T · Blossvale, NYBuilt 1963 · S/N 22-9728N5873QSternhagen Richard A · Friendship, WIBuilt 1965 · S/N 801N5873WPropst David A · Exchange, WVS/N 28-2503N5873ZSchramm Thomas L · South Rockwood, MIBuilt 1963 · S/N 22-9731N5874DFeuerborn Ethan T · Boise, IDBuilt 1960 · S/N 187453N5874UFlying Wright Aviation LLC · Henderson, NVS/N 28-26707N5874ZGodbey Patrick · St Simons Island, GABuilt 1963 · S/N 22-9732N5875HPresten Eric A · Vineburg, CABuilt 1949 · S/N 16-493N5875UTews Jamie S · Greenville, WIBuilt 1970 · S/N 28-26708N5875VCrew Michael A · Phoenix, AZBuilt 1977 · S/N 28-7716209N5875ZReed John F · Bemus Point, NYBuilt 1963 · S/N 22-9733N5876DKirkendall James · N Richlnd Hls, TXBuilt 1956 · S/N 22-4557N5876LWilson James · Bagwell, TXS/N AA5-0276N5876U3shahs Aviation LLC · Temecula, CAS/N 28-26709N5876WKiss George C · Bangor, PAS/N 28-2552N5876ZDraper Scott · Rutland, VTBuilt 1963 · S/N 22-9736N5877FFeldvary John · Jackson, MIBuilt 1976 · S/N 28-7715155N5877LFlyboys Aviation LLC · Sioux City, IABuilt 1972 · S/N AA5-0077N5877NMeisner Shane · Fredericksburg, VABuilt 1978 · S/N 14422N5877QKenyon Alexandrea A · Costa Mesa, CABuilt 1965 · S/N 803N5877VWest Keith W · Slatington, PABuilt 1977 · S/N 28-7790505N5878ESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 17271949N5878GConner Norman V · Lakewood, WABuilt 2005 · S/N 70179N5878HDelaware Taildraggers LLC · Hancock, NYBuilt 1949 · S/N 16-495N5878LGomez Blanco Rafael · Lakewood, CABuilt 1972 · S/N AA5-0078N5878UAlbright Jasper N · Raleigh, NCBuilt 1970 · S/N 28-26710N5878WWorrell Wayne · Campbellsville, KYBuilt 1965 · S/N 28-2555N5878ZSallmon James H · Saratoga Springs, UTBuilt 2010 · S/N 001N5879HParlin Larrol L · Friday Harbor, WABuilt 1949 · S/N 16-497N5879LN5879l LLC · Lewes, DEBuilt 1972 · S/N AA5-0229N5879NBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 14424N5879UJacobs Levon Jr · Oak Hill, FLBuilt 1970 · S/N 28-26713N587AMPerry Monty R · Simi Valley, CABuilt 2022 · S/N 41966
Back to AD 81-18-04 R2