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.

N5851UFoothill Aircraft Sales & Service Inc · Upland, CABuilt 1969 · S/N 28-26683N5851VMcconnell Thomas E · Grass Valley, CABuilt 1977 · S/N 28-7715273N5851WCameron Hugh R · Gainesboro, TNBuilt 1965 · S/N 28-2308N5851ZBurklund Joel H · Minneapolis, MNBuilt 1963 · S/N 22-9706N5852HKelley Don Lee · Loon Lake, WABuilt 1949 · S/N 16-462N5852LOhser David G · Hudson, FLBuilt 1972 · S/N AA5-0052N5852QOldham Jared K · Richfield, WIBuilt 1965 · S/N 3135N5852WFerguson Carl R · Waupaca, WIBuilt 1965 · S/N 28-2312N5852ZTuttle James R · Cherryvale, KSS/N 22-9708N5853DHapka Leon J · Halma, MNBuilt 1956 · S/N 22-4532N5853LKennedy Samuel E · Watsonville, CABuilt 1972 · S/N AA5-0053N5853PLewellen Walter G · Moreno Valley, CABuilt 1959 · S/N 24-935N5853UPost Jay M · Greenfield, OHBuilt 1970 · S/N 28-26685N5854DPro West Air LLC · West Point, UTS/N 22-4533N5854LVolpe Brandon M · Baton Rouge, LABuilt 1972 · S/N AA5-0254N5854NShort Brian D · Rock Island, ILBuilt 1978 · S/N 14399N5854UMagic Valley Aero Club Inc · Twin Falls, IDBuilt 1970 · S/N 28-26686N5854WAtluas LLC · Dallas, TXBuilt 1965 · S/N 28-2333N5855DMiller Justin · Boaz, ALBuilt 1956 · S/N 22-4534N5855HNortheast Cub LLC · Hudson, NYS/N 16-473N5855LSchauf Cindy R · Colwich, KSBuilt 1972 · S/N AA5-0055N5855WZachry David · West Point, GABuilt 1965 · S/N 28-2358N5856DStephen George · Land O Lakes, WIBuilt 1956 · S/N 22-4535N5856HWaco West Inc · Dover, DEFirst renewal noticeBuilt 1949 · S/N 16-474N5856LOrland Flying Service Inc · Bunnell, FLBuilt 1972 · S/N AA5-0056N5856PDemontalvo Aaron M · Mansfield, TXBuilt 1959 · S/N 24-938N5856QDison Timothy A · Nolensville, TNS/N 3137N5856WSergeant Mary E · Harvard, ILBuilt 1965 · S/N 28-2361N5856ZHankins Jon A · Fort Mohave, AZBuilt 1963 · S/N 22-9712N5857LHill James III · Gainesville, FLBuilt 1972 · S/N AA5-0057N5857VHague Parkerson B · Virginia Beach, VAS/N 28-7716207N5858HKoch Michael R · Nemo, SDBuilt 1949 · S/N 16-478N5858WPaulisin George W · Crossville, TNBuilt 1965 · S/N 28-2368N5859NPegasus Flight LLC · Carbondale, ILS/N 14404N5859PSnider Scott E · Turner, MTBuilt 1959 · S/N 24-941N5859QHill Larry J · Idaho Falls, IDBuilt 1965 · S/N 795N5859VHaney Paul · Navarre, FLBuilt 1977 · S/N 28-7790504N5859ZInternational Air Services Inc Trustee · Carson City, NVBuilt 1963 · S/N 22-9716N585AMPj Aviation LLC · Richmond Hill, GABuilt 2005 · S/N 18281585N585AWChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 2843934N585CAThomas-Guy Ltd · Newtown, PABuilt 1993 · S/N 14586N585CBBlack Christopher · Williamson, NYS/N 819RN585CCUsda-Aphis-Ws · Cedar City, UTBuilt 2011 · S/N CC180049N585CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282168N585DEHouston Fire Aviators LLC · Houston, TXBuilt 1968 · S/N 28-4660N585GEWayne Mogg Inc · Parker, AZFirst renewal noticeBuilt 2018 · S/N 2881009N585LJWaldal Art B · Battle Ground, WABuilt 1999 · S/N 24852N585MAPadawan Labs LLC · Portland, ORBuilt 2005 · S/N 992-2005N585MRCooper Marcus F III · Locust Grove, GABuilt 2006 · S/N 40286N585NYPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954012
Back to AD 81-18-04 R2