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.

N5834LFount Valley Flying Club LLC · Kidron, OHS/N AA5-0034N5834QGill Harold P · Bolton, MABuilt 1965 · S/N 3126N5834UNewburn William A Jr · Fresno, CABuilt 1969 · S/N 28-26665N5834WDowdy Joseph N · Blacksburg, VABuilt 1965 · S/N 28-2186N58359Warner Robert G Jr · Broomall, PABuilt 1979 · S/N 1290861N5835PLoya Francisco · Crestline, CAS/N 24-916N5835ZNiemela Blair K · Wasilla, AKBuilt 1963 · S/N 22-9688N58363Hartle Aaron Duane · Vicksburg, MIBuilt 1979 · S/N 690796N5836PShort Final LLC · Murfreesboro, TNBuilt 1959 · S/N 24-917N5836ZGaines Jesse B · Bryan, OHBuilt 1963 · S/N 22-9689N58371Bilton Aircraft Management Inc · Umatilla, FLBuilt 1979 · S/N 690794N5837LDudock John M Jr · Birch Run, MIBuilt 1972 · S/N AA5-0037N5837PGoodman Wayne A · Conway, SCBuilt 1959 · S/N 24-918N5837UDeblass Christopher C · Cranford, NJBuilt 1969 · S/N 28-26668N58384Sonnichsen Landen D · Delta Junction, AKS/N 990829N5838HPoliti Terris P · Lake Placid, NYFirst renewal noticeBuilt 1949 · S/N 16-457N5838LCox Andrew C · Scappoose, ORBuilt 1972 · S/N AA5-0038N5838MMuller Isaac Paul · Nampa, IDBuilt 2026 · S/N 5838N5838PHoughtling Marvin · Pasadena, TXBuilt 1959 · S/N 24-919N5838WJohn Andrew P · Auburn, MES/N 28-2207N58397Frost Darrell G · Atlanta, TXBuilt 1979 · S/N 1090833N5839HKinney Philip D · Audubon, MNBuilt 1949 · S/N 16-456N5839LHoyer Chase R · Jarrell, TXBuilt 1972 · S/N AA5-0039N5839PSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 24-920N5839QSnodgrass Michelle B · Sierra Vista, AZBuilt 1965 · S/N 785N5839RGiraud Stephen · Box Elder, SDBuilt 1995 · S/N 20042CN5839ZPhillips Michael K · Issaquah, WABuilt 1963 · S/N 22-9692N583CHuber James M · Melba, IDBuilt 1983 · S/N 583N583CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881132N583FLSotomayor Edwin · Lacey, WABuilt 1971 · S/N 28-7125438N583GWGentlemans Investments LLC · Camden, MEBuilt 1978 · S/N 14387N583MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2004 · S/N 40.399N583NDChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 4496253N583SVSouth County Aviation LLC · San Martin, CABuilt 2005 · S/N 372N584Wyatt James · Conyers, GABuilt 1977 · S/N 0021N5840HFarrell Tammy · Sterling, AKBuilt 1949 · S/N 16-458N5840UTall Timber Flying Service LLC · Kalispell, MTBuilt 1970 · S/N 28-26671N5841DLeopold Gary L · Winterset, IABuilt 1956 · S/N 22-4520N5841QGuziec Philip R · Riverwoods, ILS/N 786N5841WDestination Flyer LLC · Memphis, TNBuilt 1965 · S/N 28-2216N5842HUnivair Aircraft Corp · Aurora, COBuilt 1949 · S/N 16-460N5842LBerner Walter T III · Stamford, CTBuilt 1972 · S/N AA5-0042N5842NAero Florida LLC · Geneva, FLBuilt 1978 · S/N 14390N5842PFlyair Flight Academy LLC · Flint, TXBuilt 1959 · S/N 24-923N5842QBradford Michael · San Jose, CABuilt 1965 · S/N 3130N5842WFrakes Enterprises · Happy, TXBuilt 1965 · S/N 28-2221N5843HPerkins Jeffrey · Georgetown, TXBuilt 1949 · S/N 16-461N5843LMaschek Scott · Harker Heights, TXBuilt 1972 · S/N AA5-0043N5843QKeane Christopher · Salem, NHBuilt 1965 · S/N 787N5843UOnyx Aviation LLC · North Fort Myers, FLS/N 28-26674
Back to AD 81-18-04 R2